PASSING PARAMETERS BACK USING C#

Question

I'm saving data to database with save button. how do i re-enter another users info the that info is saved/ SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand(RICI_PersonalInfo_SavePage_Test MyConnection2); da.InsertCommand.CommandType = CommandType.StoredProcedure; da.InsertCommand.Parameters.AddWithValue(@SSN txtSSN.Text); da.InsertCommand.Parameters.AddWithValue(@FileDate txtFileDate.Text); da.InsertCommand.Parameters.AddWithValue(@SequenceIDSqlDbType.Char).Value = txtSequenceID.Text; da.InsertCommand.Parameters.Add(@Name SqlDbType.VarChar).Value = Session[Name].ToString(); da.InsertCommand.Parameters.Add(@BirthDateSqlDbType.VarChar).Value = txtBxDOB.Text; da.InsertCommand.Parameters.Add(@Gender SqlDbType.VarChar).Value = RadioButtonListGender.Text; da.InsertCommand.Parameters.Add(@Citizen SqlDbType.VarChar).Value = RadioButtonListCitizen.Text;

Vincent Maverick Durano · Answer

I'm not quite sure if I follow. Do you want to update a record from database? If so then you can simply create an Update query and pass the user ID as the parameter to your query. For example: using(SqlConnection conn = new SqlConnection(YOUR CONNECTION STRING)){ string sql = UPDATE TableName SET ColumnName1 = @Value1 WHERE ID = @ID; conn.Open(); using(SqlCommand cmd = new SqlCommand(sql conn)){ cmd.Parameters.AddWithValue(@ID PassTheIDValueHere); cmd.Parameters.AddWithValue(@Value1 SomeValueToUpdate); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } }