|
The rule for database connections is simple. Open the connection to the database as late as possible, execute your batch as quick as possible, then close your connection as early as possible. It's very bad practice to hold open a database connection for the life of your app.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you so much for the information provide,I think I should learn more from you all in the future. Thats great you all really help me a lot on solving the problem. All the best and happy new year.
|
|
|
|
|
at LoadLibraryW(UInt16* )
at System.EnterpriseServices.Thunk.Security.Init()
at System.EnterpriseServices.Thunk.Security.SuspendImpersonation()
at System.EnterpriseServices.Platform.Initialize()
at System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb)
at System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl)
at System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl
)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn
ectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at checkConn.Module1.Main()
I am getting the above error, when I try to open a connection with local MSDE 2000 database
can you help me?
Thank You
|
|
|
|
|
hi all,
i have a problem dealing with cascading style sheet.
how do i link my style sheet (placed background pic inside) to Default.aspx (example).
i want the picture to appear when i run Default.aspx
error occurs when i tried.
error message:-
Error 1=> Cannot switch views: Validation (XHTML 1.0 Transitional): Element 'link' cannot be nested within element 'html'.
where shall i put this link then?
link: thanks for the help..
-DarkangeL-
|
|
|
|
|
Put your <link> tag in the <head> section.
Michael Flanakin
Web Log
|
|
|
|
|
Gee..
thanks for your help..
it does solve my problem..
thank you once again.
-DarkangeL-
|
|
|
|
|
I have an aspx page that generates an xml file and saves it to a directory using server.mappath. I want to use this page to generate that xml file when someone logs in. How can I reference this to make it happen?
E
|
|
|
|
|
Hadware,
use session or cookies to trace the login of users and then redirect to that XML page
something like this ...>
Session("strEmail") = Request.QueryString("ID")
Response.Redirect "xmlPage.aspx"
Session will be available on that page too and u can use this session to print some data according to it in XML format.
Hope it is helpful for you
R A M
|
|
|
|
|
Any thoughts on why changing a form's ShowInTaskbar property at runtime would cause an "Error Creating Window Handle" error?
Thanks ... George
"Evidently your parents slapped together version 1.0 of you and hoped no one would notice the bugs." ... Dogbert (tech support)
|
|
|
|
|
how do you open a web page in the default web browser using vb.net
http://ixpress.sourceforge.net/feedmonster
http://simpleread.blogspot.com
|
|
|
|
|
System.Diagnostics.Process.Start(WebURL)
... where WebURL is a string containing the URL of a web site
"Evidently your parents slapped together version 1.0 of you and hoped no one would notice the bugs." ... Dogbert (tech support)
|
|
|
|
|
If you want to test if the URL is reachable (e.g. an Internet connection is available and the URL is valid), pass the URL string to this function.
Private Function WebSiteIsAvailable(ByVal linkText As String) As Boolean
Dim URL_Object As New System.Uri(linkText)
Dim URL_WebRequest As System.Net.WebRequest
Dim URL_WebResponse As System.Net.WebResponse
Dim Response_Result As Boolean
' Attempt to get a response from the URL
Try
URL_WebRequest = System.Net.WebRequest.Create(URL_Object)
URL_WebResponse = URL_WebRequest.GetResponse
Response_Result = True
Catch Any_Error As Exception
Response_Result = False
End Try
URL_WebResponse = Nothing
URL_WebRequest = Nothing
URL_Object = Nothing
' Return the result
Return Response_Result
End Function
"Evidently your parents slapped together version 1.0 of you and hoped no one would notice the bugs." ... Dogbert (tech support)
|
|
|
|
|
thanks
i think this will do it
|
|
|
|
|
|
Why does this question reek of homework?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi there,
I just installed VS2005 and I found a new nice control: tabstrippanel,
in the VS help I just found some general info like "tabstrippanels are collapsible"...great but how can i collapse tabstrippanels?
I mean, I can collapse them in design mode but I can't at runtime, am I missing something (of course I am..), any help is greatly appreciated,
thanks in advance!
cheers!
F2R
|
|
|
|
|
Odd. TabStripPanel doesn't exist in any MS documentation.
Are you talking about Actipro TabStripPanel[^]? That's something we don't really support here. 3rd party controls are supported by their respective manufacturers. There's just way too many of them (thousands) to support here.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If you are talking about ToolStripContainer and ToolStripPanel: use the "BottomToolStripPanelVisible" (etc.) property of the container control.
|
|
|
|
|
oops!
yes ToolStripPanel, but I still have the same problem.
The BottomToolStripPanelVisible Property let me see the ToolStripPanel but at design time I see it with a little button with a arrow which let me expand and collapse it, at runtime the little (thin) button is not there anymore. I'd like to expand/collapse it at runtime to show or hide the controls in it.
thanks a lot!
F2R
|
|
|
|
|
Hi
I am a beginning VB.Net programmer and I am looking to create an application for both single machine as well as multiple machines over a network. Is there anything that needs to be changed in the initial set-up of the application ?
Forgive me if this is a simple answer.
|
|
|
|
|
It's a question that's impossible to answer because we know absolutely nothing of the application your trying to write. There is no "one thing" to change in any configuration file to magically make your application "network aware". You have to write your app to be network aware yourself...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
In previously posted messsage I asked how to detect controls I create by using for example New Panel and so on, and the answer was that all controls are stacked into a container/list called controls in Me.Controls(index).
But the thing now is that I want to delete/clear those newly created controls...so I can keep track of the index much better. I know there's a Me.Controls.Clear() but that kills all controls.
Is there a way to get around this?
Best Regards,
Hmmkk
|
|
|
|
|
The same way you referenced the control before. Just call it's Dispose method.
It might look something like this, your code will, of course, look different:
CType(Me.Controls(index), Control).Dispose()
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This is the code for the disposing:
Dim a As String<br />
For i As Integer = 1 To 10<br />
a = "pnlThing" & i<br />
For j As Integer = 0 To Me.Controls.Count - 1<br />
If Me.Controls(j).Name = a Then<br />
'Me.Controls(j).Dispose()<br />
CType(Me.Controls(j), Control).Dispose()<br />
<br />
End If<br />
Next j<br />
Next i
But this gives me ArgumentOutOfRangeException error=/ and the program crashes.
How to rewrite this code so that it will run throught all controls and kill those for who the text applies?
Regards,
Hmmkk
|
|
|
|
|
Looping through 10 different names, and the controls for each name, is very slow. I would suggest naming your panel controls that are removable with a common name prefix and a number and just going through the controls array once. It looks like you already have something like this, but just to be sure...
But, you're getting the IndeoxOutORangeException because when you Dispose the control, the number on controls in the collection is reduced by one, making the top end of your loop greater than the new number of controls in the Control array. The solution is deceptively easy -- Start and the end of the array and work your way back!
For i As Integer = Me.Controls.Count - 1 To 0 Step -1
If Me.Controls(i).Name.StartsWith("pnlThing") Then
Me.Controls(i).Dispose()
End If
Next
Note, you cannot use a For Each enumeration in this loop because of the same problem! Modifying the size of a collection during an enumeration is, in most cases, not allowed!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 11:02 Wednesday 28th December, 2005
|
|
|
|