How to call the ms-access query in windows vb.net

Posted by Rrana under VB.NET on 7/23/2012 | Points: 10 | Views : 5120 | Status : [Member] | Replies : 4
Hi All,

i have wrote parameterized query in ms-access.
can any one tell me that, how can i call that query in windows vb.net

___Query

UPDATE Wsr_UserDetails SET Wsr_UserDetails.[Password] = [Pwd]
WHERE (((Wsr_UserDetails.UserId)=[Uid]));
-----------


Thanks in advance

Sucharitha Goud
Bank Of America..



Responses

Posted by: Hemanthlaxmi on: 7/23/2012 [Member] Starter | Points: 25

Up
0
Down
Use Oledb Provider to Connect to the Access Database.So that you can pass the Parameters as for the SQL Server Passed Parameters.
Check this link
http://kyokasuigetsu25.wordpress.com/2011/01/16/how-to-connect-ms-access-with-vb-net-using-oledb-2/

If this helps you .
Please "Mark as Answer"

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/23/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
look at this link
it will help u
http://www.codeproject.com/Articles/26801/Insert-Update-Delete-Search-Values-in-MS-Access-20

.

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 7/31/2012 [Member] Silver | Points: 25

Up
0
Down
Please refer this http://www.techonthenet.com/access/modules/recordset.php

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 7/31/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as answer if it helps...,That motivates...!!!

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response