<script runat="server">
SqlConnection objConn = new SqlConnection();
SqlCommand objCmd = new SqlCommand();
SqlDataAdapter dtAdapter = new SqlDataAdapter();
DataTable dt = new DataTable();
String strConnString, strSQL;
void Page_Load(object sender,EventArgs e)
{
strConnString = "Server=localhost;UID=sa;PASSWORD=12345;database=mydatabase;Max Pool Size=400;Connect Timeout=600;";
if (Convert.ToString(Session["strUser"]) == "")
{
Response.Redirect("index.aspx");
Response.End();
}
if(!Page.IsPostBack)
{
BindData();
}
}
void BindData()
{
strSQL = "SELECT * FROM AddRoom";
objConn.ConnectionString = strConnString;
objCmd.Connection = objConn;
objCmd.CommandText = strSQL;
objCmd.CommandType = CommandType.Text;
objCon ...
Go to the complete details ...