郁闷啊～～～System.IndexOutOfRangeException: 无法找到表 0

[Chase-Wang]

Datalist绑定数据库 第一次加载没问题 可等编辑的某一行的时候。 就出现问题了。 说无法找到表0. 我把关键的几段代码贴出来。 希望有大神帮我修改下。 多谢啊。

BindDataList部分

    protected static PagedDataSource pds = new PagedDataSource();//创建一个分页数据源的对象且一定要声明为静态
    public static string x;
    public static string mySql = "select * from goods order by  id asc";
    
    protected static string cb;
    protected static string cba;
    WmsClass gl = new WmsClass();
    protected void Page_Load(object sender, EventArgs e)
    { 
        if (!IsPostBack)
        { BindDataList(0);}
    }
    private void BindDataList(int currentpage)
    {
        pds.AllowPaging = true;
        pds.PageSize = 10;
        pds.CurrentPageIndex = currentpage;

        DataSet ds = new DataSet();
        ds=gl.GetDataSet(mySql);
        pds.DataSource = ds.Tables[0].DefaultView;//把数据集中的数据放入分页数据源中
        DataList.DataSource = pds;//绑定Datalist
        DataList.DataBind();
 }

DataList编辑的一个动作

    protected void DataList_DeleteCommand(object source, DataListCommandEventArgs e)
    {   x = ((Label)e.Item.FindControl("LB_id")).Text.Trim();
        mySql = "delete from goods where id='" + x + "'";
        gl.ExecuteSql(mySql);
        BindDataList(0);
    }

连接数据库的代码

public class WmsClass
    {
        public WmsClass()
        {
        }

        public SqlConnection con;

        bool myDBConSelfOpen = false;
        
        private void OpenSql()
        {
            if (con == null)
            {
                con = new SqlConnection(@"Data Source=GENGHI;Initial Catalog=WMS;Integrated Security=True");
                con.Open();
                myDBConSelfOpen = true;
            }
        }
        
        private void CloseSql()
        {
            if (myDBConSelfOpen == true)
            {
                con.Close();
                con.Dispose();
                con = null;

                myDBConSelfOpen = false;
            }
        }

        public SqlDataReader myDataReader(string mySql)
        {


            SqlDataReader dr;
            try
            {
                OpenSql();
                SqlCommand cmd = new SqlCommand(mySql, con);
                dr = cmd.ExecuteReader();
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return dr;


        }

        public DataRow GetDataRow(string strQuery)
        {
            DataRow myRow = null;
            try
            {
                DataTable myTable = GetDataTable(strQuery);
                if (myTable.Rows.Count > 0)
                {
                    myRow = myTable.Rows[0];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return myRow;
        }

        public DataSet GetDataSet(string strQuery)
        {
            DataSet myDataSet = new DataSet();

            try
            {
                OpenSql();
                SqlDataAdapter myDataAdapter = new SqlDataAdapter(strQuery, con);
                myDataAdapter.Fill(myDataSet);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            CloseSql();
            return myDataSet;
        }

        public DataTable GetDataTable(string strQuery)
        {
            
            DataTable myTable = new DataTable();
            try
            {
                myTable = GetDataSet(strQuery).Tables[0];
            }
            catch (Exception ex)
            {
                throw ex;
            }
            //返回数据集 myDataSet
            return myTable;
        }

        public bool ExecuteSql(string strQuery)
        {
            bool flag = true;
            OpenSql();
            SqlTransaction myTra = con.BeginTransaction();
            //创建操作数据库的命令
            SqlCommand myCommand = new SqlCommand(strQuery, con, myTra);
            try
            {
                //执行命令
                myCommand.ExecuteNonQuery();
                myTra.Commit();
            }
            catch (Exception ex)
            {
                flag = false;
                myTra.Rollback();
                throw ex;
            }
            CloseSql();
            return flag;}
    }
}

[liu_lxx]

帮你顶一下。在执行删除成功之后刷新页面试试。

[md5e]

或许和你这堆代码有关 protected static PagedDataSource pds = new PagedDataSource();//创建一个分页数据源的对象且一定要声明为静态 public static string x; public static string mySql = "select * from goods order by id asc"; protected static string cb; protected static string cba; 不用static看看,没有必要需要用static

[Chase-Wang]

引用 2 楼 liuchaolin 的回复:

或许和你这堆代码有关 protected static PagedDataSource pds = new PagedDataSource();//创建一个分页数据源的对象且一定要声明为静态 public static string x; public static string mySql = "select * from goods order by id asc"; protected static string cb; protected static string cba; 不用static看看,没有必要需要用static

第二段代码 数据库操作能够完成, 但紧接着的BindDataList(0)出问题了. 可PageLoad时能够顺利执行啊.

[Chase-Wang]

错误在于 BindDataList()里面的 ds=gl.GetDataSet(mySql)中的mySql在第二段代码中被改变了. 然后没有返回值给ds.