I need to get a list of distinct names inside the data table and the sum of values for each one. I know some basic stuff about linq, but i don't know how to put the distinct and the sums together.
The SQL Query:
SQL
SELECT DISTINCT username,
[Sum1] = SUM(day1),
[Sum2] = SUM(day2)
[Code].....
I have a DataGridView which populates from an SQL query just fine in default mode
using these table names
[firstName] [varchar](20) NOT NULL,
[lastName] [varchar](20) NOT NULL,
[code]....
I have edited the column headers and set the column names to the same values as my table names yet the data is not showing in form load I have set datagridview.AutoGenerateColumns = False I know the data is there if I delete datagridview.AutoGenerateColumns = False then the data is shown with the default headings?
I want to display distinct items from a column in a checked list box then make a selection or selections and perform commands based on info from a second column in that database the database is a small Access 2010 database in the application directory right now I added the data source and items dont display even though I selected that source in the checked list box properties
Dataset = MyDataSet1
CheckedListBox = MyListBox1
I tried it with a combo box and it shows items but includes duplicates, did I setup the datasource wrong?
[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesVS 2010 ComboBox filtering of db table names
View 4 RepliesI have written some code so i can connect to a Mysql db. But how can i get like an array of the columnnames?
View 2 RepliesI am trying to write names from a list box and it works apart from the first listbox item.So this doesn't work:
My.Computer.FileSystem.RenameFile("D:Renaming2.avi", TextBox4.Text & " " & "1" & " " & "-" & " " & ListBox1.Items(0))
But this does:
MessageBox.Show(ListBox1.Items(0))
So listbox1.items(0) does exist but I just get the error that there are illegal characters in the path.
I need to scrap data from a website where data is Inside table.
View 1 RepliesHow can I get a new distinct list from an existing list using LINQ? This is what I have so far and it is not distinct but does give me a new list.
Dim tmpQryColumn = (From a In _allAudits
Select New CheckBoxListItem
With {.Id = a.AuditColumn, .Name = a.AuditColumn}
).Distinct()
_columnList = New List(Of CheckBoxListItem)(tmpQryColumn)
How can I get a new distinct list from an existing list using LINQ? This is what I have so far and it is not distinct but does give me a new list.
Dim tmpQryColumn = (From a In _allAudits
Select New CheckBoxListItem
With {.Id = a.AuditColumn, .Name = a.AuditColumn}
[code]......
How to make a text file importer, I want to know how to import list of names from the text file to import it to the listbox component by using browse commands and button. And by using webbrowse component to load the link [URL] and insert the name selected from listbox from loaded names on the text box of my url and click the button signup.
And after the name is added and clicked the signup button from my web automatically to remove the names from the listbox. And after every click of signup button to refresh the link and insert next name and continuously do like that. I need this to send registration link to my members that applied their emails on my site for being informed when site will be launched.
I am trying to populate a listbox on form load of a list of directories. I only want to show the directory name, not the full path:
[code]...
The form opens w/ no data in the list box. I played w/ this for a bit and found the strFolderName(i) assignment seems to break the code (make it not work) but I can't figure out why.
Does anyone know a way for a datatable to be generated INSIDE the code of VB? It would be a "backup" datatable generation subroutine to be run in case the original datatable got damaged somehow (bad hard drive sectors, virus, whatever). It would need to be able to generate a "blank" datatable that could be filled in while running the program, instead of having to do it from an outside source (like Access).An example would be an "inventory" datatable (X product, Store Code, Manufacturer Code, Cost, Price).
View 11 RepliesI am trying to populate a combobox with a list of filenames from a selected directory. I am getting the directory OK but the combobox instead of having a list of 8 files max shown when I select the combobox has a full list of all the files selected from that directory.
Private Sub BrowseButton_Click(sender As System.Object, e As System.EventArgs) Handles BrowseButton.Click
If FolderBrowserDialog1.ShowDialog() = DialogResult.OK Then
TextBox1.Text = FolderBrowserDialog1.SelectedPath
End If
[Code].....
check if the entered data is in the same row inside the table using .net?
View 1 RepliesNET 3.0. Is there a Distinct on List(Of T)? What packages would I need to import? If not, is there an equivalence?
View 4 Repliessince this
(vb.net)
Dim test As New List(Of Integer())
test.Add(New Integer() {1, 2, 3})
test.Add(New Integer() {1, 3, 3})
test.Add(New Integer() {3, 2, 3})
[code]....
does not work, how would you do the distinct?
I have a List(Of Hardware) - the List is called HWModels
Class Hardware has the following Properties:
ModelName
Status
CPUStatus
MemoryStatus
DiskStatus
The List is populated by reading a CSV file, once it's populated, I want to return the distinct records based on the ModelName
I've attempted by doing it as follows:
(From a In HWModels Select a.ModelName).Distinct
But this isn't right because I end up with a list of only the ModelName's and nothing else.
How do I get the Distinct function to return all of the other class members within the list?
On to my question.I have a List(of String) that contains multiple items in each index.
A list declared as:
Dim NewStrings As New List(Of String)
May contain the following:
item (0) - (1 MKNO ABC 2.45 STND 3.3)
item (1) - (1 MKGO ABC 1.34 STND 2.5)
item (2) - (1 MKNO ABC 2.45 STND 3.3)
item (3) - (1 MKNO ABC 2.45 STND 3.3)
[Code]...
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 RepliesI am trying to distinct on multiple columns and get datarows from datatable. but getting error.
Dim query As IEnumerable(Of DataRow) =
(From row As DataRow In SourceTable.AsEnumerable() _
Select row.Field(Of String)("ColumnName1"),
[Code]....
I want another datatable with distinct row based on given columns from SourceTable.
I load a list from a database like the example below. The class has more properties that the database table holds so when I load the list from the DB, there are Null values for certain properties of each item in the list. When I try List = List.Distinct.ToList, it never works (when null values are present).
[Code]...
This is my first post here at Xtreme VB Talk. I just started programming 2 semesters ago. I am currently working on a program but I am having a little trouble with the length. I am trying to take the integer entered in a text box and using it inside the name of another object.
[Code]...
I am used to C like languages such as C#. I added a list box with a list of names. In the code behind I added the below code. When I run the code I am getting the MessageBox but it will state "UserName favorite color is " but does not show the color. I thought it might be misspelled or non-matching names but this is not the issue due to the names being correct.
Public Class Form1
Private Sub lstData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstData.SelectedIndexChanged
'Declare Variables
[CODE]...
I have a listbox that is sorted and the data table that is bound to it is also sorted. I am trying to add a Record to this data table and ensure that it is always at the end of the list. Is there a way to do this using specific character combination?
View 2 Replieshow to add together integers from the end of a list array based on certain criteria. example: a list of students assignments and grades, and im trying to add all of the grades from a certain student up based on the student id from the user.
the student table looks like this:
111 H1 09/12/2010 17
111 P1 09/14/2010 42
111 H2 10/02/2010 18
[Code].....
i need to copy all the rows with data from a existing table to other existing table through button click
View 13 RepliesI am trying to retrieve the data from MS Access Table to LIST-VIEW, its difficult for me to write the code
View 4 RepliesI need to pupulate a Grid, but i like to do like Microsoft SQL Server Management Studio, when you make a Select to a table with bounch of rows, it start show the result but in the botton still retriving data.So you can start looking the data, not like you get the data and after you get the last row you can asing to the Grid.
View 6 RepliesSo in this gridview, there is a column for status and I want to have a drop down list with Pass, Pending, Fail appear when the edit button is clicked. These values are already in a table, so I need to somehow bind from this table to each ddl for every row.Here is the column from the gridview. As you can see, I would like to just have a label showing when not in edit mode, and a ddl when the edit button is pressed
<asp:TemplateField HeaderText="During Production Status" SortExpression="DuringProductionStatus">
<EditItemTemplate>
[code]......