void PopualteData()
{
string sType = "";
if (!string.IsNullOrEmpty(Convert.ToString(cmbType.Text.Trim())))
{
sType = cmbType.SelectedItem.ToString();
}
MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev);
List <USP_VP_GET_ACCOUNTResult> lstCategory = new List <USP_VP_GET_ACCOUNTResult>();
//lstCategory = MyDa.USP_VP_GET_ACCOUNT("", txtName.Text.Trim(), "", sType, "", txtMobileNo.Text.Trim(), Datalayer.iT001_COMPANYID.ToString()).ToList();
lstCategory = MyDa.USP_VP_GET_ACCOUNT("", "", "", "", "", "", Datalayer.iT001_COMPANYID.ToString()).ToList();
dgDisplayData.DataSource = lstCategory;
dgDisplayData.Columns["T001_ACCOUNTID"].Visible = false;
dgDisplayData.Columns["T001_CONTACT_PERSON"].Visible = false;
dgDisplayData.Columns["T001_ADDRESS1"].Visible = false;
dgDisplayData.Columns["T001_ADDRESS2"].Visible = false;
dgDisplayData.Columns["TM_STATEID"].Visible = false;
dgDisplayData.Columns["TM_STATEID1"].Visible = false;
dgDisplayData.Columns["TM_STATE_NAME"].Visible = false;
dgDisplayData.Columns["TM_STATE_CODE"].Visible = false;
dgDisplayData.Columns["T001_MOBILE2"].Visible = false;
dgDisplayData.Columns["T001_PHONE"].Visible = false;
dgDisplayData.Columns["T001_EMAIL"].Visible = false;
dgDisplayData.Columns["T001_OPENINGBAL"].Visible = false;
dgDisplayData.Columns["T001_GSTTIN"].Visible = false;
dgDisplayData.Columns["T001_TIN"].Visible = false;
dgDisplayData.Columns["T001_DISCOUNT"].Visible = false;
dgDisplayData.Columns["TM_COMPAYID"].Visible = false;
dgDisplayData.Columns["T001_TYPE"].Visible = false;
dgDisplayData.Columns["T001_NAME"].HeaderText = "Name";
dgDisplayData.Columns["T001_MOBILE1"].HeaderText = "Mobile No";
dgDisplayData.Columns["T001_CITY"].Visible = false;
dgDisplayData.Columns["T001_NAME"].DisplayIndex = 0;
dgDisplayData.Columns["T001_MOBILE1"].DisplayIndex = 1;
dgDisplayData.AllowUserToResizeColumns = false;
this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3);
dgDisplayData.EnableHeadersVisualStyles = false;
//this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
//dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3);
//dgDisplayData.EnableHeadersVisualStyles = false;
//// dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White;
//dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
//dgDisplayData.ColumnHeadersHeight = 30;
//dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
//dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
}
