Hi All, Thanks everyone for your kind support. I added one more feature to the solution that I tried(in the hope of "reference" for beginners).
To get DISTINCT values from the dataset - table of a particular column & assigned as datasource to a component. dt= ds.Tables[0].DefaultView.ToTable(true,"<ColumnName>"); //Here true refers the Distinct values cmb.DataSource = dt; cmb.DisplayMember = "<ColumnName>"; Note: You can't use distinct in filter as it is used for expression. RowFilter in DataView is similar to where clause in query. In case of much better solution, Pls add. Thanks & Regards, Vels:) On Aug 29, 2:50 pm, velsankar <[EMAIL PROTECTED]> wrote: > Hi, > > I am trying to assign a particular column values to combo box under > certain condition. > We can get datarow[] from dataset by select method (condition as > query). > Is it possible to assign a (single) column of the datarow [] to > combobox datasource. > That means, it need not to be combobox datasource or Items.Add() but > something else... > In simple, want to add the column values of the datarow[] to combobox > The basic idea is to avoid loops & recursive methods. Any idea???? > > Thanks & Regards, > Vels --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx -~----------~----~----~----~------~----~------~--~---
