C#DataGridView不用按钮直接增、改并提交数据库

最新推荐文章于 2025-05-23 11:32:33 发布

原创

最新推荐文章于 2025-05-23 11:32:33 发布 · 913 阅读

6 ·

CC 4.0 BY-SA版权

 public partial class Form1 : Form
    {
        private SqlConnection connection()
        {
            string strconn = "Server=.;uid=sa;pwd=密码;database=数据库名";
            SqlConnection conn = new SqlConnection(strconn);
            return conn;
        }

        public Form4()
        {
            InitializeComponent();
        }

        private void Form4_Load(object sender, EventArgs e)
        {
            GetDataGridView();
            //dataGridView1.AutoGenerateColumns = true;  //设置自动创建列，默认为True 
            //dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;  //鼠标单击编辑，默认双击 
            
            //dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically;

        }

        //默认显示所有数据
        private void GetDataGridView()
        {
            try
            {
                SqlConnection conn = connection();
                conn.Open();
                string strda = "select Name,Sex,Numb