如何在C#中调用SQL Server中的存储过程 请给出代码?谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://support.microsoft.com/default.aspx?scid=kb;zh-cn;310070 Create Procedure TestProcedure( @au_idIN varchar (11), @numTitlesOUT Integer OUTPUT)AS select A.au_fname, A.au_lname, T.title from authors as A join titleauthor as TA onA.au_id=TA.au_idjoin titles as Ton T.title_id=TA.title_idwhere A.au_id=@au_idINset @numTitlesOUT = @@Rowcountreturn (5) SqlConnection PubsConn = new SqlConnection ("Data Source=server;integrated " + "Security=sspi;initial catalog=pubs;");SqlCommand testCMD = new SqlCommand ("TestProcedure", PubsConn);testCMD.CommandType = CommandType.StoredProcedure;SqlParameter RetVal = testCMD.Parameters.Add ("RetVal", SqlDbType.Int);RetVal.Direction = ParameterDirection.ReturnValue;SqlParameter IdIn = testCMD.Parameters.Add ("@au_idIN", SqlDbType.VarChar, 11);IdIn.Direction = ParameterDirection.Input;SqlParameter NumTitles = testCMD.Parameters.Add ("@numtitlesout", SqlDbType.VarChar, 11);NumTitles.Direction = ParameterDirection.Output ; IdIn.Value = "213-46-8915";PubsConn.Open();SqlDataReader myReader = testCMD.ExecuteReader();Console.WriteLine ("Book Titles for this Author:");while (myReader.Read()) { Console.WriteLine ("{0}", myReader.GetString (2)); };myReader.Close() ;Console.WriteLine("Number of Rows: " + NumTitles.Value );Console.WriteLine("Return Value: " + RetVal.Value); 这里有完整例子,http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspxhttp://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx SqlConnection conn=new SqlConnection();conn.ConnectionString="server=.;uid=sa;pwd=;database=bargain";conn.Open();SqlCommand cmd=new SqlCommand();cmd.Connection=conn;cmd.CommandText="存储过程名";cmd.Parameters.Add(”参数“);cmd.CommandType=CommandType.StoredProcedure;System.Data.SqlClient.SqlDataAdapter da=new SqlDataAdapter(cmd);DataSet ds=new DataSet();da.Fill(ds,"Product");conn.Close();return ds; 新手小问题 System.Drawing.Pen的颜色如果是变量怎么弄啊? wwf工作的设计问题 gridview显示问题 如何在选择ComboBox中某一项的同时改变其显示的内容 高分求免费电子档C#学习教程初\中\高 在此谢谢各位的有心帮助!! 删除数据库符合时间记录 大侠们,谁有C#写的接受邮件的实例啊。我接收过来不会转码啊 如何取得当前程序的版本等信息? 关于frame 请教:winform中如何使窗口位置固定,就是使其无法被拖动 有没有开发过数码相机控制的?
(
@au_idIN varchar (11),
@numTitlesOUT Integer OUTPUT
)
AS select A.au_fname, A.au_lname, T.title
from authors as A join titleauthor as TA on
A.au_id=TA.au_id
join titles as T
on T.title_id=TA.title_id
where A.au_id=@au_idIN
set @numTitlesOUT = @@Rowcount
return (5)
SqlConnection PubsConn = new SqlConnection
("Data Source=server;integrated " +
"Security=sspi;initial catalog=pubs;");
SqlCommand testCMD = new SqlCommand
("TestProcedure", PubsConn);testCMD.CommandType = CommandType.StoredProcedure;SqlParameter RetVal = testCMD.Parameters.Add
("RetVal", SqlDbType.Int);
RetVal.Direction = ParameterDirection.ReturnValue;
SqlParameter IdIn = testCMD.Parameters.Add
("@au_idIN", SqlDbType.VarChar, 11);
IdIn.Direction = ParameterDirection.Input;
SqlParameter NumTitles = testCMD.Parameters.Add
("@numtitlesout", SqlDbType.VarChar, 11);
NumTitles.Direction = ParameterDirection.Output ;
IdIn.Value = "213-46-8915";
PubsConn.Open();SqlDataReader myReader = testCMD.ExecuteReader();
Console.WriteLine ("Book Titles for this Author:");
while (myReader.Read())
{
Console.WriteLine ("{0}", myReader.GetString (2));
};
myReader.Close() ;
Console.WriteLine("Number of Rows: " + NumTitles.Value );
Console.WriteLine("Return Value: " + RetVal.Value);
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx
conn.ConnectionString="server=.;uid=sa;pwd=;database=bargain";
conn.Open();
SqlCommand cmd=new SqlCommand();
cmd.Connection=conn;
cmd.CommandText="存储过程名";
cmd.Parameters.Add(”参数“);
cmd.CommandType=CommandType.StoredProcedure;
System.Data.SqlClient.SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds,"Product");
conn.Close();
return ds;