using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

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

    }

    private void BindGrid()
    {
        String str = "server='(local)';DataBase=kq;uid=sa;pwd=sa";
        SqlConnection cn = new SqlConnection(str);
        cn.Open();
      String mysql = "select * from admin";
      SqlDataAdaper da = new SqlDataAdaper(mysql, cn);
      DataSet ds = new DataSet();
      da.Fill(ds);
      GridView1.DataSource = ds;
      GridView1.DataBind();
      cn.Close();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //获取要删除的记录的id并赋值给变量ID
        string ID = this.GridView1.DataKeys[e.RowIndex][0].ToString();
        logic.Class1 abc = new logic.Class1();
        string Sql = "DELETE FROM" + configure.Class1.Dataname + " where id=" + ID + "";
        abc.Exesql(Sql);
        baindata();
    }
    //换页后触发
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        //更新页值
        this.GridView1.PageIndex = e.NewPageIndex;
        baindata();//重新绑定记录
    }
    //点击编辑后触发
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        baindata();
    }
    //当取消时触发
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        baindata();
    }
   
    protected void  Button2_Click(object sender, EventArgs e)
{
　　　　　Response.Redirect("adminadd.aspx");
}
}
   

 

这段程序报错，怎么解决啊，这段程序有点乱。能帮我改一下吗，谢谢各位

SqlDataAdaper

========>

SqlDataAdapter

不少啊，   if (!IsPostBack)
           { BindGrid();}，取主键string ID = this.GridView1.DataKeys[e.RowIndex]。value.ToString();

楼主你是在装傻吗？三楼已经说的很清楚了
SqlDataAdaper da = new SqlDataAdaper(mysql, cn);这行代码中的SqlDataAdaper写的是错的，你少写了一个“t”
应该是SqlDataAdapter da = new SqlDataAdapter(mysql, cn);

不明白楼主为什么会少？不是打前几个字母就有提示了吗？而且色也是高亮的！

谢谢了，我解决了。