网上查了一下,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();
}
}
}
}
<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();
}
}
}
}
解决方案 »
- IE打印
- 用GridView和detailsView实现主/从视图?!
- c#能否判断程序是否在u盘中???
- 新手请教下自己写的类的问题
- 关于 人民网。 简体中文、繁体中文 显示切换。
- 微软官方给出的正则表达式怎么回事???
- DataGrid怎么实现点中一行即选择一行编辑,而不用添加一个选择按钮列?
- 如何自动取得SQLCommand中SQL语句的参数个数及类型?
- textbox的问题,我想实现一个调用text_changed的事件,还不想刷新画面。服务器端有数据库处理。急急急急!!!!!!!!!
- XML请教
- 关于response.write输出button控件,求帮忙
- 提示错误:Both DataSource and DataSourceID are defined on 'GridView1'.
{
GridView1.DataSourceID=null;
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}