private void FormShowData_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'studentManageDataSet1.student' table. You can move, or remove it, as needed.
this.studentTableAdapter.Fill(this.studentManageDataSet1.student);
this.studentTableAdapter.Fill(this.studentManageDataSet1.student);
SqlCommand command = new SqlCommand("SELECT * FROM student");
dataGridView1.ReadOnly = true;
DataGridViewImageColumn picCol = new DataGridViewImageColumn();
dataGridView1.RowTemplate.Height = 80;
dataGridView1.DataSource = stuf.getStudents(command);
picCol = (DataGridViewImageColumn)dataGridView1.Columns[7];
picCol.ImageLayout = DataGridViewImageCellLayout.Stretch;
dataGridView1.AllowUserToAddRows = false;
}
public void LoadGridByKey()
{
if (id_rabtn.Checked == true)
{
SqlCommand sqlcommand = new SqlCommand("Select * from student where StudentID LIKE '%" + SearchBar_txt.Text + "%'");
show_datagv.DataSource = stuf.getStudents(sqlcommand);
}
else if (fName_rabtn.Checked == true)
{
SqlCommand sqlcommand = new SqlCommand("Select * from student where FirstName LIKE '%" + SearchBar_txt.Text + "%'");
show_datagv.DataSource = stuf.getStudents(sqlcommand);
}
else
{
SqlCommand sqlcommand = new SqlCommand("Select * from student where LastName LIKE '%" + SearchBar_txt.Text + "%'");
show_datagv.DataSource = stuf.getStudents(sqlcommand);
}
}
// check điều kiện của radio button để load dữ liệu lên data grid view
public void LoadByGender()
{
if (yes_rbtn.Checked)
{
DateTime start = time1_tp.Value;
DateTime end = time2_tp.Value;
if (start > end)
{
DateTime temp = start;
start = end;
end = temp;
}
if (male_rbtn.Checked)
{
SqlCommand command = new SqlCommand("SELECT * from student where DateOfBirth between @start and @end and gender = 'Male'");
command.Parameters.Add("@start", SqlDbType.DateTime).Value = start;
command.Parameters.Add("@end", SqlDbType.DateTime).Value = end;
info_dgv.DataSource = stuf.getStudents(command);
}
else if (fMale_rbtn.Checked)
{
SqlCommand command = new SqlCommand("SELECT * from student where DateOfBirth between @start and @end and gender = 'Female'");
command.Parameters.Add("@start", SqlDbType.DateTime).Value = start;
command.Parameters.Add("@end", SqlDbType.DateTime).Value = end;
info_dgv.DataSource = stuf.getStudents(command);
}
else
{
SqlCommand command = new SqlCommand("SELECT * from student where DateOfBirth between @start and @end");
command.Parameters.Add("@start", SqlDbType.DateTime).Value = start;
command.Parameters.Add("@end", SqlDbType.DateTime).Value = end;
info_dgv.DataSource = stuf.getStudents(command);
}
}
else
{
if (allGender_rbtn.Checked)
{
SqlCommand command = new SqlCommand("SELECT * from student");
info_dgv.DataSource = stuf.getStudents(command);
}
else if (fMale_rbtn.Checked)
{
SqlCommand command = new SqlCommand("SELECT * from student where gender = 'female'");
info_dgv.DataSource = stuf.getStudents(command);
}
else
{
SqlCommand command = new SqlCommand("SELECT * from student where gender = 'male'");
info_dgv.DataSource = stuf.getStudents(command);
}
}
}
