Question

如何使用C#语言调用存储过程

Answer 1

dataSet.Reset();
//执行存储过程
command = new SqlCommand( "GetDeliverItem ", connection);
//说明命令要执行的是存储过程
command.CommandType = CommandType.StoredProcedure;
//向存储过程中传递参数
command.Parameters.Add(new SqlParameter( "@SampCode ", SqlDbType.VarChar, 30));
command.Parameters.Add(new SqlParameter( "@DeptName ", SqlDbType.VarChar, 100));
command.UpdatedRowSource = UpdateRowSource.None;
command.Parameters[ "@SampCode "].Value = sampCode;
command.Parameters[ "@DeptName "].Value = combSelDeliver.Text.ToString();
//执行命令
dapt.SelectCommand = command;
dapt.SelectCommand.ExecuteNonQuery();
dapt.Fill(dataSet, "samp000 ");
dataView.Table = dataSet.Tables[ "samp000 "];
dataGridView1.DataSource = dataSet.Tables[ "samp000 "];

Answer 2

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="storedProcName">存储过程名</param>
/// <param name="parameters">存储过程参数</param>
/// <param name="tableName">DataSet结果中的表名</param>
/// <returns>DataSet</returns>
public static DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);
sqlDA.Fill(dataSet, tableName);
connection.Close();
return dataSet;
}
}

Answer 3

你连接数据库的时候不是写comm的类型吗？ 你把类型该一下。代码如下：
SqlConnection conn=new SqlConnection ();
conn.ConnectionString="Server=(local);database=db;uid=sa;pwd=sa";//连接数据库
conn.Open();
SqlCommand cmd=new SqlCommand("Proc",conn);//其中Proc为存储过程名称
cmd.CommandType = CommandType.StoredProcedure;//指定执行类型为存储过程
DataTable dt = new DataTable();
//执行存储过程
SqlDataAdapter sda=new SqlDataAdapter(cmd);
//将结果填充到datatable中
sda.Fill(dt);
return dt;//返回Datatable

Answer 4

执行命令选择这个 CommandType.StoredProcedure
Test 是文本 就是你手写sql语句 上面这个就是存储过程

Answer 5

C#调用SQL Server存储过程里例子代码
http://hi.baidu.com/wangzhiqing999/blog/item/0c2fd3ad17aee6f31f17a263.html

C#调用 Oracle 存储过程例子代码
http://hi.baidu.com/wangzhiqing999/blog/item/ba83a905209f83017aec2c7a.html