ASP.NET

//query what i had is// 
update table tb_staff set active=1 where active=0 

<asp:linkbutton id="lnkbtnactive" text="Active" commandargument='<%#Eval("id")%>' commandname="xxx" runat="server">

if (e.CommandName == "act" && e.CommandArgument=="StaffId")
                {
                    //sql conn
                    //sql comm ("select * from tb_staff"
                    DataSet ds = new DataSet();
                    DataTable dt = new DataTable();
                    OleDbDataAdapter ad = new OleDbDataAdapter(cm);
                    ad.Fill(ds, "tb_staff");
                    dt = ds.Tables["tb_staff"];
                    foreach (DataRow row in dt.Rows)
                    {
                        if (row["Active"].ToString() == "1")
                        {
                            SqlCommand cmd = new SqlCommand("update_staff_active", cnn);
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Parameters.Add("@StaffId", SqlDbType.Char).Value = "StaffId";
                            cmd.Parameters.Add("@Active", SqlDbType.Char).Value = "active";
               
                            SqlCommand cmd = new SqlCommand("update_staff_active", cnn);
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Parameters.Add("@StaffId", SqlDbType.Char).Value = "TextBox1.Text";
                            cmd.Parameters.Add("@Active", SqlDbType.Char).Value = "TextBox2.Text";
                            cnn.Open();
                            cmd.ExecuteNonQuery();
                            cnn.Close();
               
                           
                        }
                    }
                }

Yonathan1111 wrote:

Forum: ASP.NET
Subject: TableInsideTableRow [modified]
Sender: Yonathan1111
Date: Thursday, October 8, 2009 1:21 PM
Dear all, Thank you. I have made it.

Vishnu Nath wrote:

Could you please elaborate on how can i check for session expiration.
I used to check for session.IsNewSession on each page.

if(Session["UserID"] != null)
  {
   //Do Operation
  }
  else
  {
   Response.Redirect("Login.aspx");
  }

Abhijit Jana wrote:

if(Session["UserID"] != null)
{
//Do Operation
}
else
{
Response.Redirect("Login.aspx");
}