01

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