17,748
社区成员




// 创建连接对象
SqlConnection conn = new SqlConnection(connectionString);
// 创建命令对象
SqlCommand command = new SqlCommand(commandString);
// 打开连接
try
{
// 打开连接
conn.Open( );
// 为命令对象附加连接
command.Connection = conn;
// 获取Data Reader
SqlDataReader reader = command.ExecuteReader();
// 绑定到GridView
GridView1.DataSource = reader;
GridView1.DataBind( );
}
finally
{
conn.Close( ); // 关闭连接
}
//用上下面这个方法应该就可以了
while (reader.Read())
{
}
/// <summary>
/// datareader to datatable
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static DataTable ConvertDataReaderToDataTable(IDataReader reader)
{
DataTable objDataTable = new DataTable();
int intFieldCount = reader.FieldCount;
for (int intCounter = 0; intCounter < intFieldCount; ++intCounter)
{
objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
}
objDataTable.BeginLoadData();
object[] objValues = new object[intFieldCount];
while (reader.Read())
{
reader.GetValues(objValues);
objDataTable.LoadDataRow(objValues, true);
}
reader.Close();
objDataTable.EndLoadData() ;
return objDataTable;
}
SqlDataReader thisreader = thiscommand.ExecuteReader();
GridView1.DataSource = ConvertDataReaderToDataTable(thisreader);
GridView1.DataBind();