static void Main(string[] args)
{
string s="initial catalog=fucai;data source=.;integrated security=true";
SqlConnection thisConnection =new SqlConnection(s);
thisConnection.Open();
SqlDataAdapter thisDataAdapter =new SqlDataAdapter("select id,name from member",thisConnection);
SqlCommandBuilder thisCommandBuilder =new SqlCommandBuilder(thisDataAdapter);
DataSet thisDataSet =new DataSet();
thisDataAdapter.Fill(thisDataSet,"member");
thisDataSet.Tables["member"].Rows[0]["name"]="王鹏11";
thisDataAdapter.Update(thisDataSet,"member");(在这一步出现错误说无法生成动态SQL语句)
thisConnection.Close();
}