
复制privatevoid AddUserInfor_Click(object sender,本地 RoutedEventArgs e) { //用户信息 WP7_LocalDBDemo.DataEntity.Customer newcustomer = new DataEntity.Customer { Username=this.username.Text, Password=this.passsword.Text }; string dbname = @"wp7db.db3"; string getreply = string.Empty;//回调信息 //如果数据库文件不存在 自动创建 Sqlite3.sqlite3 newsqlite = new Sqlite3.sqlite3(); int getres = Sqlite3.sqlite3_open(dbname,ref newsqlite); if (getres == Sqlite3.SQLITE_OK) { //创建表 string sql = @"Create Table Customer ( customername varchar(100), customerpass varchar(100) ) "; Sqlite3.exec(newsqlite, sql, 0, 0, 0); string insertsql = @"insert into Customer Values("+newcustomer.Username+","+newcustomer.Password+")"; int getinsertres = Sqlite3.exec(newsqlite, insertsql, 0, 0, 0); if (getinsertres == Sqlite3.SQLITE_OK) { MessageBox.Show("数据插入成功!"); } else { MessageBox.Show("数据插入失败!
WordPress模板数据
"); } //自动查询数据 string querysql = @"select * from Customer"; Sqlite3.dxCallback getcallback = new Sqlite3.dxCallback(TakeCallmethod); int getlocalres=Sqlite3.sqlite3_exec(newsqlite,多样
querysql,getcallback,null,ref getreply); if (getlocalres == Sqlite3.SQLITE_OPEN_READWRITE) { //需要一个执行Reader API? //this.listBox1.Items.Add(getresdd.ToString()); } } } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.
服务器租用作者:人工智能