public void UpdateTimeStampTest() { string sql = "select * from TEST where int_field = @int_field"; FbTransaction transaction = this.Connection.BeginTransaction(); FbCommand command = new FbCommand(sql, Connection, transaction); FbDataAdapter adapter = new FbDataAdapter(command); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1; FbCommandBuilder builder = new FbCommandBuilder(adapter); DataSet ds = new DataSet(); adapter.Fill(ds, "TEST"); Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count"); DateTime dtValue = DateTime.Now; ds.Tables["TEST"].Rows[0]["TIMESTAMP_FIELD"] = dtValue; adapter.Update(ds, "TEST"); adapter.Dispose(); builder.Dispose(); command.Dispose(); transaction.Commit(); transaction = Connection.BeginTransaction(); sql = "SELECT timestamp_field FROM TEST WHERE int_field = @int_field"; command = new FbCommand(sql, Connection, transaction); command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1; DateTime val = (DateTime)command.ExecuteScalar(); transaction.Commit(); Assert.AreEqual(dtValue.Day, val.Day, "timestamp_field has not correct day"); Assert.AreEqual(dtValue.Month, val.Month, "timestamp_field has not correct month"); Assert.AreEqual(dtValue.Year, val.Year, "timestamp_field has not correct year"); Assert.AreEqual(dtValue.Hour, val.Hour, "timestamp_field has not correct hour"); Assert.AreEqual(dtValue.Minute, val.Minute, "timestamp_field has not correct minute"); Assert.AreEqual(dtValue.Second, val.Second, "timestamp_field has not correct second"); }
public object ExecuteScalar(string sql) { FbCommand cmd = new FbCommand(sql, con); cmd.Connection.Open(); object ret = null; try{ ret = cmd.ExecuteScalar(); }catch (Exception ex) { throw ex; }finally{ cmd.Connection.Close(); } return(ret); }
public void ParametrizedInsertTest(int id, bool?value) { using (var cmd = Connection.CreateCommand()) { cmd.CommandText = "INSERT INTO withboolean (id, bool) VALUES (@id, @bool)"; cmd.Parameters.Add("id", id); cmd.Parameters.Add("bool", value); Assert.DoesNotThrow(() => cmd.ExecuteNonQuery()); } using (FbCommand cmd = Connection.CreateCommand()) { cmd.CommandText = $"SELECT bool FROM withboolean WHERE id = @id"; cmd.Parameters.Add("id", id); Assert.AreEqual(value ?? (object)DBNull.Value, cmd.ExecuteScalar()); } }
public object CleanTable() { connectionString = GlobalSetting.CreateConectionString( @"C:\Users\user\Documents\visual studio 2013\Projects\WpfRandomValue\WPFDatabase.fdb", "SYSDBA", "masterkey", "WIN1250"); using (var conn = new FbConnection(connectionString)) { conn.Open(); var command = new FbCommand(); command.Connection = conn; command.CommandText = "DELETE FROM NUMBERTABLE"; //command.Parameters.Add(); return(command.ExecuteScalar()); } }
public int executeScalar(string sql) { FbCommand cmd = new FbCommand(sql, con); cmd.Transaction = trans; object o = cmd.ExecuteScalar(); if (o != DBNull.Value) { return(Convert.ToInt32(o)); } else { return(0); } }
public int getIdentity() { FbCommand cmd = new FbCommand("SELECT @@IDENTITY", con); cmd.Transaction = trans; object o = cmd.ExecuteScalar(); if (o != null) { return(Convert.ToInt32(o)); } else { return(0); } }
public T GetValueFromSelect <T>(string sql, FbTransaction trans, object parameters = null) { object result; using (var command = new FbCommand(sql, trans.Connection, trans)) { if (parameters != null) { command.Parameters.AddParams(DatabaseEngine.Firebird, parameters); } result = command.ExecuteScalar(); } return(typeof(T) == typeof(object) ? (T)result : result.NGetValue <T, object>()); }
/// <summary> /// Создает таблицу для задач с проверкой дубликации файлов /// </summary> /// <param name="taskName">Имя таблицы</param> public static void CreateTableFingerprint(string taskName) { if (!StartFirebirdService()) { throw new Exception("Не удалось запустить службу Firebird"); } string connStr = @"SELECT 1 FROM RDB$RELATIONS WHERE RDB$RELATION_NAME = '" + taskName + "'"; object result; using (FbConnection connection = new FbConnection(ConnectionString)) { connection.Open(); using (FbCommand command = new FbCommand(connStr, connection)) { using (FbTransaction transaction = connection.BeginTransaction()) { command.Transaction = transaction; result = command.ExecuteScalar(); transaction.Rollback(); } } } if (result != null) { return; } connStr = "CREATE TABLE " + taskName + @" (FILENAME CHAR(255) NOT NULL, HASH CHAR(255) NOT NULL, OPERATIONDATE TIMESTAMP NOT NULL, MODIFYDATE TIMESTAMP NOT NULL );"; using (FbConnection connection = new FbConnection(ConnectionString)) { connection.Open(); using (FbCommand command = new FbCommand(connStr, connection)) { using (FbTransaction transaction = connection.BeginTransaction()) { command.Transaction = transaction; command.ExecuteNonQuery(); transaction.Commit(); } } } }
private void KayitliMi1_CheckedChanged(object sender, EventArgs e) { try { if (KayitliMi1.Checked) { groupBox3.Enabled = true; } else { groupBox3.Enabled = false; musara.Text = ""; SatisMusteri.SelectedIndex = -1; checkBox1.Checked = false; } SatisMusteri.Items.Clear(); FbConnection baglan = new FbConnection(fk.Baglanti_Kodu()); baglan.Open(); FbCommand MustList = new FbCommand("SELECT * FROM Musteriler", baglan); object sonuc = MustList.ExecuteScalar(); if (sonuc != null) { FbDataReader oku = MustList.ExecuteReader(); while (oku.Read()) { SatisMusteri.Items.Add(oku["Musteri_adi"].ToString() + " " + oku["Musteri_soyadi"].ToString()); } SatisMusteri.SelectedIndex = -1; } else { SatisMusteri.Enabled = false; checkBox1.Enabled = false; groupBox3.Enabled = false; MessageBox.Show("Kayıtlı müşteri bulunmamaktadır, müşteri ekleyiniz.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); MusteriEkle me = new MusteriEkle(); me.ShowDialog(); } baglan.Close(); } catch (Exception h1) { MessageBox.Show(h1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Object ExecuteScalar(String sql) { FbCommand cmd = new FbCommand(sql, co); Object o = null; try { o = cmd.ExecuteScalar(); _lastError = ""; } catch (Exception e) { _lastError = e.Message; } return(o); }
/// <summary> /// Executa (ExecuteScalar) e retorna o comando. T é o tipo de objeto de retorno. /// </summary> /// <param name="command"></param> /// <returns></returns> public static T Executar <T>(this FbCommand command) { var temp = command.ExecuteScalar(); if (temp is DBNull) { return(default(T)); } else if (temp != null) { return((T)temp); } else { return(Activator.CreateInstance <T>()); } }
private decimal GetArticlePrice(int articleId) { using (FbConnection fbConnection = new FbConnection(GlobalConstants.FireBirdConnectionString)) { fbConnection.Open(); StringBuilder fbQuery = new StringBuilder(); fbQuery.AppendLine("SELECT a.Price FROM Article as a"); fbQuery.AppendLine($"WHERE a.Id = {articleId}"); using (FbCommand fbCommand = new FbCommand(fbQuery.ToString(), fbConnection)) { decimal price = (decimal)fbCommand.ExecuteScalar(); return(price); } } }
private void KayitliMi2_CheckedChanged(object sender, EventArgs e) { try { SatisMusteriCb.Items.Clear(); FbConnection baglan = new FbConnection(fk.Baglanti_Kodu()); baglan.Open(); FbCommand MustList = new FbCommand("SELECT * FROM Musteriler", baglan); object sonuc = MustList.ExecuteScalar(); if (sonuc != null) { FbDataReader oku = MustList.ExecuteReader(); SatisMusteri.Enabled = true; checkBox3.Enabled = true; while (oku.Read()) { SatisMusteriCb.Items.Add(oku["Musteri_adi"].ToString() + " " + oku["Musteri_soyadi"].ToString()); } SatisMusteriCb.SelectedIndex = 0; } else { SatisMusteri.Enabled = false; checkBox3.Enabled = false; MessageBox.Show("Kayıtlı müşteri bulunmamaktadır.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); SatisMusteriB.Enabled = false; } baglan.Close(); textBox1.Text = ""; checkBox3.Checked = false; if (KayitliMi2.Checked) { SatisMusteriB.Enabled = true; } else { SatisMusteriB.Enabled = false; SatisMusteriCb.SelectedIndex = -1; } } catch (Exception e6) { MessageBox.Show(e6.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool IniciarSesion(string pUsuario, string pPass) { if (_objContextoAD.Conexion.State == ConnectionState.Closed) { _objContextoAD.Conexion.Open(); } string sql = "SELECT COUNT(USUARIO) FROM USUARIOS WHERE USUARIO = @USUARIO AND PASS = @PASS"; FbCommand cmd = new FbCommand(sql, _objContextoAD.Conexion); cmd.Parameters.AddWithValue("@USUARIO", pUsuario.ToLower()); cmd.Parameters.AddWithValue("@PASS", pPass); if (_objContextoAD.EsTransaccion) { cmd.Transaction = _objContextoAD.Transaccion; } return(Convert.ToInt32(cmd.ExecuteScalar()) > 0); }
public User insert(User user) { FbConnection connection = null; FbCommand statement = null; FbTransaction transaction = null; string sql = "execute procedure insert_user(@first_name, @second_name, @third_name, @app, @id_dept, @type, @login, @pass, @e_mail, @hash_pass)"; try { connection = daoFactory.getConnection(); connection.Open(); transaction = connection.BeginTransaction(); statement = new FbCommand(sql, connection); statement.Parameters.Add("@first_name", user.FirstName); statement.Parameters.Add("@second_name", user.SecondName); statement.Parameters.Add("@third_name", user.ThirdName); statement.Parameters.Add("@app", user.Appointment); statement.Parameters.Add("@id_dept", user.Department.idDepartment); statement.Parameters.Add("@type", user.TypeUser); statement.Parameters.Add("@login", user.Login); statement.Parameters.Add("@pass", user.Password); statement.Parameters.Add("@e_mail", user.Email); statement.Parameters.Add("@hash_pass", user.HashPass); int id = Convert.ToInt32(statement.ExecuteScalar()); transaction.Commit(); if (id != 0) { user.Id = (int)id; } } catch (Exception e) { transaction.Rollback(); throw new DAOException("Insert User error ", e); } finally { if (connection != null) { connection.Close(); } } return(user); }
/** * @Kyle van Raaij * Gets a query out of the database table with as name _gridName. * All the parameters connected to the database table _gridName will be acquired as well. * * @_gridName the name of the grid that is stored in the database * @return the query used to get all gridvalues **/ public QueryValues GetGridQuery(string _gridName) { FbConnection conn = dbconn.GetFbConnection(); try { FbCommand cmd = new FbCommand("CCDA_GRIDQUERY", conn); //FbCommand cmd2 = new FbCommand("SELECT P.CCDA_P_NAME, p.CCDA_P_ID FROM CCDA_GRID G LEFT JOIN CCDA_PARAMETER P ON G.CCDA_G_NAME = P.CCDA_P_PARENTNAME", conn); FbCommand cmd2 = new FbCommand("SELECT CCDA_P_NAME, CCDA_P_ID FROM CCDA_PARAMETER WHERE CCDA_P_PARENTNAME = @GRID_NAME", conn); cmd2.CommandType = CommandType.Text; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@GRID_NAME", _gridName); cmd2.Parameters.Add("@GRID_NAME", _gridName); conn.Open(); string query = (string)cmd.ExecuteScalar(); FbDataReader reader = cmd2.ExecuteReader(); QueryValues qValues = new QueryValues(); qValues.Query = query; List <string> values = new List <string>(); if (reader.HasRows) { while (reader.Read()) { values.Add(reader.GetString(0)); } } conn.Close(); qValues.Parameteres = values; return(qValues); } catch (FbException ex) { Console.WriteLine(ex); conn.Close(); return(null); } catch (NullReferenceException ex) { Console.WriteLine(ex); conn.Close(); return(null); } }
public void BinaryBlobTest() { int id_value = GetId(); string selectText = "SELECT blob_field FROM TEST WHERE int_field = " + id_value.ToString(); string insertText = "INSERT INTO TEST (int_field, blob_field) values(@int_field, @blob_field)"; Console.WriteLine("\r\n\r\nBinary Blob Test"); Console.WriteLine("Generating an array of temp data"); // Generate an array of temp data byte[] insert_values = new byte[100000 * 4]; RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider(); rng.GetBytes(insert_values); Console.WriteLine("Executing insert command"); // Execute insert command FbTransaction transaction = Connection.BeginTransaction(); FbCommand insert = new FbCommand(insertText, Connection, transaction); insert.Parameters.Add("@int_field", FbDbType.Integer).Value = id_value; insert.Parameters.Add("@blob_field", FbDbType.Binary).Value = insert_values; insert.ExecuteNonQuery(); transaction.Commit(); Console.WriteLine("Checking inserted values"); // Check that inserted values are correct FbCommand select = new FbCommand(selectText, Connection); byte[] select_values = (byte[])select.ExecuteScalar(); for (int i = 0; i < insert_values.Length; i++) { if (insert_values[i] != select_values[i]) { throw new Exception("differences at index " + i.ToString()); } } Console.WriteLine("Finishing test"); }
private void MusteriEkle_Load(object sender, EventArgs e) { try { ToolTip Aciklama = new ToolTip(); Aciklama.SetToolTip(katekle, "Müşteri Kategorisi Ekle"); FbConnection komut_baglan = new FbConnection(fk.Baglanti_Kodu()); FbDataReader oku; FbCommand cmd = new FbCommand(); object sonuc; komut_baglan.Open(); cmd.Connection = komut_baglan; cmd.CommandText = "SELECT * FROM Musteri_kategori"; sonuc = cmd.ExecuteScalar(); if (sonuc != null) { oku = cmd.ExecuteReader(); while (oku.Read()) { Musteri_kategori.Items.Add(oku[1].ToString()); } Musteri_kategori.SelectedIndex = 0; oku.Close(); Musteri_kategori.Enabled = true; ButonEkle.Enabled = true; } else { Musteri_kategori.Enabled = false; ButonEkle.Enabled = false; MessageBox.Show("Müşteri kategorisi bulunamadı, müşteri kategorisi ekleyiniz", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); MusteriKategoriEkle mke = new MusteriKategoriEkle(); mke.ShowDialog(); } komut_baglan.Close(); } catch (Exception me1) { MessageBox.Show(me1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void UpdateTimeTest() { var sql = "select * from TEST where int_field = @int_field"; var transaction = Connection.BeginTransaction(); var command = new FbCommand(sql, Connection, transaction); var adapter = new FbDataAdapter(command); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1; var builder = new FbCommandBuilder(adapter); var ds = new DataSet(); adapter.Fill(ds, "TEST"); Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count"); var dtValue = new TimeSpan(5, 6, 7); ds.Tables["TEST"].Rows[0]["TIME_FIELD"] = dtValue; adapter.Update(ds, "TEST"); adapter.Dispose(); builder.Dispose(); command.Dispose(); transaction.Commit(); transaction = Connection.BeginTransaction(); sql = "SELECT time_field FROM TEST WHERE int_field = @int_field"; command = new FbCommand(sql, Connection, transaction); command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1; var val = (TimeSpan)command.ExecuteScalar(); transaction.Commit(); Assert.AreEqual(dtValue.Hours, val.Hours, "time_field has not correct hour"); Assert.AreEqual(dtValue.Minutes, val.Minutes, "time_field has not correct minute"); Assert.AreEqual(dtValue.Seconds, val.Seconds, "time_field has not correct second"); }
public void UpdateDateTest() { var sql = "select * from TEST where int_field = @int_field"; var transaction = Connection.BeginTransaction(); var command = new FbCommand(sql, Connection, transaction); var adapter = new FbDataAdapter(command); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1; var builder = new FbCommandBuilder(adapter); var ds = new DataSet(); adapter.Fill(ds, "TEST"); Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count"); var dtValue = DateTime.Now; ds.Tables["TEST"].Rows[0]["DATE_FIELD"] = dtValue; adapter.Update(ds, "TEST"); adapter.Dispose(); builder.Dispose(); command.Dispose(); transaction.Commit(); transaction = Connection.BeginTransaction(); sql = "SELECT date_field FROM TEST WHERE int_field = @int_field"; command = new FbCommand(sql, Connection, transaction); command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1; var val = (DateTime)command.ExecuteScalar(); transaction.Commit(); Assert.AreEqual(dtValue.Day, val.Day, "date_field has not correct day"); Assert.AreEqual(dtValue.Month, val.Month, "date_field has not correct month"); Assert.AreEqual(dtValue.Year, val.Year, "date_field has not correct year"); }
public static void Novi(string korisnickoIme, string sifra) { using (FbConnection con = new FbConnection(Baza.connectionString)) { con.Open(); using (FbCommand cmd = new FbCommand("INSERT INTO KORISNICI (KORISNIKID, KORISNIK, SIFRA) VALUES (((SELECT MAX(KORISNIKID) FROM KORISNICI) + 1), @Korisnik, @Sifra) RETURNING KORISNIKID", con)) { cmd.Parameters.AddWithValue("@Korisnik", korisnickoIme); cmd.Parameters.AddWithValue("@Sifra", sifra); cmd.Parameters.Add("KORISNIKID", FbDbType.Integer).Direction = ParameterDirection.Output; var id = (int)cmd.ExecuteScalar(); Prava.Dodaj(id, 0, 1); } con.Close(); } }
public int GetArticleIdByName(string name) { using (FbConnection fbConnection = new FbConnection(GlobalConstants.FireBirdConnectionString)) { fbConnection.Open(); StringBuilder fbQuery = new StringBuilder(); fbQuery.AppendLine("SELECT Id FROM Article"); fbQuery.AppendLine($"WHERE Name = '{name}'"); using (FbCommand fbCommand = new FbCommand(fbQuery.ToString(), fbConnection)) { int articleId = (int)fbCommand.ExecuteScalar(); return(articleId); } } }
public static string GetParamParentName(string connectionString, int parentId) { string connStr = "SELECT NAME FROM PARAM WHERE PARAMID=" + parentId.ToString() + ";"; using (FbConnection connection = new FbConnection(connectionString)) { connection.Open(); object result; using (FbCommand command = new FbCommand(connStr, connection)) { FbTransaction transaction = connection.BeginTransaction(); command.Transaction = transaction; result = command.ExecuteScalar(); transaction.Rollback(); } return((result == null) ? "" : result.ToString()); } }
public void SimplifiedChineseTest() { string createTable = "CREATE TABLE TABLE1 (FIELD1 varchar(20))"; FbCommand create = new FbCommand(createTable, this.Connection); create.ExecuteNonQuery(); create.Dispose(); // insert using parametrized SQL string sql = "INSERT INTO Table1 VALUES (@value)"; FbCommand command = new FbCommand(sql, this.Connection); command.Parameters.Add("@value", FbDbType.VarChar).Value = "中文"; command.ExecuteNonQuery(); command.Dispose(); sql = "SELECT * FROM TABLE1"; FbCommand select = new FbCommand(sql, this.Connection); string result = select.ExecuteScalar().ToString(); select.Dispose(); Assert.AreEqual("中文", result, "Incorrect results in parametrized insert"); sql = "DELETE FROM TABLE1"; FbCommand delete = new FbCommand(sql, this.Connection); delete.ExecuteNonQuery(); delete.Dispose(); // insert using plain SQL sql = "INSERT INTO Table1 VALUES ('中文')"; FbCommand plainCommand = new FbCommand(sql, this.Connection); plainCommand.ExecuteNonQuery(); plainCommand.Dispose(); sql = "SELECT * FROM TABLE1"; select = new FbCommand(sql, this.Connection); result = select.ExecuteScalar().ToString(); select.Dispose(); Assert.AreEqual("中文", result, "Incorrect results in plain insert"); }
private void Signin(object sender, RoutedEventArgs e) { string name = signinName.Text; string pass1 = signinPass.Text; string pass2 = signinPass2.Text; if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(pass1) || string.IsNullOrEmpty(pass2)) { MessageBox.Show("Something is Empty!"); return; } if (pass1 != pass2) { MessageBox.Show("The re-password does not match!"); return; } using (FbConnection conn = new FbConnection(@"Server=localhost;User=SYSDBA;Password=admin;Database=C:\Users\Norbert\Documents\Visual Studio 2015\Projects\NCarRental\NCarRental\_Resources\DB.FDB")) using (FbCommand cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandText = "select name from users where name=@name"; cmd.Parameters.Add("name", name); var result = cmd.ExecuteScalar(); if (result != null) { MessageBox.Show("The username is already taken!"); return; } cmd.CommandText = "insert into users(name, pass, balance) values (@name, @pass, @balance)"; cmd.Parameters.Add("pass", pass1); cmd.Parameters.Add("balance", 20000); cmd.ExecuteNonQuery(); MessageBox.Show("Done!"); signinName.Text = ""; signinPass.Text = ""; signinPass2.Text = ""; } }
private void btnAccept_Click(object sender, RoutedEventArgs e) { if (nameTB.Text == "") { MessageBox.Show("Podaj imię autora!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (surnameTB.Text == "") { MessageBox.Show("Podaj nazwisko autora!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); return; } FbCommand command = new FbCommand("select count(*) from AUTORZY where IMIE = '" + nameTB.Text + "' and NAZWISKO = '" + surnameTB.Text + "' " + "and ID_AUTOR <> " + id, connection); Int32 result = (Int32)command.ExecuteScalar(); if (result > 0) { MessageBox.Show("Podany autor już istnieje!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); return; } else { if (isEdit) { command = new FbCommand("update AUTORZY set IMIE = '" + nameTB.Text + "' and NAZWISKO = '" + surnameTB.Text + "' where ID_AUTOR = " + id, connection); result = command.ExecuteNonQuery(); } else { command = new FbCommand("insert into AUTORZY (IMIE, NAZWISKO) values ('" + nameTB.Text + "', '" + surnameTB.Text + "')", connection); result = command.ExecuteNonQuery(); } } if (result != 0) { MessageBox.Show("Operacja powiodła się!", "Sukces", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("Operacja nie powiodła się!", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); } this.Close(); }
public void CreateTableIfNotExists(string tableName, string tableStruct) { using (var conn = new FbConnection(_connectionString)) { conn.Open(); using (var command = new FbCommand("select 1 from rdb$relations where rdb$relation_name = '" + tableName.ToUpper() + "';", conn)) { var res = command.ExecuteScalar(); if (res == null) { using (var cmd = new FbCommand("create table " + tableName + tableStruct + ";", conn)) { cmd.ExecuteNonQuery(); } } } } }
private void uyeMi_CheckedChanged(object sender, EventArgs e) { try { if (uyeMi.Checked) { FbConnection baglan = new FbConnection(fk.Baglanti_Kodu()); baglan.Open(); FbCommand MusSql = new FbCommand("SELECT Musteri_adi,Musteri_soyadi FROM Musteriler", baglan); object Mvarmi = MusSql.ExecuteScalar(); if (Mvarmi != null) { FbDataReader MusOku = MusSql.ExecuteReader(); while (MusOku.Read()) { musteri.Items.Add(MusOku["Musteri_adi"].ToString() + " " + MusOku["Musteri_soyadi"].ToString()); } uyeyse.Enabled = true; uyedegilse.Enabled = false; musteri.SelectedIndex = 0; } else { DialogResult MusEkle = MessageBox.Show("Sistemde müşteri bulunmamaktadır, yeni müşteri eklemek ister misiniz?", "Bilgilendirme", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (MusEkle == DialogResult.Yes) { MusteriEkle me = new MusteriEkle(); me.ShowDialog(); } } baglan.Close(); } else { uyeyse.Enabled = false; uyedegilse.Enabled = true; } } catch (Exception e1) { MessageBox.Show(e1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void RunInstance() { int i = 0; int errors = 0; // restrict number of errors here to avoid endless output int maxErrors = 5; while (i < maxCycles) { FbCommand singleUsedCommand = new FbCommand(commandText, connection); try { connection.Open(); object result1 = multipleUsedCommand.ExecuteScalar(); object result2 = singleUsedCommand.ExecuteScalar(); // following line prevents errors //singleUsedCommand.Dispose(); } catch (Exception ex) { Console.WriteLine("{0} instance {1}, cycle {2}, {3}", DateTime.Now, id, i + 1, ex.Message); if (errors < maxErrors) { errors++; } else { break; } } finally { connection.Close(); i++; } // inner connection can be used by another instance Thread.Sleep(50); } }
private void UrunEkle_Load(object sender, EventArgs e) { try { ToolTip Aciklama = new ToolTip(); Aciklama.SetToolTip(katekle, "Ürün Kategorisi Ekle"); FbConnection komut_baglan = new FbConnection(fk.Baglanti_Kodu()); FbDataReader oku; FbCommand cmd = new FbCommand(); object sonuc; komut_baglan.Open(); cmd.Connection = komut_baglan; cmd.CommandText = "SELECT * FROM Urun_kategori"; sonuc = cmd.ExecuteScalar(); if (sonuc != null) { oku = cmd.ExecuteReader(); while (oku.Read()) { UrunKategori.Items.Add(oku[1].ToString()); } UrunKategori.SelectedIndex = 0; oku.Close(); } else { MessageBox.Show("Ürün ekleyebilmek için önce ürün kategorisi ekleyin", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); UrunKategoriEkle uke = new UrunKategoriEkle(); uke.ShowDialog(); } komut_baglan.Close(); } catch (Exception e1) { MessageBox.Show(e1.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } }