110,535
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = new DataTable();
DataColumn col1 = new DataColumn("id", typeof(string));
DataColumn col2 = new DataColumn("name", typeof(string));
dt.Columns.Add(col1);
dt.Columns.Add(col2);
DataRow row1 = dt.NewRow();
row1["id"] = "0001";
row1["name"] = "aaa";
dt.Rows.Add(row1);
DataRow row2 = dt.NewRow();
row2["id"] = "0002";
row2["name"] = "bbb";
dt.Rows.Add(row2);
string name = "b";
Response.Write(dt.Select("name like'%" + name + "'", "")[0]["name"].ToString());
create table #(s varchar(50))
insert into # select 'abc'
declare @name varchar(50)
set @name='c'
exec('
select * from #
where s like''%'+ @name +'%''')