Click here to Skip to main content
15,895,667 members
Home / Discussions / C#
   

C#

 
AnswerRe: Fill Combo box Pin
K V Sekhar6-Mar-09 20:35
K V Sekhar6-Mar-09 20:35 
QuestionC# Error of Lockbits Pin
Swati Khanna6-Mar-09 19:30
Swati Khanna6-Mar-09 19:30 
GeneralRe: C# Error of Lockbits Pin
Luc Pattyn7-Mar-09 1:49
sitebuilderLuc Pattyn7-Mar-09 1:49 
QuestionProviding trial period for an product Pin
K V Sekhar6-Mar-09 18:53
K V Sekhar6-Mar-09 18:53 
AnswerRe: Providing trial period for an product Pin
dan!sh 6-Mar-09 20:44
professional dan!sh 6-Mar-09 20:44 
GeneralRe: Providing trial period for an product Pin
K V Sekhar6-Mar-09 22:58
K V Sekhar6-Mar-09 22:58 
AnswerRe: Providing trial period for an product Pin
Xmen Real 6-Mar-09 23:57
professional Xmen Real 6-Mar-09 23:57 
GeneralRe: Providing trial period for an product Pin
K V Sekhar7-Mar-09 1:38
K V Sekhar7-Mar-09 1:38 
QuestionHow to execute SP from access in C# Pin
Pankaj Deharia6-Mar-09 18:34
professionalPankaj Deharia6-Mar-09 18:34 
QuestionNext Form Pin
Sajjad Leo6-Mar-09 17:58
Sajjad Leo6-Mar-09 17:58 
AnswerRe: Next Form Pin
Xmen Real 6-Mar-09 18:50
professional Xmen Real 6-Mar-09 18:50 
AnswerRe: Next Form Pin
K V Sekhar6-Mar-09 20:38
K V Sekhar6-Mar-09 20:38 
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 

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.