Dataset is crushed when application is run on client machine.

Question

0.00/5 (No votes)

See more:

C#

hello

I have make one small desktop application in visual studio 2010 . In this i used one crystal report.
It is working properly in development side. But when i make its setup & install in client machine, it will close whole application.It means it stops whole process.

What can I do in this situation ?

I have seen the problem in Dataset when execution control comes on dataset it will close whole application.

What I have tried:

I am using visual studio 2010 & crystal report for vs2010 .

Posted 11-Sep-16 21:08pm

khushbujasmine

Updated 11-Sep-16 22:19pm

Add a Solution

Comments

Patrice T 12-Sep-16 3:18am

Asking questions is a skill[^]

Mehdi Gholam 12-Sep-16 3:35am

My 5! :)

Patrice T 12-Sep-16 4:04am

Too bad I didn't used a solution :)

Maciej Los 12-Sep-16 4:07am

So, use it! I'll upvote it!

khushbujasmine 12-Sep-16 5:32am

Actually my English is little bit slow. So my question is like this.

Patrice T 12-Sep-16 5:36am

No problem for me.
It is just that you do not provide information, so no help is possible beyond very general advice.

khushbujasmine 12-Sep-16 5:55am

When I run my windows application in my local pc , it will work properly, it shows all reports also.
But when i make its setup and install in client machine , it will work nice but when i click on view report , it will stopped working & close whole application.

2 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)

OriginalGriff · Answer 1 · 2016-09-11T21:40:00

Solution 1

Quote:
I have seen the problem in Dataset when execution control comes on dataset it will close whole application.

Then the most likely reason is that you don't use any try-catch blocks to try to locate and handle errors properly, and your connection string is probably wrong. Development and production do not normally use the same connection string - or even the same database - so unless your code is set up to use a configuration system to store the connection string, it's probably still trying to reference your development SQL Server instance. EVen if it is, you need to check what that string is, and that it's correct for the actual instance of SQL that it references. And that the instance has a copy of the database. And ... you get the idea.
We can't do any of that for you: so check it all very carefully, and add try - catch blocks to report problems (including any inner exception) so that you get told what the error actual is rather than "it crashed".

Posted 11-Sep-16 21:40pm

OriginalGriff

Comments

khushbujasmine 12-Sep-16 5:22am

Hello
I used try & catch block.

conn = GetConnection();

if (fieldname == "All")
{
cmd = new SqlCommand("select * from tbl_Expense order by nTitle", conn);
}

else if (equality == "equal")
{
cmd = new SqlCommand("select * from tbl_Expense where " + fieldname + "='" + values + "' order by nTitle asc", conn);
}
else if (equality == "Like")
{
cmd = new SqlCommand("select * from tbl_Expense where " + fieldname + " like '%" + values + "%' order by nTitle asc", conn);
}
else if (equality == "Less")
{
cmd = new SqlCommand("select * from tbl_Expense where " + fieldname + " < " + float.Parse(values) + " order by nTitle asc", conn);
}

cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet dsreport = new DataSet();
dsreport.Clear();

try
{

da.Fill(dsreport, "tbl_Expense");

}
catch (SqlException)
{

}
return dsreport;

All database queries are correct & database connectivity is also correct.

OriginalGriff 12-Sep-16 5:28am

And you swallowed any exceptions, so you have no idea what went wrong, if anything...

khushbujasmine 12-Sep-16 5:33am

When i run this program in visual studio ,i traced line by line, not any exception given.
it is working properly.

OriginalGriff 12-Sep-16 5:39am

Yes.
But you don't run it under VS in production, do you?
And that's where it's failing...so that's where you need to gather information instead of throwing it away.

khushbujasmine 12-Sep-16 5:51am

I cant understand your question, "But you don't run it under VS in production, do you?" What it means ?

OriginalGriff 12-Sep-16 6:03am

You only run your application under Visual Studio (VS for short) that is on your development machine, under your development environment, using your development database.
You don't use VS in production, you run in a different environment, and you use a different database. So you can't extrapolate from "no exceptions in dev" to "no exceptions in prod" - particularly when your application doesn't work...
So when you swallow exceptions you throw away information that you desperately need, and have no other way to get...

Maciej Los · Answer 2 · 2016-09-11T22:19:00

Solution 2

Well, you didn't provide much information but...

MS wrote:
To provide Crystal Reports runtime files, your setup projects must include the Crystal Reports for .NET Framework 2.0 Redistribution Package or Crystal Reports merge modules. Crystal Reports merge modules are available for 32 and 64-bit machines.

source: Crystal Reports Deployment Overview[^]

This mean, you need to install Crystal Reports runtime files on client machine to be able to use it.

Posted 11-Sep-16 22:19pm

Maciej Los

Comments

khushbujasmine 12-Sep-16 5:29am

I had installed dotNetFx40_Client_x86_x64 , crystal report (CRforVS_redist_install_32bit_13_0),
sql server 2008.

Maciej Los 12-Sep-16 5:48am

And...

khushbujasmine 12-Sep-16 5:56am

and my application not any else.