Working with database in C# Pocket PC

[Sheikko]

Working with database in C# Pocket PC

Hi all,
I want to develop an application that work with DB on pocket PC.
I have added the DB to the project from Menu->Data->Add New Data
Source.
I want to insert some Rows in a table of this Db.
I know that I can create a connection and insert values with sql
statements like that:

public void SaveSettings(TS aveSettings Values)
{

DBConnection = new SqlCeConnection ();
DBConnection.Co nnectionString = @"Data Source = ..\My
Documents\Db.sd f";

//Create a SqlCeCommand on your connection
SqlCeCommand InsertCommand = DBConnection.Cr eateCommand();

//Set the CommandText for the command
//The ?'s represent parameters that will be set later
InsertCommand.C ommandText = "Insert Into Settings(ComPor t)
Values (?)";

//Add parameters and assign them the values from the
TextBoxes on the form
InsertCommand.P arameters.Add(n ew SqlCeParameter( "ComPort",
SqlDbType.NText ));

InsertCommand.P arameters["ComPort"].Value =
Values.ComPort;

//Open the connection, execute the query
DBConnection.Op en();
InsertCommand.E xecuteNonQuery( );

//Close the connection
if (DBConnection.S tate == ConnectionState .Open)
DBConnection.Cl ose();
}

in this way it work, but why I have added the Db to the project? I
want from my application to make operation on my DB without creating
connection, open it and close it by code, but I want to use smoe
things like dataset, adding rows by rows.add().. and so on.

Can you help me with some examples or tutorials on line?
thank you very much

[LaFlour]

On Apr 6, 3:00 pm, "Sheikko" <shei...@gmail. comwrote:

Working with database in C# Pocket PC
in this way it work, but why I have added the Db to the project? I

What do you meant? Can you make it clear?

[Ginny Caughey [MVP]]

I'm not sure exactly what you're asking, but tutorials are available here:
http://www.microsoft.com/sql/edition...t/default.mspx

--
Ginny
"Sheikko" <sh*****@gmail. comwrote in message
news:11******** **************@ l77g2000hsb.goo glegroups.com.. .

Working with database in C# Pocket PC

Hi all,
I want to develop an application that work with DB on pocket PC.
I have added the DB to the project from Menu->Data->Add New Data
Source.
I want to insert some Rows in a table of this Db.
I know that I can create a connection and insert values with sql
statements like that:

public void SaveSettings(TS aveSettings Values)
{

DBConnection = new SqlCeConnection ();
DBConnection.Co nnectionString = @"Data Source = ..\My
Documents\Db.sd f";

//Create a SqlCeCommand on your connection
SqlCeCommand InsertCommand = DBConnection.Cr eateCommand();

//Set the CommandText for the command
//The ?'s represent parameters that will be set later
InsertCommand.C ommandText = "Insert Into Settings(ComPor t)
Values (?)";

//Add parameters and assign them the values from the
TextBoxes on the form
InsertCommand.P arameters.Add(n ew SqlCeParameter( "ComPort",
SqlDbType.NText ));

InsertCommand.P arameters["ComPort"].Value =
Values.ComPort;

//Open the connection, execute the query
DBConnection.Op en();
InsertCommand.E xecuteNonQuery( );

//Close the connection
if (DBConnection.S tate == ConnectionState .Open)
DBConnection.Cl ose();
}

in this way it work, but why I have added the Db to the project? I
want from my application to make operation on my DB without creating
connection, open it and close it by code, but I want to use smoe
things like dataset, adding rows by rows.add().. and so on.

Can you help me with some examples or tutorials on line?
thank you very much