ASP.NET

reminston wrote:

chris r u asking me

reminston wrote:

i'm vb.net developer but don't have any idea about asp.net

<br />
<br />
  <footertemplate><br />
	   <br />
   </footertemplate><br />
    <br />
    <br />
 <br />
  <tr><br />
    <td><br />
     <input type="hidden" id="PageSize" value="5" runat="server" /><br />
    </td><br />
     <td>  <br />
    <input type="hidden" id="CurrentPage" value="1" runat="server" /><br />
   </td><br />
     <td><br />
    <input type="hidden" id="TotalSize" runat="server" /><br />
    </td> <br />
 </tr><br />
  <tr><br />
     <td align="center" style="font-weight: bold; border-top-width: thick; border-left-width: thick; border-bottom-width: thick; border-right-width: thick;" colspan="3"><br />
      <asp:linkbutton id="Prev" text="<< Previous" visible="false" forecolor="blue" onclick="Page_Repeater" runat="server" xmlns:asp="#unknown" /> <br />
      <asp:linkbutton id="Next" text="Next >>" visible="false" forecolor="blue" onclick="Page_Repeater" runat="server" xmlns:asp="#unknown" /><br />
    </td><br />
  </tr><br />
<br />

public void Repeaterfill()
  {
       SqlDataAdapter da = new SqlDataAdapter("select a.Complaint_id,a.Emp_id,a.Decription,"
          + " substring(Convert(varchar,a.Problem_date),0,12) as Problem_date,substring(Convert(varchar,b.Resolved_Date),0,12) as Resolved_Date"
          + " from Hr_complaint_detail a,hr_complaint_status b where a.sys_complaint_id=b.Complaint_id and b.Resolved_or_not=1 and a.Emp_id="+empid, con);
      DataSet ds = new DataSet();



      //Get the start Record Count
      //Remember database count is zero based so first decrease the value of
      //the current page
      int startRecord = (int.Parse(CurrentPage.Value) - 1) *
         int.Parse(PageSize.Value);
      //Fetch only the necessary records.
      da.Fill(ds, startRecord, int.Parse(PageSize.Value), "hr_complaint_status");

      //DataBind the Repeater
      Rep_comp_solved.DataSource = ds.Tables["hr_complaint_status"].DefaultView;
      Rep_comp_solved.DataBind();

      if (ds.Tables["hr_complaint_status"].Rows.Count <= 0)
      {
          Rep_comp_solved.Visible = false;
          s = "No solved Complaints are there";
          CreateMessageAlert(this, s);
          Prev.Visible = false;
          Next.Visible = false;
      }
      else
      {
          Prev.Visible = true;
          Next.Visible = true;
      }

      //Second Part
      //Create a new Command to select the total number of records
      SqlCommand Cmd = new SqlCommand("select count(*) from Hr_complaint_detail a,hr_complaint_status b "
                  + " where a.sys_complaint_id=b.Complaint_id and b.Resolved_or_not=1 and a.Emp_id="+empid, con);
      con.Open();
      //retrieve the value
      TotalSize.Value = Cmd.ExecuteScalar().ToString();
      con.Close();
      BuildPagers();
  }

public void Page_Repeater(object sender, EventArgs e)
  {
      //Check for Button clicked
      if (((LinkButton)sender).ID == "Prev")
      {
          //Check if we are on any page greater than 0
          if ((int.Parse(CurrentPage.Value) - 1) >= 0)
          {
              //Decrease the CurrentPage Value
              CurrentPage.Value = (int.Parse(CurrentPage.Value) - 1).ToString();
          }
      }
      else if (((LinkButton)sender).ID == "Next")
      {
          //Check if we can display the next page.
          if ((int.Parse(CurrentPage.Value) * int.Parse(PageSize.Value))< int.Parse(TotalSize.Value))
          {
              //Increment the CurrentPage value
              CurrentPage.Value = (int.Parse(CurrentPage.Value) + 1).ToString();
          }
      }
      //Rebuild the Grid
      Repeaterfill();
  }
  public void BuildPagers()
  {
      //Check if its possible to have the previous page
      if ((int.Parse(CurrentPage.Value) - 1) <= 0)
      {
          Prev.Enabled = false;
      }
      else
      {
          Prev.Enabled = true;
      }
      //Check if its possible to have the next page
      if ((int.Parse(CurrentPage.Value) * int.Parse(PageSize.Value)) >= int.Parse(TotalSize.Value))
      {
          Next.Enabled = false;
      }
      else
      {
          Next.Enabled = true;
      }
  }