Repitition of a query in sql server from C#.NET Winform application

Question

i want to run the same query ten times.

INSERT INTO items VALUES ('item_name')

GO 10

i can use GO , but i want to do this from my .net winform application. when the user clicks a button then the query gets executed and inserts 10 rows into the table ITEMS. whats the solution for this ?

marc_s · Accepted Answer · 2011-03-07 06:06:58Z

4

You need to do this in your C# code:

for(int i = 1; i <= 10; i++)
{
   cmdInsert.ExecuteNonQuery();
}

The GO is not a valid SQL keyword - it's a SQL Server Management Studio addition that works only in SSMS (and btw: you can rename that to anything you like in the SSMS options dialog - try renaming it to SELECT and have some fun :-) )

answered Mar 7, 2011 at 6:06

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

2 Comments

sqlchild Over a year ago

sir , when GO can't be used from C# application, then in real applications , is there any use of it? like developers do use it, if yes, then where?

marc_s Over a year ago

@sqlchild: "GO" is used in SSMS - and only there.

Muhammad Akhtar · Accepted Answer · 2011-03-07 06:07:51Z

1

You can loop to your insert command

answered Mar 7, 2011 at 6:07

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Comments

Pete M · Accepted Answer · 2011-03-07 06:18:31Z

1

In straight SQL:

DECLARE @I INT

SET @I = 0

WHILE (@I < 10)
BEGIN
   INSERT INTO items VALUES ('item_name')
   SET @I = @I + 1
END

answered Mar 7, 2011 at 6:18

Pete M

2,04811 silver badges17 bronze badges

Collectives™ on Stack Overflow

Repitition of a query in sql server from C#.NET Winform application

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related