asp.net mysql所有数据库_asp.net 如何获取sql数据库所有列名称

打开Default.aspx.cs文件，添加如下代码，如下图所示：

protected void Page_Load(object sender, EventArgs e)

{

string conString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ToString();

if (!IsPostBack)

{

using (SqlConnection con = new SqlConnection(conString))

{

string sql = "SELECT * FROM SysColumns WHERE id = Object_Id('T1')";

using (SqlDataAdapter adapter = new SqlDataAdapter(sql, con))

{

DataSet ds = new DataSet();

adapter.Fill(ds);

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

Response.Write("第"+(i+1)+"列名为："+ds.Tables[0].Rows[i][0]+"

");

}

}

}

}

}