protected void btnAdd_Click(object sender, EventArgs e)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@au_fname", txtfName.Text),
new SqlParameter("@au_lname", txtLName.Text),
new SqlParameter("@phone", txtPhone.Text),
new SqlParameter("@address", txtAddress.Text),
new SqlParameter("@city", txtCity.Text),
new SqlParameter("@state", txtState.Text),
new SqlParameter("@zip", txtZip.Text)
};
DataAccessSQL daSQL = new DataAccessSQL();
bool retVal = daSQL.ExecuteNonQuery("AddNewAuthor", CommandType.StoredProcedure, parameter);
if (retVal == true)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Save Successful!');</script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Save Failed!');</script>");
}
}
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();
}
}
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 Page_Load(object sender, EventArgs e)
{
DataAccessSQL daSQL = new DataAccessSQL();
}
