Add row in datagrid after select from SQL C#

Question

Add row in datagrid after select from sql query

First time when select is empty row, second is full row

Some help please

Need when select from db value to insert in datagrid

Query is ok

Problem is from line 22 to line 33

private void prijavaAction()
{
int sno = dataGridView1.Rows.Count + 1;
SqlConnection con = new SqlConnection(cs);
if (textBox1.Text.All(char.IsDigit))
{
string queryString = "select bar_kod, ime, cijena_sa_porezom from roba_usluge WHERE bar_kod = '" + textBox1.Text + "'";// pronaci artikl u bazi
using (SqlConnection connection = new SqlConnection(cs))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
for (int i = 1; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells["redni_broj"].Value = i;
dataGridView1.Rows[i].Cells["bar_kod"].Value = reader["bar_kod"].ToString();
dataGridView1.Rows[i].Cells["naziv_artikla"].Value = reader["ime"].ToString();
dataGridView1.Rows[i].Cells["cijena"].Value = reader["cijena_sa_porezom"].ToString();
}
// dataGridView1.Rows.Add(sno, nazivartikla, 1, cijena, cijena);
dataGridView1.Rows.Add();
reader.Close();
}
else
{
MessageBox.Show("Bar kod ne postoji u bazi!", "Obavještenje", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox1.Text = "";
}
}
}
else
{
MessageBox.Show("Bar kod ne postoji ili nije bar kod!", "Obavještenje", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox1.Text = "";
}
}

Rafnas T P · Answer

hi, remove for loop as shown below if (reader.Read()) { var index = dataGridView1.Rows.Add(); dataGridView1.Rows[index].Cells[ "redni_broj" ].Value = index ; dataGridView1.Rows[index].Cells[ "bar_kod" ].Value = reader[ "bar_kod" ].ToString(); dataGridView1.Rows[index].Cells[ "naziv_artikla" ].Value = reader[ "naziv_artikla"].ToString() ; dataGridView1.Rows[index].Cells[ "cijena" ].Value = reader[ "cijena"].ToString() ; reader.Close(); } else { MessageBox.Show( "Bar kod ne postoji u bazi!" , "Obavještenje" , MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Text = "" ; }

Goran Bibic · Answer

I try this but not work if (reader.Read()) { for ( int i = 1; i { var index = dataGridView1.Rows.Add(); dataGridView1.Rows[index].Cells[ "redni_broj" ].Value = i; dataGridView1.Rows[index].Cells[ "bar_kod" ].Value = "bar_kod" ; dataGridView1.Rows[index].Cells[ "naziv_artikla" ].Value = "naziv_artikla" ; dataGridView1.Rows[index].Cells[ "cijena" ].Value = "cijena" ; } dataGridView1.Rows.Add(); reader.Close(); } else { MessageBox.Show( "Bar kod ne postoji u bazi!" , "Obavještenje" , MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Text = "" ; }

Dhammapal Kamble · Answer

var index = dgv.Rows.Add(); dgv.Rows[index].Cells["Column1"].Value = "Column1"; dgv.Rows[index].Cells["Column2"].Value = 5.6;