How do I insert multiple rows to a database in a loop using c#

See more:

C#

i have the following sql command which inserts a defined number of rows into a table

INSERT INTO table1(column1, column2) VALUES ('1','2'), ('3','4'), ('5','6')

how can i use c# to make such a query given that the number of rows are not defined. I would want to use a loop to add columns as determined by the user. I tried lookin for solutions but couldnt get an understandable one. Any form of help will be appreciated