ASP.NET

12-Jan-10 22:57

Hi Guys,

Can you someone advice me handling database in asp.net

Which is the best practice either closing database & recordset (i.e. sqlcommand,sqlreader etc) connection
as soon as getting the required data or just closing the recordset(i.e sqlreader, sqladapter) and retaining the database connection(i.e sqlcommand)

Thanks in advance.

Message Removed

12-Jan-10 23:36

Pranay Rana

12-Jan-10 23:36

Message Removed

Mohamed Asane12-Jan-10 23:55

12-Jan-10 23:55

thank Rana..

My question is

Is it fine to close the database connection once the transaction completed?

or

Is it fine to keep the database connection until closing the appln.?

Kindly clarify.

Abhishek Sur12-Jan-10 23:57

Abhishek Sur

12-Jan-10 23:57

Of course. You are right.

It is the new technology with ADO.NET. We now work with Disconnected Data Architecture.

We connect only when actual database is needed. We can create a replica of the original database (with relations) in our DataSet.

Though there is also an option to use DataReader which works similar to ADO.

So call :

Connection.Open()
Command.ExecuteNonQuery() // Anything here
Connection.Close()

As all of them are Disposable, you can use Using Block.

Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

Mohamed Asane13-Jan-10 0:08

13-Jan-10 0:08

thanks Abhishek..

Pranay Rana13-Jan-10 0:02

Pranay Rana

13-Jan-10 0:02

i think its better to close connection as your task of fetching record is completed because its feature of ado.net disconnected framework

for that below code is better tech.

the best way is use of using block

using(connectionobject)
{
// perform database related transaction here
}

its close your connection once it get executed successfully

or

use

try
{
}
finally
{
connectionobj.close();
}

Mohamed Asane13-Jan-10 0:07

13-Jan-10 0:07

thank u Rana..

Now I'm clear..

Post back in asp button

Hema Bairavan12-Jan-10 22:48

Hema Bairavan

12-Jan-10 22:48

Hi Peoples,

I am doing an asp application in which i have to do some validation with some values in the page as
text box and buffer by means of datatable,
but when i click the button my as its coming to the page load(post back)
my data table are getting cleared... its becoming null, even though i checked
!Ispostback,

how to do this, how to do that button click in the means that i should use all my values.

thanks in advance..

Re: Post back in asp button [modified]

Brij12-Jan-10 23:11

Brij

12-Jan-10 23:11

I think your data is getting removed on every postback so you can put your data in the viewstate and access it as per your requirement.

Cheers!!
Brij

Hema Bairavan12-Jan-10 23:17

Hema Bairavan

12-Jan-10 23:17

thanks for ur reply brij.

just now am googling though i found the same as u said, even though before posting here i did that, but i didnt find.
but how to use the view state?? is it possible to use for the data table also??

and one more thing brij.. view state wont be true by default..
and i am creating the dynamic controls??

modified on Wednesday, January 13, 2010 5:29 AM

Brij12-Jan-10 23:49

Brij

12-Jan-10 23:49

There is property ViewState of Page.You can access it from server side code like

ViewState["mydatatable"]=your datatable<br />
and access it as<br />
DataTable dt =(DataTable)ViewState["mydatatable"];<br />

Let me know if any query

Cheers!!
Brij

Pranay Rana12-Jan-10 23:30

Pranay Rana

12-Jan-10 23:30

Make your data table as

static private datatable dt
than try because value of the static varible dont get cleared during function call back and during page post pack