一个非常简单的问题,请大哥们帮忙
我要通过sqldataadapter一次将两个表studentinfo和kecheng放进dataset中(带条件xuanke1=变量a, kechengname=变量a),请帮我看看这段程序对不对,该如何修改
SqlConnection con = new SqlConnection(constring);
SqlDataAdapter da = new SqlDataAdapter("select * from studentinfo where xuanke1='" + a + "'"+"select * from kecheng where kechengname='"+a+"'", con);
DataSet ds = new DataSet();
da.Fill(ds,"studentinfo","kecheng");