SQL Database update from C# console application

[James]

I'm stuck. I have created a console application that does its job of
collecting the data I want it to however I am stuck on writing this data back
to a database. All of the examples I have been able to find on using the
SQLConnectin, SQLDataAdapter and DataSet objects all point me to a forms
application where you can visually modify the data the send the
update,insert,d elete commands. I have not been able to locate how to update
or insert data on a DataSet that is not bound to a visual object of some kind.

Thanks for any assistance...

FYI... I am attempting this with VS2005 Beta 2 and SQL 2005 AprilCTP.

Thanks!

[W.G. Ryan MVP]

You reference the values directly...

ie
DataSetName.Tab les[TableIndexOrNam e].Rows[RowIndex].Columns[ColumnIndexOrNa me]
= WhateverValue;

"James" <Ja***@discussi ons.microsoft.c om> wrote in message
news:2E******** *************** ***********@mic rosoft.com...

I'm stuck. I have created a console application that does its job of
collecting the data I want it to however I am stuck on writing this data
back
to a database. All of the examples I have been able to find on using the
SQLConnectin, SQLDataAdapter and DataSet objects all point me to a forms
application where you can visually modify the data the send the
update,insert,d elete commands. I have not been able to locate how to
update
or insert data on a DataSet that is not bound to a visual object of some
kind.

Thanks for any assistance...

FYI... I am attempting this with VS2005 Beta 2 and SQL 2005 AprilCTP.

Thanks!

[James]

okay, let me make sure I am on the right track...

I can call the fill method to load the dataset from the database, compare my
discovered data with the data in the dataset by directly refrencing the
fields as you said, then call the update method to send the updated data back
to the database.

If I need to insert a new row of data do I just call an Add method to the
dataset and reference the table name?

"W.G. Ryan MVP" wrote:

You reference the values directly...

ie
DataSetName.Tab les[TableIndexOrNam e].Rows[RowIndex].Columns[ColumnIndexOrNa me]
= WhateverValue;

"James" <Ja***@discussi ons.microsoft.c om> wrote in message
news:2E******** *************** ***********@mic rosoft.com...

I'm stuck. I have created a console application that does its job of
collecting the data I want it to however I am stuck on writing this data
back
to a database. All of the examples I have been able to find on using the
SQLConnectin, SQLDataAdapter and DataSet objects all point me to a forms
application where you can visually modify the data the send the
update,insert,d elete commands. I have not been able to locate how to
update
or insert data on a DataSet that is not bound to a visual object of some
kind.

Thanks for any assistance...

FYI... I am attempting this with VS2005 Beta 2 and SQL 2005 AprilCTP.

Thanks!

[Jimbo]

James wrote:

I'm stuck. I have created a console application that does its job of
collecting the data I want it to however I am stuck on writing this data back
to a database. All of the examples I have been able to find on using the
SQLConnectin, SQLDataAdapter and DataSet objects all point me to a forms
application where you can visually modify the data the send the
update,insert,d elete commands. I have not been able to locate how to update
or insert data on a DataSet that is not bound to a visual object of some kind.

Thanks for any assistance...

I think this is what your after. Below is a code snippet that updates
two databases, one via ODBC and another via OLE. Hope this helps.
oleDbConnection 1 = new System.Data.Ole Db.OleDbConnect ion();
odbcConnection1 = new System.Data.Odb c.OdbcConnectio n();

oleDbConnection 1.ConnectionStr ing = @"Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Database Password=;Data Source=""C:\Doc uments and Settings\All
Users\Documents \DATA.mdb"";Pas sword=;Jet OLEDB:Engine Type=5;Jet
OLEDB:Global Bulk
Transactions=1; Provider=""Micr osoft.Jet.OLEDB .4.0"";Jet OLEDB:System
database=;Jet OLEDB:SFP=False ;Extended Properties=;Mod e=Share Deny
None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System
Database=False; Jet OLEDB:Don't Copy Locale on Compact=False;J et
OLEDB:Compact Without Replica Repair=False;Us er ID=Admin;Jet
OLEDB:Encrypt Database=False" ;

odbcConnection1 .ConnectionStri ng =
"STMT=;OPTION=5 24292;DSN=Looe; UID=XXXX;PASSWO RD=XXXX;SOCKET= ;DESC=;DATABASE =YYYY;SERV"
+ "ER=192.168.0.7 ;PORT=3306";

oleDbConnection 1.Open();
odbcConnection1 .Open();

OleDbCommand odc = oleDbConnection 1.CreateCommand ();
odc.CommandText = "UPDATE........ .";
odc.ExecuteNonQ uery();

OdbcCommand oc = odbcConnection1 .CreateCommand( );
oc.CommandText = "UPDATE........ ....";
oc.ExecuteNonQu ery();

oc.Close();
odc.Close();


Cheers
Jimbo

[W.G. Ryan MVP]

"James" <Ja***@discussi ons.microsoft.c om> wrote in message
news:6B******** *************** ***********@mic rosoft.com...

okay, let me make sure I am on the right track...

I can call the fill method to load the dataset from the database, compare
my
discovered data with the data in the dataset by directly refrencing the
fields as you said, then call the update method to send the updated data
back
to the database. Yes
If I need to insert a new row of data do I just call an Add method to the
dataset and reference the table name?
Yes
"W.G. Ryan MVP" wrote:

You reference the values directly...

ie
DataSetName.Tab les[TableIndexOrNam e].Rows[RowIndex].Columns[ColumnIndexOrNa me]
= WhateverValue;

"James" <Ja***@discussi ons.microsoft.c om> wrote in message
news:2E******** *************** ***********@mic rosoft.com...

> I'm stuck. I have created a console application that does its job of
> collecting the data I want it to however I am stuck on writing this
> data
> back
> to a database. All of the examples I have been able to find on using
> the
> SQLConnectin, SQLDataAdapter and DataSet objects all point me to a
> forms
> application where you can visually modify the data the send the
> update,insert,d elete commands. I have not been able to locate how to
> update
> or insert data on a DataSet that is not bound to a visual object of
> some
> kind.
>
> Thanks for any assistance...
>
>
>
> FYI... I am attempting this with VS2005 Beta 2 and SQL 2005 AprilCTP.
>
> Thanks!
>