常用读取数据的方法
string connectionString = "";
string queryString = "";
//–使用dataset
DataSet ds = new DataSet();
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(ds);
}
catch (Exception exp)
{
Console.WriteLine(exp.Message);
}
}
//–使用Data reader
List<MyType> fields = new List<MyType>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
fields.Add(new MyType(name, type));
}
}
catch (Exception exp)
{
Console.WriteLine(exp.Message);
}
}
