StringCollection sc = new StringCollection();
IDataReader r = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
DataRowCollection drc = r.GetSchemaTable().Rows;
foreach (DataRow row in drc)
sc.Add(row["ColumnName"].ToString());
IDataReader r = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
DataRowCollection drc = r.GetSchemaTable().Rows;
foreach (DataRow row in drc)
sc.Add(row["ColumnName"].ToString());
Console.writeline ( ds.Tables[0].Columns[0].ColumnName );
这样还可以做到吗??
string sql = "SELECT * FROM SYSCOLUMNS WHERE ID = OBJECT_ID('表名')";
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
adapter.Fill(ds,"表名");foreach(DataColumn col in ds.Tables["表名"].Columns)
{
....
}