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
Gizmo
NA
4
9.2k
oledbCommand parameters causing frustration - simple problem
May 5 2006 1:54 PM
Hello. I am using an Access database. Recently I learnt that it is not a good idea to pass information directly into an SQL query... and it is a good practice to use parameters instead. Note1: rentChecked_cmd is an OleDBCommand object Note2: I've already created the Parameter in InitialiseComponents() using the following statement: rentChecked_cmd.Parameters.Add(new OleDbParameter("RentID", Integer)); Well, heres my code, I've kept it simple private void returnBtn_Click(object sender, System.EventArgs e) { rentChecked_cmd.Parameters["RentID"].Value=int.Parse(whatever); rentChecked_cmd.CommandText = "SELECT DateDue FROM Rents WHERE RentID=@RentID"; mainConn.Open(); reader = rentChecked_cmd.ExecuteReader(); .... .... .... } When I click the "Return" button for the first time, everything works fine... but when I click it again.. the database tells me "Accessor is Invalid". After debuggined the error is throw by the reader = rentChecked_cmd.ExecuteReader() line This error is frustrating me cause I cant find any reason! Whats funny is that in my returnBtn_Click() method when I add the line "rentChecked_cmd.Parameters.Add(new OleDbParameter("RentID", Integer));"... it works.... But thats so stupid, I am not supposed to Add a new Parameter each time a button is clicked!!
Reply
Answers (
0
)
Getting tables_names from mdb file.
Populating the textboxes from DataGridView