欢迎大家光临我的博客!
今天主要练习了一下多表连接查询
一、内连接查询:
select u.name,u.sex,c.name,c.price from users_commodity as uc
inner join users as u on uc.uid =u.id
inner join commodity as c on uc.cid=c.id
这里就用到了集合
public ArrayList SelectUsersCommodity()
{
ArrayList list = new ArrayList();
SqlConnection con = new SqlConnection("server=.;database=Market;Trusted_Connection=SSPI");