日期:2014-05-18  浏览次数:20559 次

gridview 按下一頁後,整個消失了
gridview 按下一頁後,整個消失了,以下是我的代碼.

  protected void btnQuery_Click(object sender, EventArgs e)
  {
  Search();
  }

  //search data
  protected void Search()
  {
  sqldsDiverLicense.ConnectionString = ConfigurationManager.ConnectionStrings["MovinavConnectionString"].ConnectionString;
  gviewDiverLicense.DataSourceID = sqldsDiverLicense.ID;
  string strSQL = "SELECT D.License_no, Right(D.License_no,4)+'/'+Left(D.License_no,4) as PLicense_no ,";
  strSQL = strSQL + " dbo.b5_to_uc(P.cname) as cname,";
  strSQL = strSQL + " POwner = dbo.b5_to_uc(CASE WHEN NOT D.Owner IS NULL THEN D.Owner ELSE A.Agency_cname END),";
  strSQL = strSQL + " dbo.b5_to_uc(D.Subject) as Subject, dbo.b5_to_uc(D.Active_place) as Active_place,";
  strSQL = strSQL + " D.Valid_date1, D.Valid_date2, D.Issue_date, D.Status,";
  strSQL = strSQL + " dbo.b5_to_uc(S.Ship_cname) as ship_cname, S.Ship_pname";
  strSQL = strSQL + " FROM DivrLicense D LEFT OUTER JOIN";
  strSQL = strSQL + " Project P ON D.Project_no = P.Project_no LEFT OUTER JOIN";
  strSQL = strSQL + " Agency A ON D.Agency_no = A.Agency_no LEFT OUTER JOIN";
  strSQL = strSQL + " Ship S ON D.Ship_no = S.Ship_no";
  strSQL = strSQL + " WHERE ((D.Status = 1) OR (D.Status = 2)) AND (D.Cancel = 0)";
  if (txtValidDate.Text != "")
  {
  strSQL = strSQL + " AND (D.Valid_date2 >= '" + txtValidDate.Text + "')";
  }
  else
  {
  strSQL = strSQL + " AND (D.Valid_date2 < '1900/1/1')";
  }

  switch (cbQueryType.SelectedIndex) {
  case 0 :
  //...
  break;
  case 1 :
strSQL = strSQL + " AND (dbo.b5_to_uc(D.Owner) like N'%" + txtContent.Text + "%'";
  strSQL = strSQL + " or dbo.b5_to_uc(A.Agency_cname) like N'%" + txtContent.Text + "%')"; 
  break;
  case 2 :
  strSQL = strSQL + " AND (dbo.b5_to_uc(D.Subject) like N'%" + txtContent.Text + "%')";
  break;
  case 3:
  strSQL = strSQL + " AND (dbo.b5_to_uc(S.Ship_cname) like N'%" + txtContent.Text + "%')";
  break;
  case 4:
  strSQL = strSQL + " AND (S.Ship_pname like '%" + txtContent.Text + "%')";
  break;
  case 5:
  strSQL = strSQL + " AND (D.Full_code like '%" + txtContent.Text + "%')";
  break;
  case 6:
  strSQL = strSQL + " AND (dbo.b5_to_uc(P.Cname) like N'%" + txtContent.Text + "%')";
  break;
  case 7:
  strSQL = strSQL + " AND (dbo.b5_to_uc(D.Active_place) like N'%" + txtContent.Text + "%')"; 
  break;
  case 8:
  strSQL = strSQL + " AND (dbo.b5_to_uc(D.Description) like N'%" + txtContent.Text + "%')";
  break;
  default:
  //...
  break;
  }
  strSQL = strSQL + " ORDER BY D.License_no";
  //Re