Xml Editor: Work with DataTable, DataView and DataGrid

• Download source files - 356 Kb

Introduction

Currently, I work on a web design project. I created a MenuCreator which is based on XML files. Then, the client the XML files are hard to maintain, since he knows not much about computer. Therefore, I created a simple XML editor with datagrid

Work With....

XML, DataTable, DataView, DataGrid

Step:

1. Load DataTable from XML

2. Bind DataTable to DataGrid

3. Work with DataGrid

• Insert a new row into n-position
• Edit a data row in a datagrid
• Delete a data row in a datagrid
• Move a data row up
• Move a data row down
• The data row GOTO n-position

4. Write back to XML

CODE...

There are thousand samples with edit and delete a dataRow in datagrid samples on web

So...i just put Insert a new row into n-position and Move up,down and GOTO ON...

INSERT INTO

 private void addNewRow()
  {   
   if(this.isGoodIndex( TB_newDrPosition.Text))
   {
    int newRp = int.Parse(TB_newDrPosition.Text);
    DataTable dt = (DataTable) this.Session[this._SessionName];
    DataRow dr = dt.NewRow();
    dr["Id"] = newRp;
    dt.Rows.InsertAt(dr,newRp);
    this.reorderId(dt);
    this.Session["xmlTable"] =dt;
    DataView dv = dt.DefaultView;
    dv.Sort = "Id";
    this.newRowFlag.Value = "1";
    this.DataGrid1.DataSource = dv;
    this.DataGrid1.EditItemIndex = newRp;//dt.Rows.Count-1;
    this.DataGrid1.DataBind();
   }
   else
   {
    this.LWarning.Text = "<a class='warning' >" + 
                                             "Bad Index Input </a>";
   }
  }

Item MOVE MOVE MOVE AND GOTO

In this programe, moving row up and down is just switch rows around.

ItemCommand in DataGrid

private void DataGrid1_ItemCommand(object source, 
        System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   int selectedIndex = e.Item.ItemIndex;
   DataTable dt = this.takeOutDt();//(DataTable) this.Session[_SessionName];
   switch(e.CommandName.Trim())
   {
    case "SelectUp":
     if(selectedIndex == 0)
     {
      this.LWarning.Text = "<a class='warning' >" + 
         "Top row can not be moved up, there is no heaven</a>";
     }
     else
     {
      this.SwitchRows(dt,selectedIndex, selectedIndex-1);
     }
     break;
    case "SelectDown":
     if( selectedIndex == dt.Rows.Count-1)
     {
      this.LWarning.Text = "<a class='warning' >" + 
             "Botton Row can not be moved down, there is no hell</a>";
     }
     else
     {
      this.SwitchRows(dt,selectedIndex, selectedIndex+1);
     }
     break;
    case "SelectGoto":
     string _index = ((TextBox)e.Item.FindControl("gotowhere")).Text;
     if(this.isGoodIndex(_index))
     {
      int index = int.Parse(_index);
      this.dtGoTo(dt, selectedIndex, index);
     }
     break;
   }
   this.throwBackDt(dt);
   dTtoXml(dt, this._filePath,this._xmlStyle, this._XMLdtTag,this._XMLdrTag);
   DataView dv = dt.DefaultView;
   dv.Sort = "Id";
   this.DataGrid1.DataSource = dv;
   this.DataGrid1.DataBind();
  }

Switch rows

 private void SwitchRows(DataTable _dt, int i, int j)
  {
   object[] _iRow = _dt.Rows[i].ItemArray;
   object[] _jRow = _dt.Rows[j].ItemArray;
   _dt.Rows[i].ItemArray = _jRow;
   _dt.Rows[j].ItemArray = _iRow;
  }

GOTO

  private void dtGoTo(DataTable dt , int curI, int newI)
  {
   DataRow holder = copyRowAt(curI, dt);
   dt.Rows.RemoveAt(curI);
   this.reorderId(dt);
   dt.Rows.InsertAt(holder, newI);
   this.reorderId(dt);
   this.throwBackDt(dt);
   dTtoXml(dt, this._filePath,this._xmlStyle, this._XMLdtTag,this._XMLdrTag);
   this.DataGrid1.DataSource = dt.DefaultView;
   this.DataGrid1.DataBind();
  }

Thanks

Thanks for million of articles from web.

It is not really good code.....yet...

Thank you for Viewing...