C#调用存储过程的通用方法如何写呀！！！

[清风树下]

C#调用存储过程的通用方法如何写呀！！！
如这样：
/// <summary>
/// 数据库存储过程执行
/// </summary>
/// <param name="StrProc">存储过程名 参数1,参数2,...参数n</param>
/// <param name="Data_Config">SQL数据库连接配置信息</param>
/// <returns>返回null表示错误，返回null表示无返回值返操作成功,否则返回存储过程的返回值</returns>
public object ExecuteProc(string StrProc, SqllinkConfig Data_Config)
{
try
{
if (IsNull(StrProc))
{
if (Data_Config == null) return false;
SqlConnection conn = new SqlConnection(Data_Config.Connection);
conn.Open();
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = datavoid.ReplaceSql(StrSql, "SQL");
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
conn.Close();
return true;
}

}
catch { }
return false;
}
可是不对呀！！！

[shoushii]

DateSet getSet(string Procedure,params IDBParameter[] para)
{
连接数据库
CMD对象
DATASET对象
适配对象
传递参数
..
返回数据

}

[shoushii]

CommandType.StoredProcedure;

[lovesnow1573]

=====================对你的代码分析一下


SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = datavoid.ReplaceSql(StrSql, "SQL");
command.CommandType = CommandType.StoredProcedure;

======================================================
换成
SqlCommand command = new SqlCommand("存储过程的名字",conn);
command.CommandType = CommandType.StoredProcedure;
============
或者是

SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = "存储过程的名字";
command.CommandType = CommandType.StoredProcedure;

[cbgn]

你下个SQLHELPER,都有的

[xiaoliangwh]

up

[buxiangwei]

command.CommandText = "存储过程名";
就行

[xwk789xwk]

SqlCommand cmd = new SqlCommand(procName,con);//procName是存储过程名，con是连接语句
cmd.CommandType = CommandType.StoredProcedure;

[hm7921936]

通用就是任何 参数 任何存储过程都可以用的吧..

[blankfang]

经典

[vicqqq]

经典

[szh3210]

up

[Jinglecat]

完全不知道 LZ 这个能用用来什么

命名参数怎么办？

[AndaChang]

command.CommandText = "存储过程名";
就行

[songsu]

string sql = "INSERT INTO Admin (AdminName,AdminPassword) VALUES (@AdminName,@AdminPassword);";
SqlCommand cmd = new SqlCommand(sql,app.G_Con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AdminName",SqlDbType.NVarChar,50).Value = this.AdminName.Text;
cmd.Parameters.Add("@AdminPassword",SqlDbType.NVarChar,50).Value = this.AdminPassword.Text;

cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();

this.Message.Text = "添加成功！";

[songsu]

你先创建一个存储过程

CREATE PROCEDURE AddData_Admin
@AdminName NVarChar(50),@AdminPassword NVarChar(50)
AS
SET NOCOUNT ON
INSERT INTO Admin
(AdminName,AdminPassword)
VALUES(@AdminName,@AdminPassword)
SELECT @@IDENTITY AS NID



SqlCommand cmd = new SqlCommand("AddData_Admin",app.G_Con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AdminName",SqlDbType.NVarChar,50).Value = this.AdminName.Text;
cmd.Parameters.Add("@AdminPassword",SqlDbType.NVarChar,50).Value = this.AdminPassword.Text;

cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();

this.Message.Text = "添加成功！";

[sunzhong2003]

petshop SQLHELPER看看吧

[yangyibang]

经典

[稍微有点无敌]

看看我做的
http://www.cnblogs.com/jintan/archive/2007/04/28/731217.html

[yuanzhihua520]

up

[yan53125]

那个结晶~~