private void loadClubData()
{
President p = new President();
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select * from dbo.Club where president_id = " + p.getPresidentID(session);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Club club = new Club();
club.setClubName(reader.GetString(2));
club.setClubFees(reader.GetDecimal(3));
club.setClubDescription(reader.GetString(4));
// show value for edit
societyName.Text = club.getClubName();
societyFees.Text = club.getClubFees();
beautifyDescription();
societyDescription.Text = club.getClubDescription();
// automate value on textfield
societyNameTextbox.Text = club.getClubName();
feesLabel.Text = club.getClubFees();
societyDescriptionTextbox.Text = club.getClubDescription();
// close connection
connect.close();
reader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("error " + ex);
}
}
