Hi, I have been doing asp.net for about a year and have always used VS .Net however I have stayed clear of the drag and drop tool to create data functionality. I thought I would learn to hand code first rather than rely on GUI tools.
However now I am getting my head round asp.net I have decided to start using the drag and drop DataAdapter and Connection objects to increase speed. But I am currently having a bit of a problem with them. I am currently facing two problem
1) I like to set my connection to my in my web.config file however when I drag my connection object onto the page it uses the Server Explorer connection. I then have to manually go and Dynamic Properties and change it to point to my web.config file. So I wonder is there any way I can get Server Explorer to use my web.config connection?
2) I am trying to create a page which will have several data adapter on it. When I create my first data adapter its creates the connection for it. However when I add another data adapter to the page it creates another sqlConnection object which seems to be a waste as a connection object already exists on the page. How can I get the GUI to use one connection object for several data adapter. Is this a manual job or am i using the GUI wrong.
Many thanks in advance
However now I am getting my head round asp.net I have decided to start using the drag and drop DataAdapter and Connection objects to increase speed. But I am currently having a bit of a problem with them. I am currently facing two problem
1) I like to set my connection to my in my web.config file however when I drag my connection object onto the page it uses the Server Explorer connection. I then have to manually go and Dynamic Properties and change it to point to my web.config file. So I wonder is there any way I can get Server Explorer to use my web.config connection?
2) I am trying to create a page which will have several data adapter on it. When I create my first data adapter its creates the connection for it. However when I add another data adapter to the page it creates another sqlConnection object which seems to be a waste as a connection object already exists on the page. How can I get the GUI to use one connection object for several data adapter. Is this a manual job or am i using the GUI wrong.
Many thanks in advance