SqlException in app using SQL Server

Question

Hey I just started learning to make application in C# using back-end as sql. I put some breakpoints to see that the control never comes back after executing the cntCeilInn.Open(); soon, the output window shows 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Google tells me its not timing out or something that I couldn't understand. Some help please.

string strServerName="EXPRESSION";

using (SqlConnection cntCeilInn = new SqlConnection("Data Source=" + strServerName + ";" + "Integrated Security=YES"))
{
    SqlCommand cmdCeilInn= new SqlCommand("If exists ("+ "Select name "+ "from sys.database "+ "Where name=N'CeilInn1')"+ "DROP database CeilInn1;"+ "go"+ "create database CeilInn1;", cntCeilInn);
    cntCeilInn.Open();
    cmdCeilInn.ExecuteNonQuery();
}

You can try catch the Exception and debug with its Exception message. — Raptor
– Raptor, Commented Jan 17, 2013 at 6:11
Check the exception message and its details, post it with your question — Habib
– Habib, Commented Jan 17, 2013 at 6:11
Why do you have a string literal split up into little parts? Perhaps the problem is that there's no space between ) and DROP. — JLRishe
– JLRishe, Commented Jan 17, 2013 at 6:39

ibrahimBadredine · Accepted Answer · 2013-01-17 06:24:44Z

1

As connectionString parameter,you should use:

Data Source=yourServerName;Initial Catalog=yourDatabaseName;Integrated Security=True

make sure to modify youServerName and yourDatabaseName by appropriate data.

Note that you forgot to set the database name in your connectionString(Initial Catalog), and the value for Integrated Security is True.

answered Jan 17, 2013 at 6:24

ibrahimBadredine

665 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

praveen · Accepted Answer · 2013-01-17 06:40:49Z

0

There are few mistakes in your sql query .

It's sys.databases not sys.database
No space between Go and Create syntax
You need to place the sql statements in seperate line
Not to mention do check your connection string once as others have stated

Try this out

SqlCommand cmdCeilInn = new SqlCommand("If exists (" + "Select name " + "from sys.databases " + "Where name=N'Sample') DROP database Sample;" 
                      +Environment .NewLine+ "go " + Environment .NewLine 
                     +" create database Sample;", cntCeilInn);

answered Jan 17, 2013 at 6:40

praveen

12.3k1 gold badge44 silver badges50 bronze badges

1 Comment

praveen Over a year ago

@camelbrush : Please mark it as an answer if any of the suggestion helped you

Collectives™ on Stack Overflow

SqlException in app using SQL Server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related