Beispiel #1
0
        private void textBox2_KeyUp(object sender, KeyEventArgs e)
        {
            string     q  = "select s.std_id as 'ID', s.std_name as 'Name',s.std_fname as 'Father Name',s.std_gender as 'Gender',s.std_address as 'Address',s.std_age as 'Age', s.std_phone as 'Phone NO',s.std_admissiondate as 'Admission Date',a.ad_name as 'Admin ID' from student s inner join administrator a on a.ad_id=s.std_ad_fk_id where s.std_id like '" + textBox2.Text + "%'";
            view_class vc = new view_class(q);

            dataGridView1.DataSource = vc.showrecord();
        }
Beispiel #2
0
        private void view_form_Load(object sender, EventArgs e)
        {
            string     q = "select * from student_record";
            view_class v = new view_class(q);

            dataGridView1.DataSource = v.showrecord();
        }
Beispiel #3
0
        private void viewform_Load(object sender, EventArgs e)
        {
            string     q  = "select s.std_id as 'ID', s.std_name as 'Name',s.std_fname as 'Father Name',s.std_gender as 'Gender',s.std_address as 'Address',s.std_age as'Age',s.std_phone as'Phone NO',s.std_admissiondate as 'Admission Date',a.ad_name as 'Admin Name' from student s inner join administrator a on a.ad_id=s.std_ad_fk_id";
            view_class vc = new view_class(q);

            dataGridView1.DataSource = vc.showrecord();
        }