1、建立自己的存儲過程SpDelData
CREATE PROCEDURE SpDelData @a char(10)
AS
delete from T1 where a= @a
GO
2、調用
SqlConnection conn = new SqlConnection(Connstring);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText="SpDelData";
SqlParameter para1 = cmd.Parameters.Add("@a",SqlDbType.Char);
para1.Direction = ParameterDirection.Input;
para1.Value = "value";
// 同上可添加多個參數,
cmd.ExecuteNonQuery();
conn.Close();