void PopualteData() { if (Datalayer.T010_PACKINGSLIPID > 0) { DataTable dt = new DataTable(); dt = dl.SelectMethod("SELECT * FROM T010_PACKINGSLIP WHERE T010_PACKINGSLIPID=" + Datalayer.T010_PACKINGSLIPID); if (dt != null && dt.Rows.Count > 0) { cmbName.SelectedValue = int.Parse(dt.Rows[0]["T001_ACCOUNTID"].ToString()); PopualtePackingDetails(); cmbName.Enabled = false; dtpDate.Text = dt.Rows[0]["T010_DATE"].ToString(); txtBillNo.Text = dt.Rows[0]["T010_NO"].ToString(); txtTransport.Text = dt.Rows[0]["T010_TRANSPORT"].ToString(); txtLRNo.Text = dt.Rows[0]["T010_LRNO"].ToString(); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_ORDERLIST_FOR_PACKINGSLIP_ON_IDResult> lstCategory = new List <USP_VP_GET_ORDERLIST_FOR_PACKINGSLIP_ON_IDResult>(); lstCategory = MyDa.USP_VP_GET_ORDERLIST_FOR_PACKINGSLIP_ON_ID(Datalayer.T010_PACKINGSLIPID.ToString(), Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; dgDisplayData.Columns["T004_ORDERID"].Visible = false; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; dgDisplayData.Columns["TM02_PRICE"].Visible = false; dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Size"; dgDisplayData.Columns["T004_DATE"].HeaderText = "Date"; dgDisplayData.Columns["T004_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy"; dgDisplayData.Columns["T004_QTY"].HeaderText = "Qty"; dgDisplayData.Columns["T004_PENDING_QTY"].HeaderText = "Packing Qty"; dgDisplayData.Columns["T004_IS_COMPLITE"].HeaderText = "Is Complite ?"; dgDisplayData.Columns["T004_IS_URGENT"].HeaderText = "Is Urgent ?"; dgDisplayData.Columns["T004_DATE"].DisplayIndex = 0; dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 1; dgDisplayData.Columns["TM02_SIZE"].DisplayIndex = 2; dgDisplayData.Columns["T004_QTY"].DisplayIndex = 3; dgDisplayData.Columns["T004_PENDING_QTY"].DisplayIndex = 4; dgDisplayData.Columns["T004_IS_COMPLITE"].DisplayIndex = 5; dgDisplayData.Columns["T004_IS_URGENT"].DisplayIndex = 6; 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; dgDisplayData.Columns["T004_DATE"].Width = 100; dgDisplayData.Columns["TM01_NAME"].Width = 350; dgDisplayData.Columns["T004_DATE"].ReadOnly = true; dgDisplayData.Columns["TM01_NAME"].ReadOnly = true; dgDisplayData.Columns["TM02_SIZE"].ReadOnly = true; dgDisplayData.Columns["T004_QTY"].ReadOnly = true; dgDisplayData.Columns["T004_IS_COMPLITE"].ReadOnly = true; dgDisplayData.Columns["T004_IS_URGENT"].ReadOnly = true; cmbName.Focus(); } } }