簡單的搜尋引擎 + CheckBoxList (實用)

http://blog.sina.com.tw/myvufzbi/article.php?pbgid=91238&entryid=595441


把資料展現到畫面上
ExecuteReader

• ADO 連線、下命令、讀取

http://javapig.pixnet.net/blog/post/48216334-ado-%E9%80%A3%E7%B7%9A%E3%80%81%E4%B8%8B%E5%91%BD%E4%BB%A4%E3%80%81%E8%AE%80%E5%8F%96

//建立連線
SqlConnection conn;
conn = new SqlConnection("data source = EasyFlow;initial catalog = EFNET;user id =sa;password = XXX");
conn.Open();

//下指令
SqlCommand cmd;
cmd = new SqlCommand("select dept as 部門,empname as 員工名稱,empno as 員工代號,extension as 分機,phs as PHS from extension where deptno like @empno", conn);
cmd.Parameters.Add("@empno", SqlDbType.NVarChar).Value = txt_what.Text.Trim() + "%";

//讀取到中介
SqlDataReader dr;
dr = cmd.ExecuteReader();

//仲介資料給GridView去顯示
GridView.DataSource = dr;
GridView.DataBind();

//若要讀取仲介的每一筆資料並丟給DropDownList
while (dr.Read())
{
    DropDownList.Items.Add(dr["dept"].ToString()); //dr["dept"].ToString() 是dr的dept欄位資料
}