protected void button_Click(object sender, EventArgs e) { using (SqlConnection conexion = Conexion.ObtenerConexion()) { conexion.Open(); string query = "select * from helix_usuario where NOMBRE_USUARIO ='" + txt_user.Text + "' and PASSWORD ='******'"; SqlCommand cmd = new SqlCommand(query, conexion); SqlDataReader Reader1; Reader1 = cmd.ExecuteReader(); if (Reader1.Read()) { //ScriptManager.RegisterStartupScript(this, this.GetType(), "alertIns", "alert('Hola desde el grid');", true); //getInt32 para obtener los valores numericos para comparacion y getValue para obtener el valor de la celda y no comparar if (Reader1.GetInt32(1) == 1) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alertIns", "alert('Bienvenido');", true); perfil = Convert.ToString(Reader1.GetValue(1)); Response.Redirect("/View/Tickets.aspx", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alertIns", "alert('Incorrecto');", true); } } }
public int catchDB(DateTime date, string category) { string datedb = date.ToString("yyyy-MM-dd"); int result; MySqlConnection con = null; MySqlCommand command, command2; con = new MySqlConnection(conectabanco); command = new MySqlCommand("SELECT SUM(Tempo) FROM `concurso` WHERE Categoria = '" + category + "' AND DataRevisao = '" + datedb + "'", con); command2 = new MySqlCommand("SELECT count(DataRevisao) FROM concurso WHERE Categoria = '" + category + "' AND DataRevisao = '" + datedb + "'", con); con.Open(); MySqlDataReader Reader1, Reader2; Reader2 = command2.ExecuteReader(); Reader2.Read(); string valid = Reader2.GetString(0); Reader2.Close(); if (Convert.ToInt32(valid) > 0) { Reader1 = command.ExecuteReader(); Reader1.Read(); result = Convert.ToInt32(Reader1.GetString(0)); Reader1.Close(); return(result); } else { return(0); } }
private void Project_Advisor_Load(object sender, EventArgs e) { String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True"; String query = "select Id from Advisor"; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(query, con); SqlDataReader Reader; con.Open(); Reader = cmd.ExecuteReader(); while (Reader.Read()) { comboBox2.Items.Add(Reader.GetInt32(0)); } String query1 = "select Title from Project"; SqlConnection con1 = new SqlConnection(str); SqlCommand cmd1 = new SqlCommand(query1, con1); SqlDataReader Reader1; con1.Open(); Reader1 = cmd1.ExecuteReader(); while (Reader1.Read()) { comboBox1.Items.Add(Reader1.GetString(0)); } }
public (string, string, string, string, string) ConnectDataBase(string Data, int nextresult) { string name, path, cate, time, revision; name = "0"; path = "0"; cate = "0"; time = "0"; try { con = new MySqlConnection(conectabanco); command2 = new MySqlCommand("SELECT count(Data) FROM concurso where DataRevisao='" + Data + "'", con); command = new MySqlCommand("SELECT * FROM concurso where DataRevisao='" + Data + "'", con); con.Open(); MySqlDataReader Reader1, Reader2; Reader2 = command2.ExecuteReader(); Reader2.Read(); string v = Reader2.GetString(0); int tam = Convert.ToInt32(v); string[] namestr, pathstr, catestr, timestr, revistr; namestr = new string[tam]; pathstr = new string[tam]; catestr = new string[tam]; timestr = new string[tam]; revistr = new string[tam]; Reader2.Close(); Reader1 = command.ExecuteReader(); int valid = Convert.ToInt32(v) - nextresult; if (Convert.ToInt32(valid) > 0) { while (Reader1.HasRows) { int aux = 0; while (Reader1.Read()) { namestr[aux] = Reader1.GetString(0); pathstr[aux] = Reader1.GetString(1); catestr[aux] = Reader1.GetString(2); revistr[aux] = Reader1.GetString(5); timestr[aux] = Reader1.GetString(6); aux++; } Reader1.NextResult(); } name = namestr[nextresult]; path = pathstr[nextresult]; cate = catestr[nextresult]; time = timestr[nextresult]; revision = revistr[nextresult]; } else { name = "0"; path = "0"; cate = "0"; time = "0"; revision = "0"; } } catch (Exception erro) { name = "ERRO"; path = "ERRO"; cate = "ERRO"; time = "ERRO"; revision = "ERRO"; MessageBox.Show(Convert.ToString(erro)); } return(name, path, cate, time, revision); }
private void button1_Click(object sender, EventArgs e) { if (Wettbewerb_combobox.Text.Length == 0) { label2.Text = "Wettbewerb auswählen"; return; } //mysql tables string erzeugen string abcd = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` ( `id` int(5) unsigned NOT NULL AUTO_INCREMENT, `Spieler` VARCHAR(50) NOT NULL, `Team` VARCHAR(50) NOT NULL, `Opp` VARCHAR(50) NOT NULL, `Pos` VARCHAR(50) NOT NULL, `Min` VARCHAR(50) NOT NULL, `G` VARCHAR(50) NOT NULL, `A` VARCHAR(50) NOT NULL, `S` VARCHAR(50) NOT NULL, `SOG` VARCHAR(50) NOT NULL, `CC` VARCHAR(50) NOT NULL, `P` VARCHAR(50) NOT NULL, `AP` VARCHAR(50) NOT NULL, `CR` VARCHAR(50) NOT NULL, `ACR` VARCHAR(50) NOT NULL, `AW` VARCHAR(50) NOT NULL, `DR` VARCHAR(50) NOT NULL, `DSP` VARCHAR(50) NOT NULL, `INTT` VARCHAR(50) NOT NULL, `TKL` VARCHAR(50) NOT NULL, `TKLW` VARCHAR(50) NOT NULL, `BLK` VARCHAR(50) NOT NULL, `CL` VARCHAR(50) NOT NULL, `CS` VARCHAR(50) NOT NULL, `GC` VARCHAR(50) NOT NULL, `SV` VARCHAR(50) NOT NULL, `FS` VARCHAR(50) NOT NULL, `FC` VARCHAR(50) NOT NULL, `Y` VARCHAR(50) NOT NULL, `R` VARCHAR(50) NOT NULL, `Wettbewerb` VARCHAR(50) NOT NULL, `Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0', `Datum` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`), KEY `Spielerid` (`Spielerid`)) ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "Rotowire"); //mysql connection erzeugen MySqlConnection con = new MySqlConnection("server=buqhvbltjab1w9h2bks9-mysql.services.clever-cloud.com;port =20444; database=buqhvbltjab1w9h2bks9;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F"); con.Open(); //mysql DB erzeugen var cmda = new MySql.Data.MySqlClient.MySqlCommand(abcd, con); cmda.ExecuteNonQuery(); con.Close(); //db auslesen //liste Datum erzeugen string datum2 = System.DateTime.Now.ToShortDateString(); List <string> dbListe1 = new List <string>(); MySqlCommand command1 = con.CreateCommand(); command1.CommandText = "SELECT Wettbewerb FROM Rotowire WHERE Datum = '" + datum2 + "'"; MySqlDataReader Reader1; con.Open(); Reader1 = command1.ExecuteReader(); while (Reader1.Read()) { string row1 = ""; for (int i = 0; i < Reader1.FieldCount; i++) { row1 += Reader1.GetValue(i).ToString(); dbListe1.Add(row1); } } dbListe1 = dbListe1.Distinct().ToList(); con.Close(); //CSV in Array speichern string whole_file; string link = String.Join(",", listBox1.Items.OfType <Object>().Select(i => i.ToString()).ToArray()); whole_file = System.IO.File.ReadAllText(@link); whole_file = whole_file.Replace('\n', '\r'); string[] lines = whole_file.Split(new char[] { '\r' }, StringSplitOptions.RemoveEmptyEntries); int num_rows = lines.Length; int num_cols = lines[0].Split(',').Length; string[,] Tabelle = new string[num_rows, 10]; string[,] values = new string[num_rows, num_cols]; for (int r = 0; r < num_rows; r++) { string[] line_r = lines[r].Split(','); for (int c = 0; c < num_cols; c++) { values[r, c] = line_r[c]; } } //MYSQL Table erzeugen und Connection erstellen //mysql tables string erzeugen string createTableQuery = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` ( `id` int(5) unsigned NOT NULL AUTO_INCREMENT, `Spieler` VARCHAR(50) NOT NULL, `Team` VARCHAR(50) NOT NULL, `Opp` VARCHAR(50) NOT NULL, `Pos` VARCHAR(50) NOT NULL, `Min` VARCHAR(50) NOT NULL, `G` VARCHAR(50) NOT NULL, `A` VARCHAR(50) NOT NULL, `S` VARCHAR(50) NOT NULL, `SOG` VARCHAR(50) NOT NULL, `CC` VARCHAR(50) NOT NULL, `P` VARCHAR(50) NOT NULL, `AP` VARCHAR(50) NOT NULL, `CR` VARCHAR(50) NOT NULL, `ACR` VARCHAR(50) NOT NULL, `AW` VARCHAR(50) NOT NULL, `DR` VARCHAR(50) NOT NULL, `DSP` VARCHAR(50) NOT NULL, `INTT` VARCHAR(50) NOT NULL, `TKL` VARCHAR(50) NOT NULL, `TKLW` VARCHAR(50) NOT NULL, `BLK` VARCHAR(50) NOT NULL, `CL` VARCHAR(50) NOT NULL, `CS` VARCHAR(50) NOT NULL, `GC` VARCHAR(50) NOT NULL, `SV` VARCHAR(50) NOT NULL, `FS` VARCHAR(50) NOT NULL, `FC` VARCHAR(50) NOT NULL, `Y` VARCHAR(50) NOT NULL, `R` VARCHAR(50) NOT NULL, `Wettbewerb` VARCHAR(50) NOT NULL, `Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0', `Datum` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`), KEY `Spielerid` (`Spielerid`)) ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "Rotowire"); //mysql connection erzeugen MySqlConnection connection = new MySqlConnection("server=buqhvbltjab1w9h2bks9-mysql.services.clever-cloud.com;port =20444; database=buqhvbltjab1w9h2bks9;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F"); connection.Open(); //mysql DB erzeugen var cmd = new MySql.Data.MySqlClient.MySqlCommand(createTableQuery, connection); cmd.ExecuteNonQuery(); connection.Close(); //letzte db id auslesen MySqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT * FROM Rotowire"; MySqlDataReader Reader; connection.Open(); Reader = command.ExecuteReader(); label2.Text = ""; while (Reader.Read()) { string row = ""; //Komplette dB auslesen //for (int i = 0; i < Reader.FieldCount; i++) //letzte id auslesen for (int i = 0; i < 1; i++) { row += Reader.GetValue(i).ToString(); } label2.Text = row; } connection.Close(); //daten in db connection.Open(); int h; if (label2.Text.Length == 0) { h = 1; } else { h = Int32.Parse(label2.Text) + 1; } int k; string st2; string st3; string datum = System.DateTime.Now.ToShortDateString(); for (int i = 2; i < num_rows; i++) { k = 0; cmd.CommandText = "INSERT INTO Rotowire(id, Spieler, Team, Opp, Pos, Min, G, A, S, SOG, CC, P, AP, CR, ACR, AW, DR, DSP, INTT, TKL, TKLW, BLK, CL, CS, GC, SV, FS, FC, Y, R, Wettbewerb, Spielerid, Datum) VALUES(@id, @Spieler, @Team, @Opp, @Pos, @Min, @G, @A, @S, @SOG, @CC, @P, @AP, @CR, @ACR, @AW, @DR, @DSP, @INTT, @TKL, @TKLW, @BLK, @CL, @CS, @GC, @SV, @FS, @FC, @Y, @R, @Wettbewerb, @Spielerid, @Datum)"; cmd.Prepare(); cmd.Parameters.AddWithValue("@id", h + i); st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Spieler", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Team", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Opp", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Pos", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Min", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@G", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@A", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@S", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@SOG", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@CC", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@P", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@AP", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@CR", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@ACR", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@AW", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@DR", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@DSP", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@INTT", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@TKL", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@TKLW", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@BLK", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@CL", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@CS", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@GC", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@SV", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@FS", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@FC", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Y", st3); k = k + 1; st2 = values[i, k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@R", st3); cmd.Parameters.AddWithValue("@Spielerid", k); cmd.Parameters.AddWithValue("@Wettbewerb", Wettbewerb_combobox.Text); cmd.Parameters.AddWithValue("@Datum", datum); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } connection.Close(); label2.Text = "Finish"; }
private void button1_Click(object sender, EventArgs e) { //Prüfen ob alle Einträge gemacht sind!! if (FanteamUrl_input.Text.Length == 0) { status_lbl.Text = "URL eingeben"; return; } if (AnzahlSeiten_input.Text.Length == 0) { status_lbl.Text = "Anzahl Seiten eingeben"; return; } if (TurnierID_eingabe.Text.Length == 0) { status_lbl.Text = "TurnierID eingeben"; return; } if (Wettbewerb_combobox.Text.Length == 0) { status_lbl.Text = "Wettbewerb auswählen"; return; } if (FanteamUrl_input.Text.Length != 0 && AnzahlSeiten_input.Text.Length != 0 && TurnierID_eingabe.Text.Length != 0 && Wettbewerb_combobox.Text.Length != 0) { //mysql tables string erzeugen string abcd = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` ( `id` int(5) unsigned NOT NULL AUTO_INCREMENT, `Wettbewerb` VARCHAR(50) NOT NULL, `Spieler` VARCHAR(50) NOT NULL, `Position` VARCHAR(50) NOT NULL, `home` VARCHAR(50) NOT NULL, `away` VARCHAR(50) NOT NULL, `Form` VARCHAR(50) NOT NULL, `Punkte` VARCHAR(50) NOT NULL, `Preis` VARCHAR(50) NOT NULL, `Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0', `Datum` VARCHAR(50) NOT NULL, `TurnierID` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`), KEY `Spielerid` (`Spielerid`)) ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "FanteamPreise"); //mysql connection erzeugen MySqlConnection con = new MySqlConnection("server=bddiyuk2rbzdbj9pfb9r-mysql.services.clever-cloud.com;database=bddiyuk2rbzdbj9pfb9r;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F"); con.Open(); //mysql DB erzeugen var cmda = new MySql.Data.MySqlClient.MySqlCommand(abcd, con); cmda.ExecuteNonQuery(); con.Close(); //db auslesen //liste Wettbewerb erzeugen List <string> dbListe1 = new List <string>(); MySqlCommand command1 = con.CreateCommand(); command1.CommandText = "SELECT TurnierID FROM FanteamPreise"; MySqlDataReader Reader1; con.Open(); Reader1 = command1.ExecuteReader(); while (Reader1.Read()) { string row1 = ""; for (int i = 0; i < Reader1.FieldCount; i++) { row1 += Reader1.GetValue(i).ToString(); dbListe1.Add(row1); } } con.Close(); dbListe1 = dbListe1.Distinct().ToList(); int abb = 0; for (int i = 0; i < dbListe1.Count(); i++) { if (dbListe1[i] == TurnierID_eingabe.Text) { abb = 1; } } if (abb != 0) { status_lbl.Text = "Turnier bereits in DB geladen."; return; } if (abb == 0) { //Spielerliste erzeugen List <string> Spielerliste = new List <string>(); //Firefox öffnen IWebDriver driver = new FirefoxDriver(); //URL öffnen driver.Url = FanteamUrl_input.Text; //10 sec warten System.Threading.Thread.Sleep(10000); //javaScript einbinden IJavaScriptExecutor js = driver as IJavaScriptExecutor; //Anzahl Seiten auslesen int x = Int32.Parse(AnzahlSeiten_input.Text); //Daten scrappen for (int j = 0; j < x; j++) { //Tabelle in Webelement speichern IWebElement table = (IWebElement)js.ExecuteScript("return document.querySelector('.ft-view-port').shadowRoot.querySelector('.not-safari').shadowRoot.querySelector('.choices')"); //Webelement in String speichern string table_str = table.Text; //String vereinzeln und in array speichern string[] Spieler_ar = table_str.Split(new Char[] { '\n' }); //Spieler in Liste eintragen for (int i = 5; i < Spieler_ar.Length; i++) { Spielerliste.Add(Spieler_ar[i]); } //nächste Seite js.ExecuteScript("return document.querySelector('.ft-view-port').shadowRoot.querySelector('.not-safari').shadowRoot.querySelector('.game > aside:nth-child(1) > ft-loading:nth-child(4) > ft-pagination:nth-child(2)').shadowRoot.querySelector('button.pagination__arrow:nth-child(4)').click()"); } driver.Close(); // Daten in SQL string createTableQuery = string.Format(@"CREATE TABLE IF NOT EXISTS `{0}` ( `id` int(5) unsigned NOT NULL AUTO_INCREMENT, `Wettbewerb` VARCHAR(50) NOT NULL, `Spieler` VARCHAR(50) NOT NULL, `Position` VARCHAR(50) NOT NULL, `home` VARCHAR(50) NOT NULL, `away` VARCHAR(50) NOT NULL, `Form` VARCHAR(50) NOT NULL, `Punkte` VARCHAR(50) NOT NULL, `Preis` VARCHAR(50) NOT NULL, `Spielerid` smallint(5) unsigned NOT NULL DEFAULT '0', `Datum` VARCHAR(50) NOT NULL, `TurnierID` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`), KEY `Spielerid` (`Spielerid`)) ENGINE = MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;", "FanteamPreise"); //mysql connection erzeugen MySqlConnection connection = new MySqlConnection("server=bddiyuk2rbzdbj9pfb9r-mysql.services.clever-cloud.com;database=bddiyuk2rbzdbj9pfb9r;uid=uxayl6sbtpqdhepa;password=QZPnMNX6OIJrkYTkes3F"); connection.Open(); //mysql DB erzeugen var cmd = new MySql.Data.MySqlClient.MySqlCommand(createTableQuery, connection); cmd.ExecuteNonQuery(); connection.Close(); //letzte db id auslesen MySqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT * FROM FanteamPreise"; MySqlDataReader Reader; connection.Open(); Reader = command.ExecuteReader(); while (Reader.Read()) { string row = ""; //Komplette dB auslesen //for (int i = 0; i < Reader.FieldCount; i++) //letzte id auslesen for (int i = 0; i < 1; i++) { row += Reader.GetValue(i).ToString(); } status_lbl.Text = row; } connection.Close(); //daten in db connection.Open(); int h; if (status_lbl.Text.Length == 0) { h = 1; } else { h = Int32.Parse(status_lbl.Text) + 1; } int k = 0; string st2; string st3; string datum = System.DateTime.Now.ToShortDateString(); for (int i = 0; i < Spielerliste.Count / 7; i++) { cmd.CommandText = "INSERT INTO FanteamPreise(id, Spieler, Position, home, away, Form, Punkte, Preis, Spielerid, Wettbewerb, Datum, TurnierID) VALUES(@id, @Spieler, @Position, @home, @away, @Form, @Punkte, @Preis, @Spielerid, @Wettbewerb, @Datum, @TurnierID)"; cmd.Prepare(); cmd.Parameters.AddWithValue("@id", h + i); st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Position", st3); k = k + 1; st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Spieler", st3); k = k + 1; st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@home", st3); k = k + 1; st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@away", st3); k = k + 1; st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Form", st3); k = k + 1; st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Punkte", st3); k = k + 1; st2 = Spielerliste[k]; st3 = st2.Trim(); cmd.Parameters.AddWithValue("@Preis", st3); k = k + 1; cmd.Parameters.AddWithValue("@Spielerid", k); cmd.Parameters.AddWithValue("@Wettbewerb", Wettbewerb_combobox.Text); cmd.Parameters.AddWithValue("@Datum", datum); cmd.Parameters.AddWithValue("@TurnierID", TurnierID_eingabe.Text); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } connection.Close(); status_lbl.Text = "finished!"; } } }
public Form3() { InitializeComponent(); string myConnnection = "datasource=localhost; port=3306;username=root;password=Sercan.123; "; MySqlConnection myConn = new MySqlConnection(myConnnection); myConn.Open(); MySqlCommand command = new MySqlCommand(); command = myConn.CreateCommand(); command.CommandText = "SELECT schema_name FROM information_schema.schemata where schema_name not like '%_schema' and schema_name not like 'mysql';"; MySqlDataReader Reader1; Reader1 = command.ExecuteReader(); while (Reader1.Read()) { string row = ""; for (int i = 0; i < Reader1.FieldCount; i++) { row += Reader1.GetValue(i).ToString(); } trV1.Nodes.Add(row); } for (int i = 0; i < trV1.Nodes.Count; i++) { trV1.Nodes[i].Nodes.Add("Tables"); trV1.Nodes[i].Nodes.Add("Views"); trV1.Nodes[i].Nodes.Add("Stored Procedure"); trV1.Nodes[i].Nodes.Add("Functions "); } Reader1.Close(); Reader1.Dispose(); myConn.Close(); myConn.Open(); MySqlCommand command_table = new MySqlCommand(); command_table = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_table.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_schema ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader2; Reader2 = command_table.ExecuteReader(); while (Reader2.Read()) { string table = ""; for (int j = 0; j < Reader2.FieldCount; j++) { table += Reader2.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[0].Nodes.Add(table); } Reader2.Close(); Reader2.Dispose(); } myConn.Close(); myConn.Open(); MySqlCommand command_view = new MySqlCommand(); command_view = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_view.CommandText = "SELECT table_name FROM information_schema.tables WHERE table_type='VIEW' AND table_schema ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader3; Reader3 = command_view.ExecuteReader(); while (Reader3.Read()) { string view = ""; for (int j = 0; j < Reader3.FieldCount; j++) { view += Reader3.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[1].Nodes.Add(view); } Reader3.Close(); Reader3.Dispose(); } myConn.Close(); myConn.Open(); MySqlCommand command_procedure = new MySqlCommand(); command_procedure = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_procedure.CommandText = "SHOW PROCEDURE STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader4; Reader4 = command_procedure.ExecuteReader(); while (Reader4.Read()) { string procedure = ""; for (int j = 0; j < Reader4.FieldCount; j++) { procedure += Reader4.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[2].Nodes.Add(procedure); } Reader4.Close(); Reader4.Dispose(); } myConn.Close(); myConn.Open(); MySqlCommand command_function = new MySqlCommand(); command_function = myConn.CreateCommand(); for (int i = 0; i < trV1.Nodes.Count; i++) { command_function.CommandText = "SHOW FUNCTION STATUS WHERE Db ='" + trV1.Nodes[i].Text + "' "; MySqlDataReader Reader5; Reader5 = command_function.ExecuteReader(); while (Reader5.Read()) { string function = ""; for (int j = 0; j < Reader5.FieldCount; j++) { function += Reader5.GetValue(j).ToString(); } trV1.Nodes[i].Nodes[3].Nodes.Add(function); } Reader5.Close(); Reader5.Dispose(); } ContextMenuStrip docMenu = new ContextMenuStrip(); ToolStripMenuItem SelectRows = new ToolStripMenuItem(); SelectRows.Text = "Select Rows"; ToolStripMenuItem AlterTable = new ToolStripMenuItem(); AlterTable.Text = "Alter Table"; ToolStripMenuItem DropTable = new ToolStripMenuItem(); DropTable.Text = "Drop Table"; docMenu.Items.AddRange(new ToolStripMenuItem[] { SelectRows, AlterTable, DropTable }); for (int i = 0; i < trV1.Nodes.Count; i++) { for (int j = 0; j < trV1.Nodes[i].Nodes[0].Nodes.Count; j++) { trV1.Nodes[i].Nodes[0].Nodes[j].ContextMenuStrip = docMenu; } } SelectRows.Click += SelectRows_Click; void SelectRows_Click(object sender, System.EventArgs e) { MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=Sercan.123"); connection.Open(); try { MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM " + trV1.SelectedNode.Parent.Parent.Text + "." + trV1.SelectedNode.Text + " ", connection); DataSet ds = new DataSet(); adapter.Fill(ds, trV1.SelectedNode.Text); dataGridView1.DataSource = ds.Tables[trV1.SelectedNode.Text]; string a = ds.Tables[0].Columns.ToString(); //MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM blm437.ogrenci ", connection); //DataSet ds = new DataSet(); //adapter.Fill(ds, "ogrenci"); //dataGridView1.DataSource = ds.Tables["ogrenci"]; } catch (Exception ex) { MessageBox.Show(ex.Message); } } }