c# 調用存儲過程

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();