Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Data.SqlClient;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- namespace WindowsFormsApplication1
- {
- public partial class form2 : Form
- {
- int m_selectedIndex;
- //string[] queries = { "NumeReclama", "CategReclama" };
- //Implementarea Queriurilor se face aici!
- string[][] m_tables = {
- new string[]{"NumeReclama"},
- new
- private int p1;
- private int p2;
- public form2(int p1,int p2)
- {
- // TODO: Complete member initialization
- this.p1 = p1;
- this.p2 = p2;
- } new string[]{"CategReclama"}
- new string[]{"NumeReclama", "NrPagina" }
- new string[]{"NumeRevista","CategRevista","Editie"}
- new string[]{"NumeReclama","VarstaAudienta"}
- new string[]{"NumeReclama","MarimeReclama"}
- new string[]{"NumeRevista", "NrReviste"},
- new string[]{"NumeReclama","IDPagina"},
- new string[]{"NumeRevista"},
- new string[]{"VarstaAudienta","SexAudienta"}
- };
- string[] m_queries = {
- "SELECT NumeReclama FROM Reclama",
- "SELECT CategReclama FROM Reclama",
- "SELECT r.NumeReclama,p.NrPagina FROM Pagina p JOIN PaginaReclama rp ON p.IDPagina=rp.IDPagina JOIN Reclama r ON r.IDReclama=rp.IDReclama",
- "SELECT NumeRevista,CategRevista,Editie FROM Revista ORDER BY Editie",
- "SELECT NumeReclama,VarstaAudienta FROM Reclama r JOIN Audienta a ON r.IDReclama=a.IDReclama",
- "SELECT NumeReclama,MarimeReclama FROM Reclama ORDER BY MarimeReclama",
- //Interogari simple
- "SELECT r.NumeRevista,(SELECT COUNT (*) FROM PaginaReclama pr ,Reclama r,Pagina p,Revista re WHERE r.IDReclama=pr.IDReclama AND p.IDPagina=pr.IDPagina AND re.IDRevista=p.IDRevista)AS NrReviste FROM Revista r WHERE r.NumeRevista='Forbes'",
- "SELECT r.NumeReclama,p.IDPagina FROM Pagina p,Reclama r,PaginaReclama rp WHERE p.IDPagina=rp.IDPagina AND r.IDReclama=rp.IDReclama AND p.IDPagina='4'",
- "SELECT NumeRevista FROM Revista WHERE IDRedactie=(SELECT IDRedactie FROM Redactie WHERE NumeRedactie='Antena')",
- "SELECT VarstaAudienta,SexAudienta FROM Audienta WHERE IDAudienta=(SELECT IDAudienta FROM Reclama WHERE CategReclama='IT' GROUP BY CategReclama ) "
- //Interogari complexe
- };
- public form2(int i_comboNumber, int i_selectedIndex)
- {
- InitializeComponent();
- m_selectedIndex = i_selectedIndex + (i_comboNumber - 1) * 6;
- //Conexiunea cu baza de date
- string connString = "Data Source=.;Initial Catalog=Gestionare;Integrated Security=True";
- using (SqlConnection con = new SqlConnection(connString))
- {
- con.Open();
- string query = m_queries[m_selectedIndex];
- using(SqlCommand cmd= new SqlCommand(query, con)){
- using (SqlDataReader reader = cmd.ExecuteReader())
- {
- while (reader.Read())
- {
- string result = String.Empty;
- for (int i = 0; i < m_tables[m_selectedIndex].Length; i++)
- {
- result += reader[m_tables[m_selectedIndex][i]];
- result += " ";
- }
- listBoxData.Items.Add(result);
- }
- }
- }
- }
- }
- private void label1_Click(object sender, EventArgs e)
- {
- }
- private void button1_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement