XML Import / Pocket PC

  • Thread starter Thread starter Steiner Hubert
  • Start date Start date
S

Steiner Hubert

Hello,
i use this code:
cmd.CommandText = "INSERT INTO Tabelle(Name,ID,Hersteller,Kombi) "
cmd.CommandText &= "VALUES ('"
cmd.CommandText &= rw.Item("tab_bezeichnung") + "','"
cmd.CommandText &= rw.Item("tab_id") + "','"
cmd.CommandText &= rw.Item("tab_hersteller") + "','"
cmd.CommandText &= rw.Item("tab_kombi")
cmd.CommandText &= "')"
cmd.ExecuteNonQuery()

how can i use this over the parameters?
cmd.parameters.??
 
hello,
can you give me a sample?

i use:
Dim cmd As New SqlServerCe.SqlCeCommand
cmd.Parameters.Add("Name", rw.Item("tab_bezeichnung"))
cmd.Parameters.Add("ID", rw.Item("tab_id"))
cmd.Parameters.Add("hersteller", rw.Item("tab_hersteller"))
cmd.Parameters.Add("kombi", rw.Item("tab_kombi"))
cmd.ExecuteNonQuery()

but this dosnt work
 
Back
Top