Question

C# 中SqlDataReader怎么获取列名

如题
C# 中SqlDataReader怎么获取列名
SqlDataReader sdr = new SqlDataReader();
sdr.Read();
string s = sdr[0].列名

具体怎么弄 说下?

Answer 1

  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();
                }
           }

Answer 2

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
();//初始化集合
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();
}
}

Answer 3

sdr["id"]是数据库表中的id
sdr["id"]返回的是object类型，
用.tostring()返回string

Answer 4

用datareader对象就可以了