public void InsertNewUser(PropertyService P) { cmd = new SqlCommand("InsertNewUser", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Fname", P.FirstName); cmd.Parameters.AddWithValue("@Lname", P.LastName); con.Open(); cmd.ExecuteNonQuery();//To Save Changes into Table. & to findout Number of affected by Query con.Close(); }
public void UpdateUser(PropertyService P) { cmd = new SqlCommand("UpdateUser", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UID", P.UserID); cmd.Parameters.AddWithValue("@Fname", P.FirstName); cmd.Parameters.AddWithValue("@Lname", P.LastName); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }