Gridview重复值. [英] Gridview duplicate values..

问题描述

如何避免在网格视图中显示重复值????
例如:-1个数学1234
2个Bio 234
1个数学1234
2个Bio 234
我的代码是:-

public partial class InstSentIntForFran : System.Web.UI.Page
{
    SqlConnection cn;
    autheticate at = new autheticate();
    protected void Page_Load(object sender, EventArgs e)
    {
        
        getCandidateSentIntrest();
    }
    public void getCandidateSentIntrest()
    {
        try
        {
            cn = at.sqlcon();
            //SqlDataAdapter sda = new SqlDataAdapter(strqry, cn);
            //DataSet ds = new DataSet();

            string strqry = getQuery();
 
            SqlDataAdapter sda = new SqlDataAdapter(strqry, cn);
            DataSet ds = new DataSet();
            ds.Clear();
            sda.Fill(ds);
            int dd = ds.Tables[0].Rows.Count;
            GridView1.DataSource = ds;
            GridView1.DataBind();
          
          
        }
        catch (Exception err)
        {
            lblres.Text = err.Message;
        }
    }


    string getQuery()
    {

         string sentintrestType = "";
        if (Request.QueryString["sentintrestType"] != null)
        {
            sentintrestType = Request.QueryString["sentintrestType"].ToString();
        }
        string qry = "Select C.Franchise_Brand_Name,p.Franchise_Offer_Industry,p.Franchise_Offer_ExpnReg,p.Franchise_OfferInvReqMin,p.Franchise_Offer_InvReqMx,p.Franchise_Offer_MinSqft,p.Franchise_Offer_MaxSqFt,I.Int_Date from User_Details U,Franchise_Details C,Franchise_Offer_Details p,Intrests I where I.Applicants_User_Name=''" + Session["uid"] + "'' and I.Receivers_User_Name = U.User_Name and I.Receivers_User_Name = C.User_Name and p.User_Name = C.User_Name  ";
        
       
        if (sentintrestType == "Brand_Int_Frn")
        {
            qry = qry + "and I.Brand_Int_Frn=''true''";
        }
        qry = qry + "ORDER BY I.Int_Date DESC";
        return qry;

    }

}

请帮助我这是什么问题吗???????????????????????? 1.确保查询仅返回所需的数据.查询本身没有重复项.
2.更改以下代码行:

 GridView1.DataSource = ds; 

到

 GridView1.DataSource = ds.Tables [ 0 ]; 

没问题，但是您可能希望将GridBind代码放在Page IsPostback属性中，以避免在每次回发时重新绑定网格.

如果查询返回的行比
将其写在gridview的属性aspx页面中

 AutoGenerateColumns = "  

how to avoid to display duplicate value in grid view?????
eg:- 1 maths 1234
2 bio 234
1 maths 1234
2 bio 234
my code is:-

public partial class InstSentIntForFran : System.Web.UI.Page
{
    SqlConnection cn;
    autheticate at = new autheticate();
    protected void Page_Load(object sender, EventArgs e)
    {
        
        getCandidateSentIntrest();
    }
    public void getCandidateSentIntrest()
    {
        try
        {
            cn = at.sqlcon();
            //SqlDataAdapter sda = new SqlDataAdapter(strqry, cn);
            //DataSet ds = new DataSet();

            string strqry = getQuery();
 
            SqlDataAdapter sda = new SqlDataAdapter(strqry, cn);
            DataSet ds = new DataSet();
            ds.Clear();
            sda.Fill(ds);
            int dd = ds.Tables[0].Rows.Count;
            GridView1.DataSource = ds;
            GridView1.DataBind();
          
          
        }
        catch (Exception err)
        {
            lblres.Text = err.Message;
        }
    }


    string getQuery()
    {

         string sentintrestType = "";
        if (Request.QueryString["sentintrestType"] != null)
        {
            sentintrestType = Request.QueryString["sentintrestType"].ToString();
        }
        string qry = "Select C.Franchise_Brand_Name,p.Franchise_Offer_Industry,p.Franchise_Offer_ExpnReg,p.Franchise_OfferInvReqMin,p.Franchise_Offer_InvReqMx,p.Franchise_Offer_MinSqft,p.Franchise_Offer_MaxSqFt,I.Int_Date from User_Details U,Franchise_Details C,Franchise_Offer_Details p,Intrests I where I.Applicants_User_Name=''" + Session["uid"] + "'' and I.Receivers_User_Name = U.User_Name and I.Receivers_User_Name = C.User_Name and p.User_Name = C.User_Name  ";
        
       
        if (sentintrestType == "Brand_Int_Frn")
        {
            qry = qry + "and I.Brand_Int_Frn=''true''";
        }
        qry = qry + "ORDER BY I.Int_Date DESC";
        return qry;

    }

}

plz help me what is wrong in this?????

解决方案

2 things:
1. Make sure your query returns only the needed data. No duplicates from query itself.
2. Change this line of code:

GridView1.DataSource = ds;

to

GridView1.DataSource = ds.Tables[0];

Not an issue, but you may want to put the GridBind code in Page IsPostback property to avoid grid''s rebind on every postback.

If your query returning one row than
write this in gridview''s property aspx page

AutoGenerateColumns="False"

这篇关于Gridview重复值.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！