如何通过下拉列表从表中获取ID到另一个表

本文介绍了如何通过下拉列表从表中获取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);