DropDownList文章检索的问题

[wangliang8229780]

先贴代码

UI层:

protected void Page_Load(object sender, EventArgs e)
    {
        BindTypeData();//绑定分类
    }

//绑定分类
protected void BindTypeData()
    {
        DataSet ds = new NewsTypeBLL().GetClassList(0); //获取所有分类信息

        this.dropDownNewsType.DataSource = ds.Tables[0].DefaultView;
        this.dropDownNewsType.DataBind();

        this.dropDownNewsType.Items.Clear();
        this.dropDownNewsType.Items.Add(new ListItem("按分类查询", "0"));
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            int ClassTj = Convert.ToInt32(dr["ClassTj"]);
            string ClassId = dr["ClassId"].ToString().Trim(); //绑定分类ID
            string ClassName = dr["ClassName"].ToString().Trim(); //绑定分类名称

            if (ClassTj == 1)
            {
                this.dropDownNewsType.Items.Add(new ListItem(ClassName, ClassId));

            }
            else
            {
                ClassName = "├ " + ClassName;
                ClassName = StringHelper.StringOfChar(ClassTj - 1, "　") + ClassName;

                this.dropDownNewsType.Items.Add(new ListItem(ClassName, ClassId));
            }
        }
    }

//查询按钮事件
protected void btnSearch_Click(object sender, EventArgs e)
    {
        string TypeId = dropDownNewsType.SelectedValue;

        CompanyArticleRepeaterList.DataSource = articleBLL.SearchNews(TypeId);
        CompanyArticleRepeaterList.DataBind();
    }

//业务逻辑层省略
.
.
.

//数据访问层
public DataSet SearchNews(string NewsTitle,string TypeId,int IsCmd)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * from Article where 1=1");

            if (TypeId != "0")
            {
                strSql.Append(" and TypeId = '" + TypeId + "'");
            }

            return GetDataset(CommandType.Text, strSql.ToString()); //执行SQL,返回结果
        }

问题:查询时无法返回任何结果,也没有错误提示.很是崩溃~~期盼高手相助~感谢!

[takako_mu]

這個斷點跟蹤問題就出來了。
另外Page_Load里加上if(!IsPostBack).

[中年秃头大叔]

首先在
protected void Page_Load(object sender, EventArgs e)
{
if(!this.IsPostBack)
{
BindTypeData();//绑定分类
}
}

还有函数 void BindTypeData()里面的
this.dropDownNewsType.DataSource = ds.Tables[0].DefaultView;
this.dropDownNewsType.DataBind();根本就不用要.

button事件里面的.string TypeId = dropDownNewsType.SelectedValue;
换成string TypeId = dropDownNewsType.SelectedItem.Text;

试试看.

[chen_ya_ping]

step by step Debug

[hou881011]

学习。。