How to fill datagridview row by row in c# using barcode

Naeem Khan

Hi,

I have a windows application developed in c#.
I have datagridview with three columns in it.
I will be scanning barcode in the text box.After scanning a particular barcode, i need to query the database and fill the barcodes info in the datagridview columns of the current row.
Like wise after scanning each barcode i need to fill the particular row like above.

i used this kind of code but its not working ..

try
{
MySqlConnection con = new MySqlConnection(StartUp.database);
con.Open();
MySqlCommand cmd = new MySqlCommand("select Accession_no,Title_in_full from t_book_details where Accession_no ='" + txt_accession_no.Text + "'", con);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
gv_show_details.Rows[0].Cells[0].Value = dr[0].ToString();
gv_show_details.Rows[0].Cells[1].Value = dr[1].ToString();
gv_show_details.Rows.Add(dr);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

please give me idea where i m doing mistakes..

thanks in advance

4 Replies

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

Naeem Khan11y ago
thank u sir,

and let me know how to validate for same Accession number and blank record..
0
Ravi Kumar11y ago
HI
Try the fallowing code
declare variable i outside that event.
int i=0;
try
{
MySqlConnection con = new MySqlConnection(StartUp.database);
con.Open();
MySqlCommand cmd = new MySqlCommand("select Accession_no,Title_in_full from t_book_details where Accession_no ='" + txt_accession_no.Text + "'", con);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
gv_show_details.Rows.Add();
gv_show_details.Rows[i].Cells[0].Value = dr[0].ToString();
gv_show_details.Rows[i].Cells[1].Value = dr[1].ToString();
i++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
0
Naeem Khan11y ago
thanks for the reply sir,

but i want to add rows by one by one.. when i m inserting second accesssion number it is clearing previous entry and second thing if same accession number is exists then it should be say error and blank row can't be inserted ..

reply me ASAP..
0
Ravi Kumar11y ago
HI
Try the fallowing code
try
{
MySqlConnection con = new MySqlConnection(StartUp.database);
con.Open();
MySqlCommand cmd = new MySqlCommand("select Accession_no,Title_in_full from t_book_details where Accession_no ='" + txt_accession_no.Text + "'", con);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
gv_show_details.Rows.Add();
gv_show_details.Rows[0].Cells[0].Value = dr[0].ToString();
gv_show_details.Rows[0].Cells[1].Value = dr[1].ToString();

}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
0