WickedlNl's Q&A profile

• Windows Forms use ActiveX ctrl if available

  That must be a common scenario, but I have not found anything about it: I want to use an ActiveX control if it is available, e.g. the "Microsoft Excel 11.0 Object Library" to export some data shown on the screen to Excel and show the new document. If the ActiveX control is not installed, so probably office is not installed, I do not want to offer that feature in that installation. What is the right way to approach this scenario Having created a helper class by importing the object, I'd have thought you could try to create an instance and if it works, then it's available ...Show All

• SQL Server How to make this simple SELECT query perform faster

  Hi, I have the following simple SELECT query: SELECT * FROM TRX_LAPD But the problem that table TRX_LAPD is very big. Althoug, I am using this query in a Network envirenment. If I implement this query inside Microsoft SQL Server, the first time is somehow slow (40 sec), but becasue of the caching cabability the next time is very fast. The thing that I am using this query in Visual Web Developer, so to be accessed by other users in the local network, but it seems that there is no caching features; each time I execute the query the implementation remains slow (40 sec) even from the from the server PC which have the SQL Server runni ...Show All

• Windows Forms Deploying a Win Form via Web Server

  I'm trying to setup a web server on my intranet to deploy windows forms applications.  I've written a VERY simply app, the classic "Hello World" and have successfully tested launching the app from my local machine (ex. http://localhost/helloworld/helloworld.exe) When I move the app to the actual intranet web server (Win NT 4, SP 6, IIS 4, .Net Framwork  ...Show All

• SQL Server Can I use ALTER LOGIN in a stored procedure???

  Can the ALTER USER statement be used (without a hack like using EXEC) in a stored procedure I know that the sp_password system stored procedure can not be. Additionally, it is being deprecated anyway. I guess what is boggling me about my attempts so far relate to the errors I am getting due to the user being specified not being in quotes in the syntax. All of the searching I have done so far have come up lame so far; the only examples I have found about it were in scripts that create other scripts for transferring users and other administrative tasks that would be run from the query window, but not from an application. To be complete as po ...Show All

• Visual Studio VSTestHost.exe

  When attempting to run a basic test where I scroll around yahoo, when selecting run I keep getting a VSTestHost.exe error. I ran the debug and it came up with this access violation. EHAccessViolation Has anyone else come across this during a test run If you have please contact me since I am very new to using the MSDN tools. Thanks Robert Seiler MGM-Mirage rseiler@mgmmirage.com Hi Robert, Can you provide more information about this, such as -Are you running on an RTM version of VSTS -I assume you were recording on a Web Test when you saw this error -Anything else you were doing before this ...Show All

• Visual Studio Express Editions A question about forms

  I'm new to C# after years of Delphi, so still getting used to things. I have a question about forms and displaying new forms. In the programs I write, I have a number of forms that I need to open and close, depending on circumstances. In Delphi this was easily achieved; you created the form and showed it and closed it as necessary. In C# I'm having problems understanding the same process. I can declare a form along with the other private/public declarations (in the class declaration), but once the form's closed it's gone. Alternatively if I create a form (frm = new Form2();) in an event handler for a button, for example, I can open the ...Show All

• Visual Studio Team System Work Items, Documents, and Reports folders show RED X's in Team Explorer -- WHY?

  I can connect to my Team Foundation Server just fine from Team Explorer, but the Work Items, Documents, Reports, and --intermittently -- the Version Control folders under my Team Project all have RED X's in the corner of them and are inaccessible.  The tooltip and toolbar buttons seem to suggest that it is "refreshing" (for example, the "Stop Refresh" toolbar button lights up), but the unknown activity rarely completes, and when it does, the RED X's remain. I read another post suggesting that it may be a permissions issue, but it happens even when I'm logged on as Administrator, so I'm discounting that theory. Am I doing something ...Show All

• .NET Development App Blocks Conversion 1.1->2.0

  I found this post on GotDotNet and it never recieved an answer. We have the same problem :) so I am going to post it here with the hopes that some VERY smart individual will be able to answer and solve the worlds problems: I'm using the [ June ] ( we are using latest ) 2k5 Enterprise library, VS 2005, C#, and some other stuff :) I can't build, every time I get this error: Error 1 The type 'Microsoft.Practices.EnterpriseLibrary.Configuration.ProviderData' is defined in an assembly that is not referenced. You must add a reference to assembly 'Microsoft.Practices.EnterpriseLibrary.Configuration, Version=1.9.9.9, Culture=neutral, Publ ...Show All

• Visual C++ how to read exe file

  Hi all I have a problem. i have situation where i need to send a complete C program made in .net 2003 to another pc using socket. Now rather than sending individual files CPP and .h files(since there can be more than 2 or 3 files), i deicded to make an exe file and then send exe file to other pc. Now i am able to create the exe file but i am not able to read it using c++ file handling. here is the code #include<iostream> #include<fstream> using namespace std; void main() { ofstream fout; ifstream fin; char c[20]=" "; fout.open("C:\\sample1234.exe",ios::ate); fin.open("C:\\ ...Show All

• Visual C# Just-In-Time Data Loading For DataGrids

  Hello! I have a database with 2 million records and I want to display these records in a data grid, but I do not want to load them all into memory from the database. I want them loaded "just in time," maximizing performance and minimizing memory load on the application. Version: Visual Studio 2005 SO: Windows XP proffessional Thank you in advance On Windows dev center there is a great article written by Kesse Liberty: Just-In-Time Data Loading For DataGrids . ...Show All

• SQL Server Migrating form access to SQL

  I am facing problems in migrating my application from Access to SQL. Few of the fuctions like CBDATE (userdefined functions) are not working. Please let me know how to overcome this problem. Thanks Yeah, I would assume that to be the case...problem would be if the VBA function is doing anything you can't do in T-SQL...then it would be more difficult... ...Show All

• SQL Server How to allow remote connections to SQL Server 2005 Express database

  I've developed an asp.net 2.0 web app with vs 2005 and am using a SQL Server 2005 Express database. The app works fine locally, but after uploading to the remote web server the following error occures: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) How do I go about granting remote connections to SQL Server Express Does the web server have to have SQL Server Express instal ...Show All

• Visual Studio How to check programmtically if the report is empty in a web form

  In the body of the report, I can use the "NoRows" property to display a message when there is no record found. But I also need to perform other processings based on that result, eg. redisplaying the input boxes etc. Can someone point me to the correct API to check programmtically if the report is empty Thanks! Thanks, Brad. First part of your answer was helpful. However, I don't really know how to go about writing my own parser. I found a work-around - on ObjectDataSource_Selected, I could get a count of the datatable: eg. D ataSet1 . DataTable1DataTable dt = ( DataSet1 . DataTable1DataTable ) e.ReturnV ...Show All

• Windows Forms windows form parking window

  Hello People. I have this problem, one time my application show me this error: WindowsFormParkingWindow I can’t reproduce the situation,that is what i need to now what it is WindowsFormParkingWindow or what its function in .NET. Thanks!. Hi! WinForms use internally parking window. I think it's used to hold controls that was closed/removed/etc, i.e. that not inside any parent control. ...Show All

• .NET Development Sending and Retrieving Data using TCPClient only..

  Hi everybody,   Is it possible to send and receive data using only TCPClient Class only with out any server-side class/components For example, I am sending sql statement (Select command) and Retrieving Data in DataTable or DataSet format, and sending Insert, update or delete sql statements and retrieving response in string or int datatype. Is this possible Is it possible to convert byte[] data from NetworkStream to DataTable How Thanks. Sample Code (Plan to do): private bool SendData(string url, int port, string str) {   TcpClient tcpClient = new TcpClient()   tcpClient.Connect(url, port); . ..     Networ ...Show All