trying to read code from my textbox... Doesnt

Israel

Hi!

I wrote these to try to read the data that appear on the textbox when the barcode reader is pointed on a barcode book for example. But its doesnt. Anyone can explain please.

private void codigoBarraConsStocks_KeyPress(object sender, KeyPressEventArgs e)

{
string connectionString = @"Data Source=localhost\sqlexpress;Initial Catalog=master;Integrated Security=True";

SqlConnection sqlCon = new SqlConnection(connectionString);

sqlCon.Open();

string commandString = "select * from consultoria where codigobarra ='" + codigoBarraConsStocks.Text + "'";

SqlCommand sqlCmd = new SqlCommand(commandString, sqlCon);

SqlDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

codigoBarraStocks.Text = read["codigobarra"].ToString(); // it will show the code

produtoStocks.Text = read["produto"].ToString(); // it will show the code

precoStocks.Text = read["preco"].ToString(); // it will show the code

nStocksStocks.Text = read["n_stocks"].ToString(); // it will show the code

}

else

{

MessageBox.Show("A record with a code of " + codigoBarraConsStocks.Text + " was not found");

}

read.Close();

sqlCon.Close();

}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Israel12y ago
Its doesnt show any error message.
I do try it. But its read just the first number of the barcode (9789804714405)
0
Wim Sturkenboom12y ago
OK,

put a breakpoint on the first line of your method

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\office.mdb;Persist Security Info=False";

To do so, place the text cursor in the line and press (that is, the F9 function key); you will get a red dot at the left. Run your code, scan the barcode and see if the program stops on the breakpoint. If not, the TextChanged event is not triggered when you scan the barcode.

Alternatively, you can add the following lines just before the the above line; they will show the values that the program sees.

private void textBox1_TextChanged(object sender, EventArgs e)
{
    TextBox tb = (TextBox)sender;
    string txt1 = tb.Text;
    string txt2 = textBox1.Text;

    MessageBox.Show(String.Format("txt1: {0}\r\ntxt2: {1}", txt1, txt2), "TextBox1 content");

// rest of your code

Does this new messagebox show? If not, the TextChanged event is not triggered. If it shows,
what are the values that it displays for txt1 and txt2?

I unfortunately don't have a barcode reader so can only simulate using copy and paste.
0
Israel12y ago
ok, I see. Sorry!

When I focus on a barcode that's on the product. Its not happear in the textbox1. After focusing on the barcode its show ONLY zero (0) in the textbox1 without filtering the product to show on the textbox2.
In final, its doesnt show any error. That why I didnt talk about the error.

My code:

private void textBox1_TextChanged(object sender, EventArgs e)
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from barcode where code ='" + textBox1.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)
{
while (read.Read())
{
textBox2.Text = read["product"].ToString(); // it will show the code

}
}
else
{
MessageBox.Show("A record with a code of " + textBox1.Text + " was not found");
}

read.Close();
sqlCon.Close();
}
0
Wim Sturkenboom12y ago
[quote]
Secondly inside of textbox on textchanged event. Its doesnt.
[/quote]
Please be more specific; it doesn't work means nothing. Do you get errors when running the code? Is the textchanged event triggered (put a breakpoint in it) when you scan? If so, what is the value of the textBox.text (not the visual one in the UI, but in code behind); does it reflect whatever you scanned or is it corrupted?

0
Israel12y ago
Please see I want to try but its doesnt works:

Firstly when I try inside of button. Its works!:

private void button1_Click(object sender, EventArgs e)
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from barcode where code ='" + textBox1.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)
{
while (read.Read())
{
textBox2.Text = read["product"].ToString();
}
}
else
{
MessageBox.Show("A record with a code of " + textBox1.Text + " was not found");
}

read.Close();
sqlCon.Close();
}

Secondly inside of textbox on textchanged event. Its doesnt. Why? See my code please:

private void textBox1_TextChanged(object sender, EventArgs e)
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from barcode where code ='" + textBox1.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)
{
while (read.Read())
{
textBox2.Text = read["product"].ToString();
}
}
else
{
MessageBox.Show("A record with a code of " + textBox1.Text + " was not found");
}

read.Close();
sqlCon.Close();
}

What happen. Need your support please. Thanx!

0
Anupam Singh12y ago
Try to use OnTextChanged event instead of KeyPress and also note you will have to enable autopostback for the same.
0
Nitesh Kejriwal12y ago
I believe you want to get the data from database based on barcode input. For this, you should try TextChanged event or Leave event as when input is done via barcode reader, Keypress event is not fired.
0