|
Well it depends on your logic, typically after looping through datareader's results you can close the connection.
If you are asking how to close connection, then you can use Close() method under SqlConnection class.
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
Actually, in case of other methods like ExecuteNonquery or ExecuteScalar i can use sqlconnectionobject.close() immediately after execution, in business layer itself. but in case of ExecuteReader i think its not possible as it follows the connected data model. My question is this, whether i can close the sqlconnection in the businesslayer itself, when i am using ExecuteReader and i want to return a value to the presentation layer.
I hope you understood the scenario.
thanks
sebastian
|
|
|
|
|
Yes i got you, but this is not possible with data readers. Data readers comes into 'Connected' approach - meaning you will be connected to the db until you get your last row fetched from the data reader. If you close your connection first, nothing will be returned by the data reader.
I guess you need to use DataSets for this.
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
If you want to close your sql connection as soon as possible you should probably return back a dataset. Once the dataset is populated you could close the connection. You can not close the connection if you are still reading from the sqldatareader.
Ben
|
|
|
|
|
thank you for the reply
Sebastian
|
|
|
|
|
The ExecuteReader method doesn't fetch the data, it only creates the data reader that is used to fetch the data. The data reader doesn't contain all the data, the data remains on the database server until you read it. When you have read all the data you want using the data reader, you can close the data reader and the connection.
---
single minded; short sighted; long gone;
|
|
|
|
|
Actually, in case of other methods like ExecuteNonquery or ExecuteScalar i can use sqlconnectionobject.close() immediately after execution, in business layer itself. but in case of ExecuteReader i think its not possible as it follows the connected data model. My question is this, whether i can close the sqlconnection in the businesslayer itself, when i am using ExecuteReader and i want to return a value to the presentation layer.
I hope you understood the scenario.
thanks
Sebastian
|
|
|
|
|
Dear all,
I my application i am using datagrid,by populating with the xml file my problem is how can i update the xml file i can able to delete but updation i am facing problem can any body can give me the idea so that i can accomplish my task.
thanks and regards,
Subbu.
-- modified at 8:51 Thursday 3rd May, 2007
|
|
|
|
|
That shouldn't be too hard. You can save a dataset as an xml file and replace the copy that you opened. DataSet.WriteXml method to do this.
|
|
|
|
|
Hi,
I have a Asp.Net application in which i have designed a salary slip with datas fetched from the database for each employee in a single form named SalarySlip.aspx. In that i have to print the form inorder to print the salary slip when we click print. For that is there any option in .net? If so pls provide me with source code examples..
Regards
Vijay.
|
|
|
|
|
I suppose that you want to print on a printer connected to the client computer, not to the server? In that case the solution has nothing to do with ASP.NET. Use Javascript:
window.print();
---
single minded; short sighted; long gone;
|
|
|
|
|
Let me know how will it appear if you choose from the combobox by selecting a table name and will it work
Romeo
|
|
|
|
|
What is your question? Try to be more descriptive
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
Please refere the link given below...It will help you
here[^]
The secret of life is not enjoyment
but education through experience.
- Swami Vivekananda.
|
|
|
|
|
Hi,
How to disable a specific item present in a dropdownlist!
For example i have a dropdown list with following values:
india
australia
america
now, in the dropdownlist 'india' should be visible but the user should not be provided with a provision to select it!!!!
Gautham
|
|
|
|
|
Well you can always add a Javascript to alert the user of wrong selection and reset it.
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
hi all ,
problem as follows ,
i am using method called
public void ExecuteNonQuery(string sql) inside Database Class .functionality of this method is takes the sql query and execute by using sqlcommand class here each method for example AddSubscriber() method is for inserting values into Subscriber table and AddSubscriberLogin() this is for inserting values into Subscribelogin Table and we have a link table called Subscribrsubscribelogin()
wihich containes both Subscriber and Suscriberlogin Id's so Due to Some problem like internet the values are not stored into SubscriberSubscriberlogintable so clint canot see all logins of Subscribers i got an idea of using sqltransactions i used as follows
Code:
in subscriber class
class Subscriber
{
AddSubscriber()
{
string sql="";//insert query
ExecuteNonQuery(sql);
}
but this code is not working. i need like to add All methods like AddSubscribeLogin() And AddSubscriSubscribeLogin() After that only i have to Commit other wise rollback all table values.
}
public void ExecuteNonQuery(string sql)
{
SqlConnection connection = new SqlConnection(databaseConnection);
try
{
connection.Open();
transaction=connection.BeginTransaction();
SqlCommand command = new SqlCommand(sql, connection);
command.Transaction=transaction;
command.ExecuteNonQuery();
transaction.Commit();
}
catch(Exception ex)
{
transaction.Rollback();
}
finally
{
connection.Close();
}
}
but when i am calling in each method it is commit always can u suggest any solution please .
Thanks And Regards,
Kinnu
-- modified at 6:51 Thursday 3rd May, 2007
|
|
|
|
|
I am getting problem in doing data modifications(insert,update,delete) in my CUSTOM DATABASE that i have created instead of using the default(i.e ASPNETDB.MDF that gets created by aspnetsqldataprovider by asp.net which also provides different asp.net services such as membership,role,profiles etc)
what exactly i must do?
also i want to know the way one can change default provider in asp.net 2.0 for different services.
m.h.adhia
|
|
|
|
|
There's this file that I wanna open from my web application, but I want it to open by Google Earth, the file is not located on the server it's on the user's computer but the application knows its name and path: "C:\\Places.kml"
How can I do that? I'm using ASP.NET web application in C#
|
|
|
|
|
You can't open files on the users computer. You have have the user upload the file to the web server and then you can open it.
Ben
|
|
|
|
|
Can I know if there is any testing tool to test the dotnet applications?
|
|
|
|
|
Being a developer you should test ur application with unit testing only.
there are lot of tools available to test the application that will be carried out by the testing or QA dept.
Regards,
Satips.
|
|
|
|
|
Remind me not to hire a developer that only tests his theapplication with unit tests, or rather one that broadly asserts developers should only use unit tests. I would recommend other people also avoiding such appointments.
|
|
|
|
|
In what way you want to test your application there N number of tool available in the market ...
Do you want to see the performance, Code review, etc of your application
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
I want to see performance and Code review also
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
