void BindData1() { Seminar S = new Seminar(); DataTable dt = S.GetSEMINAR(txtSearchSeminarCitizen.Text, "", "", "", ""); GridView1.DataSource = dt; GridView1.DataBind(); SetViewState(dt); }
protected void lbuSearch_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtSearchSeminarCitizen.Text)) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - กรุณากรอกรหัสบัตรประชาชนในช่องคำค้นหา</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (txtSearchSeminarCitizen.Text.Length < 13) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - กรุณากรอกรหัสบัตรประชาชนในช่องค้นหาให้ครบ 13 หลัก</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); string result = ""; using (OracleCommand com = new OracleCommand("SELECT CITIZEN_ID FROM TB_SEMINAR WHERE CITIZEN_ID = '" + txtSearchSeminarCitizen.Text + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { result = reader.GetString(0); } } } if (result == txtSearchSeminarCitizen.Text) { Seminar s = new Seminar(); DataTable dt = s.GetSEMINAR(txtSearchSeminarCitizen.Text, "", "", "", ""); GridView1.DataSource = dt; GridView1.DataBind(); SetViewState(dt); notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } else { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - ไม่พบข้อมูลของรหัสบัตรประชาชนดังกล่าว</div>"; return; } } }