protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlPublisher.DataSource = daSQL.ExecuteSelectCommand("select * from publishers", CommandType.Text);
ddlPublisher.DataTextField = "pub_name";
ddlPublisher.DataValueField = "pub_id";
ddlPublisher.DataBind();
ddlPublisher.Items.Insert(0, new ListItem("--Select One--", "0"));
gridTitle.DataSource = daSQL.ExecuteSelectCommand("select * from titles", CommandType.Text);
gridTitle.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataAccessSQL dbAccess = new DataAccessSQL();
ddlSelect.DataSource = dbAccess.ExecuteSelectCommand("GetAuthorStates", CommandType.StoredProcedure);
ddlSelect.DataTextField = "state";
ddlSelect.DataValueField = "state";
ddlSelect.DataBind();
ddlSelect.Items.Insert(0, new ListItem("--Select One--", "0"));
GridAuthor.DataSource = dbAccess.ExecuteSelectCommand("GetAuthors", CommandType.StoredProcedure);
GridAuthor.DataBind();
}
}
protected void ddlSelect_SelectedIndexChanged(object sender, EventArgs e)
{
DataAccessSQL dbAccess = new DataAccessSQL();
if (ddlSelect.SelectedValue.Trim() == "ALL")
{
GridAuthor.DataSource = dbAccess.ExecuteSelectCommand("GetAuthors", CommandType.StoredProcedure);
}
else
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@state", ddlSelect.SelectedValue) };
GridAuthor.DataSource = dbAccess.ExecuteParamerizedSelectCommand("GetAuthorByState", CommandType.StoredProcedure, param);
GridAuthor.DataBind();
}
}