1.新建sql Server Project项目,并在项目中添加存储过程模版,此时自动引入System.Data.SqlServer命名空间,并创建一个static函数
2.在自动创建好的函数中添加如下代码,以下是返回SqlDataReader的实例。
1
using System;
2
using System.Data;
3
using System.Data.SqlClient;
4
using System.Data.SqlTypes;
5
using Microsoft.SqlServer.Server;
6
using System.Text;
7![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
public partial class StoredProcedures
9
{
10
[Microsoft.SqlServer.Server.SqlProcedure]
11
public static void StoredProcedure1()
12
{
13
StringBuilder sqlSb = new StringBuilder();
14
string showFiled = "ZfId,ZfXm";
15
string fromTable = "Xf_ZfJbXx";
16
string conditionFiled = "ZfXb";
17
string valueString = "男";
18![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
sqlSb.AppendFormat("select {0} from {1} where {2}='{3}'", showFiled, fromTable, conditionFiled, valueString);
20![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
using (SqlConnection cnn = new SqlConnection("Context Connection=true"))
22
{
23
using (SqlCommand sqlCmd = new SqlCommand())
24
{
25
cnn.Open();
26
sqlCmd.Connection = cnn;
27
sqlCmd.CommandText = sqlSb.ToString();
28
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
29![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
SqlPipe sqlP = SqlContext.Pipe;
31
sqlP.Send(sqlReader);
32
}
33
}
34
}
35
};
36![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3.修改数据库的兼容级别:
打开查看SQL Server Management Studio,按照以下步骤操作:
鼠标右键选择使用的数据库,点击属性;选择-选项-兼容级别:SQL Server 2005(90).
4.如果CLR为关闭
则执行系统存储过程
sp_configure 'clr enabled','1'
reconfigure
5.可以在查询分析器里运行此存储过程了。