I need to know if a form2 is already open when a button1 on form1 is clicked. I found the following code which fails when I open form2 then close form2. When I click button1 on form1 nothing happens. Is there a way to reset form2 to nothing or is this just wrong?
Sub isFormOpen()
If xmlTest Is Nothing Then
xmlTest.Show()
OpenXML(filename)
End If
End Subdavidbell
Im using a dataset to display data in a datagrid from a sql server DB. One of the colums I have in my datagrid is "Status" the table adapter sql statment selects certain items based on whether there open or closed e.g "where = Open ". I want to remove this row entirely and instead of displaying open or closed for status column, display the open/ closed results in colour on the datagrid. Im really not sure how to go about this whether i need to do it in the table adapter or some sort of property. I presume i need to write a sql statement and selct the identity of the row where x= open etc , is there a way of assigning a colour in sql statement so it displays on my vb form ?
View 2 RepliesI'm making a Visual Basic GUI application to display whether a number of my ports are open for people to know whether things like my website and my Minecraft server are open.My problem is I have absolutely no idea how to do this in Visual Basic.Basically, I'm asking for something which sends a signal to an IP with a specific port, if it is open then return true, if it's closed, return false. Similar to: http:[url]....
View 1 RepliesI am still working on a POS application in VB.Net 2003. What I need to do is check the state of the cash drawer. I want to make sure the drawer is closed before a cashier is allowed to move on to the next sale. The cash drawer I am using is a MMF ECD200 (not sure if this will make a difference). Here is the code I am using to open the drawer:
[Code]...
I am trying to save "Closed" when i click on check box [code]Conversion from string "TRUE" to type 'Double' is not valid.
View 10 RepliesSimply enough, I closed a design window, and now I can't reopen it.Whenever I click on the form in the Solution Explorer, there is no option to show the design view, yet I know that there is one.When I go to the folder where the files are stored, there is a file there is supposedly the design of the form I closed, but when I open it, all that appears is another window of code.
View 2 RepliesOk...i have read all posts..and no solution...on main form I have...
adapSB.Connection.ConnectionString = "Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=dbone;Data Source=xxx
adapSB.Fill(DTSB)
and in class that starts new thread started every time users change some data(very often)
[Code]...
1. other parts of application are targeting other SQL server...just this adapter is updating only one row(table has two columns, some id and last time any of users changed something.
This reader is done in the form load event and is the very first thing done so I don't understand why it's telling me there is an open DataReader. I've also set MARS=True in my connection string so obviously it is something else.Here's my code and like I said the routine is called at the top of the form load event. The error occurs on the
Reader_Customer = command.ExecuteReader() line:
Module Globals
Public g_strConnectionString As String = "workstation id=" & System.Environment.MachineName & ;" _ & "packet size=4096;Connection Timeout=60; " _
[code].....
I have create a simple app in vb.net that receive data from a bluetooth device ( data are simple strings like "90123.9mm"). Is there a way to check if the device has closed the connection ?
[Code]...
I get the following message "There is already an open DataReader associated with this Command which must be closed first." Is the insert statement the most effiecient way to write to the table row by row?
Dim comment As String Dim cnx As Data.SqlClient.SqlConnection = SqlCnx.SourceDB Dim cmd As New Data.SqlClient.SqlCommand("select number,comment from [Comments]", cnx) Dim daComments As New SqlClient.SqlDataAdapter Dim bsComments As New BindingSource cmd.CommandTimeout = "360" cmd.CommandType = CommandType.Text cnx.Open()
[code]....
In our VB 2008 we are making a lot of connections to sql server 2005 databases. Is there a possibillity to check with a program or a tool of 2005, all connections are closed?
View 3 RepliesHow do you check if all instances of forms (or simply all forms of an application) has already been closed?
View 10 RepliesI'm new to VB 2010 but have be using VB6 for many years.I'm currently stuck trying to store the state of open MDI childs at the moment the MDI parent is closed. Clicking the parent upper right close button appears to close all open MDI childs before running the parent 'Closing' or 'Disposed' events.I am therefore unable to detect which MDI childs are open and cannot restore them next time the application is run.Is there any other event for the MDI parent I can detect the start of the closing process before the children are closed?
View 2 RepliesI have been searching and trying for quite some time now but did not yet find the right way to solve my problem.Here is what I want to do:- open powerpoint with a file (an disable the UI of my app while it is opened)- make some changes to this file- save it with a new name- get notice when Powerpoint is closed (either by my app once the automatic changes are done or if the user quits Powerpoint)- enable UI once Powerpoint is closedThe notice is my problem. Is there an easy way (other than timers that check the process list) to get notice of when my started Powerpoint-Process is closed/quit?
View 1 Repliesfor example i have this code :
Sub Month()
Dim Conn As New Data.OracleClient.OracleConnection
Conn.Open()
Try
Dim Cmd As New Data.OracleClient.OracleCommand
With Cmd
[Code]...
What will happen to the datareader when the Connection is closed ( Conn.close)
Will the Cursor that is used by the datareader be freed ? or will it stay open ?
If the cursor that is used by the datareader is still open , when will it be automatically closed ? or should i just closed it manually ?
Will it cause the dreaded "ORA-01000: maximum open cursors exceeded" ?
I am making the interface controls on my forms to go from right to left using with RightToLeftLayout and RightToLeft which I have set the properties set to true. When I run the application and I open another form on the same application that I am using, I click the button to set the form to go from right to left. When I click the button where the code are running, it close one form as it leave the one other form running. There is no code like Me.Close() that required to close one form. I am using Me.RightToLeftLayout = True,
View 8 Repliesi have an application. which is executed after every 5 mins. i have an open connection but it gives me the following error:
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
my code is something like this. I have shown where all i am using ExceuteScalar()
Sub Main()
Try
connection.open()
cmd.ExecuteScalar()
[code]....
I am trying to delete a file after viewing it. I loosely copied the code from [URL]. The problem I am running into is the filename I am passing is still in use after I close this form. How to get id where the file is being held open. Here is the relevant portion of the code. This is how I am opening it
Private Sub TifViewer_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
PicImage.ImageLocation = PassedImage
PicImage.SizeMode = PictureBoxSizeMode.Zoom
cboFrameNo.Items.Clear()
'Sets the tiff file as an image object.
[Code] .....
I have multiple forms in my VB.NET application. How do I make it so that any form I close will terminate the application?
View 3 RepliesI need a way to detect when a child form has been closed. I've created an MdiWindowList thing (but in the form of a toolbar with buttons, similarly to the Windows taskbar), and everything works great, but the method I have for refreshing the taskbar's windows has to be called when a child form closes. I've trying calling the method from the child's Form_Closing event, but there's a slight lag so whenever there's more than 1 window open the first one gets skipped (then the others close properly, since the taskbar is being refreshed first before the form actually closes).
View 10 RepliesAnd this problem:+ I have 2 form. - Form 1 have 3 combobox with some item load from database Access.- Form 2 load data when change item at combobox form 1.
View 5 RepliesUsing VB Express 2010 in windows XP Pro 64.
A ListBox shows the project forms names.
On ListBox_DoubleClick
For Each F As Form In xFormCollection
[Code]....
Works fine the first time but after closing the form opened by the DC, if I try to open it again, throws an exception "Cannot access a disposed object".
Since I can still access any other form not previously showed I guess that the closing changes a status that allowed the form to be .Show, there is no F.Load , F.Activate after the exception doesn't seem to do anything. What should I do?
When a sub runs, it is using up large chunks of memory on every pass. It is loading pics into a listview. The pics are 1 to 2mb each and it is consuming 30-60mb for each one. How to release the memory once I close the form. Is there anything I can do to reduce it?
Private Sub PhotoFrm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
For Each ImageStr As String In Images
Dim Extension As String = IO.Path.GetExtension(ImageStr)
Dim fs As New IO.FileStream(ImageStr, IO.FileMode.Open)
Dim br As New IO.BinaryReader(fs)
[Code] .....
I have a checkbox on Form2 that will enable an email notification. From Form1, it tests the .Checked property of the Form2 checkbox. What is happening is that the checkbox reverts to unchecked (default at run time) each time the form is closed.
What is the best way to keep the checkbox checked once the form is closed so that it will enable the email notification?
I want to add some action to my form when it is closed by clicking on the "X" button in the upper right corner of the form.How is this done? I suspect that i must add a handler for some event, but which event is it?
Currently i am using the closing event, but i dont get it to work properly.
I have two forms with a variable (x) that is set by a trackbar on the second form.
View 3 RepliesI have a dialog box with about a dozen combo boxes. How can I access the checked results of the combos once the dialog form is closed?
View 3 RepliesTry If functionmode = "ADD" Then
[Code]...
I got this error..The connection was not closed. The connection's current state is open.
This is coding to add data in Ms access in vb...
Imports System.Data.OleDb Public Class Form1
[Code]...
I'm developing a device app in VB.net that will access a SQL Server database. I need to establish a connection when the app is launched, and keep the connection open until the app is closed. I've done the following:In the Master Module:
Public CNN
As SqlConnection
In the Main menu form load:
CNN =
New SqlConnection(sqlConnString)
CNN.Open()
Then when I want to read from the database:
Dim sqlDR
As SqlDataReader
SQL = "SELECT Name FROM Table"
[code]....
When I run the same code without the global CNN, but rather dim the connection inside the Select function, all works well.