예제 #1
0
    public void filldata()
    {
        ds = objdf.FillDss("select um.id,username,useremail,usermobilenumber,age,cm.city from UserMaster um, CityMaster cm where um.city  = cm.id ");


        Repeater1.DataSource = ds;
        Repeater1.DataBind();
    }
예제 #2
0
    public void countmemberdata()
    {
        DataSet ds = objdf.FillDss("select count(id) as total,count(case when gender='1' then 1 end ) as male_cnt,count(case when gender='2' then 1 end ) as female_cnt  from UserMaster");

        lblcountmem.Text = ds.Tables[0].Rows[0]["total"].ToString();
        lblbride.Text    = ds.Tables[0].Rows[0]["female_cnt"].ToString();
        lblgroom.Text    = ds.Tables[0].Rows[0]["male_cnt"].ToString();
    }
예제 #3
0
 public void FetchDetails()
 {
     ds = objdf.FillDss("select rm.id, rm.Sender_Id, rm.Recevier_Id, um.username, rm.User_Name from RequestMaster rm, UserMaster um where rm.Confrim = '" + 1 + "' AND rm._Delete = '" + 0 + "' and  rm.Sender_Id = um.id ");
     Repeater1.DataSource = ds;
     Repeater1.DataBind();
 }