DAL的方法:
public List<RS_HolidayType> SearchHolidayType(string H_HolidayTime, string H_HolidayType, string H_Bank)
{
List<RS_HolidayType> list = new List<RS_HolidayType>();
string comtext = "select * from RS_HolidayType where 1=1";
if (H_HolidayTime != "")
{
comtext += " and H_HolidayTime = '"+H_HolidayTime+"'";
}
if(H_HolidayType!="")
{
comtext += " and H_HolidayType = '"+H_HolidayType+"'";
}
if (H_Bank != "")
{
comtext += " and H_Bank = '"+H_Bank+"'";
} SqlCommand command = new SqlCommand(comtext);
using (SqlDataReader dr = SQLDBHelper.ExecuteReader(SQLDBHelper.ConnectionString, command))
{
while (dr.Read())
{ RS_HolidayType htype = new RS_HolidayType();
htype.H_ID1 = dr.GetInt32(0);
if (dr[1] is System.DBNull)
htype.H_HolidayTime1 = DateTime.Parse("1900-01-01");
else
htype.H_HolidayTime1 = dr.GetDateTime(1);
if (dr[2] is System.DBNull)
htype.H_HolidayType1 = String.Empty;
else
htype.H_HolidayType1 = dr.GetString(2);
if (dr[3] is System.DBNull)
htype.H_Bank1 = String.Empty;
else
htype.H_Bank1 = dr.GetString(3); list.Add(htype); }
}
return list;
}后台:
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
RS_Person_BLL rpb = new RS_Person_BLL();
List<RS_HolidayType> list = rpb.SearchHolidayType (txtHolidayTime.Text,txtHolidayType.Text,txtbank.Text);
if (list.Count > 0)
{
AdjustType_gv.DataSource = list;
AdjustType_gv.DataBind(); } 在选定的数据源上未找到名为“H_ID”的字段或属性。
else
{
Tongyong.ShowError(ChkMessage_Panel, ChkMessage_lb, "你输入的搜索条件不正确!");
AdjustType_gv.Visible = false;
ChkMessage_Cancel_Click(sender, e);
}
}
catch (Exception ex)
{ Tongyong.ShowError(ChkMessage_Panel, ChkMessage_lb, "你输入的搜索条件不正确!");
}
}
public List<RS_HolidayType> SearchHolidayType(string H_HolidayTime, string H_HolidayType, string H_Bank)
{
List<RS_HolidayType> list = new List<RS_HolidayType>();
string comtext = "select * from RS_HolidayType where 1=1";
if (H_HolidayTime != "")
{
comtext += " and H_HolidayTime = '"+H_HolidayTime+"'";
}
if(H_HolidayType!="")
{
comtext += " and H_HolidayType = '"+H_HolidayType+"'";
}
if (H_Bank != "")
{
comtext += " and H_Bank = '"+H_Bank+"'";
} SqlCommand command = new SqlCommand(comtext);
using (SqlDataReader dr = SQLDBHelper.ExecuteReader(SQLDBHelper.ConnectionString, command))
{
while (dr.Read())
{ RS_HolidayType htype = new RS_HolidayType();
htype.H_ID1 = dr.GetInt32(0);
if (dr[1] is System.DBNull)
htype.H_HolidayTime1 = DateTime.Parse("1900-01-01");
else
htype.H_HolidayTime1 = dr.GetDateTime(1);
if (dr[2] is System.DBNull)
htype.H_HolidayType1 = String.Empty;
else
htype.H_HolidayType1 = dr.GetString(2);
if (dr[3] is System.DBNull)
htype.H_Bank1 = String.Empty;
else
htype.H_Bank1 = dr.GetString(3); list.Add(htype); }
}
return list;
}后台:
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
RS_Person_BLL rpb = new RS_Person_BLL();
List<RS_HolidayType> list = rpb.SearchHolidayType (txtHolidayTime.Text,txtHolidayType.Text,txtbank.Text);
if (list.Count > 0)
{
AdjustType_gv.DataSource = list;
AdjustType_gv.DataBind(); } 在选定的数据源上未找到名为“H_ID”的字段或属性。
else
{
Tongyong.ShowError(ChkMessage_Panel, ChkMessage_lb, "你输入的搜索条件不正确!");
AdjustType_gv.Visible = false;
ChkMessage_Cancel_Click(sender, e);
}
}
catch (Exception ex)
{ Tongyong.ShowError(ChkMessage_Panel, ChkMessage_lb, "你输入的搜索条件不正确!");
}
}
应该是H_ID1,而不是H_ID,你少写了一个1
肯定是RS_HolidayType这个实体类里面没有H_ID1这个成员变量或则公开的属性
你调试的时候
AdjustType_gv.DataSource = list; 在这里设置一个断点 ,展开那个list看里面是否有H_ID1