/// <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);
}
