读书人

c#net中怎样用DataGrid控件显示Sql Se

发布时间: 2011-12-31 23:50:30 作者: rapoo

c#.net中怎样用DataGrid控件显示Sql Server数据库中的内容呢
如题

[解决办法]
string source= "server=(local);uid=sa;database=northwind ";
string customers= "select * from Customers ";
SqlConnection con=new SqlConnection(source);
SqlDataAdapter da=new SqlDataAdapter(customers,con);
DataSet ds=new DataSet();
da.Fill(ds, "Customers ");
DataGrid1.SetDataBinding(ds, "Customers ");


[解决办法]
string source= "server=(local);uid=sa;database=northwind ";
string customers= "select * from Customers ";
SqlConnection con=new SqlConnection(source);
SqlDataAdapter da=new SqlDataAdapter(customers,con);
DataSet ds=new DataSet();
da.Fill(ds, "Customers ");
dataGrid1.DataSource=ds.Tables[0];
[解决办法]
string source= "server=(local);uid=sa;database=northwind ";
string customers= "select * from Customers ";
SqlConnection con=new SqlConnection(source);
SqlDataAdapter da=new SqlDataAdapter(customers,con);
DataSet ds=new DataSet();
da.Fill(ds, "Customers ");
dataGrid1.DataSource=ds.Tables[0];
dataGrid1.DataBind();

读书人网 >C#

热点推荐