Doesnt obey to update?

Israel

Hi!

I have a little bit confusion. I need to update at the same time at diferente database. The condition is when the code is egal on what that "combobox" then update. Curiosly its doenst obey... Means that even I choose any another code its still update. That is wrong!

Its should update ONLY when the code is the same as I choose (or write) into the combobox:

private void button4_Click(object sender, EventArgs e)

{

conn.Open();

OleDbParameter jan = new OleDbParameter("@january", SqlDbType.VarChar);

OleDbParameter cod = new OleDbParameter("@cod", SqlDbType.VarChar);

comm.Parameters.Add(jan);

comm.Parameters.Add(cod);

jan.Value = "PAYED";

cod.Value = cbxCod.Text;

comm.Connection = conn;

comm.CommandText = "UPDATE bill SET january = ? WHERE codcliente = @cod";

comm.ExecuteNonQuery();

//{

// conn.Close();

//}

/////////////////////////////////////////

OleDbParameter janregist = new OleDbParameter("@jan", SqlDbType.VarChar);

OleDbParameter codclienteregist = new OleDbParameter("@codcliente", SqlDbType.VarChar);

comm.Parameters.Add(janregist);

comm.Parameters.Add(codclienteregist);

janregist.Value = "PAYED";

codclienteregist.Value = cbxCod.Text;

comm.Connection = conn;

comm.CommandText = "UPDATE registration SET jan = ? WHERE codcliente = @codcliente";

comm.ExecuteNonQuery();

{

conn.Close();

}

2 Replies

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

Israel11y ago
hi!

It's winform for VS 2010.
All these codes are inside of a button (not in a event that all) .
The "update" should have a unique reference it's the combobox "cbxCod". It's not complicated. The only way it's to allow updating once for each database separatly (it's clear in my codes).
Let's me clarify it again:
private void button4_Click(object sender, EventArgs e)
{
//for the database "bill"

conn.Open();
OleDbParameter jan = new OleDbParameter("@january", SqlDbType.VarChar);
OleDbParameter cod = new OleDbParameter("@cod", SqlDbType.VarChar);
comm.Parameters.Add(jan);
comm.Parameters.Add(cod);
jan.Value = "PAYED";
cod.Value = cbxCod.Text;
comm.Connection = conn;
comm.CommandText = "UPDATE bill SET jan = ? WHERE codcliente = @cod";
comm.ExecuteNonQuery();
//{
// conn.Close();
//}

//for the database "registration"

OleDbParameter janregist = new OleDbParameter("@jan", SqlDbType.VarChar);
OleDbParameter codclienteregist = new OleDbParameter("@codcliente", SqlDbType.VarChar);
comm.Parameters.Add(janregist);
comm.Parameters.Add(codclienteregist);
janregist.Value = "PAYED";
codclienteregist.Value = cbxCod.Text;
comm.Connection = conn;
comm.CommandText = "UPDATE registration SET jan = ? WHERE codcliente = @cod";
comm.ExecuteNonQuery();
{
conn.Close();
}

0
Amit Choudhary11y ago
Looks like an event handler but which application you're working on Winforms/WPF/Asp.net Forms? Also looks like you want to use the combobox but the the event is for button click.
0