网上查了一下,GridView不能绑定2个数据,那我要实现代码所示功能,该如何解决?<body>
    <form id="form1" runat="server">
    <div>
        请选择省份:<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" Width="112px">
            <asp:ListItem>请选择</asp:ListItem>
            <asp:ListItem>厦门</asp:ListItem>
            <asp:ListItem>北京</asp:ListItem>
            <asp:ListItem>上海</asp:ListItem>
        </asp:DropDownList>
        <asp:Button ID="Button1" runat="server" Text="提交" onclick="Button1_Click" />
        <p></p>
    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="ID" DataSourceID="SqlDataSource1" EnableModelValidation="True">
        <Columns>
            <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                ReadOnly="True" SortExpression="ID" />
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
            <asp:BoundField DataField="Address" HeaderText="Address" 
                SortExpression="Address" />
            <asp:BoundField DataField="TelePhone" HeaderText="TelePhone" 
                SortExpression="TelePhone" />
            <asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ProductConnectionString %>" 
        SelectCommand="SELECT * FROM [UserInfo]"></asp:SqlDataSource>
    </form>
</body>using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strConn = ConfigurationManager.ConnectionStrings["ProductConnectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection(strConn);
        SqlCommand cmd = new SqlCommand(strConn, conn);
        SqlDataAdapter myda = new SqlDataAdapter();
        DataSet ds = new DataSet();
        try
        {
            conn.Open();
            cmd.Connection = conn;
            string Address = DropDownList1.SelectedItem.ToString();
            cmd.CommandText = "select ID,Name,Sex,Age,TelePhone from UserInfo where Address=@Address";
            myda.SelectCommand = cmd;            //定义参数
            SqlParameter mypara = new SqlParameter();
            mypara.ParameterName = "@Address";
            mypara.Value = Address;
            cmd.Parameters.Add(mypara);
            myda.Fill(ds);//填充数据
            if (ds.Tables[0].Rows.Count > 0)
            {
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataBind();
            }
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
    }
}