我怎么能在一个单一的数据集使用两个或两个以上的表

Shobana16:试试这个，codeprelang="SQL"spanclass="code-keyword"create/spanspanclass="code-keyword"procedure/spanspDatasetspanclass="code-keyword"as/spanspanclass="code-keyword"begin/spanspanclass="code-keyword"select/span*spanclass="code-keyword"from/spantblCountryspanclass="code-keyword"select/span*spanclass="code-keyword"from/spantblCityspanclass="code-keyword"end/span/pre/code在CS页面codeprelang="c#"spanclass="code-keyword"protected/spanspanclass="code-keyword"void/spanPage_Load(spanclass="code-keyword"object/spansender,EventArgse){connection();cmd.CommandType=CommandType.StoredProcedure;cmd=spanclass="code-keyword"new/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"spDataset"/span,conn);da=spanclass="code-keyword"new/spanSqlDataAdapter(cmd);da.Fill(ds);GridView1.DataSource=ds.Tables[spanclass="code-digit"0/span];spanclass="code-comment"///spanspanclass="code-comment"Forfirstselectquery(table)inStoredprocedure,thatisselect*fromtblCountry/spanGridView1.DataBind();GridView2.DataSource=ds.Tables[spanclass="code-digit"1/span];spanclass="code-comment"///spanspanclass="code-comment"Forfirstselectquery(table)inStoredprocedure,thatisselect*fromtblCity/spanGridView2.DataBind();}/pre/code
乌玛尚卡尔帕特尔

看到这个讨论imgsrc=
KARTHIK Harve:你可以使用这样..表内的数据集

foreach(DataTable dt in ds.Tables)

{

    Console.WriteLine(dt.Rows[0][1].ToString());

}

查询更多这里..

{A}
{A2}
{A3的}

希望它可以帮助..

{体C3}