public adminTrainee()
{
InitializeComponent();
SqlCommand Courses = new SqlCommand("select * from Trainee", Program.dbconnection);
SqlDataReader data = Courses.ExecuteReader();
while (data.Read())
{
TraineePanel pnl = new TraineePanel(data.GetString(data.GetOrdinal("UserName")), data.GetString(data.GetOrdinal("FirstName")),
data.GetString(data.GetOrdinal("LastName")), data.GetInt32(data.GetOrdinal("iD")), data.GetString(data.GetOrdinal("Email")),
data.GetString(data.GetOrdinal("Gender")), data.GetString(data.GetOrdinal("Pass")), data.GetString(data.GetOrdinal("Qualification")), data.GetString(data.GetOrdinal("Phone")));
FlowLayoutPanel.Controls.Add(pnl);
}
data.Close();
}
private void SearchButton_Click(object sender, EventArgs e)
{
SearchPanel.Controls.Clear();
SqlCommand Search = new SqlCommand("GetTraineeByname", Program.dbconnection);
Search.CommandType = CommandType.StoredProcedure;
Search.Parameters.AddWithValue("@firstName", SearchBox.Text.Substring(0, SearchBox.Text.IndexOf(' ')));
Search.Parameters.AddWithValue("@lastName", SearchBox.Text.Substring(SearchBox.Text.IndexOf(' ') + 1));
SqlDataReader data = Search.ExecuteReader();
while (data.Read())
{
TraineePanel pnl = new TraineePanel(data.GetString(data.GetOrdinal("UserName")), data.GetString(data.GetOrdinal("FirstName")),
data.GetString(data.GetOrdinal("LastName")), data.GetInt32(data.GetOrdinal("iD")), data.GetString(data.GetOrdinal("Email")),
data.GetString(data.GetOrdinal("Gender")), data.GetString(data.GetOrdinal("Pass")), data.GetString(data.GetOrdinal("Qualification")), data.GetString(data.GetOrdinal("Phone")));
SearchPanel.Controls.Add(pnl);
}
data.Close();
}
