SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQLCE Workshop III - Getting started with 3.5 Beta


SQLCE Workshop III - Getting started with 3.5 Beta

Author
Message
jacob sebastian
jacob sebastian
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2678 Visits: 2523
Comments posted to this topic are about the item SQLCE Workshop III - Getting started with 3.5 Beta

.
jeff-599565
jeff-599565
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 46
Still really curious about that great set of questions in article #2, esp

Designing the database schema
How do I design my database schema, modify and manage the database objects? What designer can I use? Is it really handy? What are the tools that I can use to connect to my SQL Server CE database to view and manage my data? How do I create a database diagram?

Business Intelligence and Reporting
Will I be able to create Business Intelligence applications on top of my database? Will I be able to use Reporting services? Will the ReportViewer work with my database?
Schema Management

Pros and Cons
What are the capabilities and what are the limitations of SQL Server CE?

Administration
What if my database grows? Do I need to worry before it is 4 GB? Will the performance be good enough? What do I do if the database still grows? Does it work on a multi-user environment? What are the administrative activities needed?

TSQL Programming
SSCE does not support Stored Procedures, Triggers and Views. Will it affect me and my development team in any manner? How do I organize and manage my database queries/code for better maintainability and productivity?

Synchronization
How do I synchronize my SSCE database with a central Server? Can I synchronize with an external server (outside my local network)? Do I need direct access to the server? What if the server is behind a firewall? Is there a way to do a sync through a Web Service? Can I sync with a different database server, say Oracle or DB2? What is Remote Data Access and How do my applications benefit from it?
miejunkacct
miejunkacct
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1
Hows come using the below code I never see any data in my database?

SqlCeConnection conn = null;
SqlCeTransaction trans = null;
try
{
conn = new SqlCeConnection(@"Data Source=|DataDirectory|\MediaLister.sdf");
conn.Open();
trans = conn.BeginTransaction();
SqlCeCommand insertMedia = conn.CreateCommand();
String insertMediaSql = "INSERT INTO Media(MediaName, MediaType, MediaLength, MediaDescription)";
insertMediaSql = insertMediaSql + String.Format("VALUES ('{0}','{1}','{2}','{3}')","MediaName", "DVD", "MediaLength", "MediaDescription");
// "VALUES (@MediaName, @MediaType, @MediaLength, @MediaDescription)";
insertMedia.Transaction = trans;
insertMedia.CommandText = insertMediaSql;
//insertMedia.Parameters.Clear();
//insertMedia.Parameters.AddWithValue("@MediaName", this.MediaNameTB.Text);
//insertMedia.Parameters.AddWithValue("@MediaType", this.MediaTypeDDL.Text);
//insertMedia.Parameters.AddWithValue("@MediaLength", this.MediaLengthTB.Text);
//insertMedia.Parameters.AddWithValue("@MediaDescription", this.MediaDescTB.Text);
insertMedia.ExecuteNonQuery();
trans.Commit(CommitMode.Immediate);
}
catch (SqlCeException ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
jacob sebastian
jacob sebastian
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2678 Visits: 2523
After building the INSERT QUERY, try to print it in debug mode and see if it looks correct..Then try to execute the query in management studio you could spot the problem quickly.

.
lisa_lacour
lisa_lacour
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 0
I get this error message:

Reference required to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' containing the base class 'System.Data.Common.DbConnection'. Add one to your project. C:\CDR\DEMsql\DEMsql\clsDEMsqlServerCE.vb

I have System.Data referenced, it's 3.5 not 2.0 but even after dropping 3.5 and adding 2.0 it didn't help. Ideas?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search