protected void btnSearch_Click1(object sender, EventArgs e) { if (txtID.Text != "") { DataManager.DataAccess da = new DataManager.DataAccess(); DataSet dsCompanies = new DataSet(); int CompanyID = Convert.ToInt32(txtID.Text); dsCompanies = da.FetchCompany(CompanyID); gvCompanyName.DataSource = dsCompanies; gvCompanyName.DataBind(); } else { DataManager.DataAccess da = new DataManager.DataAccess(); DataSet dsCompanies = new DataSet(); String Name = txtName.Text; dsCompanies = da.FetchCompany(Name); gvCompanyName.DataSource = dsCompanies; gvCompanyName.DataBind(); //dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim()); //gvPersonName.DataSource = dsPersons; //gvPersonName.DataBind(); } }
private void LoadCompany() { this.txtID.Text = Request.QueryString["CompanyID"]; int CompanyID = Convert.ToInt32(txtID.Text); DataManager.DataAccess da = new DataManager.DataAccess(); DataSet ds = da.FetchCompany(CompanyID); object ci = ds.Tables[0].Rows[0]["CompanyID"]; object cn = ds.Tables[0].Rows[0]["Name"]; object n = ds.Tables[0].Rows[0]["Notes"]; txtID.Text = ci.ToString(); txtName.Text = cn.ToString(); txtNotes.Text = n.ToString(); String Name = txtName.Text; }
private void LoadCompany() { this.txtID.Text = Request.QueryString["CompanyID"]; int CompanyID = Convert.ToInt32(txtID.Text); DataManager.DataAccess da = new DataManager.DataAccess(); DataSet ds = da.FetchCompany(CompanyID); object ci = ds.Tables[0].Rows[0]["CompanyID"]; object cn = ds.Tables[0].Rows[0]["Name"]; object n = ds.Tables[0].Rows[0]["Notes"]; txtID.Text = ci.ToString(); txtName.Text = cn.ToString(); txtNotes.Text = n.ToString(); String Name = txtName.Text; }
protected void btnSearch_Click1(object sender, EventArgs e) { if (txtID.Text != "") { DataManager.DataAccess da = new DataManager.DataAccess(); DataSet dsCompanies = new DataSet(); int CompanyID = Convert.ToInt32(txtID.Text); dsCompanies = da.FetchCompany(CompanyID); gvCompanyName.DataSource = dsCompanies; gvCompanyName.DataBind(); } else { DataManager.DataAccess da = new DataManager.DataAccess(); DataSet dsCompanies = new DataSet(); String Name = txtName.Text; dsCompanies = da.FetchCompany(Name); gvCompanyName.DataSource = dsCompanies; gvCompanyName.DataBind(); //dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim()); //gvPersonName.DataSource = dsPersons; //gvPersonName.DataBind(); } }