Adding items to datatable dynamically

Adding rows in datatable
     
        DataTable dt = new DataTable();
        if (Session["data"] != null)
                {
                    dt = (DataTable)Session["data"];
                }
                else
                {
                    DataColumn proid = new DataColumn("p_id");
                    DataColumn Product_id = new DataColumn("Product");                 

                    dt.Columns.Add(proid);
                    dt.Columns.Add(Product);                
                }
                DataRow dr = dt.NewRow();
                dr["p_id"] = productid.Text;
                dr["Product"] = pid.Text;                            
                dt.Rows.Add(dr);
                Session["data"] = dt;

Updating data in datatable

 protected void Edit_Click(object sender, EventArgs e)
     {      
        Button im = (Button)sender;
        GridViewRow gr = (GridViewRow)im.NamingContainer;
        DataTable dt = (DataTable)Session["myDt"];
        DataRow dr = dt.Rows[gr.RowIndex];
        Session["dr"] = dr;
        Label lblpro = (Label)GridView1.Rows[gr.RowIndex].FindControl("lblpronm");
        texttBox1.text=lblpro.text;
        }   

  protected void Update_Click(object sender, EventArgs e)
     {    
            DataTable dt = (DataTable)Session["myDt"];
            DataRow dr = (DataRow)Session["dr"];
            dr["Proname"] = lblpro.text;         
            GridView1.DataSource = dt;
            GridView1.DataBind();
      }

Deleting rows from datatable

 protected void Delete_Click(object sender, ImageClickEventArgs e)
    {
        ImageButton img = (ImageButton)sender;
        GridViewRow gr = (GridViewRow)img.NamingContainer;
        DataTable dt = (DataTable)Session["data"];
        DataRow dr = dt.Rows[gr.RowIndex];
        dr.Delete();
        GridView1.DataSource = dt;
        GridView1.DataBind();
      
    }

Inserting data from datatable to database

protected void btn_checkout_Click(object sender, EventArgs e)
    {
 DataTable dt = (DataTable)Session["data"];
for (int j = 0; j < dt.Rows.Count; j++)
        {
            dl.p_id = Convert.ToInt16(dt.Rows[j]["p_id"]);
            dl.products = Convert.ToInt16(dt.Rows[j]["Product"]);
            bl.insert_order(dl);                                             
        }

read more

AccordionPane in ajax

.css

 .accheader
    {
        background-color:#2E4D7B;
        border:1px solid #2F4F4F;
        color:White;
        cursor:pointer;
        font-family: Arial,Sans-Serif;
        font-size:12px;
        font-weight:bold;
        margin-top:5px;
        padding:5px;
        width:730px;
       
       
   
    }
    .accheaderselected
    {
        background-color:#5078B3;
        border:1px solid #2F4F4F;
        color:White;
        cursor:pointer;
        font-family:Arial,Sans-Serif;
        font-size:12px;
        font-weight:bold;
        margin-top:5px;
        padding:5px;
        width:730px;
    }
    .acccontent
    {
        background-color:#D3DEEF;
        border-color:-moz-use-text-color #2F4F4F #2F4F4F;
        border-right: 1px dashed #2F4F4F;
        border-style: none dashed dashed;
        border-width: medium 1px 1px;
        padding: 10px 5px 5px;
        width:715px;
       
    }
 

.aspx


div class="accordation">
    <asp:Accordion ID="Accordion1" runat="server"
        FramesPerSecond="40" RequireOpenedPane="false" SuppressHeaderPostbacks="True"
        TransitionDuration="255" Enabled="true" HeaderCssClass="accheader"
        HeaderSelectedCssClass="accheaderselected" ContentCssClass="acccontent" FadeTransitions="true" AutoSize="Limit" SelectedIndex="0">
        <Panes>
            <asp:AccordionPane ID="AccordionPane1" runat="server">
            <Header><a href="" class="href">Articles</a></Header>
            <Content >
            <ul>
            <li>Animation/ Multimedia</li>
            <li>Engineering/ Technology</li>
           </ul>
             </Content>           
            </asp:AccordionPane>
        </Panes>
      </asp:Accordion>
</div>
  

read more

Sorting in gridview

 public SortDirection dir
    {
        get
        {
            if (ViewState["dirState"] == null)
            {
                ViewState["dirState"] = SortDirection.Ascending;
            }
            return (SortDirection)ViewState["dirState"];
        }
        set
        {
            ViewState["dirState"] = value;
        }
    }
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        all_resol();
        DataTable dt = new DataTable();
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd = new SqlCommand("select* from Details whereActive='Active' and Status=1 ", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        dt = ds.Tables[0];
        {
            string SortDir = string.Empty;
            if (dir == SortDirection.Ascending)
            {
                dir = SortDirection.Descending;
                SortDir = "Desc";
            }
            else
            {
                dir = SortDirection.Ascending;
                SortDir = "Asc";
            }
            DataView sortedView = new DataView(dt);
            sortedView.Sort = e.SortExpression + " " + SortDir;
            GridView1.DataSource = sortedView;
            GridView1.DataBind();
        }
    }


 <asp:TemplateField HeaderText="IS" SortExpression="IS">
</asp:TemplateField>

read more

show online users

Global.asax

Application_start
{
    Application["unm"] =0;
}
Application_end
{
   Application["unm"] =0;
}
Session_start
{
   Application.lock();
   Application["unm"] =Convert.toInt16(Application["unm"]+1);
   Application.Unlock();
}Session_end
{
   Application.lock();
   Application["unm"] =Convert.toInt16(Application["unm"]-1);
   Application.Unlock();
}

.cs file

label1.text="online users"+Application["unm"];

read more