首页下载资源行业研究winf实验十(1).zip

ZIPwinf实验十(1).zip

2401_879602226.32KB需要积分:1

资源文件列表:

winf实验十(1).zip 大约有6个文件
  1. winf实验十/
  2. winf实验十/App.txt 632B
  3. winf实验十/Form1.cs 3.47KB
  4. winf实验十/Form1.Designer.cs 11.49KB
  5. winf实验十/Form1.resx 6.3KB
  6. 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(); } } }
100+评论
captcha

    相关资源

    1. chromedriver-win32-133.0.6899.0.zip

      pbymw8iwm#行业研究ZIP8.34MB2月前
      资源摘要:chromedriver-win32-133.0.6899.0

    2. chromedriver-win32-133.0.6900.0.zip

      pbymw8iwm#行业研究ZIP8.31MB2月前
      资源摘要:chromedriver-win32-133.0.6900.0

    3. 2023-7mysql期末复习题.zip

      2403_85962182#行业研究ZIP327.19KB2月前
      资源摘要:2023-7mysql期末复习题.zip

    4. Ziperello压缩包密码破解

      linsenaa#安全技术ZIP1.25MB2月前
      资源摘要:Ziperello压缩包密码破解

    5. zj1111111111111111

      c15531440023#后端ZIP1003B2月前
      资源摘要:zj1111111111111111

    6. 概论课实践教学作业模板（2024）.zip

      2301_80880449#行业研究ZIP146.61KB2月前
      资源摘要:概论课实践教学作业模板（2024）.zip

    7. Java EE 课程设计 Java web 课程设计 数据管理系统.zip

      Qing__er#行业研究ZIP431B2月前
      资源摘要:课程设计报告

    8. 华中科技大学大学CS课程其它报告.zip

      Qing__er#行业研究ZIP820B2月前
      资源摘要:课程设计报告
    站长QQ:九六九五七三七