/// <summary> /// Run SQL Query over Excel file /// </summary> /// <param name="sql"> /// SQL Query to run /// </param> /// <param name="dataTable"> /// DataSet with result /// </param> /// <returns> /// True if operation completed successfully /// </returns> public void RunSql(string sql, ref DataTable dataTable) { OleDbConnection oConn = null; OleDbCommand oComm = null; OleDbDataReader oRdr = null; try { String sConnString = BuildConnectionString(); oConn = new OleDbConnection(sConnString); oConn.Open(); String sCommand = sql; oComm = new OleDbCommand(sCommand, oConn); oRdr = oComm.ExecuteReader(); dataTable.Load(oRdr); } finally { oRdr?.Close(); oRdr = null; oComm?.Dispose(); oConn.Close(); oConn.Dispose(); } }
protected virtual void Dispose(bool disposing) { if (!disposedValue) { if (disposing) { command?.Dispose(); conn?.Dispose(); wDSResults?.Dispose(); } // TODO: free unmanaged resources (unmanaged objects) and override finalizer // TODO: set large fields to null disposedValue = true; } }
/// <summary> /// 关闭数据库连接 /// </summary> public void CloseConnection() { UnityModule.DebugPrint("关闭数据库连接..."); try { if (DataBaseConnection == null) { return; } DataBaseConnection?.Close(); DataBaseConnection?.Dispose(); DataBaseCommand?.Dispose(); DataBaseConnection = null; DataBaseCommand = null; } catch (Exception ex) { UnityModule.DebugPrint("关闭数据库连接时遇到错误:", ex.Message); } }
/// <summary> /// 执行带一个存储过程参数的的SQL语句。 /// </summary> /// <param name="SQLString">SQL语句</param> /// <param name="content">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param> /// <returns>影响的记录数</returns> public static int ExecuteSql(string SQLString, string content) { using OleDbConnection connection = new OleDbConnection(string.Format(connectionString, App.project_path)); OleDbCommand cmd = new OleDbCommand(SQLString, connection); OleDbParameter myParameter = new OleDbParameter("@content", OleDbType.VarChar); myParameter.Value = content; cmd.Parameters.Add(myParameter); try { connection.Open(); int rows = cmd.ExecuteNonQuery(); return(rows); } catch (System.Data.OleDb.OleDbException E) { throw new Exception(E.Message); } finally { cmd.Dispose(); connection.Close(); } }
private void btnAllReset_Click(object sender, EventArgs e) { if (MessageBox.Show("모든 데이터를 초기화 하시겠습니까?", "정산", MessageBoxButtons.OKCancel) == DialogResult.OK) { string deleteQuery = "DELETE FROM precontract"; OleDbCommand OLECmd = new OleDbCommand(deleteQuery, conn); OLECmd.CommandType = CommandType.Text; OLECmd.ExecuteNonQuery(); OLECmd.Dispose(); deleteQuery = "DELETE FROM contract"; OLECmd = new OleDbCommand(deleteQuery, conn); OLECmd.CommandType = CommandType.Text; OLECmd.ExecuteNonQuery(); OLECmd.Dispose(); deleteQuery = "DELETE FROM paytable"; OLECmd = new OleDbCommand(deleteQuery, conn); OLECmd.CommandType = CommandType.Text; OLECmd.ExecuteNonQuery(); OLECmd.Dispose(); } }
private void btnCariDelete_Click(object sender, EventArgs e) { if (txtNpmDelete.Text.Length == 0) { MessageBox.Show("NPM harus !!!", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtNpmDelete.Focus(); return; } OleDbConnection conn = GetOpenConnection(); string sql = @"select npm, nama, angkatan from mahasiswa where npm = @npm"; OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.Parameters.AddWithValue("@npm", txtNpmDelete.Text); OleDbDataReader dtr = cmd.ExecuteReader(); // eksekusi perintah SELECT if (dtr.Read()) // data ditemukan { txtNpmDelete.Text = dtr["npm"].ToString(); txtNamaDelete.Text = dtr["nama"].ToString(); txtAngkatanDelete.Text = dtr["angkatan"].ToString(); } else { MessageBox.Show("Data mahasiswa tidak ditemukan !", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information); } dtr.Dispose(); cmd.Dispose(); conn.Dispose(); }
/// <summary> /// 查询数据 /// </summary> /// <param name="strExetuceOrder">sql</param> /// <returns></returns> public DataTable selectData(string strExetuceOrder) { try { cmd.CommandText = strExetuceOrder; conn.Open(); OleDbDataReader odr = cmd.ExecuteReader(); DataTable dt = new DataTable(); if (odr.HasRows) { for (int i = 0; i < odr.FieldCount; i++) { dt.Columns.Add(odr.GetName(i)); } dt.Rows.Clear(); } while (odr.Read()) { DataRow row = dt.NewRow(); for (int i = 0; i < odr.FieldCount; i++) { row[i] = odr[i]; } dt.Rows.Add(row); } cmd.Dispose(); conn.Close(); return(dt); } catch (Exception ex) { LogWriter.WriteLogInfo(DateTime.Now.ToString() + ":" + ex.ToString(), LOGSTATE.Error); return(new DataTable()); } }
public static void luudl(String txttenlop, String txtmagv, String txtmalop) { //tao kết nối tới file Access KetNoi_CSDL(); //tao đối tương command OleDbCommand objCommand = new OleDbCommand(); objCommand.Connection = cnnqlgd; objCommand.CommandType = CommandType.Text; objCommand.CommandText = "Update LOP " + "Set TEN_LOP = @TEN_LOP, MA_GV = @MA_GV " + "Where MA_LOP = @MA_LOP"; objCommand.Parameters.Add("@TEN_LOP", OleDbType.VarChar).Value = txttenlop; objCommand.Parameters.Add("@MA_GV", OleDbType.VarChar).Value = txtmagv; objCommand.Parameters.Add("@MA_LOP", OleDbType.VarChar).Value = txtmalop; objCommand.ExecuteNonQuery(); // hủy đối tượng objCommand.Dispose(); objCommand = null; HuyKetNoi_CSDL(); }
private void btnCancelar_Click(object sender, EventArgs e) { OleDbConnection conDeshacerVenta; OleDbCommand cmdDeshacerVenta; string strSQL_Delete = "DELETE FROM TEMP_VENTAS "; try { conDeshacerVenta = new OleDbConnection(Conexion.CnnStr); conDeshacerVenta.Open(); cmdDeshacerVenta = new OleDbCommand(strSQL_Delete, conDeshacerVenta); cmdDeshacerVenta.ExecuteNonQuery(); cmdDeshacerVenta.Dispose(); conDeshacerVenta.Close(); ReadData(varUSER_LOGIN, varID_CAJA); txtID_PRODUCTO.Text = ""; txtCANTIDAD.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message, "DeshacerVenta"); } }
/// <summary> /// 解析Excel到DataTable 》》多表 /// </summary> /// <param name="filePath"></param> /// <returns></returns> public static DataTable GegDataTabelExcelContentAll(string filePath) { //excel2007,兼容2003 string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';"; System.Data.OleDb.OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(strCon); myConn.Open(); //获取excel第一标签名 DataTable dt = new DataTable(); DataTable schemaTable = myConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null); int DataNum = schemaTable.Rows.Count; for (int i = 0; i < DataNum; i++) { string tableName = schemaTable.Rows[i][2].ToString().Trim(); //标签名 string strCom = "SELECT * FROM [" + tableName + "]"; //查询语句 OleDbCommand ocmd = null; try { ocmd = new OleDbCommand(strCom, myConn); OleDbDataAdapter oda = new OleDbDataAdapter(ocmd); oda.Fill(dt); } catch (OleDbException oex) { dt = null; throw oex; } finally { myConn.Close(); ocmd.Dispose(); } } return(dt); }
static public bool DownLoadXml(string fileID, string filePath) { bool ret = true; string errMsg = ""; try { OleDbConnection db2conn = new OleDbConnection(DBdb2.SetConString()); string sqlstr = "select * from T_SYS_MENU where T_XMLID='" + fileID + "'"; OleDbCommand db2cmd = new OleDbCommand(sqlstr, db2conn); db2conn.Open(); OleDbDataReader db2reader = db2cmd.ExecuteReader(); string FileName = filePath; if (!db2reader.Read()) { FileName = ""; } else { byte[] bytes = (byte[])db2reader["B_XML"]; FileStream fs = new FileStream(FileName, FileMode.Create, FileAccess.Write); fs.Write(bytes, 0, bytes.Length); fs.Flush(); fs.Close(); } db2reader.Close(); db2cmd.Dispose(); db2conn.Close(); } catch (Exception ce) { errMsg = ce.Message; ret = false; } return(ret); }
public override DataRow GetDataRow(string storeProcedureName, IDbDataParameter[] parameters) { if (connection.State == ConnectionState.Closed) { connection.Open(); } DataRow dataRow = null; DataRow row2; try { IDbCommand cmd = new OleDbCommand(); cmd.Connection = connection; cmd.CommandText = storeProcedureName; cmd.CommandType = CommandType.StoredProcedure; SetParameters(cmd, parameters); dataRow = this.GetDataRow(cmd); ReturnParameters(cmd, parameters); cmd.Dispose(); cmd = null; row2 = dataRow; } catch (Exception e) { throw new Exception("操作数据库失败!参考:" + e.Message); } finally { if (connection.State != ConnectionState.Closed) { connection.Close(); } } return(row2); }
private void simpleButton2_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Sayın " + txtMusteriAd.Text + " " + txtMusteriSoyad.Text + " Ürününüz iade edilmesini Onaylıyormusunuz", "Bildirim Penceresi", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { baglan.Open(); komut2.Connection = baglan; komut2.CommandText = "Delete from Satislar where MusteriNo='" + Convert.ToInt16(txtMusteriNo.Text.ToString()) + "'"; komut2.ExecuteNonQuery(); komut2.Dispose(); baglan.Close(); baglan.Open(); OleDbCommand komut3 = new OleDbCommand("Select *from Stok where UrunAdi='" + txtUrunAdi.Text + "'", baglan); OleDbDataReader dr = komut3.ExecuteReader(); if (dr.Read()) { lblAdet.Text = dr["UrunAdedi"].ToString(); lblUrunNO.Text = dr["StokNo"].ToString(); } baglan.Close(); baglan.Open(); int adet = Convert.ToInt16(lblAdet.Text); int kalan = adet + Convert.ToInt16(txtMusteriAdet.Text); lblAdet.Text = kalan.ToString(); komut3.CommandText = "update Stok set UrunAdedi='" + kalan.ToString() + "'where StokNo='" + lblUrunNO.Text + "'"; komut3.ExecuteNonQuery(); baglan.Close(); listView1.Items.Clear(); listRenklendir(); temizle(); } }
public dynamic DBCommandReadData(string query, string data) { var word = ""; cn.ConnectionString = cnnString; if (cn.State == ConnectionState.Closed) { cn.Open(); command = new OleDbCommand(); command.Connection = cn; command.CommandType = CommandType.Text; command.CommandText = query; reader = command.ExecuteReader(); if (reader.Read() == true) { word = reader[data].ToString().ToUpper(); } } cn.Close(); command.Dispose(); return(word); }
/// <summary> /// 向数据库里插入图像格式的字段(和上面情况类似的另一种实例) /// </summary> /// <param name="strSQL">SQL语句</param> /// <param name="fs">图像字节,数据库的字段类型为image的情况</param> /// <returns>影响的记录数</returns> public static int ExecuteSqlInsertImg(string strSQL, byte[] fs) { using OleDbConnection connection = new OleDbConnection(string.Format(connectionString, App.project_path)); OleDbCommand cmd = new OleDbCommand(strSQL, connection); OleDbParameter myParameter = new OleDbParameter("@fs", OleDbType.Binary); myParameter.Value = fs; cmd.Parameters.Add(myParameter); try { connection.Open(); int rows = cmd.ExecuteNonQuery(); return(rows); } catch (OleDbException E) { throw new Exception(E.Message); } finally { cmd.Dispose(); connection.Close(); } }
/// <summary> /// 执行带一个存储过程参数的的SQL语句(参数名为content) /// </summary> /// <param name="p_strSql">SQL语句</param> /// <param name="p_strContent">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param> /// <returns>影响的记录数</returns> public static int ExecuteSql(string p_strSql, string p_strContent) { using (OleDbConnection connection = new OleDbConnection(connectionString)) { OleDbCommand cmd = new OleDbCommand(p_strSql, connection); OleDbParameter oleDbPara = new OleDbParameter("@content", OleDbType.VarChar); oleDbPara.Value = p_strContent; cmd.Parameters.Add(oleDbPara); try { Open(connection); return(cmd.ExecuteNonQuery()); } catch (OleDbException E) { throw new Exception(E.Message); } finally { cmd.Dispose(); Close(connection); } } }
/// <summary> /// 向数据库里插入图像格式的字段(图像参数名为image) /// </summary> /// <param name="p_strSql">SQL语句</param> /// <param name="p_byteFs">图像字节,数据库的字段类型为image的情况</param> /// <returns>影响的记录数</returns> public static int ExecuteSqlInsertImg(string p_strSql, byte[] p_byteImagee) { using (OleDbConnection connection = new OleDbConnection(connectionString)) { OleDbCommand cmd = new OleDbCommand(p_strSql, connection); OleDbParameter myParameter = new OleDbParameter("@image", OleDbType.Binary); myParameter.Value = p_byteImagee; cmd.Parameters.Add(myParameter); try { Open(connection); return(cmd.ExecuteNonQuery()); } catch (OleDbException exp) { throw new Exception(exp.Message); } finally { cmd.Dispose(); Close(connection); } } }
public static DataSet FL_get_oledb_dataset(string Constring, string Query) { var ds = new DataSet("data_set"); try { var connection = new OleDbConnection(Constring); var cmd = new OleDbCommand(Query, connection); connection.Con_switch(); var da = new OleDbDataAdapter(cmd); var dt = new DataTable(); da.Fill(dt); ds.Locale = Thread.CurrentThread.CurrentCulture; ds.Tables.Add(dt); connection.Con_switch(); cmd.Dispose(); connection.Dispose(); } catch (OleDbException e) { MessageBox.Show("Error : " + e.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } return(ds); }
public static int SetAddInstruction(string client_id, string acct_type, string acct, string symbol, string tradeside, string ord_qty, string ord_price, string ord_type) { int count = -1; lock (InstructionSync) { string sql = string.Format(@"insert into instructions (inst_type, client_id, acct_type, acct, symbol, tradeside, ord_qty, ord_price, ord_type, ord_no, ord_param) values('O', '{0}', '{1}', '{2}', '{3}', '{4}', {5}, {6}, '{7}', '', '')", client_id, acct_type, acct, symbol, tradeside, decimal.Parse(ord_qty), decimal.Parse(ord_price), ord_type); using (OleDbConnection conn = new OleDbConnection(ConnectionString)) { conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); //cmd.Parameters.AddWithValue("@inst_type", "0"); //cmd.Parameters.AddWithValue("@client_id", client_id); //cmd.Parameters.AddWithValue("@acct_type", acct_type); //cmd.Parameters.AddWithValue("@acct", acct); //cmd.Parameters.AddWithValue("@symbol", symbol); //cmd.Parameters.AddWithValue("@tradeside", tradeside); //cmd.Parameters.AddWithValue("@ord_qty", ord_qty); //cmd.Parameters.AddWithValue("@ord_price", ord_price); //cmd.Parameters.AddWithValue("@ord_type", ord_type); try { count = cmd.ExecuteNonQuery(); cmd.Dispose(); } catch (Exception ex) { string s = ex.Message + ex.StackTrace; Utils.logger.LogInfo(s); return(-1); } } } return(count); }
private void button2_Click(object sender, EventArgs e) { conn.Open(); string insert = " INSERT INTO RezervariCamere([NrCamera],[DataStart],[DataStop],[Specificatii]) Values( '" + cboCamera.Text + "','" + checkIn.Value + "','" + checkOut.Value + "','" + txtSpecificatii.Text + "')"; OleDbCommand cmdInsert; OleDbDataAdapter adapter = new OleDbDataAdapter(); cmdInsert = new OleDbCommand(insert, conn); try { // inserarea in conturi adapter.InsertCommand = new OleDbCommand(insert, conn); adapter.InsertCommand.ExecuteNonQuery(); cmdInsert.Dispose(); MessageBox.Show("Rezervarea dumneavoastra a fost inregistrata"); } catch (OleDbException ex) { MessageBox.Show(ex.Message); } }
public static void Select_HasOneParameter(string Query_Select, BindingSource MyBindSource, string ParameterName, string ParameterValue) { //1.Khởi tạo kết nối với file Access CreateConnect(); //2.Thiết lập đối tượng OleDbCommand OleDbCommand MyCommand = new OleDbCommand(); MyCommand.Connection = MyConnect; MyCommand.CommandType = CommandType.StoredProcedure; MyCommand.CommandText = Query_Select; //3.Thêm tham số cho câu lệnh Query MyCommand.Parameters.Add(ParameterName, OleDbType.VarChar).Value = ParameterValue; //4.Thực hiện câu lệnh query và đổ dữ liệu vào DataTable OleDbDataReader MyReader = MyCommand.ExecuteReader(); DataTable MyTable = new DataTable(); MyTable.Load(MyReader); MyBindSource.DataSource = MyTable; //5.Dùng xong thì hủy các đối tượng không cần thiết MyCommand.Parameters.Clear(); MyCommand.Dispose(); MyCommand = null; DestroyConnect(); }
public void VeriSil1(int id, DataGridView grid) { try { DialogResult cevap; cevap = MessageBox.Show("Kaydı silmek istediğinizden emin misiniz ?", "Uyarı !", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (cevap == DialogResult.Yes) { baglantiac(); komut = new OleDbCommand(); komut.Connection = baglanti; komut.CommandText = "delete from tbl_insaat where id =" + id; komut.ExecuteNonQuery(); Goster1(grid); komut.Dispose(); } } catch (Exception) { MessageBox.Show("Lütfen listeden bir alan seçiniz.", "UYARI"); } }
public static void Log_permissão(string nome, string data) { string strConnection = "Data Source=.\\SQLEXPRESS;Initial Catalog=chave;User ID=sa;Password=#lecoteco1975 ;Provider=SQLOLEDB"; //define a instrução SQL para somar Quantidade e agrupar resultados String strSQL = "Log_permissão"; //cria a conexão com o banco de dados OleDbConnection dbConnection = new OleDbConnection(strConnection); //cria a conexão com o banco de dados OleDbConnection con = new OleDbConnection(strConnection); //cria o objeto command para executar a instruçao sql OleDbCommand cmd = new OleDbCommand(strSQL, con); //abre a conexao con.Open(); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@Nome", nome); //cmd.Parameters.AddWithValue("@Telefone", telefone); //cmd.Parameters.AddWithValue("@Endereço", endereço); cmd.Parameters.AddWithValue("@Data", data); //cria um dataadapter OleDbDataAdapter da = new OleDbDataAdapter(cmd); //cria um objeto datatable DataTable clientes = new DataTable(); //preenche o datatable via dataadapter da.Fill(clientes); con.Dispose(); con.Close(); cmd.Dispose(); dbConnection.Dispose(); dbConnection.Close(); }
private void Load_Utilizatori() { if (cnn.State == ConnectionState.Open) { cnn.Close(); } try { string strCom = "Select NumeUtilizator from Utilizatori"; cnn.ConnectionString = CnnStr; cnn.Open(); OleDbCommand Comm = new OleDbCommand(strCom, cnn); OleDbDataReader dr = Comm.ExecuteReader(); cmbUtilizatori.Items.Clear(); cmbUtilizatori.Items.Add("Selectati utilizator"); while (dr.Read()) { cmbUtilizatori.Items.Add(dr[0]); } cmbUtilizatori.SelectedIndex = 0; Comm.Dispose(); cnn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "SMS", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 执行SQL语句,返回影响的记录数 /// </summary> /// <param name="SQLString">SQL语句</param> /// <returns>影响的记录数</returns> public static void RunSql(string SQLString) { using (OleDbConnection connection = new OleDbConnection(connectionString)) { using (OleDbCommand cmd = new OleDbCommand(SQLString, connection)) { try { connection.Open(); cmd.ExecuteNonQuery(); } catch (System.Data.OleDb.OleDbException e) { connection.Close(); throw e; } finally { cmd.Dispose(); connection.Close(); } } } }
public void PointSet(double point, int ID) { /*string sqlstr = "select Point from Menu where ID="; * sqlstr += "'" + ID + "'"; * command = connect.CreateCommand(); * command.CommandText = sqlstr; * OleDbDataReader reader = command.ExecuteReader(); * while (reader.Read()) * { * bpoint = reader["Point"].ToString(); * count = reader["Count"].ToString(); * } * int npoint = (int.Parse(bpoint) + point) / int.Parse(count); */ string Ppoint = point.ToString(); string sqlstr = "Update Menu Set Point="; sqlstr += "'" + Ppoint + "'"; sqlstr += "WHERE ID="; sqlstr += ID; command = new OleDbCommand(sqlstr, connect); command.ExecuteNonQuery(); command.Dispose(); }
private void BtnTest_Click(object sender, EventArgs e) { OleDbCommand resultsCommand = null; OleDbDataAdapter resultsAdapter = new OleDbDataAdapter(); DataTable resultsTable = new DataTable(); try { // establish command object and data adapter resultsCommand = new OleDbCommand(txtSQLTester.Text, booksConnection); resultsAdapter.SelectCommand = resultsCommand; resultsAdapter.Fill(resultsTable); // bind grid view to data table grdSQLTester.DataSource = resultsTable; lblRecords.Text = resultsTable.Rows.Count.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error in Processing SQL", MessageBoxButtons.OK, MessageBoxIcon.Error); } resultsCommand.Dispose(); resultsAdapter.Dispose(); resultsTable.Dispose(); }
public void GetOrderBytime(string time, ListView list, string ID) { command = new OleDbCommand(); command = connect.CreateCommand(); string sqlstr = "SELECT * from Orderlist WHERE Time LIKE"; sqlstr += "'" + time + "%" + "'"; sqlstr += " " + "AND" + " " + "ID="; sqlstr += "'" + ID + "'"; command.CommandText = sqlstr; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { foodmenu = new ListViewItem(); foodmenu.SubItems[0].Text = reader["ID"].ToString(); foodmenu.SubItems.Add(reader["FoodName"].ToString()); foodmenu.SubItems.Add(reader["Num"].ToString()); foodmenu.SubItems.Add(reader["Price"].ToString()); foodmenu.SubItems.Add(reader["Time"].ToString()); list.Items.Add(foodmenu); } command.Dispose(); }
private void btn_update_Click(object sender, EventArgs e) { int idi = 0; if (!string.IsNullOrEmpty(lblid.Text)) { idi = Convert.ToInt32(lblid.Text); } else { idi = 0; } string sorgu = "UPDATE dersler SET ders_adi='" + txt_ders_adi.Text + "' , ders_kodu='" + txt_ders_kodu.Text + "', ders_gunu='" + cbox_dersgunu.Text + "',ders_saati='" + maskedTextBox_dersssati.Text + "',sinif_sube='" + cbox_sube.Text + "' where ders_no = " + idi + ""; OleDbCommand kmt = new OleDbCommand(sorgu, bag); bag.Open(); kmt.ExecuteNonQuery(); kmt.Dispose(); bag.Close(); MessageBox.Show("işleminiz başarılı"); listele(); }
public static List <DataRow> GetKeysWithValuesFromGroup(string group) { List <DataRow> keysWithValues = new List <DataRow>(); OleDbCommand command = new OleDbCommand(); command.Connection = m_Connection; command.CommandText = "SELECT " + m_OptionsTableName + "." + m_KeysColumnName + ", " + m_OptionsTableName + "." + m_ValuesColumnName + " FROM " + m_OptionsTableName + " WHERE " + m_OptionsTableName + "." + m_GroupsColumnName + " LIKE '" + group + "'"; DataSet dataSet = new DataSet(); OleDbDataAdapter adapter = new OleDbDataAdapter(); try { adapter.SelectCommand = command; adapter.Fill(dataSet, m_OptionsTableName); foreach (DataRow row in dataSet.Tables[m_OptionsTableName].Rows) { keysWithValues.Add(row); } } catch (Exception e) { MessageBox.Show("Не удалось получить ключи со значениями группы " + group + " из таблицы " + m_OptionsTableName + "." + Environment.NewLine + e.Message); } finally { command.Dispose(); dataSet.Dispose(); adapter.Dispose(); } return(keysWithValues); }