Answer Wiki

You need to create a SQLConnection object as well as a SQLDataReader object as well as a SQLCommand object and use them to execute the SQL Statement in the SQLCommand object against the SQLCOnnection object and put the output into the SQLDataReader object.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 3 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Repeater Control
The "MyRepeater" instance is an example of carlosdl's implementation of the Repeater class. Essentially all of the examples above, minus the calls to MyRepeater, are how you connect to the db, execute T-SQL commands, and get datasets back. He just uses a Repeater to handle the data, you could attach it to a listbox (or any number of other controls) if you so choose.
Using VS2005 you can also use the SHIFT+ALT+D to open the datasources window and add your database. From there you can drag and drop columns and tables to your forms and they will be automatically databound.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy