How to put a web site offline and in maintenance mode.

Place a file app_offline.htm in the root site and edit the content of this file to display the message to the end user like "Site is under maintenance".

Load Cycle of page with user control and master page .

Init Cycle:
(User Control/Custom Control) ---> Master Page ----> Page

Load Cycle:
Page ---> Master Page ----> (User Control/Custom Control)

PreRender Cycle:
Page ---> Master Page ----> (User Control/Custom Control)

Render Cycle:
Page ---> Master Page ----> (User Control/Custom Control)

How to work with multiple result sets using SqlDataReader?

string _connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;

protected void Page_Load(object sender, EventArgs e)
{
// get the connection
using (SqlConnection conn = new SqlConnection(_connStr))
{
// write the sql statement to execute
string sql = "SELECT AutoID, FirstName, LastName, Active FROM
PersonalDetail ORDER BY FirstName; " +
"SELECT AutoId, FileName FROM Files Order By FileName ASC";
// instantiate the command object to fire
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
// in case of multiple result set you will not be able to specify the
CommandBehavior
// if so you will not be able to get the next result set from the
reader
using (SqlDataReader reader = cmd.ExecuteReader())
{
// bind the first resultset
GridView1.DataSource = reader;
GridView1.DataBind();

reader.NextResult();

// bind the second resultset
GridView2.DataSource = reader;
GridView2.DataBind();
}
conn.Close();
}
}
}

how to update top 10 records using sql update statement?

update top (10) table1 set field1 = 1