C# 数据适配器 SqlDataAdapter 对象使用示例 - 更新数据源

using System;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Text;using System.Threading.Tasks;namespace 数据适配DataAdapter对象{internal class Program{static void Main(string[] args){string sqlserver = "Server=.;user=sa;pwd=sa;database=wjc";SqlConnection mycon = new SqlConnection(sqlserver);try{mycon.Open();string updatesql = "update test set dept='运维部' where name='赵海'";SqlDataAdapter myda = new SqlDataAdapter("select*from wjc", mycon);myda.UpdateCommand = new SqlCommand(updatesql, mycon);DataSet myds = new DataSet();myda.Fill(myds, "test");myda.Update(myds, "test");OutValues(myds);Console.ReadKey();}catch (Exception ex){Console.WriteLine(ex.Message);}finally{mycon.Close();}}public static void OutValues(DataSet ds){foreach (DataTable dt in ds.Tables){Console.WriteLine("表名" + dt.TableName);foreach (DataRow row in dt.Rows){foreach (DataColumn col in dt.Columns){Console.Write(row[col] + "\t");}Console.WriteLine();}}}}