How To I Add A Record In A Database In VB?

[casualrich]

hi as some of you know i have this assignment where i have had to attach a database into a vb file I have now done this bit

but now i need to add a new record into table when VB is running

but im not sure on how to do it

here is my code

    Private Sub butadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butadd.Click
        Dim myconnection As OleDb.OleDbConnection
        Dim strSQL As String

        'this is using parameters 
        strSQL = "INSERT INTO Engineers " & _
        " (EngineerNO, Surname , Firstname, Mobileno) "

 

[jmcilhinney]

You create an OleDbCommand, assign you're SQL code to its CommandText property, add a parameter for each value you want to insert, then call its ExecuteNonQuery method. You'll need to open your connection first and close it again afterwards. You should start by reading the MSDN documentation for the OleDbCommand class. There are also plenty of ADO.NET tutorials on the Web.

 

[casualrich]

thanks for the replay but how well do i do this?

can you give me an example please?

 

[cjard]

Youre not allowed to use the Data Walkthroughs linked in my signature?