How to use SqlCommand with included two queries

Question

First question, I would like to implement two queries in one command.

What is the correct syntax that should I followed?

I tried this

SqlCommand cmd = new SqlCommand("BEGIN;" +
                " INSERT INTO Booking(Arrive, leave, RoomId)" +
                " VALUES(@Arrive, @leave, @RoomId);" +
                " INSERT INTO Customer(CustomerId, CustomerName, birth_day, City, Phone, Email, Gender)" +
                " VALUES(@CustomerId, @CustomerName, @birthday, @City, @Phone, @Email, @Gender); COMMIT; ", con)

Second one : can I put "if statement" before SqlCommand ?

For example :

if (x = 1) 
{
    SqlCommand cmd = new SqlCommand("BEGIN;" +
                " INSERT INTO Booking(Arrive, leave, RoomId)" +
                " VALUES(@Arrive, @leave, @RoomId);" +
                " INSERT INTO Customer(CustomerId, CustomerName, birth_day, City, Phone, Email,Gender)" +
                " VALUES(@CustomerId, @CustomerName, @birthday, @City, @Phone, @Email, @Gender);COMMIT; ", con)
}
else
{ 
    SqlCommand cmd = new SqlCommand("insert into Customer(CustomerId, CustomerName, birth_day, City, Phone, Email, Gender)" +
                " values(@CustomerId, @CustomerName, @birthday, @City, @Phone, @Email, @Gender)", con)
}

Vivek Nuna · Accepted Answer · 2020-07-05 05:30:37Z

1

Yes, you can use stored procedure and call as many as query inside it.

Yes you can use if statement but it should be if(x == 1.

I think your query should also work, don't need begin and commit

edited Jul 5, 2020 at 5:30

answered Jul 5, 2020 at 5:23

Vivek Nuna

30.6k34 gold badges162 silver badges259 bronze badges

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

2 Comments

Pepsi Over a year ago

I think my mistake in first query is semicolon, Should I remove all ";" ? , If yes, should I replace them by something else like "+" ?

Vivek Nuna Over a year ago

@Pepsi use this ` " INSERT INTO Booking(Arrive, leave, RoomId)" + " VALUES(@Arrive, @leave, @RoomId);" + " INSERT INTO Customer(CustomerId, CustomerName, birth_day, City, Phone, Email,Gender)" + " VALUES(@CustomerId, @CustomerName, @birthday, @City, @Phone, @Email, @Gender);`

Collectives™ on Stack Overflow

How to use SqlCommand with included two queries

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related