da.UpdateCommand = new SqlCommand("UPDATE tblNUMBERS_1 SET FirstNum = @FirstNum, SecondNum = @SecondNum, ThirdNum = @ThirdNum, FourthNum = @FourthNum, FifthNum = @FifthNum WHERE Date = @Date", cs); da.UpdateCommand.Parameters.Add("@FirstNum", SqlDbType.Int).Value = int.Parse(txtFirstNum.Text); da.UpdateCommand.Parameters.Add("@SecondNum", SqlDbType.Int).Value = int.Parse(txtSecondNum.Text); da.UpdateCommand.Parameters.Add("@ThirdNum", SqlDbType.Int).Value = int.Parse(txtThirdNum.Text); da.UpdateCommand.Parameters.Add("@FourthNum", SqlDbType.Int).Value = int.Parse(txtFourthNum.Text); da.UpdateCommand.Parameters.Add("@FifthNum", SqlDbType.Int).Value = int.Parse(txtFifthNum.Text); da.UpdateCommand.Parameters.Add("@Date", SqlDbType.DateTime).Value = ds.Tables[0].Rows[tblNUMBERSBS_1.Position][5]; cs.Open(); x = da.UpdateCommand.ExecuteNonQuery(); cs.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)