VB.Net SQL Databases- How to Save Changes to Database?

Question

My database program is fully functional and when I add new entries to the database they appear on my DataGridView correctly. However after I close the program these changes are not saved. How do I save the changes back to the database? Here's my code:

    Dim conn As New SqlClient.SqlConnection(My.Settings.MainDatabaseConnectionString)
    Dim query As String = "INSERT INTO Users VALUES('Something','Test');"
    Dim cmd As New SqlClient.SqlCommand(query, conn)
    Dim reader As SqlClient.SqlDataReader

    'Open Connection
    conn.Open()
    'Execute Query
    reader = cmd.ExecuteReader
    'Close Connection
    conn.Close()

    'Update DataGridView
    Me.UsersTableAdapter.Fill(Me.UsersDataSet.Users)

paulsm4 · Accepted Answer · 2011-07-22 04:51:45Z

3

As you've discovered, you need more the a reader :)

There are many ways to go. This link gives a reasonable example:

http://msdn.microsoft.com/en-us/library/ms972948.aspx

The key thing:

To start, the GridView's SqlDataSource must contain an UpdateCommand with appropriate parameters.

answered Jul 22, 2011 at 4:51

paulsm4

123k23 gold badges175 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bash- · Accepted Answer · 2011-07-22 05:11:12Z

0

If you want to insert something into the DB you can do this

Dim mySQLCommand As Data.SqlClient.SqlCommand
mySQLCommand.CommandText = "INSERT INTO Users VALUES('Something','Test');"
mySQLCommand.ExecuteNonQuery()

you might also want to parameterize your variables to prevent sql injections

mySQLCommand.Parameters.Add("@variable_name", SqlDBType.NvarChar).value = variable

and using @variable_name in the insert

mySQLCommand.CommandText = INSERT INTO Users VALUES(@variable_name, @variable_name2)

answered Jul 22, 2011 at 5:11

bash-

6,33410 gold badges45 silver badges51 bronze badges

Collectives™ on Stack Overflow

VB.Net SQL Databases- How to Save Changes to Database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related