public static void Login(string username, string passhash) { if (Validate(username, passhash)) { time = string.Format("{0:yyyy.MM.dd 0:HH:mm:ss tt}", DateTime.Now); rdr = new MySqlCommand("SELECT lastin FROM login WHERE username='******';", conn).ExecuteReader(); while (rdr.Read()) { Console.WriteLine("User's last sign in was: " + rdr["lastin"]); } rdr.Close(); new MySqlCommand("UPDATE login SET lastin='" + time + "' WHERE username='******';", conn).ExecuteNonQuery(); } Console.WriteLine("HHHHhhhh"); //TODO: // //If the username exists, check that the password hash matches. // //If the username does not exist, be like "No user found". // //Else, If the password hash matches, Sign in. //Set the current player to active //forward/bind socket to control an Object? //Note the timestamp and IP of the login in the database //Send all of the necessary information back to the client: }
public static StatusFilmDTO readerToStatusFilmDTO(MySqlDataReader reader) { StatusFilmDTO status = new StatusFilmDTO(); status.Id = reader.GetInt32("idStatusFilm"); status.Naziv = reader["nazivStatusFilm"].ToString(); return status; }
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); }
protected Game GetGameFromDataReader(MySqlDataReader dataReader) { string gameNaam = dataReader.GetString("gamenaam"); int gameId = dataReader.GetInt32("game_id"); Game game = new Game { ID = gameId, Naam = gameNaam }; return game; }
public void findAll() { db = new Database(); brands.Clear(); brandQuery = new MySqlCommand(); brandQuery.Connection = db.Connection(); brandQuery.CommandText = "SELECT * FROM brand ORDER BY brandname ASC"; this.brandResult = brandQuery.ExecuteReader(); while (brandResult.Read()) { if (!brandResult.IsDBNull(0)) { idbrand = brandResult.GetInt32(0); } if (!brandResult.IsDBNull(1)) { brandname = brandResult.GetString(1); } brands.Add(new Brand { idbrand = this.idbrand, brandname = this.brandname}); } db.Close(); }
private void button1_Click(object sender, EventArgs e) { string pwss = textBox1.Text.ToString(); string confirm = textBox2.Text.ToString(); if (pwss == confirm) { if (this.textBox3.Text.ToString() == usuario_activo.pw) { sentenciaSQL = "UPDATE sql28127.usuarios SET pw='" + this.textBox2.Text + "' where id_usuario= '" + usuario_activo.id + "' ;"; // sentenciaSQL = "UPDATE test.usuarios SET pw='" + this.textBox2.Text + "' where id_usuario= '" + usuario_activo.id + "' ;"; comando = new MySqlCommand(sentenciaSQL, conexion); resultado = comando.ExecuteReader(); MessageBox.Show("Cambio completado", "Aceptado"); this.Close(); Form3 principal = new Form3(); principal.Show(); } else { MessageBox.Show("Tercer campo \"Repetir Contraseña\" erroneo", "ERROR"); } } else { MessageBox.Show("Igualar Contraseñas", "ERROR"); } }
private static ContractType rdrParse(MySqlDataReader rdr) { return new ContractType { Id = rdr.GetInt32 ("id"), Name = rdr.GetString ("name") }; }
private static void show(MySqlDataReader mysqlDataReader) { Console.WriteLine (); while (mysqlDataReader.Read()) { Console.WriteLine ("{0} {1}", mysqlDataReader ["id"], mysqlDataReader ["nombre"]); } }
private bool DoSQLQueryTest() { try { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); String queryStr = ""; queryStr = "SELECT COUNT(id) as countindex FROM database.metadata WHERE metadata.codeuser='******' "; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); countindex = 0; while (reader.HasRows && reader.Read()) { countindex = reader.GetInt32(reader.GetOrdinal("countindex")); } if (countindex != 0) { return(true); } reader.Close(); conn.Close(); } catch (Exception ex) { Console.WriteLine(ex); } return(false); }
public bool deleteCustomer(long contactNo) { Customer p = new Customer(); MySqlConnection conn = mysqlDbConnect.GetConnection(); MySql.Data.MySqlClient.MySqlDataReader mySqlReade = null; String sqlString = "SELECT * FROM customer WHERE contactNo = '" + contactNo.ToString() + "'"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); mySqlReade = cmd.ExecuteReader(); if (mySqlReade.Read()) { mySqlReade.Close(); sqlString = "DELETE FROM customer WHERE contactNo = '" + contactNo.ToString() + "'"; cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); cmd.ExecuteNonQuery(); return(true); } else { return(false); } }
public ArrayList getCustomer() { ArrayList CustomerArray = new ArrayList(); MySqlConnection conn = mysqlDbConnect.GetConnection(); MySql.Data.MySqlClient.MySqlDataReader mySqlReade = null; String sqlString = "SELECT * FROM customer"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); mySqlReade = cmd.ExecuteReader(); while (mySqlReade.Read()) { Customer p = new Customer(); p.contactNo = mySqlReade.GetInt32(0); p.firstName = mySqlReade.GetString(1); p.lastName = mySqlReade.GetString(2); p.email = mySqlReade.GetString(3); p.address = mySqlReade.GetString(4); p.password = mySqlReade.GetString(5); CustomerArray.Add(p); } return(CustomerArray); }
public Customer getCustomer(long contactNo) { Customer p = new Customer(); MySqlConnection conn = mysqlDbConnect.GetConnection(); MySql.Data.MySqlClient.MySqlDataReader mySqlReade = null; String sqlString = "SELECT * FROM customer WHERE contactNo = '" + contactNo.ToString() + "'"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); mySqlReade = cmd.ExecuteReader(); if (mySqlReade.Read()) { p.contactNo = mySqlReade.GetInt32(0); p.firstName = mySqlReade.GetString(1); p.lastName = mySqlReade.GetString(2); p.email = mySqlReade.GetString(3); p.address = mySqlReade.GetString(4); p.password = mySqlReade.GetString(5); return(p); } else { return(null); } }
public Drink loadDrinkDetails(int drinkId) { Drink p = new Drink(); MySqlConnection conn = mysqlDbConnect.GetConnection(); MySql.Data.MySqlClient.MySqlDataReader mySqlReade = null; String sqlString = "SELECT * FROM drink WHERE drinkId='" + drinkId + "'"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); mySqlReade = cmd.ExecuteReader(); if (mySqlReade.Read()) { p.drinkId = mySqlReade.GetInt32(0); p.drinkName = mySqlReade.GetString(1); p.drinkPrice = mySqlReade.GetInt32(2); return(p); } else { return(null); } }
public Food loadFoodDetails(int foodId) { Food p = new Food(); MySqlConnection conn = mysqlDbConnect.GetConnection(); MySql.Data.MySqlClient.MySqlDataReader mySqlReade = null; String sqlString = "SELECT * FROM food WHERE foodId='" + foodId + "'"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); mySqlReade = cmd.ExecuteReader(); if (mySqlReade.Read()) { p.foodId = mySqlReade.GetInt32(0); p.foodName = mySqlReade.GetString(1); p.foodPrice = mySqlReade.GetInt32(2); return(p); } else { return(null); } }
private void ReviewRecipeData(String recId) { ///Get recipe data from database by recipe id try { CheckStateDB(); String sql_get = "SELECT recipe_name, detail, materialCode FROM recipe WHERE recipe_id = @recipe_id"; cmd = new MySqlCommand(sql_get, conn); cmd.Parameters.AddWithValue("@recipe_id", recId); reader = cmd.ExecuteReader(); while (reader.Read()) { this.recipeName.Text = reader.GetString("recipe_name"); this.recipeDetail.Text = reader.GetString("detail"); this.recipeMaterial.Text = reader.GetString("materialCode"); } reader.Close(); } catch (Exception e) { ErrorLogCreate(e); MessageBox.Show("เกิดข้อผิดพลาด ข้อมูล error บันทึกอยู่ในไฟล์ log กรุณาแจ้งข้อมูลดังกล่าวแก่ทีมติดตั้ง" , "ข้อผิดพลาด", MessageBoxButton.OK, MessageBoxImage.Warning); } }
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); }
private void DoSQLCountComment() { try { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connString); conn.Open(); String queryStr = ""; queryStr = "SELECT COUNT(id) as countcom FROM database.comment WHERE comment.codeuser='******' AND comment.idmetadata= (SELECT id from database.metadata WHERE metadata.codeuser='******') "; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); count = ""; while (reader.HasRows && reader.Read()) { count = reader.GetString(reader.GetOrdinal("countcom")); } if (reader.HasRows) { LaCountComment.Text = count; } reader.Close(); conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
public static void show(MySqlDataReader mySqlDataReader) { // METODO QUE MUESTRA TODO EL CONETNIDO DE LA TABLA Console.WriteLine ("FILAS : "); // EL SHOW MUESTRA EL SHOWROW (FILA). EL SHOWROW MUESTRA LA FILA while (mySqlDataReader.Read()) showRow (mySqlDataReader); }
protected void btn_show_Click(object sender, EventArgs e) { conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString); conn.Open(); try { cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM assigned_employee where reqid='" + tb_reqid.Text + "'"; reader = cmd.ExecuteReader(); //int x =reader.ro; //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('COUNT IS '+'"+x+"');</script>"); //("COUNT IS " + x); //DataTable dt = new DataTable(); //dt.Load(reader); //int numberOfResults = dt.Rows.Count; //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('COUNT IS '+'" + numberOfResults + "');</script>"); //for (int z=0; z< numberOfResults; z++) //{ while (reader.Read()) { tb_assignedto.Text = tb_assignedto.Text + reader.GetString("name") + "\n"; } //} } catch { } conn.Close(); }
public System.Data.DataTable DataReaderToDataTable(MySqlDataReader Reader) { System.Data.DataTable dt = new System.Data.DataTable(); System.Data.DataColumn dc; System.Data.DataRow dr; ArrayList arr = new ArrayList(); int i; for(i=0;i<Reader.FieldCount;i++) { dc = new System.Data.DataColumn(); dc.ColumnName = Reader.GetName(i); arr.Add(dc.ColumnName); dt.Columns.Add(dc); } while(Reader.Read()) { dr = dt.NewRow(); for (i=0;i<Reader.FieldCount;i++) { dr[(string)arr[i]] = Reader[i].ToString(); } dt.Rows.Add(dr); } Reader.Close(); return dt; }
public static ArrayList MySQL_Column(string server, string username, string password, string database, string table, string port = "3306") { //Ip+端口+数据库名+用户名+密码 string connectStr = "server=" + server + ";port=" + port + ";database=information_schema" + ";user="******";password="******";"; ArrayList columns = new ArrayList(); MySqlConnection conn = new MySqlConnection(connectStr);; try { conn.Open();//跟数据库建立连接,并打开连接 string sql = "select column_name from information_schema.columns where table_schema='" + database + "' and table_name='" + table + "'"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySql.Data.MySqlClient.MySqlDataReader msqlReader = cmd.ExecuteReader(); while (msqlReader.Read()) { //do something with each record columns.Add(msqlReader[0]); } } catch (Exception e) { Console.WriteLine(e.ToString()); } finally { conn.Clone(); } return(columns); }
public void InitFromData(MySqlDataReader reader) { Id = (int)reader["id"]; Ip = (string)reader["ip"]; Port = (int)reader["port"]; Status = ServerStatusEnum.OFFLINE; }
public static ArrayList MySQL_DateBase(string server, string username, string password, string port = "3306") { //Ip+端口+数据库名+用户名+密码 string connectStr = "server=" + server + ";port=" + port + ";database=information_schema" + ";user="******";password="******";"; ArrayList datebase = new ArrayList(); MySqlConnection conn = new MySqlConnection(connectStr);; try { conn.Open();//跟数据库建立连接,并打开连接 string sql = "select schema_name from information_schema.schemata"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySql.Data.MySqlClient.MySqlDataReader msqlReader = cmd.ExecuteReader(); while (msqlReader.Read()) { //do something with each record // Console.WriteLine(" Datebase: " + msqlReader[0]); if ((msqlReader[0].ToString() != "information_schema") && (msqlReader[0].ToString() != "mysql") && (msqlReader[0].ToString() != "performance_schema") && (msqlReader[0].ToString() != "sys")) { datebase.Add(msqlReader[0]); } } } catch (Exception e) { Console.WriteLine(e.ToString()); } finally { conn.Clone(); } return(datebase); }
//管理员创建用户 public int registUser(UserBean bean) { try { string selectSql = "select * from users as u where u.ACCOUNT='" + @bean.Account + "'"; reade = MySqlHelper.ExecuteReader(MySqlHelper.Conn, CommandType.Text,selectSql, new MySqlParameter("@bean.Account", bean.Account)); if (reade.Read()) return HAS; string pawMd = Session.MD5Encrypt(bean.Password); string sql = "insert into users(ACCOUNT,USER_NAME,TYPE,PASSWORD,STATUS,CREATE_ID,CREATE_TIME,PHONE) values('" + @bean.Account + "','" + @bean.UserName + "'," + @bean.Type + ",'" + @pawMd + "'," + @bean.Status + "," + @bean.CreateId + ",'" + @bean.CreateTime + "','"[email protected]+"')"; MySqlParameter[] parameter = { new MySqlParameter("@bean.Account",bean.Account), new MySqlParameter("@bean.UserName",bean.UserName), new MySqlParameter("@bean.Type",bean.Type), new MySqlParameter("@pawMd",pawMd), new MySqlParameter("@bean.Status",bean.Status), new MySqlParameter("@bean.CreateId",bean.CreateId), new MySqlParameter("@bean.CreateTime",bean.CreateTime.ToString("yyyy-MM-dd hh:mm:ss")), new MySqlParameter("@bean.Phone",bean.Phone), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text,sql, parameter); } catch (Exception e) { e.GetBaseException(); return SYSTEM_EXCEPTION; } return SUCCESS; }
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!!"; } }
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); }
// 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); }
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 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 Values getValues(int id) { Values v = new Values(); MySql.Data.MySqlClient.MySqlDataReader mySQLReader = null; string sqlString = $"SELECT * FROM Products WHERE id ={id}"; MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn); mySQLReader = cmd.ExecuteReader(); if (mySQLReader.Read()) { v.id = mySQLReader.GetInt32(0); v.product_name = mySQLReader.GetString(1); v.stock_quantity = mySQLReader.GetInt32(2); v.des_box = mySQLReader.GetString(3); v.URL = mySQLReader.GetString(4); v.categories = mySQLReader.GetString(5); return(v); } else { return(null); } }
//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 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); }
public override void FillFields(MySqlDataReader reader) { EventId = (long)reader["EventId"]; EventTime = (long)reader["EventTime"]; EventName = (Logger.EventLogNames)Enum.Parse(typeof(Logger.EventLogNames), reader["EventName"].ToString()); EventData = reader["EventData"].ToString(); }
public static void PopulateListView(ListView lst, String strQuery) { ListViewItem lstItem = null; int x; lst.Items.Clear(); conn.Open(); comm.Connection = conn; comm.CommandText = strQuery; reader = comm.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { lstItem = lst.Items.Add(reader.GetValue(0).ToString()); for (x = 1; x < reader.FieldCount; x++) { lstItem.SubItems.Add(reader.GetValue(x).ToString()); } } } 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(); } }
private static void showColumNames(MySqlDataReader mysqlDataReader) { // SOLUCION YO int columns = mysqlDataReader.FieldCount; //Console.Write (columns); for (int i=0; i < columns; i++) { Console.Write (mysqlDataReader.GetName(i)+" "); } // // OTRA OPCION // int count = mysqlDataReader.FieldCount; //cuenta las columnas // List<string> columnNames = new List<string> (); //crea una lista // for (int i=0; i< count; i++) { //la recorre // columnNames.Add (mysqlDataReader.GetName (i)); return columnNames.ToArray (); // } // /* SOLUCION PROFESOR // int columns = mysqlDataReader.FieldCount; // String [] columnNames = new string[columns]; // for (int i=0; i<columns;i++){ // columnNames [i] = mysqlDataReader.GetName (i); // }*/ }
//funcionando public int BuscarIdPlanoDeMarketing(int IdPlano) { try { string QueryPesquisarIdSumario = "select * from planodemarketing where id_Plano=@IdPlano;"; int idSumario = 0; Dal.ConectarBanco(); ComandoPesquisarIdPlanoDeMarketing = new MySqlCommand(QueryPesquisarIdSumario); ComandoPesquisarIdPlanoDeMarketing.Connection = Dal.Conn; ComandoPesquisarIdPlanoDeMarketing.Parameters.AddWithValue("@IdPlano", IdPlano); ReaderPEsquisarIdPlanoDeMarketing = ComandoPesquisarIdPlanoDeMarketing.ExecuteReader(); while (ReaderPEsquisarIdPlanoDeMarketing.Read()) { idSumario = int.Parse(ReaderPEsquisarIdPlanoDeMarketing["id"].ToString()); } return idSumario; } catch { int idSumario = 0; return idSumario; } finally { ReaderPEsquisarIdPlanoDeMarketing.Close(); Dal.FecharConexao(); } }
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); } }
private static void show(MySqlDataReader mySqlDataReader) { Console.WriteLine ("show"); while (mySqlDataReader.Read()) { showRow (mySqlDataReader); } }
//metodo que devuelve un array con el nombre de las columnas de la tabla que contiene el mySqlDataReader private string[] getColumnNames(MySqlDataReader mySqlDataReader) { List<string> columnNames = new List<string>();//Lista de valores que almacenara el nombre de las columnas de la tabla en la base de datos for (int index = 0; index < mySqlDataReader.FieldCount; index++)//se obtienen del mySqlDataReader el nombre de las columnas columnNames.Add (mySqlDataReader.GetName (index));//se añade el nombre a la lista return columnNames.ToArray (); }
protected void Page_Load(object sender, EventArgs e) { topics_ids = new ArrayList(); dbConnection = new MySqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()); dbConnection.Open(); slctTopics = new MySqlCommand("SELECT t_id FROM topics", dbConnection); dReaderTopics = slctTopics.ExecuteReader(); while (dReaderTopics.Read()) { topics_ids.Add(dReaderTopics[0].ToString()); counter++; } dReaderTopics.Close(); slctTopics.Dispose(); while (i < counter) { updtTopicsNumberOfVideos = new MySqlCommand("UPDATE topics SET t_nb_videos=(SELECT count(*) FROM videos WHERE t_id=" + topics_ids[i].ToString() + ") WHERE t_id=" + topics_ids[i].ToString(), dbConnection); updtTopicsNumberOfVideos.ExecuteNonQuery(); updtTopicsNumberOfVideos.Dispose(); i++; } }
// TODO: Klassen som kaller på CreateNewUser må sjekke om epost og passord er VARCHAR(50) public bool CreateNewUser(string epost, string password) { command = connection.CreateCommand(); command.CommandText = "INSERT INTO login (epost, passord) VALUES ('" + epost + "','" + password + "');"; reader = command.ExecuteReader(); return true; }
/// <summary> /// Gets schema from reader taking Query.ResultRowType in consideration /// </summary> public static Schema GetSchemaForQuery(string target, Query query, MySqlDataReader reader, QuerySource qSource, out Schema.FieldDef[] toLoad) { Schema schema; var rtp = query.ResultRowType; if (rtp != null && typeof(TypedRow).IsAssignableFrom(rtp)) schema = Schema.GetForTypedRow(query.ResultRowType); else schema = GetSchemaFromReader(query.Name, qSource, reader); //determine what fields to load toLoad = new Schema.FieldDef[reader.FieldCount]; for (int i = 0; i < reader.FieldCount; i++) { var name = reader.GetName(i); var fdef = schema[name]; //todo A gde GetBackendNameFor target? if (fdef==null) continue; var attr = fdef[target]; if (attr!=null) { if (attr.StoreFlag!=StoreFlag.LoadAndStore && attr.StoreFlag!=StoreFlag.OnlyLoad) continue; } toLoad[i] = fdef; } return schema; }
public int Login(TextBox utilizador, TextBox password) { Conetar(); int valor = 0; string query = "SELECT * FROM conta WHERE utilizador='" + utilizador.Text + "' AND password='******';"; _cmdDataBase = new MySqlCommand(query, _conDataBase); try { _conDataBase.Open(); _myReader = _cmdDataBase.ExecuteReader(); while (_myReader.Read()) { } if (_myReader.HasRows) { MessageBox.Show("Login Correto"); valor = 1; } else { MessageBox.Show("Login Incorreto! Volte a Introduzir as suas Credenciais"); valor = 0; } _myReader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return valor; }
//when check name and password, get the user's information public PropertyClass CheckNameAndPasswd(string name,string password) { PropertyClass accountClass=null; string strSql="select * from account where accountName='"+name.Trim()+"' and accountPassword='******'"; try{ sdr=db.GetDataReader(strSql); sdr.Read(); if(sdr.HasRows) { accountClass=new PropertyClass(); accountClass.UserId=sdr.GetInt32("id"); accountClass.AccountName=name.Trim(); accountClass.AccountPassword=password.Trim(); accountClass.Email=sdr["email"].ToString(); accountClass.Job=sdr.GetInt32("job");; accountClass.Superviser=sdr.GetInt32("superviser"); } } catch(Exception ex) { } finally { sdr.Close(); } return accountClass; }
private void RetreiveProduct() { ///Get product list from database try { CheckStateDB(); String sqlGet = "SELECT product_id FROM product"; cmd = new MySqlCommand(sqlGet, conn); reader = cmd.ExecuteReader(); if (reader.HasRows == false) { throw new Exception("No row were found!"); } else { while (reader.Read()) { this.prodList.Items.Add(reader.GetString("product_id")); } } reader.Close(); } catch (Exception ex) { ErrorLogCreate(ex); LockWindow(true); } }
protected override DBEntity getDBEntity(MySql.Data.MySqlClient.MySqlDataReader reader) { Efficiency eff = new Efficiency(this.filter); eff.date = (DateTime)reader[TimeEvent.ST.ST_DATE];//.TODO: we must review this line when reading from the DB. Visto por Ademir eff.mileseconds = (int)reader[TimeEvent.ST.ST_MILESECONDS]; eff.id_pergunta = (int)reader[TimeEvent.ST.ST_ID_PERGUNTA]; eff.event_type = (string)reader[TimeEvent.ST.ST_EVENT_TIPE]; eff.id_processos = (int)reader[TimeEvent.ST.ST_ID_PROCESS]; eff.id_especialista = (int)reader[Process.ST.ID_EXPERT]; eff.id_projeto = (int)reader[Process.ST.ID_PROJECT]; eff.idElicitationMethod = (int)reader[Process.ST.ID_ELICITATION_METHOD]; eff.idTrainingMethod = (int)reader[Process.ST.ID_TRAINING_METHOD]; eff.idAnalyst = (int)reader[Process.ST.ID_ANALYST]; eff.index_lastTrainingQuestion = (int)reader[Process.ST.INDEX_LAST_TRAINING_QUESTION]; eff.index_lastElicitationQuestion = (int)reader[Process.ST.INDEX_LAST_ELICITATION_QUESTION]; eff.name_project = (string)reader[Project.ST.ST_NAME]; eff.name_analyst = (string)reader[Analyst.ST.ST_NAME];//retornaListaEstatisticaString("nome"); eff.intimityMath = (int)reader[Expert.ST.ST_INTIMITY_MATH]; eff.intimityUncertainty = (int)reader[Expert.ST.ST_INTIMITY_UNC]; eff.expertiseField = (string)reader[Expert.ST.ST_EXPERTISE_FIELD]; eff.email = (string)reader[Expert.ST.ST_EMAIL]; eff.id_titulacao = (int)reader["idTitulacao"];//o id da titulação está no construtor de titration então teria que se insanciar um objeto para se pegar essa string eff.titulacao = (string)reader[Titration.ST.ST_TITULACAO]; eff.especialidade = (string)reader[Titration.ST.ST_ESPECIALIDADE]; return(eff); }
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 static RobaDTO readerToRobaDTO(MySqlDataReader reader) { RobaDTO roba = new RobaDTO(); roba.SifraRoba = reader.GetInt32("SifraRoba"); roba.Naziv = reader.GetString("Naziv"); return roba; }
//When Login has been Pressed protected void SubmitEventMethod(object sender, EventArgs e) { string username = Username.Text; string pass = Password.Text; query = "SELECT * FROM 17agileteam6db.users WHERE staff_no ='" + username + "' AND pass = '******';"; //checks user name and password DB db = new DB(); reader = db.Select(query); while (reader.HasRows && reader.Read()) { Session["role"] = reader.GetString(reader.GetOrdinal("role")); Session["firstName"] = reader.GetString(reader.GetOrdinal("first_name")); Session["lastName"] = reader.GetString(reader.GetOrdinal("last_name")); } if (reader.HasRows) { Session["loggedin"] = "Loggedin"; Session["StaffNo"] = Username.Text; Response.BufferOutput = true; Response.Redirect("Index.aspx", false); } else { //If username and password not found return false Session["failed"] = "failed"; Response.Redirect("Login.aspx", false); } reader.Close(); }
public List<Sector> LoadSector() { try { using (MySqlConnection cn = new MySqlConnection((clsCon=new Connection(this.user)).Parameters())) { listSec = new List<Sector>(); cn.Open(); sql = "select * from asada.view_sectores"; cmd = new MySqlCommand(sql, cn); reader = cmd.ExecuteReader(); while (reader.Read()) { sec = new Sector(); sec.Code = reader.GetString(0); sec.Consecutive = reader.GetInt32(1); sec.Description = reader.GetString(2); listSec.Add(sec); } reader.Close(); return listSec; } } catch (Exception) { throw; } }
public override void SetUp(MySqlDataReader reader) { this.ProductTypeName = reader["UsingProductType"].ToString(); this.RollingStockType = reader["OnRollingStockType"].ToString(); this.IndustryName = reader["ForIndustry"].ToString(); this.isProducer = (bool)reader["IsProducer"]; }
public Person(MySql.Data.MySqlClient.MySqlDataReader reader) { navyid = Convert.ToString(reader["navyid"]); statuscode = Convert.ToString(reader["statuscode"]); yearin = Convert.ToString(reader["yearin"]); batt = Convert.ToString(reader["batt"]); company = Convert.ToString(reader["company"]); name = Convert.ToString(reader["name"]); sname = Convert.ToString(reader["sname"]); id8 = Convert.ToString(reader["id8"]); unit3 = Convert.ToString(reader["unit3"]); unitname = Convert.ToString(reader["unitname"]); ask = Convert.ToString(reader["ask"]); oldyearin = Convert.ToString(reader["oldyearin"]); regdate = reader.GetDateTime("regdate"); movedate = reader.GetDateTime("movedate"); //stitle = Core.DataDefinition.GetStatusSTitle(statuscode); stitle = Convert.ToString(reader["stitle"]); postname = Convert.ToString(reader["postname"]); unit4 = Convert.ToString(reader["unit4name"]); item = Convert.ToString(reader["sxitem"]); percent = Convert.ToString(reader["percent"]); educname = Convert.ToString(reader["educname"]); skill = Convert.ToString(reader["skill"]); platoon = Convert.ToString(reader["platoon"]); pseq = Convert.ToString(reader["pseq"]); unit1 = Convert.ToString(reader["unit1name"]); unit2 = Convert.ToString(reader["unit2name"]); }
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(); }
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); } }
public TableInformations(MySqlDataReader reader) { _primaryKey = new List<string>(); _uniqueConstraints = new List<string>(); _foreignConstraints = new List<string>(); this.setProperty(reader); }
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 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); } }
public bool IsNameExist(string name) { string strSql="select * from account where accountName='"+name.Trim()+"'"; try{ sdr=db.GetDataReader(strSql); sdr.Read(); if(sdr.HasRows) { sdr.Close(); return true; } else { sdr.Close(); return false; } } catch(Exception e) { } finally { sdr.Close(); } return true; }
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(); } } }