Access DataBase & Textboxes

[bryan]

Does anyone know how to navigate and edit Access DB using textboxes?

Thanks

 

[cpopham]

What do you mean navigate Access using textboxes? Do you want to enter a string and then query Access with it? There are several methods that are invloved with editing any type of database. What are you wanting to do? Delete records, edit records or add new records, or do a combination of all the above?

We need a little more information and what type of Access database is it? 97 or 2000 / 2002?

Chester

 

[bryan]

Yes, thats what I wanted it to do, but I figured it out. Thanks anyway

 

[muaz]

Hi dears
I m new to this site.I have a problem, I make a table in access that is member table which have(codeno (primary key),employeeid,memberid,address,phoneno,designation) coloumns.Now i made a form for this in vb.net and i wanted to insert value for it but i draw a combobox for employeeid and memberid.from which i choose only one.wat code i used for this.pls anyone have idea give me response as soon as possible.
thanxs

 

[mzim]

Is your problem is loading data in the combobox? Or What?

i cant hardly understand your prob. mates"

 

[bryan]

I think He wants to have a combobox that has ID numbers for all employees, and when you click on it, some textboxes are filled with information on the employee id that was selected in the combobox

 

[mzim]

ah..ok thanks bryan if that so..
make a select statement..
in the selecteditem events of the combobox

[php]
  'cn is a connection
  dim cm as new sqlcommand("select * from sampletable where id =" & combobox1.selecteditem,cn)
  dim dr as Sqldatareader = cm.ExecuteReader
  while dr.read
  textbox1.text = dr(1)<---it gets the 2nd column of the table
  'and so on and soforth..
  end while
  dr.close()

[/php]

hope it helps..if not sorry for my stupidity

 

[muaz]

Hi dears
Tanx allot.I m very tankful to u.
bye