主要是这么一句sql语句:
select name from syscolumns where id = object_id('表名');
实现方法:
public List<string> getSqlColumnName()
{
List<string> columnName = new List<string>();
string sql = "select name from syscolumns where id = object_id('表名')";
try {
conn.Open();
SqlCommand com = new SqlCommand(sql, conn);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
columnName.Add(dr[0].ToString());
}
dr.Close();
conn.Close();
}
catch (Exception e)
{
}
return columnName;
}
之前以为要用到这个,百度啊qq群里问啊,结果发现还是自己对这个dr理解比较模糊,理解了就非常的easy,虽然后来发现这个并派不上用场,还是在此记录一笔吧