Ad:

VB.NET Discussion Thread
Unsolved
Views: 3598

Feb 25th, 2009

combobox and textbox

Expand Post »

I have a sql table consisting of dept_name and dept_code.and on the form i have textbox for dept_code and combobox for dept_name.When i select a particular dept_name from the combobox i should get the corrosponding dept_code in the textbox.

Similar Threads

How to change a textbox to a dropdown with Drop Down Menu in HTML and CSS
how can i display data in textbox from choosen dropdown menu? in VB.NET
how to get binded combobox selected item? in C++
retreive data in textbox in C#
VB.NET ComboBox & Statusbar HELP! in VB.NET

kritiohri

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Feb 25th, 2009

Re: combobox and textbox

Hi,

it should be easy;

show me your codes;

good luck;

Bandar.M.A

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

18 posts
since Feb 2009

Permalink

Feb 25th, 2009

Re: combobox and textbox

I dont have the code .The combox contains the dept_names and i want the cprrosponding value that is the dept_no in the yextbox.iam able to save the values.

kritiohri

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Feb 25th, 2009

Re: combobox and textbox

Ok

in Combobox event changeindex (or something like that)
try to send Sql statement with the value you get then
put the result in your textbox

Bandar.M.A

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

18 posts
since Feb 2009

Permalink

Feb 25th, 2009

Re: combobox and textbox

use data binding.

There are many guides or examples on this, but i googled and this is the first result i got.

http://www.startvbdotnet.com/ado/Simplebinding.aspx

jbrock31

Reputation Points: 22

Solved Threads: 14

Junior Poster in Training

Offline

73 posts
since Oct 2008

Permalink

Feb 25th, 2009

Re: combobox and textbox

first is what field is your primary key? is it the dept_code or dept_name?

Quote ...

When i select a particular dept_name from the combobox i should get the corrosponding dept_code in the textbox.

Now, what you want is a little bit complicated WHEN your primary is the dept_code.

Why? because if your primary is dept_code then it is very possible that there will be the same department name but have different code. right? so ergo, if you are going to select a department name the department code to be return will be the first department code saved in the database, thus you are not sure that the department code you are looking is the correct one.

regards.

jireh

Reputation Points: 11

Solved Threads: 49

Posting Whiz

Offline

316 posts
since Jul 2007

Permalink

Feb 27th, 2009

Re: combobox and textbox

Hello,
I am Not as good as all of you but i tried with this, and i am agree with jireh.

And After I try i am at following :-

First Declare Con as Connection

VB.NET Syntax (Toggle Plain Text)
Private sub Combobox1_selectedindexchanged(byval sender As System.object, ByVal e as system.eventargs) Handles Combobox1.Selectedindexchanged
'(declare con as connection)
Dim Da as New OledbDataAdapter
Dim Ds As New Dataset
Dim Dt As DataTable
Try
Da=New OledbDataAdapter("Select * from Tablename where DeptName="& Combobox1.SelectedItem & "",Con)
Da.fill(Ds, "TableName")
Dt = Ds.Tables("TableName")
Catch ex As Exception
Messagebox.show(ex.Message)
End Try
Textbox1.Text = Dt.Rows.Item(0).Item(0)
End sub
Private sub Combobox1_selectedindexchanged(byval sender As System.object, ByVal e as system.eventargs) Handles Combobox1.Selectedindexchanged
'(declare con as connection)
Dim Da as New OledbDataAdapter
Dim Ds As New Dataset
Dim Dt As DataTable
Try
Da=New OledbDataAdapter("Select * from Tablename where DeptName="& Combobox1.SelectedItem & "",Con)
Da.fill(Ds, "TableName")
Dt = Ds.Tables("TableName")
Catch ex As Exception
Messagebox.show(ex.Message)
End Try
Textbox1.Text = Dt.Rows.Item(0).Item(0)
End sub

Praniya

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Help in Crystal report

Next Thread in VB.NET Forum Timeline: E-mail a PDF file from MS Access 2003

DaniWeb Message

Cancel Changes

User Name
Password