Wrong forum, Try here[^] (I tried it and I don't get any s:- option at all. Perhaps give a more detailed explanation when you repost this in the correct place) Simon

Google broken where you are?[^]

wrapped property for merged cell is set. still not showing the hidden part.

i want in 2003

You can use the Concat method to concatenate lists together. So, if you wanted to insert a "--select--" string at position 1 in a list of strings, you could do it like this: string[] valueToInsert = { "--select--"; }; string[] otherValues = { "foo", "bar", "baz", "bat" }; var result = valueToInsert.Concat(otherValues); Tech, life, family, faith: Give me a visit. I'm currently blogging about: Upon this disciple I'll build my new religion? The apostle Paul, modernly speaking: Epistles of Paul Judah Himango

what you did not like the answers you got last time clickety[^] Never underestimate the power of human stupidity RAH

Hi Nilish, Try these links: Link #1[^] Link #2[^] Link #3[^] I hope these would be helpful. John Adams ComponentOne LLC. www.componentone.com

Yes, that would work. I would call it a cheap version of #1. :) Despite everything, the person most likely to be fooling you next is yourself.

I'm not making fun of the issue. I'm telling you that the answer is there. If you have a problem with the answer, then post the followup on that thread - don't create a new one because: a. It looks like you haven't read the replies to the original post. b. Other people use these forums to find the answers to problems, so if you split your thread up it makes it almost impossible for them to find the answer. c. It looks like you're trying to bump your post to the top. Deja View - the feeling that you've seen this post before. My blog | My articles

You'll have to ask Infragistics that question. Click here[^]. When you paid for the controls, you also paid for support. You DID pay for the controls, correct? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Hi , Please go through this code.... BaseClassDataContext = New BaseClassDataContext(BLLmdlCommon.strConfiguration) 'Left outer join for extracting the project table records Dim query = From p In BaseClassDataContext.GetTable(Of CP\_Project)() \_ Group Join crt In BaseClassDataContext.GetTable(Of CP\_CLM\_ClientRating)() \_ On p.RatingID Equals crt.RatingID Into ratingname = Group From c In ratingname.DefaultIfEmpty() \_ Group Join cname In BaseClassDataContext.GetTable(Of CP\_CLM\_Client)() \_ On cname.ClientID Equals p.ClientID Into clientname = Group From c1 In clientname.DefaultIfEmpty() \_ Group Join pstatus In BaseClassDataContext.GetTable(Of CP\_PRJ\_ProjectStatus)() \_ On pstatus.ProjectStatusID Equals p.ProjectStatusID Into projectstatus = Group From c2 In projectstatus.DefaultIfEmpty() \_ Group Join pjtype In BaseClassDataContext.GetTable(Of CP\_PRJ\_ProductType)() \_ On pjtype.ProductTypeID Equals p.ProductTypeID Into pj = Group From projecttype In pj.DefaultIfEmpty() \_ Select c.Rating, p.ProjectName, c1.ClientName, p.StartDate, p.DeliveryDate, c2.ProjectStatus, \_ p.ProjectID, c.RatingColor, projecttype.ProductType 'grdTasks.DataSource = query If i bind the grid now then i don't get the order of the column as i mentioned above Now instead of binding the grid now , if i create it's XML and convert into dataset . Then the order is correct. xElement = New XElement("Root", From p In query Select New XElement("Leaf", _ New XElement("Rating", p.Rating), _ New XElement("ProjectName", p.ProjectName), _ New XElement("ClientName", p.ClientName), _ New XElement("StartDate", p.StartDate), _ New XElement("DeliveryDate", p.DeliveryDate), _ New XElement("ProjectStatus", p.ProjectStatus), _ New XElement("ProjectID", p.ProjectID), _ New XElement("RatingColor", p.RatingColor), _ New XElement("RatingColor", p.ProductType))) ds = New DataSet ds.ReadXml(New System.IO.StringReader(xElement.ToString()))

Linq will not support spaces in variable names. You can use _(underscore) instead of space. dim query = from p in baseclass.gettable(of table1)() _ select first_name = p.name Cheers, sekhar

He wants something converted in Linq, and is wanting someone to do it for him. "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

LINQ querues return IEnumerable(of T) In your example you're creating an anonymous type[^], so T is an anonymous type, so passing it as a return of a function is going to be an issue. Object will work of course, but how do you get the results? 1) don't use an anonymous type, use a Structure or Class e.g. Select New MyType With { .field1 = p.name , .field2 = c1.name1 } 2) return an anonymous type and use reflection to get the property values This is what I do for my Report generator - it does not know the type the report will generate, but it gets a list of properties from the report and uses Reflection. 'Howard

To be able to insert in the code you need to know the type of object in your list. Your original query returns IEnumerable(of CP_PRJ_ProjectStatus) so you'd have to insert a new CP_PRJ_ProjectStatus entry into that (which you probably don't want to do). Secondly the query is returning the whole table when only two values are needed. You could create your own structure or class to hold the ID,Name values and then insert one at the top, in the example below I've used the generic KeyValuePair class since it's there already. I've put ID into Key and Name into Value. Public Function ReturnProjectStatus() As List(Of KeyValuePair(of String, String)) Dim Baseclassobject As BaseClassDataContext = Nothing Try Baseclassobject = New BaseClassDataContext(BLLmdlCommon.strConfiguration) Dim query = From p In Baseclassobject.GetTable(Of CP\_PRJ\_ProjectStatus)() \_ Select New KeyValuePair(of String, string)(p.ID, p.Name) \_ Return query.ToList() Catch ex As Exception End Try End Function Private Sub abc() cmbStatus.DisplayMember = "name" cmbStatus.ValueMember = "ID" Dim query = ReturnProjectStatus() 'Insert new value at top query.Insert(0, New KeyValuePair(of string, string)("ID","Value") combobox1.datasource = query End Sub 'Howard

ParamArray only works when you are directly calling the function. The arguments passed to a ParamArray parameter will always be converted to an array at compile time. When you are using Me.Invoke, you need to make the array yourself. Me.Invoke(New d(AddressOf disablefunction), False, new Button() {Button1, Button2}) As a bonus, if you had declared the function as disablefunction(ParamArray b() as object) and called it as disablefunction(new button() {Button1, Button2}) you would get a one element array that is an array of buttons.

There isn't an In predicate in LINQ. I assume you mean the IN clause from SQL. e.g. SELECT * FROM Customers WHERE Country IN ('UK','Germany'); There are several ways to do this. The simplest: Dim countries = new String() {"UK","Germany"} Dim query = from c in db.Customers _ where countries.Contains(c.Country) _ select c Note that LINQ to SQL translates the .Contains() function into an IN clause. 'Howard

like sql s server

I assumed that ID was not a nullable value (if it truly is an ID it should not be). LINQ is saying it's not sure which extension method to use with ID since it's not an Int but Int? (nullable int). If you don't want to include the nulls, just cast it to an int: dim query = From T In db.Table _ Group T by Name = T.Name _ Into c=Count(), MaxID=Max(Ctype(T.ID,Integer)) _ Where c > 1 _ Select MaxID, Name Or you can convert the nulls to a zero, e.g. MaxID=Max(T.ID.GetValueOrDefault(0)) 'Howard