erikkl2000's Q&A profile

• Visual C# How do I enable Ctrl + V and Ctrl + C for a ComboBox?

  Although it works when you do a right click, then copy and paste. But doing a Ctrl + V and Ctrl + C doesn't work. How do i enable this I found the problem. When I added a MenuStrip control, I inserted all standard items. The standard items have an entry for both Copy and Paste with ShortcutKeys of Ctrl + C and Ctrl + V, respectively. But since I haven't defined these functions in my code and so there are no actions taken. ...Show All

• Visual Studio Team System Prevent overriding checkin policy?

  Is there a way to disable allowing the user to do this Perhaps via a security permission Otherwise what good is the policy Thanks WXS123 wrote: The issue we have is that management would agree to requiring comments on all checkins and approve that across the board as a functional implementation that enforced it, but they typically don't crack down on people that avoid it. So we would certainly enable the policy here to require but unless it's enforced we're not going to get 100% compliance ever. I can well imagine the management requirements, but 100% enforcement is complete 100% bull. That's yet another myth in a row of similar ones (100% of bugs fixed in release, 100% ...Show All

• SQL Server Need help in migrating from Access to SQL express

  Hi there, I am totally new at SQL/SQL express.I have downloaded the sQL express server and wanted to know how i can go about exporting my tables which i created using MS access into SQL express. Also my application is currently working by using Access and ASP...what will be the changes i would need to incorporate in my code other than the queries and Data connection string. How would the data connection string in SQL look like if i am using it in my asp code Any help or useful links would be a very good help! thanks in advance smita Try the SQL Server Migration Assistant. http://www.microsoft.com/downloads/details.aspx FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&DisplayLang=en ...Show All

• Visual Studio Tools for Office ASP.NET and Word

  I need some design guidance. I currently have an asp.net application that has some word documents that are used as templates and are stored in xml wordml format. I use standard XML processing to replace various parts of the document then send the processed XML document out in the response stream. This works great if the user has Word 2003 installed but now have to find a solution to support other versions of Word, etc. I began to think I could simply keep most of the processing the same (processing a WordML document) but instead of sending the WordML format document to the client have the document first converted to a standard word doc on the server then send to the client. I thought this may help me get around the incompatibilities wit ...Show All

• Visual Studio Express Editions clock time

  what is the best to keep track of time What I want to do is calculate time worked in the morning and in the afternoon. For example: person clocked in at 7:55am clock out for lunch at 12:10pm clock in from lunch at 1:15pm clock out for that day at 5:22pm Is there an easy way to calculated this or I am basically going to have to do all the calculation in the code thanks you can use a class called TimeSpan: http://msdn2.microsoft.com/en-us/library/system.timespan.aspx a TimeSpan calculates the duration/time interval between times. Example: DateTime d1 = DateTime.Now; DateTime d2 = DateTime.Now.AddHours(1); TimeSpan diff = d2 - d1; MessageBox.Show(diff. ...Show All

• Smart Device Development How to install .net cf 2.0 version from 1.1 version

  Hi folks, i have an .net 1.0 application. It has an self updating mechanism. If there is a newer version, the user can download it and update the application. However i'd like to upgrade the application to run under .net 2.0. So what have i done I implement a "dependency checking" module to the update mechanism. The new version should be dependend on .net 2.0. Even though i can determine, whenever the user has the .net 2.0 installed yet (through the registry) i have to install the .net 2.0 in case he/she has not installed it. But, and here is the problem, when i run the CAB installation from my .net 1.1 application, it fails with the error code 2 (means that a .net application is running preventing the installer to ov ...Show All

• SQL Server Compare Dates and fail job if no match

  This is probably a problem with a pretty simple solution but i can't find the right control/data flow item to handle it Scenario. I determine the database date for my source data for a set of ETL jobs via a piece of SQL - this gets passed to a master package variable which is subsequently to be used as the "Load date" of the resulting child package ETL routines. However I only want the packages to run if the LoadDate has either not been run before or is the next one in the DW sequence. To check for this, In my data warehouse I also have a table called Import_Registry where the date of each upload is stored at the end of the daily ETL routines. So I can obtain the potential NextUpload date via this bit of SQL script. S ...Show All

• Visual Basic counting letters in a textbox?

  Is it possible to count the number of letters in a textbox OR label e.g >textbox1.text = "thesister" would return a value of 9 letters is this possible textBox1.Text = "thesister" Dim textLength As String = textBox1.Text.Length --- Result: textLength = 9 ...Show All

• .NET Development static constructor

  Dear All, I am first to C# .net. I heared about static constructor. I want to know more about these. Can you explain this to me. It is a sample code I modified. Please use this code to explain the static constructor. public class Bus { static int AAA; static int BBB; static int CCC; static Bus() { System.Console.WriteLine("The static constructor invoked."); AAA=AAA+1; } public static void Drive() { System.Console.WriteLine("The Drive method invoked."); BBB=BBB+1; } public static void Start() { System.Console.WriteLine("The start method invoked."); CCC=CCC+1; } public void Stop() { System.Console.WriteLine("The Stop method invoked."); } ...Show All

• SQL Server READ_COMMITTED_SNAPSHOT

  ALTER DATABASE TestDb SET READ_COMMITTED_SNAPSHOT ON; The above statement work fine in SQL Server 2005. But my problem is that I have some old databases still using Sql Server 2000. I know the above statement is only valid in 2005. Is there any workaround in Sql Server 2000 to do the same thing Thanks. What you want is non-blocking read-committed isolation level in SQL2000. No, it is not supported. Only choice you have is to use read-uncommitted but that will potentially require you to change your app. Also, your app will need to be changed to handle uncommitted data. ...Show All

• Visual C# ExtractAssociatedIcon Help!!!

  Hello, I'm trying to extract icon from exe files during runtime, i know about the following function. Icon ico = Icon.ExtractAssociatedIcon(@"C:\WINDOWS\system32\notepad.exe"); this .Icon = ico; The problem is when i save the icon object to the disk!! MemoryStream Memo = new MemoryStream(); ico .Save(Memo ); File.WriteAllByte(@"C:\DLICO.Ico", Memo ); The above code should write the icon to C:\ the icon is saved but its deformed!!, i mean its colors looks very bad, can any one help, mention that the icon appear correctly in this line this .Icon = ico; but the saved icon appear very bad. Please help, thanks Dominator Legend wrote: Thanks Paul for your replay, the pro ...Show All

• SQL Server query to Linksed server very slow!

  Hello, i have created an RPC from my SQL server which queries a database of a linked server (remote server). the query result is very very slow. (it is a mis-size query, with many JOINs on tables with many entries). Let's say it takes about two minutes to get about 3000 results. The query uses five tables in the database of the linked server, runs a few (let's about 5-8) JOIN clauses and selects the entries. except for two tables (out of 8), each table has about 1000-2000 entries. the two have about 40,000 entries. Is this normal ! Is there anyway i can optimize my query i also tested my query and asked for only 100 results as opposed to all of the 3000. there was only 2-3 second difference in getting the results back, which indicates that ...Show All

• SQL Server SS2K5 Encryption - Use in HA and Test/UAT

  I am in need of some answers on SS2K5 Encryption and possible issues when used in a clustered(replicated) configuration as well as having the encryption work on a Test/UAT configuration. Here is the scenerio: ServerA - is the Primary/Active server in a NeverFail cluster. NeverFail is a replication method like MS Clustering is except NF replicates the server to EXACT mirrors of each other. ServerA has lets say 2 client DBs (actually we have 10-20 but for simplicity we will say 2.) ServerB is the Secondary/Passive node. First question is ... what issues may I run into if I encrypt the 2 clients needed data in the DBs and we then have a failover. I figure we should not see an issue if NeverFail is replicating everything includi ...Show All

• Windows Forms Key-Based List Control?

  Hi Everyone, I was just curious. Is there a Windows Forms List control out there that is "key-based". Basically, I want to display all of my Dictionary items in a List on a form, with the key of each item of the Dictionary being how I access each item in the List. I've looked at the ListView and ListBox, but it doesn't look like either one would do the trick. Thanks in advance Yes, that part is easy. What I want to be able to do is remove an item from a listbox/listview by a unique key. I see that the ListView control has a unique key accessor, which is assigned using one of two of the overloaded ListView.Items.Add() methods: ListView.Items.Add(string key, string text, string imageKey) or ListView.Items.Add(string key, stri ...Show All

• .NET Development CancelEventArgs is not marked Serializable

  The System.ComponentModel.CancelEventArgs class in the .Net Framework 2.0 is not marked with the Serializable attribute. I discovered this in a remoting application that I am working on when the app through a SerializationException . Why is the System.ComponentModel.CancelEventArgs class not marked as Serializable Is this a bug or oversight in the .Net Framework 2.0 Thanks for your reply. Yours is a good point. Let's see what others have to say. It's simple enough to recreate the class but I am wondering if that would be a mistake. ...Show All