从系统表中能取到
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();
前台:
,
取消
评论