public void BindDataGrid()
{
try
{
clsCompanyBusiness objLoad = new clsCompanyBusiness();
objLoad.Mode = "SELECTALL";
dgvCustomerMaster.AutoGenerateColumns = false;
var ds = objLoad.GetAllCompany();
dgvCustomerMaster.DataSource = ds.Tables[0];
lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindDataGrid", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindCompanyCombo()
{
try
{
clsCompanyBusiness objLoad = new clsCompanyBusiness();
objLoad.Mode = "SELECTALL";
var ds = objLoad.GetAllCompany();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr["CompanyBusinessKey"] = "0";
dr["CompanyName"] = "Please Select Company";
dt.Rows.InsertAt(dr, 0);
//DataRow dr = dt.NewRow();
/* Bind the Item Group */
cmbCompany.DataSource = dt;
cmbCompany.DisplayMember = "CompanyName";
cmbCompany.ValueMember = "CompanyBusinessKey";
cmbCompany.Text = "Please Select Company";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindCompanyCombo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
