Help to store in Ms Access

[Vinay Patel]

hi All

Q1.
i want to store string like

" vinay's home " in access database using vb.net

but my query get dropped because of " ' " in string input

and it become

Qry="Insert into info values('vinay's home')

i got error in this case so any one knows

how can i resolve it ??
Q2
is there any way to create store procedure for Access database if yes
than how ?
Waiting for Reply

Thanks in advance

With Regards

Vinay Patel

[Rad [Visual C# MVP]]

On 13 Apr 2007 22:39:39 -0700, Vinay Patel wrote:

hi All

Q1.
i want to store string like

" vinay's home " in access database using vb.net

but my query get dropped because of " ' " in string input

and it become

Qry="Insert into info values('vinay's home')

i got error in this case so any one knows

how can i resolve it ??

Q2
is there any way to create store procedure for Access database if yes
than how ?

Waiting for Reply

Thanks in advance

With Regards

Vinay Patel

Two options
1) Use parameterized queries (OleDB commands using OleDbParameters)
2) Replace all ' with '' using the String.Replace method
--
Bits.Bytes
http://bytes.thinkersroom.com

[Cor Ligthert [MVP]]

Hi Vinay

http://msdn.microsoft.com/library/de.../acfundsql.asp

http://msdn.microsoft.com/library/de...l/acintsql.asp

http://msdn.microsoft.com/library/de...l/acadvsql.asp

I hope this helps a little bit?

Cor
"Vinay Patel" <pa*****************@gmail.comschreef in bericht
news:11**********************@w1g2000hsg.googlegro ups.com...

hi All

Q1.
i want to store string like

" vinay's home " in access database using vb.net

but my query get dropped because of " ' " in string input

and it become

Qry="Insert into info values('vinay's home')

i got error in this case so any one knows

how can i resolve it ??
Q2
is there any way to create store procedure for Access database if yes
than how ?
Waiting for Reply

Thanks in advance

With Regards

Vinay Patel

[sloan]

Open up the database.

Add a new Query. Change the type to "Updateable" I think it is.

Start out with something simple like

qryCustomerUpdate

Maybe supply 2 parameters

pCustomerID , pLastName

and the query is

Update Customer Set LastName = pLastName where CustomerID = pCustomerID

the last time i did this (circa 2001 I think) i used to put 'p' s in for
parameters, to increase readability, since there is no @variableName like in
sql server.

It's something along those lines.

"Vinay Patel" <pa*****************@gmail.comwrote in message
news:11**********************@w1g2000hsg.googlegro ups.com...

hi All

Q1.
i want to store string like

" vinay's home " in access database using vb.net

but my query get dropped because of " ' " in string input

and it become

Qry="Insert into info values('vinay's home')

i got error in this case so any one knows

how can i resolve it ??
Q2
is there any way to create store procedure for Access database if yes
than how ?
Waiting for Reply

Thanks in advance

With Regards

Vinay Patel