private void DbInit() { //if (SearchTB.Text.Trim().Length>0 && DateDDL.SelectedIndex>0) //{ using (SqlConnection Conn = new SqlConnection(strConnectString)) { string strSearch; strSearch = (SearchTB.Text.Trim().Length > 0) ? "%" + SearchTB.Text.Trim().ToUpper() + "%" : "%"; DataTable dt = new DataTable(); string sqlstr = selectsql(); SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, Conn); myAdapter.SelectCommand.Parameters.AddWithValue("Search", strSearch); myAdapter.SelectCommand.Parameters.AddWithValue("Search1", strSearch); myAdapter.Fill(dt); if (dt.Rows.Count > 0) { PhoneGV.DataSource = dt; PhoneGV.DataBind(); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('搜尋不到資料');</script>"); } } //} //else //{ // Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('請輸入搜尋資料與月份');</script>"); //} }
private void DbInit() { using (SqlConnection Conn = new SqlConnection(strConnectString)) { DataTable dt = new DataTable(); string sqlstr = selectsql(); SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, Conn); myAdapter.Fill(dt); PhoneGV.DataSource = dt; PhoneGV.DataBind(); } }