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