Error in Binding a value selected in dropdown to sql table

sri ranjani

Hi all,

I need to know how to pass the value selected from an unbound dropdown to tables

I've tow dropdowns one is for site and another is warehouse..

site is bounded and warehouse dropdown need to change based on the site selected change, here i can change the warehouse based on site but i am not able to pass the selected value to table

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

sri ranjani8y ago
I can change the dropdown values but i need to know how to pass this selected warehouse value to sql table, when I insert this value I'm getting an error warehouse field should not be empty
Jenith Thakkar8y ago
https://www.aspsnippets.com/Articles/Cascading-DropDownList-for-CountryStateCity-in-ASPNet.aspx

Please Check this Example For Cascading in VB.Net
sri ranjani8y ago
thanks, Jenith Thakkar
But i need to do in vb.net and below mentioned is my code, please check
sri ranjani8y ago
This is my design code:

TabIndex="6" AutoPostBack="True" DataSourceID="inventsite"
DataTextField="SITEID" DataValueField="SITEID" OnSelectedIndexChanged="sitedropdown_SelectedIndexChanged">

This is my vb code:

Protected Sub sitedropdown_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
Dim IdTxtsiteInsert As DropDownList = CType(DetailsView3.Rows(0).FindControl("TxtsiteInsert"), DropDownList)
Response.Cookies("sitedropdownvalue").Value = IdTxtsiteInsert.SelectedValue
Fillwarehouse(IdTxtsiteInsert.Text)
'Dim IdTxtWarehouseInsert As DropDownList = CType(DetailsView3.Rows(0).FindControl("TxtWarehouseInsert"), DropDownList)
'insertwarehouse(IdTxtsiteInsert.Text, IdTxtWarehouseInsert.Text)
End Sub
Public Sub Fillwarehouse(ByVal siteid As String)
'Dim IdTxtWarehouseInsert As DropDownList = CType(DetailsView3.Rows(0).FindControl("TxtWarehouseInsert"), DropDownList)
Dim ddr As DropDownList = CType(DetailsView3.Rows(0).FindControl("TxtWarehouseInsert"), DropDownList)
Dim strConn As String = WebConfigurationManager.ConnectionStrings("BMGINC_DYNAX09_ProdConnectionString").ConnectionString
Dim con As New SqlConnection(strConn)
Dim cmd As New SqlCommand()
cmd.Connection = con
cmd.CommandType = CommandType.Text
cmd.CommandText = "Select InventLocationId, Name from InventLocation where InventSiteId ='" & siteid & "'"
cmd.Parameters.AddWithValue("InventSiteId", siteid)
Dim objDs As New DataSet()
Dim dAdapter As New SqlDataAdapter()
dAdapter.SelectCommand = cmd
con.Open()
dAdapter.Fill(objDs)
con.Close()
If objDs.Tables(0).Rows.Count > 0 Then
ddr.DataSource = objDs.Tables(0)
ddr.DataTextField = "InventLocationId"
ddr.DataValueField = "InventLocationId"
ddr.DataBind()
ddr.Items.Insert(0, "-Select-")
Else
LblError.Text = "No Warehouse found"
End If
End Sub
Jenith Thakkar8y ago
You can do it with CasCading Dropdown
https://www.c-sharpcorner.com/UploadFile/sourabh_mishra1/cascading-dropdownlist-in-Asp-Net-mvc/
Please Check this example of Cascading Dropdown you can do it same this way