با تشكر از توجه شما
ALTER PROCEDURE dbo.NewPerson
@id nvarchar(50),
@name nvarchar(50),
@family nvarchar(50),
@fathername nvarchar(50),
@shsh nvarchar(50),
@shmelli nvarchar(50),
@sadere nvarchar(50),
@postcode nvarchar(50),
@adres nvarchar(50),
@pelak nvarchar(50),
@tel nvarchar(50),
@ostan nvarchar(50),
@shahr nvarchar(50)
AS
insert into tblpersons(id,[name],family,fathername,shsh
,shmelli,sadere,postcode,adres,pelak,tel,ostan,sha hr) values(@id,@name,@family,@fathername
,@shsh,@shmelli,@sadere,@postcode,@adres,@pelak,@t el,@ostan,@shahr)
RETURN
بعد با اين كدهم اون رو اجرا مي كنم
int c = 0;
SqlCommand com = new SqlCommand("select count(*) from tblpersons", Classes.Vars.MyConnection);
Classes.Vars.MyConnection.Open();
c = int.Parse(com.ExecuteScalar().ToString())+1;
Classes.Vars.MyConnection.Close();
com.CommandText = "NewPerson";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@id", c.ToString());
com.Parameters.AddWithValue("@name", txtName.Text);
com.Parameters.AddWithValue("@family", txtFamily.Text);
com.Parameters.AddWithValue("@shsh", txtshsh.Text);
com.Parameters.AddWithValue("@shmelli", txtshmelli.Text);
com.Parameters.AddWithValue("@sadere", txtSadere.Text);
com.Parameters.AddWithValue("@postcode", txtCodePosti.Text);
com.Parameters.AddWithValue("@adres", txtAdres.Text);
com.Parameters.AddWithValue("@pelak", txtpelak.Text);
com.Parameters.AddWithValue("@tel", txtTel.Text);
com.Parameters.AddWithValue("@ostan", cbOstan.Text);
com.Parameters.AddWithValue("@shahr", cbShahr.Text);
com.Parameters.AddWithValue("@fathername", txtFatherName.Text);
com.CommandType = CommandType.StoredProcedure;
Classes.Vars.MyConnection.Open();
com.ExecuteNonQuery();
Classes.Vars.MyConnection.Close();