不会调用方法了（控件用的GridView）

Question

DbHelper
   public DbHelper()    {
        this.connection = CreateConnection(DbHelper.dbConnectionString);
    }
    public DbHelper(string connectionString)
    {
        this.connection = CreateConnection(connectionString);
    }
    public static DbConnection CreateConnection()
    {
        DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
        DbConnection dbconn = dbfactory.CreateConnection();
        dbconn.ConnectionString = DbHelper.dbConnectionString;
        return dbconn;
    }
    public static DbConnection CreateConnection(string connectionString)
    {
        DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
        DbConnection dbconn = dbfactory.CreateConnection();
        dbconn.ConnectionString = connectionString;
        return dbconn;
    }
    public DbCommand GetStoredProcCommond(string storedProcedure)
    {
        DbCommand dbCommand = connection.CreateCommand();
        dbCommand.CommandText = storedProcedure;
        dbCommand.CommandType = CommandType.StoredProcedure;
        return dbCommand;
    }
    public DbCommand GetSqlStringCommond(string sqlQuery)
    {
        DbCommand dbCommand = connection.CreateCommand();
        dbCommand.CommandText = sqlQuery;
        dbCommand.CommandType = CommandType.Text;
        return dbCommand;
    }    #region 增加参数
    public void AddParameterCollection(DbCommand cmd, DbParameterCollection dbParameterCollection)
    {
        foreach (DbParameter dbParameter in dbParameterCollection)
        {
            cmd.Parameters.Add(dbParameter);
        }
    }
    public void AddOutParameter(DbCommand cmd, string parameterName, DbType dbType, int size)
    {
        DbParameter dbParameter = cmd.CreateParameter();
        dbParameter.DbType = dbType;
        dbParameter.ParameterName = parameterName;
        dbParameter.Size = size;
        dbParameter.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(dbParameter);
    }
    public void AddInParameter(DbCommand cmd, string parameterName, DbType dbType, object value)
    {
        DbParameter dbParameter = cmd.CreateParameter();
        dbParameter.DbType = dbType;
        dbParameter.ParameterName = parameterName;
        dbParameter.Value = value;
        dbParameter.Direction = ParameterDirection.Input;
        cmd.Parameters.Add(dbParameter);
    }
    public void AddReturnParameter(DbCommand cmd, string parameterName, DbType dbType)
    {
        DbParameter dbParameter = cmd.CreateParameter();
        dbParameter.DbType = dbType;
        dbParameter.ParameterName = parameterName;
        dbParameter.Direction = ParameterDirection.ReturnValue;
        cmd.Parameters.Add(dbParameter);
    }
    public DbParameter GetParameter(DbCommand cmd, string parameterName)
    {
        return cmd.Parameters[parameterName];
    }
    #endregion    #region 执行
    public DataSet ExecuteDataSet(DbCommand cmd)
    {
        DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
        DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
        dbDataAdapter.SelectCommand = cmd;
        DataSet ds = new DataSet();
        dbDataAdapter.Fill(ds);
        return ds;
    }
    public DataTable ExecuteDataTable(DbCommand cmd)
    {
        DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
        DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
        dbDataAdapter.SelectCommand = cmd;
        DataTable dataTable = new DataTable();
        dbDataAdapter.Fill(dataTable);
        return dataTable;
    }
    public DbDataReader ExecuteReader(DbCommand cmd)
    {
        cmd.Connection.Open();
        DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        return reader;
    }
    public int ExecuteNonQuery(DbCommand cmd)
    {
        cmd.Connection.Open();
        int ret = cmd.ExecuteNonQuery();
        cmd.Connection.Close();
        return ret;
    }
    public object ExecuteScalar(DbCommand cmd)
    {
        cmd.Connection.Open();
        object ret = cmd.ExecuteScalar();
        cmd.Connection.Close();
        return ret;
    }
    #endregion    #region 执行事务
    public DataSet ExecuteDataSet(DbCommand cmd, Trans t)
    {
        cmd.Connection = t.DbConnection;
        cmd.Transaction = t.DbTrans;
        DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
        DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
        dbDataAdapter.SelectCommand = cmd;
        DataSet ds = new DataSet();
        dbDataAdapter.Fill(ds);
        return ds;
    }
    public DataTable ExecuteDataTable(DbCommand cmd, Trans t)
    {
        cmd.Connection = t.DbConnection;
        cmd.Transaction = t.DbTrans;
        DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
        DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
        dbDataAdapter.SelectCommand = cmd;
        DataTable dataTable = new DataTable();
        dbDataAdapter.Fill(dataTable);
        return dataTable;
    }
    public DbDataReader ExecuteReader(DbCommand cmd, Trans t)
    {
        cmd.Connection.Close();
        cmd.Connection = t.DbConnection;
        cmd.Transaction = t.DbTrans;
        DbDataReader reader = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        return reader;
    }
    public int ExecuteNonQuery(DbCommand cmd, Trans t)
    {
        cmd.Connection.Close();
        cmd.Connection = t.DbConnection;
        cmd.Transaction = t.DbTrans;
        int ret = cmd.ExecuteNonQuery();
        return ret;
    }
    public object ExecuteScalar(DbCommand cmd, Trans t)
    {
        cmd.Connection.Close();
        cmd.Connection = t.DbConnection;
        cmd.Transaction = t.DbTrans;
        object ret = cmd.ExecuteScalar();
        return ret;
    }
    #endregion
}
    
public class Trans : IDisposable
{
    private DbConnection conn;
    private DbTransaction dbTrans;
    public DbConnection DbConnection
    {
        get { return this.conn; }
    }
    public DbTransaction DbTrans
    {
        get { return this.dbTrans; }
    }
    public Trans()
    {
        conn = DbHelper.CreateConnection();
        conn.Open();
        dbTrans = conn.BeginTransaction();
    }
    public Trans(string connectionString)
    {
        conn = DbHelper.CreateConnection(connectionString);
        conn.Open();
        dbTrans = conn.BeginTransaction();
    }
    public void Commit()
    {
        dbTrans.Commit();
        this.Colse();
    }
    public void RollBack()
    {
        dbTrans.Rollback();
        this.Colse();
    }
    public void Dispose()
    {
        this.Colse();
    }
    public void Colse()
    {
        if (conn.State == System.Data.ConnectionState.Open)
        {
            conn.Close();
        }
    }
}

Answer 1

DALusing System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
   public class data2_DAL
    {
        //查询所有数据
        public static IList<data2> SelectAll()
        {
            DbHelper db = new DbHelper();
            DbCommand cmd = db.GetSqlStringCommond("SELECT * FORM data2");
            return CollectionHelper.ConvertTo<data2>(db.ExecuteDataTable(cmd));
        }
        //查询所有数据
        public static DataTable SelectAllForExcel()
        {
            DbHelper db = new DbHelper();
            DbCommand cmd = db.GetSqlStringCommond("SELECT * FROM data2");
            return db.ExecuteDataTable(cmd);
        }
        //删除数据
        public static bool Delete(int id)
        {
            DbHelper db = new DbHelper();
            DbCommand cmd = db.GetSqlStringCommond("DELETE * FROM data2 WHERE (id=" + id + ")");
            int status = db.ExecuteNonQuery(cmd);
            if (status == 1)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
BLL
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
   public class data2_BLL
    {
       //返回所有数据
       public static string SelectAll()
       {
           return DataConvert.IList2Json<data2>("DataTable", data2_DAL.SelectAll());
       }
       public static DataTable selectAllForExcel()
       {
           DataTable dataSource = data2_DAL.SelectAllForExcel();
           dataSource.Columns.Remove("id");
           dataSource.Columns["nq"].ColumnName = "全国统一编号";
           dataSource.Columns["ns"].ColumnName = "省（区）编号";
           dataSource.Columns["ny"].ColumnName = "原编号";
           dataSource.Columns["mc"].ColumnName = "品种名称";
           dataSource.Columns["ly"].ColumnName = "来源或原产地";
           dataSource.Columns["bc"].ColumnName = "保存单位";
           dataSource.Columns["xp"].ColumnName = "系谱";
           dataSource.Columns["xy"].ColumnName = "选育单位";
           dataSource.Columns["yc"].ColumnName = "育成年份";
           dataSource.Columns["zz"].ColumnName = "种质类型";
           dataSource.Columns["yt"].ColumnName = "用途";
           dataSource.Columns["sy"].ColumnName = "生育期（d）";
           dataSource.Columns["yq"].ColumnName = "芽鞘色";
           dataSource.Columns["ym"].ColumnName = "幼苗色";
           dataSource.Columns["zg"].ColumnName = "株高（cm）";
           dataSource.Columns["jc"].ColumnName = "茎粗（cm）";
           dataSource.Columns["fn"].ColumnName = "分蘖（个）";
           dataSource.Columns["hc"].ColumnName = "穗长（cm）";
           dataSource.Columns["hbs"].ColumnName = "穗柄伸出度（cm）";
           dataSource.Columns["hbw"].ColumnName = "穗柄弯曲程度";
           dataSource.Columns["hb"].ColumnName = "是否护脖";
           dataSource.Columns["zm"].ColumnName = "主脉色";
           dataSource.Columns["hx1"].ColumnName = "穗型";
           dataSource.Columns["hx2"].ColumnName = "穗形";
           dataSource.Columns["ykc"].ColumnName = "颖壳色";
           dataSource.Columns["ykb"].ColumnName = "颖壳包被度";
           dataSource.Columns["mx"].ColumnName = "芒性";
           dataSource.Columns["pr"].ColumnName = "胚乳类型";
           dataSource.Columns["ks"].ColumnName = "壳色";
           dataSource.Columns["ls"].ColumnName = "粒色";
           dataSource.Columns["lx"].ColumnName = "粒形";
           dataSource.Columns["hl"].ColumnName = "穗粒重（g）";
           dataSource.Columns["ql"].ColumnName = "千粒重（g）";
           dataSource.Columns["zk"].ColumnName = "着壳率（%）";
           dataSource.Columns["jz"].ColumnName = "角质率（%）";
           dataSource.Columns["cd"].ColumnName = "粗蛋白（%）";
           dataSource.Columns["la"].ColumnName = "赖氨酸（%）";
           dataSource.Columns["dn"].ColumnName = "单宁（%）";
           dataSource.Columns["zd"].ColumnName = "总淀粉（%）";
           dataSource.Columns["zl"].ColumnName = "支链淀粉含量（%）";
           dataSource.Columns["cz"].ColumnName = "粗脂肪（g/kg）";
           dataSource.Columns["qx"].ColumnName = "倾斜率（%）";
           dataSource.Columns["dz"].ColumnName = "倒折率（%）";
           dataSource.Columns["sz"].ColumnName = "丝黑穗病自然发病率（%）";
           dataSource.Columns["sj"].ColumnName = "丝黑穗病接种发病率（%）";
           dataSource.Columns["jyb"].ColumnName = "茎叶病";
           dataSource.Columns["ymx"].ColumnName = "玉米冥抗性";
           dataSource.Columns["note"].ColumnName = "备注";
           return dataSource;
       }
       //删除数据
       public static string Delete(int id)
       {
           bool status = data2_DAL.Delete(id);
           if (status) 
           {
               return "成功"; 
           }
           else
           {
               return "失败"; 
           }
       }

Answer 2

显示的页代码index2.aspx
     <tbody>
            <tr class="listA">
                <asp:GridView ID="GVAbout" runat="server" 
                    AutoGenerateColumns="False" AutoGenerateEditButton="True" BorderColor="Black" 
                    BorderStyle="Solid" BorderWidth="1px" DataKeyNames="id" EnableViewState="False" 
                    GridLines="None" PageSize="10" AutoGenerateDeleteButton="True" 
                    style="margin-right: 0px" AllowPaging="True" 
                    onpageindexchanging="GVAbout_PageIndexChanging" 
                    onrowcancelingedit="GVAbout_RowCancelingEdit" onrowediting="GVAbout_RowEditing" 
                    onrowupdating="GVAbout_RowUpdating">
                </asp:GridView>
                
               
            </tr>
        </tbody>index2.aspx.cs 代码    这就不会写了  不知道怎么调用自己写的方法  怎样写才能把数据库的东西绑定到GridView空件里
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;namespace WpfAppKY.library.data2
{
    public partial class index2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {        }
      }
}

Answer 3

能显示出数据库的数据  在index2.aspx 运行的时候   现在就是不知道怎么用自己的查询所有数据的方法

Answer 4

data2_BLL 中的 SelectAll() 有些问题你现在的 SelectAll() 应该命名为 All2Json而 SelectAll() 应该是返回 IList<data2> 

Answer 5

namespace WpfAppKY.library.data2
{
    public partial class Full : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GVAbout.DataSource = data2_BLL.SelectAll();
                GVAbout.DataBind();
            }
        }
    }
}这么写行不行

Answer 6

要看你的 data2_BLL.SelectAll 返回的是什么之前返回 string 是不行的

Answer 7

如果返回的是datatable 直接绑定就行了 要是返回的dataSet  data2_BLL.SelectAll().table[0]