Hi All, I am fairly new to asp.net and have a simple question (i hope). In regualr asp, I would typically open the database connection at the top of the page, then create a recordset object and the use that recordset object over and over throughout the page using .open/.close as needed. then finally close the close the connection and set the recordset objects to nothing.
from my reading on .net it seems like the author keeps opening the database connection anytime a query is run, so instead of before needing just one line of code (like objRs1.open "select * ...") I would now need 7 lines of code to create the dataset object. can someone please post some code of what they are actually do as best practice.
I am using a SQL database.
thx, Marc
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
well I would assume you would save the database connection string in the webconfig file to avoid issues later on when changing things around. but if you are going to run 4 queries on a single page do you run the first line more than once, and do you create multiple dataset objects or can you reuse...
thanks very much...
Sorry for the delay.
There are a lot of technologies in the Framework 2.0 to optimize your process depending on your needs.
- You can keep the connection opened and execute your 4 queries.
- You can execute the first query, close the connection and do some long running job with those datas in an asynchronous thread while you load the 3 other queries. Here is the link:
http://msdn.microsoft.com/
- You can use multiple datasets by optimizing the data caching:
http://www.developer.com/n
Business Accounts
Answer for Membership
by: nouloukPosted on 2007-12-21 at 10:10:36ID: 20515305
Hi mrferrari,
5 lines for me to fill your dataset:
OleDbConnection con= new OleDbConnection ("Provider =Microsoft.JET.OLEDB.4.0;"
DataSet myDataSet = new DataSet();
OleDbCommand CommandObject = new OleDbCommand ("Select * from employee");
OleDbAdapter myDataAdapter = new OleDbAdapter (CommandObject, con);
myDataAdapter.Fill (myDataSet, "EmployeeData");
Hope this helps.