SQL database creation error while executing "ExecuteNonQuery" in C#

Question

I want to Deploy C# application with SQL database. I am using database scripts in MSI insataller. My database scripts working fine on DBCC (database console command) of SQL server 2005 management studio. But while executing "ExecuteNonQuery" in installer it gives exception shown in screen shot. enter image description here

How can I resolve it? I am using following connection string.

                    connString = "Data Source = " + machineName + "\\SQLEXPRESS; Initial Catalog = master; Integrated Security = SSPI";

Can you post the query that is being executed? Looks like the query is syntactically not correct. — Pawan Mishra
– Pawan Mishra, Commented Dec 3, 2011 at 7:02
i hope people can help you better if you post your code & query along with this exception screenshot. — Peeyush
– Peeyush, Commented Dec 3, 2011 at 8:09

Justin Beckwith · Accepted Answer · 2011-12-03 07:03:04Z

2

You can't use the 'GO' command inside of a SqlCommand like that. Here's a good explanation and a few workarounds:

http://weblogs.asp.net/jgalloway/archive/2006/11/07/Handling-_2200_GO_2200_-Separators-in-SQL-Scripts-2D00-the-easy-way.aspx

answered Dec 3, 2011 at 7:03

Justin Beckwith

7,8761 gold badge38 silver badges57 bronze badges

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

Comments

Nikola Radosavljević · Accepted Answer · 2011-12-03 07:08:18Z

1

Place semicolon (;) after each GO statement, or even better each statement. When using DML statements, SQL Server accepts them without semicolons, but when using GO you have to delimit them.

answered Dec 3, 2011 at 7:08

Nikola Radosavljević

6,91135 silver badges44 bronze badges

Comments

Peeyush · Accepted Answer · 2011-12-03 08:14:36Z

1

Have a look on this;

http://smehrozalam.wordpress.com/2009/05/12/c-executing-batch-t-sql-scripts-with-go-statements/

answered Dec 3, 2011 at 8:14

Peeyush

4,89817 gold badges67 silver badges93 bronze badges

Comments

Asken · Accepted Answer · 2011-12-03 07:05:27Z

0

Replace go with new line (\r\n). That will run all the commands in the string var in sequence.

answered Dec 3, 2011 at 7:05

Asken

8,14711 gold badges50 silver badges84 bronze badges

Collectives™ on Stack Overflow

SQL database creation error while executing "ExecuteNonQuery" in C#

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related