linq

  1. M

    LINQ - quick help needed on an aggregate groupby

    Need some quick help as I've suffered over this easy problem all afternoon. Yes, I could do it in SQL easily then call that FillBy or 20 other different ways but I'm trying to figure out LINQ since I never used it before. Group by Year Month and sum all three integer columns Simple table...
  2. poncianux

    System.XML.Linq reference in Framework 2.0

    Due to most of the computers uses Windows XP or a non updated framework, as developer sometimes you need to use the most common tools, but what happens when the common tools doesn't have what you want? That's exactly what happens to me now with the reference 'System.XML.Linq' I need that...
  3. S

    Dynamically query a collection

    Hi all, I hope you can help. I have an object called tblTask (From linq query to the object) which has fields such as T3_1, T3_2, T3_3, T3_4. These are questions that need to be filled in by the user. I want to run a dynamic query to find out if any information is in that field or not. The...
  4. B

    Question Property as input parameter like LINQ

    Can someone help me please, i`m looking for a way to build a filter like LINQ but i want to use it before selecting data out of the database. For building a ORM witch can be used for our business. I`m looking for a way to execute a where function for example with ObjectA.PropertyB as argument...
  5. lordbaddkitty

    Question Linq join on parameterized distinct key CASE INSENSITIVE

    To Revisit a previous question with a further stipulation... Anyone know how to do the following, IGNORING CASE? Dim Matches = From mRows In LinqMasterTable Join sRows In LinqSecondTable _ On mRows(ThePrimaryKey) Equals sRows(TheForignKey) _ Order By...
  6. lordbaddkitty

    Question Linq join on parameterized distinct key

    I'm trying to LINQ two tables based on a dynamic key. User can change key via a combo box. Key may be money, string, double, int, etc. Currently I'm getting the data just fine, but without filtering out the doubles. I can filter the double in VB, but it's slooooow. I'd like to do it in the LINQ...
  7. N

    Question Using LINQ to SQL group, sum and aggreate all together

    Hi, I have two tables Students and Origami. Origami has Foreign Key of Students table. Each student can make one or more origami for each month. Students sample data: StudentId, FirstName, LastName - 187 , John , Maslow - 196 , Crystal , Hood - 195 , Sarah , Lewis Origami sample data...
  8. F

    Populate combobox using linq to sql selected items

    Hi, New to vb so please go easy on me :) Im trying to populate the combobox with items that are returned from a search of the database with linq from the combobox when the text changes(in the combo box) here is some of my code: Dim db As New ProdLinqDataContext Dim searchstring =...
  9. A

    Aspose.Total for .NET Q3 2009 Released

    What’s new in Aspose.Total for .NET Q3 2009? This Q3 2009 release of Aspose.Total for .NET includes a detailed quarterly summary about major feature enhancements and a large number of newly supported features by Aspose .NET components. Let me list down some of these important features for your...
  10. S

    Question DataGridView doesn't show changes of its DataSource

    Hello everybody! My application looks like the following: 1. An XML file is read using LINQ and the result is an enumeration of objects of a specific type (i don't use anonymous types). The result is then converted with result.ToList() to a standard list and saved to a list-variable. 2. I...
  11. S

    Question Return value of a LINQ query

    Hi everybody! I'm new here and I'm not a native speaker, so please don't be to severe ;). My XML source file: <?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?> <pricelist> <item> <item_no>123</item_no> <item_description> <description1>new item...
  12. R

    New records are not persistent in SQL Server Db

    Hello, I'm trying to learn how to write and save a new record to a SQL Server Db using LINQ. When I run my code and view the data in the table, the new record isn't there. However, when I query the table, the new record shows up! When I close the project, open it up, and run the query the...
  13. B

    Question LINQ on array of objects

    Let´s say I have an array (I named it "Points") of objects. Each object has a custom property called for example "Selected". The property type is Boolean. Can I use LINQ to determine the INDEX of the element in the "Points" array where "Selected=True"? (I´ve ensured that only one element can...
  14. D

    Populate an array using LINQ

    I have an array wherein i have to populate some objects that are not part of another object. For e.g there are objects called viewgroup and membershipgroup.i have to populate the array with viewgroup obj that are not part of the membershipgroup. i need to do this using LINQ in VB.Net. can anyone...
  15. kkemerait

    Linq over entities DataGridView - no Display

    Using a Linq statement to select objects from a custom collection Private Items As New Generic.List(Of T). The funtion is as follows... Public Function AllChildren() As Generic.IEnumerable(Of T) Dim Query = From Child As T In Items Select Child Return Query.ToList End...
Top Bottom