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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by toon10

  1. toon10

    Access denied to folder using impersonation on IIS 6

    I’m using impersonation on my web application in order to identify who is currently logged onto the client. For example “John Smith”. This side of things works fine as the web page lists the name and email address of whoever is logged onto the machine. My web.config file contains…...
  2. toon10

    getting 1 line from inner join returning 4 lines

    That's great. Thanks for your quick and accurate help! Much appreciated. I had thought of using SUM but I had my syntax a little confused and i didn't work. Your solution works great.
  3. toon10

    getting 1 line from inner join returning 4 lines

    Hi I’m using this SQL query in 2005. USE [MIS] SELECT DasCompQty, DarQty, DarRWC, DasFlnRate / 60 * DarRwTime * DarQty AS FaultCost FROM dbo.AssemblyOperation AS [AO] INNER JOIN dbo.[Assembly] AS [A] ON AO.AopAssNo = A.AssPartNo INNER JOIN dbo.ListFlowline AS [LF] ON A.AssFlnId = LF.FlnId...
  4. toon10

    Alternative "smarter" datagrid control

    I have found this on the Internet which seems to work well for autosizing if case anyone else wants to do this. Public Sub AutoFitColumns() On Error Resume Next Dim C As Column, K As Integer, L As Single, Text As String For Each C In DGresults.Columns 'autofit datagrid columns L =...
  5. toon10

    Alternative "smarter" datagrid control

    Hi I’m using a treeview control which lists staff members from my database. On the node_click event, I’m populating a datagrid with training record information from a table based on the staff member selected from the treeview. I’m using ADO code to populate a recordset and then setting the...
  6. toon10

    comparing 2 recordsets to make a 3rd

    Thank you very much. That looks great!
  7. toon10

    comparing 2 recordsets to make a 3rd

    Thanks for the response. I've tried this before posting and the problem is that this doesn't return a list of staff members who have not done training on this course. It produces a list of all courses that staff members have done (excluding the selected course) For example, if Frank Spencer...
  8. toon10

    comparing 2 recordsets to make a 3rd

    If you can write a query that would achieve this, I'd be happy to see it.
  9. toon10

    comparing 2 recordsets to make a 3rd

    Hi I was wondering what the logic to use for comparing 2 recordsets. I have a RSCourseAttendedByStaff recordset (which is a list of staff members who have done a specific training course) My other recordset, RSAllStaff, is a full list of staff members. I want to compare the two and find out...
  10. toon10

    inserting the results of a datatable into a database table

    Thanks for the help. I'll give that a try!
  11. toon10

    Parameter Help

    Here's an example of a TableAdapter I use. Try Me.DailyAssOppRwkTableAdapter.Fill(Me.DataSetDailyAssRwk.DailyAssOppRwk, CurAssPartNo, CurAssOppNo, CurDate) Catch ex As System.Exception MsgBox("Daily Rework Data Error" + vbCrLf + ex.Message, MsgBoxStyle.Exclamation, "DATA...
  12. toon10

    inserting the results of a datatable into a database table

    Hi I have a datatable which I want to write to a table in my database. Dim varSQL As String varSQL = ("SELECT * FROM [tblCost] WHERE [Part Number] = '" & txtPartNumber.Text & "' ORDER BY [Part Number]") Try Dim AccessCommandPartRetrieve As New...
  13. toon10

    binding datagrid to access table

    Indeed you are correct. I made the school boy error of not using single quotes for my Part Numbers which are of type text. Thanks for the help, it's appreciated!
  14. toon10

    binding datagrid to access table

    Actually, it throws the error out at the AccessCommandPartNoRetrieve.Fill(dt) line.
  15. toon10

    binding datagrid to access table

    Hi Thanks for the reply. What you say makes sense. I'm rather new to .NET! I'm still getting the same error of a data type mismatch on bindingSource1.DataSource = dt. I'll look on msdn for creating DataTable's. Thanks
See more

Part and Inventory Search

Back
Top