Question

怎样同时绑定两张表中的数据?ASP.NET

哪位帮帮忙，急！

Answer 1

string connstr = ConfigurationManager.ConnectionStrings["adventureWorks"].ConnectionString;
DataSet ds,ds1;
using (SqlConnection conn = new SqlConnection(connstr))
{
string sql = "select * from ContactType";
string sql1= "select * from News";
ds = new DataSet();
ds1=new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
SqlDataAdapter adapter1=new SqlDataAdapter(sql1,conn);
adapter.Fill(ds);
adapter1.Fill(ds1);
ds.Merge(ds1);

}
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

Answer 2

问题是在是太牛了....... 什么同时绑定两个表。。。SQL语句合成一个表查询出来 不就行了