Recent content by toon10

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…...

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.

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

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 =...

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

Thank you very much. That looks great!

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

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

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

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

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

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

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!

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

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