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