public void CloseCommand() { try { oCommand.Cancel(); oCommand.Dispose(); oCommand = null; return; } catch { return; } }
private void btnLogin_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand("Select * From employee Where employee_id = ? and employee_pwd =?", conn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("employee_id", this.txtId.Text); cmd.Parameters.AddWithValue("employee_pwd", this.txtPwd.Text); conn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); //管理員登入 if ((this.txtId.Text.Trim() == "admin" && this.txtPwd.Text == "123456")) { Session["admin_id"] = this.txtId.Text; Response.Redirect("aOrder_List.aspx"); } //一般使用者登入 else if (dr.Read()) { Session["employee_no"] = dr[0]; Session["employee_name"] = dr[3]; cmd.Cancel(); dr.Close(); conn.Close(); conn.Dispose(); Response.Redirect("uOrder_List.aspx"); } else { this.lblRemind.Text = "帳號或密碼有誤,請重新輸入。"; return; } }
public void ProcessRequest(HttpContext context) { sOrder_no = context.Request.QueryString["order_no"]; // 傳入的資料 string order = context.Request["order"] ?? string.Empty; // 反序列化資料:將JSON格式轉換成物件 List <Data> data = JsonConvert.DeserializeObject <List <Data> >(order); // 訂單資料存入資料庫 string sSql = @"Insert Into filledIn(order_no, employee_no, filledin_date, item_name, quantity, item_price, filledIn_remark) Values(?,?,?,?,?,?,?)"; OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); conn.Open(); OleDbCommand cmd = new OleDbCommand(sSql, conn); for (int intA = 0; intA < data.Count; intA++) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("order_no", sOrder_no); cmd.Parameters.AddWithValue("employee_no", context.Session["employee_no"].ToString()); cmd.Parameters.AddWithValue("filledin_date", DateTime.Now.ToString("yyyy/MM/dd HH:mm")); cmd.Parameters.AddWithValue("item_name", data[intA].Name); cmd.Parameters.AddWithValue("quantity", data[intA].Quantity); cmd.Parameters.AddWithValue("item_price", data[intA].Price); cmd.Parameters.AddWithValue("filledIn_remark", data[intA].Remark); cmd.ExecuteNonQuery(); } cmd.Cancel(); conn.Close(); // 回傳資料並序列化成JSON context.Response.Write(JsonConvert.SerializeObject(data)); }
// 輸出訂單資料 private void Inititle() { string sSql = "Select * From dessert_order A Left Join store B On A.store_no = B.store_no Where A.order_no = ?"; OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand(sSql, conn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("order_no", sOrder_no); conn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { this.lblStoreName.Text = dr["store_name"].ToString(); this.lblPhone.Text = dr["store_phone"].ToString(); this.lblAddress.Text = dr["store_address"].ToString(); this.lblRemark.Text = dr["store_remark"].ToString(); this.txtStartDate.Text = dr["start_date"].ToString(); this.txtEndDate.Text = dr["end_date"].ToString(); this.txtOrderRemark.Text = dr["order_remark"].ToString(); } else { Server.Transfer("~/ErrorPages/aOops.aspx"); } cmd.Cancel(); dr.Close(); }
public static string GetGameStoragePrice(string storageid) { string price = ""; string strPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\" + DBName + ".accdb"; string conStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + strPath; OleDbConnection conn = new OleDbConnection(conStr); conn.Open(); OleDbCommand command = new OleDbCommand("select * from StorageInfo where ID = " + storageid, conn); OleDbDataReader dr = command.ExecuteReader(); if (dr.Read()) { price = dr.GetString(dr.GetOrdinal("price")); } dr.Close(); dr = null; command.Cancel(); command.Dispose(); command = null; conn.Close(); conn.Dispose(); conn = null; return(price); }
// 取得店家基本資料 private void GetStoreData() { OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand("Select * From store Where store_no = ?", conn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("aStore_no", sStore_no); conn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { this.txtStore.Text = dr.GetString(1); this.txtPhone.Text = dr.GetString(2); this.txtAddress.Text = dr.GetString(3); this.txtRemark.Text = dr.GetString(4); } else { Server.Transfer("~/ErrorPages/aOops.aspx"); } cmd.Cancel(); dr.Close(); }
protected void Page_Load(object sender, EventArgs e) { OleDbConnection Conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbDataReader dr = null; OleDbCommand cmd = new OleDbCommand("SELECT [商品ID], [商品名稱] FROM [商品主黨]", Conn); try //==== 以下程式,只放「執行期間」的指令!===================== { Conn.Open(); dr = cmd.ExecuteReader(); } catch (Exception ex) { Response.Write("<b>Error Message---- </b>" + ex.ToString() + "<HR/>"); } finally { if (dr != null) { cmd.Cancel(); dr.Close(); } if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } }
// 刪除資料 private void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string sSql = "Delete From item Where item_no = ?"; try { OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand(sSql, conn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("item_no", this.GridView1.DataKeys[e.RowIndex].Value.ToString()); conn.Open(); cmd.ExecuteNonQuery(); cmd.Cancel(); conn.Close(); // 重新綁定資料 DataTable dt = (DataTable)ViewState["dt"]; dt.Rows.RemoveAt(e.RowIndex); ViewState["dt"] = dt; BindItem(); GetCategory(); } catch (Exception ex) { this.divAlert.Style.Add("display", "block"); this.lblAlert.Text = "Error : " + ex.Message; } }
/// <summary> /// 此为搜索使用 /// </summary> /// <returns></returns> public static List <string> GetGameListName() { List <string> gameList = new List <string>(); string strPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\" + DBName + ".accdb"; string conStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + strPath; OleDbConnection conn = new OleDbConnection(conStr); conn.Open(); OleDbCommand command = new OleDbCommand("select * from GameList", conn); OleDbDataReader dr = command.ExecuteReader(); while (dr.Read()) { string zhName = dr.GetString(dr.GetOrdinal("ZhName")); string enName = dr.GetString(dr.GetOrdinal("EnName")); gameList.Add(zhName + enName); } dr.Close(); dr = null; command.Cancel(); command.Dispose(); command = null; conn.Close(); conn.Dispose(); conn = null; return(gameList); }
/// <summary> /// Execute database command directly and display result to data grid /// </summary> /// <param name="oleCommand"></param> /// <param name="targetDataGridView"></param> public void CommandExec(string oleCommand, DataGridView targetDataGridView) { OleDbConnection DBConnection = new OleDbConnection(ConnectString()); OleDbCommand DBCommand = new OleDbCommand(oleCommand, DBConnection); DBConnection.Open(); if (DBConnection.State == ConnectionState.Open) { try { DBCommand.ExecuteNonQuery(); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(oleCommand, DBConnection); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); targetDataGridView.DataSource = dataSet.Tables[0]; DBCommand.Cancel(); } catch (OleDbException dberr) { MessageBox.Show(dberr.Message, dberr.Source, MessageBoxButtons.OK, MessageBoxIcon.Error); DBConnection.Close(); } finally { DBConnection.Close(); } } else { MessageBox.Show("Something's wrong with Database connection, Check Directory."); } }
// 新增餐點類別至資料庫 private void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("AddNew")) { string sCategoryName = (this.GridView1.FooterRow.FindControl("txtCategoryNameFooter") as TextBox).Text.Trim(); if (sCategoryName == "") { GetData(); this.divNotify.Style.Add("display", "block"); this.lblNotify.Text = "您忘記輸入類別名稱了。"; return; } OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand("Insert Into item_category(itemCategory_name, store_no) Values(?,?)", conn); cmd.Parameters.AddWithValue("itemCategory_name", sCategoryName); cmd.Parameters.AddWithValue("store_no", sStore_no); conn.Open(); cmd.ExecuteNonQuery(); cmd.Cancel(); conn.Close(); GetData(); } }
/// <summary> /// 得到用户密码 /// </summary> /// <param name="userID"></param> /// <returns></returns> public static string GetUserPasswd(string userID) { string passwd = ""; string strPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\" + DBName + ".accdb"; string conStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + strPath; OleDbConnection conn = new OleDbConnection(conStr); conn.Open(); OleDbCommand command = new OleDbCommand("select * from UserList where ID = " + userID, conn); OleDbDataReader dr = command.ExecuteReader(); if (dr.Read()) { passwd = dr.GetString(dr.GetOrdinal("passwd")); } dr.Close(); dr = null; command.Cancel(); command.Dispose(); command = null; conn.Close(); conn.Dispose(); conn = null; return(passwd); }
private void OnTimedEvent(Object source, System.Timers.ElapsedEventArgs e) { App.log($"Query status check @ {e.SignalTime} | Runtime : {runtime()} | Max RunTime : {App.queryMaxRunTime}"); if (state == states.Running) { if (runtime() > App.queryMaxRunTime) { App.log($"need to cancel query.| Runtime : {runtime()} | Max RunTime : {App.queryMaxRunTime} "); Timing timing = new Timing(this.db); cmd.Cancel(); timing.stop(); timing.log("Cancelling Query"); state = states.Done; result = results.Stopped; timer.Stop(); throw new TimeoutException($"SQL Query exceeded maximum allowed runtime. | Runtime : {runtime()} | Max RunTime : {App.queryMaxRunTime} "); // I should save/log this efffort and allow a retry - now while in memory? // or leave the scheduler retry } else { timer.Start(); // schedule another run } } else { App.log($@"This query should have stopped. Will stop {errorMsg} {sql}"); timer.Stop(); } }
private void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { try { // 新增店家 if (e.CommandName.Equals("AddNew")) { string sStoreName = ((TextBox)this.GridView1.FooterRow.Cells[0].FindControl("txtStoreNameFooter")).Text.Trim(); string sStoreAddress = ((TextBox)this.GridView1.FooterRow.Cells[0].FindControl("txtAddressFooter")).Text.Trim(); string sStorePhone = ((TextBox)this.GridView1.FooterRow.Cells[0].FindControl("txtPhoneFooter")).Text.Trim(); string sStoreRemark = ((TextBox)this.GridView1.FooterRow.Cells[0].FindControl("txtRemarkFooter")).Text.Trim(); // 驗證資料 if (sStoreName == "") { GetData(); this.GridView1.FooterRow.Visible = true; this.divNotify.Style.Add("display", "block"); this.lblNotify.Text = "您忘記輸入店家名稱了。"; return; } // 新增至資料庫 string sSql = "Insert Into store(store_name, store_address, store_phone, store_remark) Values (?,?,?,?);"; OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand(sSql, conn); cmd.Parameters.AddWithValue("store_name", sStoreName); cmd.Parameters.AddWithValue("store_address", sStoreAddress); cmd.Parameters.AddWithValue("store_phone", sStorePhone); cmd.Parameters.AddWithValue("store_remark", sStoreRemark); conn.Open(); cmd.ExecuteNonQuery(); cmd.Cancel(); conn.Close(); DataTable dt = (DataTable)ViewState["dt_sotre"]; // ViewState 新增餐點 DataRow row = dt.NewRow(); row["store_name"] = sStoreName; row["store_phone"] = sStorePhone; row["store_address"] = sStoreAddress; row["store_remark"] = sStoreRemark; dt.Rows.InsertAt(row, 0); ViewState["dt_sotre"] = dt; GetData(); } // 取消新增店家 else if (e.CommandName.Equals("CancelAddNew")) { this.GridView1.FooterRow.Visible = false; GetData(); } } catch (Exception ex) { this.divAlert.Style.Add("display", "block"); this.lblAlert.Text = "Error : " + ex.Message; } }
private int SaveLocal(DataSet objdatasetdto) { var objcon = new SqlConnection(ConfigurationManager.ConnectionStrings["SecureConnectionString"].ToString()); for (var i = 0; i < objdatasetdto.Tables[0].Rows.Count; i++) { //access db var conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source= F:\\LED\\Local\\Pop.mdb"); if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); var comm = new OleDbCommand(); comm.CommandType = CommandType.Text; comm.Connection = conn; comm.CommandText = "INSERT INTO Called ([No], Registration, [LO_NO]) values (" + objdatasetdto.Tables[0].Rows[i]["Queue_No"] + ", '" + objdatasetdto.Tables[0].Rows[i]["Registration"] + "', " + objdatasetdto.Tables[0].Rows[i]["LO_NO"] + ")"; comm.ExecuteNonQuery(); comm.Cancel(); comm.Dispose(); } return(1); }
private void Disconnect() { if (_con != null && _con.State == ConnectionState.Open) { _cmd.Cancel(); _con.Close(); } }
// <Snippet1> public void CreateCommand(string queryString, OleDbConnection connection) { OleDbCommand command = new OleDbCommand(queryString, connection); command.Connection.Open(); command.ExecuteReader(); command.Cancel(); }
protected void Button1_Click(object sender, EventArgs e) { //----上面已經事先寫好 Using System.Web.Configuration ---- //---- (連結資料庫)---- OleDbConnection Conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); Conn.Open(); OleDbDataReader dr = null; OleDbCommand cmd = new OleDbCommand("select 會員ID, 會員帳號, 會員帳號, 會員密碼 from 會員資料 where 會員帳號 = '" + TextBox1.Text + "' and 會員密碼 = '" + TextBox2.Text + "'", Conn); //*** 請注意資料隱碼攻擊(SQL Injection攻擊)*** dr = cmd.ExecuteReader(); //---- 這時候執行SQL指令,取出資料 if (!dr.Read()) { Response.Write("帳號或是密碼有錯!"); cmd.Cancel(); //----關閉DataReader之前,一定要先「取消」SqlCommand dr.Close(); Conn.Close(); Conn.Dispose(); Response.End(); //--程式暫停。或是寫成 return,脫離這個事件。 } else { Session["Login"] = "******"; //--帳號密碼驗證成功,才能獲得這個 Session["Login"] = "******" 鑰匙 Session["u_name"] = dr["會員帳號"].ToString(); Session["u_passwd"] = dr["會員密碼"].ToString(); Session["u_id"] = dr["會員ID"].ToString(); cmd.Cancel(); dr.Close(); Conn.Close(); Conn.Dispose(); Response.Redirect("home.aspx"); //--帳號密碼驗證成功,導向另一個網頁。 } }
public void ExecuteSqlTran(ArrayList SQLStringList, string bakname, HttpContext context) { string str3; StreamReader reader = new StreamReader(Path.Combine(base.Server.MapPath("."), "ProgressBar.html"), Encoding.GetEncoding("gb2312")); string s = reader.ReadToEnd(); reader.Close(); context.Response.Write(s); context.Response.Flush(); Thread.Sleep(200); OleDbConnection connection = null; connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + bakname); connection.Open(); OleDbCommand command = new OleDbCommand { Connection = connection, Transaction = connection.BeginTransaction() }; try { double num = 0.0; double count = SQLStringList.Count; double num3 = 0.0; for (int i = 0; i < SQLStringList.Count; i++) { num++; if ((((num / count) * 100.0) >= 1.0) && (Math.Round((double)((num / count) * 100.0)) > num3)) { Thread.Sleep(1); num3 = Math.Round((double)((num / count) * 100.0)); str3 = "<script>SetPorgressBar('已备份" + num.ToString() + "','" + num3.ToString() + "'); </script>"; context.Response.Write(str3); context.Response.Flush(); } string str4 = SQLStringList[i].ToString(); if (str4.Trim().Length > 1) { command.CommandText = str4; command.ExecuteNonQuery(); } } command.Transaction.Commit(); } catch (Exception exception) { command.Transaction.Rollback(); throw new Exception(exception.Message); } command.Cancel(); connection.Close(); command.Dispose(); connection.Dispose(); str3 = "<script>hText(); </script>"; context.Response.Write(str3); context.Response.Flush(); context.Response.Write(base.ShowDialogBox("備份成功!", string.Format("/BillBackupManage/BillBackup.aspx?lid={0}", 100), 0)); }
public override void Cancel() { try { OleDbCommand.Cancel(); } catch (OleDbException e) { throw new VfpException(e.Message, e); } }
public int GetNumber() { OleDbCommand cmd = new OleDbCommand("Select iif(IsNull(Max(order_no)), 0, Max(order_no)) From OrderHead1 Where order_no like '" + iDateDefult + "%'", conn); conn.Open(); iLatestNum = (int)cmd.ExecuteScalar(); cmd.Cancel(); conn.Close(); return(iLatestNum); }
private static void Test_Command_Cancel() { using (OleDbCommand cmd = new OleDbCommand("select * from code;", conn)) { cmd.ExecuteReader(); cmd.Cancel(); OleDbCommand cmd_clone = cmd.Clone(); Assert.AreEqual(cmd.ToString(), cmd_clone.ToString()); } }
//Заполнение DataTable public static DataTable GetDataTable(string p_query, OleDbParameter[] p_pr) { DataTable m_dt = new DataTable(); OleDbConnection m_conn = DataBaseHelper.GetOleDbConnection(); OleDbCommand m_cmd = new OleDbCommand(); OleDbDataAdapter m_da = new OleDbDataAdapter(); try { m_conn.Open(); } catch (OleDbException e) { throw new Exception(e.Message); } catch (Exception e1) { throw new Exception(e1.Message); } m_cmd.Connection = m_conn; m_cmd.CommandText = p_query; if (p_pr != null) { for (int i = 0; i < p_pr.Length; i++) { m_cmd.Parameters.Add(p_pr[i]); } } m_da.SelectCommand = m_cmd; try { m_da.Fill(m_dt); } catch (OleDbException e) { throw new Exception(e.Message); } catch (Exception e1) { throw new Exception(e1.Message); } finally { m_cmd.Cancel(); m_conn.Close(); } return(m_dt); }
// 更新餐點資料 private void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string sSql = "Update item Set itemCategory_no = ?, item_name = ?, item_price = ? where item_no = ?"; try { // 抓取修改後的值 string sCategoryNo = ((DropDownList)this.GridView1.Rows[e.RowIndex].Cells[1].FindControl("ddlCategoryEdit")).Text.Trim(); string sCategoryName = ((DropDownList)this.GridView1.Rows[e.RowIndex].Cells[1].FindControl("ddlCategoryEdit")).SelectedItem.Text; string sItemName = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].FindControl("txtItemName")).Text.Trim(); string sItemPrice = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].FindControl("txtItemPrice")).Text.Trim(); sItemPrice = Regex.Replace(sItemPrice, @"\b\s+\b", " "); //字串中間多餘的空格去掉,只保留一個空格 // 驗證資料 string sErrMsg = Verify(sItemName, sItemPrice); if (sErrMsg != "") { this.divNotify.Style.Add("display", "block"); this.lblNotify.Text = sErrMsg; return; } // 更新資料庫 OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand(sSql, conn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("itemCategory_no", sCategoryNo); cmd.Parameters.AddWithValue("item_name", sItemName); cmd.Parameters.AddWithValue("item_price", sItemPrice); cmd.Parameters.AddWithValue("item_no", this.GridView1.DataKeys[e.RowIndex].Value.ToString()); //取得被選取列的主鍵 conn.Open(); cmd.ExecuteNonQuery(); cmd.Cancel(); conn.Close(); // 更新ViewState的dt DataTable dt = (DataTable)ViewState["dt"]; GridViewRow row = this.GridView1.Rows[e.RowIndex]; dt.Rows[row.DataItemIndex]["itemCategory_no"] = sCategoryNo; dt.Rows[row.DataItemIndex]["itemCategory_name"] = sCategoryName; dt.Rows[row.DataItemIndex]["item_name"] = sItemName; dt.Rows[row.DataItemIndex]["item_price"] = sItemPrice; // 離開編輯模式 this.GridView1.EditIndex = -1; ViewState["dt"] = dt; BindItem(); GetCategory(); } catch (Exception ex) { this.divAlert.Style.Add("display", "block"); this.lblAlert.Text = "Error : " + ex.Message; } }
protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { string id; int i = 0, z = 0, total = 0; int[] array = new int[300]; int[] idd = new int[300]; string[] strid = new string[300]; string[] strcol = new string[300]; string[] strg = new string[300]; int[] strdol = new int[300]; id = Session["u_id"].ToString(); OleDbConnection Conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbDataReader dr = null; Conn.Open(); OleDbCommand cmd = new OleDbCommand("SELECT [購買商品],[會員ID], [顏色],[容量],[數量] ,[價格] FROM [購物車]", Conn); dr = cmd.ExecuteReader(); while (dr.Read()) { int iddStr = (int)dr["會員ID"]; String idStr = (String)dr["購買商品"]; String colStr = (String)dr["顏色"]; String gStr = (String)dr["容量"]; int muStr = (int)dr["數量"]; int dolStr = (int)dr["價格"]; idd[z] = iddStr; strid[z] = idStr; strcol[z] = colStr; strg[z] = gStr; array[z] = muStr; strdol[z] = dolStr; z = z + 1; } cmd.Cancel(); Conn.Close(); for (i = 0; i < z; i++) { if (idd[i] == int.Parse(id)) { total = total + (strdol[i] * array[i]); } } Label1.Text = total.ToString(); Label2.Text = "本次消費金額" + total.ToString(); }
//Выполнение произвольного запроса public static bool ExecuteQuery(string p_query, OleDbParameter[] p_pr) { bool m_result = true; OleDbConnection m_conn = DataBaseHelper.GetOleDbConnection(); OleDbCommand m_cmd = new OleDbCommand(); try { m_conn.Open(); } catch (OleDbException e) { throw new Exception(e.Message); } catch (Exception e1) { throw new Exception(e1.Message); } m_cmd.Connection = m_conn; m_cmd.CommandText = p_query; if (p_pr != null) { for (int i = 0; i < p_pr.Length; i++) { m_cmd.Parameters.Add(p_pr[i]); } } try { m_cmd.ExecuteNonQuery(); } catch (OleDbException e) { m_result = false; throw new Exception(e.Message); } catch (Exception e1) { throw new Exception(e1.Message); } finally { m_cmd.Cancel(); m_conn.Close(); m_conn.Dispose(); } return(m_result); }
private void cbNev_SelectedIndexChanged(object sender, EventArgs e) { OleDbConnection kapcsolat = new OleDbConnection(); kapcsolat.ConnectionString = connectionString; kapcsolat.Open(); OleDbCommand emailKeres = new OleDbCommand("select [e-mail] from nevek where nev=('" + cbNev.Text + "')", kapcsolat); tbEmail.Text = emailKeres.ExecuteScalar().ToString(); emailKeres.Cancel(); kapcsolat.Close(); }
public static string GetData(string sSql) { string sLatestNum; using (OleDbConnection conn = new OleDbConnection(connDB)) { OleDbCommand cmd = new OleDbCommand(sSql, conn); conn.Open(); sLatestNum = (string)cmd.ExecuteScalar(); cmd.Cancel(); } return(sLatestNum); }
private void btnClear_Click(object sender, EventArgs e) { if (sender.Equals(this.btnClear)) { OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OleDbCommand cmd = new OleDbCommand("Delete From filledIn Where order_no = " + sOrder_no + "and employee_no ='" + Session["employee_no"].ToString() + "'", conn); conn.Open(); cmd.ExecuteNonQuery(); cmd.Cancel(); conn.Close(); GetFilledIn(); } }
private void frmModositas_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'nevekDataSet.nevek' table. You can move, or remove it, as needed. this.nevekTableAdapter.Fill(this.nevekDataSet.nevek); OleDbConnection kapcsolat = new OleDbConnection(); kapcsolat.ConnectionString = connectionString; kapcsolat.Open(); OleDbCommand emailKeres = new OleDbCommand("select [e-mail] from nevek where nev=('" + cbNev.Text + "')", kapcsolat); tbEmail.Text = emailKeres.ExecuteScalar().ToString(); emailKeres.Cancel(); kapcsolat.Close(); }