获取SqlDataReader的列名
时间:2011-03-22 来源:郑文亮
SqlConnection thisConnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
// Open connection
thisConnection.Open();
// Create command for this connection
SqlCommand thisCommand = thisConnection.CreateCommand();
// Specify SQL query for this command
thisCommand.CommandText = sCommandText;
// Execute DataReader for specified command
SqlDataReader thisReader = thisCommand.ExecuteReader();
// While there are rows to read
//
//
View_LogDetailEntity = new List<CView_LogDetail>();//初始化集合
string sColumnName = string.Empty;
while (thisReader.Read())
{
CView_LogDetail myCView_LogDetail = new CView_LogDetail();
for (int i = 0; i < thisReader.FieldCount; i++)
{
sColumnName = thisReader.GetName(i).Trim();
}
}