public static bool validateLogin(UserLog ul) { DBConnector dbcon = new DBConnector(); dbcon.openConnection(); //try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM user WHERE username='******' AND password=MD5('" + ul.getPassword() + "')"; cmd.Connection = dbcon.connection; MySqlDataReader login = cmd.ExecuteReader(); if (login.Read()) { LoginSession.setSession(login.GetString("iduser")); //login.Close(); dbcon.closeConnection(); return true; } else { //login.Close(); dbcon.closeConnection(); return false; } //} //catch (MySqlException e){ //int errorcode = e.Number; //return false; //} }
public static void LoadItemsSets() { lock (DatabaseHandler.ConnectionLocker) { var sqlText = "SELECT * FROM datas_items_sets"; var sqlCommand = new MySqlCommand(sqlText, DatabaseHandler.Connection); var sqlReader = sqlCommand.ExecuteReader(); while (sqlReader.Read()) { var set = new Models.Items.SetModel(); set.ID = sqlReader.GetInt16("ID"); set.ParseBonus(sqlReader.GetString("bonus")); set.ParseItems(sqlReader.GetString("items")); lock(SetsList) SetsList.Add(set); } sqlReader.Close(); } Utilities.Loggers.StatusLogger.Write(string.Format("Loaded @'{0}' items sets@ from the database !", SetsList.Count)); }
public Account LoadAccount(string username) { string SqlQuery = "SELECT * FROM `accounts` WHERE `username` = ?username"; MySqlCommand SqlCommand = new MySqlCommand(SqlQuery, AccountDAOConnection); SqlCommand.Parameters.AddWithValue("?username", username); MySqlDataReader AccountReader = SqlCommand.ExecuteReader(); Account acc = new Account(); if (AccountReader.HasRows) { while (AccountReader.Read()) { acc.AccountId = AccountReader.GetInt32(0); acc.Username = AccountReader.GetString(1); acc.Password = AccountReader.GetString(2); acc.Email = AccountReader.GetString(3); acc.AccessLevel = (byte)AccountReader.GetInt32(4); acc.Membership = (byte)AccountReader.GetInt32(5); acc.isGM = AccountReader.GetBoolean(6); acc.LastOnlineUtc = AccountReader.GetInt64(7); acc.Coins = (int)AccountReader.GetInt32(8); acc.Ip = AccountReader.GetString(9); acc.UiSettings = ByteUtilities.StringToByteArray(AccountReader.GetString(10)); } } AccountReader.Close(); return (acc.Username == "") ? null : acc; }
public static Trayecto buscarPorId(int id) { Trayecto trayecto = null; if (id > -1) { MySqlConnection con = conexionDB.ObtenerConexion(); try { string sql = "select id, origen, destino, precio from trayecto where id = " + id; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { trayecto = new Trayecto(dr.GetInt32(0), CiudadFacade.buscarPorId(dr.GetInt32(1)), CiudadFacade.buscarPorId(dr.GetInt32(2)), dr.GetInt32(3)); } dr.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); trayecto = null; } finally { con.Close(); } } return trayecto; }
public static List<Trayecto> buscarOrigenes() { List<Trayecto> trayectos = new List<Trayecto>(); ; MySqlConnection con = conexionDB.ObtenerConexion(); try { string sql = "select id, origen, destino, precio from trayecto group by origen"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { trayectos.Add(new Trayecto(dr.GetInt32(0), CiudadFacade.buscarPorId(dr.GetInt32(1)), CiudadFacade.buscarPorId(dr.GetInt32(2)), dr.GetInt32(3))); } dr.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return trayectos; }
public static Models.AccountsModel LoadAccount(int accountID) { DatabaseProvider.CheckConnection(); lock (DatabaseProvider.ConnectionLocker) { var account = new Models.AccountsModel(); var sqlText = "SELECT * FROM dyn_accounts WHERE id=@id"; var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection); sqlCommand.Parameters.Add(new MySqlParameter("@id", accountID)); var sqlReader = sqlCommand.ExecuteReader(); if (sqlReader.Read()) { account.ID = sqlReader.GetInt16("id"); account.Username = sqlReader.GetString("username"); account.Password = sqlReader.GetString("password"); account.Pseudo = sqlReader.GetString("pseudo"); account.Communauty = sqlReader.GetInt16("communauty"); account.Level = sqlReader.GetInt16("gmLevel"); account.Question = sqlReader.GetString("question"); account.Answer = sqlReader.GetString("answer"); account.SubscriptionDate = sqlReader.GetDateTime("subscription"); } sqlReader.Close(); return account; } }
protected void Button2_Click(object sender, EventArgs e) { String cbid = TextBox1.Text; conn = new MySqlConnection(GetConnectionString()); try { conn.Open(); MySqlCommand comm = new MySqlCommand("Select Stock, Amount, DATE_FORMAT(Valid_From, '%d-%m-%Y'),DATE_FORMAT(Valid_To, '%d-%m-%Y') from Combopack where Combo_ID='" + cbid + "'", conn); MySqlDataReader dr = comm.ExecuteReader(); dr.Read(); TextBox3.Text = dr.GetValue(0).ToString(); TextBox2.Text = dr.GetValue(1).ToString(); TextBox4.Text = dr.GetValue(2).ToString(); TextBox5.Text = dr.GetValue(3).ToString(); dr.Close(); comm.CommandText = "Select p.Product_ID, p.Company_Name, p.Product_Name, c.Quantity from Current_Store_Products p,Combopack_Schemes c where c.Product_ID=p.Product_ID and c.Combo_ID='" + cbid + "'"; dr = comm.ExecuteReader(); GridView1.DataSource = dr; GridView1.DataBind(); dr.Close(); comm.CommandText = "Select Sum(Quantity),Sum(Price) from Combopack_Schemes where Combo_ID='" + cbid + "'"; dr = comm.ExecuteReader(); dr.Read(); Label9.Text = dr.GetValue(0).ToString(); Label10.Text = dr.GetValue(1).ToString(); dr.Close(); } catch (Exception ex) { Response.Write("In Button2Click"+ex.Message); } finally { conn.Close(); } }
public void AggregateTypesTest() { execSQL("CREATE TABLE foo (abigint bigint, aint int)"); execSQL("INSERT INTO foo VALUES (1, 2)"); execSQL("INSERT INTO foo VALUES (2, 3)"); execSQL("INSERT INTO foo VALUES (3, 4)"); execSQL("INSERT INTO foo VALUES (3, 5)"); // Try a normal query string NORMAL_QRY = "SELECT abigint, aint FROM foo WHERE abigint = {0}"; string qry = String.Format(NORMAL_QRY, 3); MySqlCommand cmd = new MySqlCommand(qry, conn); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { reader.GetInt64(0); reader.GetInt32(1); // <--- aint... this succeeds } } cmd.CommandText = "SELECT abigint, max(aint) FROM foo GROUP BY abigint"; using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { reader.GetInt64(0); reader.GetInt64(1); // <--- max(aint)... this fails } } }
private void GetValues() { qry = "SELECT In_Stock,Hired_Out FROM books WHERE ISBN = @ISBN"; using (MySqlConnection Connection = new MySqlConnection(MyConString)) { try { MySqlCommand cmd = new MySqlCommand(qry, Connection); cmd.Parameters.Add(new MySqlParameter("@ISBN",(object)ISBN)); MySqlDataReader reader; Connection.Open(); reader = cmd.ExecuteReader(); in_stock = int.Parse(reader["In_Stock"].ToString()); hired_out = int.Parse(reader["Hired_Out"].ToString()); reader.Close(); cmd.Parameters.Clear(); qry = "SELECT Books_purchased,Books_hired FROM clients WHERE FirstName = @FirstName AND LastName = @LastName"; cmd.Parameters.Add(new MySqlParameter("@FirstName", (object)firstname)); cmd.Parameters.Add(new MySqlParameter("@LastName", (object)lastname)); reader = cmd.ExecuteReader(); books_purchased = int.Parse(reader["Books_purchased"].ToString()); books_hired = int.Parse(reader["Books_hired"].ToString()); } catch (Exception ex) { MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Connection.Close(); } } }
public ReportData getPatientReport(int patientID) { ReportData reportData = new ReportData(); using (MySqlConnection conn = new MySqlConnection(connectionString)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "SELECT * FROM patient where patientID=@pID"; cmd.Prepare(); cmd.Parameters.Add("@pID", MySqlDbType.Int32).Value = patientID; using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { reportData.PatientData.PatientID = rdr.GetInt32("patientID"); reportData.PatientData.FirstName = rdr.GetString("firstName"); reportData.PatientData.LastName = rdr.GetString("lastName"); reportData.PatientData.DateAdmitted = rdr.GetDateTime("dateAdmitted"); } } //TODO new reach specific, fix later cmd.CommandText = "SELECT * FROM reach where patientID=@pID"; cmd.Prepare(); using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { ExerciseData exerciseData = new ExerciseData(); exerciseData.ExerciseName = "reach"; exerciseData.PatientID = rdr.GetInt32("patientID"); exerciseData.EmployeeID = rdr.GetInt32("employeeID"); exerciseData.SessionID = rdr.GetInt32("sessionID"); //specific to reach exerciseData.Hands = rdr.GetString("hands"); exerciseData.Angle = rdr.GetDouble("angle"); exerciseData.Date = rdr.GetDateTime("exerciseDate"); exerciseData.Time = rdr.GetDouble("time"); reportData.ExerciseDataList.Add(exerciseData); } } } return reportData; }
public static List<OgrenciDersleri> OgrenciDersGetir(Ogrenci ogrenci) { List<OgrenciDersleri> ogrenciDersleri = new List<OgrenciDersleri>(); MySqlConnection connection=null; try { string connectionString="SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;"; connection = new MySqlConnection(connectionString); connection.Open(); string query = "SELECT * FROM OgrenciDersleri"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader= cmd.ExecuteReader(); while (reader.Read()) { OgrenciDersleri ogreciDers = new OgrenciDersleri(); ogreciDers.Id = Convert.ToInt32(reader["Id"]); ogreciDers.Ogrenci = new Ogrenci(); ogreciDers.Ogrenci.Id = Convert.ToInt32(reader["Ogrenci"]); ogreciDers.Ders = new Ders(); ogreciDers.Ders.Id = Convert.ToInt32(reader["Ders"]); string studentQuery = "SELECT * FROM Ogrenci WHERE Id = '" + ogreciDers.Ogrenci.Id + "'"; MySqlCommand cmdStudent = new MySqlCommand(query, connection); MySqlDataReader readerStudent = cmd.ExecuteReader(); while (readerStudent.Read()) { ogreciDers.Ogrenci.Adi = readerStudent["Adi"].ToString(); ogreciDers.Ogrenci.Soyadi = readerStudent["Soyadi"].ToString(); } ogrenciDersleri.Add(ogreciDers); } connection.Close(); DataTable table = new DataTable(); table.Load(reader); for (int i = 0; i < table.Rows.Count; i++) { string adi = table.Rows[i]["Id"].ToString(); } //DersBilgileriDoldur(ogrenciDersleri); } catch (Exception ex) { } finally { connection.Close(); } return ogrenciDersleri; }
public int AddNewCustomer() { int newCustomerID = 0; int existingCustomerResult = 0; //Used to check if this customer already exists in the database MySqlConnection conn = new MySqlConnection("Server=database2.cs.tamu.edu; Database=gcopley-car_dealership; Uid=gcopley ;Pwd=add431;"); MySqlCommand findExistingCmd = new MySqlCommand("SELECT MAX(id) from customer where f_name ='" + m_txtCrtPendingCustFirstNameVal.Text + "' and l_name ='" + m_txtCrtPendingCustLastNameVal.Text + "'", conn); findExistingCmd.Connection.Open(); //First check to see if the customer already exists in the database, if he does, return his ID, as there is no need to add him MySqlDataReader queryReader = findExistingCmd.ExecuteReader(); while (queryReader.Read()) { if (queryReader.FieldCount != 0) { existingCustomerResult = (queryReader.GetInt32(0)); } } queryReader.Close(); if (existingCustomerResult != 0) { queryReader.Dispose(); return existingCustomerResult; } //If the customer doesn't exist, add him into the database, and if its a success, extract his id and return it. MySqlCommand addNewCustomerCmd = new MySqlCommand("INSERT INTO customer(f_name, l_name, addr_city, addr_state, addr_zip, phone, email) " + "VALUES('" + m_txtCrtPendingCustFirstNameVal.Text + "','" + m_txtCrtPendingCustLastNameVal.Text + "','" + m_txtCrtPendingCustCityVal.Text + "','" + m_txtCrtPendingCustStateVal.Text + "','" + m_txtCrtPendingCustZipVal.Text + "','" + m_txtCustomerPhoneNumber.Text + "','" + m_txtCustomerEmail.Text + ")", conn); addNewCustomerCmd.ExecuteNonQuery(); //queryReader.(); queryReader = findExistingCmd.ExecuteReader(); while (queryReader.Read()) { newCustomerID = (queryReader.GetInt32(0)); } if (newCustomerID != 0) { queryReader.Close(); queryReader.Dispose(); return newCustomerID; } else { queryReader.Close(); queryReader.Dispose(); return 0; } }
private void button1_Click(object sender, EventArgs e) { string strconn; strconn = "SERVER = " + server + "; DATABASE = " + DBtext + "; User ID =" + user + " ; password = "******";Charset=utf8"; MySqlConnection mys_conn = new MySqlConnection(strconn); mys_conn.Open(); string sql = "select * from " + DBtable + " order by mdl_code asc"; MySqlCommand mys_com = new MySqlCommand(sql,mys_conn); MySqlDataReader mys_read = mys_com.ExecuteReader(); int listcount = 0; while (mys_read.Read()) { if (mys_read.HasRows) { listcount++; } } result = new string[listcount][]; //釋放資源 mys_read.Dispose(); //重新載入 mys_read = mys_com.ExecuteReader(); int times = 0; while (mys_read.Read()) { result[times] = new string[mys_read.FieldCount]; string str=""; for (int i = 0; i < mys_read.FieldCount; i++) { result[times][i] = mys_read[i].ToString(); if (i == 0) { str += mys_read[i].ToString(); continue; } str += " , "+ mys_read[i].ToString(); } times++; listBox1.Items.Add(str.ToString()); } mys_read.Dispose(); mys_read.Close(); mys_com.Dispose(); mys_conn.Dispose(); mys_conn.Close(); }
//Vrakja lista na knigi public List<Book> SelectListBooks(string search,string language, string category) { List<Book> list = new List<Book>(); using (MySqlConnection connection = new MySqlConnection()) { connection.ConnectionString = connString; connection.Open(); string query = "SELECT IDBook, Name, ImageSrc, Description, Date FROM Books, Categories, Tags, BelongsTo, Tagged"; MySqlCommand command = new MySqlCommand(query, connection); MySqlDataReader dataReader = command.ExecuteReader(); Dictionary<string, string> dictionary = new Dictionary<string, string>(); List<Dictionary<string, string>> books = new List<Dictionary<string, string>>(); List<Author> authors; while (dataReader.Read()) { dictionary.Add("IDBook", dataReader["IDBook"].ToString()); dictionary.Add("Name", dataReader["Name"].ToString()); dictionary.Add("ImageSrc", dataReader["ImageSrc"].ToString()); dictionary.Add("Description", dataReader["Description"].ToString()); dictionary.Add("Date", dataReader["YearPublished"].ToString()); books.Add(dictionary); } dataReader.Close(); for (int i = 0; i < books.Count; i++) { //Lista na avtori za sekoja kniga authors = new List<Author>(); query = "SELECT a.Name, a.Surname,a.Country FROM Authors as a, Books as b, Wrote as w WHERE w.IDAuthor = a.IDAuthor AND w.IDBook =" + books[i]["IDBook"]; command.CommandText = query; dataReader = command.ExecuteReader(); while (dataReader.Read()) { Author a = new Author(dataReader["Name"].ToString(), dataReader["Surname"].ToString(), dataReader["Countrey"].ToString()); authors.Add(a); } dataReader.Close(); //Dodavanje na knigata vo listata Book b = new Book(books[i]["Name"], authors, books[i]["ImageSrc"], books[i]["Description"], books[i]["Date"]); list.Add(b); } connection.Close(); return list; } }
protected void Confirm_Click(object sender, EventArgs e) { conn = new MySqlConnection(GetConnectionString()); String orderid = TextBox7.Text; List<String> ProductID = new List<String>(); List<int> Quantity = new List<int>(); try { conn.Open(); // MySqlCommand comm=new MySqlCommand("Update Order_Detail_Store set Order_Received='Completed' where Order_ID='"+orderid+"'",conn); MySqlCommand comm=new MySqlCommand("Select Order_Received from Order_Detail_Store where Order_ID='"+orderid+"'",conn); MySqlDataReader dr=comm.ExecuteReader(); dr.Read(); String flag=dr.GetValue(0).ToString(); dr.Close(); if(flag.Equals("Pending")) { comm.CommandText="Update Order_Detail_Store set Order_Received='Completed' where Order_ID='"+orderid+"'"; comm.ExecuteNonQuery(); comm.CommandText = "Update Order_Detail_Store_Central set Order_Received='Completed' where Order_ID='" + orderid + "'"; comm.ExecuteNonQuery(); comm.CommandText = "Select Product_ID,Quantity from Order_Product_Store where Order_ID='"+orderid+"'"; MySqlDataReader dr1 = comm.ExecuteReader(); while (dr1.Read()) { ProductID.Add(dr1.GetValue(0).ToString()); Quantity.Add(int.Parse(dr1.GetValue(1).ToString())); } dr1.Close(); int i=0; foreach (String pid in ProductID) { int quant = Quantity.ElementAt(i); i++; comm.CommandText = "Update Current_Store_Products set Stock=Stock+" + quant + " where Product_ID='" + pid + "'"; comm.ExecuteNonQuery(); } } } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } TextBox7.Text=""; }
protected void Page_Load(object sender, EventArgs e) { MySqlConnection conn = new MySqlConnection(GetConnectionString()); String[] top = new String[5]; String[] bottom = new String[5]; MySqlDataReader dr; String query1 = "Select Product_Name,Company_Name,Sp4_Value,Sp5_Value,Sp6_Value,Sp7_Value,Sp8_Value from Master_Products where Product_ID in (Select Product_ID from Transactions where Bill_No in (Select Bill_No from Bills where MONTH(Bill_Date) = MONTH(NOW())) GROUP BY(Product_ID) ORDER BY SUM(Quantity) desc) ORDER BY(Product_ID) desc"; String query2 = "Select Product_Name,Company_Name,Sp4_Value,Sp5_Value,Sp6_Value,Sp7_Value,Sp8_Value from Master_Products where Product_ID in (Select Product_ID from Transactions where Bill_No in (Select Bill_No from Bills where MONTH(Bill_Date) = MONTH(NOW())) GROUP BY(Product_ID) ORDER BY SUM(Quantity) ORDER BY (Product_ID))"; try { conn.Open(); MySqlCommand comm = new MySqlCommand(query1, conn); dr = comm.ExecuteReader(); for (int i = 0; i < 5; i++) { dr.Read(); top[i] = dr.GetValue(1).ToString() + " " + dr.GetValue(0).ToString() + " " + dr.GetValue(2).ToString() + " " + dr.GetValue(3).ToString() + " " + dr.GetValue(4).ToString() + " " + dr.GetValue(5).ToString() + " " + dr.GetValue(6).ToString(); } dr.Close(); comm.CommandText = query2; dr = comm.ExecuteReader(); for (int i = 0; i < 5; i++) { dr.Read(); bottom[i] = dr.GetValue(1).ToString() + " " + dr.GetValue(0).ToString() + " " + dr.GetValue(2).ToString() + " " + dr.GetValue(3).ToString() + " " + dr.GetValue(4).ToString() + " " + dr.GetValue(5).ToString() + " " + dr.GetValue(6).ToString(); } dr.Close(); } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } Label3.Text = top[0]; Label5.Text = top[1]; Label4.Text = top[2]; Label6.Text = top[3]; Label7.Text = top[4]; Label8.Text = bottom[0]; Label9.Text = bottom[1]; Label10.Text = bottom[2]; Label11.Text = bottom[3]; Label12.Text = bottom[4]; }
public List<Categoria> ObterCategoriasCadastradas(string idioma) { List<Categoria> lista = new List<Categoria>(); MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "SELECT id, nome, urlImagem FROM tb_categorias order by nome"; conn.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { lista.Add(new Categoria { id = (int)dr["id"], nome = Tradutor.Traduzir(dr["nome"].ToString(), idioma), urlImagem = dr["urlImagem"].ToString() }); } } conn.Close(); return lista; }
public EParametros getParamentro() { EParametros objPar = null; // List<EParametros> lista = new List<EParametros>(); string sql = "SELECT * FROM afparametros WHERE codigo = 1"; using (conexion cnx = new conexion()) { cnx.cadena = Configuracion.Instanciar.conexionBD(); using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand()) { cmd.CommandText = sql; cmd.Connection = cnx.getConexion(); if (cnx.abrirConexion()) { MySql.Data.MySqlClient.MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objPar = mapearObjeto(dr); //lista.Add(objPar); } cnx.cerrarConexion(); } } return(objPar); } }
/* ===================================================================================== * ================== G E T V A L U E S B Y O T H E R V A L U E S ================== * ===================================================================================== */ static string[] getCharakByNameAndKodas(string name, string kodas) { string[] result = { "", "" }; MySqlConnection con = new MySqlConnection(connectionStringAlt); con.Open(); //query string query = "SELECT pr_z.pr_pavad as 'name',g_v.prid, g_v.g_kodas as 'kodas' FROM pg_zodynas INNER JOIN pg_seima on pg_seima.pg_id_v=pg_zodynas.pg_id INNER JOIN goods_v g_v on g_v.pgs_id = pg_seima.pgs_id INNER JOIN pr_zodynas AS pr_z ON g_v.pr_id=pr_z.pr_id AND g_v.del_date IS NULL WHERE pg_zodynas.pavaddgs = '" + name + "'"; MySqlCommand cmd = new MySqlCommand(query, con); //executing query MySqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { if (data["kodas"].ToString() == kodas) result[0] = data["name"].ToString(); { result[1] = data["prid"].ToString(); } } data.Close(); con.Close(); return result; }
public static List<NetworkProcessor> CreateNetProcs() { AppLog.WriteLine(5, "STATUS", "Entered IRCStatistician.Program.CreateNetProcs()."); List<NetworkProcessor> returnList = new List<NetworkProcessor>(); // Get the tbn_networks table MySqlCommand NetworkCmd = new MySqlCommand("SELECT * FROM " + Config.SQLTablePrefix + "networks", MyDBConn.Connection); MySqlDataReader NetworkDataReader = NetworkCmd.ExecuteReader(); DataTable NetworkTable = new DataTable(); NetworkTable.Load(NetworkDataReader); NetworkDataReader.Close(); // Get the tbn_channels table MySqlCommand ChannelCmd = new MySqlCommand("SELECT * FROM " + Config.SQLTablePrefix + "channels", MyDBConn.Connection); MySqlDataReader ChannelDataReader = ChannelCmd.ExecuteReader(); DataTable ChannelTable = new DataTable(); ChannelTable.Load(ChannelDataReader); ChannelDataReader.Close(); // Organize them together. foreach (DataRow CurNetwork in NetworkTable.Rows) { NetworkProcessor tempLW = new NetworkProcessor(CurNetwork); foreach (DataRow CurChannel in ChannelTable.Rows) { if (Convert.ToInt32(CurChannel["networkid"]) == tempLW.Network.Id) { tempLW.Network.Channels.Add(CurChannel["name"].ToString(), new Channel(CurChannel["name"].ToString())); } } returnList.Add(tempLW); } return returnList; }
private void DoSQLQueryPieFournisseur() { try { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); queryStr = ""; queryStr = "SELECT * FROM database.detail WHERE detail.t1='" + Session["AnnPieFournisseur"] + "' AND detail.titre='Solde fournisseurs'"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { fournisseur = reader.GetString(reader.GetOrdinal("t1")); DebitF1 = reader.GetInt32(reader.GetOrdinal("t2")); CreditF1 = reader.GetInt32(reader.GetOrdinal("t3")); SoldeF1 = reader.GetInt32(reader.GetOrdinal("t4")); } reader.Close(); conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
private void buttonCadastrar_Click(object sender, EventArgs e) { MySqlConnection conn = null; try { conn = Conexao.getConexao(); MySqlCommand cmd = new MySqlCommand("call cadastra_pizza(@nome, @tamanho, @preco)", conn); cmd.Prepare(); cmd.Parameters.AddWithValue("@nome", this.txt_nome.Text); cmd.Parameters.AddWithValue("@tamanho", this.cmb_tamanho.Text); cmd.Parameters.AddWithValue("@preco", this.txt_preco.Text); MySqlDataReader rs = cmd.ExecuteReader(); rs.Read(); if (!rs.HasRows) { conn.Close(); new SuccessDialog("Pizza cadastrada com sucesso!"); this.Close(); } else { String error = rs.GetString(0); conn.Close(); new ErrorDialog(error); } } catch (Exception err) { if (conn != null) conn.Close(); new ErrorDialog(err.Message); } }
public List <Contato> BuscarTodos(Contato contato) { List <Contato> todos = new List <Contato>(); MySqlConnection conn = new ConexaoBancoMySql().getConnection(); conn = new MySqlConnection(connectionString); String selecionaTodos = "select id, nome, telefone from contato "; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(selecionaTodos, conn); try { MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Contato novo = new Contato(); novo.id = (int)reader["id"]; novo.nome = reader["nome"].ToString(); novo.telefone = reader["telefone"].ToString(); todos.Add(novo); } conn.Close(); return(todos); } finally { conn.Close(); } }
public List <Person> getPersons() { List <Person> personList = new List <Person>(); MySql.Data.MySqlClient.MySqlDataReader mySqlReader = null; string sqlString = "SELECT * from tbl_personnel"; var cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); try { mySqlReader = cmd.ExecuteReader(); while (mySqlReader.Read()) { Person p = new Person(); p.ID = mySqlReader.GetInt32(0); p.FirstName = mySqlReader.GetString(1); p.LastName = mySqlReader.GetString(2); p.PayRate = mySqlReader.GetFloat(3); p.StartDate = mySqlReader.GetDateTime(4); p.EndDate = mySqlReader.GetDateTime(5); personList.Add(p); } } catch (Exception ex) { Console.WriteLine("MySQL exception"); Console.WriteLine(ex); Console.WriteLine(ex.Data); } return(personList); }
public bool deletePerson(long ID) { bool recordDeleted = false; MySql.Data.MySqlClient.MySqlDataReader mySqlReader = null; string sqlString = "SELECT * from tbl_personnel where ID = " + ID.ToString(); var cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); try { mySqlReader = cmd.ExecuteReader(); if (mySqlReader.Read()) { mySqlReader.Close(); sqlString = "DELETE FROM tbl_personnel where ID = " + ID.ToString(); cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); cmd.ExecuteNonQuery(); recordDeleted = true; } } catch (Exception ex) { Console.WriteLine("SQL Exception in Delete"); Console.WriteLine(ex); Console.WriteLine(ex.Data); } return(recordDeleted); }
protected void LoginUser(object sender, EventArgs e) { string connectionString = @"Data Source=db4free.net; Database=centresportif420; user=centresportif420; password=stephane420;"; using (MySqlConnection cn = new MySqlConnection(connectionString)) { cn.Open(); queryStr = "SELECT * FROM centresportif420.personne WHERE codebarre='" + Server.HtmlEncode(((TextBox)(Login1.FindControl("UserName"))).Text) + "' AND motdepasse='" + Server.HtmlEncode(((TextBox)(Login1.FindControl("Password"))).Text) + "'"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, cn); reader = cmd.ExecuteReader(); name = ""; while (reader.HasRows && reader.Read()) { name = reader.GetString(reader.GetOrdinal("nom")); role = reader.GetString(reader.GetOrdinal("role")); idpersonne = reader.GetString(reader.GetOrdinal("idpersonne")); Session["idpersonne"] = idpersonne; Session["urole"] = role; } if (reader.HasRows) { Session["uname"] = name; Response.BufferOutput = true; Response.Redirect("~/Account/Membre.aspx", false); FormsAuthentication.SetAuthCookie(Server.HtmlEncode(((TextBox)(Login1.FindControl("UserName"))).Text), true); } else { Response.Redirect("~/Account/Login.aspx", false); } reader.Close(); cn.Close(); } }
public dynamic GetUserBetPointsDetails(int userID) { oCon.Open(); string fetchQuery = "SELECT * FROM view_userdetails WHERE UserID = " + userID; List <UserPointsModel> userbets = new List <UserPointsModel>(); oMySQLData.MySqlCommand cmd = new oMySQLData.MySqlCommand(fetchQuery, oCon); cmd.ExecuteNonQuery(); oMySQLData.MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UserPointsModel userbet = new UserPointsModel(); userbet.UserID = Convert.ToInt32(reader["UserID"]); userbet.TournamentID = Convert.ToInt32(reader["TournamentID"]); userbet.TotalPoints = Convert.ToInt32(reader["TotalBetPoints"]); userbet.TournamentPoints = Convert.ToInt32(reader["TournamentPoints"]); userbets.Add(userbet); } oCon.Close(); return(userbets); }
List <UserBetModel> GetUserBetList(int userID, int tournamentID) { oCon.Open(); string fetchQuery = "SELECT * FROM view_userbetdetails WHERE fldBettorID = " + userID + " AND fldTournamentID = " + tournamentID; List <UserBetModel> bets = new List <UserBetModel>(); oMySQLData.MySqlCommand cmd = new oMySQLData.MySqlCommand(fetchQuery, oCon); cmd.ExecuteNonQuery(); oMySQLData.MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UserBetModel bet = new UserBetModel(); bet.BettorID = Convert.ToInt32(reader["fldBettorID"]); bet.TournamentID = Convert.ToInt32(reader["fldTournamentID"]); bet.MatchID = Convert.ToInt32(reader["fldMatchID"]); bet.TeamID = Convert.ToInt32(reader["fldTeamBetID"]); bet.PlaceBet = Convert.ToInt32(reader["fldPlaceBetPoints"]); bets.Add(bet); } oCon.Close(); return(bets); }
private void btn_load_Click(object sender, EventArgs e) { MySqlConnection connection; var sql = String.Format("SELECT * FROM creature_ai_scripts WHERE creature_id = {0}", UInt32.Parse(tb_entry.Text)); try { connection = new MySqlConnection("server=127.0.0.1;uid=root;pwd=;database=world2;"); connection.Open(); MySqlCommand cmd = new MySqlCommand(sql, connection); var data = cmd.ExecuteReader(); if (!data.HasRows) return; while(data.Read()) { tc_content.TabPages.Add("AI"); var newTab = tc_content.TabPages[tc_content.TabCount - 1]; var aiTab = new AiTab(); aiTab.Dock = DockStyle.Fill; aiTab.FromDatabase(data); newTab.Controls.Add(aiTab); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
//private MySql.Data.MySqlClient.MySqlConnection conn; /*public DepartmentPersistence() * { * string feashConn; * feashConn = "server=localhost;port=3306;database=fea_starhub;username=root;password=135246;"; * try * { * conn = new MySql.Data.MySqlClient.MySqlConnection(); * conn.ConnectionString = feashConn; * conn.Open(); * } * catch (MySql.Data.MySqlClient.MySqlException ex) * { throw ex; } * }*/ public ArrayList allDepts() { MySql.Data.MySqlClient.MySqlConnection conn; string feashConn; feashConn = ConfigurationManager.ConnectionStrings["localDB"].ConnectionString; conn = new MySql.Data.MySqlClient.MySqlConnection(); try { conn.ConnectionString = feashConn; conn.Open(); ArrayList d = new ArrayList(); MySql.Data.MySqlClient.MySqlDataReader getReader = null; string getString = "SELECT * FROM Dept_ProgramID;"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(getString, conn); getReader = cmd.ExecuteReader(); while (getReader.Read()) { getSingleDept adept = new getSingleDept(); adept.DName = getReader.IsDBNull(0) == false?getReader.GetString(0) : null; adept.DEntity = getReader.IsDBNull(1) == false?getReader.GetString(1) : null; adept.ProgramID = getReader.IsDBNull(2) == false?getReader.GetString(2) : null; d.Add(adept); } return(d); } catch (MySql.Data.MySqlClient.MySqlException ex) { throw ex; } finally { conn.Close(); } }
public bool checkExistance() { string connStr = "server=csshrpt.eku.edu;user=csc834;database=csc834;port=3306;password=CSC834student;"; MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(connStr); try { Console.WriteLine("Connecting to MySQL..."); conn.Open(); string sql = "SELECT * FROM changitemtable WHERE name = @name"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@name", name); MySqlDataReader myReader = cmd.ExecuteReader(); if (myReader.Read()) { return(true); } else { return(false); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } conn.Close(); Console.WriteLine("Done."); return(false); }
public UserModel(int id) { try { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "SELECT username,currency,avatar,email FROM users WHERE id = @id"; cmd.Prepare(); cmd.Parameters.AddWithValue("@id", id); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { username = rdr[0].ToString(); currency = Convert.ToInt32(rdr[1]); avatar = rdr[2].ToString(); if (avatar.Length == 0) { avatar = "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCACAAIADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9Cvh98PvBGpeCNDvr7wtps9xPYxSSyyW6lnYrySe5rof+FX/D3/oTtJ/8Blo+F/8AyT3w9/2Dof8A0GuooA5f/hV/w9/6E7Sf/AZaP+FX/D3/AKE7Sf8AwGWuoooA5f8A4Vf8Pf8AoTtJ/wDAZaP+FX/D3/oTtJ/8BlrpnbaMk4A5NeB/FH9sDwL4Ge407w3bN4k1G2bZIYpRFaI3cedgliP9hSOoyCKAPVT8Mfh4P+ZN0r/wFWmn4a/DlfveENIGfW2UV8XeKf26vif4gs5dO8P6bpOgvPkfaYUaaaIf7Jc7cn1K14TrnjHxD4mvXv8AxF4l1K/uZDkvd3Tyc+wJwPwFAH6jD4bfDhjtXwjo5Ptboaf/AMKw+Hv/AEJuk/8AgKtflXaanrGmTpfaZqt9aTxnKzWd26Op+qkGvc/hV+2j8R/BFzDZeNpW8WaIXVJGlwt9bpkAlH4EmB/C/J/vCgD7i/4Vf8Pf+hO0n/wGWj/hV/w9/wChO0n/AMBlqXwH4/8AC3xL8NWvizwdqsd9p91xuUYeNxjdG6nlXGeQa6OgDl/+FX/D3/oTtJ/8Blo/4Vf8Pf8AoTtJ/wDAZa6iigDl/wDhV/w9/wChO0n/AMBlrA8f/D3wPp3gnXL6y8K6bBPBYTSRSx26hkYIcEHsa9Hrmfib/wAk98Rf9g2f/wBANADfhf8A8k98Pf8AYOh/9BrqK5f4X/8AJPfD3/YOh/8AQa6igApDxS0h6GgD5Z/bM+OFz4ZtYvhj4eupIbu/hE2pyxnDCBiQkKt2LkEtjnaAOjV8QapfuqNIzK7qMEn7kZ/uqP612X7Q/ie68QfF/wAU6rNMWA1Ke3hy33Ujbyhj/gKD868qdrvWLhbOzRtoOM9gPU0Aauk5MJvmJbMmATznjmrl9YGeQyWThJgMmI9/pXf/AAc+H8nirX4rY2zto9hDKtzPt+V5HQptU9CfmJ46Y965/wAZ+EL/AMJ61L4b16J4JoSTa3QBCzx/wup7j19DkHpQBws93dWblbuCSIj+LkU5dWS6+WZgGHCyDg/j61fuTrVl8txEl5CO5XPFZ1xe6a+d+kmJj1KnFAHpn7P/AMdNY+BnjuDVxLLL4e1GRINasl5DxZ4mQdpE6g9xlT14/U/T9Qs9VsbfUtPuEntbuJJ4ZUYFZI2GVYHuCCDX4uXFzaPZtGVJPbNfoz+wT4/m8YfA9NCvJHe58J3r6XuY5LQECWLHsFk2D/coA+kqKKKACuZ+Jv8AyT3xF/2DZ/8A0A101cz8Tf8AknviL/sGz/8AoBoAb8L/APknvh7/ALB0P/oNdRXL/C//AJJ74e/7B0P/AKDXUUAFIelLSHoaAPyR+LNotv8AEjxLp16zI1rrN8jDHJ/fvg/lzXuHwI/ZfXxJocPivxTDJBp9wBJb2Y+V5l7PI3XaecKMccn0rR+P3whsrL9qXRLzWLNh4e8aXMVwGHCtcqAskR9MsIz7iQ+lfYmn2MFro8dtbRqqRoFUKMAADoKAPIbbwxpugQpp2mWUVtBDwkcahVUewAqh4k8F+H/F1h/ZviPSbe+g5Khwd0Z9UYcqfoa7zVbHFy3bmqn2E0AfOmu/sraS7GTwp4ovLAE5+z3kYuI/wIKsPxzXGaz+y/43iUvbXOgX4HTEkkTn80I/Wvr1rE4qhf22yMnHOKAPgjxv8FPHXhnR7rWb/wALiK0s13zXEd1E6oucZwG3dT6V9N/8E0Yp/wDhHPHkxJ8k6jZovp5gict+jJUnx4lS0+EPiZ5cASW6QrnuzSqB/OvXf2OvhfcfDD4K6fb6paNb6trsraxfRsPmRpQBGh91iWMEdjkUAe40UUUAFcz8Tf8AknviL/sGz/8AoBrpq5n4m/8AJPfEX/YNn/8AQDQA34X/APJPfD3/AGDof/Qa6iuX+F//ACT3w9/2Dof/AEGuooAKQjIxS0UAcX8VPhno3xQ8NDRdRdre7tJ0vdMv4xmWyu0OUlX19CO4JFWtKa9toFsNUCfakRVkMedhbHJXPOD2rqqzdW09rgLdQD99F0H94elAHNatYZkLqvBrN+yAcba6cYuYwGGD3BqpLY7DwKAMFrQY6ViawgUbAOc11t3GIkzWPa6Lca1qAiRSBnliOFHc0AYem/Cuy8fzafL4gG/R9Mv476S1K5W7mj5jVs9UViGI7lVHTOfa1UKMAVBp9hb6baRWdsu2OIYHv71ZoAKKKKACuZ+Jv/JPfEX/AGDZ/wD0A101cz8Tf+Se+Iv+wbP/AOgGgBvwv/5J74e/7B0P/oNdRXL/AAv/AOSe+Hv+wdD/AOg11FABRRSE4oAWkPSua8QeN7DSWa1tEN5drwUU4RD/ALTdvoMmuXsNS8R+K5Lua81OS3t4AQtrakxgkDPzMDuPUd6AMXU/HGr+E/FuqSTW0mo6NJdMdiHEkBwASh7jOTtNdXpnxJ8A6vDmDxRZRSAZaG5k8mRD7q+KwrXSo7lSlwgYt97POapXvwo0HU5fNms0JPPK0AWPEfxU8IxE2mgXI1y9J2iKzOY1Pq8hGAPpk1rfCK71W5n1aXW7hWuZ/JdIl4SNBuGFHpz+tZ1l4G0vRExa2iL9FFMbQV1O6+yedc2/BIltrh4ZEI6EOhBGPy9c0AeucUtfGGq/tM/Eb4NeO9Q8F65f2/iuxtZUEEl6BFOUZQwUyxjhsEDlW5r6C+E/7QPgD4sg2Wj3j2Wrxpvk027wsuMcmMg4kUc5K8juBQB6bRSA5GaWgArmfib/AMk98Rf9g2f/ANANdNXM/E3/AJJ74i/7Bs//AKAaAG/C/wD5J74e/wCwdD/6DXUVy/wv/wCSe+Hv+wdD/wCg11FABXCeNfFs4uW8OaJLibGbqdf+WQP8I/2sd+31ro/Fmtr4e0G61TAaSNdsKn+KRuFH5n9K8r0yF7Wykvrpy882ZJHY8sx6mgCO7lg0+EwoQT3PqfU1lWXivUvCepDWLK3N7auuy9s0IDyL2dCeN65PBwGHGQQDWfqepmW4YbuAaqvcgp1oA9d8P+IvBHi1Td6Hq8XmrxNByksTdw8bfMp57iumhtIY1yt2rD3NfK2u6LYakRO8SiWPlHA+ZD6qeqn3BBrCuNW8d6NGItO8Va4I1GFH9oyvj/vtiaAPsC7t7MKWmvEUD3rx74qftAeCPh3Y3Wn+H5otX17aUFvE2VgYg4MzjIQd9udxHQdx80eJ9f8AG2ro0Gqazrl5GScxS30xjb/eQNtP0IrhL3S9VnURpbCBAcD+EAeyigDmvFural4n16W/vLlp729uDPPKe5JyT7D0HQDApbfV9U0TUINU029ntLq1kEsE8LlZInHRlI6HmtiLw6tpudstI33nI6j0+lZ2tWax27H2oA+9v2YP2kLf4u6X/wAIx4mmig8WabCHlCgKl9CMDzkHZgSA6joTkcHj3vIr8avCvjjW/AvijTvFPh67aDUdKuFuIG6gkdVI7qwJUjuDX62/C/x5pfxN8BaL470jIt9XtVm2HrFJ0kjPurhl/CgDqa5n4m/8k98Rf9g2f/0A101cz8Tf+Se+Iv8AsGz/APoBoAb8L/8Aknvh7/sHQ/8AoNdPXMfC/wD5J74e/wCwdD/6DXSySpEu5zgUAeefFq5LyaJphfCTTyTMM9SoAH/oZrl/EFyLfTW2nAP8q6D4rwprNha3GnyYvtNlaWNScCVSMMmfXgEfSvK9a8VC508W0wKSrwQwwc/SgDHkvQ0rEtnmlN4Mdf1rAF8pY8jrTjerjr+tAGnNdjaR1rMup1IO7mq02oKB1rMutRUZ5oAjvjEx3ECucv1hGcKKtX+rxKuN2a5fU9eRQQOT+VAEOpSIiN2xXD+Jr9I4HG4HIIGKu6vrkzhljDd64XW5Ly5LCTPP5UAc1dT7rglWOMnNfoT/AME4fF11q3w28R+FLqcuND1VZrdeflhuE3Y/7+RyH8a/PiPTL+8ulsrK0mubiQ7UihQu7nsAq5J/Kv0b/Yg+G958IvBGp3PilfJ1rxJcx3D23VreCNSsaPg435Z2IHTcB1FAH1SK5r4m/wDJPfEX/YNn/wDQDXQwXEU6ho2zXPfE3/knviL/ALBs/wD6AaAG/C//AJJ74e/7B0P/AKDXQ3duLmPZmvP/AIe+P/BOneB9Dsr7xVpcE8FjFHLFJcorIwXkEZ4NdD/wsz4e/wDQ5aR/4Fp/jQBm654QubrcUJwa858QfDK+uixNuX9CVzXq/wDwsz4e/wDQ5aR/4Fp/jSN8Sfh0ww3jDRz9bpP8aAPnK++FmsQsxhhcY6cGsi48C+IYOlux/wCA19Pv4/8AhlJ9/wAVaIf+3lP8agfxl8KpPveJ9E/8Ck/xoA+VpvB/iPPNmx/A1m3PgzxG5wtkfzP+FfWreJ/hK/XxPon/AIFJ/jUR8QfCM8jxRov/AIEp/jQB8eXPw38TzglbRfpk/wCFUJPgz4sujxbQqD2Jb/CvtMeIfhHjnxPov/gSn+NPXxL8JU6eJ9F/8Ck/xoA+Jk/Zx8UXzAS3kcIJydtuXJHsSRXQab+ybYzlP7V/tC75yV3iNT/3yAf1r6+Txh8KkOV8UaJ/4FJ/jVhPHvwxj+54q0Qf9vKf40AeJ+B/gRp3hbb/AGH4ftrFsbWkjiG9h7v94/ia9X0LwVdWu0uMAVtL8R/hyn3fF+jD6XSf40//AIWZ8Pf+hy0j/wAC0/xoA2rCx+yIAWyQKxfib/yT3xF/2DZ//QDR/wALM+Hv/Q5aR/4Fp/jXP+P/AB/4I1HwRrtjY+K9LnnnsJo4oo7lGd3KHAAzzQB//9k="; } email = rdr[3].ToString(); } else { username = "******"; currency = 0; avatar = ""; } Conn.Close(); } catch (Exception e) { } }
private void button3_Click(object sender, EventArgs e) { string CommandString = "update kitbox_database.kitbox set Enstock='" + this.Enstock.Text + "' where CodeBarre='" + this.CodeBarre.Text + "';"; MySql.Data.MySqlClient.MySqlCommand Command; Command = new MySql.Data.MySqlClient.MySqlCommand(CommandString, connection); MySqlDataReader myReader; if (CodeBarre.Text.Trim() == string.Empty || Enstock.Text.Trim() == string.Empty) { MessageBox.Show("Please make sure that all fields are completed"); return; // return because we don't want to run normal code of buton click } else { try { connection.Open(); myReader = Command.ExecuteReader(); MessageBox.Show("saved"); while (myReader.Read()) { } } catch (Exception ex) { MessageBox.Show(ex.Message); } LoadTable(); connection.Close(); } }
/*! * \brief This method populates the cityInfo Combo Box. * \details This methos populates the cityInfo CB by querying the CarrierCities table in the database for all of the unique city names. * \param <b>void</b> */ private void fillCityComboBox() { string conStr = ConfigurationManager.ConnectionStrings[localUser.CONSTR].ConnectionString; StringBuilder cmdSB = new StringBuilder("SELECT distinct(cityName) FROM CarrierCities;"); MySqlDataReader reader = null; using (MySqlConnection connection = new MySqlConnection(conStr)) { MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(cmdSB.ToString(), connection); try { connection.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { cityInput.Items.Add(reader["cityName"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } } }
private void Lockbtn_Click(object sender, EventArgs e) { //UPDATE PASSWORD TO DATABASE using (MySqlConnection con = new MySqlConnection("server = 35.240.129.112; user id = asguarduser; database = da_schema")) { con.Open(); string queryStr = ""; queryStr = "UPDATE Userinfo set verificationflag=@vflag, statusDate=@statusDate where userid = @userid"; MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, con); if (vflag.Text == "L") { //lock to unlock cmd.Parameters.AddWithValue("@vflag", "T"); cmd.Parameters.AddWithValue("@statusDate", "NULL"); dblog.Log("Account status changed(L -> T) by Admin", "Accounts", Logininfo.userid, Logininfo.email); } else if (vflag.Text == "T") { //unlock to lock cmd.Parameters.AddWithValue("@vflag", "L"); cmd.Parameters.AddWithValue("@statusDate", DateTime.Now.ToString("dd'/'MM'/'yyyy HH:mm:ss")); dblog.Log("Account status changed(T -> L) by Admin", "Accounts", Logininfo.userid, Logininfo.email); } else if (vflag.Text == "A") { MessageBox.Show("User had been archived."); } cmd.Parameters.AddWithValue("@userid", AdminSession.userid); cmd.ExecuteReader(); con.Close(); } userdataRetrieval(); }
private void DoSQLQueryPieBanque() { try { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); queryStr = ""; queryStr = "SELECT * FROM database.detail WHERE detail.titre='Solde banque'"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { BIATD = reader.GetInt32(reader.GetOrdinal("t1")); BIATE = reader.GetInt32(reader.GetOrdinal("t2")); STB = reader.GetInt32(reader.GetOrdinal("t3")); } reader.Close(); conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
private void DoSQLQuery1() { try { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); queryStr = ""; queryStr = "SELECT * FROM database.tbl_user WHERE tbl_user.id='" + Session["Id"] + "' "; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { education = reader.GetString(reader.GetOrdinal("education")); localisation = reader.GetString(reader.GetOrdinal("localisation")); } if (reader.HasRows) { // Session["uname"] = name; // userName = (String)(Session["utname"]); // Label14.Text = userName; LabelEducation.Text = education; LabelLocation.Text = localisation; } reader.Close(); conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
/// <summary> /// 根据主键查询 /// </summary> /// <param name="primaryKey"></param> /// <returns></returns> public DialogueSettingBO Get(string primaryKey) { string sql = "SELECT client,username,password,database_id,workspace_id,emailtype_id,email_id,ftp_account_id,prefix,sms_account,sms_password,sms_pid FROM t_dialoguesetting where APIKey=@APIKey"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@APIKey", primaryKey); MySqlDataReader reader = command.ExecuteReader(); DialogueSettingBO DB_DialogueSetting = null; if (reader.Read()) { DB_DialogueSetting = new DialogueSettingBO(); DB_DialogueSetting.client = reader["client"] == DBNull.Value ? "" : reader["client"].ToString(); DB_DialogueSetting.username = reader["username"] == DBNull.Value ? "" : reader["username"].ToString(); DB_DialogueSetting.password = reader["password"] == DBNull.Value ? "" : reader["password"].ToString(); DB_DialogueSetting.contactDatabaseId = reader["database_id"] == DBNull.Value ? "" : reader["database_id"].ToString(); DB_DialogueSetting.workspaceId = reader["workspace_id"] == DBNull.Value ? "" : reader["workspace_id"].ToString(); DB_DialogueSetting.emailTypeId = reader["emailtype_id"] == DBNull.Value ? "" : reader["emailtype_id"].ToString(); DB_DialogueSetting.directEmailId = reader["email_id"] == DBNull.Value ? "" : reader["email_id"].ToString(); DB_DialogueSetting.ftpAccountId = reader["ftp_account_id"] == DBNull.Value ? "" : reader["ftp_account_id"].ToString(); DB_DialogueSetting.sms_account = reader["sms_account"] == DBNull.Value ? "" : reader["sms_account"].ToString(); DB_DialogueSetting.sms_password = reader["sms_password"] == DBNull.Value ? "" : reader["sms_password"].ToString(); DB_DialogueSetting.sms_pid = reader["sms_pid"] == DBNull.Value ? "" : reader["sms_pid"].ToString(); DB_DialogueSetting.prefix = reader["prefix"] == DBNull.Value ? "" : reader["prefix"].ToString(); } return DB_DialogueSetting; } }
protected void Page_Load(object sender, EventArgs e) { Button2.Visible = false; DateTime dNow = DateTime.Now; TextBox1.Text = (dNow.ToString("MM/dd/yyyy")); txtReqId.Text = Request.QueryString["val"]; txtReqDate.Text = Request.QueryString["val2"]; txtapprove.Text = Request.QueryString["val5"]; if (!this.IsPostBack) { // MySql.Data.MySqlClient.MySqlCommand cmd; conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString); conn.Open(); string query = "SELECT item_name,itemid FROM procurement.item where reqid ='" + txtReqId.Text + "' "; cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn); ListBox1.DataSource = cmd.ExecuteReader(); ListBox1.DataTextField = "item_name"; ListBox1.DataValueField = "itemid"; ListBox1.DataBind(); conn.Close(); } }
public void Initialize() { Logger.WriteLog("Loading the server list...", Logger.LogType.Initialize); MySqlCommand cmd = new MySqlCommand("SELECT * FROM servers", DatabaseFactory.Instance.GetDBConnection()); using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { GameServerList.Add(dr.GetString(1), new GameServerInfo() { ServerID = dr.GetByte(0), ServerName = dr.GetString(1), ServerAddr = IPAddress.Parse(dr.GetString(2)), ServerPort = dr.GetInt16(3), OnlineUsers = dr.GetInt16(7), DateCreated = dr.GetDateTime(4), DeveloperOnly = Convert.ToBoolean(dr.GetByte(6)) }); } dr.Close(); } }
/// <summary> /// Gets the Clients by logged in User role /// </summary> /// <param name="LoggedInUser"></param> /// <returns></returns> public List <User> getClients(User LoggedInUser) { MySql.Data.MySqlClient.MySqlCommand Using; List <User> Clients = new List <User>(); DAL.DBRoleConnection dBRoleConnection = new DBRoleConnection(); switch (LoggedInUser.RoleID) { case 2: Using = new MySql.Data.MySqlClient.MySqlCommand("select user.ID, user.BsnNumber,user.FirstName,user.LastName from user where user.Confirmed!=0", con); break; case 6: Using = new MySql.Data.MySqlClient.MySqlCommand("select user.ID, user.BsnNumber,user.FirstName,user.LastName from user where user.MainTherapistID=@therapistid and user.Confirmed!=0", con); break; case 7: Using = new MySql.Data.MySqlClient.MySqlCommand("select user.ID, user.BsnNumber,user.FirstName,user.LastName from user where user.Confirmed!=0", con); break; default: Using = new MySql.Data.MySqlClient.MySqlCommand("select user.ID, user.BsnNumber,user.FirstName,user.LastName from user where user.MainTherapistID=@therapistid and user.Confirmed!=0", con); break; } using (MySql.Data.MySqlClient.MySqlCommand cmd = Using) { cmd.Parameters.AddWithValue("@therapistid", (LoggedInUser.ID != 0) ? LoggedInUser.ID : throw new Exception("No rights to perform this action (User.ID = null)")); try { con.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { User Client = new User(); Client.ID = (int)reader["ID"]; Client.BsnNumber = (string)reader["BsnNumber"]; Client.FirstName = (string)reader["BsnNumber"] + " " + (string)reader["FirstName"] + " " + (string)reader["LastName"]; Clients.Add(Client); } } catch (Exception ex) { if (con.State != System.Data.ConnectionState.Closed) { con.Close(); } throw new Exception(ex.Message); } if (con.State != System.Data.ConnectionState.Closed) { con.Close(); } } return(Clients); }
public IDataReader ExecuteDataReader(Saga.Data.IQueryProvider query, CommandBehavior behavior) { MySqlConnection connection = ConnectionPool.Request(); MySqlCommand command = new MySqlCommand(); MySqlDataReader reader = null; try { command.CommandText = query.CmdText; command.Connection = connection; foreach (KeyValuePair<string, object> pair in query.Parameters) { command.Parameters.AddWithValue(pair.Key, pair.Value); } return command.ExecuteReader(behavior); } catch (Exception e) { __dbtracelog.WriteError("Database", e.Message); return null; } finally { //ALWAYS CLOSE THE CONNECTION AND REPOOL THE ITEMS if (reader != null && reader.IsClosed == false) reader.Close(); ConnectionPool.Release(connection); } }
public static void LoadItems() { lock (DatabaseHandler.ConnectionLocker) { var sqlText = "SELECT * FROM datas_items"; var sqlCommand = new MySqlCommand(sqlText, DatabaseHandler.Connection); var sqlReader = sqlCommand.ExecuteReader(); while (sqlReader.Read()) { var item = new Models.Items.ItemModel(); item.ID = sqlReader.GetInt32("ID"); item.Pods = sqlReader.GetInt16("Weight"); item.Price = sqlReader.GetInt32("Price"); item.Type = sqlReader.GetInt16("Type"); item.Level = sqlReader.GetInt16("Level"); item.Jet = sqlReader.GetString("Stats"); item.Condistr = sqlReader.GetString("Conditions"); item.ParseWeaponInfos(sqlReader.GetString("WeaponInfo")); item.ParseRandomJet(); lock(ItemsList) ItemsList.Add(item); } sqlReader.Close(); } Utilities.Loggers.StatusLogger.Write(string.Format("Loaded @'{0}' items@ from the database !", ItemsList.Count)); }
private void DoSQLAffiche1() { try { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); queryStr = ""; queryStr = "SELECT * FROM database.event WHERE event.iduser='******' AND event.idex='2'"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { namec1 = reader.GetString(reader.GetOrdinal("name")); monthstart1 = reader.GetInt32(reader.GetOrdinal("monthstart")); yearstart1 = reader.GetInt32(reader.GetOrdinal("yearstart")); daystart1 = reader.GetInt32(reader.GetOrdinal("daystart")); yearend1 = reader.GetInt32(reader.GetOrdinal("yearend")); monthend1 = reader.GetInt32(reader.GetOrdinal("monthend")); dayend1 = reader.GetInt32(reader.GetOrdinal("dayend")); hstart1 = reader.GetInt32(reader.GetOrdinal("hstart")); hend1 = reader.GetInt32(reader.GetOrdinal("hend")); minstart1 = reader.GetInt32(reader.GetOrdinal("minstart")); minend1 = reader.GetInt32(reader.GetOrdinal("minend")); } Labelnamec1.Text = namec1; } catch (Exception ex) { Console.WriteLine(ex); } reader.Close(); conn.Close(); }
protected void Onayla(object sender, EventArgs e) { belge = h.InnerText; String connStr = System.Configuration.ConfigurationManager.ConnectionStrings["WebConnString"].ToString(); using (conn = new MySql.Data.MySqlClient.MySqlConnection(connStr)) { conn.Open(); if (OnayRadio.SelectedValue == "Makaleyi Onayla") { queryStr = "Update tasarimdersi.yazarmakale set onay = 'Hakem tarafından Onaylandı' WHERE makalepdf ='" + belge + "'"; } else if (OnayRadio.SelectedValue == "Makaleyi Reddet") { queryStr = "Update tasarimdersi.yazarmakale set onay = 'Hakem tarafından ONAYLANMADI' WHERE makalepdf ='" + belge + "'"; } else if (OnayRadio.SelectedValue == "Makaleyi Onay Sürecinde Bırak") { queryStr = "Update tasarimdersi.yazarmakale set onay = 'Hakem İncelemesinde' WHERE makalepdf ='" + belge + "'"; } else { queryStr = "Update tasarimdersi.yazarmakale set onay = 'Editör İncelemesinde' WHERE makalepdf ='" + belge + "'"; } cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); cmd.ExecuteReader(); conn.Close(); Response.Redirect(Request.RawUrl); } }
public List<Categoria> getCategoriaConProductosParaImprimirCodigos() { int totalCat = getTotalCategoria(); ProductoFacade prodFac = new ProductoFacade(); string consulta = "SELECT*FROM categoria"; List<Categoria> listaCategoria = new List<Categoria>(); MySqlCommand cmd = new MySqlCommand(consulta, getconexion.getConexion()); MySqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { if (prodFac.getProductosBynombreCategoria(read.GetString(1)).Count > 0) { listaCategoria.Add(new Categoria(read.GetInt32(0), read.GetString(1), read.GetDateTime(2))); } } getconexion.CerrarConexion(); return listaCategoria; }
// This is used for saving the messages to the database. // The messages need to have correct userIDs - used to establish who sent them - and correct caseIdDs - used to establish which case the message belongs to. public String[] getUserIDcaseID() { // Array is tidier than multiple strings, make use of indexes. String[] IDs = new String[2]; IDs[0] = uID; // Populated with the Session method during Page_Load - no need to query DB for this. String connString = System.Configuration.ConfigurationManager.ConnectionStrings["projectConnectionString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); queryStr = ""; // Use case_name to obtain case ID from the allcases table. queryStr = "SELECT case_id FROM project.allcases WHERE case_name=?cname"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); cmd.Parameters.AddWithValue("?cname", case_name); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { // Grab caseID. IDs[1] = reader.GetString(reader.GetOrdinal("case_id")); } reader.Close(); // Return the array, therefore method can be called and assigned to varaible due to return - efficient. return(IDs); }
public getSingleDept oneProgID(string als) { MySql.Data.MySqlClient.MySqlConnection conn; string feashConn; feashConn = ConfigurationManager.ConnectionStrings["localDB"].ConnectionString; conn = new MySql.Data.MySqlClient.MySqlConnection(); try { conn.ConnectionString = feashConn; conn.Open(); getSingleDept d = new getSingleDept(); MySql.Data.MySqlClient.MySqlDataReader getReader = null; string getString = "SELECT * FROM Dept_ProgramID WHERE DeptProgramID = '" + als.ToString() + "';"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(getString, conn); getReader = cmd.ExecuteReader(); if (getReader.Read()) { d.DName = getReader.IsDBNull(0) == false?getReader.GetString(0) : null; d.DEntity = getReader.IsDBNull(1) == false?getReader.GetString(1) : null; d.ProgramID = getReader.IsDBNull(2) == false?getReader.GetString(2) : null; return(d); } else { return(null); } } catch (MySql.Data.MySqlClient.MySqlException ex) { throw ex; } finally { conn.Close(); } }
public List <string> ChatGetUsername() { //string chatInfo; String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString; conn = new MySql.Data.MySqlClient.MySqlConnection(connString); try { conn.Open(); MySqlCommand cmd = new MySqlCommand(queryString, conn); List <string> storeDate = new List <string>(); queryString = "SELECT username FROM dububase.chat"; cmd.CommandText = queryString; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryString, conn); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { storeDate.Add((reader["username"].ToString())); } return(storeDate); } catch (System.Data.SqlClient.SqlException ex) { string errorMsg = "Error"; errorMsg += ex.Message; throw new Exception(errorMsg); } finally { reader.Close(); conn.Close(); } }
protected void selectthegrp(object sender, EventArgs e) { string clsid = (String)Session["clsid"]; string tgrpid = "grp_" + clsid; Int32 mygrp = Convert.ToInt32(grpnumber.Text); int stuid = (Int32)Session["stuid"]; String connstring = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConString"].ToString(); connectiong = new MySql.Data.MySqlClient.MySqlConnection(connstring); connectiong.Open(); querystr1 = "select count(*) from " + tgrpid + " where groupid=" + mygrp + ""; cmd = new MySql.Data.MySqlClient.MySqlCommand(querystr1, connectiong); long check = (long)cmd.ExecuteScalar(); Int32 checks = Convert.ToInt32(check); if (checks < 6) { querystr = "update " + tgrpid + " set groupid='" + mygrp + "' where uhclid=" + stuid + ""; cmd = new MySql.Data.MySqlClient.MySqlCommand(querystr, connectiong); reader = cmd.ExecuteReader(); reader.Close(); Int32 num = Convert.ToInt32(grpnumber.Text); show.Text = "Your group number is " + num; } else { show.Text = "The maximum limit of group is only 6..Please select other group!!"; } }
public int GetStaffID(string loginName) { int id = 0; using (MySqlConnection connection = new MySqlConnection(GetConnection())) { MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(); cmd.Connection = connection; cmd.CommandText = string.Format("SELECT staff_id FROM sakila.staff where first_name = '{0}'", loginName); try { connection.Open(); MySqlDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (myReader.Read()) { id = myReader.GetInt32(0); break; } myReader.Close(); } finally { connection.Close(); } } return(id); }
private static void LoadCharacters() { Utilities.ConsoleStyle.Infos("Loading @characters@ .."); var query = new MySqlCommand("SELECT * FROM characters", DatabaseManager.Connection); var reader = query.ExecuteReader(); while (reader.Read()) { var character = new Models.Character() { ID = reader.GetInt32("id"), Account = reader.GetInt32("account"), Nickname = reader.GetString("nickname"), Level = reader.GetInt32("level"), Experience = reader.GetInt64("experience"), Sex = reader.GetInt32("sex"), Breed = reader.GetInt32("breed"), SkinColor = reader.GetInt32("skincolor"), HairColor = reader.GetInt32("haircolor"), PupilColor = reader.GetInt32("pupilcolor"), SkinColorFactor = reader.GetInt32("skincolorfactor"), HairColorFactor = reader.GetInt32("haircolorfactor"), Cloth = reader.GetInt32("cloth"), Face = reader.GetInt32("face"), Title = reader.GetInt32("title"), }; Characters.Add(character); } reader.Close(); Utilities.ConsoleStyle.Infos("Loaded @'" + Characters.Count + "'@ characters !"); }
public List <getAllDepts> OneEntName(string als) { MySql.Data.MySqlClient.MySqlConnection conn; string feashConn; feashConn = ConfigurationManager.ConnectionStrings["localDB"].ConnectionString; conn = new MySql.Data.MySqlClient.MySqlConnection(); try { conn.ConnectionString = feashConn; conn.Open(); string getString = "SELECT * FROM Dept_ProgramID WHERE DeptEntity = '" + als.ToString() + "';"; var d = new List <getAllDepts>(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(getString, conn); MySqlDataReader fetch_query = cmd.ExecuteReader(); while (fetch_query.Read()) { d.Add( new getAllDepts( fetch_query["DeptName"] != DBNull.Value ? fetch_query["DeptName"].ToString() : null, fetch_query["DeptEntity"] != DBNull.Value ? fetch_query["DeptEntity"].ToString() : null, fetch_query["DeptProgramID"] != DBNull.Value ? fetch_query["DeptProgramID"].ToString() : null ) ); } return(d); } catch (MySql.Data.MySqlClient.MySqlException ex) { throw ex; } finally { conn.Close(); } }
/// <summary> /// Initializes a new instance of the <see cref="ManagerGeneralItemStagesGui"/> class. /// </summary> /// <param name="itemid">The itemid.</param> public ManagerGeneralItemStagesGui(string itemid) { //Login.close = 1; InitializeComponent(); this.WindowStartupLocation = WindowStartupLocation.CenterScreen; this.itemID = itemid; try { MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = "select itemName from item where itemid='" + itemID + "'"; MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); MySqlDataReader dr = MSQLcrcommand1.ExecuteReader(); while (dr.Read()) { if (!dr.IsDBNull(0)) { itemName = dr.GetString(0); } } MySqlConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } type_comboBox.Items.Add("רישום"); type_comboBox.Items.Add("בעבודה"); type_comboBox.Items.Add("תיקון"); type_comboBox.Items.Add("פסול"); type_comboBox.Items.Add("גמר ייצור"); type_comboBox.Items.Add("הסתיים"); type_comboBox.SelectedIndex = 0; itemidlabel.Content = itemID; itemnamelabel.Content = itemName; try { MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring); MySqlConn.Open(); string Query1 = ("SELECT itemStageOrder as `מספר שלב`,stageName as `שם שלב` ,stage_discription as `תאור השלב` FROM item WHERE itemid='" + itemID + "' and itemStatus='רישום' "); MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn); MSQLcrcommand1.ExecuteNonQuery(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1); dt.Clear(); mysqlDAdp.Fill(dt); dataGrid1.ItemsSource = dt.DefaultView; mysqlDAdp.Update(dt); MySqlConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public SignalProp getCurSigProp() { SignalProp prop = null; String sql = " SELECT s.lampId, s.signalName, s.type, s.state, c.state as specState, direction, dir_to, s.ip FROM cursignal c LEFT JOIN signal s ON c.lampId=s.lampId AND c.type=1 "; MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn); System.Data.Common.DbDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { prop = new SignalProp(); prop.SignalID = reader.GetString(0).ToUpper(); prop.SignalName = DBStringToNormal(reader.GetString(1)); prop.Type = reader.IsDBNull(2)? (byte)0 : (byte)reader.GetInt16(2); prop.State = reader.GetString(3); prop.SpecState = reader.IsDBNull(4) ? (byte)0 : (byte)reader.GetInt16(4); prop.DirFrom = reader.IsDBNull(5) ? (byte)0 : (byte)reader.GetInt16(5); prop.DirTo = reader.IsDBNull(6) ? (byte)0 : (byte)reader.GetInt16(6); prop.Ip = reader.GetString(7); } reader.Close(); } catch (Exception e) { reader.Close(); Trace.TraceError("get cur signal prop " + e.StackTrace); } return(prop); }
private static string pobierzDane(string name, string column) { var pos = ""; try { string server = @"SERVER=localhost;PORT=3306;DATABASE=pizzeria;UID=pizzeria;"; using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(server)) { MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand("SELECT " + column + " FROM Menu WHERE name LIKE '" + name + "'", connection); connection.Open(); using (MySqlDataReader read = command.ExecuteReader()) { while (read.Read()) { pos = read[column].ToString(); } connection.Close(); } } } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Błąd." + ex, ex.ToString()); } return(pos); }
protected void Page_Load(object sender, EventArgs e) // Open the connection to the database, read data from a table, display it on the page { Globals.conn.Open(); string query = "SELECT * FROM book"; // Change the 'book' table to a table name in your database var cmd = new MySql.Data.MySqlClient.MySqlCommand(query, Globals.conn); var reader = cmd.ExecuteReader(); // lblMyOutput.Text = String.Empty; while (reader.Read()) { var titleValue = reader["Title"]; // get data from the 'Title' column of the book table var isbnValue = reader["isbn"]; // Do something with the retrieved values // lblMyOutput.Text += "Book title is " + titleValue.ToString() // + " and its ISBN is " + isbnValue.ToString() // + "<br>"; } searchTerm = Session["searchTerm"].ToString(); searchMethod(searchTerm); }
public string GetSchedule(string phone, string ordernum) { con.Open(); MySqlCommand cmd = new MySqlCommand("select TechnicianName, Phone, sdate,slotnumber,idtechnician,order_id from fosimple.technician t join fosimple.schedule s on s.technician_id = t.idTechnician join fosimple.orders o on o.idorders =s.order_id where idorders = " + ordernum + " and mobilenumber = '" + phone + "'", con); MySqlDataReader dr = cmd.ExecuteReader(); string techname = "", ph = "", sdate = "", slot = ""; int tid = 0; if (dr.Read()) { techname = dr[0].ToString(); ph = dr[1].ToString(); sdate = dr[2].ToString(); slot = dr[3].ToString(); // tid = Convert.ToInt16(dr[4].ToString()); } if(sdate != "") { if (Convert.ToDateTime(sdate) < DateTime.Now) { techname = "Completed"; } sdate = Convert.ToDateTime(sdate).Month.ToString() + "/" + Convert.ToDateTime(sdate).Day.ToString() + "/" + Convert.ToDateTime(sdate).Year.ToString(); } dr.Dispose(); con.Close(); return techname + "##" + ph + "##" + sdate + "##" + slot; }
public List <EUsuario> getAll() { EUsuario objUser = null; List <EUsuario> lista = new List <EUsuario>(); string sql = "SELECT * FROM USUARIOS "; using (conexion cnx = new conexion()) { cnx.cadena = ConfigSAE.Instanciar.cadenaSAE(); using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand()) { cmd.CommandText = sql; cmd.Connection = cnx.getConexion(); if (cnx.abrirConexion()) { MySql.Data.MySqlClient.MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objUser = mapearObjeto(dr); lista.Add(objUser); } cnx.cerrarConexion(); } } return(lista); } }
public void add_date_firstDay(string date, int line, string first, string sec, string thi, string four, string fiv, string six, string sev, string eig, string nin, string ten, string ele,string twe) { DateTime dt = Convert.ToDateTime(date); //string connect = "datasource = 127.0.0.1; port = 3306;Connection Timeout=30; Min Pool Size=20; Max Pool Size=200; username = root; password = ;"; MySqlConnection conn = new MySqlConnection(connect); MySqlCommand sda = new MySqlCommand(@"insert into shedulling.tablelayout1 values ('" + dt + "','" + line + "','" + first + "','" + sec + "','" + thi + "','" + four + "','" + fiv + "','" + six + "','" + sev + "','" + eig + "','" + nin + "','" + ten + "', '" + ele + "','"+twe+ "')", conn); MySqlDataReader reader; try { conn.Open(); reader = sda.ExecuteReader(); while (reader.Read()) { } reader.Close(); conn.Close(); conn.Dispose(); } catch (Exception e) { MessageBox.Show(e.Message); } finally { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); } } }