Question

ASP.net CS0029: 无法将类型“int”隐式转换为“string”

这句是作为sql的查询语句：id为bigint类型，
string query = string.Format("select * from dd where id like '%{0}%' order by id desc",tbx_key.Text）；
该怎么改？
抱歉！完整代码应该是这样！一直出错！
protected void btn_search_Click(object sender, EventArgs e)
{
string query;
if (tbx_key.Text != "")
{
switch (DropDownList1.SelectedItem.Value)
{
case 0: query = string.Format("select * from dd where bianhao like '%{0}%' order by bianhao desc", tbx_key.Text); break;
case 1: query = string.Format("select * from dd where name like '%{0}%' order by bianhao desc", tbx_key.Text); break;
case 2: query = string.Format("select * from dd where huifu like '%{0}%' order by bianhao desc", tbx_key.Text); break;
}

DataSet ds = myset.getds(query);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
else
{

}
}
解决了原来是DropDownList1.SelectedItem.Value要强制转换为int

Answer 1

在数据库中，只有字符串类型才能使用like关键字进行模糊搜索。
如果非要这么用。那就把sql语句写成：
select * from [table] where convert(nvarchar,id) like '%%' order by id desc

希望对你有用

Answer 2

string.Format("select * from dd where bianhao like ('%'+'{0}'+'%') order by bianhao desc", tbx_key.Text); break;
这样试下