这里有很多U3D资源、U3D培训视频、U3D教程、U3D常见问题、U3D项目源码,我们致力于打造业内unity3d培训、学习第一品牌
第一步:这是我弄得三个表
第二部:连上关联
第三部:控制台代码
public ArrayList UsersSelectOrse()
{
ArrayList list = new ArrayList();
SqlConnection con = new SqlConnection("server=.;Trusted_Connection=SSPI;database=Restaurant");
string sql = "select Users.name,Food.name,Food.price,Ordering.number from Ordering"+
" inner join Users on Users.id=Ordering.uid"+
" inner join Food on Food.id=Ordering.eid";
这个是多表查询的语句,
SqlCommand com = new SqlCommand(sql, con);
con.Open();
SqlDataReader re = com.ExecuteReader();
while (re.Read())
{
Users u = new Users();
u.Name = (string)re.GetValue(0);
Food f = new Food();
f.Name = (string)re.GetValue(1);
Food f1 = new Food();
f1.Price = (decimal)re.GetValue(2);
Orde o = new Orde();
o.Number = (int)re.GetValue(3);
list.Add(u);
list.Add(f);
list.Add(f1);
list.Add(o);
和普通查询差不多,就是在这里需要调用多个表的属性,加进集合里去
}
return list;
}
输出语句:
ArrayList list2 = new ArrayList();
list2 = new Orde().UsersSelectOrse();
IEnumerator it = list2.GetEnumerator();
while (it.MoveNext())
{
Users u = (Users)it.Current;
it.MoveNext();
Food f = (Food)it.Current;
it.MoveNext();
Food f1 = (Food)it.Current;
it.MoveNext();
Orde o = (Orde)it.Current;
Console.WriteLine("用户名:" + u.Name + " 菜名:" + f.Name + " 单价:" + f.Price + " 数量:" + o.Number);
}