which is faster for adding records?

[gmatteson]

using a datarow object or regular sql syntax such as..

Dim oCmdInsertSchool As New MySqlCommand("insert into school (name , db, host) values('" & txtSchool.Text & "', '" & txtDB.Text & "', '" & txtHost.Text & "')", oConn)
oCmdInsertSchool.ExecuteNonQuery()

rather than
dim orow as datarow

orow.items("name") = txtschool.text

thanks

[Edneeis]

It depends if how often/when you are updating the database or how many rows you are changing. If you want to change 10 rows in a row then a dataset and the second way would be faster than calling an update for each row. Also if you want to only update the database at selected times, in a delayed fashion, then the 2nd way could be faster but if you want to update immediately then go the first route.

[Memnoch1207]

Call a stored procedure and pass it the values needed.

[hellswraith]

Originally posted by Memnoch1207
Call a stored procedure and pass it the values needed.

Fastest way.

[indydavid32]

Could someone please post an example of a stored procedure that adds a new record to a database.

Thanks