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

Question

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_noTitle_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

Naeem Khan · Answer

thank u sir and let me know how to validate for same Accession number and blank record..

Ravi Kumar · Answer

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_noTitle_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); }

Naeem Khan · Answer

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..

Ravi Kumar · Answer

HI Try the fallowing code try { MySqlConnection con = new MySqlConnection(StartUp.database); con.Open(); MySqlCommand cmd = new MySqlCommand(select Accession_noTitle_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); }