mysql查询表头_怎样取sql数据库数据表的表头字段

从系统表中能取到

select name,offset from sys.syscolumns where id=object_id('job')

C#:

string connstr = "Data Source=xxxx;Initial Catalog=xxxx;Persist Security Info=True;User ID=xxxxx;Password=xxxxx";

SqlConnection conn = new SqlConnection(connstr);

if (conn.State.Equals("Closed"))

{

conn.Open();

}

SqlDataAdapter sda = new SqlDataAdapter("select name,offset from sys.syscolumns where id=object_id('Job') ", conn);

DataSet ds = new DataSet();

sda.Fill(ds,"result");

DataList1.DataSource = ds.Tables["result"];

DataList1.DataBind();

conn.Dispose();

conn.Close();

前台:

,

取消

评论