ado修改

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace ConsoleApplication4
{
    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();
            //编写sql数据命令
            cmd.CommandText = "update student set name='" + sname + "',sex='" + ssex + "',bithday='" + sbirthday + "',score= " + sscore + " where code='" + scode + "'";
            //cmd.CommandText = "update student set name='" + sname + "',sex='" + ssex + "',birthday='" + sbirthday + "',score=" + sscore + " where code = '" + scode + "'";

            Console.WriteLine(cmd.CommandText);
            try
            {
                //开启数据库
                conn.Open();
                //执行操作命令
                cmd.ExecuteNonQuery();
                //显示操作成功
                Console.WriteLine("修改成功！");

            }
            catch
            {
                Console.WriteLine("数据库连接失败！请重新连接！");
            }
            finally
            {
                //关闭数据库
                conn.Close();
                Console.ReadLine();
            }


           
        }
    }
}

转载于:https://www.cnblogs.com/fengsantianya/p/5604596.html