如何通过下拉列表从表中获取ID到另一个表 [英] How to Get ID from Table to another table through dropdown

问题描述

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到另一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！