01，01店手機網

01，01店手機網

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

namespace 練習2
{
    class Program
    {
        static void Main(string[] args)
        {
            string str = @"data source=C:\Users\Administrator\Desktop\math.db";
            using(SQLiteConnection con=new SQLiteConnection (str))
            {
                con.Open();
                using(SQLiteCommand cmd=new SQLiteCommand ())
                {
                    cmd.CommandText = "insert into Student values('李四','Steve jobs')";
                    cmd.Connection = con;
                    int i = cmd.ExecuteNonQuery();
                    if(i>0)
                    {
                        Console.WriteLine("成功");
                    }
                    else
                    {
                        Console.WriteLine("失敗");
                    }
                    Console.ReadKey();
                }
            }



            //刪除
            string str2 = @"data source=C:\Users\Administrator\Desktop\math.db";
            using(SQLiteConnection con=new SQLiteConnection (str2))
            {
                con.Open();
                string delStr = "delete from Student where ID='01'";
                using(SQLiteCommand cmd=new SQLiteCommand (delStr,con))
                {
                    int i = cmd.ExecuteNonQuery();
                    if(i>0)
                    {
                        Console.WriteLine("成功");
                        
                    }
                    else
                    {
                        Console.WriteLine("失敗");
                    }
                    Console.ReadKey();
                }
            }
        }
    }
}