store in database if value is other dept from textbox.

Bhavesh Vankar

Records are being saved from the combobox. But if the value of the combobox is in other department, then how can the value of the textbox be saved in the same column instead of the combobox?

exa.

if i have combo1 in combo 1 their is 34 department and 35th department is "other department"

if i select other department in combo1 then textbox should be enable and whatever i enter in textbox name of department it should be save in same column in table instead of combo1

5 Replies

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

Amit Gupta5y ago
Accepted answer
As we are unaware about the scenario of your project (how you are doing), we can just help you out with the current issue..

You can check with the combox text/bindedID/index (how you have binded the value from the db),

in case of text
txtOtherDeptName.Enabled = comDept.Text == "Other Department";

or, in case of index
txtOtherDeptName.Enabled = comDept.SelectedIndex == comDept.Items.Count;

or, in case with your binded ID (Department ID)
txtOtherDeptName.Enabled = comDept.SelectedValue ==

Do let us know, if you need any clarification or elaborate your project scenario to give you the optimized solution
+2
Bhavesh Vankar5y ago
thanks for your kind reply its working in my project thanks.....
+2
Bhavesh Vankar5y ago
i have tried below code but not working....it storing only combobox value...
if (my other condition) then
...
else
K.Parameters(10).Value = Combo1.Text
end if
  if Combo1.Text = "OTHER DEPARTMENT" Then
  K.Parameters(10).Value = txtdeptother.Text
End If
+2
Bhavesh Vankar5y ago
whetever mean in combobox only 34 department name 35th name is Other Department when user select other department then textbox should be enable and user should enter manualy department name in textbox and that textbox value should be store in same column in table.
+2
Amit Gupta5y ago
Can you elaborate?
whatever i enter in textbox name of department it should be save in same column in table instead of combo1
+2