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
Boblysan
NA
66
0
VERY basic one..
Apr 2 2005 9:44 PM
Ok, I am trying to perform what I believe to be an extremely simple task and am having difficulty. I am attempting to connect to an SQL database and retrieve a first name and last name based on a customer ID. I know the SQL is good as I can run it in query analyzer and it works fine. I can successfully open a connection to the DB in my application but can not figure out how to get the information from the database via the SQLDataReader (or any other method for that matter)
conn.Open(); MessageBox.Show("Connection Opened!!"); SqlCommand cmd = new SqlCommand("SELECT RTRIM (C536870914) + ' ' + RTRIM(C536870913) NAME, C536870980 PHONELOOKUP FROM ARSYSTEM.DBO.T55 WHERE C536870980 = " + txtCustID.Text, conn); reader = cmd.ExecuteReader(); string custName = reader[0].ToString(); txtCustName.Text = custName; When I run this application and attempt execute the above method I receive the following error. An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Invalid attempt to read when no data is present. I'm not sure why it says no data is present as when I run this query elsewhere it does return data. Any thoughts? Thanks, Bob
Reply
Answers (
1
)
Retrieving enum information
SqlDataAdapter Not working with parameters from C#