how do i search a value using combo box in vb.net

[sathyan8294]

i am using dotnet 2003.i am doing my project in vb.net windows application.i have two form in my project.first form is datagrid .In second form label,textboxes and combobox are avilable to save the entering values in datagrid of first form through this 2nd form.my problem is,i want to search a value using combobox.
for example,
in first form,
there are 4 columns named as name,age,rollno,address in datagrid.
values are ramu for namecolumn,24 for age column,42 for rollno column,cbe for address column.now values in datagrid like below
id name age rollno address
1 ramu 24 42 cbe
2 somu 23 32 che
here id is primary key.
in 2nd form,there are 4 label,4 textbox and 1 combobox.textbox arenamed as nametextbox,agetextbox,rollnotextbox,addresstextbo x and 1 combobox named as searchcombobox.
now values of name(ramu,somu) are stored in combobox.
my problem is,
in second form,
if i click the value ramu in combobox means,want to display the values of ramu in textboxes.(ie..want to display automatically ramu in nametextbox,24 in age textbox,42 in rollnotextbox,cbe in address textbox)
during runtime in vb.net windows application.so how i automatically display the values of row in each textbox by clicking the values in combobox.plz help me.

[dip_developer]

i am using dotnet 2003.i am doing my project in vb.net windows application.i have two form in my project.first form is datagrid .In second form label,textboxes and combobox are avilable to save the entering values in datagrid of first form through this 2nd form.my problem is,i want to search a value using combobox.
for example,
in first form,
there are 4 columns named as name,age,rollno,address in datagrid.
values are ramu for namecolumn,24 for age column,42 for rollno column,cbe for address column.now values in datagrid like below
id name age rollno address
1 ramu 24 42 cbe
2 somu 23 32 che
here id is primary key.
in 2nd form,there are 4 label,4 textbox and 1 combobox.textbox arenamed as nametextbox,agetextbox,rollnotextbox,addresstextbo x and 1 combobox named as searchcombobox.
now values of name(ramu,somu) are stored in combobox.
my problem is,
in second form,
if i click the value ramu in combobox means,want to display the values of ramu in textboxes.(ie..want to display automatically ramu in nametextbox,24 in age textbox,42 in rollnotextbox,cbe in address textbox)
during runtime in vb.net windows application.so how i automatically display the values of row in each textbox by clicking the values in combobox.plz help me.

I think you have these records in database.........
then bind the combobox with name and id.

populate a Dataset(say dsStudent ) with this sql query.....
SELECT id,name FROM mytable

then set the ValueMember and DisplayMember property of combobox like this

 
searchcombobox.DataSource=dsStudent 
' Suppose dsStudent is the DataSet name
searchcombobox.ValueMember ="id"
searchcombobox.DisplayMember ="name"
 

In the SelectedIndexChanged of the combobox retrieve the id and execute a sql statement like this...

 
dim student_id as string 
dim sql as string
student_id = CType(searchcombobox.SelectedItem, DataRowView).Row("id")
sql ="SELECT name,age,rollno,address FROM mytable WHERE
id='" & student_id & "'"
 

with the above sql populate a dataset(say dsSingleRecord)

Now bind the dataset(dsSingleRecord) with 4 textboxes like

 nametextbox.Text=dsSingleRecord.Tables(0).Rows(0).Item(0) 
agetextbox.Text=dsSingleRecord.Tables(0).Rows(0).Item(1)
rollnotextbox.Text=dsSingleRecord.Tables(0).Rows(0).Item(2)
addresstextbox .Text=dsSingleRecord.Tables(0).Rows(0).Item(3)