select top 5 * from Orders select OrderID,Products,ProductName,[order Details].Unitprice,[order details].QUantity from [order Details],Products where [Order Details].ProductID=products.ProductID数据库是SQL2000 NORTHWIND里面的,好像是三个表,这个SQL能解释一下马。
调试欢乐多
再从新的数据源中取5条数据
应该这样理解:
select top 5 *
from Orders,(select OrderID,Products,ProductName,[order Details].Unitprice,[order details].QUantity from [order Details],Products )--查询结果当做一个表来供其他的查询,这里可以取个别名的
where [Order Details].ProductID=products.ProductID
应该这样理解
select top 5 *
from
Orders(select OrderID,Products,ProductName,[order Details].Unitprice,[order details].QUantity
from [order Details],Products
where [Order Details].ProductID=products.ProductID)--将查询的结果作为另一个查询的表了,Orders为这个表的别名
string strConn=ConfigurationSettings.AppSettings["itschoolconn"];
myConnection.ConnectionString=strConn;
string strSQL="select top 5 * from Orders select OrderID,Products,ProductName,[order Details].Unitprice,[order details].QUantity from [order Details],Products where [Order Details].ProductID=products.ProductID
";
SqlDataAdapter da=new SqlDataAdapter(strSQL,myConnection);
DataSet ds=new DataSet();
da.Fill(ds);
ds.Tables[0].TableName="bbsreforum";
ds.Tables[1].TableName="student";
DataColumn Parent=ds.Tables["bbsreforum"].Columns["sno"];
DataColumn Child=ds.Tables["student"].Columns["sno"];
DataRelation tableRelation=new DataRelation("tableRelation",Parent,Child,false);
ds.Relations.Add(tableRelation);
DataGrid1.DataSource=ds.Tables["bbsreforum"].DefaultView;
DataGrid1.DataBind();
"select top 5 * from Orders
select OrderID,Products.ProductName,[order Details].Unitprice,[order details].QUantity from [order Details],Products where [Order Details].ProductID=products.ProductID";
select OrderID,Products.ProductName,[order Details].Unitprice,[order details].QUantity from [order Details],Products where [Order Details].ProductID=products.ProductID查出详细订单中供应商id,产品名称,单价,数量.
我也用过,能行的