GridView与下拉菜单选择数据的问题

bg8crv 2007-05-30 08:24:08

各位老鸟，你好！~

小弟在学习asp.net的过程中遇到了一个问题，我在页面上放了一个GridView，在放上一个下拉控件，一个按钮控件，我想让下拉控件里面显示数据库的表的序号，选中一个序号后，点按钮，就可以将那条记录显示在GridView里面，请问应该怎么做呢？

谢谢！~

我今天做了一天都没整出来，请各位在给我讲讲可以吗？

...全文

315 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

bg8crv 2007-06-01

打赏
举报

濡傛灉鎴戣鍔犱竴涓狟utton鍛紵

璁╁畠浠嶵extBox閲岄潰鑾峰彇瀛楃涓诧紝鐒跺悗鐐笲utton浠ュ悗锛屽湪GridView閲屾樉绀烘煡璇㈢殑鏁版嵁锛岃兘鏁欐暀鎴戝悧锛

codeangel 2007-06-01

打赏
举报

1.将你的ID字段绑到DropDownList上
2.选一个项目，然后做查询，把查询的结果绑到gridview上

guyue1986 2007-06-01

打赏
举报

<asp:DropDownList ID="DropdownlistL" runat="server" Height="16px" Width="80%" DataSourceID="ObjectDataSource1"
DataTextField="fullname" DataValueField="id" OnDataBound="DropdownlistL_DataBound"
OnSelectedIndexChanged="DropdownlistL_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="Query"
TypeName="Entity.Category">
<SelectParameters>
<asp:ControlParameter ControlID="TextL" Name="strCondition" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
可以做出下拉框
然后在查询这条内容就好了

guyue1986 2007-06-01

打赏
举报

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
DataTextField="ID" DataValueField="ID" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"
Width="206px">
</asp:DropDownList>
可以做出下拉框
然后在查询这条内容就好了

playzxw 2007-06-01

打赏
举报

既然是不同的表，必须用DataGrid的自动增加列设置为True

antiking 2007-06-01

打赏
举报

<asp:DropDownList ID="ddlNewsType" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlNewsType_SelectedIndexChanged">
<asp:ListItem Value="0" Text=""></asp:ListItem>
<asp:ListItem Value="1">A</asp:ListItem>
<asp:ListItem Value="2">B</asp:ListItem>
<asp:ListItem Value="3">C</asp:ListItem>
<asp:ListItem Value="4">D</asp:ListItem>
</asp:ListItem>
</asp:DropDownList>
protected void ddlNewsType_SelectedIndexChanged(object sender, EventArgs e)
{
sql="select * from table where condition='"+ddlNewsType.SelectedText.ToString()+"'";
GridviewBind(sql);
}

private void GridviewBind(string sql)
{
conn.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
myda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

amandag 2007-05-30

打赏
举报

//不用后台代码，要用你那点不大够用

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
<style type="text/css">

</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
<asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
<asp:BoundField DataField="LeiBie" HeaderText="LeiBie" SortExpression="LeiBie" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:FaYuanDBConnectionString %>"
SelectCommand="SELECT * FROM [LoginTable] WHERE ([id] = @id)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" DefaultValue="1" Name="id" PropertyName="SelectedValue"
Type="Byte" />
</SelectParameters>
</asp:SqlDataSource>
</div>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
DataTextField="id" DataValueField="id"
>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:FaYuanDBConnectionString %>"
SelectCommand="SELECT [id] FROM [LoginTable]"></asp:SqlDataSource>
</form>
</body>
</html>

bg8crv 2007-05-30

打赏
举报

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
this.GridView1.DataBind();
}

这是我写的东西，麻烦看看

bg8crv 2007-05-30

打赏
举报

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<br />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
<asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
<asp:BoundField DataField="LeiBie" HeaderText="LeiBie" SortExpression="LeiBie" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:FaYuanDBConnectionString %>"
SelectCommand="SELECT * FROM [LoginTable]"></asp:SqlDataSource>

</div>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
DataTextField="ID" DataValueField="ID" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"
Width="206px">
</asp:DropDownList>
</form>
</body>
</html>