DataView Distinct

dataview 可以将一个dt重新排序 或是筛选 可是如果要实现distinct 得话好像没有直接得方法,要实现discinct和count的话  研究了一下可以按下面的方法来做  可能效率低了点 可是暂时没有更好的方法了  呵呵

 SqlConnection con  =   new  SqlConnection(Constr);
            SqlDataAdapter da  =   new  SqlDataAdapter( " select * from test " ,con);
           DataTable dt  =   new  DataTable();
           da.Fill(dt);
        
            DataView dv  =   new  DataView(dt);
            dv.Sort  =   " name " ;
           dt  =  dv.ToTable();

            DataTable tb  =   new  DataTable();
            DataColumn col1  =   new  DataColumn( " name " );
            DataColumn col2  =   new  DataColumn( " count " );
tb.Columns.Add(col1);
            tb.Columns.Add(col2);
           Distinct Distinct #region Distinct
            for (int i = 0; i < dt.Rows.Count; i++)
            {
              
        if(i==0||dt.Rows[i][0].ToString() != dt.Rows[i - 1][0].ToString())
        {
            DataRow disRow = tb.NewRow();
                     disRow[0] = dt.Rows[i][0];
                      tb.Rows.Add(disRow);
        }
            }
            #endregion
            Count Count #region Count
            foreach (DataRow row in tb.Rows)
            {
                DataRowView[] arows = dv.FindRows(row[0]);
                row[1] = arows.Length.ToString();
            }
            #endregion
            GvData.DataSource  =  tb;
            GvData.DataBind();

转载于:https://www.cnblogs.com/joy/archive/2007/05/20/753147.html