|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
adding records to an access dbI have an unbound form with two fields,
Date and Name. I want to enter text in theese two fields and then click a button to add the text in a row in an Access db. What is the easiest way to do this? reidarT Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data
Source=<database path here>") Dim cmd As New OleDb.OleDbCommand("INSERT statement here", con) Try con.open cmd.ExecuteNonQuery Catch ex As OleDbException 'error handling here Finally con.close End Try Show quoteHide quote "reidarT" <rei***@eivon.no> wrote in message news:OVEOCohmGHA.4164@TK2MSFTNGP03.phx.gbl... >I have an unbound form with two fields, > Date and Name. > I want to enter text in theese two fields and then click a button > to add the text in a row in an Access db. > What is the easiest way to do this? > reidarT >
OpenFileDialog
how to search a datatable-can I use sql on a vb2005 datatable? How to filter by File Type ? CHM file with .NET Navigate through a dataset Default MessageBox Title Delegates: String or Integer System.Management VS WbemScripting Adding new row to table in DataGridView Problem with OpenFile dialog |
|||||||||||||||||||||||