XML Import / Pocket PC

[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.??

 

[Sergey Bogdanov]

See this for example:
http://msdn.microsoft.com/library/d...emdatasqlservercesqlceparameterclasstopic.asp

 

[Steiner Hubert]

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

 

[Sergey Bogdanov]

Sorry, gave you wrong link. This link contains an example how to use
parameters:
http://msdn.microsoft.com/library/e...aSqlServerCeSqlCeCommandClassPrepareTopic.asp

 

[Steiner Hubert]

thanks!