Error in Binding a value selected in dropdown to sql table

Question

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

sri ranjani · Answer

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 Thakkar · Answer

https://www.aspsnippets.com/Articles/Cascading-DropDownList-for-CountryStateCity-in-ASPNet.aspx Please Check this Example For Cascading in VB.Net

sri ranjani · Answer

thanks, Jenith Thakkar But i need to do in vb.net and below mentioned is my code, please check

sri ranjani · Answer

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 Thakkar · Answer

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

Error in Binding a value selected in dropdown to sql table

Answers (5)