private void button1_Click(object sender, EventArgs e)
{
using(OdbcConnection oconn=new OdbcConnection(Basic_HTB_Info.Conn_Str)){
oconn.Open();
Form_Search_Res fsr = new Form_Search_Res();
fsr.MdiParent = Basic_HTB_Info.cfg.MDIparent;
if (textBox1.Text.Length > 0)
{
string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where stud_ref like '{0}' ", textBox1.Text);
binding_btn(fsr, sql, oconn);
}
if (textBox2.Text.Length > 0)
{
string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where code like '{0}' ", textBox2.Text);
binding_btn(fsr, sql, oconn);
}
if (textBox3.Text.Length > 0)
{
string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where name_c like '{0}' ", textBox3.Text);
binding_btn(fsr, sql, oconn);
}
if (textBox4.Text.Length > 0)
{
String grade = textBox4.Text.Substring(0, textBox4.Text.Length - 1).ToUpper();
String classno = textBox4.Text[textBox4.Text.Length - 1].ToString().ToUpper();
string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where grade='{0}' and classno='{1}' ", grade,classno);
binding_btn(fsr, sql, oconn);
}
oconn.Close();
oconn.Dispose();
fsr.Show();
}
}
private void binding_btn(Form_Search_Res fsr, String sql, OdbcConnection oconn)
{
OdbcDataReader dr = new OdbcCommand(sql, oconn).ExecuteReader();
while (dr.Read())
{
String btntxt = String.Format("{0}:{1}:{2}:{3}{4}{5}", dr[0], dr[1], dr[2], dr[3], dr[4], dr[5]);
Button btn = new Button();
btn.Text = btntxt;
btn.Size = btnsize;
btn.Font = btnfont;
btn.Click += btn_click;
fsr.flowLayoutPanel1.Controls.Add(btn);
}
}
