?? class.cs
字號:
//
this.btnCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnCancel.Image")));
this.btnCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.btnCancel.Location = new System.Drawing.Point(216, 24);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(56, 24);
this.btnCancel.TabIndex = 101;
this.btnCancel.Text = "取消";
this.btnCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click_1);
//
// dataGrid1
//
this.dataGrid1.AlternatingBackColor = System.Drawing.Color.GhostWhite;
this.dataGrid1.BackColor = System.Drawing.Color.GhostWhite;
this.dataGrid1.BackgroundColor = System.Drawing.Color.Lavender;
this.dataGrid1.CaptionBackColor = System.Drawing.Color.RoyalBlue;
this.dataGrid1.CaptionForeColor = System.Drawing.Color.White;
this.dataGrid1.DataMember = "";
this.dataGrid1.FlatMode = true;
this.dataGrid1.Font = new System.Drawing.Font("Tahoma", 8F);
this.dataGrid1.ForeColor = System.Drawing.Color.MidnightBlue;
this.dataGrid1.GridLineColor = System.Drawing.Color.RoyalBlue;
this.dataGrid1.HeaderBackColor = System.Drawing.Color.MidnightBlue;
this.dataGrid1.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
this.dataGrid1.HeaderForeColor = System.Drawing.Color.Lavender;
this.dataGrid1.LinkColor = System.Drawing.Color.Teal;
this.dataGrid1.Location = new System.Drawing.Point(24, 208);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ParentRowsBackColor = System.Drawing.Color.Lavender;
this.dataGrid1.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
this.dataGrid1.ReadOnly = true;
this.dataGrid1.SelectionBackColor = System.Drawing.Color.Teal;
this.dataGrid1.SelectionForeColor = System.Drawing.Color.PaleGreen;
this.dataGrid1.Size = new System.Drawing.Size(440, 240);
this.dataGrid1.TabIndex = 2;
this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
this.dataGridTableStyle1});
//
// dataGridTableStyle1
//
this.dataGridTableStyle1.DataGrid = this.dataGrid1;
this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
this.dataGridTextBoxColumn1,
this.dataGridTextBoxColumn2,
this.dataGridTextBoxColumn3,
this.dataGridTextBoxColumn4});
this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGridTableStyle1.MappingName = "Class";
//
// dataGridTextBoxColumn1
//
this.dataGridTextBoxColumn1.Format = "";
this.dataGridTextBoxColumn1.FormatInfo = null;
this.dataGridTextBoxColumn1.HeaderText = "班級代碼";
this.dataGridTextBoxColumn1.MappingName = "ClassID";
this.dataGridTextBoxColumn1.Width = 75;
//
// dataGridTextBoxColumn2
//
this.dataGridTextBoxColumn2.Format = "";
this.dataGridTextBoxColumn2.FormatInfo = null;
this.dataGridTextBoxColumn2.HeaderText = "班級名稱";
this.dataGridTextBoxColumn2.MappingName = "ClassName";
this.dataGridTextBoxColumn2.Width = 120;
//
// dataGridTextBoxColumn3
//
this.dataGridTextBoxColumn3.Format = "";
this.dataGridTextBoxColumn3.FormatInfo = null;
this.dataGridTextBoxColumn3.HeaderText = "所屬院系";
this.dataGridTextBoxColumn3.MappingName = "DepartmentName";
this.dataGridTextBoxColumn3.Width = 150;
//
// dataGridTextBoxColumn4
//
this.dataGridTextBoxColumn4.Format = "";
this.dataGridTextBoxColumn4.FormatInfo = null;
this.dataGridTextBoxColumn4.HeaderText = "學生人數";
this.dataGridTextBoxColumn4.MappingName = "StudentNumber";
this.dataGridTextBoxColumn4.Width = 75;
//
// CancelAll
//
this.CancelAll.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.CancelAll.Image = ((System.Drawing.Image)(resources.GetObject("CancelAll.Image")));
this.CancelAll.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.CancelAll.Location = new System.Drawing.Point(272, 24);
this.CancelAll.Name = "CancelAll";
this.CancelAll.Size = new System.Drawing.Size(64, 24);
this.CancelAll.TabIndex = 107;
this.CancelAll.Text = "取消所有";
this.CancelAll.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.CancelAll.Click += new System.EventHandler(this.CancelAll_Click);
//
// Class
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(528, 477);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.dataGrid1);
this.Name = "Class";
this.Text = "Class";
this.Load += new System.EventHandler(this.Class_Load);
this.groupBox2.ResumeLayout(false);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void btnExit_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void Class_Load(object sender, System.EventArgs e)
{
try
{
this.conn1.Open();
this.sqlDataAdapter1.Fill(this.DataSetDep,"Class");
this.DataSet_Bingding();
this.Buttons_Control(false);
this.Combo_Fill();
}
catch(Exception E)
{
MessageBox.Show(E.ToString());
}
finally
{
this.conn1.Close();
}
}
private void DataSet_Bingding()
{
this.dataGrid1.DataSource=this.DataSetDep;
this.dataGrid1.DataMember="Class";
this.textClaID.DataBindings.Add("Text",this.DataSetDep,"Class.ClassID");
this.textClaName.DataBindings.Add("Text",this.DataSetDep,"Class.ClassName");
this.comboDep.DataBindings.Add("Text",this.DataSetDep,"Class.DepartmentName");
this.textStuNum.DataBindings.Add("Text",this.DataSetDep,"Class.StudentNumber");
}
private void btnAdd_Click(object sender, System.EventArgs e)
{
this.Buttons_Control(true);
this.BindingContext[this.DataSetDep,"Class"].AddNew();
}
public void ErrorHandle(System.Exception E)
{
MessageBox.Show(E.ToString());
}
private void Buttons_Control(bool IsValid)
{
if(IsValid)
{
this.btnCancel.Enabled=true;
this.btnApply.Enabled=true;
this.textClaID.Enabled=true;
this.textClaName.Enabled=true;
this.comboDep.Enabled=true;
this.textStuNum.Enabled=true;
}
else
{
this.btnCancel.Enabled=false;
this.btnApply.Enabled=false;
this.textClaID.Enabled=false;
this.textClaName.Enabled=false;
this.comboDep.Enabled=false;
this.textStuNum.Enabled=false;
}
}
private void btnCancel_Click_1(object sender, System.EventArgs e)
{
try
{
this.BindingContext[this.DataSetDep,"Class"].CancelCurrentEdit();
}
catch(System.Exception E)
{
this.ErrorHandle(E);
}
this.Buttons_Control(false);
}
private void btnApply_Click(object sender, System.EventArgs e)
{
try
{
this.BindingContext[this.DataSetDep,"Class"].EndCurrentEdit();
if(this.conn1.State==ConnectionState.Closed)
this.conn1.Open();
SqlCommandBuilder commandbuilder1=new SqlCommandBuilder(this.sqlDataAdapter1);
this.sqlDataAdapter1.Update(this.DataSetDep,"Class");
this.DataSetDep.AcceptChanges();
this.dataGrid1.Refresh();
}
catch(Exception E)
{
this.ErrorHandle(E);
}
finally
{
this.conn1.Close();
this.Buttons_Control(false);
}
}
private void btnDelete_Click(object sender, System.EventArgs e)
{
if((this.BindingContext[this.DataSetDep,"Class"].Count>0)&
(MessageBox.Show("真的要刪除此記錄嗎","確定刪除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question).Equals(DialogResult.OK)))
{
int position=this.BindingContext[this.DataSetDep,"Class"].Position;
this.BindingContext[this.DataSetDep,"Class"].RemoveAt(position);
}
else
return;
}
private void btnModify_Click(object sender, System.EventArgs e)
{
this.Buttons_Control(true);
}
private void Combo_Fill()
{
try
{
if(this.conn1.State==ConnectionState.Closed)this.conn1.Open();
this.commandStr="select DepartmentName from Department";
this.Command1.CommandText=this.commandStr;
this.DataReader1=this.Command1.ExecuteReader();
while(this.DataReader1.Read())
{
this.comboDep.Items.Add(this.DataReader1["DepartmentName"].ToString());
}
this.conn1.Close();
}
catch(Exception E)
{
MessageBox.Show(E.ToString());
}
finally
{
this.conn1.Close();
}
}
private void CancelAll_Click(object sender, System.EventArgs e)
{
try
{
this.DataSetDep.RejectChanges();
}
catch(System.Exception E)
{
this.ErrorHandle(E);
}
this.Buttons_Control(false);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -