Question

.net中Dropdownlist绑定数据后怎么获得其数据的主键ID?

.net中Dropdownlist绑定数据后怎么获得其数据的主键ID?

<asp:DropDownList ID="TypeName" runat="server" DataSourceID="SqlDataSource1" DataTextField="TypeName" DataValueField="TypeName">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:digitalConnectionString %>"
SelectCommand="SELECT [TypeName], [ProductTypeID] FROM [ProductType]"></asp:SqlDataSource>

我想获取ProductTypeID然后填入另一个表

请教高手?

Answer 1

<asp:DropDownList ID="TypeName" runat="server" DataSourceID="SqlDataSource1" DataTextField="TypeName" DataValueField="ProductTypeID">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:digitalConnectionString %>"
SelectCommand="SELECT [TypeName], [ProductTypeID] FROM [ProductType]"></asp:SqlDataSource>

C#后台
int ProductTypeID=TypeName.selectvalue;

Answer 2

DataValueField="ProductTypeID"
这样设置后,用Dropdownlist的SelectedValue就可以得到所选择的TypeName所对应的
ProductTypeID了

Answer 3

Dropdownlist.SelectedValue为取得键值，也就是你所说的主键ID，DropDownList.SelectedItem.Text为取值。