Application working partially in a particular PC

Question

1.00/5 (2 votes)

See more:

I developed a Windows Based Application and installed the setup.exe created by using VS C#2.0 on other PC to check accuracy , after properly installing the application on Windows Vista it successfully established the connection to SQL Server 2005. There are many form in this application viz; 'New Order', 'Generate Bill', 'Final Payment' and 'Purchase Details' etc. When I enter data by using the 'Purchase Details' form, data successfully submitted to database, but when I enter data by using the 'New Order' form and click the submit button the application stops working immediately and gives an error message as like:-

CSS

Description:
  Stopped working

Problem signature:
  Problem Event Name:   CLR20r3
  Problem Signature 01: billing_software.exe
  Problem Signature 02: 1.0.0.0
  Problem Signature 03: 522ed0d8
  Problem Signature 04: System.Data
  Problem Signature 05: 2.0.0.0
  Problem Signature 06: 49cc5f1a
  Problem Signature 07: 2492
  Problem Signature 08: 2c
  Problem Signature 09: System.Data.SqlClient.Sql
  OS Version:   6.0.6002.2.2.0.768.2
  Locale ID:    16393

Read our privacy statement:
  http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409

I am giving herewith the New Order Submit button code sample:-

CSS

private void button1_Click(object sender, EventArgs e)
        {
            string s = "insert into New_Order values('" + comboBox1.Text + "','" + comboBox2.Text + "','" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + dateTimePicker1.Value + "','" + dateTimePicker2.Value + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "')";
            SqlConnection con = new SqlConnection(Class1.cs);
            con.Open();
            SqlCommand cmd = new SqlCommand(s, con);
            cmd.ExecuteNonQuery();
            MessageBox.Show("Information Saved Successfully");
            textBox3.Text = "";
            comboBox2.Text = "";
            textBox1.Text = "";
            textBox4.Text = "";
            textBox2.Text = "";
            dateTimePicker1.Text = "";
            dateTimePicker2.Text = "";
            textBox5.Text = "";
            textBox6.Text = "";
            textBox7.Text = "";
            textBox8.Text = "";
            con.Close();
            string s1 = "select * from Sales_Details where Challan_No='" + comboBox1.Text + "'";
            SqlConnection cn = new SqlConnection(Class1.cs);
            cn.Open();
            SqlDataAdapter da = new SqlDataAdapter(s1, cn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            cn.Close();
        }

I am not finding the reason behind it, pleasesomeone help me.

Posted 9-Sep-13 22:52pm

Md M Ahmad

Updated 10-Sep-13 17:15pm

v5

Add a Solution

Comments

lukeer 10-Sep-13 5:17am

Did you write that software?
Then use the "Improve question" link and provide the code that's being run on clicking the submit button on the NewOrder form.

If that's a software you don't have the source code for, ask the creator/vendor/publisher.

Joezer BH 10-Sep-13 5:38am

The best idea you will get by asking the developer of the software, there's very little we can do with your info...

Md M Ahmad 10-Sep-13 10:49am

Sir, I have developed the software.

ZurdoDev 10-Sep-13 7:56am

You need to debug it. Add some logging features to it.

Md M Ahmad 10-Sep-13 11:23am

Sir, sorry didn't understand logging features??

ZurdoDev 10-Sep-13 11:29am

When you write code you should have lots of trys and catches and when you catch errors you should log them so that when you deploy and there are issues that you didn't find in development you can figure out what is happening.

[no name] 10-Sep-13 8:34am

The first thing you would need to do would be to use proper parameterized queries instead of this SQL injection attack waiting to happen code. What is "Class1.cs"? Isn't that a filename?

Md M Ahmad 10-Sep-13 10:53am

class Class1
{
public static bool connection;
public static string cs = "Data Source=MASHKOOR-PC;Initial Catalog=Kolkata_Dental;User Id= sa; Password=md22mashkoor";
}

Richard MacCutchan 10-Sep-13 12:07pm

See http://runtingsproper.blogspot.co.uk/2010/02/solved-error-1053-eventtype-clr20r3.html.

Md M Ahmad 10-Sep-13 13:35pm

I opened this link and followed it, nothing would changed.

Richard MacCutchan 10-Sep-13 14:08pm

The first thing you need to do is correct your code.
1. Use realistic names for your variables so they make some form of sense; using textBox1, textBox2, etc makes it much more difficult to identify problems.
2. Fix your SQL command to use proper parameterised queries and not the string concatenation you are using. What you have allows for any sort of corruption and/or SQL injection to destroy your database.
3. Add proper checks on all statements that return values to indicate their results.
4. Use your debugger to step through the code and check exactly what is happening at each stage.

Md M Ahmad 10-Sep-13 22:34pm

Sir, I can submit data by the same piece of code in other PC or the developer PC.

Richard MacCutchan 11-Sep-13 3:11am

You should still do what I suggested.
As to that, you are probably missing the correct version of some .NET libraries on the new PC where you have installed your software. The only way to diagnose this further is to look at the event logs on the failing system, as suggested in the link I gave you above.

KmgKrishnan 11-Sep-13 2:15am

I believe the issue might be while creating the setup. How did you create the setup? Have you used the sign in assembly? If yes, there seems to be something missing in the config file for it. I might need more information to understand your issue.

1 solution

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)

Bernhard Hiller · Answer 1 · 2013-09-10T23:01:00

Solution 1

Change that button click handler a littel, with a try catch blcok (and I'd also suggest a parameterized query):

C#

private void button1_Click(object sender, EventArgs e)
{
    try
    {
        //your code here
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Tostring());
    }
}

At least, the application won't crash away totally, and you'll get a better error message.

Posted 10-Sep-13 23:01pm

Bernhard Hiller

Comments

Md M Ahmad 11-Sep-13 6:22am

I used it the application throws an error:
Error:- System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime datatype resulted in an out-of-range datetime value.
The statement has been terminated.

Bernhard Hiller 11-Sep-13 9:27am

You see: the problem is not so obscure. Likely a different format for date and time on that specific computer. Can be easily resolved with a parameterized query.