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