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(); }