怎样一个按钮既实现insert又实现update

Question

dataGridView中的数据，修改之后，直接按一个按钮，就自动的应该update的update，应该insert的insert。有人说用sqlAdapter Update()? 能具体点吗？或者其他方法？

Answer 1

sqlAdapter Update()就是判断的行状态批量操作.using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;using System.Data.SqlClient;namespace InformationTest
{
    public partial class DataGridViewDemo : Form
    {
        public DataGridViewDemo()
        {
            InitializeComponent();
        }        private void btnSave_Click(object sender, EventArgs e)
        {
            DataTable dt = dataGridView1.DataSource as DataTable;
            if (dt != null)
            {
                try
                {
                    using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=test"))
                    {
                        SqlDataAdapter da = new SqlDataAdapter("select * from [DataGridViewDemoTable]", con);
                        SqlCommandBuilder scb = new SqlCommandBuilder(da);
                        DataSet ds = new DataSet();
                        da.Fill(ds, "DataGridViewDemoTable");
                        da.Update(dt);
                    }
                }
                catch (DataException de)
                {
                    con = null;
                }
            }
        }        private void DataGridViewDemo_Load(object sender, EventArgs e)
        {
            using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=test"))
            {
                try
                {
                    SqlDataAdapter da = new SqlDataAdapter("select * from [DataGridViewDemoTable]", con);
                    DataSet ds = new DataSet();
                    da.Fill(ds, "DataGridViewDemoTable");
                    if (ds.Tables.Contains("DataGridViewDemoTable"))
                    {
                        dataGridView1.DataSource = ds.Tables["DataGridViewDemoTable"];
                    }
                }
                catch (DataException de)
                {
                    con = null;
                }
            }
        }
    }
}