Write data in VB.NET to Access using SQL

Question

Okay,  I have an Administrator page that is able to create new users.  I have a simple adduserform that has a TabControl added in it with a tab for General Info and User Info.  Those have quite a few texboxes for input and outside of the TabControl are 3 buttons that are Save, Clear, and Exit.  What I want to do is have the Save write the data to my small database that I have for users.  If you want to see an example of my screen you can see it here.... http://redbearcustoms.no-ip.info/VB/adduserform.html

Answer 1

well the link doesn't work.... lol

so let me get this straight, you want to write data to a database correct? Which database? MS Access or SQL?

either way, there are a good few examples and snippets on these forums - you may wish to do a quick search but of course, we are more than happy to post code for your needs if you can tell us if its actually SQL you are using (just to add, which version?) or MS Access

Answer 2

Okay, sorry bout the link.  My server went down last night and I haven't had time to bring it back up. 

Now for the database, Im currently writing it in MS Access but I want to eventually convert it over to SQL(MySQL) if I have time.

My professor said what I want to do is not possible with MS Access but I know it is and he said i didn't have enough experience with VB to write something to use SQL.  i want to prove him wrong. 

I would greatly appreciate any help.

 

Thanks,

 QWERTYtech

Answer 3

you can insert data and read data into a database without any problems. Is this what you are pretty much ultimately after? You can use Access or SQL to do this job. code snippets can be posted without any problems :-)

Answer 4

Yes, I was wondering if there was any way that I could post a picture of my screens without having to link to another site.

 

Answer 5

I dont think these forums yet have a feature to attach a picture but only links to a picture.

As for inserting into database, this is not a problem. Here is a small snippet of code which will insert data into an MS Access database. Import the System.Data.OleDb namespace to make this work

Now, the code supplied is just a snippet. You need to adjust the fields to insert into, the table name, the values, datatypes etc.... in order to make it work. The fieldnames and datatypes must match from the database into the code below as otherwise you would get an exception thrown stating that the datatypes are not correct or can't insert into a column

 

Dim theOleDbConnection as new OleDbConnection("ConnectionStringHere") Dim theOleDbCommand as new OleDbCommand("INSERT INTO [tableName] (field1, field2) VALUES (@p1, @p2)") theOleDbCommand.Connection = theOleDbConnection   Dim theParameter as new OleDbParameter("@p1", OleDbType.VarChar, Length) theParameter.Value = "ValueHere"   Dim theParameter2 as new OleDbParameter("@p2", OleDbType.VarChar, Length) theParameter2.Value = "ValueHere"   theOleDbCommand.Parameters.Add(theParameter) theOleDbCommand.Parameters.Add(theParameter2)   theOleDbCommand.Connection.Open() theOleDbCommand.ExecuteNonQuery() theOleDbCommand.Connection.Close()

 

The code will: