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();                }            }        }    }}