In one of my programs I have a datatable on which i calculate different statistics for different subgroups. In my opinion this is as very timeconsuming proces (at least my solution). I was wondering if there is not a more effecient solution.
CODE:
Just working on a project an wanted to know how to show cpu statics like mem usage, free space ect
View 1 RepliesIn our company we are using PHP to display graph from statistics in SQL over webpage. So anywhere just access the website and input the date will display statistics over the webpage of the company.
My question now is, will VB.net can do that to link SQL and display it over the webpage? Or do I need to have special software to use?
If VB.net can do it? Is there any tutorial link you can recommend for me? Video link much better.
I'm a novice that has developed a data processing application for which statistics regarding the processing status are recorded in the application window. All works well until an arbitrary point at which the statistical upates to the window cease. When the application finishes, then the application window properly displays the final results. However, intermediate to the completion of the application, all updates to the status window are suspended. Can you please inform me of the means by which I can continue to display the status updates when other activities appear to interrupt the updates prior to completion?
View 2 RepliesIm Wirting a Program that ask a user to Input Rain Fall of Each Month Im using Arrays for this, then once a user clicks on Display Stats, the user should see Annaul Rain Fall, Average Rain fall, Min Rain Fall and finaly Max Rain Fall,Ok any way the Program is Working away but the Min and Max Rain fall is Showing 0.
(code)
Public Class Form1
'Const IntNum_Months As Integer = 11
Const intNum_Months As Integer = 11
[code]....
i tryed a Val1 < Min and also a Val2 > Max, in Array(1) but this didnt work either.
I am suppose to create an application that lets the user enter the rainfall for each of the 12 months into an array,I need total rainfall, avg rainfall, min rainfall and max rainfall. So far doing good but It wont accept input into the listbox..
[Code]...
What would be the best way to show how many users are using your Application. For instance, Having a label show how many users have used it/are using it.
View 1 RepliesI want to make a game statistics calculator. For this I choose to make a XML database with the base stats of the characters.
I've made a small XML file in the VS2010 project with 1 class stats and made a list to 10 levels (to lazy atm to write all 85).
the XML looks like this:
<BASIC_CHARACTER_STATS>
<Levels>
<level id="1">1</level>
[Code]....
On the Form1.vb I've to combo boxes, 1 to display class names and 1 for levels.
Also have some Labels to display i.e. the base_STR number. But after trying random stuff to get it linked and closed VB to restart again because it was messed up too much
I want to crawl data (league tables and statistics) to crystal report from BETRADAR.COM for bookie.how to do that with http response,twitch data between tags.Someone if have code or command to do that
View 1 RepliesI'm trying to build an application to monitor a site to build statistics from the data being read. This HTML looks like this.
<div id="history">
<h4>HISTORY</h4>
<table border="0" cellspacing="0" cellpadding="0">
[code]...
Now I can read the html and put the text anywhere, I just don't how to read specific parts so I can separate the data out.
I am developing a computer application designed to monitor the network and CPU statistics on a computer remotely. The monitored computer would have my program installed and the monitoring computer would display, in a form, the information being sent from the remote client.The application does not send any information regarding packets, user names, passwords, etc. It is solely meant for monitoring CPU performance and Network resources remotely.
What would be the best method to send this information over to my host machine?I am programing in Visual Studio 2008 on windows XP. The client machine is also XP. I know this sounds a little shady, but it is required for my little business (http://www.iquorum.net) to monitor what and when something happens on our machines when I and my employees are away.
Is there an easy way to get the "Last saved by" information from the file statistics? FileInfo doesn't have it, and I have searched and found DSOFile, but it seems that is only for office documents.
View 3 RepliesI am making this program for a school assignment but it has errors when calculating
Private Sub frmReceipt_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'When this form is loaded, assign the date to the date label & start the timer
lblDate.Text = Date.Now
[CODE]...
So if counter finishes, execute the following code
If counter > 4 And km >= 1 And kmcashset = 0 Then 'If there is still kms to calculate 'And kmcashset = 0
kmcashholder = kmcash
km = km / 5
[CODE]...
And if I add counter = 0 and km = 0 at the end of that "If counter > 4 And km >= 1 And kmcashset = 0" Then it doesn't calculate anything correctly. I supply it with 9 for Distance and it returns 4 for excessdistance which is correct but returns 7 for excessdistancecharge when it should be 4! When I supply 23 for Distance it returns 18 for excessdistance and 11 for excess distance charge which is correct. (???)
Excessweightcharge calculates correctly.
I think it may be the way I'm implementing it, through the use of AND or maybe it's because it's in timer tick?
-Minimum charge of $5 which covers 10 kgs for the first 5 kms only
-Each kg over 10 kgs incurs a charge of $0.50
-Distances over 5 kms incur an additional charge of $1 per km up to 10 kms
-For deliveries over 10 kms, the extra distance should be rounded up to the nearest 5 kms and charged at $2 for each extra 5 km block.
EXAMPLE 1:
Packet weighing 9kms travelling 9 kms
Standard charge for first 5 kms ($5.00)
Weight less than 10 kgs so no extra weight charge
Extra distance charge 9 - 5 kms = 4kms x $1 = ($4)
Total delivery charge = $5 plus $4 = $9
[But my program returns 7 for excess distance charge]
EXAMPLE 2:
Packet weighing 33kgs travelling 23 kms
Standard charge for the first 5 kms ($5)
Excess weight 33 - 10 kgs = 23kgs x $0.50 ($11.50)
Extra distance (23 - 5kms = 18kms):
18kms ( 5 to 10 kms at $1/km) = ($5)
13kms (18-5)/5 = 3 (rounded up) x $2.00 = ($6)
$5 + $6 = $11
Total delivery charge = $5 plus $11.50 plus $11 = $27.50
[My program calculates everything correctly]
I am trying to get the first store to calculate the total 5 payroll inputs but it is only calculating the first entry I am not sure what I am doing wrong. Also if I click on the cancel button in my inputbox it bombs.
Private Sub calcButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles calcButton.Click
' Dim storeTotal As Integer
' Dim store As Integer
[code]....
I'm having some problems calculating the values for two diferent fiels of the datatable. it return " Object reference not set to an instance of an object"this is How I feed the datatable
Dim daProd As New SqlDataAdapter
Dim conProd As New SqlConnection
conProd = Connect()
Dim cmdProd, cmdSave As New SqlCommand
[code]....
I want to calculate variance of a col in my datatable object. If i apply datatable.compute(Var(...)), i gives a negative result. Variance can't be negative. And it I just apply it to half of the data, it works fine. Does datatable.compute has a limited capacity?
View 7 RepliesI am trying to calculate the number of years for my calculate age event handler, however i am apparently missing a method or whatnot because im trying to calculate the age , can anyone suggest help on this. I need to subtract years to get my age but when i try the birthdate.Subtract (currentDate) method i get an error about not able to convert from LONG?
So below is what I have.
Private Sub btnCalculateAge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateAge.Click
Dim currentDate As Date
Dim BirthDate As Date
Dim Age As Long
[CODE]
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.
View 6 RepliesI'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data
load the contents of a query from a dataTable Adapter into a datatable?
View 2 RepliesI am trying to add NewRow to the database by using datatable in dataset, but before I do that I want to make sure that row is not already there. I create new row for the datatable I am working with, fill it with information. I fill datatable with the row from database that has the same primary key as my NewRow by using tableadapter.fill method, but when I do that my NewRow that was never added to the datatable is filled with information from database(and not information that I assigned to it). I count rows in my datatable before I fill it and it's 0, so why is my NewRow affected by Fill command? (I am using VB.NET 2005 Framework 2.0)
[Code]....
I am trying to figure out how bitmasks are calculated in vb... I have the following constants and their bit values:
[Code]...
I'm really new to VB. This is only the 3 app I've created, and I'm stuck.I need to code an app that displays total commission earned on sales at different levels. The commission percentage goes up as sales go up.
Should I write a If/else/else/else/else/then statement or something else?There are 5 different commission levels in the problem. I have my interface designed, but obviously that's the easy part.