|
If I close connection in finally I need to close it in the function, this solves that problem but this causes another problem that the datareader does not read in the Subroutine because the connection is closed. I cannot close the connection in the finally of the Subroutine as it has been opened in the function.
I may just have to put everything in the Subroutine and just not bother splitting my code up into the Function.
macca
|
|
|
|
|
I see now...
you should initialize your connection object in Sub, pass it to Function as a parameter and close it in Sub after use. Or you can have your Function returning something else than SqlDataReader, DataTable for example, so you dont need to use connection in Sub and you can close it in Function.
Pilo
|
|
|
|
|
Hi,
We have to use the below overloaded method on the executereader method of the command obect to close the connection automatically, otherwise we have to cloase manually.
objCommand.ExecuteReader(CommandBehavior.CloseConnection)
Ram
|
|
|
|
|
Could you give me an example of this being used in some code.
macca
|
|
|
|
|
Thanks guys.
Got this sorted.
macca
|
|
|
|
|
I dont see you calling conn.Close() anywehere... call that method when you're done using the connection.
Nathan Lindley
.NET Aficionado
|
|
|
|
|
i m transferring data from sqlserver to sqlserver using webservices,when run the application from local machine data is getting tranferred correctly,but when i create exe and run the application the date showing one day lesser like if the date id 21/01/2006 its getting transferred as 20/01/2006
pls help me in solving
kavitha
|
|
|
|
|
please tell me about how can we pass values in a text box to another page by using QueryString
|
|
|
|
|
You can attach the value in the URL and there in the destination page you can retrive it using request.querystring
Best Regards,
Apurva Kaushal
|
|
|
|
|
can u please send me the syntax???
|
|
|
|
|
You can send value (which is kaushal in this case) with querystring like this:
string str = "../Destination.aspx?var=kaushal";<br />
Response.Redirect(str);
You can retrieve it like this in the destination page:
string str1 = Request.QueryString[var].ToString();
Best Regards,
Apurva Kaushal
|
|
|
|
|
sir
but one problem..How can i take values from contrils like textBox??
Please help me....
|
|
|
|
|
Like this:
string str = "../Destination.aspx?var=" + TextBox1.Text;
Best Regards,
Apurva Kaushal
|
|
|
|
|
t hank u
sir
|
|
|
|
|
always welcome..
And no need to call sir... I too am a developer..
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi ,
can we pass values from multiple textboxes...syntax too..
|
|
|
|
|
Hi ,
can we pass values from multiple textboxes...syntax too..
|
|
|
|
|
Yes you can pass multiple values this is how you can do that:
string str = "../Destination.aspx?var=" + TextBox1.Text + "&Var1=" + TextBox2.Text;
Best Regards,
Apurva Kaushal
|
|
|
|
|
If you are using ASP .NET 2.0, you can use "cross page posting". Take a look at this video tutorial: http://www.only4gurus.net/video/aspnet/hilo_tips_final.wmv[^] . The part about cross page posting begins at about 5:00 minutes into the video. It's a pretty cool feature if you don't want to use the QueryString.
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
hi there,
i have a javascript function
function Chk_Cancellation()
{
spring = window.confirm("Are You sure to Cancel Subsription ?");
if (spring == true)
{
return true;
}
else
{
return false;
}
}
which shows the confirmation box with "Ok" and "Cancle" button but i want a box with options "YES" and "NO" . please help me asap
thanx
Deepti
|
|
|
|
|
AFAIK, you cannot change these values, if you don't want it you may consider using your own confirm box with allows you to customize what you want. There are a couple of controls posted here at CP and available out there.
|
|
|
|
|
If it is JavaScript, then 'NO'. You can get this in VBScript. 
But if it is VBScript, then it is only IE on Windows. 
|
|
|
|
|
i want to open a pop up page for a perticular task.
pop up page of fixed size which conatin some web controls.
so how can i create pop up page in asp.net 2005 of fixed size. which apper on button click. such as some adverstiment appered on bank sides or on any other site.
dcjoshi2
|
|
|
|
|
Call the JavaScript function ‘window.open’.
window.open( [page name],[window name],'status=yes,width=700,height=400');
Thomas
|
|
|
|
|
Hi,
I'm quite a newbie to the ASP.Net game. I've built an application using Visual Web Devloper, ASP.Net 2.0 and C# which relies heavily on its database connection for frequent writes and retrieves. This is all running fine on my local machine.
I need to deploy it to a web server and set up ODBC access to the database as I have another application which will also be reading and writing to the database, simultaneously to the ASP.Net front end.
My questions are, what do I do to deploy this to a remote site? How do I set up security and access permissions for the ODBC connection? What facilities or specification will I require from my host? My database, as initially created has a .mdf file extension - when published will this be accessible to multiple concurrent users, or do I need to store the database in some other way. How do I upload the database to my server?
I appreciate that these are quite open questions, but I'd really value any help or direction you can give. You can see how little I know so far 
Thanks in advance,
Alice
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
