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);
}
}
