用VS怎么写存储过程 怎么写

[qqy880228]

请写出一个很简单的存储过程

[wuyq11]

存储过程在数据库里写，如SQL 2005
CREATE PROCEDURE P_Q
AS
SELECT * FROM TABLE1

[笺香]

关注

[qqy880228]

[Quote=引用 3 楼 jiongjiongtang 的回复:]
create proc [dbo].[pro_update_restore]
@resTime varchar(20),
@resMan varchar(30),
@resCount int,
@resRemark varchar(50),
@resId int

as
begin
update restores set resTime=@resTime,resMan=@resMan,resCount=@resCount,resRemark=@resRemark
where resId=@resId;
end
[/Quote]

我 不懂啊 有问题

[y63964632]

哪里不懂？楼主可以说明白~

[zhaoguo2007]

存储过程是写在SQL Server上的...

CREATE PROCEDURE dbo.AXzhz
/*
这里写注释
*/
@getXM varchar(16),
@getNN varchar(16),
AS
insert into test1(XM,NN) values(@getXM,@getNN)
GO

用的时候在CS文件里
顶上记得引用using System.Data.SqlClient;

写个执行存储过程的方法:
public void doStoredProcedure(SqlConnection con, SqlCommand com)
{
com = new SqlCommand("AXzhz", con);
com.CommandType = CommandType.StoredProcedure;
SqlParameter par1 = new SqlParameter("@getXM ", XM.Text);
SqlParameter par2 = new SqlParameter("@getNN ", NN.Text);
com.Parameters.Add(par1);
com.Parameters.Add(par2);

SqlDataReader rd = com.comm.ExecuteNonQuery();
}
调用上面的方法执行存储过程:
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand comm=new SqlCommand ();
using (SqlConnection conn = returnConn())
{
doStoredProcedure(conn ,comm);
}
}
写个数据库连接的函数:
protected SqlConnection returnConn()
{
string connStr=System.Configuration.ConfigurationManager.AppSettings["connStr"];
SqlConnection conn = new SqlConnection(connStr);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
return conn;
}

Web.config里:
<configuration>
<appSettings>
<add key="connStr" value="Server=SQL服务器名或者IP;Database=数据库名;uid=sa;pwd=密码" />
</appSettings>
</configuration>

[zhaoguo2007]

上面的第一个方法写错了...
public void doStoredProcedure(SqlConnection con, SqlCommand com)
{
com = new SqlCommand("AXzhz", con);
com.CommandType = CommandType.StoredProcedure;
SqlParameter par1 = new SqlParameter("@getXM ", XM.Text);
SqlParameter par2 = new SqlParameter("@getNN ", NN.Text);
com.Parameters.Add(par1);
com.Parameters.Add(par2);

comm.ExecuteNonQuery();
}

[gtiroy]

vs
写存储过程？

[sphinger]

貌似是在SQL里写的，楼主能说清楚问题就更好了

[jiongjiongtang]

create proc [dbo].[pro_update_restore]
@resTime varchar(20),
@resMan varchar(30),
@resCount int,
@resRemark varchar(50),
@resId int

as
begin
update restores set resTime=@resTime,resMan=@resMan,resCount=@resCount,resRemark=@resRemark
where resId=@resId;
end