存储过程
CREATE PROCEDURE procedure2
@id char(10),@jb char(100)
AS
delete from 发件箱 where id=@id and 级别=@jb
GOc#调用语句
-------建立对象实例代码省略了------
cmdprs.Connection=cnprs;
cmdprs.CommandType=CommandType.StoredProcedure;
cmdprs.CommandText="procedure2";
cmdprs.Parameters.Add("@id",textBox1.Text);
cmdprs.Parameters.Add("@jb",textBox2.Text);
cnprs.Open();
cmdprs.ExecuteNonQuery();
cnprs.Close(0;
CREATE PROCEDURE procedure2
@id char(10),@jb char(100)
AS
delete from 发件箱 where id=@id and 级别=@jb
GOc#调用语句
-------建立对象实例代码省略了------
cmdprs.Connection=cnprs;
cmdprs.CommandType=CommandType.StoredProcedure;
cmdprs.CommandText="procedure2";
cmdprs.Parameters.Add("@id",textBox1.Text);
cmdprs.Parameters.Add("@jb",textBox2.Text);
cnprs.Open();
cmdprs.ExecuteNonQuery();
cnprs.Close(0;
cmdprs.Connection=cnprs;
cmdprs.CommandType=CommandType.StoredProcedure;
cmdprs.CommandText="procedure2";
cmdprs.Parameters.Add("@id",SqlDbType.Char,10);
cmdprs.Parameters.Add("@jb",SqlDbType.Char,100);
cmdprs.Parameters["@id"].Value = textBox1.Text;
cmdprs.Parameters["@jb"].Value = textBox2.Text;
cnprs.Open();
cmdprs.ExecuteNonQuery();
cnprs.Close(0;
hashtable 存放 参数名称,和参数值.
---------------------------------------------
public SqlDataReader execDataReader(string procName,Hashtable hashtable)
{
sqlConn.Open();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlConn;
sqlCmd.CommandText = procName;
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
System.Collections.IDictionaryEnumerator myE = hashtable.GetEnumerator();//接口遍历哈希表所有的值和参数
SqlParameter p;
while(myE.MoveNext())
{
p = new SqlParameter();
switch(myE.Value.GetType().ToString())
{
case "System.Int32":
p.SqlDbType = SqlDbType.Int;
break;
case "System.String":
p.SqlDbType = SqlDbType.VarChar;
break;
case "System.Boolean":
p.SqlDbType = SqlDbType.Bit;
break;
case "System.Byte":
p.SqlDbType = SqlDbType.Binary;
break;
case "System.Double":
p.SqlDbType = SqlDbType.Float;
break;
case "System.DateTime":
p.SqlDbType = SqlDbType.DateTime;
break;
default:
p.SqlDbType = SqlDbType.VarChar;
break;
}
p.ParameterName = myE.Key.ToString();
p.Value = myE.Value.ToString();
sqlCmd.Parameters.Add(p);
}
SqlDataReader result = sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);
return result;
}
cmdprs.CommandType=CommandType.StoredProcedure;
cmdprs.CommandText="procedure2";
cmdprs.Parameters.Add("@id",SqlDbType.Char,10);
cmdprs.Parameters["@id"].Value=textBox1.Text;cmdprs.Parameters.Add("@jb",SqlDbType.Char,100);
cmdprs.Parameters["@jb"].Value=textBox2.Text;cnprs.Open();
cmdprs.ExecuteNonQuery();
cnprs.Close(0;
cnprs.Close(): !!