Software Technology Tips

What -- To create a variable with table-like structure and to store the information within it. And to retains the records with page postbacks.

Why --  The need of temporary table may be necessary if you don't want to interact with the database as and when you need it. Rather you prefer storing all information in some intermediate variable and on certain conditions to synchronize these data with the database. It will increase your execution speed causing faster application loading which will give the end user more comfort and satisfaction.

How --  

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
{

    // To add Autoincremented column to the table.
    DataColumn dcSlno = new DataColumn("PK_ID");
    dcSlno.AutoIncrement = true;
    dcSlno.AutoIncrementSeed = 0;
    dcSlno.AutoIncrementStep = 1;
    dcSlno.DataType = typeof(Int32);
    dtTemp.Columns.Add(dcSlno);


    // To add column with the default value.
    DataColumn points = new DataColumn();
    points.ColumnName = "POINTS";
    points.DataType = typeof(Int32);
    points.DefaultValue = 1;
    dtTemp.Columns.Add(points);


    // If you want to add data from the database
    DataTable dtDatabase = null; // Fetch Data from database
    dtTemp = dtDatabase.Clone();
    dtTemp.Merge(dtDatabase);


    // TO insert SPecific rows to temp table.
    // ! note -- The structure of row must be matched with the structure of temporary rable.
    dtTemp.ImportRow(dtDatabase.Rows[0]);


    //Updation ::
    dtTemp.Rows[0].SetField<int>("POINTS", 20);


    // Deleation of record.
    dtTemp.Rows[1].Delete();


    //Filteration of records.
    string Expression = "POINT > 20";
    string sort = "SLNO ASC";
    DataRow[] drFiltered = dtTemp.Select(Expression, sort);