Find max value in column and icrease for 1...

Goran Bibic

Why update complete column...not just active cell

SqlDataReader rdr;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select max(brojprijavnice2) from dbo.prijava_radnika WHERE radnik = '" + readerresultTextbox.Text + "'";
cmd.Connection = con;
con.Open();
rdr = cmd.ExecuteReader();
int max = 0;
while (rdr.Read())
{
max = Convert.ToInt32(rdr[0].ToString());
Console.WriteLine(max);
}
con.Close();
String updateStaff = "UPDATE [dbo].[prijava_radnika] SET [vrijemeodjave] = @vrijemeodjave, brojprijavnice2 = " + (max + 1) + ", [status] = 'odjavljen' WHERE radnik = '" + readerresultTextbox.Text + "'";

4 Replies

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

Piyush Pansuriya8y ago
Hi,
You have to put uniqe id in where condition.

Your readerresultTextbox.Text value is repeated in table column. So, put any uniqe value in where condition which will not repeat in perticular table.
Goran Bibic8y ago
to add and id=what?
String updateStaff = "UPDATE [dbo].[prijava_radnika] SET [vrijemeodjave] = @vrijemeodjave, brojprijavnice2 = " + (max + 1) + ", [status] = 'odjavljen' WHERE radnik = '" + readerresultTextbox.Text + "'";
Goran Bibic8y ago
Have...id
Piyush Pansuriya8y ago
Hi,
You are updating every rows where radnik= readerresultTextbox.Text.

You have to put unique id in where condition.
Is there any unique identity column in your table?