using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; namespace ado修改 { class Program { static void Main(string[] args) { //1、让用户输入要修改的学生编号 Console.Write("请输入要修改的学生编号:"); string Scode = Console.ReadLine(); Console.Write("请输入更改后的学生姓名:"); string Sname = Console.ReadLine(); Console.Write("请输入更改后的学生性别:"); bool Ssex = Convert.ToBoolean(Console.ReadLine()); Console.Write("请输入更改后的学生生日:"); DateTime Sbirthday = Convert.ToDateTime(Console.ReadLine()); Console.Write("请输入更改后的学生成绩:"); decimal Sscore = Convert.ToDecimal(Console.ReadLine()); //2、执行修改 SqlConnection conn = new SqlConnection("server=.;database=Data0425;user=sa;pwd=123;"); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "update student set name='" + Sname + "',sex='" + Ssex + "',birthday='" + Sbirthday + "',score=" + Sscore + " where code = '" + Scode + "'"; conn.Open(); cmd.ExecuteNonQuery(); Console.WriteLine("修改成功!"); conn.Close(); Console.ReadLine(); } } }