It works? Hmm.
The names are correct. I usually use lbl____ for a label, and lb____ for a linkbutton. The linkbutton does show up on the page, and I can even change attributes of it, like the text.
A variable that I had not mentioned before is that the user has the ability to add as many of the user controls as they want, and each control contains a link button. so, when the page loads, the first control is loaded...
Casey
Last Activity: Apr 19 '07, 04:08 PM
Joined: Aug 14 '06
Location:
-
Can you create a datareader from the query and loop through it?
Dim x as Integer = 1
Dim dbConnect as your database connection
dim sqlCommand as your query, dbConnect
Dim dtrStuff as Datareader = sqlCommand .ExecuteReader( )
While Not dtrStuff .EOF
if x = 1 then textbox1.text = dtrStuff ("column")
if x = 2 then textbox2 .text= dtrStuff ("column")
if x = 3...Leave a comment:
-
Dynamically Added Linkbutton EventHandler
I’m really hoping someone can help me out on this. I’m adding a user control to a page that has, among other items, a link button. I’m trying to add an event handler to that link button. The control is added just fine, and the link button appears, but when I click on it, nothing happens.
Sub AddControl()
control_count = control_count + 1
Dim new_control As Control = New Control()... -
How to use a variable with a full-text search query
I am really having trouble with a full-text search query. Here's what I've got:
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(l istings, *, 'FormsOf(INFLEC TIONAL, tax')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
When I hard code the value 'tax' into the query, it returns over 500 results. But when I try and do it with a variable,... -
Please! Can nobody help? I am really stuck here!
CaseyLeave a comment:
-
I should be more clear:
DECLARE @SearchWord nvarchar(4000)
SET @SearchWord = 'tax'
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(l istings, *, 'FormsOf(INFLEC TIONAL, @SearchWord')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
This returns no results. But this...
SELECT listing_id, RANK, name, address,...Leave a comment:
-
Using FormsOf(INFLECTIONAL, )
This does not seem to work:
CREATE Procedure getSearchResult s2
(
@search nvarchar(4000)
)
as
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(l istings, *, 'FormsOf(INFLEC TIONAL, @search') b
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
GO
It always treats @search as NULL. What's wrong... -
Multiple Search Criteria using FREETEXTTABLE function
Hi,
How would one allow for possible multiple search criteria using FREETEXTTABLE. For example, my table "listings" has a full-text search catalog, and I may want to:
SELECT * FROM listings WHERE name LIKE @name AND city LIKE @city
I've got it working to select only by name:
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(l istings,...
No activity results to display
Leave a comment: