Find Where This Code Might Be Leaving Old Connections Open
Jan 11, 2010
I'm trying to find where this code might be leaving old connections open, and I found this code that might be the cullprit. It is in a function. I'm wondering if this connection would close, if an exception occured from within the USING statement?
I am experiencing a strange issue with a VB6 -> VB.Net conversion. There is a function that uses ADOX to look through the tables in a given database, and reset the seed values of any columns in said tables with the auto increment property set to true.I tracked the issue down to a call of "col.Properties("Autoincrement").Value". If this line of code is commented out, then the file handle properly terminates when I close both the ADO and the ADOX connections at the end of the function. If I leave that line in, the handle stays open despite the closing calls and forcing garbage collection.Here's how I am closing the objects:
System.Runtime.InteropServices.Marshal.ReleaseComObject(adoConn) Dim connection As ADODB.Connection = cat.ActiveConnection If Not connection Is Nothing Then
When a user leaves a TextBox on the form I execute a format and save to a variable. This is saved to a database by clicking on a ToolStrip button.
The problem occurs if the user moves the mouse directly from the TextBox to the Button. Neither the Leave event or the Lost Focus event is triggered, the variable is not created and, of course not saved.
If I put the code in the Save Button and the User moves to another control, the formatting(data type Double to currency format in the TextBox) that I want to show is not executed.
I'm trying to update an old code that I don't have the source code for. In this code, the user enters an integer in a textbox as part of a form. Once they move to the next textbox a new form opens to input the number of files that the user chose (in the textbox).I have created all of the forms, but I can't figure out how to get the code to open the new form once the integer has been entered in the textbox and the cursor has moved to the next textbox. I would prefer this to happen automatically and not involve a button.
I searched on google for these terms : "How to see all open connections in vb.net" and it should be for a server im running and it would be like to see witch users are connected (ip) and then if i type in the console -disconnect ip then the user will be disconnected from the server but is this technical posibble ?
I have never made a notepad like program just calculators and felt like learning how to link/find the parts to make save, open, format, and some other extras but I have NO code. I can't move on unless I know the parts needed and what the code for one of them is if I can link the save as button on the menu bar to the part needed to save I can figure the rest out besides the format that it saves in.
I've been working on a GUI in WPF which I'm fairly new to, having only used Windows Forms up until now. So far, my GUI is very simple: it contains two rectangles, each of which drops a shadow. The shadow creates an effect of rectangles "floating above the canvas" so to speak.
When one of the rectangles is pressed, the myRectangle.MouseDown event is handled such that the shadow goes away, thus creating an effect of the rectangle being pressed down onto the canvas, like a button.Similarly, when mouse button is released, the myRectangle.MouseDown event is handled such that the shadow reappears and the rectangle "floats" again. This behavior make them resemble buttons. Note, there a reasons I want them to be rectangles and not custom buttons.
[Code]...
If the pointer leaves a rectangle while mouse button is pressed, I'd like shadow to reappear. This is arguable simple, because theoretically in this case, any time myRectangle.MouseLeave is raised, the shadow should come back on, even if it was already there.If the pointer left a rectangle when mouse button was pressed, then came back while before the button was released, I want the shadow to disappear again. This one is what gives me problems. No idea how to do this.
I want to compress an ms access database using vb.net. If the database is open this fails. How can I close the database, compress it, then reopen the database using vb.net code to accomplish this. I've already successfully written the code for compression, but I can't find anything on closing the database while leaving ms access open.
This thread (Question) is a continuation of a question answered by JohnWein. the original question asked by me in this thread:http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/4d9b44a0-91ed-4f64-a3a2-74afffce2256 an this is the answer:
[Code]...
The question is, in the case of four connections, how can I make sure that all points are connected with minimum number of connections using the same above code?
How to get the active connections like these examples does I just want to keep it simple but basicly i want to get some information about the network connections that are open like these examples does
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
I am extremly new to this concept of aps.net and vb. all the tutorials I see are c# based or very basic for vb. What I have is a contact forum with some basic information. I got the whole "check if the user has input information correctly down pat how ever Its this whole, connecting to a database (sdf) if in another vb file ands calling that method into aspx file and proessing forum input to say "take this, insert into bla..." I come from java, JSP and J2ee bak ground where its not that diffrent and I dont have all week to read books and take baby steps. I have until tuseday morning to finsih this. Right now I am as far as forum validation....
I have a program that runs some code when i click a button on a form when done running the application ends. I want to automaticaly run the code when the users clicks on the exe. I have put the code that i want to run in the startup forms load event but that doesn't start
I have a windowform and in my form , have a text box & a button.I write a word in textbox then click on button. I want open a pdf file and find and highlight words that I write in textbox.how to open pfd and find & highlight words in it by vb.net?
I have already managed to get friendly urls working with my cms; however, what i want to know is: with asp.net 4.0 routes options, how do i get a root leaving routing? When user types in www.mysite.com/page_name, which is aboutus, it goes to the page cms.aspx but leaves the other routes intact:
So I have a few variables in an array a I want to compare another variable to each of them, if it is the same do something, AND STOP THE FOR LOOP. else carry on the for loop. So...
for i = 0 to 4 if variable = a(i) then do some stuff
[code]....
how do i end the for loop from within an if statement that is in the for loop
Upon my program startup, I need to see if an Excel 2003 file with a certain name is open and then control it (set a reference to it). Unfortunately, the path of the Excel file is not set; else I could just detect if that file was open. So I guess I need to somehow loop through all open instances of Excel; then once I set an Excel app reference to each instance I could loop through the workbook names... But how would one go about looping through open instances of Excel in VB.net 2008?
this is urgent. i have a form in which i need to give timedelay of 3 seconds before each line executes. But when i try system.threading.thread.sleep its freezing the UI and furthermore all delays are executing as one single delay. that is
I have a modal pop up that is supposed to upload documents. It does that just fine, except that it doesn't give them a title, therefore nothing shows up on my page since Title is how they show up in the list. What should I replace LinkTitle.Text with to get this to work?I am trying to fix this guys code because none of it worked right. I added a comment below that has new code in it that is parameterized. This is in ASP.net 4.0 VB using Microsoft SQL Server.[code]
I find that if I do me.close and then reopen the form with showDialog later, things are as they were before I closed it. If I use me.dispose and then later open the form again, its as if it was never opened before. Are these two both valid methods for leaving a form?
Leaves the user no options to do anything with the program.What I want is to disable everything using the given line (or if anything else), but leave a Menustrip enabled.
I'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
Im currently working on a taskbar, in which you can totally control:
* Processes * Services * This feature I want to add: Windows, that are currently being runned like in the taskbar. or e.g. when you open your taskmanager under applications.
I'am Using Visual studio 2010 from 1 year , and it's work fine But Today when I tryed to open the Vs2010 an Error Msg was Appeared to me which is (Cannot Find One Or More Components please reinstall the application.)
Using a timer, am making a rectangle platform move from left to right. The problem is that it leaves a trail of itself and I believe this is down to refreshing or something. here is the timer code if your interested:
If shaperet = False Then Timer2.Start() platform.Left -= 4
I'm looking for a way to process the text entered into a textbox, before the the focus is lost from the control. Or a way to pass a reference to the control to a function/sub when the control has lost focus. In Access I would be able to use the AfterUpdate event. I have tried the following events, but have not figured out how to get what I want from either of these events:
- TextChanged (tried to capture the Tab key, didn't work)
- Validating (when fired for Text1, the ActiveControl name is Text2 which is the next TextBox control)