Distinct rows from a DataSet or DataTable


ds.Tables["Employee"].DefaultView.ToTable(true,”employeeid”);
ds – Dataset object
dt.DefaultView.ToTable( true, “employeeid”);

Comments

Post a Comment

Popular posts from this blog

Microsoft Technology

Throw Vs Throw ex Posted: 29 Jun 2010 08:41 AM PDT Throw Throw Ex try    {          // do some operation that can fail    }     catch  (Exception ex)    {         // do some local cleanup          throw ;    } try    {          // do some operation that can fail    }     catch  (Exception ex)    {         // do some local cleanup          throw  ex;    } It preserve the Stack information with Exception It Won't Send Stack information with Exception This is called as "Rethrow" This is called as "Breaking the Sta...
Read more

Design Patterns

Image
There are three basic classifications of patterns Creational, Structural, and Behavioral patterns. Creational Patterns • Abstract Factory :- Creates an instance of several families of classes • Builder : - Separates object construction from its representation • Factory Method :- Creates an instance of several derived classes • Prototype :- A fully initialized instance to be copied or cloned • Singleton :- A class in which only a single instance can exist Note : - The best way to remember Creational pattern is by remembering ABFPS (Abraham Became First President of States). Structural Patterns • Adapter :-Match interfaces of different classes . • Bridge :-Separates an object’s abstraction from its implementation. • Composite :-A tree structure of simple and composite objects. • Decorator :-Add responsibilities to objects dynamically. • Façade :-A single class that represents an entire subsystem. • Flyweight :-A fine-grained instance used for efficient sharing...
Read more

RDBMS Vs OODBMS

An Object-Oriented Database Management System (OODBMS), sometimes referred as Object Database Management System (ODMS) is a Database Management System (DBMS) that supports modeling and creation of data as objects. OODBMS provides support for object classes, class property and method inheritance by sub classes and their objects. A Relational Database Management System (RDBMS) is also a DBMS but, that is based on the relational model. Most popular DBMSs currently in use are RDMSs. As mentioned earlier RDBMS is based on the relational model and data in a RDMS are stored in the form of related tables. So, a relational database can simply be seen as a collection of one or more relations or tables with columns and rows. Each column corresponds to an attribute of the relation and each row corresponds to a record that consists of data values for an entity. RDMSs are developed by extending hierarchical and the network models, which were two previous database systems. Main elements of a RD...
Read more