private void ListFilteredStock() { try { pnlList.Visible = true; grdList.Visible = true; grdList.Rows.Clear(); StockReconcolitationDB sdb = new StockReconcolitationDB(); List <stockreconcolitation> stockList = StockReconcolitationDB.GetStockReconcolitationList(); foreach (stockreconcolitation st in stockList) { grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["StockItemID"].Value = st.StockItemID; grdList.Rows[grdList.RowCount - 1].Cells["StockItemName"].Value = st.StockItemName; grdList.Rows[grdList.RowCount - 1].Cells["Reciept"].Value = st.Reciept; grdList.Rows[grdList.RowCount - 1].Cells["Issue"].Value = st.Issue; grdList.Rows[grdList.RowCount - 1].Cells["Balance"].Value = st.PresentStock; } if (grdList.RowCount > 0) { txtSearch.Visible = true; lblSearch.Visible = true; btnExportToExcel.Visible = true; } } catch (Exception ex) { MessageBox.Show("Error in Stock listing"); } }
//---------------- //private void setdgvStyle() //{ // dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; // dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Highlight; // dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); // dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText; // dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; // dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; // dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; // this.grdList.AllowUserToAddRows = false; // this.grdList.AllowUserToDeleteRows = false; // this.grdList.AllowUserToOrderColumns = true; // //dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); // //this.grdList.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; // this.grdList.BackgroundColor = System.Drawing.SystemColors.GradientActiveCaption; // this.grdList.BorderStyle = System.Windows.Forms.BorderStyle.None; // dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; // dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Highlight; // dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); // dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText; // dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; // dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; // dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; //} private DataGridView fillgrddetail(string stockitemid) { DataGridView grdDetail = new DataGridView(); try { grdDetail.RowHeadersVisible = false; ////DataGridViewLinkColumn dgvlc = new DataGridViewLinkColumn(); ////dgvlc.SortMode = DataGridViewColumnSortMode.Automatic; ////grdDetail.Columns.Add(dgvlc); DataGridViewTextBoxColumn dgvtx1 = new DataGridViewTextBoxColumn(); dgvtx1.Name = "DocumentDate"; grdDetail.Columns.Add(dgvtx1); DataGridViewTextBoxColumn dgvtx2 = new DataGridViewTextBoxColumn(); dgvtx2.Name = "DocumentID"; dgvtx2.Width = 150; grdDetail.Columns.Add(dgvtx2); DataGridViewTextBoxColumn dgvtx3 = new DataGridViewTextBoxColumn(); dgvtx3.Name = "DocumentNo"; grdDetail.Columns.Add(dgvtx3); DataGridViewTextBoxColumn dgvtx4 = new DataGridViewTextBoxColumn(); dgvtx4.Name = "Receipt"; grdDetail.Columns.Add(dgvtx4); DataGridViewTextBoxColumn dgvtx5 = new DataGridViewTextBoxColumn(); dgvtx5.Name = "Issue"; grdDetail.Columns.Add(dgvtx5); DataGridViewTextBoxColumn dgvtx6 = new DataGridViewTextBoxColumn(); dgvtx6.Name = "Balance"; grdDetail.Columns.Add(dgvtx6); StockReconcolitationDB sdb = new StockReconcolitationDB(); List <stockreconcolitation> stockList = StockReconcolitationDB.GetStockReconcolitationDetailList(stockitemid); int i = 0; foreach (stockreconcolitation st in stockList) { grdDetail.Rows.Add(); grdDetail.Rows[i].Cells["DocumentDate"].Value = st.DocumentDate.Date.ToString("dd-MM-yyyy"); grdDetail.Rows[i].Cells["DocumentID"].Value = st.DocumentID; grdDetail.Rows[i].Cells["DocumentNo"].Value = st.DocumentNo; grdDetail.Rows[i].Cells["Receipt"].Value = st.Reciept; grdDetail.Rows[i].Cells["Issue"].Value = st.Issue; i++; } } catch (Exception ex) { MessageBox.Show("Error in Stock listing"); } return(grdDetail); }