So if anyone has fallowed any of my post, then you will know I'm still in the process of transferring to pure vb.Net, while simultaneously trying to rid any bad habits that stemmed from the good 'ol vb6 days.So having said I have a few question that are in regards to the GarbageCollector. Now I'm not looking to modify or mess with it at all, but rather it's exact functionality and where I should be disposing of and handling my own unloading.For the sake of my coding style I like to run my application differently than most(unless this is the way it should be done) but this only applies to my more large project.[code]
So as you can already guess my startup object is the AppMain sub, and I have the application framework disabled.I'm not sure how the Garbage Collecter functions, so truly I'm not sure if my code there is necessary or unnecessary. What it does is unloads all open forms that may have been left behind, plus it closes the database connection if one is open. Also I'm wondering if its a good idea to clear all my collection as well. My concern with the collections is just I have sooo much information being stored(it's a business management system that handles transactions, appointments, inventory clients employees etc etc) and this keeps growing. So I'm not really sure if all this gets handled automatically by the GarbageCollector or if it's good practice to begin clearing out this data and disposing it before hand.
I am currently writing a program that is saving user setting for the program into the registry. The problem is with the 'Administrator Control Panel' that I am writing for that program. To load/edit those settings for users that are not logged in their NTUser.dat must be loaded into the registry. I have based that part off of [url]... using the API functions RegLoadKey and RegUnloadKey. When all that is done is loading and unloading the key it works fine. However, any time that I read from the loaded registry user hive it will not unload that users registry hive. I have tryed using the RegistryKey class[url]...
My assumption is that the RegistryKey is not being closed or released properly, or completely enough for the user hive to unload. I have tried the .Close member in the RegistryKey class as well as tried 'CType(regKey, IDisposable).Dispose()' (regKey is defind as registrykey) to close the registykey. After I close the program (running from Visual Studio) I can manually unload the hive via regedit.
Is there another/better/more complete way to close the registrykey to allow for the RegUnloadKey function to work?
Im learning VB.NET and as a first task im creating a login form. ive been trying to link it to another form once a correct username and password are entered. however, despite that i still cant be able to hide it or unload it once the next form is loaded
Here is the Code
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click If UsernameTextBox.Text = "chris" And PasswordTextBox.Text = "chrispass" Then Me.Hide()
[code]....
The Form2 appears as coded above but the 'Me.Hide()' manages to hide the login form but then it appears again?
I am learning VB.NET and as a first task I am creating a login form. I've been trying to link it to another form once a correct username and password are entered. However, despite that I still cant be able to hide it or unload it once the next form is loaded.
Here is the Code Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click If UsernameTextBox.Text = "chris" And PasswordTextBox.Text = "chrispass" Then Me.Hide() Form2.Show() End If Me.Close() End Sub
The Form2 appears as coded above but the 'Me.Hide()' manages to hide the login form but then it appears again.
I feel like a complete noob for asking this because I know how to do this in VB6... But in VB.NET 2008, how would you load a new form and unload the current one? I know that in VB6 the code would be:
[code]...
The problem with that code is that it just ends my program completely without showing frmMain.
I'm rewriting a vb6 program in vb.net, and I was wondering what the best alternative is to vb6's "load"/"unload" commands for loading and unloading controls on a form.
e.g. (VB6)
Unload frmContainer.DetailGrid1 Load frmContainer.DetailGrid1 Currently I am adding/removing controls using
I am using VB.NET 2003. I am trying to move an application from VB5 to VB.NET and having some difficulty. Thre is a Main Form, which only consists of a menu bar with one of its commands being "Help" Under "Help" are several choices, including "About". There is also an About form. My question is: How do I get the About form to load when the Help/About command is clicked?
How can i call a procedure to calculate the cost of the suv and compact car mileage twice with that same procedure? Thats the only part i cant figure out with this function/procedure stuff. Also am i doing the procedures right?
Quote:
'Developer: John Nelson 'Date: Janurary 18 , 2012 'App Name: Compare Fuel Cost
I have a function in my program that adjust sales for multiple days. Sometimes it needs to adjust up to 3 months and the tasks takes a while so I decided to split up the work between multiple threads. The way I have it working is say I need to adjust 3 months. I have the first thread adjust sales for the 1st month, the second thread adjust sales for the 2nd month and finally a third thread that will adjust sales for the 3rd month. Since all three threads are performing the same tasks except for different date range they use the same procedures. Within those procedures I make a call to the database to extract the sales for the given month. At some point it seems like the threads start to use the same SQL Data Objects because I am receiving the below error."There is already an open DataReader associated with this Command which must be closed first."Below is the first procedure that is ran by each thread up to the line where it errors out.
Private Sub Process_Adjustments(ByRef objAdjustBillCodeThreadParameters As clsAdjustBillCodeThreadParameters) Dim cmd As SqlClient.SqlCommand
[code]....
So all three threads call this subroutine and the first thread does the data fill with no issues and then sometimes even the second thread does the data fill with no issue but then the third thread crashes and produces the above error. It seems as though the threads are sharing the same SQL Objects when all objects are local to the sub and I always thought each thread had it's own memory to work with. So I thought each thread would call the sub create it's own objects in memory, but that does not seem like what it's doing. I have other multithreading processes in my application that work perfectly fine, this is the first time I am attempting to multithread in this manner where I am using the same procedure within multiple threads.
Just thought of something that I might be doing wrong. The subroutine in question is in the same class where the threads are created. Should the subroutine be in it's own class, and therefore each instantiation of that class?
I created a subprocedure to change the background color of the selected matching labels in this concetration game. Now I want to change it back to silver when all the labels are selected I tried all the insertion points I could think of for a EndGame function but none have worked. I'm thinking I'm barking up the wrong tree.[code]
I've lived in the VB6 world for the last 15 years and am only now starting to learn .NET. I've got a long way to go, but I am hung up on a fundamental issue about collections.I live and die by collections in VB6; I use them for just about everything I do.So I am very used to having the abilities that the intrinsic VB6 Collection has.Things like adding items with keys, referencing items by key or index, having the "Add" method return an instance of the object, being able to add custom procedures to the collection, having it strongly typed, etc.But all of the collection information I have read about in .NET doesn't really do all of this.(I am starting out in VB.NET, with the possibility of moving to C# at a later time, so i am trying to stay away from the Microsoft.VisualBasic namespace.)
Some question about Ado.net and SQL Server stored procedures. We have a stored procedure in SQL Server as described below
Procedure dob.PendingCalls @UsID As Char(10), @Sts As Integer OUTPUT , @Msg As VarChar(100) OUTPUT AS Begin
[code]....
we are using vb.net in visual studio 2003. Now if ExecuteNonQuery is used then we do not get rows. If ExecuteReader is used then we get rows [ with forward-only access which is of no use to us] but we cannot get output parameters values returned by stored procedure?
I have a Custom.ascx file that is used on a number of pages. Custom.ascx contains a couple of controls and a button called cmdCustomPageButton. When the user click on cmdCustomPageButton, cmdCustomPageButton executes a Protected Sub that gets some data from a database.
Page1.aspx that is using Custom.ascx has its own set of controls and procedures that it executes. It contains a button called cmdPage1Button and a procedure called RetriveData that is being called by other procedures as well within Page1.aspx. When cmdPage1Button is clicked it calls RetriveData. RetriveData is only applicable to Page1.aspx. Page2.aspx and Page3.aspx both has a procedure similar to RetriveData but is only relevant to its own page.
Try to explain using code:
Custom.ascx
Public Class Custom Protected Sub cmdCustomPageButton_Click(Byval sender as Object, ByVal e as EventArgs) Handels
[CODE]..............
The question. How do I call the different RetriveData procedure form the relevant pages being it Page1, Page2 or Page3 when cmdCustomPageButton is clicked ?
Im currently working on a car service program on Visual Basic. The user simply selects some radio buttons, enters a couple of values and at the end the lablels are SubTotal, VAT and Total. Can anyone tell me how I calculate the VAT, the VAT rate I need to use is 20%. I currently have an appropiate answer for the Sub Total. I know I need to multiply the SubTotal amount by 0.2 but how do I do this using Procedures and Functions?
calling stored procedures using ADO.NET. We have an application developed, which uses SQL Sever as backend and Visual foxpro as front end. In this application every thing is done by database only. That is all insert, update, delete operations are done by SQL Server only. So we have to provide some input and output paramaters to stored procedures. Some time these procedure carry out insert, update, delete operations as well as return some data in the form of tables.
I have a block of related sub routines I would like to "group" together within class to make navigating a littel easier. When I say group, I mean achieve the same functionality of being able collapse and expand a block of code as would with single procedure or class. Two alternative ways I can think to accomplish this is either use a partial class for those procedures or use namespace. I just wanted to see if VS for VB.Net had another way to be able group and collapse blocks of procedures.
Am looking for a Currency Text Box control that will accept numeric key input and display entry as Currency according to Users Regional Settings.
Additionally, when an assignment is made such as Currencycontrol.text= 123.45 + 500 , user will see value displayed as $623.45 or formatted to regional specifications.
I do need a control rather than formatting procedures since my form could have 24 or more currency fields.
If I write many subs and functions in my code, the tools on the interface will stop responding to some of the subs and functions. What can I do about that?
The code below is right to execute more store procedures?
Dim mySQLCommand1 As New SqlCommand("sTruncate", myConn) Dim mySQLCommand2 As New SqlCommand("sAddress", myConn) Dim mySQLCommand3 As New SqlCommand("sProvider", myConn)
I initially posted this in the wrong forum. I need help getting this to run properly. I'm trying to construct a fractions calculator. In order to complete it, I need to do it like this:Using Select Case statements, four Function procedures should be called based on the operation selected. Each Function procedure will calculate the correct operation and return the Decimal value to the calling procedure. The original procedure will print the result.
Now, the result should be calculated to the hundreths place and the input values should be validated by a Try-Catch Block.And of course, I've been having trouble with how to do this. I've attempted many times and this is what I have so far:
I just happened to be reading through a post and stumbled upon this and was curious. As I was remiss to go off topic in someone else's post, I've dragged it out here.What we are doing here is logically incorrect. We loop thru all the records and set the sheet locked state and button image. But since the button is just one element, so effectively the image set would be that of the last record.We need to separate the two procedures and the events they take effect too.Ideally we should set the sheet locked state while loading it. (maybe the form_load event etc.). And we should set the button image when we switch the sheets (e.g. sheet change/activate events). The selection of events however depends on your requirements and wisdom.
[code]...
I noticed how the image was accessed above. My question is this, what is the differences between the above method and Image = Image.FromFile(Path) and if any, what are the advantages/disadvantages of each? This is just for knowledge purpose and is not pertaining to any particular problem.
I want to call a Stored Procedure using SqlDataSource. I've been reading the library documentation of the classes but i'm getting slightly confused. To call a stored procedure, I understand that I have to change the selectcommandtype and then set the selectcommand property to the name of the procedure.
'Change command type to stored procedure SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure 'set name of stored procedure
For some reason my stored procedures are all executing twice! I have a static function that runs an SP given its name and the parameters and fills a datatable.
Public Shared Function RunSP(ByVal spName As String, ByRef spParams As Dictionary(Of String, String), ByRef pDataTable As DataTable) As Integer Dim cmd As New SqlCommand Dim lAdapter As SqlDataAdapter
[code]....
Is there something wrong with the code? I've checked with the debugger and the appropriate SPs are definitely only being called once, i.e. this function only runs once for a particular insertion function, but two things are inserted into the table.
I am trying to use stored procedures with LINQ to SQL to perform insert, update, and delete operations. My update and delete procedures implement optimistic concurrency by checking the original values retrieved from the database with the current values in the database. A row count is returned to indicate if the row was updated. When I execute SubmitChanges on the data context to update the database, everything works fine except that the generated code doesn't check for concurrency. (I configured the insert, update, and delete operations to use the data context methods created from the stored procedures using the O/R Designer, and I assigned the original object properties to the method arguments.) I can customize the generated code so it works properly, but I know that I shouldn't do that because I'll lose the changes if the code is regenerated. I also know that I can add a partial class to extend the data context, but I don't know how to implement the methods correctly. All I really need to do is to have the methods return the row count, but, of course, that's not an acceptable method overload. I know that I can also call the methods directly rather than calling SubmitChanges, but it seems like this is intended to work with SubmitChanges.
