LINQ

Hi, try to add new item then choose datacontext file. Hope this one can help. Thanks Hi, Please select Good Question if my answer are fit to your Question.

Posted a response[^] in the WPF forum

Linq is basically a workaround of queries with .NET objects in client, which you would be doing with loops earlier. Say, you have a list of objects of your own class, instead of writing a for loop, you can write a LINQ query to do your job. Later introduction of Parallel Framework with LINQ will result in better performance. Running queries or Stored procs in database is completely a different scenario. Dont confuse LINQ with database queries my friend. And of course for database stored procs work faster than normal queries as execution plan stored with the stored proc, which is absent for normal queries. :cool: Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions Create .NET Templates

Sweet! Thank you!:thumbsup:

a single pipe | is a bitwise or, you wanted a boolean or which is 2 pipes ||

Found the problem had to maually fill the datasource when using linq to SQL.

Ok I figured this out now. I needed to replace my bound item on the UI as it was still thinking it was of type DefectItem.

My bad I thought it was asp.net. Correct you dont need that for winforms.

Not quite like the query designer in sql server but will help with designing linq queries. Visual LINQ Query Builder[^]

I found the solution. :)                   movies = from movie in doc.Descendants("Movie")                               where movie.Attribute("Title").Value.Contains(title) &&                                        movie.Element("Directors").Elements("Artist").Any(dfn => dfn.Attribute("FirstName").Value.Contains(director.FirstName)) &&                                        movie.Element("Directors").Elements("Artist").Any(dln => dln.Attribute("LastName").Value.Contains(director.LastName)) &&                                        movie.Element("Cast").Elements("Actor").Any(acf => acf.Element("Artist").Attribute("FirstName").Value.Contains(actor.FirstName)) &&                                        movie.Element("Cast").Elements("Actor").Any(acl => acl.Element("Artist").Attribute("LastName").Value.Contains(actor.LastName))                               select movie; Juan Mejia

The return type would actually be IQueryable<Category> but as it is based on IEnumerable<Category> they are "interchangeable" (depending on you needs of course). ...Of course, we're talking about software development here, where the simplest solution is often ignored..

Hi! The 4 rows in the Row_Updating method is useless. They do not do anything. What are you trying to achieve? Have you bound the datafields in the aspx page? or are you trying to manually update the db with the values in the Textboxes? Andreas Johansson IT Professional at Office IT Partner i Norrbotten Sweden What we don't know. We learn. What you don't know. We teach

The DataBind is a method call and the syntax should be: this.GridView2.DataBind();

One thing would be to move any collections to generics, much improved memory usage amongst other benefits. The conversion wizard seems to me to do a fairly decent job for the most part. Don't forget to keep the original source safe. :) Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”