[RESOLVED] add rows

[citizenstitch]

how do i add records into my sql ce table. i dont have a dataset so i cant use my other sql sample.

[citizenstitch]

answered my own question. found this on a microsoft site

'Create a SqlCeCommand on your connection
        Dim insertCommand As SqlCeCommand = sqlConn.CreateCommand()
 
        'Set the CommandText for the command
        'The ?'s represent parameters that will be set later
        insertCommand.CommandText = "Insert Into People(f_name, l_name) Values (?,?)"
 
        'Add parameters and assign them the values from the TextBoxes on the form
        insertCommand.Parameters.Add(New SqlCeParameter("f_name", SqlDbType.NText, 50))
        insertCommand.Parameters.Add(New SqlCeParameter("l_name", SqlDbType.NText, 50))
 
        insertCommand.Parameters("f_name").Value = txtFName.Text
        insertCommand.Parameters("l_name").Value = txtLName.Text

[Strider]

i'd recommend once you have added all the parameters the .prepare method on the sqlcommand

insertCommand.Prepare()
insertCommand.ExecuteNonQuery()

[citizenstitch]

what is prepare?

[Strider]

its sort of precompiles the sql statement so if there are any mismatches in datatype or data type lengths it will throw an exception before actually attempting to insert to the database and then throwing the exception.

it is just more efficient and faster, especially if you are inserting many records at a time