System.Data.SqlClient.SqlConnection Operationcn=new SqlConnection("数据库连接字符串");
Operationcn.Open();
SqlDataAdapter Commonada=new SqlDataAdapter("Select * From ustmoerinfo",Operationcn);
DataSet CommonDset=new DataSet();
Commonada.Fill(CommonDset,custmoerinfo);
foreach (DataColumn c in CommonDset.Tables[custmoerinfo].Columns)
{ MessageBox.Show(c.ColumnName.ToString()); //显示当前操作表所有字段名
}
Operationcn.Open();
SqlDataAdapter Commonada=new SqlDataAdapter("Select * From ustmoerinfo",Operationcn);
DataSet CommonDset=new DataSet();
Commonada.Fill(CommonDset,custmoerinfo);
foreach (DataColumn c in CommonDset.Tables[custmoerinfo].Columns)
{ MessageBox.Show(c.ColumnName.ToString()); //显示当前操作表所有字段名
}
Commonada.Fill(CommonDset,custmoerinfo);
foreach (DataColumn c in CommonDset.Tables[custmoerinfo].Columns)
{ MessageBox.Show(c.ColumnName.ToString()); //显示当前操作表所有字段名
}应改为:
Commonada.Fill(CommonDset,"custmoerinfo");
foreach (DataColumn c in CommonDset.Tables["custmoerinfo"].Columns)
{ MessageBox.Show(c.ColumnName.ToString()); //显示当前操作表所有字段名
}
select Name from syscolumns where id=object_id('custmoerinfo')字段描述:
select * from ::fn_listextendedproperty(NULL, 'user', 'dbo', 'table', 'custmoerinfo','column', default)