winf实验十(1).zip 6.32KB

2401_87960222

资源文件列表:

winf实验十(1).zip 大约有6个文件

winf实验十/
winf实验十/App.txt 632B
winf实验十/Form1.cs 3.47KB
winf实验十/Form1.Designer.cs 11.49KB
winf实验十/Form1.resx 6.3KB
winf实验十/设计.txt 3.47KB

资源介绍:

winf实验十(1).zip

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Data.SqlClient; using System.Configuration; namespace WindowsFormsApplication2 { public partial class Form1 : Form { string conStr = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString; SqlConnection con = null; SqlDataAdapter da = null; DataSet ds = null; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“studentscoreDataSet1.studentscore”中。您可以根据需要移动或删除它。 this.studentscoreTableAdapter.Fill(this.studentscoreDataSet1.studentscore); } private void label3_Click(object sender, EventArgs e) { } private void btnSelect_Click(object sender, EventArgs e) { con = new SqlConnection(conStr); da = new SqlDataAdapter("select * from studentscore", con); ds = new DataSet(); da.Fill(ds, "studentscore"); dgvStudentScore.DataSource = ds.Tables["studentscore"]; } private void btnInsert_Click(object sender, EventArgs e) { SqlCommandBuilder builder = new SqlCommandBuilder(da); DataRow r1 = ds.Tables["studentscore"].NewRow(); r1[0] = txtNum.Text; r1[1] = txtName.Text; r1[2] = txtScore.Text; ds.Tables[0].Rows.Add(r1); da.Update(ds, "studentscore"); dgvStudentScore.DataSource = ds.Tables["studentscore"]; } private void btnUpdate_Click(object sender, EventArgs e) { SqlCommandBuilder builder = new SqlCommandBuilder(da); DataRowCollection rows = ds.Tables["studentscore"].Rows; DataRow row; for (int i = 0; i < rows.Count; i++) { row = rows[i]; if (row["num"].ToString() == txtNum.Text) { row["score"] = txtScore.Text; } } dgvStudentScore.DataSource = ds.Tables["studentscore"]; da.Update(ds, "studentscore"); } private void btnDelete_Click(object sender, EventArgs e) { SqlCommandBuilder builder = new SqlCommandBuilder(da); DataRowCollection rows = ds.Tables["studentscore"].Rows; DataRow row; for (int i = 0; i < rows.Count; i++) { row = rows[i]; if (row["num"].ToString() == txtNum.Text) { row.Delete(); } } da.Update(ds, "studentscore"); dgvStudentScore.DataSource = ds.Tables["studentscore"]; } private void dgvstudentScore_CellContentClick(object sender, DataGridViewCellEventArgs e) { txtNum.Text = dgvStudentScore.CurrentRow.Cells["num"].Value.ToString(); txtName.Text = dgvStudentScore.CurrentRow.Cells["name"].Value.ToString(); txtScore.Text = dgvStudentScore.CurrentRow.Cells["score"].Value.ToString(); } } }

标题	大小	时间
chromedriver-win32-133.0.6899.0.zip	8.34MB	4月前

chromedriver-win32-133.0.6900.0.zip	8.31MB	4月前
2023-7mysql期末复习题.zip	327.19KB	4月前
Ziperello压缩包密码破解	1.25MB	4月前
zj1111111111111111	1003B	4月前

概论课实践教学作业模板（2024）.zip	146.61KB	4月前
Java EE 课程设计 Java web 课程设计数据管理系统.zip	431B	4月前
华中科技大学大学CS课程其它报告.zip	820B	4月前