connecting to sql server ce in report sharp shooter

Question

0.00/5 (No votes)

See more:

i'm using a program in C# and use master-detail tables in sql server ce.
but i no know how to connecting to sql server ce in report sharp shooter?
if someone have source code or program about this Put here.

thank u

Posted 10-Mar-12 1:35am

aref136790

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kovalev599 · Answer 1 · 2012-03-14T18:05:00

1. To work with the database we need the SQL Server Compact Edition set of libraries which can be downloaded from Microsoft website: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17439
2. Add the reference to the project to take advantage of the SqlCEDataAdapter functionality. http://img593.imageshack.us/img593/617/59588125.png
3. Write a function which will fill a dataset with the data from the database:

C#

1.	private void PrepareDataSet()
2.	        {
3.	            string connectionString = "Data Source = db.sdf";
4.	            SqlCeConnection connection = new SqlCeConnection(connectionString);
5.	            connection.Open();
6.	 
7.	            string query = "SELECT * FROM Person";
8.	            SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(query, connection);
9.	 
10.	            dataAdapter.Fill(dataSet1);
11.	}

4. Add the call for the PrepareDataSet method to the constructor http://img829.imageshack.us/img829/4720/98959194.png

5. Now the data from the database are available in a report http://img717.imageshack.us/img717/9241/85692839.png

OriginalGriff · Answer 2 · 2012-03-10T01:48:00

Looking at their website, they say it supports "use of any .Net data sources supported by your application" so it should do.

I would suggest that you look at their website: they offer support both free and paid, and will understand thier product and hoiw you use it a lot better than we would! http://www.perpetuumsoft.com/Support.aspx?lang=en[^]

aref136790 · Answer 3 · 2012-03-23T00:10:00

i use Solution 2
and this source for report

C#

string connectionString = @"Data Source=C:\data\Shop1.sdf";
               SqlCeConnection connection = new SqlCeConnection(connectionString);
               connection.Open();
               string query = "SELECT * FROM Customers";
               SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(query, connection);
               dataAdapter.Fill(shop1DataSet1);
           try
           {
               reportGenerator1.Prepare();
               using (NineRays.Reporting.View.PreviewForm previewForm = new NineRays.Reporting.View.PreviewForm(reportGenerator1))
               {
                   previewForm.WindowState = FormWindowState.Maximized;
                   previewForm.ShowDialog(this);
               }
           }
           catch (Exception ee)
           {
               MessageBox.Show(ee.Message, "Report Sharp-Shooter", MessageBoxButtons.OK, MessageBoxIcon.Error);
           }

then run program and saw this:
http://freepicupload.com/view.php?filename=232p1.png[^]

then click to Refresh report and saw this
http://freepicupload.com/view.php?filename=679p2.png[^]

why report empty?!!2

connecting to sql server ce in report sharp shooter

3 solutions

Solution 2

Solution 1

Solution 6

Add your solution here

Preview 0