|
It is possible, but why would you want to? Best practice is to open a connection just long enough to do whatever work you need, like setup a DataReader (which will close it's connection upon reading the dataset), update a table, or call a stored procedure, then close it when it's not needed for the current operation anymore. Keeping a connection open a poor practice because they are expensive resources to have open on the server occupying a connection license and holding on to resources.
VB.NET and VB.NET Express are the exact same language. You might want to look into using a collection instead of an array. What does the code look like that your having problems with?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Well i do know it is expensive to hold memory with multiple connections. Indeed stinky piece... Consider an auditor or a CEO or a top management person of an organization having a system which can connect to all systems simultaneously [Production status from SCADA/PLC, Finance status from AS400, User info from Exchange server, Raw Material info from Mainframe data, Customer info from Biztalk etc] all in one application, compare them [technically in one dataset but multiple connections].... Exactly this is what i did and my system worked perfectly when it was done in VB6(multiple connections stufffff) but not in DOTNET... may it be array or collection....
Hope that you got what i'm trying to tell. This is not the competitive techi stuff to prove something but used or in high need in enterprise level...
RV
|
|
|
|
|
So? You still don't need an array of connections for this!
In proper modular programming s own class(estyle, each of these systems would have its own class(es) that manage the fetching of data from that system. Again, the proper method is to open the connection, perform the data transaction, then close the connection. Keeping the connection open only as long as is required to complete the transaction.
BTW: Creating an array of connections IS possible, but no-one does this because it's never necessessary. Unless your writing your own connection pooling algorithm, anyway.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Guru's,
Let's say I have made a Question Dialog which has 2 buttons: a Yes and a No button. When a user clicks on the main form 'Delete file' button the question dialog is called like this: frmQuestionDialog.show vbmodal.
How can i know after calling the .show which button Yes/no they have pressed at the question dialog?
Best regards,
Jens
|
|
|
|
|
Simply create a property on your Question Dialog form, which you will set with a value telling what button was selected by the user. Read the property just after calling .show method.
Best wishes,
Maciek
|
|
|
|
|
hi every one,
i am new to smart device application,i am trying to create small application using smart device,the emulator which i am using for this 'pocket PC 2002'.i have a database which i created in the emulator.path of that database is "\My Documents\Personal\Mysql.sdf".this is what i am seeing while connecting the database in emulator.
when i am trying to access this database,i could not open it.the code is here.
Dim local_DatabaseFile As String<br />
Dim local_ConnString As String<br />
local_DatabaseFile = "\My Documents\Personal\Mysql.sdf"<br />
local_ConnString = "Data Source= " & local_DatabaseFile<br />
Sqcon = New SqlServerCe.SqlCeConnection(local_ConnString)<br />
Sqcon.Open()
please tell me the correct path of this database file.which is located in personal forlder Emulator.
thank you
|
|
|
|
|
Your question would be better handled in the Embedded/Mobile Forum[^]. The information your asking is specific to Mobile developement, not Visual Basic.NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am working on a project that consists of 4 forms. It starts with a main, which I have added a "Public Shared" variable for the title of all forms. This part works. It then branches off into 2 forms, then from these it goes to 1 form. I need to be able to take a variable from the two forms and pass it to the 3rd form and a variable from the 1st to the 3rd. Here is an example.
form 1
title - to all forms
user - to form 4
form 2
type - to form 4
form 3
type - to form 4
Any and all help is greatly appriciated.
|
|
|
|
|
Hi -
I've had some success adding public methods to the forms for passing information around, but it's been a while. I think the secret is that all of the forms can see main, but forms other than main might not be able to see each other. So to pass data from form2 to form3 it might be necessary for form2 to call a method in main which in turn sets the data in form3. Just make sure you don't try to call a method in a form before that form is instantiated or you'll get null pointer errors.
Hope this helps...
Steve Mitchell
An unbreakable toy is useful for breaking other toys.
|
|
|
|
|
|
How do I execute a stored procedure from VB6? 
|
|
|
|
|
Microsoft Knowledge Base Article - 146651
How To Call SQL Stored Procedures from Visual Basic
http://support.microsoft.com/default.aspx?scid=kb;en-us;146651
just in case:
Using Stored Procedures in Visual Basic .NET
http://msdn.microsoft.com/vbasic/using/columns/adventures/default.aspx?pull=/library/en-us/dnadvnet/html/vbnet09102002.asp
|
|
|
|
|
Hello,
I attach a "TREE CONTROL" in VB.net form and then add one parent node and one child node.
I want that when i click on "Parent Node", then it prints a Message,"PArent Node".
similarly, when i click on "Child Node", then it display or prints any message against it.
Kindly tell me that how can i do this.
I am positively waiting.
Regards,
Eshban
EsHbAn BaHaDuR
|
|
|
|
|
Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect
MessageBox.Show(TreeView1.SelectedNode.Text)
End Sub
.NET Framework Class Library
TreeView.AfterSelect Event
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformstreeviewclassafterselecttopic.asp
|
|
|
|
|
Hello,
This is Srinivas from SIUE.I am working on an application to call Matlab from visualBaisc.Net. The main idea is to develop a GUI in Vb.Net for runnning Matlab programs in the background and hence sending Data input from Vb to Matlab. I am trying real hard at this, Anyone here can help me out with this.
Thanks.
Srinivas Rao Sambaraju
|
|
|
|
|
how to create a calendar with holidays marked in red
without using calendar controls.
is it possible to modify calendar contrl by changing eg:january to be written inanother language
sdf
|
|
|
|
|
.NET Framework Developer's Guide
Developing World-Ready Applications
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondesigningglobalapplications.asp
|
|
|
|
|
I'm trying to import excel workbook into Vb.Net. Any idea on how to do it? As I have data and graph which is done in excel but now would like to put it in Vb.Net. Or is there any alternative?(eg: Drawing 2 chart in a graph, as the original excel file display an overlay of Bar-Chart and XY scatter chart.)
|
|
|
|
|
How to automate Microsoft Excel from Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;301982
|
|
|
|
|
Hi,
I would like to perform some run-time coding such as:
s1 = "testing"
s2 = "s1"
s3 = evaluate(s2)
Then, s3 will become "testing".
Is it possible to do this in VB.NET or VB6?
Many thanks, Wilfred
|
|
|
|
|
If your attempting to do what I think your are, the short answer is no.
During the debugging session, most changes you make while the code is running will cause your app to restart. You'll have to run your app again in order to get your app back to the point where you made the changes.
If your talking about writing your own language interpreter, sort of like your own version of VB, then you would have to research expression evaluation. You could start with Runtime Compiled Symbolic Expressions[^] here on CodeProject. It's written in C#, but is can be converted to VB.NET. You might check out Exploring the Microsoft Script Control
[^] on MSDN. This article has some root into what you might be looking at doing.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello i am new to vb.net, and am learning it in tafe. I was wondering how to store certain information. I have done coding in another language which i used hash tables for, and i really liked them, so i was wondering if i can do hash tables in VB.Net and if so are they easy for storing data? Also is there a tutorial for them ?
The overwhelming power of death is there just to inspire. Translation; life is different ways of not dying.
|
|
|
|
|
Setting and retrieving a Dataset in a Hashtable
http://www.thecodeproject.com/vb/net/TinguHashTable.asp
|
|
|
|
|
The Scenerio is as follows..
I have a DAtabase server... The connection to database can be made by just one ip.. I have to make my middle tier and insatll it on that ip.. And I have to make Client VB.Net Desktop Applications.. Which will reference to that Middle tier.
The bottom line is no Client Applications can make DAtabase Connection.
Which technique is best suited .. plz help me onto this..
|
|
|
|
|
Hi to all!
Please tell me how can I draw on Graphics to another.
For example: I have an Graphics object gr1 that was received from the window handle to and another object gr2 that was received from the button handle. How can I draw gr2 on to the gr1?
Thanks
Alex
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
