绑定了一个DropDownList,其中一个为查询条件,绑定的值为like,显示文字为‘包含’,怎么在调用的时候这个DropDownList.Text却成了like...?我在界面上看到的明明也是‘包含’。高手看看这是怎么回事。。? private void getSechose()
{
try
{
if (scn.State == ConnectionState.Closed)
{
scn.Open();
}
DataTable dt = new DataTable();
dt = acc.GetSereachData("select * from ItItem_sefiled WHERE SeFileTable='ConditionA' and SeFileClass='Condition' and IsSelect=1 Order by SeOrderID");
Ddcondition.DataSource = dt;
Ddcondition.DataValueField = "SeFileID";
Ddcondition.DataTextField = "SeFileName";
Ddcondition.DataBind();
}
catch (Exception ex)
{
throw(ex);
}
finally
{
scn.Close();
}
}
protected void bingdgv()
{
try
{
if (txtSeValue.Text.Trim().ToString() == "")
{
return;
}
else
{
SqlScmstr = "";
if (scn.State == ConnectionState.Closed)
{
getscnstr();
scn.Open();
}
if (Ddcondition.Text.Trim() == "包含")
{
SqlScmstr = "SELECT * FROM ITItem_ComputerInfo WHERE " + DdSeFile.SelectedValue + Ddcondition.SelectedValue + "'%" + txtSeValue.Text.Trim() + "'%";
}
else
{ SqlScmstr = "SELECT * FROM ITItem_ComputerInfo WHERE " + DdSeFile.SelectedValue + Ddcondition.SelectedValue + "'" + txtSeValue.Text.Trim() + "'"; }
DataTable dt = new DataTable();
dt = acc.GetSereachData(SqlScmstr);
dtTableHade = dt;
if (dt.Rows.Count > 0)
{
gvPCInfo.AllowPaging = true;
gvPCInfo.AllowSorting = true;
gvPCInfo.PageSize = 4;
gvPCInfo.DataSource = dtTableHade;
gvPCInfo.DataBind();
}
else
{
gvPCInfo.Dispose();
}
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (scn.State == ConnectionState.Open)
scn.Close();
}
}
{
try
{
if (scn.State == ConnectionState.Closed)
{
scn.Open();
}
DataTable dt = new DataTable();
dt = acc.GetSereachData("select * from ItItem_sefiled WHERE SeFileTable='ConditionA' and SeFileClass='Condition' and IsSelect=1 Order by SeOrderID");
Ddcondition.DataSource = dt;
Ddcondition.DataValueField = "SeFileID";
Ddcondition.DataTextField = "SeFileName";
Ddcondition.DataBind();
}
catch (Exception ex)
{
throw(ex);
}
finally
{
scn.Close();
}
}
protected void bingdgv()
{
try
{
if (txtSeValue.Text.Trim().ToString() == "")
{
return;
}
else
{
SqlScmstr = "";
if (scn.State == ConnectionState.Closed)
{
getscnstr();
scn.Open();
}
if (Ddcondition.Text.Trim() == "包含")
{
SqlScmstr = "SELECT * FROM ITItem_ComputerInfo WHERE " + DdSeFile.SelectedValue + Ddcondition.SelectedValue + "'%" + txtSeValue.Text.Trim() + "'%";
}
else
{ SqlScmstr = "SELECT * FROM ITItem_ComputerInfo WHERE " + DdSeFile.SelectedValue + Ddcondition.SelectedValue + "'" + txtSeValue.Text.Trim() + "'"; }
DataTable dt = new DataTable();
dt = acc.GetSereachData(SqlScmstr);
dtTableHade = dt;
if (dt.Rows.Count > 0)
{
gvPCInfo.AllowPaging = true;
gvPCInfo.AllowSorting = true;
gvPCInfo.PageSize = 4;
gvPCInfo.DataSource = dtTableHade;
gvPCInfo.DataBind();
}
else
{
gvPCInfo.Dispose();
}
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (scn.State == ConnectionState.Open)
scn.Close();
}
}
解决方案 »
- 如果两个表结构相似,要不要合成一个表?谢谢。在线等结贴。
- 急,在线等!
- 关于HttpRequest对象的一个问题
- sql server在xp sp2中无法被.net程序访问!报错说没有sql服务器,或者访问被拒绝!
- 如何解压有密码的zip文件,有什么好的Zip控件都拿出来分享一下
- DataSet不重复显示数据
- asp.net 做文件上传,总是提示 访问被拒绝
- 为什么我的分页不行的呀,前五页行的,后面的就点不下去了.这是怎么回事呀,请o0O.net进来看一下
- 简单的treeview问题
- 怎样锁定一条记录
- js绑定GridView
- web.sitemap 文件的问题求解..................................
应该是Dbcondition.SelectedText,获取的是你选择的text
你这个dropdownlist的命名规范,不是很推荐
{
}