SQ: Update command ReWrites my whole table with repeate data?

[EDN Admin]

Hey guys...super big issue here.
I have 17 rows... each row has an ID bla bla bla ok?
now when i try to update one of thoes rows, and use the code below, it replaces my whole table with the same record, help?
please reveiw my code... thanks,
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; private <span style="color:Blue; void btnEditAsset_Click(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Blue; string contactName = tbContactName.Text;
<span style="color:Blue; string ContactNumber = tbContactPhone.Text;
<span style="color:Blue; string contactRole = tbcontactRole.Text;
<span style="color:Blue; string contactEmail = tbContactEmail.Text;
<span style="color:Blue; string Region = <span style="color:#A31515; "CANLA";
<span style="color:Blue; string Address = <span style="color:#A31515; "NULL";

<span style="color:Blue; string IsActive = <span style="color:#A31515; "1";

SqlConnection cs = <span style="color:Blue; new SqlConnection(<span style="color:#A31515; @"server=MyServer");
SqlDataAdapter da = <span style="color:Blue; new SqlDataAdapter();
da.UpdateCommand = <span style="color:Blue; new SqlCommand
(<span style="color:#A31515; "UPDATE dbo.Vendor SET Name = @Name, IsActive = @IsActive, Region= @Region, Address= @Address, Contact1Name= @Contact1Name, Contact1Role= @Contact1Role, Contact1Tel= @Contact1Tel, Contact1Email= @Contact1Email, Contact2Name= @Contact2Name, Contact2Role = @Contact2Role, Contact2Tel= @Contact2Tel, Contact2Email = @Contact2Email, Contact3Name =@Contact3Name, Contact3Role= @Contact3Role, Contact3Tel =@Contact3Tel, Contact3Email = @Contact3Email", cs);
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Name", SqlDbType.VarChar).Value = cbCarrer.Text.ToString();
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@IsActive", SqlDbType.Bit).Value = Convert.ToInt32(IsActive);
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Region", SqlDbType.NVarChar).Value = Region;
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Address", SqlDbType.NVarChar).Value = Address;
<span style="color:Green; //Contact1 Info
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact1Name", SqlDbType.NVarChar).Value = contactName;
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact1Role", SqlDbType.NVarChar).Value = contactRole;
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact1Tel", SqlDbType.NVarChar).Value = ContactNumber;
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact1Email", SqlDbType.NVarChar).Value = contactEmail;
<span style="color:Green; //Contact2 Info
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact2Name", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact2Role", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact2Tel", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact2Email", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
<span style="color:Green; //Contact3 Info
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact3Name", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact3Role", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact3Tel", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
da.UpdateCommand.Parameters.Add(<span style="color:#A31515; "@Contact3Email", SqlDbType.NVarChar).Value = <span style="color:#A31515; "";
cs.Open();
da.UpdateCommand.ExecuteNonQuery();
<span style="color:Green; //cs.Dispose();
cs.Close();



}
[/code]
Any ideas where im messing up here? can i add like an Update where ID= string or something?
Thanks in advance!! <hr class="sig Loving life since 1981 Preston Lambeth

View the full article