/** public void createUc() - create user controls (display reminders) * */ public void createUc() { int i = 0; UserControl1[] uc = new UserControl1[200]; SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString()); new_con.Open(); SQLiteCommand get = new SQLiteCommand("SELECT * FROM reminder LIMIT 0 , 30", new_con); String header; SQLiteDataReader reader; reader = get.ExecuteReader(); while (reader.Read()) { //data[i,0] = new ArrayList(); string[] str = new string[3]; str[0]=reader[0].ToString(); str[1]=DateTime.Parse(reader[1].ToString()).ToShortDateString(); str[2]=DateTime.Parse(reader[5].ToString()).ToShortTimeString(); reminderList.Add(str); header = String.Format("{1,-20} {0,5}", reader[2].ToString(), DateTime.Parse(reader[1].ToString()).ToShortDateString()); uc[i] = new UserControl1(); uc[i].setContent(Convert.ToInt16(reader[0].ToString()), reader[3].ToString(), reader[4].ToString(), DateTime.Parse(reader[5].ToString()).ToShortTimeString() , header); WrapPanel1.Children.Add(uc[i]); i++; } reminderlistarray = reminderList.ToArray(); }
public MainWindow() { InitializeComponent(); AddDinValues(); AddPCBValues(); AddRKValues(); // create a new database connection: sqlite_conn = new SQLiteConnection("Data Source=ICTSupportInventory.db;Version=3;New=False;Compress=True;"); // open the table for connection sqlite_conn.Open(); // create a new SQL command: sqlite_cmd = sqlite_conn.CreateCommand(); // create a new table to work with sqlite_cmd.CommandText = "CREATE TABLE Items (ProductType varchar(100), SerialNumber varchar(100), Location varchar(100), Availability varchar(50), Owner varchar(100), ETR varchar(100), Comments varchar(100));"; // close the connection sqlite_conn.Close(); // get values to populate all items PopulateAllLists(); }
// create a new database connection: //ajouter voiture public bool ajouterVoiture(Voiture v) { try { sqlite_conn.Open(); sqlite_cmd = sqlite_conn.CreateCommand(); string req = "Insert Into Automobile(Annee, Immatriculation, Coulour, Marque, TypeV, AutoMoto) Values (" + v.Annee + ", '" + v.Immatriculation + "', '" + v.Coulour + "', '" + v.Marque + "', '" + v.TypeV + "', 'True');"; // Lets insert something into our new table: sqlite_cmd.CommandText = req; sqlite_cmd.ExecuteNonQuery(); sqlite_conn.Close(); return true; } catch (Exception) { return false; } }
private void btnSubmit_Click(object sender, EventArgs e) { // Let the SQLiteCommand object know our SQL-Query: sqlite_conn = new SQLiteConnection("Data Source=database.db;Version=3;Compress=True;"); sqlite_conn.Open(); //UPDATE People set stxtFname=@stxtFname,stxtLname = @stxtLName, SQLiteCommand sqlite_cmd = new SQLiteCommand(@"Update ProgramConfig Set sPassword = @password, sEmail = @email, sSchoolName = @name, sAddress = @address, sCity = @city, sState = @state, sZip = @zip, sLatitude = @latitude, sLongitude = @longitude, sImageFile = @ImageFile Where id = 1", sqlite_conn); sqlite_cmd.Parameters.Add("@password", SqlDbType.Text).Value = parentForm.school.password; sqlite_cmd.Parameters.Add("@email", SqlDbType.Text).Value = parentForm.school.email; sqlite_cmd.Parameters.Add("@name", SqlDbType.Text).Value = parentForm.school.name; sqlite_cmd.Parameters.Add("@address", SqlDbType.Text).Value = parentForm.school.address; sqlite_cmd.Parameters.Add("@city", SqlDbType.Text).Value = parentForm.school.city; sqlite_cmd.Parameters.Add("@state", SqlDbType.Text).Value = parentForm.school.state; sqlite_cmd.Parameters.Add("@zip", SqlDbType.Text).Value = parentForm.school.zip; sqlite_cmd.Parameters.Add("@latitude", SqlDbType.Text).Value = parentForm.school.latitude; sqlite_cmd.Parameters.Add("@longitude", SqlDbType.Text).Value = parentForm.school.longitude; sqlite_cmd.Parameters.Add("@ImageFile", SqlDbType.Text).Value = parentForm.school.ImageFile; sqlite_cmd.CommandType = CommandType.Text; try { int i = sqlite_cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } parentForm.RefreshLogo(parentForm.school.ImageFile); this.Close(); }
public List<Drop> GetDrops(int mobId) { // create a new SQL command: sqlite_cmd = sqlite_conn.CreateCommand(); // But how do we read something out of our table ? // First lets build a SQL-Query again: sqlite_cmd.CommandText = "SELECT * FROM droplist where mobId = " + mobId; // Now the SQLiteCommand object can give us a DataReader-Object: sqlite_datareader = sqlite_cmd.ExecuteReader(); List<Drop> droplist = new List<Drop>(10); // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read { int itemId = Convert.ToInt32(sqlite_datareader["itemId"]); int min = Convert.ToInt32(sqlite_datareader["min"]); int max = Convert.ToInt32(sqlite_datareader["max"]); int category = Convert.ToInt32(sqlite_datareader["category"]); int chance = Convert.ToInt32(sqlite_datareader["chance"]); droplist.Add(new Drop(mobId, itemId, min, max, category, chance)); } return droplist; }
public bool GetSchool() { bool bReturn = false; sqlite_cmd = new SQLiteCommand("Select * from ProgramConfig where id = 1", sqlite_conn); // Now the SQLiteCommand object can give us a DataReader-Object: sqlite_datareader = sqlite_cmd.ExecuteReader(); // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read { Console.WriteLine(sqlite_datareader["sLatitude"].ToString()); school = new School(sqlite_datareader["sPassword"].ToString(), sqlite_datareader["sEmail"].ToString(), sqlite_datareader["sSchoolName"].ToString(), sqlite_datareader["sAddress"].ToString(), sqlite_datareader["sCity"].ToString(), sqlite_datareader["sState"].ToString(), sqlite_datareader["sZip"].ToString(), sqlite_datareader["sLatitude"].ToString(), sqlite_datareader["sLongitude"].ToString(), sqlite_datareader["sImageFile"].ToString()); try { string sExistingDatabaseVersion = sqlite_datareader["sDatabaseVersion"].ToString(); if(OldDBVersion(sExistingDatabaseVersion,DatabaseVersion)) { UpgradeDB(sExistingDatabaseVersion, DatabaseVersion); } } catch (Exception e) { Console.WriteLine(e.ToString()); Console.WriteLine("No database version available. Need to upgrade to DB Version 1.0 after backing things up."); } bReturn = true; } return bReturn; }
internal SQLiteDataReader(SQLiteCommand pCmd, CommandBehavior cmdBehavior) { if (pCmd == null) throw new ArgumentNullException(); if( pCmd.GetSQLStatementCount() <= 0 ) throw new ArgumentException("CommandText doesn't contain any SQL statements in SQLiteCommand"); mpCmd = pCmd; mCmdBehavior = cmdBehavior; }
public void ExecuteQuery(string txtQuery) { SetConnection(); sql_con.Open(); sql_cmd = sql_con.CreateCommand(); sql_cmd.CommandText = txtQuery; sql_cmd.ExecuteNonQuery(); sql_con.Close(); }
public String getSecteur(int id) { sql_con.Open(); sql_cmd = sql_con.CreateCommand(); string CommandText = "SELECT nom FROM secteur WHERE id = " + id; DB = new SQLiteDataAdapter(CommandText, sql_con); DS.Reset(); DB.Fill(DS); DT = DS.Tables[0]; sql_con.Close(); return (String)DT.Rows[0][0]; }
public DataTable getCarTable() { sql_con.Open(); sql_cmd = sql_con.CreateCommand(); string CommandText = "SELECT * FROM voiture"; DB = new SQLiteDataAdapter(CommandText, sql_con); DS.Reset(); DB.Fill(DS); DT = DS.Tables[0]; sql_con.Close(); return DT; }
public CppSqlGenerationVisitor(Settings sett, Graph rooms) { m_settings = sett; m_graph = rooms; //System.Diagnostics.Process proc = new System.Diagnostics.Process(); //proc.StartInfo.FileName = "sqlite.exe"; m_conn = new SQLiteConnection("Data Source=adventure.hac;Version=3;New=True;Compress=True"); m_conn.Open(); m_cmd = m_conn.CreateCommand(); m_propid = -1; m_statpropid = -1; m_respid = 0; }
public int CountDoc(string query) { SetConnection(); sql_con.Open(); sql_cmd = sql_con.CreateCommand(); DB = new SQLiteDataAdapter(query, sql_con); DataSet DataS = new DataSet(); DataS.Reset(); DB.Fill(DataS); //int t = Convert.ToInt16(DataS.Tables[0].Rows[0][0]); return Convert.ToInt16(DataS.Tables[0].Rows[0][0]); }
private static void InitConnection() { Console.WriteLine(Application.UserAppDataPath); string dataPath = Application.UserAppDataPath + "\\" + "data"; if (Directory.Exists(dataPath) && File.Exists(dataPath + "\\database.db")) { sqlConnection = new SQLiteConnection( "Data Source=" + dataPath + "\\database.db" + ";Version=3;New=False;Compress=True;UTF8Encoding=True;"); sqlConnection.Open(); sqlCommand = sqlConnection.CreateCommand(); } else { if (!Directory.Exists(dataPath)) { Directory.CreateDirectory(dataPath); ClearFileUnderPath(dataPath); } sqlConnection = new SQLiteConnection( "Data Source=" + dataPath + "\\database.db" + ";Version=3;New=True;Compress=True;UTF8Encoding=True;"); sqlConnection.Open(); ClearFileUnderPath(dataPath); sqlCommand = sqlConnection.CreateCommand(); sqlCommand.CommandText = "create table movie(fileLocation nvarchar primary key)"; sqlCommand.ExecuteNonQuery(); sqlCommand.CommandText = "create table music(fileLocation nvarchar primary key)"; sqlCommand.ExecuteNonQuery(); sqlCommand.CommandText = "create table file(fileLocation nvarchar primary key)"; sqlCommand.ExecuteNonQuery(); } //string sql = "select count(*) as c from sqlite_master where type ='table' and name ='movie'"; //sqlCommand.CommandText = // "create table movie(fileLocation nvarchar primary key)"; //sqlCommand.ExecuteNonQuery(); //sqlCommand.CommandText = "create table music(fileLocation nvarchar primary key)"; //sqlCommand.ExecuteNonQuery(); //sqlCommand.CommandText = "create table file(fileLocation nvarchar primary key)"; //sqlCommand.ExecuteNonQuery(); }
public OneSQLStatement( SQLiteCommand pCmd, String cmdText, ArrayList paramNames ) { mCmd = pCmd; mCmdText = cmdText; mpParamNames = paramNames; if (mCmd == null) throw new ArgumentNullException("pCmd"); if (mCmdText == null) throw new ArgumentNullException("cmdText"); if (mCmdText.Length == 0) throw new ArgumentException("The command text must be non-empty"); }
void LoadUserSelect() { comboUser.Items.Clear(); SQLiteCommand sqlite_cmd = new SQLiteCommand("SELECT * FROM People", sqlite_conn); // Now the SQLiteCommand object can give us a DataReader-Object: sqlite_datareader = sqlite_cmd.ExecuteReader(); // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read { //Console.WriteLine(String.Format("{0}, {1}", sqlite_datareader["stxtLname"], sqlite_datareader["stxtFname"])); comboUser.Items.Add(String.Format("{0}: {1}, {2}", sqlite_datareader["id"], sqlite_datareader["stxtLname"], sqlite_datareader["stxtFname"])); } }
public void SearchData(string qerty,int tab) { tabControl1.SelectedIndex = tab; SetConnection(); sql_con.Open(); sql_cmd = sql_con.CreateCommand(); DB = new SQLiteDataAdapter(qerty, sql_con); DS.Reset(); DB.Fill(DS); DT = DS.Tables[0]; dataGrid1.DataSource = DT; sql_con.Close(); RefreshButtons(); }
/// <summary> /// Simplify the creation of a SQLite command object by allowing /// a CommandType and Command Text to be provided /// </summary> /// <remarks> /// e.g.: /// SQLiteCommand command = CreateCommand(conn, CommandType.Text, "Select * from Customers"); /// </remarks> /// <param name="connection">A valid SQLiteConnection object</param> /// <param name="commandType">CommandType (TableDirect, Text)</param> /// <param name="commandText">CommandText</param> /// <returns>A valid SQLiteCommand object</returns> public static SQLiteCommand CreateCommand(SQLiteConnection connection, CommandType commandType, string commandText ) { if( connection == null ) throw new ArgumentNullException( "connection" ); if( commandType == CommandType.StoredProcedure ) throw new ArgumentException("Stored Procedures are not supported."); // If we receive parameter values, we need to figure out where they go if ((commandText == null) && (commandText.Length<= 0)) throw new ArgumentNullException( "Command Text" ); // Create a SQLiteCommand SQLiteCommand cmd = new SQLiteCommand(commandText, connection ); cmd.CommandType = CommandType.Text ; return cmd; }
static private void ExecuteQuery(string txtQuery) { lock(sql_con) { SetConnection(); sql_con.Open(); sql_cmd = sql_con.CreateCommand(); sql_cmd.CommandText = txtQuery; sql_cmd.ExecuteNonQuery(); sql_con.Close(); } }
public DataTable Insert(string queryString) { try { lock(DataBase._conn) { SQLiteCommand Cmd = new SQLiteCommand(); Cmd = DataBase._conn.CreateCommand(); Cmd.CommandText = queryString; Cmd.CommandType=CommandType.Text ; Cmd.ExecuteNonQuery(); } return null; }catch(Exception e){ Debug.WriteLine("DataBase Insert Problem: "+ e.Message); return null; } }
private void btnAddGuardian_Click(object sender, EventArgs e) { SearchForUser GetContact = new SearchForUser(GUARDIAN_ASSOCIATION_REQUEST, this, sqlite_conn); GetContact.ShowDialog(); Console.Write("{0}{1}", iUser, sRelationship); SQLiteCommand sqlite_cmd = new SQLiteCommand("INSERT INTO Guardians (id,iStudent,iPerson,sRelationship) VALUES (@id,@iStudent,@iPerson,@sRelationship)", sqlite_conn); sqlite_cmd.Parameters.Add("@id", SqlDbType.Int).Value = null; sqlite_cmd.Parameters.Add("@iStudent", SqlDbType.Int).Value = Int32.Parse(txtID.Text); sqlite_cmd.Parameters.Add("@iPerson", SqlDbType.Int).Value = iUser; sqlite_cmd.Parameters.Add("@sRelationship", SqlDbType.Text).Value = sRelationship; try { sqlite_cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } LoadGuardians(); }
/** private void ButtonYes_Click(object sender, System.Windows.RoutedEventArgs e) * delete reminder */ private void ButtonYes_Click(object sender, System.Windows.RoutedEventArgs e) { SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString()); new_con.Open(); if (delete_status == 1) { SQLiteCommand get = new SQLiteCommand("DELETE FROM reminder WHERE rid ='" + Convert.ToInt32(id) + "'", new_con); get.ExecuteNonQuery(); MainWindowStart mainWindow = MainWindowStart.Instance; mainWindow.mainWindowUpdate(); } else { SQLiteCommand get = new SQLiteCommand("DELETE FROM contact_detail WHERE cid ='" + Convert.ToInt32(id) + "'", new_con); get.ExecuteNonQuery(); MainWindowStart mainWindow = MainWindowStart.Instance; mainWindow.mainWindowUpdateContact(); } new_con.Close(); this.Close(); }
//ajouter moto public bool ajouterMoto(Moto v) { try { sqlite_conn.Open(); sqlite_cmd = sqlite_conn.CreateCommand(); string req = "Insert Into Automobile(Annee, Immatriculation, Cylindre , VitesseMax, AutoMoto) Values (" + v.Annee + ", '" + v.Immatriculation + "', " + v.Cylindre + ", " + v.VitesseMax + ", 'False');"; // Lets insert something into our new table: sqlite_cmd.CommandText = req; sqlite_cmd.ExecuteNonQuery(); sqlite_conn.Close(); return true; } catch (Exception) { return false; } }
static FmMain() { connection = new SQLiteConnection(); command = new SQLiteCommand(); String cs = ""; cs = cs + String.Format("Data Source={0};", IDE.LibPath + "ASEExpertVS2005.CodeKeeper.db"); cs = cs + String.Format("Version=3;"); bool isNew = !File.Exists(IDE.LibPath + "ASEExpertVS2005.CodeKeeper.db"); if (isNew) cs = cs + String.Format("New=True;"); cs = cs + String.Format("UTF8Encoding=True;"); cs = cs + String.Format(";"); connection.ConnectionString = cs; try { connection.Open(); command.Connection = connection; if (isNew) { ExecuteNonQuery("CREATE TABLE groups (parentid INTEGER, name TEXT)"); ExecuteNonQuery("CREATE TABLE code (groupid INTEGER, name TEXT, code TEXT, langid INTEGER)"); ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'General')"); ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'Forms')"); ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'IO')"); ExecuteNonQuery("INSERT INTO groups (parentid , name) VALUES (0, 'NET')"); } } catch (Exception exc) { IDE.Debug("", exc); } }
public DataTable Select(string queryString) { sw.Write("test"+queryString); try { lock(DataBase._conn) { SQLiteCommand Cmd = new SQLiteCommand(); SQLiteDataAdapter da = new SQLiteDataAdapter(queryString, DataBase._conn); DataTable dt = new DataTable(); if(da != null) { da.Fill(dt); return dt; }else{ return null; } } }catch(Exception e){ Debug.WriteLine("DataBase Select Problem: "+ e.Message); return null; } }
private void btnAddPerson_Click(object sender, EventArgs e) { SQLiteCommand insertSQL = new SQLiteCommand(@"INSERT INTO People ( id,stxtFname,stxtLname,stxtPhone, stxtAddress,stxtCity,stxtState,stxtZip) VALUES (@id,@stxtFname,@stxtLname,@stxtPhone,@stxtAddress,@stxtCity, @stxtState, @stxtZip)", sqlite_conn); //SQLiteCommand test = new SQLiteCommand("") insertSQL.Parameters.Add("@id", SqlDbType.Int).Value = null; insertSQL.Parameters.Add("@stxtFname", SqlDbType.Text).Value = txtEditFName.Text; insertSQL.Parameters.Add("@stxtLname", SqlDbType.Text).Value = txtEditLName.Text; insertSQL.Parameters.Add("@stxtPhone", SqlDbType.Text).Value = txtEditPhone.Text; insertSQL.Parameters.Add("@stxtAddress", SqlDbType.Text).Value = txtEditAddress.Text; insertSQL.Parameters.Add("@stxtCity", SqlDbType.Text).Value = txtEditCity.Text; insertSQL.Parameters.Add("@stxtState", SqlDbType.Text).Value = txtEditState.Text; insertSQL.Parameters.Add("@stxtZip", SqlDbType.Text).Value = txtEditZip.Text; insertSQL.CommandType = CommandType.Text; try { insertSQL.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } LoadUserSelect(); }
void LoadGuardians() { comboGuardians.Items.Clear(); SQLiteCommand sqlite_cmd3 = new SQLiteCommand("SELECT * FROM Guardians Where iStudent=@iStudent", sqlite_conn); sqlite_cmd3.Parameters.Add("@iStudent", SqlDbType.Int).Value = Int32.Parse(txtID.Text); try { sqlite_cmd3.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } // Now the SQLiteCommand object can give us a DataReader-Object: SQLiteDataReader sqlite_datareader3 = sqlite_cmd3.ExecuteReader(); // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader3.Read()) // Read() returns true if there is still a result line to read { SQLiteCommand sqlite_cmd2 = new SQLiteCommand("SELECT * FROM People Where id = @id", sqlite_conn); string[] SelectedUser = comboUserSelect.SelectedItem.ToString().Split(':'); int iUserID = Int32.Parse(SelectedUser[0]); sqlite_cmd2.Parameters.Add("@id", SqlDbType.Int).Value = sqlite_datareader3["iPerson"]; try { sqlite_cmd2.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } // Now the SQLiteCommand object can give us a DataReader-Object: SQLiteDataReader sqlite_datareader2 = sqlite_cmd2.ExecuteReader(); // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader2.Read()) // Read() returns true if there is still a result line to read { //Console.WriteLine(String.Format("{0}, {1}", sqlite_datareader["stxtLname"], sqlite_datareader["stxtFname"])); comboGuardians.Items.Add(String.Format("{0}: {1} {2}, {3}", sqlite_datareader2["id"], sqlite_datareader2["stxtFname"], sqlite_datareader2["stxtLname"], sqlite_datareader3["sRelationship"])); } } }
private void comboUserSelect_SelectedIndexChanged(object sender, EventArgs e) { SQLiteCommand sqlite_cmd = new SQLiteCommand("SELECT * FROM People Where id = @id", sqlite_conn); string[] SelectedUser = comboUserSelect.SelectedItem.ToString().Split(':'); int iUserID = Int32.Parse(SelectedUser[0]); sqlite_cmd.Parameters.Add("@id", SqlDbType.Int).Value = iUserID; // Now the SQLiteCommand object can give us a DataReader-Object: sqlite_datareader = sqlite_cmd.ExecuteReader(); // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read { txtID.Text = String.Format("{0}", sqlite_datareader["id"]); txtEditLName.Text = String.Format("{0}",sqlite_datareader["stxtLname"]); txtEditFName.Text = String.Format("{0}", sqlite_datareader["stxtFname"]); txtEditAddress.Text = String.Format("{0}", sqlite_datareader["stxtAddress"]); txtEditCity.Text = String.Format("{0}", sqlite_datareader["stxtCity"]); txtEditState.Text = String.Format("{0}", sqlite_datareader["stxtState"]); txtEditZip.Text = String.Format("{0}", sqlite_datareader["stxtZip"]); } LoadEContacts(); LoadGuardians(); }
private void btnEditPerson_Click(object sender, EventArgs e) { SQLiteCommand updateSQL = new SQLiteCommand("UPDATE People set stxtFname=@stxtFname,stxtLname = @stxtLName, stxtPhone=@stxtPhone, stxtAddress=@stxtAddress,stxtCity=@stxtCity,stxtState=@stxtState,stxtZip=@stxtZip Where id=@id", sqlite_conn); //,stxtLname,stxtPhone,stxtAddress,stxtCity,stxtState,stxtZip Where id = $) VALUES (@id,@stxtFname,@stxtLname,@stxtPhone,@stxtAddress,@stxtCity,@stxtState, @stxtZip)", sqlite_conn); int iUserID = Int32.Parse(txtID.Text); updateSQL.Parameters.Add("@id", SqlDbType.Int).Value = iUserID; updateSQL.Parameters.Add("@stxtFname", SqlDbType.Text).Value = txtEditFName.Text; updateSQL.Parameters.Add("@stxtLname", SqlDbType.Text).Value = txtEditLName.Text; updateSQL.Parameters.Add("@stxtPhone", SqlDbType.Text).Value = txtEditPhone.Text; updateSQL.Parameters.Add("@stxtAddress", SqlDbType.Text).Value = txtEditAddress.Text; updateSQL.Parameters.Add("@stxtCity", SqlDbType.Text).Value = txtEditCity.Text; updateSQL.Parameters.Add("@stxtState", SqlDbType.Text).Value = txtEditState.Text; updateSQL.Parameters.Add("@stxtZip", SqlDbType.Text).Value = txtEditZip.Text; updateSQL.CommandType = CommandType.Text; try { updateSQL.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } LoadUserSelect(); }
private void btnDeletePerson_Click(object sender, EventArgs e) { int iUserID = Int32.Parse(txtID.Text); SQLiteCommand deleteSQL = new SQLiteCommand("Delete from People WHERE id=@id", sqlite_conn); deleteSQL.Parameters.Add("@id", SqlDbType.Int).Value = iUserID; try { deleteSQL.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } LoadUserSelect(); }
private bool SaveConfigToFile(string id, string val) { try { //save the current configuration SetConnection(); sql_con.Open(); sql_cmd = new SQLiteCommand(); sql_cmd.Connection = sql_con; sql_cmd.CommandText = "replace into data(id,value,grp,tbl) values('"+id+"','" + val + "','"+this.sql_grp+"','" + this.sql_tbl + "')"; sql_cmd.ExecuteNonQuery(); sql_con.Close(); return true; } catch (System.Exception e) { MsgDlg.Show(e.Message); return false; } }