📄 f7修3.cs
字号:
//
// label4
//
this.label4.Location = new System.Drawing.Point(360, 24);
this.label4.Name = "label4";
this.label4.TabIndex = 3;
this.label4.Text = "课程名";
//
// label5
//
this.label5.Location = new System.Drawing.Point(488, 24);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(112, 23);
this.label5.TabIndex = 4;
this.label5.Text = "成绩";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(0, 64);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 5;
this.textBox1.Text = "";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(120, 64);
this.textBox2.Name = "textBox2";
this.textBox2.TabIndex = 6;
this.textBox2.Text = "";
this.textBox2.TextChanged += new System.EventHandler(this.textBox2_TextChanged);
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(240, 64);
this.textBox3.Name = "textBox3";
this.textBox3.TabIndex = 7;
this.textBox3.Text = "";
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(360, 64);
this.textBox4.Name = "textBox4";
this.textBox4.TabIndex = 8;
this.textBox4.Text = "";
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(488, 64);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(112, 21);
this.textBox5.TabIndex = 9;
this.textBox5.Text = "";
//
// button1
//
this.button1.Location = new System.Drawing.Point(656, 64);
this.button1.Name = "button1";
this.button1.TabIndex = 10;
this.button1.Text = "修改";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8, 96);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(592, 152);
this.dataGrid1.TabIndex = 11;
//
// button2
//
this.button2.Location = new System.Drawing.Point(656, 112);
this.button2.Name = "button2";
this.button2.TabIndex = 12;
this.button2.Text = "刷新";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// label6
//
this.label6.ForeColor = System.Drawing.SystemColors.HotTrack;
this.label6.Location = new System.Drawing.Point(104, 72);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(8, 8);
this.label6.TabIndex = 13;
this.label6.Text = "*";
//
// label7
//
this.label7.ForeColor = System.Drawing.SystemColors.HotTrack;
this.label7.Location = new System.Drawing.Point(224, 72);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(8, 8);
this.label7.TabIndex = 14;
this.label7.Text = "*";
//
// label8
//
this.label8.ForeColor = System.Drawing.SystemColors.HotTrack;
this.label8.Location = new System.Drawing.Point(344, 72);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(8, 8);
this.label8.TabIndex = 15;
this.label8.Text = "*";
//
// Form7
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackgroundImage = ((System.Drawing.Bitmap)(resources.GetObject("$this.BackgroundImage")));
this.ClientSize = new System.Drawing.Size(742, 473);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.label8,
this.label7,
this.label6,
this.button2,
this.dataGrid1,
this.button1,
this.textBox5,
this.textBox4,
this.textBox3,
this.textBox2,
this.textBox1,
this.label5,
this.label4,
this.label3,
this.label2,
this.label1});
this.MaximizeBox = false;
this.Menu = this.mainMenu1;
this.Name = "Form7";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "修改课程表";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void menuItem24_Click(object sender, System.EventArgs e)
{
Application.Exit();
}
private void menuItem23_Click(object sender, System.EventArgs e)
{
MessageBox.Show(" 数据库课程设计\r -------教学管理系统\r\r小组成员：金铎，汪欣，齐肖西，李莎，王丽芳");
}
private void menuItem22_Click(object sender, System.EventArgs e)
{
MessageBox.Show("暂无帮助信息！");
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form2=new Form2();
form2.ShowDialog ();
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form3=new Form3();
form3.ShowDialog ();
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form4=new Form4();
form4.ShowDialog ();
}
private void menuItem6_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form5=new Form5();
form5.ShowDialog ();
}
private void menuItem7_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form6=new Form6();
form6.ShowDialog ();
}
private void menuItem8_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form7=new Form7();
form7.ShowDialog ();
}
private void menuItem10_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form8=new Form8();
form8.ShowDialog ();
}
private void menuItem11_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form9=new Form9();
form9.ShowDialog ();
}
private void menuItem12_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form10=new Form10();
form10.ShowDialog ();
}
private void menuItem13_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form11=new Form11();
form11.ShowDialog ();
}
private void menuItem15_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form12=new Form12();
form12.ShowDialog ();
}
private void menuItem16_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form13=new Form13();
form13.ShowDialog ();
}
private void menuItem18_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form14=new Form14();
form14.ShowDialog ();
}
private void menuItem19_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form15=new Form15();
form15.ShowDialog ();
}
private void menuItem20_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form16=new Form16();
form16.ShowDialog ();
}
private void menuItem21_Click(object sender, System.EventArgs e)
{
this.Hide();
Form form17=new Form17();
form17.ShowDialog ();
}
private void button1_Click(object sender, System.EventArgs e)
{
string c_sno;
int c_cgrade;
string c_tno,c_cno,c_cname;
// t_tage =int.Parse(textBox1.Text);
c_sno =textBox1.Text;
c_cno = textBox2.Text;
c_cgrade =int.Parse(textBox5.Text);
c_tno=textBox3.Text;
c_cname=textBox4.Text;
MessageBox.Show("\t学号: "+c_sno+"\t课号: "+c_cno+"\t教师编号： "+c_tno+"\t课程名: "+c_cname+"\t成绩: "+c_cname);
SqlConnection connection = new SqlConnection("workstation id=S0353;packet size=4096;integrated security=SSPI;data source=S0353;persist security info=False;initial catalog=TSC");
try
{
connection.Open();
SqlCommand command = new SqlCommand("update C set Sno='"+c_sno+"',Cno='"+c_cno+"',Tno='"+c_tno+"',Cname='"+c_cname+"',Cgrade='"+c_cgrade+"'where Sno='"+c_sno+"' and Cno='"+c_cno+"' and Tno='"+c_tno+"'",connection);
command.ExecuteNonQuery();
MessageBox.Show("修改成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
string constr= "workstation id=S0353;packet size=4096;integrated security=SSPI;data source=S0353;pe" +
"rsist security info=False;initial catalog=TSC";
string sq1="select * from C where (Sno='"+textBox1.Text+"')";
SqlConnection cn1=new SqlConnection(constr);
SqlDataAdapter sqlDataAdapter1=new SqlDataAdapter(sq1,cn1);
DataSet dt1=new DataSet();
sqlDataAdapter1.Fill(dt1,"C");
dataGrid1.SetDataBinding(dt1,"C");
}
private void textBox2_TextChanged(object sender, System.EventArgs e)
{
}
private void button2_Click(object sender, System.EventArgs e)
{
string constr= "workstation id=S0353;packet size=4096;integrated security=SSPI;data source=S0353;pe" +
"rsist security info=False;initial catalog=TSC";
string sq1="select * from C";
SqlConnection cn1=new SqlConnection(constr);
SqlDataAdapter sqlDataAdapter1=new SqlDataAdapter(sq1,cn1);
DataSet dt1=new DataSet();
sqlDataAdapter1.Fill(dt1,"C");
dataGrid1.SetDataBinding(dt1,"C");
//sqlDataAdapter1.Fill(dataSet11,"T");
//dataGrid1.SetDataBinding(dataSet11,"T");
dataGrid1.Update ();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -