1: DataTable dtSource = new DataTable();

   2: protected void Page_Load(object sender, EventArgs e)

   3:    {

   4:     // Bind the source datatable from the database

   5:     dtSource = dataSource();

   6:    }

   7:  

   8: public DataTable FlipDataTable(GridView gvNew)

   9:     {

  10:         DataTable dataTable = new DataTable("dataTable");

  11:  

  12:         // create column

  13:         DataRow newRow;

  14:         for (int iRow = 0; iRow < dtSource.Columns.Count; iRow++)

  15:         {

  16:             newRow = dataTable.NewRow();

  17:  

  18:             newRow[0] = dtSource.Columns[iRow].ToString();

  19:  

  20:             for (int iCol = 1; iCol <= dtSource.Rows.Count; iCol++)

  21:             {

  22:                 newRow[iCol] = dtSource.Rows[iCol - 1][iRow];

  23:             }

  24:  

  25:             dataTable.Rows.Add(newRow);

  26:         }

  27:     }

   1: <Settings> 

   2:    <ElementCollection> 

   3:          <add key="SomeKey" value="SomeValue"> 

   4:          <add key="SomeKey" value="SomeValue"> 

   5:    </ElementCollection> 

   6: </Settings>

   1: // In this code we are getting the Data Item values of the Rad Editor. On UpdateCommand Event we are getting the values of data row in an instance of hash.

   2: GridDataItem dataItem = (GridDataItem)e.Item; 

   3: Hashtable ht = new Hashtable(); 

   4: dataItem.ExtractValues(ht);

   5:  

   6: //Get the node values as per the selected key name: 

   7: XmlNode AppNode = XmlDataSource1.GetXmlDocument().SelectSingleNode( String.Format("//add[@key='{0}']", key)); 

   8:  

   9: //Now assign the new value of the Value attribute of the selected node:

  10: AppNode.Attributes["value"].Value = ht["value"];

  11:  

  12: //Finally we need to update the xml source file:

  13: configXmlDataSource.Save();

   1: CREATE TABLE Employees

   2: (

   3:     Emp_UniqueID smallint PRIMARY KEY,

   4:     Emp_FName varchar(30) NOT NULL,

   5:     Emp_LName varchar(30) NOT NULL,

   6: )

   7: go

   8:  

   9: CREATE TABLE SalesCalls

  10: (

  11:     SalCal_UniqueID smallint PRIMARY KEY,

  12:     SalCal_Desc varchar(100) NOT NULL,

  13:     SalCal_Date smalldatetime NOT NULL,

  14: )

  15: go

  16:  

  17: CREATE TABLE SalesCallsEmployees

  18: (

  19:     SalCal_UniqueID smallint NOT NULL,

  20:     Emp_UniqueID smallint NOT NULL,

  21: )

  22: go