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("创建数据表成功!"); }