Sqlexception was unhandled

Question

0.00/5 (No votes)

See more:

C#

private void button1_Click(object sender, EventArgs e)
     {
         SqlConnection con = new SqlConnection("data source=SAMIRAN-PC; Initial catalog = DB2; Integrated security= true");
         SqlDataAdapter dat = new SqlDataAdapter();
         dat.InsertCommand = new SqlCommand(" INSERT INTO TAB2 VALUES(@NAME,@AGE)", con);
         dat.InsertCommand.Parameters.Add("@NAME",SqlDbType.VarChar).Value = textBox1.Text;
         dat.InsertCommand.Parameters.Add("@AGE", SqlDbType.VarChar).Value = textBox2.Text;
         con.Open();
         dat.InsertCommand.ExecuteNonQuery();
         con.Close();
     }
 }

After executing it, shows error at "con.Open();" by saying SqlException was unhandled. Then it stops during runtime

What I have tried:

After executing the form, it takes input. But after clicking submit button , it stops for a while and says such.
Please Help Me .. !!!

Posted 5-Apr-16 17:41pm

KukiSamiran

Updated 5-Apr-16 21:04pm

Add a Solution

Comments

dan!sh 6-Apr-16 2:05am

There must be more information in the inner exception. Details you have provided here are not enough to help. Also, your connection string is still wrong. I did replied to your previous question with correct connection string.

KukiSamiran 6-Apr-16 5:31am

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

error description is this.
can you help me by writing that connection string only?

Sinisa Hajnal 6-Apr-16 2:20am

If your connection is correct then your insert is wrong. Very simple. Either columns in Tab2 are in different order, there are more columns then those two or Tab2 isn't in default schema.

You should always write insert fields explicitly.

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 · 2016-04-05T21:04:00

Solution 1

Wrap the code in a

C#

try
{
    // your code here
}
catch(SqlException ex)
{
    // do something useful with the error Number
    MessageBox.Show(ex.Number.ToString());
    foreach(SqlError s in ex.Errors)
    {
        // do something useful with its properties
        MessageBox.Show(s.ToString());
    }
}

Posted 5-Apr-16 21:04pm

Bernhard Hiller

Comments

KukiSamiran 6-Apr-16 6:22am

I appreciate it. But there is a big issue in connectionString. By using your solution it only shows error not the resaon