Click here to Skip to main content
15,887,027 members
Home / Discussions / C#
   

C#

 
QuestionReference to undeclared entity 'nbsp' Pin
C. Hariharan6-Mar-09 17:11
C. Hariharan6-Mar-09 17:11 
AnswerRe: Reference to undeclared entity 'nbsp' Pin
N a v a n e e t h6-Mar-09 17:40
N a v a n e e t h6-Mar-09 17:40 
GeneralRe: Reference to undeclared entity 'nbsp' Pin
C. Hariharan6-Mar-09 19:27
C. Hariharan6-Mar-09 19:27 
QuestionClient Server in C# Pin
mrithula86-Mar-09 16:51
mrithula86-Mar-09 16:51 
QuestionHolding a key down Pin
Jay Gatsby6-Mar-09 15:19
Jay Gatsby6-Mar-09 15:19 
AnswerRe: Holding a key down Pin
Xmen Real 6-Mar-09 18:46
professional Xmen Real 6-Mar-09 18:46 
QuestionPost with webclient doesnt work Pin
ika26-Mar-09 12:11
ika26-Mar-09 12:11 
QuestionCreate db and sps with C# Pin
CodingYoshi6-Mar-09 12:05
CodingYoshi6-Mar-09 12:05 
I have a custom action fired during installation which creates a database, tables, and stored procedures. I ran the whole script in Mgmt Studio and worked fine. However, from C# it gives error:

'CREATE PROCEDURE' must be the first statement in a query batch.

I researched and found out GO is not a T-Sql statement but for Mgmt studio. How can I get rid of the error. Here is my script skeleton:

CREATE TABLE Regions
(
RegionID SMALLINT NOT NULL PRIMARY KEY,
Description VARCHAR(50) NOT NULL
);

CREATE TABLE Vendors
(
VendorID CHAR(3) NOT NULL PRIMARY KEY,
Name CHAR(30) NOT NULL
);

CREATE PROCEDURE [dbo].[up_CancelOrder]
@PurchaseOrderID VARCHAR(6) = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
UPDATE dbo.PurchaseOrder
SET StatusID = 0
WHERE PurchaseOrderID = @PurchaseOrderID
END

CREATE PROCEDURE [dbo].[up_Something]

(
--eForm Fields
@Foo CHAR(8)
)

WITH RECOMPILE
AS
SELECT TOP 100 PERCENT Name
FROM ATable
WHERE AColumn= @Foo

CodingYoshi

Visual Basic is for basic people, C# is for sharp people. Farid Tarin '07

AnswerRe: Create db and sps with C# Pin
ABitSmart6-Mar-09 23:22
ABitSmart6-Mar-09 23:22 
QuestionHow to get the SELECT SCOPE_IDENTITY() - alternative Pin
ziwez06-Mar-09 11:45
ziwez06-Mar-09 11:45 
AnswerRe: How to get the SELECT SCOPE_IDENTITY() - alternative Pin
CodingYoshi6-Mar-09 12:09
CodingYoshi6-Mar-09 12:09 
GeneralRe: How to get the SELECT SCOPE_IDENTITY() - alternative Pin
ziwez06-Mar-09 12:18
ziwez06-Mar-09 12:18 
AnswerRe: How to get the SELECT SCOPE_IDENTITY() - alternative Pin
ziwez06-Mar-09 12:20
ziwez06-Mar-09 12:20 
AnswerRe: How to get the SELECT SCOPE_IDENTITY() - alternative Pin
Ennis Ray Lynch, Jr.6-Mar-09 17:08
Ennis Ray Lynch, Jr.6-Mar-09 17:08 
GeneralRe: How to get the SELECT SCOPE_IDENTITY() - alternative Pin
ziwez06-Mar-09 21:13
ziwez06-Mar-09 21:13 
GeneralRe: How to get the SELECT SCOPE_IDENTITY() - alternative Pin
Ennis Ray Lynch, Jr.7-Mar-09 6:34
Ennis Ray Lynch, Jr.7-Mar-09 6:34 
Questionbindingsource add new rec Pin
ABBASI_RA6-Mar-09 11:09
ABBASI_RA6-Mar-09 11:09 
AnswerRe: bindingsource add new rec Pin
Xmen Real 6-Mar-09 13:21
professional Xmen Real 6-Mar-09 13:21 
GeneralPersonal Tutor wanted to teach C#, Sharepoint Pin
keralaman6-Mar-09 9:41
keralaman6-Mar-09 9:41 
GeneralRe: Personal Tutor wanted to teach C#, Sharepoint Pin
Wes Aday6-Mar-09 10:05
professionalWes Aday6-Mar-09 10:05 
QuestionHow can i write a problem so the webpages comes to me Pin
netJP12L6-Mar-09 8:37
netJP12L6-Mar-09 8:37 
AnswerRe: How can i write a problem so the webpages comes to me Pin
Yusuf6-Mar-09 8:47
Yusuf6-Mar-09 8:47 
GeneralRe: How can i write a problem so the webpages comes to me Pin
Curtis Schlak.6-Mar-09 9:26
Curtis Schlak.6-Mar-09 9:26 
AnswerRe: How can i write a problem so the webpages comes to me Pin
Cybernate6-Mar-09 8:49
Cybernate6-Mar-09 8:49 
GeneralRe: How can i write a problem so the webpages comes to me Pin
Jim Crafton6-Mar-09 18:14
Jim Crafton6-Mar-09 18:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.