private void UzButton_Click(object sender, EventArgs e)
{
Button b = (Button)sender;
Uzrasai u = (Uzrasai)b.Tag;
uzrasaiRichTextBox.Text = u.GetUzrasai();
ID = u.GetID().ToString();
Button saveButton = new Button();
Button deleteButton = new Button();
saveButton.Text = "Išsaugoti";
saveButton.Width = 63;
saveButton.Height = 23;
saveButton.Tag = (Button)sender;
saveButton.Click += SaveButton_Click;
saveButton.Location = new Point(0, 0);
deleteButton.Click += DeleteButton_Click;
deleteButton.Text = "Šalinti";
deleteButton.Width = 63;
deleteButton.Height = 23;
deleteButton.Tag = (Button)sender;
deleteButton.Location = new Point(63, 0);
toolPanel.Controls.Add(saveButton);
toolPanel.Controls.Add(deleteButton);
}
public void ReadUzrasai()
{
try
{
string connString = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = controller.Read();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Uzrasai u = new Uzrasai(Convert.ToInt32(reader[0]), reader[1].ToString(), reader[2].ToString(), reader[3].ToString());
uzr.Add(u);
}
conn.Close();
}
catch (System.Data.SqlClient.SqlException)
{
System.Windows.Forms.MessageBox.Show("Patikrinkite ar duomenų bazė yra pasiekiama!");
System.Windows.Forms.Application.Exit();
}
}
