Search results for query: *

is there anyway you can show that bit of code you posted in a generic form i dont quite understand how it works

what do you mean by use parameters instead of concatenating your SQL string.

ok it nolonger gives me an error but it doesn't add anything to the db am i missing something here? Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim objRow As DataRow 'Create a new DataRow object for this table objRow =...

i am having some trouble with my add btn PrivateSub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim objRow As DataRow cmd = New OleDbCommand 'Create a new DataRow object for this table objRow = ds.Tables("CarInfo").NewRow() 'Edit Each Field...

the only reason i am useing access is because it is a program i am just playing with and i got access for free from my parents lasy month secondly what would that command look like?

when i try to add data to a access db i get this error Update requires a valid InsertCommand when passed DataRow collection with new rows. here is the code once again Option Explicit On Imports System.Data Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form '...

all fixed thanks for the help i did get that all fixed and working now

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll this comes up when i try to run my program and dont know why here is the code below Imports System.Data Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form #Region "...