带参数的模糊查询
DataTable dt = SqlHelper.ExecuteDataTable("Select * from T_Warehouse where Material like @Material",new SqlParameter("@Material",string.Format("%{0}%", material));
DataTable dt = SqlHelper.ExecuteDataTable("Select * from T_Warehouse where Material like @Material",new SqlParameter("@Material",string.Format("%{0}%", material));