DATALIST Part2

DATALIST PART2

 

   public
DataTable getTheData()

    {

 

 

        DataSet DS1 =
new DataSet();

      //SqlConnection myConnection = new SqlConnection("Data
Source=.;Initial Catalog=TNariyamatrimony;User
ID=sa;Password=signinsign");

     SqlConnection myConnection = new SqlConnection("Data Source=98.130.0.27;Initial Catalog=signins_reports;User ID=signins_mssql;Password=ClDu47ESetde;");

        myConnection.Open();

     

      //  SqlDataAdapter objSQLAdapter = new SqlDataAdapter("select
FileName,User_Name,User_Age,Height,Weight,Star,Sub_Caste,Reside_City,Edu_Category,User_Id
from Search_Info where User_Gender='"
+ UserGender + "' and User_Age
between '" + DateFrom + "' and '" + DateTo + "'", myConnection);

        //objSQLAdapter.Fill(DS1, "Search_Info");

 

 

 

        SqlDataAdapter
objSQLAdapter = new SqlDataAdapter("select
Search_Info.FileName,Search_Info.User_Name,Search_Info.User_Age,Search_Info.Height,Search_Info.Weight,Search_Info.Star,Search_Info.Sub_Caste,Search_Info.Reside_City,Search_Info.Edu_Category,Search_Info.User_Id,Attributes_info.Edu_detail from Search_Info,Attributes_info where Search_Info.User_Gender='"
+ UserGender + "'
and Search_Info.User_Age between '" + DateFrom + "' and '"
+ DateTo + "' and Search_Info.User_id=Attributes_info.User_id",
myConnection);

        objSQLAdapter.Fill(DS1);

 

        return DS1.Tables[0];

 

 

 

 

    }

 

 

    void
doPaging()

    {

 

        pagedData.DataSource
= getTheData().DefaultView;

 

        pagedData.AllowPaging
= true;

        pagedData.PageSize
= 5;

 

 

 

        try

        {

            pagedData.CurrentPageIndex
= Int32.Parse(Request["Page"].ToString());

 

        }

 

        catch (Exception
ex)

        {

 

            pagedData.CurrentPageIndex
= 0;

 

        }

        Linktop1.Visible = (!pagedData.IsFirstPage);

        lnkfirst.Visible
= (!pagedData.IsFirstPage);

        Linktop2.Visible = (!pagedData.IsFirstPage);

        LinkButton2.Visible = (!pagedData.IsFirstPage);

      //  LinkButton22.Visible
= (!pagedData.IsFirstPage);

        Linktop3.Visible = (!pagedData.IsLastPage);

        LinkButton3.Visible = (!pagedData.IsLastPage);

        Linktop4.Visible = (!pagedData.IsLastPage);

        lnklast.Visible
= (!pagedData.IsLastPage);

 

 

        PageNumbers.Text
= (pagedData.CurrentPageIndex + 1) + " of " + pagedData.PageCount;

        lbltoppage.Text
= (pagedData.CurrentPageIndex + 1) + " of " + pagedData.PageCount;

     

 

        int a1 = pagedData.PageCount;

        int b1 = pagedData.CurrentPageIndex
+ 1;

 

        lblcountpage.Text
= a1.ToString();

        lblcurrentpageno.Text
= b1.ToString();

 

 

 

        DataList1.DataSource = pagedData;

 

        DataList1.DataBind();

        if (Label1.Text == "")

        {

            string result = "nomatch";

 

            Session["noresult"] = result.ToString();

 

 

 

 

 

            Response.Redirect("default.aspx");

 

        }

 

        if (pagedData.PageCount
== 0)

        {

 

            string result = "nomatch";

 

            Session["noresult"] = result.ToString();

 

 

 

 

 

 

            Response.Redirect("Default.aspx");

 

 

           

 

        }

 

    }

 

    private
void DataBinds()

    {

 

        string str = "select
FileName,User_Name,User_Age,Height,Weight,Star,Sub_Caste,Reside_City,Edu_Category,User_Id
from Search_Info where User_Gender='"
+ UserGender + "'
and User_Age between '" + DateFrom + "' and '"
+ DateTo + "'";

 

        mtclas.SetConnection();

        mtclas.OpenConnection();

        mtclas.ShowList(str, DataList1, "Search_Info");

 

    //    mtclas.CloseConnection();

 

 

 

    }