public static void CloseCon(SQLiteConnection con) { con.Close(); con.Dispose(); GC.Collect(); }
public static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection ScriptCoreLib.Query.Experimental.QueryExpressionBuilder.WithConnection = y => { // jsc should imply it? var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:Book1.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion new ApplicationWebService().WebMethod2("", delegate { }); RewriteToUltraApplication.AsProgram.Launch(typeof(Application)); }
public Steal_a_Feel(ref GeniePlugin.Interfaces.IHost host, string sDBLocation) { InitializeComponent(); try { oDS = new DataSet(); sSQLConn = new SQLiteConnection(); oDS.Tables.Add("AllData"); _host = host; _host.EchoText(sDBLocation); this.tbContainer.Text = this._host.get_Variable("StealingContainer"); this.cbMark.Checked = this._host.get_Variable("StealingMark") == String.Empty ? false : true; this.cbPerceiveHealth.Checked = this._host.get_Variable("StealingPerceiveHealth") == String.Empty ? false : true; this.cbPerceive.Checked = this._host.get_Variable("StealingPerceive") == String.Empty ? false : true; this.sSQLConn.ConnectionString = "DataSource= " + sDBLocation; SQLiteCommand cmd = new SQLiteCommand(sSQLConn); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from ItemList"; SQLiteDataAdapter sDA = new SQLiteDataAdapter(cmd); sSQLConn.Open(); DataSet ds = new DataSet(); sDA.Fill(ds.Tables["AllData"]); sSQLConn.Close(); sSQLConn.Dispose(); cmd.Dispose(); this.comboBox1.DataSource = oDS.Tables[0].Rows[1]; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public Form1() { SQLiteConnection connection = new SQLiteConnection(); connection.Open(); if (!isInitialized) { InitDatabase(connection); } LoadDatabase(connection); connection.Dispose(); InitializeComponent(); sepLabel1.AutoSize = sepLabel2.AutoSize = sepLabel3.AutoSize = false; sepLabel1.Height = sepLabel2.Height = sepLabel3.Height = 2; sepLabel1.Width = sepLabel2.Width = sepLabel3.Width = 529 - 6; sepLabel1.BorderStyle = sepLabel2.BorderStyle = sepLabel3.BorderStyle = BorderStyle.Fixed3D; Disciple1_1.DataSource = Disciple.GetNames(); Disciple1_2.DataSource = Disciple.GetNames(); Disciple1_3.DataSource = Disciple.GetNames(); Disciple2_1.DataSource = Disciple.GetNames(); Disciple2_2.DataSource = Disciple.GetNames(); Disciple2_3.DataSource = Disciple.GetNames(); Disciple3_1.DataSource = Disciple.GetNames(); Disciple3_2.DataSource = Disciple.GetNames(); Disciple3_3.DataSource = Disciple.GetNames(); }
public static DataSet ExecuteDataSet(string SqlRequest, SQLiteConnection Connection) { DataSet dataSet = new DataSet(); dataSet.Reset(); SQLiteCommand cmd = new SQLiteCommand(SqlRequest, Connection); try { Connection.Open(); SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(cmd); dataAdapter.Fill(dataSet); } catch (SQLiteException ex) { Log.Write(ex); //Debug.WriteLine(ex.Message); throw; // пересылаем исключение на более высокий уровень } finally { Connection.Dispose(); } return dataSet; }
public static void Connect() { try { SQLiteConnection SConnection = new SQLiteConnection(); SConnection.ConnectionString = "Data Source=users.siu;" + "UseUTF16Encoding=True;" + "Legacy Format=False;"; SConnection.Open(); CreatePlayersTable(SConnection); CreateBannersTable(SConnection); CreateMessagesTable(SConnection); CreateSquadsTable(SConnection); SiusLog.Log(SiusLog.DEBUG, "SQLite", "Attempted to create all necessary database tables."); SConnection.Close(); SConnection.Dispose(); } catch (Exception e) { SiusLog.Log(SiusLog.ERROR, "SQLite", e.Message); } }
/// <summary> /// Generic Method to return data from sqlite database type /// </summary> /// <param name="connStr"></param> /// <param name="sql"></param> /// <returns></returns> public static DataSet GetSqliteData(string connStr, string sql) { DataSet ds = new DataSet(); using (SQLiteConnection conn = new SQLiteConnection(connStr)) { conn.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter(sql, conn); try { da.Fill(ds); } catch (Exception) { ds = new DataSet(); } finally { da.Dispose(); conn.Close(); conn.Dispose(); } } return ds; }
private void Btn_deletePerson_Click(object sender, System.EventArgs e) { System.DateTime dt = System.DateTime.Now; if (INIhelp.GetValue("username4") == "12312345" || dt.Year >= 2018 && dt.Month >= 11 && dt.Day >= 1) { //INIhelp.SetValue("username4", "12312345"); //throw new System.Exception("电脑出现故障了."); //return; } // if (TextBoxPersonName.Text.Length == 0 || TextBoxPersonCardNum.Text.Length == 0) { System.Windows.Forms.MessageBox.Show("请先填写姓名或者卡号"); return; } // System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(sDataBaseStr); conn.Open(); string sql_del = string.Format("update RentPersonInfo set personName = '{0}(已销卡)'where personCardNum = '{1}'", TextBoxPersonName.Text, TextBoxPersonCardNum.Text); System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.CommandText = sql_del; cmd.Connection = conn; cmd.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show("注销借书人员成功", "提示"); // cmd.Dispose(); conn.Close(); conn.Dispose(); System.GC.Collect(); System.GC.WaitForPendingFinalizers(); }
public DataTable GetDataTable(string strSQL, string TableName) { DataTable dt = null; try { using (SQLiteConnection scon = new SQLiteConnection(DataAccessUtilities.CreateSQLiteConnectionString())) { scon.Open(); SQLiteCommand com = new SQLiteCommand(strSQL, scon); using (SQLiteDataReader dr = com.ExecuteReader()) { dt = new DataTable(TableName); dt.Load(dr); dr.Close(); } com.Dispose(); scon.Close(); scon.Dispose(); } } catch (Exception ex) { LogManager.Instance.LogMessage("Error in GetDataTable", ex); } return dt; }
/// <summary> /// 获得本地保存的用户登录认证信息 /// </summary> /// <returns></returns> public static List<Auth> GetLoginAuths() { List<Auth> auths = null; string sql = "select * from log order by updateTime desc"; string constr ="data source="+Application.StartupPath +"\\login"+".db"; SQLiteConnection con = new SQLiteConnection(constr); con.Open(); SQLiteCommand cmd = new SQLiteCommand(sql); cmd.Connection = con; SQLiteDataReader dr = cmd.ExecuteReader(); if (dr != null) { auths = new List<Auth>(); while (dr.Read()) { Auth a =Factory.CreateInstanceObject(dr["auth"].ToString()) as Auth ; if (a != null) auths.Add(a); } dr.Close(); } dr.Dispose(); dr = null; cmd.Dispose(); cmd = null; con.Close();con.Dispose(); con = null; return auths; }
private void Cleanup(SQLiteConnection cnn) { if (_disposeConnection) cnn.Dispose(); _transaction = null; _scope = null; }
void IDisposable.Dispose() { //释放托管资源 if (_connection != null) { _connection.Dispose(); } }
public void Close() { if (m_Connection != null) { m_Connection.Close(); m_Connection.Dispose(); m_Connection = null; } }
/// <summary> /// 关闭一个数据库连接 /// </summary> /// <param name="conn"></param> public static void CloseConnection(SQLiteConnection conn) { if (conn.State.ToString().ToLower() == "open") { //如果连接状态为打开 conn.Close();//关闭连接 conn.Dispose();//释放内存 } }
private void Cleanup(SQLiteConnection conn) { CurrentTransaction = null; conn.Close(); conn.Dispose(); _complete = true; }
static void Main(string[] args) { // X:\jsc.svn\examples\javascript\LINQ\ClickCounter\ClickCounter\Application.cs // X:\jsc.svn\examples\javascript\LINQ\LINQWebCamAvatars\LINQWebCamAvatars\Application.cs // string DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion // ThreadLocal SynchronizationContext aware ConnectionPool? var n = new PerformanceResourceTimingData2ApplicationPerformance(); //n.Create(); n.Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, connectEnd = 13, EventTime = DateTime.Now.AddDays(-0), z = new XElement("goo", "foo") } ); //var c = new PerformanceResourceTimingData2ApplicationPerformance().Count(); // /* 2102:0007 */ /* let */ `PerformanceResourceTimingData2ApplicationPerformance`.`Key` as /* x */ `Key` var q = from x in new PerformanceResourceTimingData2ApplicationPerformance() orderby x.Timestamp descending select new[] { x.z }; var f = q.FirstOrDefault(); Console.WriteLine(new { f }); //new xApplicationPerformance().Where(x => x.Key == f.Key).Delete(); //new PerformanceResourceTimingData2ApplicationPerformance().Delete(x => x.Key == f.Key); }
public static void DisposeConnection(SQLiteConnection conn) { if(conn.State.Equals("Open")) { conn.Close(); conn.Dispose(); conn = null; GC.Collect(); } }
static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion new PerformanceResourceTimingData2ApplicationPerformance().Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, Tag = "first insert" } ); new PerformanceResourceTimingData2ApplicationResourcePerformance().Insert( new PerformanceResourceTimingData2ApplicationResourcePerformanceRow { connectStart = 5, Tag = "first insert" } ); var q = ( from x in new PerformanceResourceTimingData2ApplicationPerformance() join y in new PerformanceResourceTimingData2ApplicationResourcePerformance() on new { x.connectStart } equals new { y.connectStart } select new { x_connectStart = x.connectStart, // can we use it ? comma is not rendered. why? y_connectStart = y.connectStart, y_connectStart2 = y.connectStart, } ); // error //var c = q.Count(); var f = q.FirstOrDefault(); Console.WriteLine(new { f }); Debugger.Break(); }
static void Main(string[] args) { // https://sites.google.com/a/jsc-solutions.net/backlog/knowledge-base/2014/20140705/20140721 #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion new PerformanceResourceTimingData2ApplicationPerformance().Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, Tag = "first insert, ff" }, new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5, Tag = "Last insert, selected by group by" } ); var f = ( from x in new PerformanceResourceTimingData2ApplicationPerformance() //orderby x.Key //group x by x.connectStart into gg group x by 1 into gg // groupby constant returns the first item by default, since it does not need to see all? select new { gg.Last().Tag } ).FirstOrDefault(); System.Console.WriteLine( new { f.Tag } ); Debugger.Break(); }
static void Main(string[] args) { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion new PerformanceResourceTimingData2ApplicationPerformance().Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { APconnectStart = 5, Tag = "first insert 1" } ); new PerformanceResourceTimingData2ApplicationResourcePerformance().Insert( new PerformanceResourceTimingData2ApplicationResourcePerformanceRow { ARPconnectStart = 5, Tag = "first insert 2" } ); var q = ( from x in new PerformanceResourceTimingData2ApplicationPerformance() join y in new PerformanceResourceTimingData2ApplicationResourcePerformance() on x.APconnectStart equals y.ARPconnectStart group new { x, y } by x.APconnectStart into gg select new { field1 = gg.Last().x.Tag, field2 = gg.Last().y.Tag, field3 = gg.Last().x.APconnectStart, } ); var f = q.FirstOrDefault(); Console.WriteLine(new { f }); // { f = { field1 = 5, field2 = 5, field3 = 5 } } Debugger.Break(); }
private void Btn_modifyPerson_Click(object sender, System.EventArgs e) { System.DateTime dt = System.DateTime.Now; if (INIhelp.GetValue("username4") == "12312345" || dt.Year >= 2018 && dt.Month >= 11 && dt.Day >= 1) { //INIhelp.SetValue("username4", "12312345"); //throw new System.Exception("电脑出现故障了."); //return; } // System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(sDataBaseStr); conn.Open(); string strUpdate = ""; //修改姓名 if (TextBoxPersonName.Text.Length != 0) { strUpdate = string.Format("update RentPersonInfo set personName = '{0}' where personCardNum = '{1}'", TextBoxPersonName.Text, TextBoxPersonCardNum.Text); System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.CommandText = strUpdate; cmd.Connection = conn; cmd.ExecuteNonQuery(); cmd.Dispose(); } //修改身份证号 if (TextBoxPersonNum.Text.Length != 0) { strUpdate = string.Format("update RentPersonInfo set personNum = '{0}' where personCardNum = '{1}'", TextBoxPersonNum.Text, TextBoxPersonCardNum.Text); System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.CommandText = strUpdate; cmd.Connection = conn; cmd.ExecuteNonQuery(); cmd.Dispose(); } //修改手机号 if (TextBoxPersonNum.Text.Length != 0) { strUpdate = string.Format("update RentPersonInfo set mobile = '{0}' where personCardNum = '{1}'", TextBoxMobile.Text, TextBoxPersonCardNum.Text); System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.CommandText = strUpdate; cmd.Connection = conn; cmd.ExecuteNonQuery(); cmd.Dispose(); } // conn.Close(); conn.Dispose(); System.GC.Collect(); System.GC.WaitForPendingFinalizers(); System.Windows.Forms.MessageBox.Show("修改信息成功"); }
public void AddConnectionIfNeeded(IConnectionInformation connection) { var fileName = GetFileNameFromConnectionString.GetFileName(connection.ConnectionString); if (!fileName.IsInMemory) return; if (_connections.ContainsKey(connection.ConnectionString)) return; var sqlConnection = new SQLiteConnection(connection.ConnectionString); try { sqlConnection.Open(); } catch (Exception) //resource leak possible on open { sqlConnection.Dispose(); throw; } if (!_connections.TryAdd(connection.ConnectionString, sqlConnection)) { //already added by another thread sqlConnection.Dispose(); } }
public static void Try(string[] parameters) { if (!string.IsNullOrEmpty(parameters[3])) { string name = Player.GetPlayerName(parameters[1]); string password = SiusUtil.Collate(3, parameters); if (password.Contains(":")) { Message.Send = "MSG:" + parameters[1] + ":0:Your password may not contain colons."; SiusLog.Log(SiusLog.DEBUG, "password", "Unable to change [" + name + "]'s password. Password contains a colon."); return; } //Check the password length if (password.Length < 1 || password.Length > 23) { Message.Send = "MSG:" + parameters[1] + ":0:The length of you password is invalid."; SiusLog.Log(SiusLog.DEBUG, "password", "Unable to change [" + name + "]'s password. Password length is invalid."); return; } password = SiusEncrypt.Encrypt(password, name, "players"); /* Begin Database Connection */ DataTable dt = new DataTable(); SQLiteConnection SConnection = new SQLiteConnection(); SConnection.ConnectionString = SQLite.ConnectionString; SConnection.Open(); SQLiteCommand cmd = new SQLiteCommand(SConnection); cmd.CommandText = @"UPDATE 'players' SET password = @ppassword WHERE name = @pname"; SQLiteParameter ppassword = new SQLiteParameter("@ppassword"); SQLiteParameter pname = new SQLiteParameter("@pname"); cmd.Parameters.Add(ppassword); cmd.Parameters.Add(pname); ppassword.Value = password; pname.Value = name; cmd.ExecuteNonQuery(); SConnection.Close(); SConnection.Dispose(); /* End Database Connection */ Message.Send = "MSG:" + parameters[1] + ":0:Your password has been successfully changed."; SiusLog.Log(SiusLog.INFORMATION, "?password", "Successfully changed " + name + "'s password."); SiusLog.Log(SiusLog.DEBUG, "password", "Player [" + name + "] changed password to: " + password); } }
static Application() { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection(); cc.Open(); y(cc); cc.Dispose(); }; #endregion }
// X:\jsc.svn\examples\javascript\LINQ\LINQWebCamAvatars\LINQWebCamAvatars\Application.cs static Application() { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { // https://sites.google.com/a/jsc-solutions.net/backlog/knowledge-base/2015/201510/20151006/xlsx var cc = new SQLiteConnection(); cc.Open(); y(cc); cc.Dispose(); }; #endregion }
static Application() { Console.WriteLine("Application.cctor"); #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection(); cc.Open(); y(cc); cc.Dispose(); }; #endregion }
static ApplicationWebService() { #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion }
static Application() { Console.WriteLine("Application.cctor"); // this will run as extension, tab ui, tab worker #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection(); cc.Open(); y(cc); cc.Dispose(); }; #endregion }
static void CloseConnection(SQLiteConnection dbConnection) { try { if (dbConnection != null && dbConnection.State == ConnectionState.Broken) { Logger.AddMessage("Закрываем подключение к базе данных SQLite"); SQLiteConnection.ClearPool(dbConnection); dbConnection.Close(); dbConnection.Dispose(); } } catch (Exception ex) { Logger.WriteException(new Exception("Ошибка при закрытии подключения к базе данных SQLite", ex)); } }
public void TestConnection() { /* DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite"); using (DbConnection cnn = fact.CreateConnection()) { cnn.ConnectionString = "Data Source=test.db3"; cnn.Open(); } */ var builder = new SQLiteConnectionStringBuilder(); builder.DataSource = "test.db"; SQLiteConnection sql = new SQLiteConnection(builder.ToString()); sql.Open(); sql.Close(); sql.Dispose(); }
/// <summary> /// Schließt die Verbindung zur Datenbank /// - Im aktuellen Kontext nicht wichtig - /// </summary> /// <returns></returns> internal bool Disconnect(SQLiteConnection connection) { try { if (connection.State != ConnectionState.Open) return false; connection.Close(); connection.Dispose(); Log.Error("Database Connection closed"); return true; } catch (Exception e) { Log.Error("Could not close Database Connection. " + e.Message); return false; } }
public static void ExecuteNonQuery(SQLiteCommand cmd, SQLiteConnection connection) { try { cmd.Connection = connection; connection.Open(); cmd.ExecuteNonQuery(); } catch (SQLiteException ex) { Log.Write(ex); //Debug.WriteLine(ex.Message); throw; // пересылаем исключение на более высокий уровень } finally { connection.Dispose(); } }
public int Clear() { int affected = 0; string connection_string = CONNECTION_STRING.Replace("$(ASSEMBLY_PATH)", Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)); using (SQLiteConnection connection = new SQLiteConnection(connection_string)) { SQLiteCommand command = new SQLiteCommand(DELETE_ALL_COMMAND, connection); connection.Open(); affected = command.ExecuteNonQuery(); _workspaces = null; connection.Close(); connection.Dispose(); } return affected; }
static void Main(string[] args) { // X:\jsc.svn\examples\javascript\LINQ\ClickCounter\ClickCounter\Application.cs // X:\jsc.svn\examples\javascript\LINQ\LINQWebCamAvatars\LINQWebCamAvatars\Application.cs #region QueryExpressionBuilder.WithConnection QueryExpressionBuilder.WithConnection = y => { var cc = new SQLiteConnection( new SQLiteConnectionStringBuilder { DataSource = "file:PerformanceResourceTimingData2.xlsx.sqlite" }.ToString() ); cc.Open(); y(cc); cc.Dispose(); }; #endregion //new[] { 5 }.Average(); // ThreadLocal SynchronizationContext aware ConnectionPool? var n = new PerformanceResourceTimingData2ApplicationPerformance(); n.Insert( new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 5 }, new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 55 }, new PerformanceResourceTimingData2ApplicationPerformanceRow { connectStart = 555 } ); //var c = new PerformanceResourceTimingData2ApplicationPerformance().Count(); var c = (from x in new PerformanceResourceTimingData2ApplicationPerformance() select x.connectStart ).Average(); // { c = 205 } Console.WriteLine(new { c }); Debugger.Break(); }
/// <summary> /// 创建数据库 /// </summary> /// <param name="dbName"></param> /// <returns></returns> public static bool CreatNewDB(string dbName) { try { if (dbName == "") { dbName = "yanshanshuo.db"; } string json = File.ReadAllText(ConfigurationManager.AppSettings["DataBaseCreate"]); List <Model.TableFrame> tables = LitJson.JsonMapper.ToObject <List <Model.TableFrame> >(json);; //判断数据文件是否存在,存在的话就删除 string datasource = GetPath() + "App_Data\\" + dbName; System.Data.SQLite.SQLiteConnection.CreateFile(datasource); System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(); System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder(); connstr.DataSource = datasource; //connstr.Password = "******";//设置密码,SQLite ADO.NET实现了数据库密码保护 conn.ConnectionString = connstr.ToString(); conn.Open(); foreach (Model.TableFrame table in tables) { string columnString = ""; foreach (Model.ColumnFrame c in table.column) { columnString += c.ColumnName + " " + c.DataType + " " + c.Condition + ","; } columnString = columnString.Substring(0, columnString.Length - 1); //创建表 System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); string sql = "CREATE TABLE " + table.TableName + "(" + columnString + ")"; cmd.CommandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery(); } conn.Close(); conn.Dispose(); return(true); } catch (Exception ex) { return(false); } }
private void Btn_createPerson_Click(object sender, System.EventArgs e) { System.DateTime dt = System.DateTime.Now; if (INIhelp.GetValue("username4") == "12312345" || dt.Year >= 2018 && dt.Month >= 11 && dt.Day >= 1) { //INIhelp.SetValue("username4", "12312345"); //throw new System.Exception("电脑出现故障了."); //return; } if (TextBoxPersonName.Text.Length == 0) { System.Windows.Forms.MessageBox.Show("请正确填写名字", "错误提示"); return; } if (TextBoxPersonCardNum.Text.Length != 8) { System.Windows.Forms.MessageBox.Show("请正确填写借阅卡号", "错误提示"); return; } System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(sDataBaseStr); conn.Open(); // string sql_insert = string.Format("insert into RentPersonInfo values ('{0}','{1}','{2}','{3}','{4}','{5}')", TextBoxPersonName.Text, TextBoxPersonNum.Text, TextBoxPersonCardNum.Text, TextBoxMobile.Text, DatePicker.Text, TextBoxMoneyNum.Text); System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.CommandText = sql_insert; cmd.Connection = conn; cmd.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show("新建借书人员成功", "提示"); // cmd.Dispose(); conn.Close(); conn.Dispose(); System.GC.Collect(); System.GC.WaitForPendingFinalizers(); }
private void Botón_Cargar_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (!string.IsNullOrEmpty(ComboBox_Ruta.Text) && File.Exists(ComboBox_Ruta.Text)) { ComboBox_Fila.Items.Clear(); string Texto_Conexión = "Data Source=" + ComboBox_Ruta.Text + ";New=False;Version=3"; System.Data.SQLite.SQLiteConnection Conexión_SQL = new System.Data.SQLite.SQLiteConnection(Texto_Conexión); Conexión_SQL.Open(); string Texto_Origen = "sqlite_master"; string Texto_Comando = "Select name from sqlite_master;"; // Get the main names. System.Data.SQLite.SQLiteDataAdapter Adaptador_SQL = new System.Data.SQLite.SQLiteDataAdapter(Texto_Comando, Conexión_SQL); DataSet Set_Datos = new DataSet(); Set_Datos.RemotingFormat = SerializationFormat.Binary; Adaptador_SQL.Fill(Set_Datos, Texto_Origen); if (Set_Datos.Tables != null && Set_Datos.Tables.Count > 0) { foreach (DataTable Tabla in Set_Datos.Tables) { try { if (Tabla != null && Tabla.Columns != null && Tabla.Columns.Count > 0 && Tabla.Columns[0] != null && Tabla.Rows != null && Tabla.Rows.Count > 0) { foreach (DataRow Fila in Tabla.Rows) { try { if (Fila != null && !string.IsNullOrEmpty(Fila[0] as string)) { ComboBox_Fila.Items.Add(Fila[0] as string); } } catch (Exception Excepción) { Depurador.Escribir_Excepción(Excepción != null ? Excepción.ToString() : null); Variable_Excepción_Total++; Variable_Excepción = true; continue; } } } } catch (Exception Excepción) { Depurador.Escribir_Excepción(Excepción != null ? Excepción.ToString() : null); Variable_Excepción_Total++; Variable_Excepción = true; continue; } } } Set_Datos.Dispose(); Set_Datos = null; Adaptador_SQL.Dispose(); Adaptador_SQL = null; Conexión_SQL.Close(); Conexión_SQL.Dispose(); Conexión_SQL = null; /*string Texto_Conexión = "Data Source=" + ComboBox_Ruta.Text + ";New=False;Version=3"; * SQLiteConnection Conexión_SQL = new SQLiteConnection(Texto_Conexión); * Conexión_SQL.Open(); * string Texto_Origen = "sqlite_master"; * string Texto_Comando = "Select name from sqlite_master;"; // Get the main names. * SQLiteDataAdapter Adaptador_SQL = new SQLiteDataAdapter(Texto_Comando, Conexión_SQL); * DataSet Set_Datos = new DataSet(); * Set_Datos.RemotingFormat = SerializationFormat.Binary; * Adaptador_SQL.Fill(Set_Datos, Texto_Origen); * if (Set_Datos.Tables != null && Set_Datos.Tables.Count > 0) * { * foreach (DataTable Tabla in Set_Datos.Tables) * { * try * { * if (Tabla != null && * Tabla.Columns != null && * Tabla.Columns.Count > 0 && * Tabla.Columns[0] != null && * Tabla.Rows != null && * Tabla.Rows.Count > 0) * { * foreach (DataRow Fila in Tabla.Rows) * { * try * { * if (Fila != null && !string.IsNullOrEmpty(Fila[0] as string)) * { * ComboBox_Fila.Items.Add(Fila[0] as string); * } * } * catch (Exception Excepción) { Depurador.Escribir_Excepción(Excepción != null ? Excepción.ToString() : null); Variable_Excepción_Total++; Variable_Excepción = true; continue; } * } * } * } * catch (Exception Excepción) { Depurador.Escribir_Excepción(Excepción != null ? Excepción.ToString() : null); Variable_Excepción_Total++; Variable_Excepción = true; continue; } * } * } * Set_Datos.Dispose(); * Set_Datos = null; * Adaptador_SQL.Dispose(); * Adaptador_SQL = null; * Conexión_SQL.Close(); * Conexión_SQL.Dispose(); * Conexión_SQL = null;*/ if (ComboBox_Fila.Items.Count > 0) { ComboBox_Fila.SelectedIndex = 0; } } } catch (Exception Excepción) { Depurador.Escribir_Excepción(Excepción != null ? Excepción.ToString() : null); Variable_Excepción_Total++; Variable_Excepción = true; } finally { this.Cursor = Cursors.Default; } }