protected void LoadDropDownList()
{
DataTable tbl = dc.GetAuthors();
AuthorList.DataSource = tbl;
AuthorList.DataTextField = "AuthorName";
AuthorList.DataValueField = "AuthorKey";
AuthorList.DataBind();
AuthorList.Items.Insert(0, "Choose an Author");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lbl_userid.Text = Session["user_id"].ToString();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from Authors";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
AuthorList.DataSource = dr;
AuthorList.DataTextField = "Name";
AuthorList.DataValueField = "Name";
AuthorList.DataBind();
cn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
if (Session["user_id"] == null)
{
Response.Redirect("Login.aspx");
}
lbl_userid.Text = Session["user_id"].ToString();
}
catch (NullReferenceException e1)
{
Response.Write("<script>alert('Please Login!')</script>");
}
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from Authors";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
AuthorList.DataSource = dr;
AuthorList.DataTextField = "Name";
AuthorList.DataValueField = "Name";
AuthorList.DataBind();
cn.Close();
}
}
