Re: INSERT and UPDATE

Tech-Archive recommends: Fix windows errors by optimizing your registry

Search for help under SqlCeParameter, SqlCeParameterCollection, SqlCeCommand
(especially the Prepare function).

--
João Paulo Figueira
Embedded MVP
http://nativemobile.blogspot.com/

"@tley" <atley_1@xxxxxxxxxxx> wrote in message
news:uFtYca0oFHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
>I am using VB.net CF
>
>
>
> "João Paulo Figueira [eMVP]" <joao.figueira@xxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote in message news:uEdZERwoFHA.3760@xxxxxxxxxxxxxxxxxxxxxxx
>> Are you using .NET CF or C++?
>>
>> --
>> João Paulo Figueira
>> Embedded MVP
>> http://nativemobile.blogspot.com/
>>
>> "@tley" <atley_1@xxxxxxxxxxx> wrote in message
>> news:e7Lo9$poFHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
>>> What do you mean? What are command parameters? How do I use them?
>>>
>>> I looked in both the VS 2k3 and the SQLServerCE help files and cannot
>>> find them anywhere.
>>>
>>>
>>> "João Paulo Figueira [eMVP]" <joao.figueira@xxxxxxxxxxxxxxxxxxxxxxxxx>
>>> wrote in message news:ekd$p2doFHA.3448@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Use command parameters.
>>>>
>>>> --
>>>> João Paulo Figueira
>>>> Embedded MVP
>>>> http://nativemobile.blogspot.com/
>>>>
>>>> "@tley" <atley_1@xxxxxxxxxxx> wrote in message
>>>> news:Oy4yXpdoFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> In VB.net 2003 is there a way to create insert and/or update
>>>>> statements so that if a string contains a ' or a " that it doesn't
>>>>> screw up the execution of the statement?
>>>>>
>>>>> any help would be greatly appreciated.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: pocket pc Listbox with two columns
    ... Create a regular list view on the dialog editor. ... >> João Paulo Figueira ... >> Embedded MVP ... >>> Chris ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: OLEDB is possible ?
    ... You can write a DLL to do this for you and call it from .NET CF. ... > You can read more about OLE DB and SQL CE 2.0 here: ... > João Paulo Figueira ... > Embedded MVP ...
    (microsoft.public.sqlserver.ce)
  • Re: OLEDB is possible ?
    ... Do you say that for eVC4 is necessary a special verion of the ... > João Paulo Figueira ... > Embedded MVP ... > Marcio Camurati ...
    (microsoft.public.sqlserver.ce)
  • Re: pocket pc Listbox with two columns
    ... Why don't you use a list view without header? ... João Paulo Figueira ... Embedded MVP ... > bar and one without), and any messages that go to one get echoed to the ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: Copying Data from MSDE 2000 to SQL Server CE
    ... Take a look at my company's website. ... tools you need for that exact purpose. ... João Paulo Figueira ... Embedded MVP ...
    (microsoft.public.sqlserver.ce)