Hope everyones doing well, not sure about the new decor around here though..Anyways, i have some labels on my form im trying to use as counters for records in a SQL db. One works just fine, and yet another using an almost identical query is returning very odd figures. If theres 5 records on the db its counting that as 1, and setting the label so. If theres 10 its counting that as 2, if theres 15 its showing 3, and so on.
[Code]...
I'm looking to list all available performance counters (on a server) in my app and allow the user to select what he/she wishes to monitor. Then when they have been selected, hit a button, and the counters will start monitoring.
From using Google so far I can monitor one counter but I'm looking to monitor several user-selected counters. I guess in short I might be looking to re-hash perfmon. Would I need an array or a Microsoft.VisualBasic.Collection?
My first try was to init performance counters in an array, which didnt work. Then I read up on performance counters and from that reading, the constructors are such that performance counters cannot be put in arrays. What does one do for multiprocessing?
View 6 RepliesI'm trying to weave a .NET performance counter into an application. When I call the incrementBy(value) method on my avg performance counter it is changing the RawValue of my base counter by value as well. I checked the variable names and think everything is correct. Then when I call increment() on my base counter it adds 1 to the rawvalue of the avgcounter as well as incrementing the base counter... adding insult to injury!
In code I'm using two different counters to measure the time a merge sort I wrote takes. I have a instantaneous counter for the elapsed time of the sort and an average counter.
Dim timePiece As New Stopwatch()
timePiece.Start()
MergeSort()
timePiece.Stop()
[Code] .....
I think I may be using the counters wrong, but why does changing the rawvalue of the average seem to also change the rawvalue of the base? i dont think that's supposed to happen.
I am trying to setup performance counters for CPU Usage and Memory Used.I would like a progress bar and a label to display the percentage.I have the below code and although it seems to be half working, there is something just not right.. The memory one seems to be working fine although the CPU one is acting strange.
[Code]...
This is my code that im working on
[Code]...
I want to add in textbox2.text and a button when i press button1 (it minus the number or whatever number i deside to put into textbox2.text) then the time (in textbox1.text ) goes back up to 100
I've been trying to get memory information from the OS by using Performance Counters. Memory performance information is available from the memory manager through the system performance counters. Right now, I'm working on getting the different types of Kernel Memory, but I'm having issues getting others as well. Through Performance Counters, I've been able to get Paged Virtual and Nonpaged Kernel memory.
The article I mentioned above does not explain how to get the Paged Physical Kernel Memory. It only gives the two I mentioned and the total, which is just the two combine and isn't the Paged Physical. The information isn't straight forward, so I'm using a third party application to compare my results so that I get the correct information. The article gives me Pool Paged Bytes Kernel memory and I found out that it is the Paged Virtual Memory.
I'm declaring this and others like so: [Code] I've researched several other methods, but I can't seem to get anywhere with anything else besides Performance Counters. To sum it up, I'm looking for a method to obtain the Paged Physical Kernel Memory.
Which is less resource-intensive (per se):
> Add controls/components (such as Performance Counters, Timers, etc.) to a project by dragging them onto the form and using them by setting the properties and using code to program what they do.
> Add controls/components (such as Performance Counters, Timers, etc.) to a project by using Dim x As New Performance Counter or Dim y As New Timer in code without actually dragging them from the Toolbox onto the bar at the bottom (under the Form Design).Or is there another way to do this that uses less CPU/RAM/Resources/etc.?
I am trying to setup performance counters for CPU Usage and Memory Used.I would like a progress bar and a label to display the percentage.I have the below code and although it seems to be half working, there is something just not right.. The memory one seems to be working fine although the CPU one is acting strange.
Shared perfTotalMemory As New ComputerInfo
Shared perfFreeMemory As New PerformanceCounter("Memory", "Available MBytes")
Shared perfProcessorTime As New PerformanceCounter("Processor", "% Processor Time", "_Total")
[code]....
I can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
View 4 Replieshow to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 RepliesHow do I update records in a dataset with records in a transaction file?
View 3 RepliesI want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.
this is not working:
Dim sqlsearch As String
sqlsearch = "SELECT * FROM setting WHERE mname LIKE '%" & TextBox.Text
[code].....
I have this piece of code wich works perfectly when inserting records into one table using records from another table. My question is that now i need to create another table by using records from 3 other tables (tables are related). Can i use aliases on the column names, like on Oracle SqlPlus? How will be the syntax of the 'INSERT INTO SQL statement?
Dim MyConn As ADODB.Connection
Dim MyRecSet As ADODB.Recordset
Dim tmpSQL As String
MyConn = New ADODB.Connection
[code]....
I am working on creating a program that records animal data (wombats) and stores it into a database, using vb.net. I am trying to add new records into a database but every time I click add, to execute that, there are duplicate records that gets added. How do i write the code so itonly adds it one time. I am using a data reader. Here is the
[Code]...
I want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.[code]
View 8 RepliesI have a dataset containing 2 tables,Customers and Contacts. Just showing the master-detail is not a problem. Problem occurs when I try to search the master table to bring in the detail table. Searching the master table shows only the master record, but not the related detail records. Adding a 'findby' query on the detail table only shows the records.url.. Normally when the master table is filled, the detail record shows in a form.
View 1 RepliesI have a database with 3 tables: Student, Unavailability and Duty.The fields for Student are entered in a form I have. One of the fields in Unavailability is filled by a form, the other fields are an autonumber and a foreign key to the Student table.ow I want records in the Duty table to be created and automatically filled in depending on what the values of the fields are in the Student table.For example, If the Boarder field in the Student table is 'yes' then I want the Duty Number field in the Duty table to be '1', '3' and '4'. If it is 'no' then I want the value to be '2' and '5'. I recognize it will have to create several different records to incorporate the different duty numbers for each StudentID. Obviously this will require an if statement, however this is my first time implementing a database with my limited experience with programming and Visual Basic, so I don't know how to refer to the specific fields in a table and set the value of other fields depending on the data in other fields.
View 6 Repliesi can add records to mysql database but it won't appear in the listview. [code]
View 3 RepliesThe following code deletes the records from the table on run time but not actually from the MS Access database. I have deleted all the records and when I restart the application, all records are exist.
How to solve the problem?
[Code]...
I have created a form called new users, I have added my data source, draged over the objects I want from the dataset onto the form and all is well appart from the fact that I cant delete records.
To add them I simply click the add button, put in my info and then click the little disk button to update the dataset.This does not work for the delete button though, instead I get the following error
UPDATE REQUIRES A VALID DELETE COMMAND WHEN PASSED DATA ROW COLLECTION WITH DELETED ROWS.
[Code]...
I have an app with one database, with one field/table.When i fill in this for the second time or more, i will see the diferens from last time til now.I want the diff betveen the two last records
Table 1= Water1 Last week we used 200 liter This week we used 210 liter, the diff is 10 liter
I have problems retrieving records for a particular day. And is kind of urgent now. I'm using DateTimePicker1 & DateTimePicker2 to let the user choose the date. After which I want to retrieve all records that fall within this date frame. However, my access database is in Date/Time field. I want to ignore the time and find all the date records. How should I do it?
[Code]...
I need to get the count of the records in my app. But BindingSource.Count always counts NewRow too if I select the new row. And this causes an exception. Is there any different method for it?
View 1 RepliesI have 2 tables one is called Product Table and the other is called item table the item table is in gridview I can get the product primary key into the itemtable using a comb box but how do i read the rest of the information for that record into the item table from the product table.
View 2 Repliesi am using MS-Access 2003, VB.NET 2008, I am able to select and delete recordes. But how can I move between records?
Imports System.Data.OleDb
Class Window1
Dim cn As OleDbConnection
[code]....
This is what I have done so far but how can I movenext,last,previous,first? The way we used to in vb6 with recordsource.
i wanna to nevigate record at the click event of a command button. I have done my connectivity properly.so give me an idea with a proper example by which i can understand the nevigation code in vb.net
[Code]...
I'm using vb.net. Usually I used the SQL Server SQLComamnd but here I need to use an ADO. I have this but I'm stuck at the end of it how to get the data? [code] How do I actually retrieve this record?Is there something akin to the SQLCommand that has Reader?
View 1 RepliesI have recently created a disk catalog program for myself, it is working fine. The problem is, when i try to index my 2 TB HDD, the time taken to write 66K rows into sql table is taking a lot of time nearing 30min.
I am using sql client (sdf is the file extension).
Also, i am using two threads to insert data simultaneous saving 50% of time.
I am using vb generated table adapters only.
I have a form and its filled from a VIEW of two tables on SQL server. When its opened i dont want other users opening that customers details from either table.I know SQL itself prevents writes if its opened but i want to stop people opening the record in the first place.[code]...
I then tried writing these values to the db on the form loading but it doesent work - it just sends back NULLs. I tried the same code in the on load event into a button and it works fine there. So im thinking i should do this as a Trigger on SQL itself, but im unsure how i could get the users computername or Windows Login name, or even username from the front end im building.