Add row in datagrid after select from SQL C#

Goran Bibic

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 = "";
}
}

3 Replies

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

Rafnas T P7y ago
Accepted 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 Bibic7y ago
I try this but not work
if (reader.Read())

                       {
                           for (int i = 1; i < dataGridView1.Rows.Count; 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 Kamble7y ago
var index = dgv.Rows.Add();
dgv.Rows[index].Cells["Column1"].Value = "Column1";
dgv.Rows[index].Cells["Column2"].Value = 5.6;