如果用datareader,就可以用whiel(dr.read())
{}这种方法读出字段里的多条记录,但是用存储过程parameter里好像不好读,我的代码: //调用存储过程
SqlCommand cmd = new SqlCommand("RidSel",connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("single",SqlDbType.Char,10);
cmd.Parameters["single"].Direction = ParameterDirection.Output;
string single = cmd.Parameters["single"].Value.ToString();//single字段里有多条记录,但是现在只能读取到最后一条
{}这种方法读出字段里的多条记录,但是用存储过程parameter里好像不好读,我的代码: //调用存储过程
SqlCommand cmd = new SqlCommand("RidSel",connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("single",SqlDbType.Char,10);
cmd.Parameters["single"].Direction = ParameterDirection.Output;
string single = cmd.Parameters["single"].Value.ToString();//single字段里有多条记录,但是现在只能读取到最后一条
AS
Select Top 10 CompanyName From Customers
GO
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Pro_Result"; SqlDataReader sr = cmd.ExecuteReader();
while (sr.Read())
{
Console.WriteLine(sr[0]);
Console.WriteLine(sr[1]);
Console.WriteLine(sr[2]);
Console.WriteLine(sr[3]);
...
}