DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter("proc_check",conn);//proc_check为存储过程名
da.SelectCommand.CommandType=CommandType.StoredProcedure;
try
{
da.Fill(ds,"fasong");
}
catch(Exception e){
Console.WriteLine(e.Message);
}
int n=ds.Tables["fasong"].Rows.Count;
if(n!=0){
foreach(DataRow dr in ds.Tables["fasong"].Rows){
Console.WriteLine(dr["msgId"]+" "+dr["phone"]+" "+dr["content"]);
}
}
Console.WriteLine(n);
SqlDataAdapter da=new SqlDataAdapter("proc_check",conn);//proc_check为存储过程名
da.SelectCommand.CommandType=CommandType.StoredProcedure;
try
{
da.Fill(ds,"fasong");
}
catch(Exception e){
Console.WriteLine(e.Message);
}
int n=ds.Tables["fasong"].Rows.Count;
if(n!=0){
foreach(DataRow dr in ds.Tables["fasong"].Rows){
Console.WriteLine(dr["msgId"]+" "+dr["phone"]+" "+dr["content"]);
}
}
Console.WriteLine(n);