Argumentexception was unhandled.. How to fix ?

Question

0.00/5 (No votes)

See more:

C#

 SqlConnection con = new SqlConnection("data source=SAMIRAN-PC; Initial catalog = DB2; Integral 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();
}

at the first line it says like such error.Nd I cannot find any thing wrong. Still it is happening.
If any one can do, will be most welcome !!

Thank You !!

What I have tried:

There may be connection problem.I am doing with such way. But I don't know which is the best and correct way to connect. Help !

Posted 5-Apr-16 17:13pm

KukiSamiran

Updated 5-Apr-16 17:31pm

v2

Add a Solution

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)

*dan!sh* · Answer 1 · 2016-04-05T17:20:00

Solution 1

Your connection string is not correct. Update it to:

Data Source=SAMIRAN-PC; Initial Catalog = DB2; Integrated Security= SSPI

This connection string specifies the server (data source), database (intial catalog) and mentions that windows authentication should be used (integrated security). In your code, last parameter is not correct.

Posted 5-Apr-16 17:20pm

dan!sh

Updated 5-Apr-16 17:23pm

v2

Comments

KukiSamiran 5-Apr-16 23:36pm

after doing that there is another problem
in
con.Open();

dan!sh 5-Apr-16 23:49pm

You will need to provide details. What is the exception you are getting? Paste the message here. I suspect windows authentication is not enabled or you do not have enough permissions on the database.

KukiSamiran 6-Apr-16 0:56am

this problem is solved. Thanks :)
another problem is that
"SqlException was unhandled" -> in con.Open() command highlighting.

KukiSamiran 6-Apr-16 5:30am

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)

Patrice T · Answer 2 · 2016-04-05T17:29:00

Solution 2

I would try to replace:

C#

dat.InsertCommand.Parameters.Add("@AGE", SqlDbType.VarChar).Value = textBox2;

with :

C#

dat.InsertCommand.Parameters.Add("@AGE", SqlDbType.VarChar).Value = textBox2.text;

You may also need to convert textBox2.text to numeric.

Posted 5-Apr-16 17:29pm

Patrice T

Comments

KukiSamiran 5-Apr-16 23:36pm

sorry ! this was my mistake. I have not paste it here correctly .