|
 hi,
I confused with sql database connection state for SqlDataAdapter.Fill() method. SqlDataAdapter retrieve the data from database with closed connection with server exception "Invalid operation ..." but it won’t throw that exception. How it works?.. Plz clear my doubt.
friendly,
ranandbe
|
|
|
|
|
ranandbe wrote: I confused with sql database connection state for SqlDataAdapter.Fill() method
There's no need of any explicit open and close of the Database Connection when you use SQLDataAdapter. SQLDataAdapter will handle that for you. The DataAdapter will implicitly open the connection when it has to retrieve the Data and Close the connection Once it is done.
- Regards -
JON
Life is not measured by the amount of breaths we take, but by the moments that take our breath away.
|
|
|
|
|
Fill() method automatically open the connection and again disconnect after execution in case connection was not oper prior to execution of Fill() method, In case connection was open you will have close it manually.
|
|
|
|
|
Thanks for your information.
friendly,
ranandbe
|
|
|
|
|
since data adapter works with disconnected architecture....
data adaper opens and close connection automatically
Aswini
|
|
|
|
|
how can i know string between two particular tag in asp.net
|
|
|
|
|
from code behind or from javascript?
|
|
|
|
|
There are many ways to perform it totally depends what is the requirement
you have given very less information to get exact solution
Any way you can do it by using regular expression or
by using string's split method
check that method
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
using split you can define the starting index and number of characters...
of substring
with regular expression , you have to define the expression string format.
so the input string is compared with the expression string format
Aswini
|
|
|
|
|
Hi all,
Can anybody suggest a good ebook,site.. for learning the ajax control toolkit implementation.i mean what is an update panel, timer etc... some samples with code....
|
|
|
|
|
AJAX toolkit comes with a documentation for all the controls. You can see ASP.NET website for more information.
|
|
|
|
|
Hi All,
I Saw many chat samples. But I have many doubts, I created one chat application. In Home page I have link to open a Login window, When I click that the Login window is open,using Window.open method.
But What happened is, the other pages also opened like Login window's height and width. How to ctrl that?
Tell me any suggesition to solve this.
Thanks in advance
|
|
|
|
|
Hi,
pass height and width when you are opening any window.
Thanks,
Sun Rays
Rate this post if you like answer.
My Articles
|
|
|
|
|
Hi Guys I am using vs2003,
I like to show one page contained text in treeview control...,
Actually treeview built tool in vs2005 and windows forms...,
But in vs2003 i like to show some things like that way,
Its possible?,
Have any way is there to show some text in tree view?,
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
|
|
|
|
|
I want to get Local System time using ASP.NET not Server time as i use DateTime.Now it will give server time which i does not required.
|
|
|
|
|
Do you want this info on the server or the client ? I think javascript can get it, but then yuo'd have to put it in a hidden field or use AJAX to send it to the server.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
When I run my project i get the Permission Denied Error on IE 6.0 , But when I run it in Firefox then it works fine. What s the reason for that. Any Solution for that.
Thanks in Advance.
|
|
|
|
|
There are a number of reasons for this, one could be that you're writing to the page using javascript before it is loaded. I had that recently.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thanks for ur replay but my JS are called after page load.
My question s that why it is working in Firefox.
|
|
|
|
|
Hi,
I need your valuable suggestions and ideas regarding NUnit test for my asp.net we application..my senior told me that there are test cases should be developed for my application using NUnit but i don't know what exactly this...please help me or suggest me something good for me...
expecting your reply....alex.
|
|
|
|
|
You should use google. The answer is, you can't really test your presentation layer, but you can test your business and data layers.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
In my project there is one table to store the user login details.
When the user logout, i want to store the logout time in the table.
But when the user close the browser without logging out, i can not store the Logout time.
How can I get the Logout time in this case.
Plz help me...
|
|
|
|
|
In this case you will have to consider the session timeout time
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
could you plz give me any sample codes for that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
