Question

c#中 两张表联查怎么实现？

A 表中有字段id,x,y,pid,recordno,B表中有字段 name,id ,现在要根据b表中的name把a表中的所有字段查询并显示在datagridview上，如何实现？下面是我的代码：
cmd.CommandText = "select a.id,a.pid,a.x,a.y,a.recordno,b.name from road_local a,roadc1name_local b where b.id = a.id AND b.name = " + textBox2.Text + ""; //textBox2中输入要查询的名字
DataSet dts = new DataSet();
SqlDataAdapter dat = new SqlDataAdapter(cmd);
dat.Fill(dts);
//将查询结果显示在DataGridView上
dataGridView2.DataSource = dts.Tables[0];

Answer 1

cmd.CommandText = "select a.id,a.pid,a.x,a.y,a.recordno,b.name from road_local a join roadc1name_local b on b.id = a.id where b.name = '" + textBox2.Text + "";
或
cmd.CommandText = "select a.id,a.pid,a.x,a.y,a.recordno,b.name from road_local a where a.id in(select id from roadc1name_local b where b.name = '" + textBox2.Text + ")";

Answer 2

sql语句没问题的话， dataGridView2.DataBind();

Answer 3

调试，然后复制你的SQl语句到数据库中试验一下看看是不是你的SQL语句有问题