-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: raja_blr
Message 8 in Discussion
Hi, Try the following script... Include neccessary namespaces. private DataTable
GetDistinctRows(DataTable dt) { string prev,next; for(int i=0; i <
dt.Rows.Count; i++) { prev = GetConcatedRows(dt.Rows[i]); int k =
i+1; while(k < dt.Rows.Count) { next =
GetConcatedRows(dt.Rows[k]); if(prev == next)
dt.Rows.Remove(dt.Rows[k]); else k = k+1; }
} return dt; }
private string GetConcatedRows(DataRow dr)
{
StringBuilder sb = new StringBuilder();
object[] obj = dr.ItemArray;
for(int k=0; k < obj.Length; k++)
sb.Append(obj[k].ToString());
return sb.ToString();
} -Raja
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
