In my program, I have a timer with a inteval set to 1000ms. The timer is executing a MySQL-command, and right now I'm opening and closing the connection each time.
View 5 RepliesWhen using SQL connections in my program, will I have to open and close the connection and the data reader each time I want to access the database ?
[code]...
Well it would appear that you need to close IO.StreamReader every time you try and open a new document. So I have tried to do this a variety of ways, with no success. I am open to the option of having it check the same document for the Username, Password, and HWID. (Yes, I know that this is not in any way a secure method to gather data but their is a reason for my madness) Anyways onto the code, I removed the URL (Yes, I did check to make sure they were all valid and worked).
VB Dim wc As New Net.WebClient 'Downloading the list..
Dim hread As New IO.StreamReader(wc.OpenRead("myurl")) 'URL to the list
Dim uread As New IO.StreamReader(wc.OpenRead("myurl")) 'URL to the list
[CODE]...
i make a class and when i call on form then that error occurs "ExecuteNonQuery requires an open and available connection, the connection Current stat is close "
Class Code isImports System.Data.SqlClientImports System.DataImports System.StringPublic Class DatabaseKits Dim Cn As New SqlClient.SqlConnection Public Function BuildConnection() As Boolean Try Cn.ConnectionString = "Persist Security Info=False;Integrated Security=True;Trusted_Connection=Yes;database=BizAimsPro2008;server=Server-2k3s" BuildConnection =
[code]....
SQL connections confuse me sometimes In almost every SQL related code on the internet the routine is like this;
* Open connection
* Execute SQL command
* Close connection
Is it good practice to just open a connection when the application starts and use that connection until the application closes?I know that sequential connections are required when processing more queries, but what if I need to poll a certain Table every x seconds? Isn't is better to keep that single connection open for as long as the application is running (and re-open when a failure occurs) instead of opening a new connection every x seconds?
I want to know what is the right way to close my Database connection while its open.
This is how i open my connection.[code..]
Should I open a connection to MySQL at the load of my application and close it when you exit or should I open and close the connection only when I need to run queries?
View 1 RepliesAre there code can open and close forms in particular Time (reference is computer clock)..?
Example: in 08:00:00 open form1 and in 08:45:00 close it
And can I let the user enter the time to open and close the forms in the Basic Form?
I want my dialog to display for five seconds then open another dialog.
View 2 RepliesHow to comment and uncomment codes at multiple place within my project at the same time?I am using VS 2010 trial version to develop a VB application.Some of functions only should be showed to developer, not to users. So I must comment them and uncomment them many times during the process of development. please note that those codes are located in many locations and many VB files within my project.
Can I do this in a conveninent way, just clicking a button, or just defining a const or "#define something", something like that?
i've tried
On Form1
form2.show
me.close
[code].....
I've been looking for ways to convert a pdf to an image so i can display a preview of the file in my application. I google and find a bunch of api's you have to pay for, but I would like to know how to actually do this myself...
[Code]...
Dont know how easy this would be, but basically I'm just wondering if there is any way in VB.net you can close open files on a remote PC.In my scenario the vb.net app would be running with domain admin permissions in most cases so would have access to things like the remote Computer Management console, which of course has the Open Files section in it which lets you close any open files on the remote machine its connected to.So I fugured there must be some way to do it in vb.net... I just dont know if its going to be more hassle than its worth and I dont really know where to start looking (ive used googled but not had much joy).
View 6 Repliesam trying to open a connection to an access db using the following:
vb
Dim cmd As New OleDb.OleDbCommand(QUERY, New OleDbConnection(CONNSTRING))
cmd.Connection.Open()
'dim dr
cmd.ExecuteReader
On the cmd.ExecuteReader line an error is being thrown whose message is unknown .
The connection string is as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MYDB.MDB;Jet OLEDB:System Database=MYWG.MDW;User ID=USER;Password=PASSWORD;
I am trying to open an Oracle database connection in vb.net 2008 in order to issue a Select statement and the populate a listbox with it.
My code is as follows:
Dim orclstr As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=10.0.0.77;" & _
"User ID=myuser;" & _
[code]....
Obviously, I am doing something wrong, but I can't figure out what.
so as to open an MySQL connection how can i have a procedure to open a connection to an MySQL server duly passing my connection variable name in to my procedure as a parameter like some thing the fallowing one is not opening the connection
[Code]...
In a program I'm working on, I want a "Loading..." dialog to close when it can't log in to a site using the username and password provided by the user. Basically, I have the code set up right because the function it is supposed to carry out when that occurs does work, but for some reason it ends up in some really weird stuff happening. In the Loading form, I have it set to do "Form1.Show()" and then "Me.Close()", assuming it would simply show the login form and then close the Loading form. However, when this happens, the Loading form closes, and then for only an instant Form1 shows, and then the Loading form shows and Form1 closes. This happens forever until I stop the debugging, and I can't seem to figure out why. Am I using the wrong method? What exactly does Me.Close() do anyways? All I want to do is close the form and open another
View 5 RepliesHow hard is make listening connection? Game? Program? Example: Server where people can connect? Just ready opened connection example where another program connects or something? (Console where you see when people connects and disconnects.....=>)
[Code]...
i 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]....
Try 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.
I'm trying to insert a new records into database, one of those records is a "datetime"...when I type a wrong date, and try to insert those values into database, i get an error (about wrong typed date etc.)...ok, that's fine, things need to work that way. But here comes the problem, I correct the date, and then try to insert values again...here I get an error from the post title. And this doesn't work until I close that form and run it again...here's part of my code:
Dim cvLicence As New SQL
Try
cvLicence.upis("INSERT INTO blabla (itsnotimportant) VALUES ('something')")
MsgBox("everything's fine", MsgBoxStyle.Information)
[code]....
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
exitwithout()
[code].....
How I Can open the same form in my application one time only can not open the form tow time in same time
View 5 Repliescan't close open image
View 10 RepliesI would like to close my appliaction and then open it based on a condition.Lets say I have a Lab1.EXE file, I want to close if the flag = True and then reopen it.
If ClFlag = True then
Application.Exit
---Then
RUN LAB1.EXE
Endif
I never had problems with this before but now this ain't working right. What I want to do is open a new Form and close the Current Form that is already open. This code use to work for me
View 5 RepliesI want to close form and open another one without termination of the application, when I try to open second form and close first one the application terminate.[code]...
View 2 RepliesWhen I open my application I have the first form which opens as the Register form. When I press the Activate Button I want the MAIN form to open and I am using the code below as the last two line[code]...
View 5 Replies