- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Windows.Forms;
- using System.Collections;
- using System.Data.SqlClient;
- namespace Quanxian
- {
- public partial class Form2 : Form
- {
- public Form2()
- {
- InitializeComponent();
- }
- private int job_id;
- private string job_desc;
- private int min_lvl;
- private int max_lvl;
- private void Form2_Load(object sender, EventArgs e)
- {
- binddatagridview();
- }
- /// <summary>
- /// 绑定Datagridview的方法
- /// </summary>
- private void binddatagridview()
- {
- SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");
- SqlDataAdapter sqldap = new SqlDataAdapter("select * from jobs", sqlcon);
- DataSet ds = new DataSet();
- sqldap.Fill(ds);
- this.dataGridView1.DataSource = ds.Tables[0];
- }
- /// <summary>
- /// 编辑单元格后触发
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
- {
- if (dataGridView1.Rows.Count > 0)
- {
- job_id = int.Parse (this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
- job_desc = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
- min_lvl = int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());
- max_lvl = int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
- }
- }
- /// <summary>
- /// 修改
- /// </summary>
- private void button1_Click(object sender, EventArgs e)
- {
- SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");
- string str = "update jobs set job_desc='" + job_desc + "',min_lvl=" + min_lvl + ",max_lvl=" + max_lvl + " where job_id=" + job_id + "";
- SqlCommand sqlcom = new SqlCommand(str,sqlcon);
- try
- {
- sqlcon.Open();
- if (sqlcom.ExecuteNonQuery() > 0)
- MessageBox.Show("保存成功");
- else
- MessageBox.Show("保存失败!");
- }
- catch
- {
- //异常
- }
- finally
- { sqlcon.Close();}
- }
- /// <summary>
- /// 刷新
- /// </summary>
- private void button2_Click(object sender, EventArgs e)
- {
- binddatagridview();
- }
- }
- }
直接修改Datagridview并保存到数据库
最新推荐文章于 2019-02-20 10:18:08 发布