Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rds80
  • Order by date
  1. rds80

    FormsAuthentication.RedirectFromLoginPage question

    Using Visual Studio .NET 2003. If you're asking whether my windows login is a aspnet debugger, then no it isn't. Sorry I'm a newbie.
  2. rds80

    FormsAuthentication.RedirectFromLoginPage question

    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...
  3. rds80

    Display Image

    If you could please share how you did it for us other ASP.NET beginners. Thanks.
  4. rds80

    binding to a datalist using dataset

    Thanks for your help again, Adam.
  5. rds80

    binding to a datalist using dataset

    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...
  6. rds80

    binding to a datalist using dataset

    Got it to work using: <asp:datalist id="DataList1" runat="server" Height="89px" Width="912px" BackColor="#f5f5f5"> <ItemTemplate> <asp:HyperLink id=HyperLink1 runat="server" Height="12px" Font-Size="Smaller" ForeColor="Navy" Width="300px" NavigateUrl='<%#...
  7. rds80

    binding to a datalist using dataset

    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...
  8. rds80

    binding to a datalist using dataset

    Adam, I tried this: <asp:DataList id="DataList1" style="Z-INDEX: 101; LEFT: 360px; POSITION: absolute; TOP: 312px" runat="server" Height="168px" Width="304"> <ItemTemplate> <asp:HyperLink id="HyperLink1" runat="server" Width="160px" NavigateUrl= '<%DataBinder.Eval(Container.DataItem...
  9. rds80

    binding to a datalist using dataset

    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...
  10. rds80

    treeview (newbie)

    so what do you guys do if you need to use a tree view in an asp.net 1.1 web app? thanks.
  11. rds80

    treeview (newbie)

    Does ASP.NET 1.1 not have a treeview? Are there sites that show how to design one using vb code? Thanks.
  12. rds80

    conversion

    tried double, decimal, but the group header isn't calculating the values.
  13. rds80

    conversion

    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...
  14. rds80

    case statement

    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...
  15. rds80

    SELECT nested in UPDATE not working

    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)
  16. rds80

    query help

    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??
  17. rds80

    query help

    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...
  18. rds80

    query help

    still doesn't return anything...
  19. rds80

    query help

    I'll be using a udf...just simplifying the logic for now @ControlIDList is what I'll be passing into the udf
  20. rds80

    query help

    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 + ')

Part and Inventory Search

Back
Top