string strConn = "server=.\\SQLEXPRESS;integrated security=SSPI;database=AdventureWorks";
SqlConnection Conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("SELECT * FROM AWBuildVersion", Conn);
这是查询的代码,怎么将查询道德结果显示在GridView1里面,后面我不会写了。
高手帮帮忙。
SqlConnection Conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("SELECT * FROM AWBuildVersion", Conn);
这是查询的代码,怎么将查询道德结果显示在GridView1里面,后面我不会写了。
高手帮帮忙。
string strConn = "server=.\\SQLEXPRESS;integrated security=SSPI;database=AdventureWorks";
SqlConnection Conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("SELECT * FROM AWBuildVersion", Conn);
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);
GridView1.DataSource=ds;
GridView1.DataBind();
using (SqlConnection conn = new SqlConnection(cnStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlAllCustomers, conn);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("..");
adpt.Fill(dt);
gridview.datasource=dt;
SqlConnection Conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("SELECT * FROM AWBuildVersion", Conn);
DataSet ds=new DataSet();
da.Fill(ds);
GridView1.DataSource=ds;
GridView1.DataBind();
SqlAdapter da=new SqlAdapter(cmd,cStrCon)
da.fill(Ds,"表名")
DataGrid.DataBourse=ds;
DataGrid.DataMember="表名";