各位大牛:我想实现一个多表查询的一个结果集怎么放到dataset里阿?
Dataset1 myset = new Dataset1();
//string strSql = "select * from A ,B where A.a1=B.b1";
try
{
string strCnn = "Server=.;Database=A;uid=sa; password=sa";
SqlConnection conn = new SqlConnection(strCnn);
SqlDataAdapter dataadpter = new SqlDataAdapter(strSql,strCnn);
//dataadpter.Fill(??)
单表的时候可以dataadpter.Fill(myset,"表名");
可是我这里涉及到2个表Fill方法的参数怎么写啊?
catch(Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
finally
{
conn.Close();
}
CrystalReport1 test = new CrystalReport1();
test.SetDataSource(myset);
crystalReportViewer1.ReportSource = test;