VS 2008 - LINQ Query Against A Typed Datatable That Will Return Me Duplicated Data?
Jan 25, 2010
I'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.With out going into too much detail, here's the basic setup:
strCode1 - string type
intCode1 - int32 type
intAdjustor - int32
There are more fields but these are the ones that are important.I'm going to do my best to describe this, as it's kind of confusing.In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear. Example:
[code]...
Ultimately I'd like to get a List(Of T) - where T is my typed data row. In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.
View 7 Replies
ADVERTISEMENT
Mar 8, 2011
What I'm trying to do is to write a generic rss reader that I plug in any URL into without worry if the feed has all the common properties. For instance in my example below I'm looking for pubDate, however if no pubDate exists in the xml I'd like to return the current Date. I cannot seem to get the syntax right though.
Dim xmldoc As New XDocument
xmldoc = XDocument.Load(url)
Dim feeds = From feed In xmldoc.Descendants("item") Select New With { _
[code].....
View 2 Replies
Apr 18, 2011
Is this the most straight forward way to return a typed collection?Here's the key line of code which returns a implicit type of IEnumerable that used to manually loop through to manually recreated a TYPED collection. Is there any native LINQ way to return a typed sorted collection without this recreating of the collection? [code]
View 2 Replies
Nov 7, 2011
i need to query the datatable & set the outcome as datagridview controls datasource
vb.net
Private Sub Txt_Search_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txt_Search.TextChanged
'routine objective:- Filter datatable & set the datagridview datasource
[code]....
View 3 Replies
Jan 24, 2012
Currently, I am using a loop to find the row I want to update.
Public Sub pubsub_SetUserDGVColumnWidth(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewColumnEventArgs)
' update all user settings for the given column
[Code]....
View 8 Replies
Nov 3, 2011
I have a method that takes in an id, a start date, and and end date as parameters. It will return rows of data each corresponding to the day of the week that fall between the date range. The rows are all doubles. After returning it into a DataTable, I need to be able to use LINQ in VB.NET to return the maximum value. How can I achieve this? Here is the initial setup?
[Code]...
View 1 Replies
Oct 15, 2010
I have a method, that returns a group of accounts
Public Shared Function GetAllNotesByUser(ByVal UserID As Guid) As Account (??)
Using db As New MyEntity
Dim query= (From A In db.Account _
[Code].....
I would then like to pass this to another function to calculate the totals for all the accounts in the collection. Is it best practice to return an Ienumerable, a generic list, I'm just not sure what works best with LINQ and the entity framework.
View 4 Replies
Jul 20, 2010
How can i write this query with LINQ to a FoxPro database?SELECT count(*) FROM Table group by item1I wrote it as below, but it doesn't work
Dim Query
Dim dt As New DataTable
Dim da = New Odbc.OdbcDataAdapter("SELECT * FROM table1",connection)
[code].....
View 3 Replies
Feb 18, 2010
I have an SQL table(for example, it have 1 column "kod" with 3 rows:1,2,3 ). To operate it, I used class LINQ to SQL and I create tmp dataset with one table, with one column "col" with values - 2,3,4. To operate with this tmp table i use IEnumerable(T).I want to find only new values in tmp table and write its in SQL table. To find this values, i want to use LINQ query. Queris to each table are worked well. But query for 2 tables don't work.
Imports System.Linq
Imports System.Data.Linq
Public Class Form1
[code]....
View 5 Replies
Dec 6, 2009
I have a set of LINQ queries filtering original datatable (loaded from Excel file) based on user selections in Comboboxes. Then the result is joined with Arraylist to further filter the set. Arraylist is a simple list of strings.
Query:
If (Samples.Item(0) Is Nothing) = False And Samples.Item(0) <> "All samples" Then
queryResults = From records In queryResults Join samp In Samples _
On records("SAMPNUM") Equals samp _
[Code]....
View 1 Replies
Sep 15, 2010
This is what I'm trying...
Dim myCommand as SqlCommand
Dim myTable as New xsdObject.ObjectDataTable
myCommand = DataAccess.GetSQLCommand( "MyStoredProc", _
[code]....
'How to access my data ?
View 1 Replies
Nov 4, 2011
Use ExecuteSQLCommand and return my data in a datatable and access it? This is what I'm trying.[code]...
View 2 Replies
Apr 16, 2012
Given a simple DTO (AccountExpiry) with properties of 'AccountNo' and 'ExpiryDate' and a List of same created thus:
New AccountExpiry(123, New Date(2012, 4, 1))
New AccountExpiry(123, New Date(2012, 4, 2))
New AccountExpiry(123, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 2))
New AccountExpiry(124, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 4))
How do I use LINQ to retrieve the most recent entry per account. I have a feeling this will involve GroupBy and FirstOrDefault. It seems like...
From Item In Source Group By Item.AccountNo Into Group
Should return all of the data grouped appropriately, but It is unclear how I might apply .FirstOrDefault to each group.
View 1 Replies
Jul 8, 2010
i want to use linq to fetch data from datatable.I have 2 tables in Cache and i want to join these tables then get value from resultset.I pasted Original Sql query and my linq query here.My linq query returns nothing.Where do i miss?My original sql query returns 1 row,but q1 is nothing
[Code].....
View 1 Replies
Sep 1, 2010
I am wondering if it is possible to filter data from a datatable.Sample datatable
Quote:
Sno CatID Nos
1 XYZ 25
[code].....
View 5 Replies
Jun 14, 2009
I wrote a procedure that builds a DataTable in memory using data stored on our DB2 database. The function builds a Multi-Level Bill of Materials (BoM), meaning that the data cannot simply be queried. The function works great and returns a nicely arranged DataTable object. However, I then need to query the in-memory DataTable against other tables on our server. What would be the best way to approach this problem? Should I make a DataTableAdapter for the Server tables and then build a DataView? I don't have too much experience yet with Data objects. (By the way, I looked into LINQ to DB2 and even installed IBM's addin's, but our server doesn't seem to support it at this time.)
View 6 Replies
Apr 16, 2011
I was wandering is it possible to use a query within another query below is the code I am trying to use.
Public Function GetInventByComp(ByVal CompID As String) Using DC As New DataClassDataContext
'need to get company id's based off names? thats bad should be name from Id need to rethink this
Dim invent = (From C In DC.Inventors_Companies _
Where C.CompID = CompID _
Select C.InventorID).ToString
[Code]...
I was trying to us multiple values in a string like "1, 3, 5" but I can't seem to get that working either so I am trying to use just a single value now. Can anyone help me? "Yes I am new to this"
View 5 Replies
Nov 19, 2009
So, I run a select statement in SQL and then it has something like " where clientName = 'John Doe' " I can generate a datagrid or dataset off the SQL statement, but it will only be good fro one client...... I would like to be able to populate a dataset/grid using the select satement and then having something like a combo box of names the USER can choose. Then the user selects the name and the datagrid is populated with that clients info or w/e........
[Code]....
View 2 Replies
Sep 22, 2009
I know that LINQ queries are deferred and only executed when the query is enumerated, but I'm having trouble figuring out exactly when that happens.Certainly in a For Each loop, the query would be enumerated.What's the rule of thumb to follow? I don't want to accidentally enumerate over my query twice if it's a huge result.
For example, does System.Linq.Enumerable.First enumerate over the whole query? I ask for performance reasons. I want to pass a LINQ result set to an ASP.NET MVC view, and I also want to pass the First element separately. Enumerating over the results twice would be painful.It would be great to turn on some kind of flag that alerts me each time a LINQ query is enumerated. That way I could catch scenarios when I accidentally enumerate twice.
View 3 Replies
Feb 21, 2012
syntax of the LINQ query to use GROUP something BY something and select some fields of the datatable. i am having a datatable filled with some rows, i am trying to fill the datagridview with the GROUP BY query output of some fields.
View 4 Replies
Jan 19, 2011
I have the following linq query which returns a Report Object; yet I need to explicitly set the value of one of its proprties from another column. [code]...
View 1 Replies
Mar 20, 2011
I'm stuck! i'm trying to read a txt file with the data as below:
LEE
JOSH
JOSH
[Code]....
the txt file is updating all the time. So, i like to read this file and then display in msgbox the name that is most duplicated. In this case the MsgBox will show JOSH.
View 1 Replies
Sep 29, 2011
I have a datatable being returned by my DAL. In my BAL I want to return a class object. So I have a class called BusinessArea that has ID, Description and Active properties. I tried this:
[Code]...
View 2 Replies
Jul 18, 2010
I'm wanting to have some datatables that are just used temporarily, mainly for creating and listing friendly versions of data that will be easier for the user to read in drop-down combos etc.
I would like them to be strongly typed to pick-up bugs at design-time. However I'm struggling to know how to achieve this. Do I need to create a custom class and inherit from DataTable and build the columns in the class constructor?I don't need a Dataset, just a DataTable?
View 4 Replies
Nov 26, 2010
I am trying to create a LINQ query statement that retrieve intersecting data from 3 datatables (dt, dt1, dt2). My first attempt to do so with the following LINQ query statement was successful: [code] However in my design, I would need the LINQ query statement to be dynamically generated, because I want a user to be able to retrieve intersecting data entries from VARIABLE number of datatables. In this case, the first option is not as good as the "INTERSECT" query operator, with which I can just easily connect each SQL query statement with a "INTERSECT" operator. The problem is that my second attempt using the "intersect" operator fails, and after many trials and errors I still can't get it to work. [code]
View 5 Replies
May 21, 2012
I am creating an application for a friend and have no issue inserting or updating the table, but I am having trouble relaying the information from the query back to the corresponding textbox when searching for an entry.
This is the closest thing I've got to a working model, but I'm still getting and "array out of index error".
[Code].....
View 3 Replies
Feb 7, 2010
I am trying to call a SELECT query (with parameters) in Access from VB.Net 2008. I am able to call queries without parameters using the code below. The problems are (1) how to apply the parameters to procName and (2) how to get a dataset returned. I have looked around the net for hours and have found some examples. However, they are all for ms access action (update, delete, etc) queries using ExecuteNonQuery which does not return a dataset.
[Code]...
View 1 Replies
Dec 12, 2011
I use this code to return records in a DataGridView:
[Code]....
View 3 Replies
Oct 26, 2011
I have these objects:[code]Using LINQ I need to take a List(Of MakeInfo) and a List(Of ModelInfo) and aggregate the StockInfo from ModelInfo into the List(Of MakeInfo).So for each MakeInfo I will have a total count of all stock where MakeInfo.Name = ModelInfo.Make, and also a minimum price.I think it's going to be something like this, but I'm having trouble accessing the nested object and not sure if it's going to be possible with a single query.[code]
View 2 Replies
Jul 14, 2010
vb.net 2005
Here is one attempt:
Dim myRow As BurnerService.OEBSContractBatchesRow
Dim myDate As Nullable(Of DateTime)
myRow = Me.BurnerService.OEBSContractBatches.AddOEBSContractBatchesRow( _
[Code].....
View 2 Replies
