Exemplo n.º 1
0
    protected void DDLmostly_SelectedIndexChanged(object sender, EventArgs e)
    {
        string    id  = DDLmostly.SelectedValue.ToString();
        string    nid = Session["userID"].ToString();
        DataTable dt  = pd.GetalladdresslistnewData(id, nid);

        GVdata.DataSource = dt;
        GVdata.DataBind();
    }
Exemplo n.º 2
0
    public void alldata()
    {
        string nid = Session["userID"].ToString();
        string sql = "select distinct(a.id),a.userID,a.frdname,a.frdphone,a.frdMobilePhone,a.frdAddress,a.frdQQ,a.frdEmail,a.frdImageUrl,a.CreateDate,a.general,b.sortname from addresslist as a right join sorttable as b on a.Sortnumber=b.sortnumber where a.userid='" + nid + "' order by a.id desc";

        DataSet ds = db.GetDataSet(sql);

        GVdata.DataSource = ds;
        GVdata.DataBind();
    }