نمونه کد فراخوانی Stored Procedure در سیشارپ ( Insert )

SqlConnection conn = new SqlConnection(_ConnectionString);
SqlCommand cmd_AddStudent = new SqlCommand();
        
cmd_AddStudent.CommandText = "stp_Addstudent"; // نام SP
cmd_AddStudent.CommandType = CommandType.StoredProcedure;

cmd_AddStudent.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int));
cmd_AddStudent.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.NVarChar));
cmd_AddStudent.Parameters.Add(new System.Data.SqlClient.SqlParameter("@family", System.Data.SqlDbType.NVarChar));
cmd_AddStudent.Parameters.Add(new System.Data.SqlClient.SqlParameter("@tell", System.Data.SqlDbType.NVarChar));
cmd_AddStudent.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.NVarChar));

cmd_AddStudent.Connection = conn;

cmd_AddStudent.Parameters["@id"].Value = txt_id.Text;
cmd_AddStudent.Parameters["@name"].Value = txt_name.Text;
cmd_AddStudent.Parameters["@family"].Value = txt_family.Text;
cmd_AddStudent.Parameters["@tell"].Value = txt_tell.Text;
cmd_AddStudent.Parameters["@address"].Value = txt_address.Text;

conn.Open();
cmd_AddStudent.ExecuteNonQuery();