TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
richard smith
1.4k
285
160.7k
C# OLEDBConnection
Mar 15 2013 6:23 PM
I want to use C# OLEDBConnection to open an access database and build a query in that database and then save the query. So for example, I want to build a query of SELECT * From tblCustInfo then after that I want to SELECT ZIP from tbl_City so the query would hold all of the info from tbl_custInfo and then the zips from tbl_City.
I know how to open a database via OLEDBConnection, I just don't know how to select data from tables (or 2 tables for that matter!)or how to save the query once I have it built out.
OleDbConnection olecon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseNamae);
olecon.Open();
Reply
Answers (
7
)
Make serial no 3 digits
i tried several times but it is not working the below code