ASP.NET

Sneha Bisht wrote:

is it good practice to store dataset in session.

non-bugging Errors wrote:

1. How to show my web page content topmost in Search Engine like Google, Yahoo, Msn etc...

//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();
               
                           
                        }
                    }
                }