SQL statement in Access

[John Sutor]

I am trying to write an insert statement in Access but it is not working
with the OleDBCommand object.
HEre is the code

string sqltxt= "INSERT INTO contacts ( Last_Name, First_Name,
Email_Address, [Note] )" +
" WHERE (Last_Name)='Testlast') AND (First_Name)='TestFirst') AND
(Email_Address)='TestEmail') AND (Note)='TestNote')";
Debug.WriteLine(sqltxt);

OleDbConnection myConnection = new OleDbConnection(connectString);
OleDbCommand myCommand = new OleDbCommand(sqltxt, myConnection);
myCommand.Connection.Open();
int ret = myCommand.ExecuteNonQuery()

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

I think that the error is in your query, INSERT INTO ... WHERE .. ??

you are mixing INSERT with UPDATE syntax.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"John Sutor" <jo********@cinfin.com> wrote in message
news:O1**************@TK2MSFTNGP15.phx.gbl...

I am trying to write an insert statement in Access but it is not working
with the OleDBCommand object.
HEre is the code

string sqltxt= "INSERT INTO contacts ( Last_Name, First_Name,
Email_Address, [Note] )" +
" WHERE (Last_Name)='Testlast') AND (First_Name)='TestFirst') AND
(Email_Address)='TestEmail') AND (Note)='TestNote')";
Debug.WriteLine(sqltxt);

OleDbConnection myConnection = new OleDbConnection(connectString);
OleDbCommand myCommand = new OleDbCommand(sqltxt, myConnection);
myCommand.Connection.Open();
int ret = myCommand.ExecuteNonQuery()

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Gerry O'Brien [MVP]]

You don't have a values section in your INSERT statement.

INSERT INTO contacts(Last_Name, First_Name) VALUES(lastname, firstname)

--
Gerry O'Brien
Visual Basic .NET MVP
"John Sutor" <jo********@cinfin.com> wrote in message
news:O1**************@TK2MSFTNGP15.phx.gbl...

I am trying to write an insert statement in Access but it is not working
with the OleDBCommand object.
HEre is the code

string sqltxt= "INSERT INTO contacts ( Last_Name, First_Name,
Email_Address, [Note] )" +
" WHERE (Last_Name)='Testlast') AND (First_Name)='TestFirst') AND
(Email_Address)='TestEmail') AND (Note)='TestNote')";
Debug.WriteLine(sqltxt);

OleDbConnection myConnection = new OleDbConnection(connectString);
OleDbCommand myCommand = new OleDbCommand(sqltxt, myConnection);
myCommand.Connection.Open();
int ret = myCommand.ExecuteNonQuery()

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Sutor]

This did not work.

string sqltxt = "Insert Into contacts (customerid, companyname,
contactname) Values (" + "'" + sLast + "'" + "," + "'" + sFirst + "'" +
"," +
"'" + sEmail + "'" + "," + "'" + sNote + "'" + ")" ;

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rajagopal Pasupuleti]

are you sending correct number of values as parameters check your commas
in the prepared statement write your sqltxt as output and check..

--
rajagopal

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!