public static void create_db_tab() { MyDatabase domain = new MyDatabase(); domain.DbName = "管理"; domain.TableName = "admin"; Dictionary <string, string> columns = new Dictionary <string, string>(); columns.Add("username", "varchar(50)"); columns.Add("upass", "varchar(50)"); columns.Add("级别", "int"); domain.Columns = columns; AccessOp.CreateAccessDb(domain.DbName); AccessOp.CreateAccessTab(domain); }
public static void test_4() { OleDbConnection con = AccessOp.getCon(null); OleDbCommand cmd = con.CreateCommand(); cmd.CommandText = "select * from admin"; cmd.Connection = con; OleDbDataAdapter db = new OleDbDataAdapter(); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine("{0} {1} {2}", reader.GetString(1), reader.GetString(2), reader.GetInt32(3)); } AccessOp.closeAll(con, cmd, reader); Console.Read(); }
public static void test() { string file = "G:\\createAccess\\admin.accdb"; AccessOp.CreateAccessDb(file); }
private static void test_2() { OleDbConnection con = AccessOp.getCon(null); }
public static void create_totalTable() { AccessOp.CreateDeptTotalTab("manager"); }
public static void createPurviewTab() { AccessOp.CreatePurviewTab("manager"); }