本文介绍了如何通过下拉列表从表中获取ID到另一个表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
using (SqlCommand cmd = new SqlCommand("SELECT Id, Location FROM Location")) { cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); location.DataSource = cmd.ExecuteReader(); location.DataTextField = "Location"; location.DataValueField = "Id"; location.DataBind(); con.Close(); } location.Items.Insert(0, new ListItem("--Select Location--", "0"));
位置表 Id位置 1美元 2英国 3阿联酋 用户表 Id名称位置 1 XYZ 0 2 UXA 0
Location Table Id Location 1 US 2 UK 3 UAE User Table Id Name Location 1 XYZ 0 2 UXA 0
cmd1.Parameters.AddWithValue("@Location", location.Text);ASP代码在这里
The ASP code is here
<asp:DropDownList ID = "location" runat="server" CssClass="formcss" Width="100%"> </asp:DropDownList>我的问题是如何将所选位置的ID存储到用户表中。通过给定的代码,我在所有插入数据行中得到0。请帮助
My Problem is that how do i store id of selected location into user table . By the given code i get 0 in all the row of inserted data . Please Help
推荐答案你必须在回发时绑定dropdownlist的值。 U have to bind the value of dropdownlist on postback. If(!IsPostBack) { LocationBind(); } Public void Location() { cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); location.DataSource = cmd.ExecuteReader(); location.DataTextField = "Location"; location.DataValueField = "Id"; location.DataBind(); con.Close(); }
并且还传递值
and also pass the value
cmd1.Parameters.AddWithValue("@Location", location.SelectedValue);
使用它 - use this- cmd1.Parameters.AddWithValue("@Location", location.SelectedValue);
更多推荐
如何通过下拉列表从表中获取ID到另一个表
发布评论