static void Main(string[] args)
        {
            using (SqlConnection con = new SqlConnection())
            {
                con.ConnectionString = "Data Source=.;Initial Catalog=北风贸易;Integrated Security=True";

                con.Open();
                SqlCommand cmd = con.CreateCommand();

                StringBuilder sb = new StringBuilder();
                sb.Append("select * from  学生 ");
                cmd.CommandText = sb.ToString();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds, "学生");
                da.SelectCommand.CommandText = sb.ToString();

                DataTable dtEdit = ds.Tables[0];

                DataRow dREdit = dtEdit.Rows[0];

                dREdit.BeginEdit();
                dREdit["姓名"] = "修改后的姓名";
                dREdit["身份证"] = "修改后的身份证";
                dREdit.EndEdit();
                dREdit.AcceptChanges();
                dtEdit.AcceptChanges();
                ds.AcceptChanges();

            }
        }