public Form1(string username, login parentForm) { InitializeComponent(); connetionString = "Data Source=WHYNOT-KOMPUTER\\SQLEXPRESS;Initial Catalog=PTproject;Integrated Security=True"; sql = "select id, imie, nazwisko, indeks from studenci"; connection = new SqlConnection(connetionString); List <string> nList = new List <string>(); nList.Add("Moje Przedmioty"); nList.Add("Przedmioty"); // nList.Add("Obecnosci"); // nList.Add("Moj Profil"); listBox1.DataSource = nList; //Controls.Add(listBox1); details_btn.Visible = true; check_btn.Enabled = false; save_btn.Enabled = false; back_btn.Enabled = false; dataGridView1.Visible = true; dataGridView2.Visible = true; dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; label1.Text = "Zalogowany: "; label2.Text = "Przemyslaw Walkowiak"; //label3.Text = "Przedmiot"; label4.Text = ""; //label5.Text = "Widoki"; label6.Text = ""; label7.Text = ""; }
public Form3(string username, login parentForm) { InitializeComponent(); _ParentForm = parentForm; // label2.Text = _ParentForm.czytajAtr(); dataGridView1.ReadOnly = true; dataGridView2.ReadOnly = true; dataGridView1.Enabled = true; dataGridView2.Enabled = false; dataGridView1.AllowUserToAddRows = false; dataGridView2.AllowUserToAddRows = false; dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; label1.Text = "SZCEGÓŁY OBECNOŚCI"; label1.Text = _ParentForm.czytajAtr(); String student = null; sconnetionString = "Data Source=WHYNOT-KOMPUTER\\SQLEXPRESS;Initial Catalog=PTproject;Integrated Security=True"; ssql = "select imie, nazwisko, indeks from studenci" + " where indeks=" + username; ssql2 = "select p.id, p.nazwa as Przedmiot, p.typ as Rodzaj, w.nazwa as Wydzial, k.nazwa as Kierunek," + " kadra.imie+\' \'+kadra.nazwisko as Prowadzacy, count(*) as LiczbaZajec, SUM(CASE WHEN ls.obecny=1 THEN 1 ELSE 0 END) as Obecny from przedmioty as p" + " join kierunki as k on k.id = p.kierunek " + " join wydzialy as w on w.id = k.wydzial_id " + " join kadra on kadra.id = p.prowadzacy_id" + " join zapisani_na_przedmiot as zap on p.id = zap.przedmiot_id" + " join studenci as s on s.id=zap.student_id " + " join lista_obecnosci as ls on s.id=ls.student_id " + " where s.indeks =" + username + " group by p.id,p.nazwa, p.typ, w.nazwa, k.nazwa, kadra.imie+\' \'+kadra.nazwisko"; //dodaj frekwencje ssql3 = ""; try { sconnection = new SqlConnection(sconnetionString); sconnection.Open(); scommand = new SqlCommand(ssql, sconnection); sadapter = new SqlDataAdapter(scommand); sbuilder = new SqlCommandBuilder(sadapter); sds = new DataSet(); sadapter.Fill(sds, "student"); stable = sds.Tables["student"]; sconnection.Close(); foreach (DataRow row in stable.Rows) { if (row["indeks"].ToString() == username) { student = row["imie"].ToString() + " " + row["nazwisko"].ToString(); } } nazwa_studenta.Text = student; } catch { } try { // sconnection = new SqlConnection(sconnetionString); sconnection.Open(); scommand = new SqlCommand(ssql2, sconnection); sadapter = new SqlDataAdapter(scommand); sbuilder = new SqlCommandBuilder(sadapter); sds2 = new DataSet(); sadapter.Fill(sds2, "student przedmioty"); stable = sds2.Tables["student przedmioty"]; sconnection.Close(); //dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; //dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.DataSource = sds2.Tables["student przedmioty"]; dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }