private void ExecuteFiles(string filename) { string[] sqls = this.ReadSqls(filename); MessageBox.Show("获取了" + sqls.Length + "条语句!"); int i = SqliteDbFactory.GetSqliteDbOperator().BatchExecute(sqls); MessageBox.Show("成功执行了" + i + "条语句!"); }
private void button6_Click(object sender, EventArgs e) { int i = SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery("delete from dept where deptid=1"); if (i > 0) { MessageBox.Show("修改数据成功!" + i); } }
private void button5_Click(object sender, EventArgs e) { int i = SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery("update dept set deptname=deptname+'modify' where deptid=1"); if (i > 0) { MessageBox.Show("修改数据成功!" + i); } }
private void button1_Click(object sender, EventArgs e) { int i = SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery("insert into dept(deptid,deptname) values(1,'name1')"); if (i > 0) { MessageBox.Show("插入数据成功!" + i); } }
public static DataTable GetDictTable(int dicttype) { if (dicttype == 3) { DataTable dt = new DataTable(); dt.Columns.Add("dicttext", typeof(string)); dt.Columns.Add("dictvalue", typeof(string)); DataRow dr = dt.NewRow(); dr[0] = "正常收货"; dr[1] = "001"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "返厂品"; dr[1] = "000"; dt.Rows.Add(dr); return(dt); } return(SqliteDbFactory.GetSqliteDbOperator().SelectFromSql("select dicttext,dictvalue from mydicts where dicttype=" + dicttype)); }
private void Form2_Load(object sender, EventArgs e) { this.dataGrid1.DataSource = SqliteDbFactory.GetSqliteDbOperator().SelectFromTableName("dept"); }
private void button7_Click(object sender, EventArgs e) { SqliteDbFactory.GetSqliteDbOperator().DropTable("dept"); MessageBox.Show("Drop表成功!"); }
private void button4_Click(object sender, EventArgs e) { SqliteDbFactory.GetSqliteDbOperator().CreateTable("create table dept(deptid integer,deptname varchar(30))"); MessageBox.Show("创建数据表成功!"); }