Accessing Data

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
    - 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: Accessing Data Tag: 65069
  - 2
    - 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: Accessing Data Tag: 65066
  - 3
    - 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: Accessing Data Tag: 65064
  - 4
    - 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: Accessing Data Tag: 65060
  - 5
    - 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: Accessing Data Tag: 65059
  - 6
    - 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: Accessing Data Tag: 65055
  - 7
    - 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: Accessing Data Tag: 65052
  - 8
    - 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: Accessing Data Tag: 65044
  - 9
    - 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: Accessing Data Tag: 65043
  - 10
    - 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: Accessing Data Tag: 65037
  - 11
    - 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: Accessing Data Tag: 65035
  - 12
    - 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: Accessing Data Tag: 65033
  - 13
    - .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: Accessing Data Tag: 65031
  - 14
    - 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: Accessing Data Tag: 65030
  - 15
    - 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: Accessing Data Tag: 65028
  - 16
    - { 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: Accessing Data Tag: 65020
  - 17
    - 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: Accessing Data Tag: 65018
  - 18
    - 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: Accessing Data Tag: 65017
  - 19
    - 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: Accessing Data Tag: 65014
  - 20
    - 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: Accessing Data Tag: 65012
  - 21
    - 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: Accessing Data Tag: 65010
  - 22
    - 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: Accessing Data Tag: 65009
  - 23
    - 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: Accessing Data Tag: 65006
  - 24
    - 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: Accessing Data Tag: 65003
  - 25
    - 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: Accessing Data Tag: 65002
- Next
  - 1
    - 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: Accessing Data Tag: 65000
  - 2
    - 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: Accessing Data Tag: 64997
  - 3
    - 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: Accessing Data Tag: 64996
  - 4
    - 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: Accessing Data Tag: 64990
  - 5
    - 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: Accessing Data Tag: 64988
  - 6
    - 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: Accessing Data Tag: 64987
  - 7
    - 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: Accessing Data Tag: 64983
  - 8
    - 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: Accessing Data Tag: 64982
  - 9
    - 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: Accessing Data Tag: 64980
  - 10
    - 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: Accessing Data Tag: 64975
  - 11
    - 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: Accessing Data Tag: 64972
  - 12
    - 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: Accessing Data Tag: 64971
  - 13
    - 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: Accessing Data Tag: 64968
  - 14
    - 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: Accessing Data Tag: 64967
  - 15
    - 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: Accessing Data Tag: 64964
  - 16
    - 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: Accessing Data Tag: 64963
  - 17
    - 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: Accessing Data Tag: 64956
  - 18
    - 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: Accessing Data Tag: 64955
  - 19
    - 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: Accessing Data Tag: 64950
  - 20
    - all .NEt applications cause to "System.Security.Policy.PolicyException I was testing some configuration options with Framework Configuration tool and eventually something went wrong in .NET security. Now cannot do anything in .NET with out having "System.Security.Policy.PolicyException: Execution permission cannot be acquired." error and CLR debugger popup. I get this error running caspol.exe, ANY .NET application, even when I try to open Configuration snap- in. I have tried to reinstall the framework and it didn't help. Virtually nothing works on my machine!!!! I have VS.NET 2003 WinXP professional and Iam administrator. Please help Im despaerate!!! Thanks David Tag: Accessing Data Tag: 64946
  - 21
    - OleDbCommand parameter datatype marshalling issue with MS Access Hi, When I create a table in MS access 2000 with SR3 using a standard SQL Create command The BOOL (YesNo) columns are NOT checkboxes, they are ints. When I create a table using the designer the BOOL YESNO fields are checkboxes. Smells like a BUG. When I call OleDbCommand with a BOOL in the parameters to update, I get "Syntax in UPDATE command" beecause this datatype is not matching because of this bug. The command runs fine when copy and pasted to the query window in MS Access directly. Smells like an Access and OleDb class bug Tag: Accessing Data Tag: 64944
  - 22
    - Getting Cokkies values using FORMS authentication Hello, Iâ??m developing in ASP.NET using â??Formsâ?? authentification: Iâ??m asking â??LOGINâ??, â??PASSWORDâ?? and â??KEYâ?? Web.config: <authentication mode="Forms"><forms name=".SOMETHING" loginUrl="login.aspx" protection="All" timeout="5" path="/"></forms></authentication> As you like read, I am using the attribute protection="All" (encrypting the cookie). Everything is running very well, â??BUT...â??, I have the following doubt: Is possible that I can apply something like: vAux = HttpContext.Current.Server.UrlEncode(â??LOGINâ??) LOGIN = HttpContext.Current.Request.Cookies.Get(vAux) vAux = HttpContext.Current.Server.UrlEncode(â??PASSWORDâ??) PASSWORD = HttpContext.Current.Request.Cookies.Get(vAux) vAux = HttpContext.Current.Server.UrlEncode(â??PASSWORDâ??) KEY = HttpContext.Current.Request.Cookies.Get(vAux) for getting DESENCRYPTED values?? (I know that the code above is not correct) I need that values for using its with others functions. Could someone help me? Thanks in advance!, l-touched Tag: Accessing Data Tag: 64940
  - 23
    - sql connection in windows service doesn't work! Hi all, Ive made a Windows Service that basically makes connections to a Sql database, when it connects it runs a stored procedure. Below is the static procedure. This procedure is in the Windows Service and the procedure runs and an Eventlog is successfully written with no exceptions. If I take this simple code and put it in a test console app with the same connection, stored procedure and email address it runs no problem. The problem I have is that I get no errors so im thinking its some kind of Threading issue? I just dont understand why this code with the same parameters can work fine in a stand alone console app rather than incorporated into a windows service. And still the windows service doesn't give me any error, and the stored procedure doesn't run! I have verified that the stored procedure is there and works! static void runme(string connection, string remove, string emailaddresss) { try { SqlConnection con = new SqlConnection(connection); SqlCommand com = new SqlCommand(remove); com.CommandType= CommandType.StoredProcedure; SqlParameter myParm = new SqlParameter("@email",SqlDbType.NVarChar,25); myParm.Value = emailaddress; com.Parameters.Add(myParm); con.Open(); com.Connection = con; com.ExecuteNonQuery(); con.Close(); com = null; con = null; EventLog.WriteEntry("MMS", " " + connection + " " + remove + " " +emailaddress); } catch(System.Exception e) { EventLog.WriteEntry("Service", "Exception is as follows: " ex.Message); } } Thanks very much for your help. phil Tag: Accessing Data Tag: 64938
  - 24
    - Use excel files in my application Hi. I develop an application in C# which tries to open a excel file. When the following code is excecuted excel.Workbooks.Open( szTemplateExcel, Type.Missing , Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing ); then the following mesage received: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in CDRProcess.exe Additional information: Old format or invalid type library Can anyone help me on this? Thanks :) Tag: Accessing Data Tag: 64937
  - 25
    - Directory.GetFiles throw an exception Hi, The following statement throws an exception when the search pattern returns no files: string[] files = Directory.GetFiles(directory,"*pl*.txt"); Is there any way to find out whether there isn't a match so that I don't have to wrap the above code up in a try- catch block? John Tag: Accessing Data Tag: 64936

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

Top

Re: Accessing Data by Jan

Jan
Wed Dec 17 14:56:48 CST 2003

Check out the answer to your question I posted in
microsoft.public.dotnet.framework.webservices newsgroup!!

Btw, it's rather annoying posting the same question in many different
newsgroups...

--
Greetz,
Jan
__________________________________
Read my weblog: http://weblogs.asp.net/jan
"Mohan Gupta" <mbgupta90@yahoo.com> schreef in bericht
news:018401c3c4de$8757fc20$a601280a@phx.gbl...
> 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
>

Top