綁定GridView時改變DataSet的結構-----去除重複單元格

  綁定GridView時改變DataSet的結構，去除重複單元格

    private DataSet BindGV(string keyword)

    {

        SqlParameter[] parm = new SqlParameter[1];

        parm[0] = new SqlParameter("@item", keyword);

    DataSet ds = MySqlBase.GetVarsAsDataSet("wms_cell_Byitem_qry", parm);

        DataTable dt = ds.Tables[0];

        for (int i = 0; i < dt.Rows.Count; i++)

        {

            for (int j = i + 1; j < dt.Rows.Count; j++)

            {

     if (dt.Rows[j][0].ToString() == dt.Rows[i][0].ToString() && dt.Rows[j][2].ToString() == dt.Rows[i][2].ToString())

               for (int k = 0; k < dt.Columns.Count; k++)

                {

     if (dt.Rows[j][k].ToString() == dt.Rows[i][k].ToString())

                        {

                            string s = dt.Rows[j][k].ToString();

                            dt.Rows[j][k] = DBNull.Value;

                            string t = dt.Rows[j][k].ToString();

                            dt.AcceptChanges();

                        }

                        continue;

                }

                continue;

            }

        }

        this.GridView1.DataSource = ds;

        this.GridView1.DataBind();

        return ds;

    }