hi. im trying to make a search engine in vb. the process is when i type a name in the test box, the result will show in an flexgrid. \r\n \r\ni have this code in my text bow \r\n \r\n
\r\n
Code:
\r\n
\r\nwith dataenvironment1\r\nset mshflexgrid1.recordset = .rcommand1\r\nend with
\r\n
the sql statement in my sql builder is \r\n
\r\n
Code:
\r\n
\r\nselect info.* from info\r\nwhere info.name like \' &text1.text& %\'
\r\n
the problem is that it doesnt show the list but if i remove the where statement it shows the whole data. i want to know what is the correct sql ststement and wat is the correct syntax in displaying the result in a flexgrid
hi. im trying to make a search engine in vb. the process is when i type a name in the test box, the result will show in an flexgrid.
i have this code in my text bow
Code:
with dataenvironment1
set mshflexgrid1.recordset = .rcommand1
end with
the sql statement in my sql builder is
Code:
select info.* from info
where info.name like ' &text1.text& %'
the problem is that it doesnt show the list but if i remove the where statement it shows the whole data. i want to know what is the correct sql ststement and wat is the correct syntax in displaying the result in a flexgrid
Last edited by ejbagz; 10-26-2007 at 01:38 AM.
Reason: the code is not right
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET. subscribe
\r\n\r\n\r\n
sql statement using data environment
Threaded Mode
