Question

C#中怎么更新一个数据源

Answer 1

用代码来阐释：

        public static SqlConnection conn = null;
        public DataSet ds = null;
        public SqlDataAdapter sda = null; 
        //连接数据库
                public void Openlink(String ser, String uid, String pwd, String data)
        {
            conn = new SqlConnection();
            conn.ConnectionString = "Server=" + ser + ";uid=" + uid + ";pwd=" + pwd + ";database=" + data;
            try
            {
                conn.Open();
            }
            catch
            {
                conn.Close();
            }
        }
        //操作查询数据库
                public void linkSQL(String sql)
        {
            if (conn != null)
            {
                ds = new DataSet();
                sda = new SqlDataAdapter();
                sda.SelectCommand = new SqlCommand(sql, conn);
                SqlCommandBuilder builder = new SqlCommandBuilder(sda);
                sda.Fill(ds);
            }
        }
        //更新数据源
                public void saveTable()
        {
            if (ds != null)
            {
                sda.Update(ds.Tables[0]);
                MessageBox.Show("Success！", "Sava Data", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

你的SqlDataAdapter是怎么连接的呢？确定他是这么设置的吗

Answer 2

string connectionString = global:: 程序名.Properties.Settings.Default. 连接字符串名; 输入global及双冒号后，会自动提示余下的选择。