how do i display the company name starting with letter a in textbox

[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 and textboxes are avilable to save the entering values in datagrid of first form through this 2nd form.my problem is,in 2nd form,if i enter letter a in findtextbox and i click find button means,i want to display the values automatically (assyst in companynametextbox,vijay in contactpersontextbox,cbe in addresstextbox)in 2nd form.
for example,
in first form,
there are 4 columns named as companyname,contactperson,address in datagrid.
values are assyst for companynamecolumn,vijay for contactperson column,cbe for address column.now values in datagrid like below
companyname contactperson address
assyst vijay cbe

in 2nd form,there are 4 label and 4 textbox.textbox are named as findtextbox,companynametextbox,contactpersontextbo x,addresstextbox.
my problem is,
in second form,
if i enter letter a in findtextbox and i click find button means,i want to display the values automatically (assyst in companynametextbox,vijay in contactpersontextbox,cbe in addresstextbox)in 2nd form.
during runtime in vb.net windows application.so how i do these.plz help me.

[blackjack2150]

Use the OnChange event of your textbox to select the records starting with that letter(s).
You will have to use the "LIKE" clause in your SQL SELECT statement to get the values starting with a specific value:

SELECT * FROM TableName WHERE CompanyName LIKE 'A%'

NOTE: The wild card character('%' in my example) is different depending on the Database engine used. You'll have to do some research to find the value for your provider if it doesn't work with '%'.

[vanc]

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 and textboxes are avilable to save the entering values in datagrid of first form through this 2nd form.my problem is,in 2nd form,if i enter letter a in findtextbox and i click find button means,i want to display the values automatically (assyst in companynametextbox,vijay in contactpersontextbox,cbe in addresstextbox)in 2nd form.
for example,
in first form,
there are 4 columns named as companyname,contactperson,address in datagrid.
values are assyst for companynamecolumn,vijay for contactperson column,cbe for address column.now values in datagrid like below
companyname contactperson address
assyst vijay cbe

in 2nd form,there are 4 label and 4 textbox.textbox are named as findtextbox,companynametextbox,contactpersontextbo x,addresstextbox.
my problem is,
in second form,
if i enter letter a in findtextbox and i click find button means,i want to display the values automatically (assyst in companynametextbox,vijay in contactpersontextbox,cbe in addresstextbox)in 2nd form.
during runtime in vb.net windows application.so how i do these.plz help me.

In order to pass values between forms, you should look up delegate or attribute option. If you have a database running underneath, you should look up that database, this is much easier way to do this.
Try those ways, if it's still, give me a buzz.

Cheers.