ado.net(增刪改)

標籤：

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication1{    class Program4    {        static void Main4(string[] args)        {            //使用者輸入要刪除的資料主索引值            Console.WriteLine("請輸入要刪除的代號：");            string code = Console.ReadLine();            //判斷該資料存不存在            SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123");            SqlCommand cmd = conn.CreateCommand();            cmd.CommandText = "select * from Info where Code=‘"+code+"‘";            conn.Open();            SqlDataReader dr = cmd.ExecuteReader();                        if (dr.HasRows)            {                //說明該資料存在                Console.WriteLine("查到該資料，是否要執行刪除操作，如果要刪除請輸入：1");                int sc = Convert.ToInt32(Console.ReadLine());                if (sc == 1)                {                    //刪除                    dr.Close(); //關閉讀取器                    cmd.CommandText = "delete from Info where Code=‘"+code+"‘";                    cmd.ExecuteNonQuery();                    Console.WriteLine("刪除成功！");                                    }                else                {                    //不刪除                    dr.Read();                    string sex = Convert.ToBoolean(dr[2])?"男":"女";                    string nation = MinZu(dr[3].ToString());                    string str = "代號："+dr[0]+"\t姓名："+dr[1]+"\t性別："+sex+"\t民族："+nation+"\t生日："+dr[4];                    Console.WriteLine(str);                }            }            else            {                //資料不存在                Console.WriteLine("輸入的代號錯誤！");            }            conn.Close();            Console.ReadLine();        }        static string MinZu(string code)        {            string name="";            SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123");            SqlCommand cmd = conn.CreateCommand();            cmd.CommandText = "select Name from Nation where Code = ‘" + code + "‘";            conn.Open();            SqlDataReader dr = cmd.ExecuteReader();            if (dr.HasRows)            {                dr.Read();                name = dr[0].ToString();            }            conn.Close();            return name;        }    }}

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication1{    class Program3    {        static void Main3(string[] args)        {            //讓使用者輸入要添加的內容            Console.WriteLine("請輸入要添加的代號：");            string code = Console.ReadLine();            Console.WriteLine("請輸入姓名：");            string name = Console.ReadLine();            Console.WriteLine("請輸入性別：");            bool sex = Console.ReadLine()=="男"?true:false;            Console.WriteLine("請輸入民族：");            string nation = Console.ReadLine();            Console.WriteLine("請輸入生日：");            string birthday = Console.ReadLine();            string nationcode = "n001";            //將民族名稱轉為名族代號            SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123");            SqlCommand cmd = conn.CreateCommand();            cmd.CommandText = "select Code from Nation where Name = ‘"+nation+"‘";            conn.Open();            SqlDataReader dr = cmd.ExecuteReader();            if (dr.HasRows)            {                dr.Read();                nationcode = dr[0].ToString();            }            conn.Close();            //往Info表添加資料            cmd.CommandText = "insert into Info values(‘"+code+"‘,‘"+name+"‘,‘"+sex+"‘,‘"+nationcode+"‘,‘"+birthday+"‘)";            conn.Open();            cmd.ExecuteNonQuery();            conn.Close();            Console.WriteLine("添加成功！");            Console.ReadLine();        }    }}

 

ado.net(增刪改)