凯美瑞油电混合2017:asp.net datagrid 多数据库绑定

来源：百度文库编辑：杭州交通信息网时间：2024/04/29 14:05:11

string strSql = "select * from Orders,Users,ShoppingCart where Orders.CustomerID=Users.uid and Orders.cartid=ShoppingCart.CartID ";

比如这个语句,有三个数据库同时被打开,希望执行结果绑定到
DataGrid1这个控件,该怎么做?
已经关了.net了，下次开的时候告诉你

对应DataField 就可以了

SqlCommand cmd3=new SqlCommand("Select Distinct TeacherAverageTable.scno,scm,TeacherAverageTable.zb1,TeacherAverageTable.zb2,TeacherAverageTable.zb3,TeacherAverageTable.zb4,TeacherAverageTable.zb5,TeacherAverageTable.zb6,TeacherAverageTable.zb7,TeacherAverageTable.zb8,TeacherAverageTable.zb9,TeacherAverageTable.zp from TeacherAverageTable,ScTable,EvaluateTable where Bpr=@tno1 and ScTable.scno=TeacherAverageTable.scno",conn );
cmd3.Parameters .Add (new SqlParameter ("@tno1",SqlDbType.Char ,8));
cmd3.Parameters["@tno1"].Value =teacherno;
TinfoDataGrid.DataSource =cmd3.ExecuteReader ();
TinfoDataGrid.DataBind ();
<asp:BoundColumn DataField="scno" HeaderText="课程号">
<HeaderStyle Width="2.2cm"></HeaderStyle>

<asp:BoundColumn DataField="scm" HeaderText="课程名">
<HeaderStyle Width="2.2cm"></HeaderStyle>

本人也想知道，期待大侠回答．

asp.net datagrid 多数据库绑定 ASP.NET DataGrid控件链接列问题 ASP.NET DataGrid控件显示问题关于ASP.NET的DataGrid 显示 ASP.NET DataGrid 更新数据问题 ASP.NET DataGrid 更新数据问题 asp.net(C#)中DATAGRID问题 asp.net 将datagrid保存成为xml ASP.NET中的DataGrid控件的使用 DataGrid多行删除问题(ASP.NET)