من کد پروسیجر و C# رو برات قرار میدم امید وارم بدردت بخوره .
ALTER PROCEDURE [dbo].[PhoneBook_Update]
@Id INT,
@Name nvarchar(20),
@Fname nvarchar(20),
@PhoneNumber int,
@CellphoneNumber varchar(20),
@OfficeNumber varchar(10),
@OtherNumber varchar(10)
AS
BEGIN
UPDATE PhoneBook_table
SET
Name=@Name ,
Fname=@Fname ,
PhoneNumber=@PhoneNumber ,
CellphoneNumber=@CellphoneNumber ,
OfficeNumber=@OfficeNumber,
OtherNumber=@OtherNumber
WHERE Id=@Id
END
SqlCommand command = new SqlCommand("PhoneBook_Update", connString);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = TxtName.Text.Trim();
command.Parameters.Add("@Fname", SqlDbType.NVarChar).Value = TxtFamily.Text.Trim();
command.Parameters.Add("@PhoneNumber", SqlDbType.int).Value = TxtPhoneNumber.Text.Trim();
command.Parameters.Add("@CellphoneNumber", SqlDbType.VarChar).Value = TxtCellphoneNumber.Text.Trim();
command.Parameters.Add("@OfficeNumber", SqlDbType.VarChar).Value = txtOfficeNumber.Text.Trim();
command.Parameters.Add("@OtherNumber", SqlDbType.VarChar).Value = txtOtherNumber.Text.Trim();
connString.Open();
command.ExecuteNonQuery();
connString.Close();