完整的删除

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、查询全部数据显示
            //创建数据连接类
            SqlConnection conn = new SqlConnection("server=.;database=Data0425;user=sa;pwd=123;");
            //创建数据操作类，并且关联连接类
            SqlCommand cmd = conn.CreateCommand();
            //编写TSQL语句
            cmd.CommandText = "select *from student";

            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    int age = DateTime.Now.Year - Convert.ToDateTime(dr["birthday"]).Year;
                    Console.WriteLine(dr["Code"] + "  " + dr["Name"] + "  " + dr["Score"] + "  " + dr["birthday"] + "  " + age);
                }
            }

            conn.Close();

            //2、删除执行
            Console.Write("请输入要删除的学生编号：");
            string Scode = Console.ReadLine();
            cmd.CommandText = "delete from student where code ='" + Scode + "'";
            conn.Open();
            cmd.ExecuteNonQuery();
            Console.Clear();
            Console.WriteLine("删除成功！");
            conn.Close();

            //3、刷新显示
            cmd.CommandText = "select *from student";

            conn.Open();
            SqlDataReader dr1 = cmd.ExecuteReader();
            if (dr1.HasRows)
            {
                while (dr1.Read())
                {
                    Console.WriteLine(dr1["Code"] + "  " + dr1["Name"] + "  " + dr1["Score"]);
                }
            }

            conn.Close();

            Console.ReadLine();
        }
    }
}