是不是 where select * from 表 where textbox.text like '%textbox.text%‘ 因为我每次查询的内容是不同的
select * from 表 where 字段 like '%textbox.text%'
select * from 表 where 字段 like '%textbox.text%'
Private Sub Button_Click() dim adoRS as new ADODB.Recordset dim adoConn as new ADODB.Connection '初始化你的adoConn set adoRS = adoConn.Execute("select * from yourtable where yourcolumn ='" & yourtextbox.text & "'") '对adoRS查询回来的内容进行操作,可以引用adoRS.Fields(n).value '清理ado对象 End Sub
這個是C#的方法我是這樣做。
//根據ID號模糊查詢某表里的記錄,并以DataGrid控件顯示出來 public void ShowData_ForLikeID(string TableName,string ID,DataGrid DataGridID) { string SQLString; DataSet DS=new DataSet(); Conn=new Connection(); Conn.Close(); //注意from后面和where前面要有空格 SQLString="select * from "+TableName+" where cast(ID as varchar) like '%"+ID+"%'"; //ID="1"; //SQLString ="select * from admin where id like '%"+ID+"'"; SqlDataAdapter Dap=new SqlDataAdapter(SQLString,Conn.myConn); Conn.Open(); Dap.Fill(DS,"TableName"); DataGridID.DataSource=DS; DataGridID.DataBind(); }
存儲過程: CREATE PROCEDURE HM_Select_UserEmailDataForID @vUserID varchar(30)='' as --執行動態查詢語句的前綴 declare @vSQLString varchar(100) --要執行的動態語句 declare @vExecSQLString varchar(200) select @vSQLString=' select UserName,Email from EmailList ', @vExecSQLString='' set @vSQLString=@vSQLString+'where UserID like ''%'+ltrim(@vUserID)+'%''' exec(@vExecSQLString) go
select * from 表 where 你要查询的字段 like 'textbox中的关键字%' 这样可以用索引,速度会快些!
因为我每次查询的内容是不同的
dim adoRS as new ADODB.Recordset
dim adoConn as new ADODB.Connection '初始化你的adoConn set adoRS = adoConn.Execute("select * from yourtable where yourcolumn ='" & yourtextbox.text & "'") '对adoRS查询回来的内容进行操作,可以引用adoRS.Fields(n).value '清理ado对象
End Sub
//根據ID號模糊查詢某表里的記錄,并以DataGrid控件顯示出來
public void ShowData_ForLikeID(string TableName,string ID,DataGrid DataGridID)
{
string SQLString;
DataSet DS=new DataSet();
Conn=new Connection();
Conn.Close();
//注意from后面和where前面要有空格
SQLString="select * from "+TableName+" where
cast(ID as varchar) like '%"+ID+"%'";
//ID="1";
//SQLString ="select * from admin where id like '%"+ID+"'";
SqlDataAdapter Dap=new SqlDataAdapter(SQLString,Conn.myConn);
Conn.Open();
Dap.Fill(DS,"TableName");
DataGridID.DataSource=DS;
DataGridID.DataBind();
}
CREATE PROCEDURE HM_Select_UserEmailDataForID
@vUserID varchar(30)=''
as
--執行動態查詢語句的前綴
declare @vSQLString varchar(100)
--要執行的動態語句
declare @vExecSQLString varchar(200)
select @vSQLString=' select UserName,Email from EmailList ', @vExecSQLString=''
set @vSQLString=@vSQLString+'where UserID like ''%'+ltrim(@vUserID)+'%'''
exec(@vExecSQLString)
go