I'm working with a zedgraph bar chart and displaying only certain values from a dataset. I have a dataset with 912 records. One field is called "DeviceName" and one is called "TimesOffline". I am able to bind the chart to the dataset, but it wants to plot all 912 records. What I need is to somehow sort the dataset to retrieve the top 10% (or something) devices with the highest number of times offline.
[Code]...
Im using ZedGraph and want to do things as points are hovered over ("show point values" has to be on). is there an event i can harness that fires when you hover over points?
View 6 RepliesI got this code to get the highest value from a dataset, but it now doesn't work properly. I think it only gives me the last row but not the highest value.
Dim adMaxRec As New SqlDataAdapter("select serviceid from service", nwindconn) 'where custid = '" & cutidtext & "'
Dim dsMaxRec As New DataSet
adMaxRec.Fill(dsMaxRec)
Dim maximumrecord As String
maximumrecord = dsMaxRec.Tables(0).Compute("Max(serviceid)", "")
In my vb.net project, I use zedgraph to draw figures. I find that the following properties work well to zoom figure on the center of mouse.
[Code]...
I want to get the n highest values from an integer array that has n or more elements. This can obviously done by sorting an slicing the array, but I'm wondering if there is a more efficient way to do this, since sorting a whole array would be quite ridiculous when for example only the top 2 elements of an array with length 4200 are asked for.
View 20 RepliesI want to pick up the highest value from the last column for a particular parameter.
16 54399883 test2185 16 54562279 abc7204997 0.00546796
16 54399883 test2185 16 54563609 abc1949072 0.0266014
16 54399883 test2185 16 54563744 abc13338967 0.000598205
[Code].....
I have a file which has numeric values like [code]What would be the best way to display the highest number in a textbox +1?I have the following coding but to be honest it just keeps showing random numbers in the textbox.[code]Also what would you be the best way to append to the file? I have the following coding to append to the last line.[code]
View 5 RepliesCreate a program where the user can find the highest number and the smallest number from a list of values It needs to operate as follows: Enter a value (number) in the TextBox and click on a button [Add to list]. Once this is done, the program analyzes if the number is the highest entered or the smallest. To view which is the smallest and largest, a second button [highest and lowest] will populate fields (texboxes) with highest and lowest numbers. I've attached an image of what the program should look like.
View 4 RepliesHow can I sort data in a sorted list using values instead of keys from highest to lowest?[code]...
View 2 RepliesI have a multi-user app which consists of a Windows form (VS2008), and a SQL Express 2008 database. I'm already detecting if the dataset has changed before the user closes the form so I can prompt them to save their changes. What I'd like to do is to capture the changes they've made, and write them to a database table so that users can track all changes made to each record on the DB.What is the best way to grab hold of the data changes before they're written back to the DB and also grab the original records?
View 1 RepliesI have a need to assign values from my dataset to a variable but when i use string (which its normally text) and the item in that row of the dataset is empty it tells me that conversion from DBnull to string is not valid
View 2 RepliesI have a dataset and I am referencing items in it like this:MainForm.DataSet1.Tables("JobsTable").Rows(1).Item("JobName")
View 5 RepliesCan anyone how can i use a zedgraph?
View 11 RepliesI have a form with labels, with changing values (sub totals from a carbon footprint calculation)
and i want to create a graph which plots the final amount in Label7.text into a gar graph.
Y axis should be Carbon Footprint and X axis should be date.[code]...
So i have a DB with 3 tables. User Table with U_ID and U_Name, Class with C_ID, and C_Name and User_Class Table with U_ID and C_ID. Foreign keys are set.I want to display the classes associated with the selected user. The user is identified by their name. I know these are the two SQL statements I need to execute:SELECT U_ID FROM User WHERE U_Name = current_U_name
then
SELECT C_ID FROM User_Class WHERE U_ID = current_U_ID
then
[code].....
I am using strongly typed dataset and have many tables in that. The problem is now I want to filter data from
GetData()
function which has a query like
select * from table_name
How can I filter a particular table and distinct values from it. Also if I try to filter it return all column but rest have null values except the one I asked, so I cannot assign it as a datasource to a datagrid or combobox. How can I do this..
How to update combobox values coming from a dataset if I change the connection string. The connection string takes effect but doesn't update the dataset tied to the combobox.
View 3 RepliesI have assigned a column of values from an Excel file into a dataset.I am using the following code to check if the column header is empty:[code] However for some reason even if I have an empty column header in the Excel spreadsheet, it is automatically assigned a value within the dataset. For example if I blank out the third column header in Excel spreadsheet, the dataset assigns it as "F3" as its column header which is making the above code ineffective. Can anyone tell me how to prevent the dataset to automatically assign a value to its column header.
View 4 RepliesI have visual studio 2008 I have two different datasets that take values as "money". those datasets are in two different forms. I would like to collect each and every value of all different entries o the two datasets, and add them so that I can display the totals in a new form that has textboxes that displays the total of the two different datasets.
View 7 RepliesI have tried googling so much that I have given up trying to look. I am trying to display a dataset in a wpf datagrid. After that I am going to need to display the individual column value in textboxes. I can then change the value in those textboxes and pressing, say, a commit button, to commit the changes to a database. Here's the code I have so far.
Dim con As New SqlConnection
Dim dbConnString As String
Dim ds As New DataSet
[code].....
I have a textbox which is bounded to the typed dataset. If the user in the textbox &hit keydown, it should allow only numeric values with 2 decimal points and also it should not allow more than one "."(dot). I found many but all thats are using textbox event
View 2 Repliesit's possibly to bind the values in a combobox to a column in a dataset? If so, how would I go about doing it? For example, If I have a column named 'Names' in a DataSet, each comboBox item would be a name from that column.(There will only me at maximum, 10 entries)
View 6 RepliesIn a WinForms app (VS2008 / .Net Framework 3.5) I bind data from SQL Server to controls. If there's a null value e.g. an employee has no middle name (allowed by business rules), when I browse that record at runtime an exception is thrown. So I code: If Not (row("middle_name") Is DbNull.Value then txtMiddleName.DataBindings.Add(New Binding("Text", row, "middle_name)). Say someone adds a middle name to this record, because the control had no databindings the dataset.HasChanges property is false and update stored proc doesn't run. I guess I could handle this like this: If txtMiddleName.Databindings.Count = 0 AndAlso txtMiddleName.Text <> "" Then row("middle_name") = txtMiddleName.Text. I guess I would have to do something similar to handle a value changing from not null to null.
View 8 RepliesI would like to iterate through a dataset and obtain values of each column in a row
[Code]...
It was written in vb6 and im trying to rewrite it in vb.net. I've completely stripped the program down from all the unneeded fancy addons and now just have the needed code to run it. The program retreives the records, but does not populate these records onto a datagrid.
Heres my Form code (Form1)
Imports ADS_SQL_TEST_VBNET
Public Class Form1
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code]...
I think the problem lies within the LoadDataBound() Sub routine, but I can't say for sure since I was unable to fix this myself.
I am making a combobox from my data source. Basically, This is a projects form and the user needs to select the the primary contact which is contrained by the customer id (GETbyCustomerID) set in another field. I have it working... mostly except the combobox only displays the contact ID which is completely useless to the user. I need to know how to display the First and Last name (both are seperate columns in the table).
View 1 RepliesThe situation: I have a small application where i store customers and orders.. In my database i have a tabel called Customers and a tabel called Orders. These 2 dabases are joined on Customer ID - every Order record contain a row with the customer Id.
[Code]...
I'm trying to have a Message Box be displayed when the user either closes the form, or changes the tab. The Message Box should only be displayed if the data in a dataset has been edited/changed, but hasn't yet been changed.
View 2 RepliesI have a Dataset with 2 different tables. What I have to do is to display those tables in a DataGridView.What I have done with a reference is given below.
[Code]...
I am trying to use a ListView to display records from a dataset. In these records, I have 4 columns: EmployeeID, EmployeeName, CustomerID, and CustomerName. It is possible for both the Employee and Customer to be listed multiple times, but with different combinations.
For instance, if we have Employees 1, 2, 3 and Customers A, B, C we could have:
(1A)
(1B)
(1C)
(2A)
(2B)
etc.
What's going on with mine is I add say (1A) to the listView and then when it tries to add (1B) I get an error saying that it cannot add the same item.
Here is my code so far:
With list
.Clear()
.Columns.Add("Employee ID")
.Columns.Add("Employee Name")
.Columns.Add("Customer ID")
.Columns.Add("Customer Name")
[Code] .....