private void GetArticleCategory(string pid)
{
SqlConnection mySqlConn = new SqlConnection(sqlConn);
string sql = "select id,d_name from dept_name where pid=@pid and del_sign=0 order by pid";
SqlCommand cmd = new SqlCommand(sql, mySqlConn);
SqlParameter Pid = new SqlParameter("@pid", SqlDbType.Int);
Pid.Value = pid;
cmd.Parameters.Add(Pid);
mySqlConn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
this.DropDownList1.Items.Add(new ListItem(toadd + " " + sdr[1].ToString(), sdr[0].ToString()));
toadd += "─┴";
this.GetArticleCategory(sdr[0].ToString());
toadd = toadd.Substring(0, toadd.Length - 2);
}
sdr.Close();
mySqlConn.Close();
}protected void sql_search(string date1,string date2,int s_key)
{
string s_sql;
switch (s_key)
{
case 0:
s_sql = ".....;
break;
case 1:
s_sql = ".....";
break;
default:
s_sql = ".....";
break;
}
SqlConnection msqlconn = new SqlConnection(sqlConn);
SqlCommand mcmd = new SqlCommand(s_sql, msqlconn);
mcmd.Parameters.Add("@date1", SqlDbType.SmallDateTime).Value = DateTime.Parse(date1);
mcmd.Parameters.Add("@date2", SqlDbType.SmallDateTime).Value = DateTime.Parse(date2).AddDays(1).AddSeconds(-1);
msqlconn.Open();
Response.Write(s_sql);
SqlDataReader sdr = mcmd.ExecuteReader();
search_list.DataSource = sdr;
search_list.DataBind();
Export(search_list); }同一个页面里面我使用了这两个不相干的函数,当我在绑定 search_list.DataBind();时老是提示:DataBinding:“System.Data.Common.DataRecordInternal”不包含名为“pid”的属性(明明pid是上一个函数用到的)网上找了下原因,也大概有个了解了,不过不是很清楚,希望大家指点一下,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货