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