|
Posted on
2008-08-29 20:06
管志鹏
阅读( 1910)
评论()
编辑
收藏
举报
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif) Code
1 using System;
2 using System.Collections.Generic;
3 using System.Text;
4 using System.Data;
5 using System.Data.SqlClient;
6![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7 namespace StoreProduceTest
8![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif) ![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif) {
9 public class Program
10![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
11![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) /**//**
12 * 存储过程
13 *
14 * create procedure queryStuNameById
15 @stuId varchar(10),--输入参数
16 @stuName varchar(10) output --输出参数
17 as
18 select @stuName=stuName from stuInfo where stuId=@stuId
19 *
20 */
21![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23 static void Main(string[] args)
24![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
25 Operater op = new Operater();
26 string name = op.QueryStuNameById("1234");
27![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
28 Console.WriteLine(string.Format("学号为1234的学生的姓名为{0}", name));
29 }
30![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
31 }
32![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
33 public class Operater
34![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
35 private string ConStr = "server=.;database=User;uid=sa;pwd=1234";
36 private SqlConnection sqlCon = null;
37 private SqlCommand sqlComm = null;
38 SqlDataReader dr = null;
39![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
40 public string QueryStuNameById(string Id)
41![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
42![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
43 string name = "";
44![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
45 try
46![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
47 using (sqlCon = new SqlConnection(ConStr))
48![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
49![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
50 sqlCon.Open();
51 sqlComm = new SqlCommand("queryStuNameById", sqlCon);
52 //设置命令的类型为存储过程
53 sqlComm.CommandType = CommandType.StoredProcedure;
54![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
55 //设置参数
56 sqlComm.Parameters.Add("@stuId", SqlDbType.VarChar);
57 //注意输出参数要设置大小,否则size默认为0,
58 sqlComm.Parameters.Add("@stuName", SqlDbType.VarChar, 10);
59 //设置参数的类型为输出参数,默认情况下是输入,
60 sqlComm.Parameters["@stuName"].Direction = ParameterDirection.Output;
61![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62 //为参数赋值
63 sqlComm.Parameters["@stuId"].Value = "1234";
64 //执行
65 sqlComm.ExecuteNonQuery();
66 //得到输出参数的值,把赋值给name,注意,这里得到的是object类型的,要进行相应的类型轮换
67 name = sqlComm.Parameters["@stuName"].Value.ToString();
68![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
69 }
70![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
71 }
72 catch (Exception ex)
73![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif) {
74![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
75 Console.WriteLine(ex.ToString());
76 }
77 return name;
78![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
79 }
80 }
81![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82 }
83![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
84![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
|