how to write in access(mdb) file. adox

Question

User-1328385175 posted

hi .

there are an access file . >> "test_file.mdb" 

there are a table in mdb file .>> "test_table1"

and  there are 2 columns in "test_table1" >> "name" and "age"

and i have 2 textbox in my web form . >> "textbox_name" and "textbox_age"

and i have a button for save textbox_name.text and textbox_age.text in mdb file .

i need adox vb code for save textboxs data in mdb file .

plz help me

Answer 1

User-1675817941 posted

hi,

here is the answer for your queries

http://msdn.microsoft.com/en-us/library/aa140021(v=office.10).aspx

http://www.codeguru.com/vb/gen/vb_database/microsoftaccess/article.php/c5149

Thanks,

Answer 2

User-1199946673 posted

To Create, Read, Update and Insert data, you should use OleDb, Not Adox. A good article can be found here:

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

By the way, in general, storing a age in an database isn't smart, because ages change, birth of date doesn't and with this you can always calculate the age. More on the ins and out on dates and Access can be found here:

http://www.mikesdotnetting.com/Article/92/MS-Access-Date-and-Time-with-ASP.NET

And you can find more articles of Mike regarding Access and ASP.NET here:

http://www.mikesdotnetting.com/Category/10

Answer 3

User-1199946673 posted

here is the answer for your queries

http://msdn.microsoft.com/en-us/library/aa140021(v=office.10).aspx

http://www.codeguru.com/vb/gen/vb_database/microsoftaccess/article.php/c5149

 

When you decide to answer on questions, maybe it's nice if you read more carefull. Although in the question he's specificaly asking for ADOX, he's also telling WHAT he would like to do, which is saving data into an Access database.  When you read the articles, you'll notice that ADOX is used for creating Access databases and tables etc (DDL = Data Definition Language). not for storing data in them (DML = Data Manipulation Language).

I get the impression you just googled on ADOX, without reading the result you found!

Answer 4

User-1328385175 posted

very thank your from you'r help .