Can anyone See where I'm going wrong?

[MikeY]

Hi Everyone,

Can anyone see where I'm going wrong? Win [C#]

OleDbConnection thisConnection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HOST
017.MDB");

thisConnection.Open();

OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * from
TableTemplate", thisConnection);

OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);

DataSet thisDataSet = new DataSet();



thisAdapter.Fill(thisDataSet,"TableTemplate");



MessageBox.Show("Before Change:" +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);



thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"] = "100";

thisAdapter.Update(thisDataSet, "TableTemplate");



MessageBox.Show("After Change: " +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);





Error being generated is : Syntax error(missing operator) in query
expression "((ID = ?) and ((? IS NULL AND Nam IS NULL) or (NAME = ?) AND....



It keeps ong on from there. But any and all help would be appreciated.



Thanks

MikeY

 

[Mark]

Just a guess but the Rows collection is zero based so the first row is
Row[0]

 

[Jim Hughes]

Name is a reserved word and should not be used for table or column names.

Do you have a primary key defined? you need one.

 

[MikeY]

Hi Jim

Yes I do have a primary key. Txs for the reserved naming convenvention. I've
been trying to find information on naming convention for Access and other
Databases. I'll look into my naming.

Thanks again.

MikeY

Name is a reserved word and should not be used for table or column names.

Do you have a primary key defined? you need one.

Hi Everyone,

Can anyone see where I'm going wrong? Win [C#]

OleDbConnection thisConnection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HOST
017.MDB");

thisConnection.Open();

OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * from
TableTemplate", thisConnection);

OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);

DataSet thisDataSet = new DataSet();



thisAdapter.Fill(thisDataSet,"TableTemplate");



MessageBox.Show("Before Change:" +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);



thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"] = "100";

thisAdapter.Update(thisDataSet, "TableTemplate");



MessageBox.Show("After Change: " +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);





Error being generated is : Syntax error(missing operator) in query
expression "((ID = ?) and ((? IS NULL AND Nam IS NULL) or (NAME = ?)
AND....



It keeps ong on from there. But any and all help would be appreciated.



Thanks

MikeY

 

[Jim Hughes]

http://support.microsoft.com/kb/286335/ is the MS document.

Located with
http://www.google.com/search?hl=en&q=access+reserved+words&btnG=Google+Search

Hi Jim

Yes I do have a primary key. Txs for the reserved naming convenvention.
I've been trying to find information on naming convention for Access and
other Databases. I'll look into my naming.

Thanks again.

MikeY

Name is a reserved word and should not be used for table or column names.

Do you have a primary key defined? you need one.

Hi Everyone,

Can anyone see where I'm going wrong? Win [C#]

OleDbConnection thisConnection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HOST
017.MDB");

thisConnection.Open();

OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * from
TableTemplate", thisConnection);

OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);

DataSet thisDataSet = new DataSet();



thisAdapter.Fill(thisDataSet,"TableTemplate");



MessageBox.Show("Before Change:" +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);



thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"] = "100";

thisAdapter.Update(thisDataSet, "TableTemplate");



MessageBox.Show("After Change: " +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);





Error being generated is : Syntax error(missing operator) in query
expression "((ID = ?) and ((? IS NULL AND Nam IS NULL) or (NAME = ?)
AND....



It keeps ong on from there. But any and all help would be appreciated.



Thanks

MikeY

 

[MikeY]

Thanks Jim,

It turns out to be the naming convention. But, thank you for your links. the
naming convention page will be very handy.

Thanks again,

MikeY

http://support.microsoft.com/kb/286335/ is the MS document.

Located with
http://www.google.com/search?hl=en&q=access+reserved+words&btnG=Google+Search

Hi Jim

Yes I do have a primary key. Txs for the reserved naming convenvention.
I've been trying to find information on naming convention for Access and
other Databases. I'll look into my naming.

Thanks again.

MikeY

Name is a reserved word and should not be used for table or column
names.

Do you have a primary key defined? you need one.

Hi Everyone,

Can anyone see where I'm going wrong? Win [C#]

OleDbConnection thisConnection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HOST
017.MDB");

thisConnection.Open();

OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * from
TableTemplate", thisConnection);

OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);

DataSet thisDataSet = new DataSet();



thisAdapter.Fill(thisDataSet,"TableTemplate");



MessageBox.Show("Before Change:" +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);



thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"] = "100";

thisAdapter.Update(thisDataSet, "TableTemplate");



MessageBox.Show("After Change: " +
thisDataSet.Tables["TableTemplate"].Rows[1]["Catagory"]);





Error being generated is : Syntax error(missing operator) in query
expression "((ID = ?) and ((? IS NULL AND Nam IS NULL) or (NAME = ?)
AND....



It keeps ong on from there. But any and all help would be appreciated.



Thanks

MikeY