If I put a breakpoint on this line of code:
If iResult = Framework.ErrState.S_OK Then
Session.Add("UserInfo", tdsUserInfo)
FormsAuthentication.RedirectFromLoginPage(tdsUserInfo.UserInfo(0).UserName, False)
Else
lblMessage.Text = sErrorMsg
End If
and then run the project it goes to...
How do I access the selected hyperlink that the user clicks from the datalist?
The suggested way to find out the Selected Index is:
dlstAuthors.SelectedIndex = e.Item.ItemIndex
but I read that only works with Button, LinkButton, and ImageButton.
What I need to do is check whether the...
Q1. are you binding the datalist?
A1. The datalist is being bound in the vb code behind. the vb code is above.
Q2. do you have data in your query when run?
a2. Yes, have data in the query.
q3. Does your query have the column names specified in the DataBinder html?
a3. Yup the sql query field...
On report.aspx, there is a dataset (tdsReportRetrieval), which has a table (tableReportRetrieval) that has a column (DisplayName) that I need to bind to a DataList (Sounds like that elementary song).
My questions are:
1) DisplayName is a field that shows the report names and a user can click on...
If I'm passing a varchar field from my stored procedure, but that field needs to be summed in the groupfooter field what type do I need to convert it in the vb backend?
Right now I'm getting 0 in the groupfooter field because it cannot add the values from the detail section as they are type...
I realized a bit late that the code below doesn't work. If there is an assistant manager, but no manager I still get a blank and that is incorrect.
COALESCE(dbo.udfGetManager(CM.ControlID) + ', ' + dbo.udfGetAssistantManager(CM.ControlID), '')
So this is the replacement code:
CASE WHEN...
Is this the same
UPDATE A
SET A.ClientID =
(SELECT SF.ClientID
FROM SF_Clients SF
Inner Join EventSpare ES
on SF.ClientName = ES.ClientName
INNER JOIN Assignments A
ON ES.AssignmentNumber = A.AssignmentNumber)
Thanks Michael and George..
George - your last post is exactly what I was looking for.
Michael - I should've tried your query out.
Is this what the WHERE clause is doing:
WHERE ,Z,Y, LIKE %,A,B,C,D,Z,Y,%'
and then it selects the values WHERE it is just Z,Y?
How did you guys know this??
Sorry doesn't seem that my question is clear..
SELECT @ControlIDList = '''Z'', ''Y'''
will not only be Z and Y. What I'll eventually have is @ControlIDList as a parameter to the function. So the value for @ControlIDList can change and for that reason I cannot have Where ControlID = 'Y' or...
1 Table - TestTable
I want to select all the fields where controlid is in 'Z' and 'Y'. Sorry I forgot the IN
DECLARE @ControlIDList nvarchar(4000)
SELECT @ControlIDList = '''Z'', ''Y'''
PRINT @ControlIDList
SELECT *
FROM TestTable
WHERE ControlID IN (' + @ControlIDList + ')
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.