sqlite insertRow question!
Posted: Sat 07 Nov 2020 14:10
Hi,
From this https://www.devart.com/dotconnect/oracl ... mmand.htmlit seems unclear.
I am wanting to add multiple rows to the sqlite table.
I have tried the following 2 pieces code but only the first row in my table added. Can you clarify more?
X
sqlitecommand.CommandText ="INSERT INTO " ...
//row1:
sqlitecommand.Parameters.Add("param1", number(1))
sqlitecommand.Parameters.Add("param2", number(2))
//row2:
sqlitecommand.Parameters.Add("param1", number(3))
sqlitecommand.Parameters.Add("param2", number(4))
....
sqlitecommand.ExecuteNonQuery()
ex2
//row1:
sqlitecommand.CommandText ="INSERT INTO " ...
sqlitecommand.Parameters.Add("param1", number(1))
sqlitecommand.Parameters.Add("param2", number(2))
sqlitecommand.ExecuteNonQuery()
//row2:
sqlitecommand.CommandText ="INSERT INTO " ...
sqlitecommand.Parameters.Add("param1", number(3))
sqlitecommand.Parameters.Add("param2", number(4))
sqlitecommand.ExecuteNonQuery()
From this https://www.devart.com/dotconnect/oracl ... mmand.htmlit seems unclear.
I am wanting to add multiple rows to the sqlite table.
I have tried the following 2 pieces code but only the first row in my table added. Can you clarify more?
X
sqlitecommand.CommandText ="INSERT INTO " ...
//row1:
sqlitecommand.Parameters.Add("param1", number(1))
sqlitecommand.Parameters.Add("param2", number(2))
//row2:
sqlitecommand.Parameters.Add("param1", number(3))
sqlitecommand.Parameters.Add("param2", number(4))
....
sqlitecommand.ExecuteNonQuery()
ex2
//row1:
sqlitecommand.CommandText ="INSERT INTO " ...
sqlitecommand.Parameters.Add("param1", number(1))
sqlitecommand.Parameters.Add("param2", number(2))
sqlitecommand.ExecuteNonQuery()
//row2:
sqlitecommand.CommandText ="INSERT INTO " ...
sqlitecommand.Parameters.Add("param1", number(3))
sqlitecommand.Parameters.Add("param2", number(4))
sqlitecommand.ExecuteNonQuery()