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
scott
NA
2
0
connect Ms access DB oleDb problem
Jan 13 2009 2:33 AM
Hi again, I'm having trouble whilst connecting a MS access db using oleDB
Problem is with getting more than one column added into a listbox in my application from the DB
here's the code so far
OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Scott\\Documents\\Menu.accdb");
OleDbDataAdapter da = new OleDbDataAdapter(
"Select * from Menu", Conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
listBox1.Items.Add(dr["Dish"]);
}
}
I just can't find a way to get the second column added ?
thanks,Scott
Reply
Answers (
2
)
Plotting an Area
ask SQL expert here: GETUTCDATE and GETDATE