subject_17668.htm

一些关于vc的问答

<p>
序号：17668 发表者：落叶夏日 发表日期：2002-10-14 12:40:41
<br>主题：数据库存储过程的处理(C#)
<br>内容：存储过程如下：<BR>CREATE PROCEDURE spCreateNewOrder<BR>(<BR>&nbsp;&nbsp; @Order_UserID char(2),<BR>&nbsp;&nbsp; @Order_From char (2)<BR>)<BR>AS<BR>INSERT INTO YHDD_HEAD<BR>(<BR>&nbsp;&nbsp; Order_UserID,<BR>&nbsp;&nbsp; Order_From,<BR>&nbsp;&nbsp; Order_date<BR>)<BR>VALUES <BR>(<BR>&nbsp;&nbsp; @Order_UserID,<BR>&nbsp;&nbsp;&nbsp;&nbsp;@Order_From,<BR>&nbsp;&nbsp;&nbsp;&nbsp;GETDATE()<BR>)<BR>SELECT @@IDENTITY<BR>GO<BR>我要在程序中得到@@IDENTITY 怎样处理, @@IDENTITY 返回的是关键字<BR>程序如下(C#)，怎样修改：<BR>private void Button1_Click(object sender, System.EventArgs e)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SqlCommand com = new SqlCommand("spCreateNewOrder",sqlConnection1);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.CommandType =CommandType.StoredProcedure;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.Parameters.Add(new SqlParameter("@Order_UserID",SqlDbType.Char,2,"Order_UserID"));<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.Parameters["@Order_UserID"].Value ="03";<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.Parameters.Add(new SqlParameter("@Order_From",SqlDbType.Char,2,"Order_From"));<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.Parameters["@Order_From"].Value ="02";<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sqlConnection1.Open();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.ExecuteNonQuery();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sqlConnection1.Close();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<BR>
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
回复者：洪乾 回复日期：2002-10-16 15:23:02
<br>内容：sqlConnection1.Open();返回若干个RecordSet，访问哪些返回的RecordSet就可以了。<BR>还有Procedure也可以返回整数啊。
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：Hpp 回复日期：2002-10-16 21:14:08
<br>内容：CREATE PROCEDURE spCreateNewOrder<BR>(<BR>&nbsp;&nbsp; @Order_UserID char(2),<BR>&nbsp;&nbsp; @Order_From char (2),<BR>&nbsp;&nbsp; @iden int output<BR>)<BR>AS<BR>INSERT INTO YHDD_HEAD<BR>(<BR>&nbsp;&nbsp; Order_UserID,<BR>&nbsp;&nbsp; Order_From,<BR>&nbsp;&nbsp; Order_date<BR>)<BR>VALUES <BR>(<BR>&nbsp;&nbsp; @Order_UserID,<BR>&nbsp;&nbsp;&nbsp;&nbsp;@Order_From,<BR>&nbsp;&nbsp;&nbsp;&nbsp;GETDATE()<BR>)<BR>SET @iden=@@IDENTITY<BR>GO<BR>然后在程序中处理传出参数!<BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>