When I run the following code:
OleDbConnection conn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\moneymakin.mdb");
String stmt = "INSERT INTO Person (FirstName,
LastName, Email, LoginID, Password) VALUES (" +
"'" + this.m_perFirstName + "', '" +
this.m_perLastName +
"', '" + this.m_emailAddress + "', '" +
this.m_loginID +
"', '" + this.m_password + "')";
MessageBox.Show(stmt);
//conn.Open();
OleDbCommand perCommand = new OleDbCommand
(stmt, conn);
perCommand.Connection.Open();
perCommand.ExecuteNonQuery();
//OleDbDataReader perReader =
perCommand.ExecuteNonQuery();
//perReader.Close();
I get the following error no matter what:
************** Exception Text **************
System.Data.OleDb.OleDbException: Syntax error in INSERT
INTO statement.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHand
ling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingle
Result(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText
(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand
(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al
(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at WindowsSample.Person.saveNewData() in c:\Documents
and Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\DataItems\Person.cs:line 192
at WindowsSample.PersonalInfo.btnPersonalSave_Click
(Object sender, EventArgs e) in c:\Documents and
Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\Forms\PersonalInfo.cs:line 326
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp
(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m,
MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage
(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc
(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr
hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Line 192 refers to the executenonquery() method. I have
tested the query by itself in Access, and it inserts the
value just fine. Does anyone have any idea what could be
wrong? I have tracked it down to the loginID or Password
field, as the query works fine without those two in
there, but I am not sure what the problem is. Any help
would be much appreciated!
Kirk
3  1521 
Password is a reserved word in Access and is the most likely culprit It
will run ok within access, but via ADO.NET, reserved words cause all kinds
of problems. The bandaid is to wrap it in bracekts [Password] but you or a
co-worker will invariably forget this sometime in the future. IMHO, get rid
of it b/c it's not worth the maintenance and headaches it will likely cause.
HTH,
Bill
"kirk g" <ky*@datatel.com> wrote in message
news:03****************************@phx.gbl... When I run the following code:
OleDbConnection conn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\moneymakin.mdb");
String stmt = "INSERT INTO Person (FirstName,
LastName, Email, LoginID, Password) VALUES (" +
"'" + this.m_perFirstName + "', '" +
this.m_perLastName +
"', '" + this.m_emailAddress + "', '" +
this.m_loginID +
"', '" + this.m_password + "')";
MessageBox.Show(stmt);
//conn.Open();
OleDbCommand perCommand = new OleDbCommand
(stmt, conn);
perCommand.Connection.Open();
perCommand.ExecuteNonQuery();
//OleDbDataReader perReader =
perCommand.ExecuteNonQuery();
//perReader.Close();
I get the following error no matter what:
************** Exception Text **************
System.Data.OleDb.OleDbException: Syntax error in INSERT
INTO statement.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHand
ling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingle
Result(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText
(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand
(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al
(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at WindowsSample.Person.saveNewData() in c:\Documents
and Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\DataItems\Person.cs:line 192
at WindowsSample.PersonalInfo.btnPersonalSave_Click
(Object sender, EventArgs e) in c:\Documents and
Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\Forms\PersonalInfo.cs:line 326
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp
(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m,
MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage
(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc
(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr
hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Line 192 refers to the executenonquery() method. I have
tested the query by itself in Access, and it inserts the
value just fine. Does anyone have any idea what could be
wrong? I have tracked it down to the loginID or Password
field, as the query works fine without those two in
there, but I am not sure what the problem is. Any help
would be much appreciated!
Kirk
That was it...thank you very much for your help. I am
just getting started with .NET, C#, and ADO by doing some
stuff at home, and have been banging my head against a
wall on this one.
Much appreciated!
Kirk -----Original Message-----
Password is a reserved word in Access and is the most
likely culprit Itwill run ok within access, but via ADO.NET, reserved
words cause all kindsof problems. The bandaid is to wrap it in bracekts
[Password] but you or aco-worker will invariably forget this sometime in the
future. IMHO, get ridof it b/c it's not worth the maintenance and headaches
it will likely cause.
HTH,
Bill
"kirk g" <ky*@datatel.com> wrote in message
news:03****************************@phx.gbl... When I run the following code:
OleDbConnection conn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\moneymakin.mdb");
String stmt = "INSERT INTO Person
(FirstName, LastName, Email, LoginID, Password) VALUES (" +
"'" + this.m_perFirstName + "', '" +
this.m_perLastName +
"', '" + this.m_emailAddress
+ "', '" + this.m_loginID +
"', '" + this.m_password + "')";
MessageBox.Show(stmt);
//conn.Open();
OleDbCommand perCommand = new OleDbCommand
(stmt, conn);
perCommand.Connection.Open();
perCommand.ExecuteNonQuery();
//OleDbDataReader perReader =
perCommand.ExecuteNonQuery();
//perReader.Close();
I get the following error no matter what:
************** Exception Text **************
System.Data.OleDb.OleDbException: Syntax error in
INSERT INTO statement.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHand ling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingle Result(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText
(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand
(CommandBehavior behavior, Object& executeResult)
at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al (CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at WindowsSample.Person.saveNewData() in
c:\Documents and Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\DataItems\Person.cs:line 192
at WindowsSample.PersonalInfo.btnPersonalSave_Click
(Object sender, EventArgs e) in c:\Documents and
Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\Forms\PersonalInfo.cs:line 326
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp
(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message&
m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message&
m) at System.Windows.Forms.Button.WndProc(Message& m)
at
System.Windows.Forms.ControlNativeWindow.OnMessage (Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc
(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr
hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Line 192 refers to the executenonquery() method. I
have tested the query by itself in Access, and it inserts
the value just fine. Does anyone have any idea what could
be wrong? I have tracked it down to the loginID or
Password field, as the query works fine without those two in
there, but I am not sure what the problem is. Any help
would be much appreciated!
Kirk
.
My pleasure. Keep on trucking though, ADO.NET is a bit confusing at first,
but you'll quickly learn to love it.
Bill
"Kirk Gray" <ky*@datatel.com> wrote in message
news:04****************************@phx.gbl... That was it...thank you very much for your help. I am
just getting started with .NET, C#, and ADO by doing some
stuff at home, and have been banging my head against a
wall on this one.
Much appreciated!
Kirk
-----Original Message-----
Password is a reserved word in Access and is the most
likely culprit Itwill run ok within access, but via ADO.NET, reserved
words cause all kindsof problems. The bandaid is to wrap it in bracekts
[Password] but you or aco-worker will invariably forget this sometime in the
future. IMHO, get ridof it b/c it's not worth the maintenance and headaches
it will likely cause.
HTH,
Bill
"kirk g" <ky*@datatel.com> wrote in message
news:03****************************@phx.gbl... When I run the following code:
OleDbConnection conn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\moneymakin.mdb");
String stmt = "INSERT INTO Person (FirstName, LastName, Email, LoginID, Password) VALUES (" +
"'" + this.m_perFirstName + "', '" +
this.m_perLastName +
"', '" + this.m_emailAddress + "', '" + this.m_loginID +
"', '" + this.m_password + "')";
MessageBox.Show(stmt);
//conn.Open();
OleDbCommand perCommand = new OleDbCommand
(stmt, conn);
perCommand.Connection.Open();
perCommand.ExecuteNonQuery();
//OleDbDataReader perReader =
perCommand.ExecuteNonQuery();
//perReader.Close();
I get the following error no matter what:
************** Exception Text **************
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHand ling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingle Result(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText
(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand
(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al (CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at WindowsSample.Person.saveNewData() in c:\Documents and Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\DataItems\Person.cs:line 192
at WindowsSample.PersonalInfo.btnPersonalSave_Click
(Object sender, EventArgs e) in c:\Documents and
Settings\Kirk Gray\My Documents\Borland Studio
Projects\WindowsSample\Forms\PersonalInfo.cs:line 326
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp
(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage (Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc
(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr
hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Line 192 refers to the executenonquery() method. I have tested the query by itself in Access, and it inserts the value just fine. Does anyone have any idea what could be wrong? I have tracked it down to the loginID or Password field, as the query works fine without those two in
there, but I am not sure what the problem is. Any help
would be much appreciated!
Kirk
.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Patchwork |
last post by:
Hi Everyone,
Please take a look at the following (simple and fun) program:
////////////////////////////////////////////////////////////////////////////
/////////////
// Monster Munch, example...
|
by: Proteus |
last post by:
Any help appreciated on a small perl project I need to write for
educator/teaching purposes. I have not programmed perl for some time, need
to get up to speed, maybe some kind souls hrere will help...
|
by: Raskolnikow |
last post by:
Hi!
I have a very simple problem with itoa() or the localtime(...).
Sorry, if it is too simple, I don't have a proper example.
Please have a look at the comments.
struct tm *systime;
time_t...
|
by: Peter |
last post by:
Hello
Thanks for reviewing my question. I would like to know how can I programmatically select a node
Thanks in Advanc
Peter
|
by: abcd |
last post by:
I am trying to set up client machine and investigatging which .net
components are missing to run aspx page.
I have a simple aspx page which just has "hello world" printed....
When I request...
|
by: dba_222 |
last post by:
Dear Experts,
Ok, I hate to ask such a seemingly dumb question, but I've
already spent far too much time on this. More that I
would care to admit.
In Sql server, how do I simply change a...
|
by: Giancarlo Berenz |
last post by:
Hi:
Recently i write this code:
class Simple
{
private:
int value;
public:
int GiveMeARandom(void);
|
by: galiorenye |
last post by:
Hi,
Given this code:
A** ppA = new A*;
A *pA = NULL;
for(int i = 0; i < 10; ++i)
{
pA = ppA;
//do something with pA
|
by: Phillip Taylor |
last post by:
Hi guys, I'm looking to develop a simple web service in VB.NET but I'm
having some trivial issues. In Visual Studio I create a web services
project and change the asmx.vb file to this:
Imports...
|
by: Chris M. Thomasson |
last post by:
I use the following technique in all of my C++ projects; here is the example
code with error checking omitted for brevity:
_________________________________________________________________
/*...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
