根据登录人数据绑定gridview? [英] Binding gridview according to login person data?

问题描述

我正在房地产网站上工作.我想根据一个登录人员在网格视图中显示已发布的广告，例如:-如果某人"A"正在网站上登录并发布了一些广告，则如果"A"要显示自己的广告.我要这么做.


给我一些线索...


预先感谢.

I am working on real estate web portal. I want to show posted ad in a grid view according to a login person for example:- if a person "A" is login on website and has posted some ads then if "A" want to show own ad. I want to do this.


Give me some clues...


Thanks in advance.

推荐答案

我已经解决了.:)
使用此代码在页面上加载.

I have solved it.:)
on page load using this code.

protected void Page_Load(object sender, EventArgs e)
{
   SqlCommand SelectCommand = new SqlCommand("select Id,Title,owner from PostAd1 where owner=@owner",conn);
   SelectCommand.Parameters.Add("@owner", SqlDbType.NVarChar);
   SelectCommand.Parameters[0].Value = Convert.ToString(Session["username"].ToString());
   SqlDataAdapter da = new SqlDataAdapter(SelectCommand);
 
   da.Fill(ds);
   Gridview1.DataSource = ds;
   Gridview1.DataBind();
}

[edit]添加了代码块[/edit]

[edit]code block added[/edit]

这篇关于根据登录人数据绑定gridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！