|
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.
|
|
|
|
|
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()
Connection.Close()
As all of them are Disposable, you can use Using Block.
|
|
|
|
|
|
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();
}
|
|
|
|
|
thank u Rana..
Now I'm clear..
|
|
|
|
|
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..
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Apply Ajax, the page needn't refresh, so the data will not be losed
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:53am.
|
|
|
|
|
Hi all,
I am getting the following error in Silverlight when i integrated silverlight with my previus application this error i am not getting on every system ..
Unhandled Error in Silverlight Application An exception occurred during the operation, making the result invalid. Check InnerException for exception details
how to fix this issue.
thanks,
Amit Patel
|
|
|
|
|
hi
I bound data from an stp to sqldatasource that link to a radgrid
I want to read data from current row special column of sqldatasource
(not from grid),that I want is similar this:
sqldatasource1.rowcurrent.columns["ID"].value
I try any solution but not success please help me.
|
|
|
|
|
You need the grid to find the data from the source.
You have to cast the Object sender in the method to the objecttype desired. I presume it is RadGridRow ( I do not use that object so better chewck your manual)
RadGridRow row = (RadGridRow)sender;
DataRowView dView = (DataRowView)row.NamingContainer;
Normally i use the GridView component and in that case it is:
GridViewRow row = (GridViewRow)sender;
DataRowView dView = (DataRowView)row.NamingContainer;
Good Luck
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Look I have all data in sqldatasource but don't add all of column in
grid it means that I want retrieve Data realty from grid's.
|
|
|
|
|
Hello,
i had a requirement to show a calender control with Last,Current and Next months with dates at time ( three months dates should be visible) in the calender control view and then provide an option to navigate to other months as it is in the normal calender control. Ideally the control always should show Three Months instead of single month. Please help me on this regard.
Thanks,
Vinay.
|
|
|
|
|
I had the same requirement earlier.For that ,I used three calendar controls, one for current another for last and next month and was syncing them on server side on any event.So you can follow this approach.
Cheers!!
Brij
|
|
|
|
|
Hi Friends
I'm currently doing a project regarding on sending sms using C#.
Is it possible to do it, if it is can anyone kindly share the code with me
Thanks in advance 
Best Regards
Veon Cheng
|
|
|
|
|
For This you need to take SMS gateway from service provider mobile compney after that you can
send sms...........
|
|
|
|
|
hmmm... is there any other way without using sms gateway from service provider mobile company
|
|
|
|
|
|
|
congrats!! abhishek you are now MVP..
|
|
|
|
|
Thank you so much bro...
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Please send us code for sms sending on mobile in asp.net windows application using C#...!!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
