tutaj cały kod:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using SqlDataAdapterProject.Models;
namespace SqlDataAdapterProject
{
public partial class Default : System.Web.UI.Page
{
public string ConnectionString = @"Data Source=localhost\sql14;
Initial Catalog=Pracownik; User ID=sa;Password=sasa";
public SqlCommand kwerenda = new SqlCommand();
public List<pracownik> pracownicy = new List<pracownik>();
protected void Page_Load(object sender, EventArgs e)
{
pobierz_wydzialy();
pobierz_pracownikow();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection sc = new SqlConnection();
sc.ConnectionString = ConnectionString;
kwerenda.Connection = sc;
kwerenda.CommandText = "Insert into pracownicy VALUES (@Imie,@Wiek,@DataZatr,@Wydzial)";
kwerenda.Parameters.AddWithValue("Imie", TextBox1.Text);
kwerenda.Parameters.AddWithValue("Wiek", int.Parse(TextBox2.Text));
kwerenda.Parameters.AddWithValue("DataZatr", TextBox5.Text);
kwerenda.Parameters.AddWithValue("Wydzial", TextBox4.Text);
try
{
sc.Open();
kwerenda.ExecuteNonQuery();
sc.Close();
Label1.Text = "Dane zostały dodane do bazy";
}
catch (Exception ex) { Label1.Text = ex.Message; }
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
TextBox5.Text = Calendar1.SelectedDate.ToShortDateString();
}
protected void pobierz_pracownikow()
{
SqlConnection sc = new SqlConnection();
sc.ConnectionString = ConnectionString;
kwerenda.Connection = sc;
kwerenda.CommandText = "Select * from pracownicy";
kwerenda.CommandType = CommandType.Text;
try
{
sc.Open();
//SqlDataAdapter da = new SqlDataAdapter(kwerenda);
//DataSet zbior = new DataSet();
//da.Fill(zbior);
using (SqlDataReader reader = kwerenda.ExecuteReader())
{
while(reader.Read())
pracownicy.Add(new pracownik(reader.GetString(1),
reader.GetInt32(2),
"222",
reader.GetInt32(4)));
}
Repeater1.DataSource = pracownicy;
Repeater1.DataBind();
}
catch (Exception ex) { Label1.Text = ex.Message; }
}
protected void pobierz_wydzialy()
{
List<Wydzialy> wydzial=new List<Wydzialy>();
SqlConnection sc = new SqlConnection();
sc.ConnectionString = ConnectionString;
kwerenda.Connection = sc;
kwerenda.CommandText = "Select * from wydzialy";
kwerenda.CommandType = CommandType.Text;
try {
sc.Open();
SqlDataAdapter DA = new SqlDataAdapter(kwerenda);
DataSet zbior = new DataSet();
DA.Fill(zbior);
GridView1.DataSource = zbior;
GridView1.DataBind();
using (SqlDataReader read = kwerenda.ExecuteReader())
{
while(read.Read())
{
wydzial.Add(new Wydzialy(read.GetInt32(0), read.GetString(1)));
}
}
DropDownList1.DataSource = wydzial;
DropDownList1.DataTextField = "nazwa";
DropDownList1.DataValueField = "id";
DropDownList1.DataBind();
//ListBox1.DataSource = wydzial;
//ListBox1.DataTextField = "nazwa";
//ListBox1.DataValueField = "id";
//ListBox1.DataBind();
}
catch(Exception ex) { Label1.Text = ex.Message; }
}
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
TextBox4.Text = ListBox1.SelectedItem.Value.ToString();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
TextBox4.Text = DropDownList1.SelectedItem.Value.ToString();
}
}
}