sql query exception was unhandled?

Question

0.00/5 (No votes)

See more:

C#

{
            string Username = UserNTB.Text;
            string password = UserPass.Text;
            string Address = UserAdd.Text;

            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=PROMOD-PC;Initial Catalog=UserDB;Integrated Security=True";
            
            String QueryStr = "Insert into UserInfo(Username, Password, Address) Values (@UN, @UP, @UA)";

            SqlCommand com = new SqlCommand(QueryStr, con);

            com.Parameters.Add(new SqlParameter("@UN", UserNTB.Text));
            com.Parameters.Add(new SqlParameter("@UP", UserPass.Text));
            com.Parameters.Add(new SqlParameter("@UA", UserAdd.Text));


            con.Open();
            com.ExecuteNonQuery();


        }

when i input data to my interface and when i hit okay button it will point out con.open and gives exception unhndled error?

Posted 25-Feb-14 16:55pm

promod madushan

Add a Solution

Comments

PIEBALDconsult 25-Feb-14 23:04pm

Well? What's the error?

♥…ЯҠ…♥ 25-Feb-14 23:10pm

I would suggest you to put it in Try catch block and see the error it throws and come back again with error description

King Fisher 25-Feb-14 23:44pm

use try catch block.

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)

Abhinav S · Answer 1 · 2014-02-25T17:35:00

Solution 2

Check the query itself.
Try running it in SQL Server Management Studio.

Ensure all database values are of the correct type.

Posted 25-Feb-14 17:35pm

Abhinav S

Krunal Rohit · Answer 2 · 2014-02-25T17:09:00

Solution 1

C#

SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=PROMOD-PC;Initial Catalog=UserDB;Integrated Security=True";

try
{
    string Username = UserNTB.Text;
    string password = UserPass.Text;
    string Address = UserAdd.Text;
    
    String QueryStr = "Insert into UserInfo(Username, Password, Address) Values (@UN, @UP, @UA)";
    
    con.Open();
    SqlCommand com = new SqlCommand(QueryStr, con);  // here it requires Open Connection to the database
    
    com.Parameters.Add(new SqlParameter("@UN", UserNTB.Text));
    com.Parameters.Add(new SqlParameter("@UP", UserPass.Text));
    com.Parameters.Add(new SqlParameter("@UA", UserAdd.Text));
    
    com.ExecuteNonQuery();

}
finally
{
    con.Close();
}

-KR

Posted 25-Feb-14 17:09pm

Krunal Rohit

Comments

PIEBALDconsult 25-Feb-14 23:15pm

No it doesn't.

Krunal Rohit 25-Feb-14 23:19pm

Yeah of course, SqlCommand requires an Open conncetion.
Put your code try-catch-finally block and catch the exception and see what happens.

-KR

PIEBALDconsult 25-Feb-14 23:20pm

I never Open a Connection until after I assign the CommandText and set the Parameters.

Krunal Rohit 25-Feb-14 23:22pm

see my answer, before assigning it to command I've opened connection and in finally it is Closed.

-KR

PIEBALDconsult 25-Feb-14 23:28pm

Yes, you have, but even the MSDN example shows Opening the Connection after instantiating the Command.

Krunal Rohit 25-Feb-14 23:21pm

Whenever code gets excuted, ExecuteNonQuery() will require open conncetion.

-KR

PIEBALDconsult 25-Feb-14 23:26pm

Yes, but not until you try to Execute it.

Krunal Rohit 25-Feb-14 23:28pm

then what's the issue ?
-KR

PIEBALDconsult 25-Feb-14 23:30pm

He knows he needs to Open the Connection, but he seems to be having trouble doing so.

Krunal Rohit 25-Feb-14 23:32pm

What trouble man ?!
It's pretty simple and straight forward.

-KR

PIEBALDconsult 25-Feb-14 23:36pm

He hasn't even told us what the error is! The code he shows is OK. How can it be straight forward?

Krunal Rohit 25-Feb-14 23:38pm

Opening and Closing connection.

-KR

PIEBALDconsult 25-Feb-14 23:41pm

Most likely, though he hasn't clarified, until then all we can do is guess. It could that he has the wrong name of the server or database or no access.

promod madushan 26-Feb-14 8:20am

sql exception unhandled
Login failed for user ''.
this is the error

still occurs? :(

Krunal Rohit 26-Feb-14 8:22am

You have not provided any user credentials for the database in database connection string.
So make sure that you have proper user credentials of that in it. Then try again.

-KR

promod madushan 26-Feb-14 8:23am

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)

Full Error?
What is this and how i resolved this?

Krunal Rohit 26-Feb-14 8:25am

Error is self-explanatory :)
"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."

So do this,
All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”.

or you may go here : http://www.sswug.org/articlesection/default.aspx?TargetID=44331

-KR