Submitting to a Database

[wwechopper1]

I a trying to submit data from a windows form to a .mdb database. What code is required to do this?

 

[JurkMonkey]

http://www.csharphelp.com/archives/archive70.html

Welcome to the world of DBs. As a recommendation from me, seriously consider using MySQL or some other alternative to access. Access grows like crazy for no reason.

 

[wwechopper1]

JurkMonkey,

Do you have any other solution because that did not solve my problem

 

[JurkMonkey]

The basic idea is:

1. Connect to the DB using a connection string (

http://www.connectionstrings.com/)

2. Create command builders for the insert statement

3. Create a dataset and add some rows

4. Submit your dataset to the DB


If you use MySQL there is a .Net connector that is much easier to use but runs on similar steps.


If you have to use Access - just google C# Access DB Tutorial and you will find lots.

 

[AlexCuse]

WWEChopper -

Welcome to tek-tips. I think you would do well to read this FAQ on effective forum participation. faq222-2244

If you get an answer that does not work, you can post back to the same thread. There is no need to start a new one. Good luck with your database issue!

Alex

Ignorance of certain subjects is a great part of wisdom