/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataGridStochasticAgeTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridStochasticAgeTable.Rows[e.RowIndex].HeaderCell; if (header.Value == null) { if (timeVarying == true) { string[] stochasticAgeTableRowHeaders = this.seqYears; setStochasticAgeTableRowHeaders(stochasticAgeTableRowHeaders, numFleets); } else { if (multiFleetTable == true) { //Pass in one empty string since setStochasticAgeTableRowHeaders sets the header string string[] stochasticAgeTableRowHeaders = { string.Empty }; setStochasticAgeTableRowHeaders(stochasticAgeTableRowHeaders, numFleets); } else { string[] stochasticAgeTableRowHeaders = { "All Years" }; setStochasticAgeTableRowHeaders(stochasticAgeTableRowHeaders, 1); } } } }
public void BeginEdit(DataGridViewRowHeaderCell c) { int ind = c.RowIndex; int Top = D.ColumnHeadersHeight; for (int i = 0; i < ind; i++) { Top += D.Rows[i].Height; } TextBox t = new TextBox(); t.Left = 1; t.Width = D.RowHeadersWidth; t.Top = Top; t.Font = new Font(D.Font.Name, D.Font.Size + 2); t.LostFocus += new EventHandler(EditHeader); t.PreviewKeyDown += new PreviewKeyDownEventHandler(TextBoxKeyDown); t.Tag = c; if (c.Value != null) { t.Text = c.Value.ToString(); } D.Controls.Add(t); t.Focus(); }
private void btnDisplay_Click(object sender, EventArgs e) { if (dtr2.Value.Date > dtr1.Value.Date) { vwGrid.DataSource = Getdt(); try { for (int i = 0; i < vwGridUnpaid.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGrid.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGrid.Rows[i].HeaderCell = cell; } vwGrid.AutoResizeColumns(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("Revise Date Selection..."); } }
static public void AddRowTitle(DataGridView dgv, object HeaderVal) { DataGridViewRowHeaderCell row = new DataGridViewRowHeaderCell(); row.Value = HeaderVal; //dgv.RowHeadersWidth = 15; dgv.Rows.Add(row); }
private void dataGridRecruitProb_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridRecruitProb.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { SetRecruitmentProbRowHeaders(); } }
private void dataGridLv1ObservationTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridLv1ObservationTable.Rows[e.RowIndex].HeaderCell; if (header.Value == null) { SetEmpiricalRowHeadsers(dataGridLv1ObservationTable); } }
private void dataGridLv2ObservationTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = this.dataGridLv2ObservationTable.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { base.SetEmpiricalRowHeadsers(this.dataGridLv2ObservationTable); } }
private void button3_Click(object sender, EventArgs e) { var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient"; string trncateBaleReg = "Truncate Table BaleRegForm"; string idInsertOn = "SET IDENTITY_INSERT BaleRegForm ON"; string idInsertOff = "SET IDENTITY_INSERT BaleRegForm OFF"; string query = "INSERT INTO BaleRegForm (BaleRegFormID, BaleRegFormCode, CreatedDate, BaleRegFormStatus, LocationID, GrowerID)" + "SELECT BaleRegFormID, BaleRegFormCode, CreatedDate, BaleRegFormStatus, LocationID, GrowerID" + " FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.BaleRegForm "; try { int count = 0; // string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'"; var sqlCon = new SqlConnection(conString00); if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); // var sqlcmdTrncate = new SqlCommand(trncateBaleReg, sqlCon); //sqlcmdTrncate.ExecuteNonQuery(); var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon); var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon); var sqlcomquery = new SqlCommand(query, sqlCon); sqlcomidInsertOn.ExecuteNonQuery().ToString(); string result = sqlcomquery.ExecuteNonQuery().ToString(); sqlcomidInsertOff.ExecuteNonQuery().ToString(); sqlCon.Close(); MessageBox.Show(lblBaleRegform.Text + " Records Inserted..."); //reader.Dispose(); sqlCon.Close(); DataTable dt_ = new DataTable(); SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM BaleRegForm order by BaleregformID desc", sqlCon); da_.Fill(dt_); this.vwGridView.DataSource = dt_; vwGridView.Show(); vwGridView.ScrollBars = ScrollBars.Both; da_.Dispose(); for (int i = 0; i < vwGridView.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGridView.Rows[i].HeaderCell = cell; } } } catch (Exception ex) { MessageBox.Show("Error" + ex.Message.ToString()); } finally { } btnBaleRegFormPost.BackColor = Color.Green; }
private void button4_Click(object sender, EventArgs e) { var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient"; string sqlcmdTruncate = "Truncate Table Grower"; string idInsertOn = "SET IDENTITY_INSERT Grower ON"; string idInsertOff = "SET IDENTITY_INSERT Grower OFF"; string query = "INSERT INTO Grower (GrowerID, GrowerName, FatherName, Location, Address, ContactNumber, CNIC, GrowerCode, CaretakerID, Active_Ind, GrowerMaxWeightLimit)" + "SELECT GrowerID, GrowerName, FatherName, Location, Address, ContactNumber, CNIC, GrowerCode, CaretakerID, Active_Ind, GrowerMaxWeightLimit " + "FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.Grower"; try { int count = 0; // string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'"; var sqlCon = new SqlConnection(conString00); if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); // var sqlcmdTruncateGrower = new SqlCommand(sqlcmdTruncate, sqlCon); // sqlcmdTruncateGrower.ExecuteNonQuery(); var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon); var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon); var sqlcomquery = new SqlCommand(query, sqlCon); sqlcomidInsertOn.ExecuteNonQuery().ToString(); string result = sqlcomquery.ExecuteNonQuery().ToString(); sqlcomidInsertOff.ExecuteNonQuery().ToString(); sqlCon.Close(); MessageBox.Show(lblGrower.Text + "Records Inserted...."); //reader.Dispose(); sqlCon.Close(); DataTable dt_ = new DataTable(); SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM Grower order by growerid desc", sqlCon); da_.Fill(dt_); this.vwGridView.DataSource = dt_; vwGridView.Show(); vwGridView.ScrollBars = ScrollBars.Both; da_.Dispose(); for (int i = 0; i < vwGridView.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGridView.Rows[i].HeaderCell = cell; } } } catch (Exception ex) { MessageBox.Show("Error" + ex.Message.ToString()); } finally { } btnPostGrower.BackColor = Color.Green; }
private void countrow() { for (int i = 0; i < dataGridView1.Rows.Count; i++) { DataGridViewRowHeaderCell cell = dataGridView1.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); dataGridView1.Rows[i].HeaderCell = cell; } }
private void dataGridObservations_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = this.dataGridObservations.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { SetRecruitPredictorRowHeaders(this.dataGridObservations); } }
private void button2_Click(object sender, EventArgs e) { var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient"; string truncate_ = "TRUNCATE TABLE BALE"; string idInsertOn = "SET IDENTITY_INSERT BALE ON"; string idInsertOff = "SET IDENTITY_INSERT BALE OFF"; string query = "INSERT INTO BALE (BaleID, Weight, Grade, Subgrade,Rate, GrowerID,Date, LotCode, BaleIDPK, BaleRegistrationFormID,Status,ReclassifiedSubgrade,ReclassifiedRate, ReclassifiedGrade, IsOrphanBale, IsReClassifiedExported)" + "SELECT BaleID, Weight, Grade, Subgrade,Rate, GrowerID, Date, LotCode,BaleIDPK, BaleRegistrationFormID,Status,ReclassifiedSubgrade,ReclassifiedRate, ReclassifiedGrade, IsOrphanBale,IsReClassifiedExported " + "FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.Bale"; try { int count = 0; // string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'"; var sqlCon = new SqlConnection(conString00); if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); //var sqlComTruncate = new SqlCommand(truncate_, sqlCon); //sqlComTruncate.ExecuteNonQuery(); var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon); var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon); var sqlcomquery = new SqlCommand(query, sqlCon); sqlcomidInsertOn.ExecuteNonQuery().ToString(); string result = sqlcomquery.ExecuteNonQuery().ToString(); sqlcomidInsertOff.ExecuteNonQuery().ToString(); sqlCon.Close(); MessageBox.Show(lblBale.Text + " Records Inserted..."); //reader.Dispose(); sqlCon.Close(); DataTable dt_ = new DataTable(); SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM BALE order by baleidPk desc", sqlCon); da_.Fill(dt_); this.vwGridView.DataSource = dt_; vwGridView.Show(); vwGridView.ScrollBars = ScrollBars.Both; da_.Dispose(); for (int i = 0; i < vwGridView.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGridView.Rows[i].HeaderCell = cell; } this.btnBalePost.BackColor = Color.Green; } } catch (Exception ex) { MessageBox.Show("Error" + ex.Message.ToString()); } finally { } }
private void AddRowNumbersToResults(DataGridView dataGridView) { for (int i = 0; i < dataGridView.Rows.Count; i++) { DataGridViewRowHeaderCell cell = dataGridView.Rows[i].HeaderCell; cell.Value = (i + 1).ToString().Trim(); dataGridView.Rows[i].HeaderCell = cell; } dataGridView.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); }
private void dataGridFractionMortality_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridFractionMortality.Rows[e.RowIndex].HeaderCell; if (header.Value == null) { dataGridFractionMortality.Rows[0].HeaderCell.Value = "Fraction F Prior to Spawn"; dataGridFractionMortality.Rows[1].HeaderCell.Value = "Fraction M Prior to Spawn"; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataGridCVTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridCVTable.Rows[e.RowIndex].HeaderCell; //header value is null if (header.Value == null) { setCVTableRowHeaders(); } }
private void button6_Click(object sender, EventArgs e) { var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient"; string sqlTruncateVoucher = "Truncate Table Voucher"; string idInsertOn = "SET IDENTITY_INSERT Voucher ON"; string idInsertOff = "SET IDENTITY_INSERT Voucher OFF"; string query = "INSERT INTO Voucher (VoucherID, Amount, OriginalPrintStatus, DuplicatePrintStatus, VoucherCode, LotID, BaleRegistrationFormID, GrowerID, PaymentDate, IsPrintedPayment, IsPrintedBank, status, IsPrintedMandi, PaymentMode, CancelationReason)" + "SELECT VoucherID, Amount, OriginalPrintStatus, DuplicatePrintStatus, VoucherCode, LotID, BaleRegistrationFormID, GrowerID, PaymentDate, IsPrintedPayment, IsPrintedBank, status, IsPrintedMandi, PaymentMode, CancelationReason FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.Voucher"; try { int count = 0; // string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'"; var sqlCon = new SqlConnection(conString00); if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); // var sqlcmdVoucher = new SqlCommand(sqlTruncateVoucher, sqlCon); // sqlcmdVoucher.ExecuteNonQuery(); var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon); var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon); var sqlcomquery = new SqlCommand(query, sqlCon); sqlcomidInsertOn.ExecuteNonQuery().ToString(); string result = sqlcomquery.ExecuteNonQuery().ToString(); sqlcomidInsertOff.ExecuteNonQuery().ToString(); sqlCon.Close(); MessageBox.Show(lblVoucher.Text + ". Records Inserted...."); //reader.Dispose(); sqlCon.Close(); DataTable dt_ = new DataTable(); SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM voucher", sqlCon); da_.Fill(dt_); this.vwGridView.DataSource = dt_; vwGridView.Show(); vwGridView.ScrollBars = ScrollBars.Both; da_.Dispose(); for (int i = 0; i < vwGridView.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGridView.Rows[i].HeaderCell = cell; } } } catch (Exception ex) { MessageBox.Show("Error" + ex.Message.ToString()); } finally { } btnPostVoucher.BackColor = Color.Green; }
private void btnpostcompany_Click(object sender, EventArgs e) { var conString00 = "Data Source=PATTERN-RECOG\\SQLEXPRESS2019;Initial Catalog=ktptsPayments; Integrated Security=True;User ID=sa;Password=mardan!1 providerName=System.Data.SqlClient providerName=System.Data.SqlClient"; string sqlTruncateVoucher = "Truncate Table Voucher"; string idInsertOn = "SET IDENTITY_INSERT [Company] ON"; string idInsertOff = "SET IDENTITY_INSERT [Company] OFF"; string query = "INSERT INTO [Company] ([CompanyID],[CompanyName],[CompanyCode],[CompanyAddress],[CompanyPhone],[Active_Ind])" + "SELECT [CompanyID],[CompanyName],[CompanyCode],[CompanyAddress],[CompanyPhone],[Active_Ind] FROM [" + this.cmbDatabase.SelectedItem.ToString() + "].dbo.[Company]"; try { int count = 0; // string Qry="exec spPostBale "+"'"+this.cmbDatabase.SelectedItem.ToString()+"'"; var sqlCon = new SqlConnection(conString00); if (sqlCon.State != ConnectionState.Open) { sqlCon.Open(); // var sqlcmdVoucher = new SqlCommand(sqlTruncateVoucher, sqlCon); // sqlcmdVoucher.ExecuteNonQuery(); var sqlcomidInsertOn = new SqlCommand(idInsertOn, sqlCon); var sqlcomidInsertOff = new SqlCommand(idInsertOff, sqlCon); var sqlcomquery = new SqlCommand(query, sqlCon); sqlcomidInsertOn.ExecuteNonQuery().ToString(); string result = sqlcomquery.ExecuteNonQuery().ToString(); sqlcomidInsertOff.ExecuteNonQuery().ToString(); sqlCon.Close(); MessageBox.Show(lblcompany.Text + ". Records Inserted...."); //reader.Dispose(); sqlCon.Close(); DataTable dt_ = new DataTable(); SqlDataAdapter da_ = new SqlDataAdapter("SELECT * FROM [Company]", sqlCon); da_.Fill(dt_); this.vwGridView.DataSource = dt_; vwGridView.Show(); vwGridView.ScrollBars = ScrollBars.Both; da_.Dispose(); for (int i = 0; i < vwGridView.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGridView.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGridView.Rows[i].HeaderCell = cell; } } } catch (Exception ex) { MessageBox.Show("Error" + ex.Message.ToString()); } finally { } btnpostcompany.BackColor = Color.Green; }
private void btnDisplay_Click(object sender, EventArgs e) { vwGrid.DataSource=null; try { //string having = "cast(bg.CreatedDate as Date)='" + dtPurchase.Value.Date.ToShortDateString() + "' OR v.VoucherCode='" + txtvcode.Text.Trim() + "' OR vd.Amount='" + Convert.ToInt32(txtamount.Text.Trim()) + "' OR cast(v.PaymentDate as Date)='" + dtPayment.Value.Date.ToShortDateString() + "'"; string db = cmbDatabase.SelectedItem.ToString(); string prdate = dtPurchase.Value.Date.ToShortDateString(); string pydate = dtPayment.Value.Date.ToShortDateString(); string vcode = txtvcode.Text; if (cmbDatabase.SelectedItem != null) { vwGrid.DataSource = ""; var da_ = new SqlDataAdapter("SELECT " + "SUM(vd.Amount) AS Amount," + "v.VoucherCode," + "g.GrowerName," + "bg.CreatedDate AS PurchaseDate, " + "v.PaymentDate, " + "v.VoucherID, " + "v.GrowerID, " + "g.FatherName, " + "g.CNIC, " + "g.ContactNumber," + "l.LocationName " + " FROM [" + cmbDatabase.SelectedItem + "].dbo.Voucher v INNER JOIN " + " [" + cmbDatabase.SelectedItem + "].dbo.VoucherDetail vd ON v.VoucherID = vd.VoucherId INNER JOIN " + " [" + cmbDatabase.SelectedItem + "].dbo.Grower g ON v.GrowerID = g.GrowerID INNER JOIN " + " [" + cmbDatabase.SelectedItem + "].dbo.Bale b ON b.BaleID = vd.BaleId INNER JOIN " + " [" + cmbDatabase.SelectedItem + "].dbo.BaleRegForm bg ON g.GrowerID = bg.GrowerID AND v.LotID = bg.BaleRegFormCode AND " + " v.BaleRegistrationFormID = bg.BaleRegFormID INNER JOIN " + " [" + cmbDatabase.SelectedItem + "].dbo.Location l ON bg.LocationID = l.LocationID " + " GROUP BY v.PaymentDate, g.ContactNumber, v.GrowerID, g.CNIC, v.VoucherID, v.VoucherCode, g.GrowerName, g.FatherName, bg.CreatedDate, l.LocationName " + " HAVING (CAST(bg.CreatedDate as Date)='"+ dtPurchase.Value.Date.ToShortDateString()+" ' OR v.VoucherCode='" + txtvcode.Text.Trim() + "' OR CAST(v.PaymentDate as Date)='" + dtPayment.Value.Date.ToShortDateString()+ "') ORDER BY v.VoucherID", UniCon); var dt_ = new DataTable(); da_.Fill(dt_); this.vwGrid.DataSource = dt_; vwGrid.Show(); vwGrid.ScrollBars = ScrollBars.Both; da_.Dispose(); for (int i = 0; i < vwGrid.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGrid.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGrid.Rows[i].HeaderCell = cell; } da_.Dispose(); } } catch (Exception ex) { } }
public void DataGridViewRowHeaderCellAccessibleObject_Parent_ReturnsExpected() { using DataGridView control = new(); control.Columns.Add("Column 1", "Header text 1"); DataGridViewRowHeaderCell cell = control.Rows[0].HeaderCell; var accessibleObject = (DataGridViewRowHeaderCellAccessibleObject)cell.AccessibilityObject; Assert.Equal(cell.OwningRow.AccessibilityObject, accessibleObject.Parent); Assert.False(control.IsHandleCreated); }
private void dataGridComboBoxSelectRecruitModels_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridComboBoxSelectRecruitModels.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { for (int i = 0; i < dataGridComboBoxSelectRecruitModels.Rows.Count; i++) { dataGridComboBoxSelectRecruitModels.Rows[i].HeaderCell.Value = "Selection " + (i + 1); } } }
private void dataGridProbabilityTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridProbabilityTable.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { for (int i = 0; i < dataGridProbabilityTable.Rows.Count; i++) { dataGridProbabilityTable.Rows[i].HeaderCell.Value = "SSB Level-" + (i + 1); } } }
private void dataGridSSBTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridSSBTable.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { for (int i = 0; i < dataGridSSBTable.Rows.Count; i++) { dataGridSSBTable.Rows[i].HeaderCell.Value = (i + 1).ToString(); } } }
public void DataGridViewRowHeaderCellAccessibleObject_DoDefaultAction_DoesNothing_IfHandleIsNotCreated(DataGridViewSelectionMode mode) { using DataGridView control = new(); control.SelectionMode = mode; control.Columns.Add("Column 1", "Header text 1"); DataGridViewRowHeaderCell cell = control.Rows[0].HeaderCell; Assert.False(cell.OwningRow.Selected); cell.AccessibilityObject.DoDefaultAction(); Assert.False(cell.OwningRow.Selected); Assert.False(control.IsHandleCreated); }
private void dataGridFixedRecruitment_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridFixedRecruitment.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { if (dataGridFixedRecruitment.Rows.Count > 0) { for (int i = 1; i < seqYears.Count(); i++) { dataGridFixedRecruitment.Rows[i - 1].HeaderCell.Value = seqYears[i]; } } } }
private void dataGridHarvestScenarioTable_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { DataGridViewRowHeaderCell header = dataGridHarvestScenarioTable.Rows[e.RowIndex].HeaderCell; if (!(header.Value != null)) { //set HarvestScenarioTable RowHeaders int iyear = 0; foreach (DataGridViewRow yearRow in dataGridHarvestScenarioTable.Rows) { yearRow.HeaderCell.Value = seqYears[iyear]; iyear++; } } }
public void DataGridViewRowHeaderCellAccessibleObject_DoDefaultAction_WorksExpected(DataGridViewSelectionMode mode, bool expected) { using DataGridView control = new(); control.SelectionMode = mode; control.Columns.Add("Column 1", "Header text 1"); DataGridViewRowHeaderCell cell = control.Rows[0].HeaderCell; control.CreateControl(); Assert.False(cell.OwningRow.Selected); cell.AccessibilityObject.DoDefaultAction(); Assert.Equal(expected, cell.OwningRow.Selected); Assert.True(control.IsHandleCreated); }
private void ShowPaid(string depot_, string prdate_, string pydate_) { DataTable dt_ = new DataTable(); try { var da_ = new SqlDataAdapter("SELECT " + "Depot, PurchaseDate, " + "PaymentDate, VCount, " + "Amount, Amount_Paid, " + "DatePaid, Status, Remarks " + " FROM vwPaid001 " + " WHERE (cast(PurchaseDate as datetime) = '" + Convert.ToDateTime(prdate_) + "' OR (cast(PaymentDate as datetime) = '" + Convert.ToDateTime(pydate_) + "' )) AND Depot = '" + depot_ + "'", new SqlConnection(UniCon)); da_.Fill(dt_); vwGridPaid.DataSource = dt_; for (int i = 0; i < vwGridPaid.Rows.Count; i++) { DataGridViewRowHeaderCell cell = vwGridPaid.Rows[i].HeaderCell; cell.Value = (i + 1).ToString(); vwGridPaid.Rows[i].HeaderCell = cell; } int sumPaid = 0; int sumPaidBy = 0; int sumVcount = 0; foreach (DataRow row_ in dt_.Rows) { sumPaid += Convert.ToInt32(row_["Amount"]); sumPaidBy += Convert.ToInt32(row_["Amount_Paid"]); sumVcount += Convert.ToInt32(row_["VCount"]); } txtAmountP.Text = sumPaid.ToString(); txtAmountPaidP.Text = sumPaidBy.ToString(); txtNoVp.Text = sumVcount.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ShowPLSGrid(List <PLS1Result> clst) { this.gridPLS.Rows.Clear(); this.gridId.Visible = false; this.gridFit.Visible = false; this.gridPLS.Visible = true; this.gridItg.Visible = false; int k = 1; foreach (var c in clst) { try { var factor = c.Factor - 1; var cell = new DataGridViewRowHeaderCell() { Value = k.ToString(), }; var row = new DataGridViewRow() { HeaderCell = cell }; row.CreateCells(this.gridPLS, c.Comp.Name, c.MahDist[factor].ToString("F4"), c.MDMin.ToString("F4"), c.SR[factor].ToString("f4"), c.SRMin.ToString("F4"), c.ND[factor].ToString("F4"), c.NDMin.ToString("F4") ); this.gridPLS.Rows.Add(row); k++; } catch { } } }
private void ShowfitGrid(FittingResult result) { this.gridFit.Rows.Clear(); this.gridId.Visible = false; this.gridPLS.Visible = false; this.gridFit.Visible = true; this.gridItg.Visible = false; if (result == null || result.Specs.Length == 0) { return; } int k = 1; foreach (var item in result.Specs) { var cell = new DataGridViewRowHeaderCell() { Value = k.ToString() }; var row = new MyDataFitRow() { Item = item, HeaderCell = cell }; if (k == 1) { row.CreateCells(this.gridFit, item.Spec.UUID, item.Rate.ToString("F4"), result.TQ.ToString("F4"), result.SQ.ToString("F4")); } else { row.CreateCells(this.gridFit, item.Spec.UUID, item.Rate.ToString("F4")); } this.gridFit.Rows.Add(row); k++; } }
private void ShowIdGrid(IdentifyResult result, int num, int numOfId) { this.gridId.Rows.Clear(); this.gridId.Visible = true; this.gridFit.Visible = false; this.gridPLS.Visible = false; this.gridItg.Visible = false; if (result == null || result.Items.Length == 0) { return; } result = IdentifyModel.GetPredictValue(result, num, numOfId); int k = 1; foreach (var r in result.Items) { if (k > num) { break; } var cell = new DataGridViewRowHeaderCell() { Value = k.ToString() }; var row = new MyDataIdRow() { Item = r, HeaderCell = cell }; row.CreateCells(this.gridId, r.Spec.UUID, r.TQ.ToString("F4"), r.SQ.ToString("F4"), r.Result); this.gridId.Rows.Add(row); k++; } }