private void dataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { if (sortAscending) { DataGridView1.Sort(DataGridView1.Columns[e.ColumnIndex], System.ComponentModel.ListSortDirection.Ascending); } else { DataGridView1.Sort(DataGridView1.Columns[e.ColumnIndex], System.ComponentModel.ListSortDirection.Descending); } sortAscending = !sortAscending; }
private void ResortDataGridView() { if (DataGridView1.SortOrder != SortOrder.None && DataGridView1.SortedColumn != null) { System.ComponentModel.ListSortDirection Direction = System.ComponentModel.ListSortDirection.Ascending; if (DataGridView1.SortOrder == SortOrder.Descending) { Direction = System.ComponentModel.ListSortDirection.Descending; } DataGridView1.Sort(DataGridView1.SortedColumn, Direction); } }
private void btnParseTextFiles_Click(object sender, EventArgs e) { using (TextFieldParser myReader = new TextFieldParser("test.txt")) { // 定义三种格式之各栏的宽度与分隔字符。 int[] FirstFormat = { 5, 10, -1 }; int[] SecondFormat = { 6, 10, 17, -1 }; string[] ThirdFormat = { "," }; this.DataGridView1.Rows.Clear(); this.DataGridView2.Rows.Clear(); this.DataGridView3.Rows.Clear(); string[] CurrentRow; while (!myReader.EndOfData) { try { string RowType = myReader.PeekChars(2); switch (RowType) { case "CK": myReader.TextFieldType = FieldType.FixedWidth; myReader.FieldWidths = FirstFormat; // 或是 myReader.SetFieldWidths(FirstFormat); CurrentRow = myReader.ReadFields(); this.DataGridView1.Rows.Add(CurrentRow); break; case "PB": myReader.TextFieldType = FieldType.FixedWidth; myReader.FieldWidths = SecondFormat; // 或是 myReader.SetFieldWidths(SecondFormat); CurrentRow = myReader.ReadFields(); this.DataGridView2.Rows.Add(CurrentRow); break; case "SP": myReader.TextFieldType = FieldType.Delimited; myReader.Delimiters = ThirdFormat; // 或是 myReader.SetDelimiters(ThirdFormat); CurrentRow = myReader.ReadFields(); this.DataGridView3.Rows.Add(CurrentRow); break; } } catch (MalformedLineException ex) { MessageBox.Show("行 " + ex.Message + " 是无效的。略过。"); } } // 排序各个 DataGridView 控件的内容。 DataGridView1.Sort(DataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending); DataGridView2.Sort(DataGridView2.Columns[0], System.ComponentModel.ListSortDirection.Ascending); DataGridView3.Sort(DataGridView3.Columns[0], System.ComponentModel.ListSortDirection.Ascending); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\StockManagement.mdf;Integrated Security=True"); if (comboBox1.Text.Length > 0) { SqlDataAdapter sda = new SqlDataAdapter("SELECT Code,Item,Publisher,DateOfPurchase,PurchaseQty,InvNo,StudentName,DateOfSale,SaleQty,[Balance Stock],NUM FROM [dbo].[ItemWiseRep] WHERE Code LIKE '" + comboBox1.Text + "'", con); System.Data.DataTable data = new System.Data.DataTable(); sda.Fill(data); DataGridView1.DataSource = data; DataGridView1.Sort(DataGridView1.Columns[10], ListSortDirection.Ascending); DataGridView1.Columns["NUM"].Visible = false; } }
public void ConfigureGridControl() { dataSet1.Tables.Clear(); moTable = dataSet1.Tables.Add("BarData"); moTable.Columns.Add("Index", typeof(int)); moTable.Columns.Add("TradeDate", typeof(DateTime)); moTable.Columns.Add("Time", typeof(DateTime)); moTable.Columns.Add("Open", typeof(double)); moTable.Columns.Add("High", typeof(double)); moTable.Columns.Add("Low", typeof(double)); moTable.Columns.Add("Close", typeof(double)); moTable.Columns.Add("Volume", typeof(int)); DataGridView1.DataSource = moTable; DataGridView1.AutoResizeColumns(); DataGridView1.Sort(DataGridView1.Columns["Time"], System.ComponentModel.ListSortDirection.Descending); }
private void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\StockManagement.mdf;Integrated Security=True"); SqlDataAdapter sda = new SqlDataAdapter("SELECT Code,Item,Publisher,DateOfPurchase,PurchaseQty,InvNo,StudentName,DateOfSale,SaleQty,[Balance Stock],DateSort FROM [dbo].[ItemWiseRep];", con); System.Data.DataTable dt = new System.Data.DataTable(); sda.Fill(dt); DataGridView1.DataSource = dt; con.Close(); sda.Dispose(); DataGridView1.Sort(DataGridView1.Columns[10], ListSortDirection.Descending); // DataGridView1.Sort(DataGridView1.Columns[11], ListSortDirection.Ascending); DataGridView1.Columns["DateSort"].Visible = false; //DataGridView1.Columns["NUM"].Visible = false; comboBox1.Text = " "; }
private void GameList_Load(object sender, EventArgs e1) { Icon = Properties.Resources.Icon_256; MainForm.Games.SaveCurrentSettings(MainForm.thisForm); if (MainForm.Games.GameList.Count > 0) { foreach (GameSettings e in MainForm.Games.GameList.Values) { int NewRowIndex = DataGridView1.Rows.Add(e.Name, "Load", "Remove"); if (e.Name == mainForm.Label6.Text) // currently open save { DataGridViewButtonCell CellBtn = new DataGridViewButtonCell(); CellBtn.Value = "Current"; DataGridView1[1, NewRowIndex] = CellBtn; } DataGridView1.Rows[NewRowIndex].Selected = false; } DataGridView1.Sort(DataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending); } }