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
Katie B
NA
66
18.1k
List Box Option Selection
Apr 15 2013 3:51 PM
Sorry I know the subject isnt great, but it hard to get this question basis in a subject box. :D
I have a list box called degree programme, once a selection is made in this listbox, I want the modules associated with selection to appear in my modules listbox. I'm doing this through an access database. I'll post the code below which i've pieced together from things ive read, but I dont know how right/wrong it is.
private void lstboxDegreeProgramme_SelectedIndexChanged(object sender, EventArgs e)
{
String strItem;
foreach (Object selecteditem in lstboxDegreeProgramme.SelectedItems)
{
strItem = Convert.ToString(lstboxDegreeProgramme.SelectedItem);
string connectionString =
"provider=Microsoft.ACE.Oledb.12.0;" +
"data source=C:\\Users\Documents\\StudentRegistrationDatabase.accdb";
OleDbConnection myOleDbConnection = new OleDbConnection(connectionString);
OleDbCommand myOleDbCommand = myOleDbConnection.CreateCommand();
myOleDbConnection.Open();
myOleDbCommand.CommandText = "SELECT * FROM Modules WHERE CourseID = '" + strItem + "''";
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();
while (myOleDbDataReader.Read())
{
lstboxModules.Items.Add(myOleDbDataReader["ModuleID"].ToString() + myOleDbDataReader["ModuleName"].ToString());
myOleDbDataReader.Read();
}
I keep getting an error on the highlighted line saying Syntax error in string in query expression 'CourseID. But when i've put breaks in it runs up until that and i've been re-writing the code for the best part of today. Any help (as normal) is appreciated :D
Reply
Answers (
8
)
C# Visual Studio 2012 - Creating reference
profile