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();
}
}
