protected void UpdateCompanyBtn_Click(object sender, EventArgs e) { Company company = new Company(); company.CompanyName = addCompanyTextBox.Text; company.CompanyId = Convert.ToInt32(CompanyIdHiddenField.Value); if (string.IsNullOrEmpty(addCompanyTextBox.Text)) { Response.Write("<script>alert('Input Field is empty');</script>"); } else { if (companySetupBll.Update(company) > 0) { Response.Write("<script>alert('updated');</script>"); } } List <Company> companies = companySetupBll.GetCompanies(); CompanyGridView.DataSource = companies; CompanyGridView.DataBind(); UpdateCompanyBtn.Enabled = false; saveCompanyBtn.Enabled = true; }
protected void Page_Load(object sender, EventArgs e) { List <Company> companies = companySetupBll.GetCompanies(); CompanyGridView.DataSource = companies; CompanyGridView.DataBind(); if (!this.IsPostBack) { UpdateCompanyBtn.Enabled = false; saveCompanyBtn.Enabled = true; } }
void BindData(string key) { string sql = ""; try { sql = "SELECT * FROM tbl_company WHERE company_status <> 1 AND company_name Like '%" + key + "%' ORDER BY company_name ASC"; MySqlDataAdapter da = function.MySqlSelectDataSet(sql); System.Data.DataSet ds = new System.Data.DataSet(); da.Fill(ds); CompanyGridView.DataSource = ds.Tables[0]; CompanyGridView.DataBind(); lbDeviceNull.Text = "พบข้อมูลจำนวน " + ds.Tables[0].Rows.Count + " แถว"; } catch { } }
protected void saveCompanyBtn_Click(object sender, EventArgs e) { Company company = new Company(); company.CompanyName = addCompanyTextBox.Text; if (string.IsNullOrEmpty(addCompanyTextBox.Text)) { Response.Write("<script>alert('Input Field is empty');</script>"); } else { Response.Write("<script>alert('" + companySetupBll.Save(company) + "');</script>"); } List <Company> companies = companySetupBll.GetCompanies(); CompanyGridView.DataSource = companies; CompanyGridView.DataBind(); }