Monitor SQL activity through .net

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Framework
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Can you redirect framework with config file to an assembly? Here's a catcher for all ya'll I have a 3rd party .Net assembly which is compiled against .Net framework 1.1 and is compatible with v1.0. However, there is not a way to specify to use 1.0, unless I recompile it against v1.0 I have only .Net framework 1.0 installed. I have an assembly that references the 3rd party .Net assembly. I know from MSDN and other postings that a config file can be used with only .exe and web apps to redirect/rebind which .Net framework to use. This gets propogated down to the referenced assemblies too. Is there a way to have my assembly (.dll) to do the exact same behaviour? Utilize the .net framework v1.0 and propogate that down to all the referenced assemblies? Including my 3rd party referenced assembly which compiled against 1.1. Upgrading to v1.1 Framework will not work becuase of the # of projects using the v1.0 framework. If I upgrade then they all have to upgrade, and then the servers have to be upgraded, test, and the list goes on and on. I heard of pilicy files in the GAC, but am not quite sure how signing my assembly and putting that into the GAC will propogate down to any of the referenced assemblies to use the v1.0 framework. Any ideas? Mike Tag: Monitor SQL activity through .net Tag: 65079
  - 2
    - Should not be required to release managed resources A while ago I noticed an issue with .NET that just stung me yet again today. I had an object that I wanted to be garbage collected but it registered itself for several events of external objects which entails giving those objects a delegate that contains a reference to the event consuming object. The solution I have seen in Microsoft samples is to unregistered for the events in the Dispose method. Unfortunately, this creates a situation where manual memory management for these objects is a requirement. Dispose must be called or they will never be garbage collected. Garbage collection is supposed to eliminate much of the need for memory management, but it is not perfect and this is one of the cases where it fails miserably and quite often. I came up with a half-solution. I call it the WeakDelegate and it works well, but in order for its potential to be truly realized it would need framework level adoption. The concept is that it is a special kind of delegate that maintains a weak reference instead of a strong one. Then you simply unregistered for the events in a Dispose method and call the Dispose method from the finalizer. Worst case is that the overhead of a finalizer is called. Maybe in future versions of .NET, delegates defined as: delegate returnType DelegateName(parameterList); will really define an abstract class derived from Delegate (or MulticastDelegate or whatever) as well as two dirivatives of DelegateName being WeakDelegateName and StrongDelegateName. Generics may help. I would love to hear feedback, expecially from a Microsoft rep, with regards to this idea. Also, I dug up a prototype from my archives from when I was first learning C#: using System; using System.Reflection; using System.Collections; namespace BDB { /// <summary>Delegate that will not prevent garbage collection</summary> /// <remarks>Static Members not supported: /// Use instance wrapper methods if this functionality is required. /// /// Invoke method called on collected objects or missing methods will fail silently.</remarks> public class WeakDelegate { /// <summary>Construct a WeakDelegate</summary> /// <param name="d">"Strong" Delegate to copy from</param> public WeakDelegate(Delegate d) { referance = new WeakReference(d.Target); methodName = d.Method.Name; } /// <summary>Construct a WeakDelegate</summary> /// <param name="o">Object to invoke method on</param> /// <param name="m">Method to invoke</param> public WeakDelegate(object obj, string methodName) { this.referance = new System.WeakReference(obj); this.methodName = methodName; } /// <summary>Call the method referanced by this WeakDelegate</summary> /// <param name="args">Arguments to pass called method</param> /// <returns>Results of method call</returns> public object Invoke(object[] args) { MethodInfo m = referance.Target.GetType().GetMethod(methodName, BindingFlags.Instance|BindingFlags.Public|BindingFlags.NonPublic); return (m==null? null : m.Invoke(referance.Target, args)); } /// <summary>Determins if the object to invoke the method on is alive</summary> public bool IsAlive { get { return referance.IsAlive; } } /// <summary>Compare WeakDelegates for equality</summary> /// <param name="obj">Compare this to "obj"</param> /// <returns>True if WeakDelegates are equivialent</returns> public override bool Equals(object obj) { if(obj == null || GetType() != obj.GetType()) return false; WeakDelegate d = (WeakDelegate)obj; return ((this.referance.Target == d.referance.Target) && (this.methodName == d.methodName)); } /// <summary>Get the hash code of this WeakReferance</summary> /// <returns>Hash code</returns> public override int GetHashCode() { return methodName.GetHashCode() + referance.Target.GetHashCode(); } private string methodName; private WeakReference referance; } /// <summary>Multicast Delegate which does not prevent garbage collection</summary> public class WeakMulticastDelegate { /// <summary>Call all methods referanced by this WeakMulticastDelegate. /// Also removes any delegates that point to dead objects</summary> /// <param name="args">Arguments to pass all invoked methods</param> public void InvokeAll(object[] args) { WeakDelegate current; for(int i = 0; i < delegates.Count; i++) { current = delegates[i] as WeakDelegate; if(current.IsAlive) current.Invoke(args); else { delegates.RemoveAt(i); i--; } } } /// <summary>Add a WeakDelegate to the invokation list</summary> /// <param name="d">WeakDelegate to add</param> public void AddDelegate(WeakDelegate d) { delegates.Add(d); } /// <summary>Remove a WeakDelegate from the invokation list</summary> /// <param name="d">WeakDelegate to remove</param> public void RemoveDelegate(WeakDelegate d) { delegates.Remove(d); } private ArrayList delegates = new ArrayList(); } } Tag: Monitor SQL activity through .net Tag: 65078
  - 3
    - .net & exchange server I am looking for recommendations for the best method to connect to exchange 2000 and read through a particular object's messages, for example to return all of the appointments in a public calendar. Thanks. Tag: Monitor SQL activity through .net Tag: 65076
  - 4
    - Get Dhcp Server List I am trying to get the list of DHCP servers directly from AD but I can not find anything on how to do it. Can anyone here point me in the right direction or provide an example please. Jason Tag: Monitor SQL activity through .net Tag: 65075
  - 5
    - FxCop on debug or release build? Does it matter whether I run FxCop on the Debug or the Release build? Thanks. Tag: Monitor SQL activity through .net Tag: 65072
  - 6
    - Accessing Data Hi Friends, Is there a way to access data from a website that displays its data from a database. For example if i visit http://www.barnesandnoble.com, and if i search for a book on VB.Net, then i would like to access the results of this search programatically. I am trying to access data which is stored in their database. Now i can access this data by reading the webpage which contains the search result. OR If "Barnes And Noble" has created a Web Service, which provides me the access to their database. OR If i have direct access to their database. Are these the only options available to me, to access this data. Is there any other way i can get access to this data? I will be very thankful if you could please provide me any insight on this. Any help/guidance will be greatly appreciated. Thanks and Regards, Mohan Tag: Monitor SQL activity through .net Tag: 65070
  - 7
    - DllNotFoundException Hi, I have created a ASP .net client talking to a .net web service. The web service in turn calls a C++ dll to get data from the host. The whole thing is working perfectly fine on my machine, but when I am deploying the components on a Window 2000 server, running the application is throwing this error: System.DllNotFoundException: Unable to load DLL (my.dll) I have tried putting the dll in the system and system32 folders, - also I tried using the whole path of the dll in DLL Import function. None of these worked. Could someone please help me? Thanks! DC Tag: Monitor SQL activity through .net Tag: 65069
  - 8
    - HttpWebRequest ReadToEnd and Timeout Problems... Heya, I've found while using HttpWebRequest that when the TCP and/or ActiveSync connection is interrupted (read: remove device from cradle or internet connection drops) the ReadToEnd operation hangs and the Timeout property on the HttpWebRequest does not appear to cause a timeout as one would expect. Do I need to create my own Timer to Abort the HttpWebRequest in case this occurs? Is there a better way to handle this? ~~K Tag: Monitor SQL activity through .net Tag: 65066
  - 9
    - I need to do physocal disk reads I want to do something like where: m_Device(_T(\\\\.\\PHYSICALDRIVE1) to read drive 1 I then want to read the physical device till the end and save it in a disk file. Does anyone have an example of doing this in c#. Below are the pertinate lines from c++. The framework does not appear to support physical access. DeviceHandle = CreateFile(m_Device, GENERIC_READ,FILE_SHARE_READ, NULL, OPEN_EXISTING, FILE_FLAG_NO_BUFFERING, NULL); then in a loop rc = ReadFile(DeviceHandle, buffer, sizeof(buffer), &BytesRead, NULL); __ Jim Tag: Monitor SQL activity through .net Tag: 65064
  - 10
    - Crystal Reports - with parms - .Export error Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool, or in the code) works fine. However, when I try to add any parameter through the record selection formula and/or the report parameters method, the report crashes. I have tried each of the methods: 1. Use the Record Selection Formula property: crReportDocument.DataDefinition.RecordSelectionFormula = "{qryTest.ID} = 54" 2. Use the Crystal Parameters collection(s) crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item ("[@TestID]") crParameterValues = crParameterFieldDefinition.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue() crParameterDiscreteValue.Value = 54 crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) Both of the methods above work fine on my development machine but the testing server gives these errors. I also set the record selection formula in the report to automatically set the TestID parameter = 54 and then tested that report on the testing server and everything worked. So the issue seems to be with populating the crystal report's parameters at runtime. The error that comes back with a logon failure at the .Export line. I have tried two methods to logon to the reports: #################### Basic: With tliTableLogonInfo.ConnectionInfo .ServerName = m_strDSNName .DatabaseName = m_strDatabase .UserID = m_strUserId .Password = m_strPassword End With 'setup each connection in the report For Each tTable In crReportDocument.Database.Tables tTable.ApplyLogOnInfo(tliTableLogonInfo) Next tTable #################### and Complex (loops through sub-reports): Dim mySection As Section Dim mySections As Sections Dim myReportObject As ReportObject Dim myReportObjects As ReportObjects Dim mySubReportObject As SubreportObject Dim mySubRepDoc As New ReportDocument() 'Declare all of the sections of the main report mySections = crReportDocument.ReportDefinition.Sections 'Loop through the sections in the main report to find the subreport objects 'then set the logon information to the subreport Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo For Each mySection In mySections myReportObjects = mySection.ReportObjects For Each myReportObject In myReportObjects If myReportObject.Kind = ReportObjectKind.SubreportObject Then 'Subreport Found - convert the report object to a sub report type mySubReportObject = CType(myReportObject, SubreportObject) 'Set the specific instance of this subreport mySubRepDoc = mySubReportObject.OpenSubreport (mySubReportObject.SubreportName) 'Set the login information for the current subreport(found) For Each crTable In mySubRepDoc.Database.Tables myLogin = crTable.LogOnInfo myLogin.ConnectionInfo.ServerName = m_strDSNName myLogin.ConnectionInfo.DatabaseName = m_strDatabase myLogin.ConnectionInfo.UserID = m_strUserId myLogin.ConnectionInfo.Password = m_strPassword crTable.ApplyLogOnInfo(myLogin) Next End If Next Next #################### Does anyone know of other methods to filter a report at runtime? Or is there a Crystal DLL that I need to move from my dev machine to the server to allow for the record selection properties to be set at runtime? OR ANY OTHER INFO WOULD BE GREAT!!! Thanks, TJ Tag: Monitor SQL activity through .net Tag: 65060
  - 11
    - just in time debugger is there a way to keep a C++ .exe built in .net 1.1 from bringing up the just in time debugger? i don't want this. during normal running, we want the application to just die on a crash. what happens is the just in time comes up on the server and it just sits there with the app in a hung state. we have another process running that if any .exe "disappears", it restarts it. when JIT comes up, it doesn't disappear and the server just sits there dead. of course we need to find what is causing this, but when running in production state, we need jit to be disabled. how can this be done? thanks. Tag: Monitor SQL activity through .net Tag: 65059
  - 12
    - C# Training Videos Currently our C# Videos are free. Check them out at: http://www.vtmag.com P.S. After viewing the videos go back to the website and rate them or send an email to let us know how we are doing! Thanks, Wade Beasley *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Monitor SQL activity through .net Tag: 65055
  - 13
    - Problems with enum Documentation (NDoc Problem?) No "Description" in resulting HTML File using NDOC (Version 1.2.1303.41457). From the Framework side I think I am doing everything correctly, because the resulting XML has the coments. Is this a known NDoc problem? Is there a NDoc newsgroup? C# : public enum Back { /// Crosshatch/CROSSHATCH (0) - CardsDll (53) Crosshatch, ... } resulting XML : <member name="F:mj10777_Cards.Back.Crosshatch"> Crosshatch/CROSSHATCH (0) - CardsDll (53) </member> Mark Johnson, Berlin Germany mj10777@mj10777.de Tag: Monitor SQL activity through .net Tag: 65052
  - 14
    - wierd problem happening when debugging and AppDomain.UnhandledException event is handled I can't explain why this is happening but here goes I have a class library being called by a Windows forms app [all VB.Net], option strict is ON before the Application.Run(new frmMain), I call AddHandler AppDomain.CurrentDomain.UnhandledException, addressof AppDomain_UnhandledException theres a call into the class library, several calls down the line is a P/invoke to a 3rd party DLL when I step INTO the function it all works if I step over/run the function the process immediately terminates... no warnings, no errors displayed in VS.Net's output anybody got any ideas? i bet this is gonna be a tough one -- Eric Newton C#/ASP Application Developer http://ensoft-software.com/ eric@cc.ensoft-software.com [remove the first "CC."] Tag: Monitor SQL activity through .net Tag: 65044
  - 15
    - Asp.net project Hi, I have Visual Studio.net installed successfully on my new XP system. I wanted to create a Visual C# project using Asp.net Web Application template. I select the template and enter OK. I have new POPup Message "Create New Web" and it displays the message for 30 - 45 mins and fails. Creating the Web "http://localhost/testWebapplication1". I appreciate if any one help me out. Thanks in advance, Tag: Monitor SQL activity through .net Tag: 65043
  - 16
    - Uninstalling a NT Service programmatically Hi NG, I'm writing a management tool for our software, that among other should be able to install and uninstall some of our NT services. The problem is that when I uninstall the services (using ManagedInstallerClass.InstallHelper with the "/u" parameter) the services are uninstalled, but they are still running until I close my management application. This is a problem since I want to remove the service assemblies as a part of the uninstallation. I read the Knowledge Base-article 287516 (http://support.microsoft.com/default.aspx?scid=kb;en-us;287516), which seems to be addressing my problem. It claims that all handles to the services needs to be closed before the service can be uninstalled. Thats fair enough, but eventhough all my ServiceControllers are Close()'d and Dispose()'d the problem persists. Is there a way to release all handles to a service allowing it to be uninstalled at once? Or is there another way to do this? Thanks for your time, Ricky Tag: Monitor SQL activity through .net Tag: 65037
  - 17
    - Enumerating windows from an NT service Hi all, The service I have written can not enumerate the current user's desktop windows when running as a service. I read where one solution to this is to install the service with "SystemAccount" rights and "Allow service to interact with desktop" but I know it leaves the system vulnerable to maliciousness. Is there a way to programmatically enumerate through the current desktop windows when running as a service? Also, How I can know the name of the user when he logged? Thanks in advance Tag: Monitor SQL activity through .net Tag: 65035
  - 18
    - AxWebBrowser control BeforeNavigate2 event does not fire This is a multi-part message in MIME format. ------=_NextPart_000_0070_01C3C474.C151CD80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;325079 tried the proposed solution and provided alternate methods to capture = the event, still doesn't fire. Anyway to fix this? Erez ------=_NextPart_000_0070_01C3C474.C151CD80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2><A=20 href=3D"http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;325079"= >http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;325079</A></FO= NT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>tried the proposed solution and = provided alternate=20 methods to capture the event, still doesn't fire.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Anyway to fix this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Erez</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0070_01C3C474.C151CD80-- Tag: Monitor SQL activity through .net Tag: 65033
  - 19
    - .Net Framework SDK Licence Agreement and OpenSource I am looking to start an Open Source project using C# but the requirements of the project require that the project must be written in a language that has freely available compilers. I am correct in think that the .Net Framework SDK is a free download from Microsoft and could be used for such an Open Source project with these requirements? I have tried finding an End User License agreement for the SDK without success. Can someone provide me with a URL to such an agreement so that I can provide this to the administrators of the Open Source project to satisfy their concerns. Thanks in Advance Heath Tag: Monitor SQL activity through .net Tag: 65031
  - 20
    - activex textbox vs windows forms textbox I'm porting an MS Access application to a .NET windows forms application. For several forms I need to use textboxes which support input masks and whose border color I can change, neither of which seem native to .NET. Is the addition of activex controls my only solution. So far, I've only found Microsoft's masked edit control (V6) which supports the input mask, but doesn't give me any control over the border color. Does anyone know if there are any better activex textboxes out there which fit the bill, or if there is a native dotnet solution that I'm missing and I could implement? Ta Tag: Monitor SQL activity through .net Tag: 65030
  - 21
    - clearing back history in IE Hi all! Can anyone tell me how do I clear the history in Internet Explorer's Back button, so that when the app gets redirected to a certain form the user won't get the possibility of getting back to the previous one using the back button... In particular, I have a login form, and after the user logs in, I don't want the user to get back there unless he/she logs out Thanks ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Monitor SQL activity through .net Tag: 65028
  - 22
    - { in a string.Format How do you escape a { in a format string for string.Format? I want to have a format string that builds code, something like "static void {0}() { {1} }". I know there are other solutions like building the {1} with the brackets. Tom Tag: Monitor SQL activity through .net Tag: 65020
  - 23
    - GetObject in .NET c# Dear All, I have to move my VB code to C#. But I have no idea on the GetObject method in Vb. ----------------------------------------- Set dom = GetObject("WinNT://" & domain) ----------------------------------------- This is easy for VB to get the object by COM monikor interface. However, what I use the following code to active a object via monikor in c#, what I got is a OBJECT Type. ---------------------------------------------- Marshal.BindToMoniker("WinNT://" + strDomain); //c# code ---------------------------------------------- Is there any way for me to KNOW the returned object type and case it to the right type in .net??? Thanks very much! -yy Tag: Monitor SQL activity through .net Tag: 65018
  - 24
    - ebXML I just want to find out about ebXML and if microsoft does use or support this standards, also find out if the ebXML has a seperate editor for the code or is it similar to the XML editor. Tag: Monitor SQL activity through .net Tag: 65017
  - 25
    - Configurable print formats. Hi; We have a requirement in our application wherein all the TEXT in the application especially the print formats for the documents and reports are configurable files that would be part of the software packaging. In other words, these formats can be changed, but the software need not be re-loaded. We will just need to download the latest formats on the handheld. I would appreciate any pointers on how to go about doing this. Thanks and Kind Regards; Ajit Goel Tag: Monitor SQL activity through .net Tag: 65014
- Next
  - 1
    - HttpWebResponse can't handle duplicate header Hi, HttpWebResponse will just display the last value of those same name http header. Ex. Aheader: a value Bheader: b value Cheader: c value 1 Cheader: c value 2 Cheader: c value 3 Dheader: d value Retrieving the Cheader value by the headers property of httpwebresponse will only return the "c value 3". Is there any workaround? Thanks MrJun Tag: Monitor SQL activity through .net Tag: 65012
  - 2
    - How to detect files copying Hi, I mean: I would like that my software has capacity to detect files-copying process into my harddisk (it is the same Norton Antivirus detects what files are copying and do stop that copying process). So, my software can prevent process of copying(installing) of somefiles. My question is how can I know that process (where is it copy from?, What is its name? ...) I attempted to use FileSystemWatcher() but I couldnot know where files come from. What I need is prevent copying from somefiles (they come from Floppies, CDROM) so I must know where those files come from. Please help me as soon as possible. It is urgent for me. Thank you. Tag: Monitor SQL activity through .net Tag: 65010
  - 3
    - How to detect files - copying... Hi, I mean: I would like that my software has capacity to detect files-copying process into my harddisk (it is the same Norton Antivirus detects what files are copying and do stop that copying process). So, my software can prevent process of copying(installing) of somefiles. My question is how can I know that process (where is it copy from?, What is its name? ...) I attempted to use FileSystemWatcher() but I couldnot know where files come from. What I need is prevent copying from somefiles (they come from Floppies, CDROM) so I must know where those files come from. Please help me as soon as possible. It is urgent for me. Thank you. V. Tag: Monitor SQL activity through .net Tag: 65009
  - 4
    - Alternatives to visual studio .net ? Hi all, I was wondering are there any free IDE's for .net development in particular aspx ? I really like Visual Studio, but can't stump up the cash at the moment for it. Thanks, -A Tag: Monitor SQL activity through .net Tag: 65006
  - 5
    - line control in VStudio.NET Looking for the good ol' Line Control in Visual Studio.NET that earlier used to be part of the standard toolbox in VB6. Any suggestions. If there is no such control in VS.NET can anyone recommend a good way to draw lines on WinForms. thanks, -paul Tag: Monitor SQL activity through .net Tag: 65003
  - 6
    - Select client channel for a remote call. All: I have registered several client-side channels, each with a different set of credentials. When I want to make a remote call, how can I specify which client-side channel I want to use to make the call? Thanks, Bill Tag: Monitor SQL activity through .net Tag: 65002
  - 7
    - System.Array.Rank (MS BUG?) The docs say System.Array.Rank will provide the number of dimensions in the array. But does not seem to work. I get 2 back for both 2 and 3 levels of dimensions in the array. I am forced to use Com interop, could that be breaking this? I am also using VB.NET. Strange output. See my code and locals window copy below: Looks like a MS bug to me Schneider '---CODE-------------------------------------------------------------------- ------------------- Public Shared Function ScheduleSink(ByVal InstrId As Integer, ByVal value As System.Array, ByVal MatureDate As System.DateTime, ByVal IssuedAmmout As Double) As PosMan.InstrMaster.ClsScheduleSink Dim u As Integer Dim v As Integer Dim tSched As New PosMan.InstrMaster.ClsScheduleSink Dim rnk As Integer Try If InstrId = 61091 Then Dim a As Integer a = 1 End If rnk = value.Rank Select Case rnk Case Is = 2 '--------------------------------------------------------------------------- -------- '-------LOCALS Copy for debug mode-------------------------------------------------- ' Notice rnk=2!, with three elements! '--------------------------------------------------------------------------- -------- rnk 2 Integer ScheduleSink Nothing PosMan.InstrMaster.ClsScheduleSink + tSched {PosMan.InstrMaster.ClsScheduleSink} PosMan.InstrMaster.ClsScheduleSink u 0 Integer v 0 Integer - value {System.Array} System.Array (0,0) "12/01/2016" String (0,1) "100.0000" String (0,2) "650000.00" String (1,0) "12/01/2017" String (1,1) "100.0000" String (1,2) "675000.00" String (2,0) "12/01/2018" String (2,1) "100.0000" String (2,2) "725000.00" String (3,0) "12/01/2019" String (3,1) "100.0000" String (3,2) "800000.00" String (4,0) "12/01/2020" String (4,1) "100.0000" String (4,2) "850000.00" String (5,0) "12/01/2021" String (5,1) "100.0000" String (5,2) "900000.00" String (6,0) "12/01/2022" String (6,1) "100.0000" String (6,2) "975000.00" String (7,0) "12/01/2023" String (7,1) "100.0000" String (7,2) "1050000.00" String (8,0) "12/01/2024" String (8,1) "100.0000" String (8,2) "1125000.00" String (9,0) "12/01/2025" String (9,1) "100.0000" String (9,2) "1200000.00" String (10,0) "12/01/2026" String (10,1) "100.0000" String (10,2) "1300000.00" String (11,0) "12/01/2027" String (11,1) "100.0000" String (11,2) "1400000.00" String (12,0) "12/01/2028" String (12,1) "100.0000" String (12,2) "1500000.00" String (13,0) "12/01/2029" String (13,1) "100.0000" String (13,2) "336850000" String '-------LOCALS Copy for debug mode-------------------------------------------------- ' Notice rnk=2! '--------------------------------------------------------------------------- -------- rnk 2 Integer ScheduleSink Nothing PosMan.InstrMaster.ClsScheduleSink + tSched {PosMan.InstrMaster.ClsScheduleSink} PosMan.InstrMaster.ClsScheduleSink u 0 Integer v 0 Integer - value {System.Array} System.Array (0,0) "06/01/2002" String (0,1) "20000000.0000000" String (1,0) "06/01/2003" String (1,1) "20000000.0000000" String (2,0) "06/01/2004" String (2,1) "15000000.0000000" String Tag: Monitor SQL activity through .net Tag: 65000
  - 8
    - Update on timer question... The behaviour I'm getting is that my timer is going off like an infiniant loop, sending hundreds of requests to my e-mail function. Sorry not to include that in my original post. Carlo Tag: Monitor SQL activity through .net Tag: 64997
  - 9
    - Is there an upward limit to the System.Timers.Timer.Interval value? I am using a timer in my Windows service previously discussed in my previous post to send warning e-mails to users who's account activity idle for a given number of days. Currently I have it set for 30 days, which I multiply by a base value for one day in milliseconds. The value that is currently being used is: 2592000000, which when divided by 24 * (60^2) * 1000 comes out to 30 days as it should. Can the timer not be used in this way? If it can't how does one accomplish this type of timing? Carlo Tag: Monitor SQL activity through .net Tag: 64996
  - 10
    - Process.Exited doesn't throw? I am writing a Windows Service that monitors a running instance of another (third-party) application by using the Process component. I set it up to listen for the Process.Exited event, but that event never seems to be raised. I tested further, using a .dll that runs in NUnit (just a handy place to test little hypotheses when I run into questions like this) and it still wouldn't recognize the closure, cancelling, killing or otherwise ending an application. I tried running on a different machine, and no dice. Is this a known issue? I'm responding to this event just as I would any other event. Is there something I missed? I'd rather not do a timer loop that constantly checks the state of the Process. Thanks for your help. -Marc Tag: Monitor SQL activity through .net Tag: 64990
  - 11
    - Query AD Does anyone know if it is possible or have an example of retrieving a list of DHCP servers directly from active directory? Tag: Monitor SQL activity through .net Tag: 64988
  - 12
    - FileSystemWatcher I set up a FileSystemWatcher to watch one specific file, code sample below. I have set the NotifyFilter to NotifyFilters.LastWrite. When the file is saved Class1.WeChanged is fired 2 times. Does anyone know why this would be? I understand that a rename or a move causes multiple events to be fired but don't know why LastWrite would get fired more than once. FileSystemWatcher fs = new FileSystemWatcher ( ); fs.Path = ".\\"; fs.Filter = "Test.dat"; fs.NotifyFilter = NotifyFilters.LastWrite; fs.Changed += new FileSystemEventHandler ( Class1.WeChanged ); fs.EnableRaisingEvents = true; Thank You Ken Tag: Monitor SQL activity through .net Tag: 64987
  - 13
    - Generating Html Pages Hi all, I need some help, I need to generate Html Files taking data from the database (SQLServer) to the specified network path on Button click of the windows form. I need to use only windows forms not web forms. Please can somebody tell me what to do Thanks in advance Tag: Monitor SQL activity through .net Tag: 64983
  - 14
    - Initializing ADO.Net SQL connection in Windows Service. I am trying to initialize an ADO.Net SQL connection to an sql server in my Windows service and I'm getting the following exception while trying to initialize the SqlConnection Object. The language is C#. System.ArgumentException: Unknown connection option in connection string: user. at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String conString, Hashtable values) at System.Data.SqlClient.ConStringUtil.ParseConnectionString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at NotifyExpiredResume.NotifyExpiredResume.OnStart(String[] args) in c:\documents and settings\carlo razzeto\my documents\visual studio projects\notifyexpiredresume\expiredresume.cs:line 111 Here is what my connection string looks like and initializer looks like: private string ConnectionString = "Data Source=(local); User=sa; Password=****; Initial Catalog=JobSite"; public SqlConnection SQLConnection; try { SQLConnection = new SqlConnection(ConnectionString); } catch(Exception ex) { EvntLog.WriteEntry("There has been an exception trying to init SQLConnection:\n" + ex.ToString(), EventLogEntryType.Error); EvntLog.Dispose(); return; } Tag: Monitor SQL activity through .net Tag: 64982
  - 15
    - reading machine.config file I have a problem that involves many technologies - if anyone thinks there's a better group to post this to, don't yell and scream, just let me know. OK, our company is developing apps with VB.Net (using Remoting) and Crystal Reports. To solve the problem of creating multi-language reports, I wrote a UFL (User Function List) to do all the translating. I won't get into specifics, but this UFL is just an ActiveX dll written in VB6 (Crystal doesn't support writing them in .NET) that reads the translations from a SQL Server database. In addition, we have many apps and they use about 10 different databases. Since we're using remoting, the data access objects reside on our web server. All the info this data access object needs to connect to the databases is stored in the machine.config file of our web server (I know the machine.config is probably not the best .config file to store this info in - but that's where my boss says it has to be!) Finally, my problem. The Crystal reports are also running on the web server and I would like my ActiveX dll to be able to read the machine.config file for the SQL Server logon info (for it to get its translations) just like my .Net apps do. Obviously, I can't use the framework methods since the dll is written in VB6. What's the best way to find the location of the latest framework verion's machine.config file. I know I could write some hokey folder traversal method to try and find what version folder to look in. I may also be able to look in the registry, but I'm just looking for a cleaner solution. In conclusion, I'm looking for an easy and clean way to find the location of the latest version of the machine.config file without using the framework methods. Thanks in advance! Tag: Monitor SQL activity through .net Tag: 64980
  - 16
    - ShowHelp() and weird window behaviour Why is it that ShowHelp causes the Help file to show up as some sort of child to the main application? (I've tried this with MS help files and it does the same, it isn't my help file per-say) You can't click on the application without bring the help file to the front, you can't alt+Tab between the help file and the application etc. This is highly not a good thing. It should be a separate application for all intents and purposes. Anyone have any ideas? Thanks, James Hancock Tag: Monitor SQL activity through .net Tag: 64975
  - 17
    - ArrayList sorting Does anyone know of a way to do multicolumn sorting with the ArrayList object? Basically I have a collection of objects and I want to sort on multiple properties of the objects in the collection. Any guidance here would be great. Thanks. Tag: Monitor SQL activity through .net Tag: 64972
  - 18
    - asynchron serversocket Hello, first, I'm sorry, my english is terrible! But in german newsgroups I didn't found an answer. I found a sourcecode in VStudio-Help. "example for asynchronious serversocket" (ms-help://MS.VSCC/MS.MSDNVS.1031/cpguide/html/cpconnon-blockingserversocketexample.htm) This is a link in the german help! In this class are all functions SHARED (VB) or (STATIC) in C#. But why? I need to use InstanceEvents. It works without the SHARED-Keyword. Why are these functions SHARED? Who can help me? Thanks. Peter Tag: Monitor SQL activity through .net Tag: 64971
  - 19
    - Include Visual Basic.NET I just bought a copy of the Visual C#.NET deluxe learning addition. It included the .NET framework and the capacity to develop in C#. It looks like I can't do anything in Visual Basic.NET until I install it. Is there anywhere I can download this part of the Visual Studio.NET environment? Also I thought it was possible to develop an app using both C# and Visual Basic. The environment makes it look like my project has to be one or the other. Thanks in advance for your help. Tag: Monitor SQL activity through .net Tag: 64968
  - 20
    - Autosize + Datagrid How I can autosize a DataGrid after then associate a Datasource=Dataset in Smart Devices applications or Windows forms application?? That same?? -- Cumprimentos, David de Passos -------------------------------------------------------------- RCSOFT, Lda. E-Mail: passos@rcsoft.pt Móvel: +351 966931639 Telefone: +351 239708708 Fax: +351 239708701 Tel. Directo: +351 239708705 ext. 401 Tag: Monitor SQL activity through .net Tag: 64967
  - 21
    - QueryString and Web Forms Hello, I have a few web forms: 1) Shows a list of items with item ids 2) Shows details specific to an item and the sub-items of this item. What is the best way to pass the item id of the selected item from the 1st page to the 2nd? If I pass the value in the query string from the first 1st form to the 2nd, the 2nd form's URL will always contain that it in it since ASP.NET uses POST method and not a get method. So if on the 2nd form there is a way to pick a different item from a drop-down list, the URL will still contain the id of the orginally selected item, while the details will be shown for the item that was subsequently selected from the drop-down. This does not look right. Should I use the Session() to pass the item id of the selected item from the 1st to 2nd page instead of the QueryString method? Thanks, Arsen Tag: Monitor SQL activity through .net Tag: 64964
  - 22
    - getting computer and domain name of pc Is there a way to retrieve the full computer name (ComputerName.DomainName.com) using the .Net Framework? System.Environment.MachineName will return the computer name but not the domain name. Tag: Monitor SQL activity through .net Tag: 64963
  - 23
    - problem with shared assembly reference in VS solution I'm having a problem with shared assemblies > 2^16 bytes in size. My assembly is in a solution along with a console app that references the assembly. The app is set up to reference the assembly (the reference path is pointed to the assemblies output directory). When I do a build, the assembly is failing to build because the .dll is loaded. I'm getting the following output from the build: The file 'Test_Library.dll' cannot be copied to the run directory. The process cannot access the file because it is being used by another process. Could not copy temporary files to the output directory. I've created a few other shared assemblies with no problems. This is the first time I've seen this exact problem and in trying to run it down I've discovered that if the .dll's size is < 65536 bytes (as all my other ones are), this doesn't happen. It looks like VS is loading the .dll when I add the reference for the console app. If I delete the console app's reference to the assembly, I am able to build the library. I hope one of you has run across this before. thanks for any help, Tim Tag: Monitor SQL activity through .net Tag: 64956
  - 24
    - console unload event? Is there some event that gets fired when a console window is closed? I have cleanup code which needs to abort several threads. Keith Tag: Monitor SQL activity through .net Tag: 64955
  - 25
    - Calculated PerformanceCounters I've read (repeatedly)the stuff on MSDN regarding calculated performance counters, and I'm still not getting it. I want to have a performance counter that can be monitored from perfmon that shows avg transaction time. All of the sample code seems to show me how to calculate this value -- that is, how to use the Calculate( ) method (using samples) to determine the value desired, but this value isn't shown in perfmon. I don't know if any of that makes sense, but if someone could point me to some resources that are better than MSDN, I'd appreciate it! Thanks, Dave Tag: Monitor SQL activity through .net Tag: 64950

Anyone have any ideas of how you would build a .net
component to monitor SQL Activity.
Here is what I am trying to do:
When an insert or update to a SQL table occurs, I want to
populate another table (in a different database). I don't
want to use a trigger.

Thx,
Troy

Top

Re: Monitor SQL activity through .net by andrew

andrew
Wed Dec 17 20:12:30 CST 2003

".net and SQL Server" <tclarke@options.com> wrote in message
news:027d01c3c506$7afa3740$a001280a@phx.gbl...
> Anyone have any ideas of how you would build a .net
> component to monitor SQL Activity.
> Here is what I am trying to do:
> When an insert or update to a SQL table occurs, I want to
> populate another table (in a different database). I don't
> want to use a trigger.

Troy,

You'll want to hook into the tracing and profiling functions of sql server,
have a look at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20126&pg=1

hth
andrew

Top