下面的例子我们用存储过程返回两个数据集，然后用DataReader的NextResult方法处理这两个数据集。

存储过程的代码（名称：Proc）：

CREATE PROC Proc —-Multiple Resultsets

AS

SELECT * FROM Users

SELECT * FROM Users WHERE State = ‘CA‘

GO

取这两个数据集的代码：

注意DataReader的NextResult出现的地方

String ConnString  = "User ID=sa;password=sa;Initial Catalog=pubs;Data Source=myServer";SqlConnection Connection = new SqlConnection(myConnString);SqlCommand Command = new SqlCommand();SqlDataReader reader ;Command.CommandType = CommandType.StoredProcedure;Command.Connection = Connection;Command.CommandText = "Proc";int RecordCount=0;try{Connection.Open();reader = command.ExecuteReader();int RecordCount=0;// read the data from that resultset    while (reader.Read()){RecordCount = RecordCount + 1;}Response.Write("Total number of Users:" + RecordCount.ToString());// read the next resultset    reader.NextResult();RecordCount = 0;// read the data from that second resultset    while (reader.Read()){RecordCount = RecordCount + 1;}Response.Write("Total number of Users from California:" + RecordCount.ToString());}catch (Exception ex){MessageBox.Show(ex.ToString());}finally{Connection.Close();}

 Split函数是用来对字符串进行分割用的，可以运用正则表达式，不多说，见例子。

1、用单个字符来分隔

string str="aaajbbbjccc";

string[] sArray=str.Split(‘j‘);

foreach(string i in sArray) Response.Write(i.ToString() + "<br>");

输出结果：
aaa
bbb
ccc

2、用多个字符来分隔

string str="aaajbbbscccjdddseee";

string[] sArray=str.Split(new char[2]{‘j‘,‘s‘}); 

foreach(string i in sArray) Response.Write(i.ToString() + "<br>"); 



输出结果：
aaa
bbb
ccc
ddd
eee

3、运用正则表达式进行字符串分隔

string str1="Hector‘s **Blog***** is***** www.ourys.com*****IT元素";

string[] str2 =System.Text.RegularExpressions.Regex.Split(str1,@"[*]+");                                                        

foreach(string i in str2)

        Console.WriteLine(i.ToString());

这个例子得到：Hector‘s Blog is www.ourys.com IT元素