我想跟你的第一句有关 string SQL = "SELECT * FROM Employees ;"+"SELECT * FROM Orders"; 我还没有这样用过.你不如将代码改成如下,应该就不会出错了: string SQL = "SELECT * FROM Employees"; SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection); da.Fill(dataSet1,"Employees");string SQL = "SELECT * FROM Orders"; SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection); da.Fill(dataSet1,"Orders"); 再看一下,该有所不同了
如果我不自己为表命名,而用下面语句:string SQL = "SELECT * FROM Employees ;"+"SELECT * FROM Orders";SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection);da.Fill(dataSet1);dataGrid1.SetDataBinding(dataSet1,"Table");//显示Employees内容 dataGrid1.SetDataBinding(dataSet1,"Table1");//显示Orders内容上面你用的是MAP,相当于为默认的Table,Table1两个表重命名。实际是一样的,取了别名而已。 为什么 string SQL = "SELECT * FROM Employees ;"+"SELECT * FROM Orders";SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection);da.Fill(dataSet1,"Employees"); da.Fill(dataSet1,"Orders");dataGrid1.SetDataBinding(dataSet1,"Order"); dataGrid1.SetDataBinding(dataSet1,"Employees");显示的都是Employees的内容?想知道我第二个SELECT返回的结果到哪里去了?这个时候我再用dataGrid1.SetDataBinding(dataSet1,"Table1");想显示第二个SELECT返回的结果都说表Table1不存在了。
string SQL = "SELECT * FROM Employees ;"+"SELECT * FROM Orders";
我还没有这样用过.你不如将代码改成如下,应该就不会出错了:
string SQL = "SELECT * FROM Employees";
SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection);
da.Fill(dataSet1,"Employees");string SQL = "SELECT * FROM Orders";
SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection);
da.Fill(dataSet1,"Orders");
再看一下,该有所不同了
da.TableMappings.Add("Table", "Employees");
da.TableMappings.Add("Table1", "Orders");
da.Fill(dataSet1);
这时候你再试一下,一定会有以外的发现。:)
da.TableMappings.Add("Table", "Employees");
da.TableMappings.Add("Table1", "Orders");
da.Fill(dataSet1);
这时候你再试一下,一定会有以外的发现。:)
dataGrid1.SetDataBinding(dataSet1,"Table1");//显示Orders内容上面你用的是MAP,相当于为默认的Table,Table1两个表重命名。实际是一样的,取了别名而已。
为什么 string SQL = "SELECT * FROM Employees ;"+"SELECT * FROM Orders";SqlDataAdapter da = new SqlDataAdapter(SQL,thisConnection);da.Fill(dataSet1,"Employees");
da.Fill(dataSet1,"Orders");dataGrid1.SetDataBinding(dataSet1,"Order");
dataGrid1.SetDataBinding(dataSet1,"Employees");显示的都是Employees的内容?想知道我第二个SELECT返回的结果到哪里去了?这个时候我再用dataGrid1.SetDataBinding(dataSet1,"Table1");想显示第二个SELECT返回的结果都说表Table1不存在了。