Increment quantity if have value from textbox in datagrid c#

Some little help.

Need if exist in datagrid value from textbox1 ( column name: bar_code) to increment cell kolicina(quantity eng.) + 1

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();
var itemAndPrice = textBox1.Text;
if (reader.Read())
{
var index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells["redni_broj"].Value = index + 1;
dataGridView1.Rows[index].Cells["bar_kod"].Value = reader["bar_kod"].ToString();
dataGridView1.Rows[index].Cells["naziv_artikla"].Value = reader["ime"].ToString();
dataGridView1.Rows[index].Cells["cijena"].Value = reader["cijena_sa_porezom"].ToString();
dataGridView1.Rows[index].Cells["kolicina"].Value = "1";
foreach (DataGridViewRow g1 in dataGridView1.Rows)
{
g1.Cells["ukupno"].Value = (Convert.ToDouble(g1.Cells["kolicina"].Value) * Convert.ToDouble(g1.Cells["cijena"].Value)).ToString("0.00");
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}
}
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 = "";
}
}

if (g1.Cells["bar_kod"].Value.toString() == textBox1.Text.ToString())
{
//if (g1.Cells["bar_kod"].Value == "your compare value")
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}

This is my code not answer

Laxmidhar Sahoo

482
3.2k
4.3k

Nov 21 2018 9:52 PM

Break point

Warning display result

Severity Code Description Project File Line Suppression State
Warning CS0252 Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'

the code in the loop place in try catch block .Give abreak point and display the line

Laxmidhar Sahoo

I try this but not work

Error is

warning CS0252: Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'

foreach (DataGridViewRow g1 in dataGridView1.Rows)
{
g1.Cells["ukupno"].Value = (Convert.ToDouble(g1.Cells["kolicina"].Value) * Convert.ToDouble(g1.Cells["cijena"].Value)).ToString("0.00");
if (g1.Cells["bar_kod"].Value == textBox1.Text.ToString())
{
//if (g1.Cells["bar_kod"].Value == "your compare value")
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}
}

foreach (DataGridViewRow g1 in dataGridView1.Rows)
{
g1.Cells["ukupno"].Value = (Convert.ToDouble(g1.Cells["kolicina"].Value) * Convert.ToDouble(g1.Cells["cijena"].Value)).ToString("0.00");
if(g1.Cells["bar_kod"].Value == "your compare value")
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}

Some little help.

Need if exist in datagrid value from textbox1 ( column name: bar_code) to increment cell kolicina(quantity eng.) + 1

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();
var itemAndPrice = textBox1.Text;
if (reader.Read())
{
var index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells["redni_broj"].Value = index + 1;
dataGridView1.Rows[index].Cells["bar_kod"].Value = reader["bar_kod"].ToString();
dataGridView1.Rows[index].Cells["naziv_artikla"].Value = reader["ime"].ToString();
dataGridView1.Rows[index].Cells["cijena"].Value = reader["cijena_sa_porezom"].ToString();
dataGridView1.Rows[index].Cells["kolicina"].Value = "1";
foreach (DataGridViewRow g1 in dataGridView1.Rows)
{
g1.Cells["ukupno"].Value = (Convert.ToDouble(g1.Cells["kolicina"].Value) * Convert.ToDouble(g1.Cells["cijena"].Value)).ToString("0.00");
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}
}
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 = "";
}
}

if (g1.Cells["bar_kod"].Value.toString() == textBox1.Text.ToString())
{
//if (g1.Cells["bar_kod"].Value == "your compare value")
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}

This is my code not answer

Laxmidhar Sahoo

482
3.2k
4.3k

Nov 21 2018 9:52 PM

Break point

Warning display result

Severity Code Description Project File Line Suppression State
Warning CS0252 Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'

the code in the loop place in try catch block .Give abreak point and display the line

Laxmidhar Sahoo

I try this but not work

Error is

warning CS0252: Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'

foreach (DataGridViewRow g1 in dataGridView1.Rows)
{
g1.Cells["ukupno"].Value = (Convert.ToDouble(g1.Cells["kolicina"].Value) * Convert.ToDouble(g1.Cells["cijena"].Value)).ToString("0.00");
if (g1.Cells["bar_kod"].Value == textBox1.Text.ToString())
{
//if (g1.Cells["bar_kod"].Value == "your compare value")
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}
}

foreach (DataGridViewRow g1 in dataGridView1.Rows)
{
g1.Cells["ukupno"].Value = (Convert.ToDouble(g1.Cells["kolicina"].Value) * Convert.ToDouble(g1.Cells["cijena"].Value)).ToString("0.00");
if(g1.Cells["bar_kod"].Value == "your compare value")
g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
}

Yes, It will add based on the rows count of the datagridview1 rows.

If it has 2 rows it'll add 2 & like that.

There is a textbox In your statement of if exist in datagrid value from textbox1 ( column name: bar_code) to increment cell

Laxmidhar Sahoo

I dont have textbox for this value.

I post picture

Please put debugger and check what value you are getting for the expression "Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;" by using quick watch & Let us know here too.So that we can try on that way.

because your code seems everything was right.

Thank you.

Your code is looking good .But in the foreach loop you may apply a if condition for checking the textbox value with g1.Cells["bar_kod"].Value

12 Replies

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

Laxmidhar Sahoo7y ago
Accepted answer
1. if (g1.Cells["bar_kod"].Value.toString() == textBox1.Text.ToString())
2. {
3. //if (g1.Cells["bar_kod"].Value == "your compare value")
5. g1.Cells["kolicina"].Value = Convert.ToInt32(g1.Cells["kolicina"].Value) + 1;
6. }