-
B
Hard Coded SQL Select Statement?
. I was not planning to use a data adapter but rather send the sql statement to access straight via oledb.command are you saying i do something like SelectStatement.fill ? Thanks as always. -
B
Hard Coded SQL Select Statement?
1. Much like my last question I simply want to send a sql statement to my access db..this time instead of executing an insert i want results form a select statement... now I know how to set up the connex and proper syntax,,, my question is instead of .executenonquery what do I use? 2. Once I... -
B
.Addnew only works the first time
thanks Solved so far... Will make a new thread if I encounter any other issues. -
B
.Addnew only works the first time
Thanks! TechG, It is telling me that there is something wrong with my connection string. Could you take a look at that as well please =) Your example shows going to sql server and mine is to jet 4.0 for MS Access I tried to improvise but its telling me it doesnt recognize provider... -
B
.Addnew only works the first time
ok PrivateConst MyCONNECTIONSTRING AsString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=final4600.mdb" ------------------------------------------ Dim DBConnection AsNew SqlClient.SqlConnection(MyCONNECTIONSTRING) Dim strSQL AsString Dim strVidId AsString Dim strRentalNo AsString Dim... -
-
B
.Addnew only works the first time
=) Good deal I will try looking through your ado stuff. The text boxes I am moving data to,, are invisible controls that have data bindings to a data set. -
B
.Addnew only works the first time
Solved -- .Addnew only works the first time SOLVED I can post code if needed but its rather long,,, anyhow, I am trying to update my orderline table one line at a time using the .addnew method. the first insert works find, the second time I use the .addnew method it tells me... -
B
How to retrieve data from a MS Access Query?
Greetings, I am finishing up a final project for my capstone course. I am curious if anyone could provide any tips on how to access the data or if I am doing anything wrong. Code as follows: PublicClass frmRental Inherits System.Windows.Forms.Form Dim cn As OleDb.OleDbConnection Dim cmd As...