将数据源插入gridview时出错 [英] Error when insert datasource to gridview

问题描述

我的DAL

My DAL

public List<BOL.MRF> MRFList(string SUBS_CD, string cc)
{
    List<BOL.MRF> vOE_LIST = new List<BOL.MRF>();

    oConnection.ConnectionString = ConnectionString;
    oConnection.Open();

    SqlCommand oCommand = new SqlCommand();
    oCommand.Connection = oConnection;
    oCommand.CommandType = CommandType.StoredProcedure;
    oCommand.CommandText = "mrf_list1";
    oCommand.Parameters.Add(new SqlParameter("@Subs_cd", SUBS_CD));
    oCommand.Parameters.Add(new SqlParameter("@cc", cc));
    SqlDataReader oReader = oCommand.ExecuteReader();
    while (oReader.Read())
    {
        BOL.MRF MRF_L = new BOL.MRF();
        MRF_L.E_Name = oReader.IsDBNull(oReader.GetOrdinal("E_Name")) ? "" : oReader["E_Name"].ToString();
        MRF_L.requester = oReader.IsDBNull(oReader.GetOrdinal("Name")) ? "" : oReader["Name"].ToString();
        MRF_L.Location = oReader.IsDBNull(oReader.GetOrdinal("E_Loc")) ? "" : oReader["E_Loc"].ToString();
        MRF_L.P_Desc = oReader.IsDBNull(oReader.GetOrdinal("D_Prob")) ? "" : oReader["D_Prob"].ToString();
        vOE_LIST.Add(MRF_L);
    }
    oReader.Close();
    oConnection.Close();

    return vOE_LIST;

}

我的cs.aspx

my cs.aspx

protected void FillRequestGrid()
   {
       int loggedUserID = Convert.ToInt32(Session["loggedUserID"]);
       List<BOL.UserInfo> userslist = new UserInfos().List();
       BOL.UserInfo loggeduser = userslist.Where(x => x.UserID == loggedUserID).FirstOrDefault();

       DAL.MRFs mrf_L= new MRFs();
       var mrf1 = mrf_L.MRFList(loggeduser.SUBSIDIARY_CD, loggeduser.CostCenter);

       GridR.DataSource = mrf_L;
       GridR.DataBind();

       if (GridR.Rows.Count > 0)
       {
           GridR.HeaderRow.TableSection = TableRowSection.TableHeader;
       }
   }

i在我的gridview填充数据源时出现此错误。 />
错误：

i getting this error while fill in datasource to my gridview.
error :

Additional information: Data source is an invalid type.  It must be either an IListSource, IEnumerable, or IDataSource.

line

GridR.DataSource = mrf_create;

任何想法如何转换为listsource / datasource？



我尝试过：



需要指南，非常感谢。

Any idea how to convert to listsource/datasource?

What I have tried:

need guide,thank you very much.

推荐答案

你需要绑定List结果而不是包含你的对象列表与LT; bol.mrf取代。所以尝试这样的事情：

You need to bind the List result and not the object that contains your List<bol.mrf>. So try something like this:

DAL.MRFs mrf_L= new MRFs();
var mrf1 = mrf_L.MRFList(loggeduser.SUBSIDIARY_CD, loggeduser.CostCenter);

GridR.DataSource = mrf1;
GridR.DataBind();

这篇关于将数据源插入gridview时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！