string mySelectQuery = "SELECT * FROM Categories ORDER BY CategoryID";
string myConnectString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";
SqlConnection myConnection = new SqlConnection(myConnectString);
SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection);
myCommand.CommandTimeout = 15;
myCommand.CommandType = CommandType.Text;这是查询数据库的编码,现在就是怎么绑定到daragrid上的问题,谢谢
string myConnectString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";
SqlConnection myConnection = new SqlConnection(myConnectString);
SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection);
myCommand.CommandTimeout = 15;
myCommand.CommandType = CommandType.Text;这是查询数据库的编码,现在就是怎么绑定到daragrid上的问题,谢谢
string myConnectString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";SqlDataAdapter da=new SqlDataAdapter(mySelectQuery,myConnectString);
DataSet ds=new DataSet();
da.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
DataSet ds=new DataSet();
da.Fill(ds,"DBName");
DataGrid1.DataSource = ds.Table["DBName"];//如果多表时,也可以取DBName别名的。
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
大哥信誉好高啊
楼上给出了正解
其实这些问题,你去MSDN里查一下,满地都是