ASP.NET页面搜索代码

来源:百度知道 编辑:UC知道 时间:2024/05/14 09:01:21
A.aspx代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="A.aspx.cs" Inherits="A" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server" OnTextChanged="TextBox1_TextChanged" Style="z-index: 100;
left: 98px; position: absolute; top: 91px"><

SqlDataAdapter sda = new SqlDataAdapter("select * from cacheeproject where 列名 like valueName", conn); //模糊查找
这句错了 模糊查询应该为
SqlDataAdapter sda = new SqlDataAdapter("select * from cacheeproject where 列名 like %valueName%", conn); //模糊查找

Thank you ! I want to your points.

什么错误你没说...不好查哦。。

string Key = Request.QueryString["Key"]+""; 试试

你把错误粘贴出来。
SqlDataAdapter sda = new SqlDataAdapter("select * from cacheeproject where 列名 like valueName", conn); 这句都有错误,

试下这个:
SqlDataAdapter sda = new SqlDataAdapter("select * from cacheeproject where 列名 like 'valueName', conn);