GridView重复显示数据？

[yetianbiao]

我无论在查询主表的时候，或者是点击主表显示从表的时候，gridview显示出来的为什么每条数据都会一样的重复显示两遍啊？很奇怪啊~有谁能帮帮我吗？下面是代码，gridview3是连主表的，gridview1是连从表的：

  public partial class tb_xsd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {      
       if (!IsPostBack)
        {
             xsd();
       }
    }

    public void xsd()
    {
        
        string SQL = "SELECT * FROM [xsd]";
        GridView3.DataSource = Binding(SQL);
        GridView3.DataKeyNames = new string[]{ "xs_no"};
        GridView3.DataBind();
        GridView1.Visible = false;

    }


    public void xsd_mx()
    {

        string strSql;
       string myStc = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        SqlConnection conn = new SqlConnection(myStc);
        conn.Open();
      
        strSql = "select * from xsd_zc"; 
        SqlDataAdapter adp = new SqlDataAdapter(strSql, conn);
        DataSet ds = new DataSet();
        adp.Fill(ds, "xsd_zc");
        GridView1.DataSource = ds.Tables["xsd_zc"].DefaultView;
        GridView1.DataBind();
    }

    protected void cerBtn_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        GridView1.Visible = false;
    }

    protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       
    }
    protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
    {
      
        string xs_no = Convert.ToString(GridView3.SelectedValue);
        string SQL = "SELECT * FROM [xsd_zc] WHERE [xs_no]='" +xs_no+ "'";
        GridView1.DataSource = Binding(SQL);
        GridView1.DataBind();
        GridView1.Visible = true;

    }

    protected DataTable Binding(string SQL)
    {
        string myStc = ConfigurationManager.AppSettings["ConnectionString"].ToString();
         SqlConnection conn = new SqlConnection(myStc);
        DataTable dt = new DataTable();
        SqlDataAdapter myAdapter = new SqlDataAdapter(SQL,conn);
        myAdapter.Fill(dt);
        return dt;

    }

    protected void cxBtn_Click(object sender, EventArgs e)
    {
        GridView1.Visible = false;
       
        string SQL;
        if (TextBox1.Text =="" || TextBox1.Text=="全部")
               SQL="SELECT * FROM [xsd]";
        else 
        SQL = "SELECT * FROM [xsd] where xs_no='"+TextBox1.Text+"'";

        GridView3.DataSource = Binding(SQL);
        GridView3.DataKeyNames = new string[] { "xs_no" };
        GridView3.DataBind();
    }
   protected void GridView3_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
       
    }
   
    protected void GridView3_PageIndexChanging1(object sender, GridViewPageEventArgs e)
    {
        GridView3.PageIndex = e.NewPageIndex;
        xsd();   
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        string xs_no = Convert.ToString(GridView3.SelectedValue);
        string SQL = "SELECT * FROM [xsd_zc] WHERE [xs_no]='" + xs_no + "'";
        GridView1.DataSource = Binding(SQL);
        GridView1.DataBind();
        GridView1.Visible = true;
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        
    }
    protected void GridView3_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string myStc = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        SqlConnection sqlConnection1 = new SqlConnection(myStc);
        string strSql,sql;
        strSql = "Delete from xsd  Where xs_no='" + GridView3.DataKeys[e.RowIndex].Value + "'";
        sql = "Delete from xsd_zc  Where xs_no='" + GridView3.DataKeys[e.RowIndex].Value + "'";
        SqlCommand cmd = new SqlCommand(strSql, sqlConnection1);
        SqlCommand cmd1 = new SqlCommand(sql, sqlConnection1);
        try
        {
            sqlConnection1.Open();
            cmd.ExecuteNonQuery();
            cmd1.ExecuteNonQuery();
            sqlConnection1.Close();
            sqlConnection1.Dispose();

        }
        catch (SqlException)
        {
            Label1.Text = "发生错误，没有正常删除记录";
        }
        xsd();  
    }
    protected void backBtn_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default2.aspx");
    }
}

[wangzhenyue]

我知道了 。。看看你的GRIDVIEW中编辑它。。
看看下面是不是有个自动生成数据。。。

[wangzhenyue]

将它点掉就可以了啊

[rgzazq]

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
string xs_no = Convert.ToString(GridView3.SelectedValue);
string SQL = "SELECT * FROM [xsd_zc] WHERE [xs_no]='" + xs_no + "'";
GridView1.DataSource = Binding(SQL);
GridView1.DataBind();
GridView1.Visible = true;
}
中的
string xs_no = Convert.ToString(GridView3.SelectedValue);
string SQL = "SELECT * FROM [xsd_zc] WHERE [xs_no]='" + xs_no + "'";
GridView1.DataSource = Binding(SQL);
GridView1.DataBind();
GridView1.Visible = true;
不要写在这里，写到PreRender事件中去

[yetianbiao]

用select distinct的话~正常是可以正常的，但是我数据库里面有text类型或image类型的~不能用这个来过滤啊~~

那个gridview里面我自动生成字段本来就没点上过的，自动增加列也是FALSE的~~

string xs_no = Convert.ToString(GridView3.SelectedValue); 
        string SQL = "SELECT * FROM [xsd_zc] WHERE [xs_no]='" + xs_no + "'"; 
        GridView1.DataSource = Binding(SQL); 
        GridView1.DataBind(); 
        GridView1.Visible = true;

写到PreRender事件里了还是一样的结果啊~

数据本身是没有重复的，用查询分析器查询的话~也会出现重复两条记录的~~难道只能用distinct？但是我数据库里面有text类型或image类型的啊

[yetianbiao]

顶顶~~谁帮我再看看啊~~~~各位大哥~

[mengxj85]

最有可能是你的SQL语句问题，拿到查询分析器里测测

[yetianbiao]

查询分析器里还是会显示出两条重复的~~但是语句上看起来没错啊

[cwmwss]

用查询分析器查询的话~也会出现重复两条记录。。。。数据库里是一条的？

[yetianbiao]

是的~~数据库里是一条的~~

[阿彪兄]

如果数据有重复就用distinct筛选过滤

[yetianbiao]

但 distinct 不能过滤text image 等字段类型的数据啊~

[凋零的老树]

是你数据的问题

[yetianbiao]

[Quote=引用 22 楼 kongxiangli 的回复:]
是你数据的问题
[/Quote]

数据的问题？为什么啊？能详细点吗？数据库里的数据本身是不重复的啊~

[wxd024]

在"编辑列"中把"自动生成字段"前的对号去掉就可以啦

[wxd024]

在"编辑列"中把"自动生成字段"前的对号去掉就可以啦

[俄德米]

八楼是对的！！我遇到这种情况，用哪种方法就好使了！谢谢了！

[俄德米]

就是把自动生成字段那个勾去掉就可以了！

[duanjiwei]

是行重复啊，还是类重复啊、
。知道这个很重要啊。

[junehsu]

我也遇到同样问题啊，兄弟们

[junehsu]

终于问题解决了
strSql = "select distinct * from xsd_zc";
GridView1中选定的字段要与上面的相同问题就解决了。
我检查了自己的选定结果原来发现自己GridView1字段中少选了一个，将少选的补上问题解决了，终于可以睡一个好觉了啊。晚安。呵呵