sqldummy's Q&A profile

• .NET Development Memory Issues

  Hello all, I've been trying to profile my ASP.NET application on my application server. I set up 2 counters for aspnet_wp process namely '#bytes in all heaps' and 'process:private bytes'. According to a documentation that i read, '#bytes in all heaps' should be less that 'process: private bytes'. However the '#bytes in all heaps' was far greater than that of the 'process: private bytes'. I'm lead to believe that this indicates a memory leak somewhere. Now, the problem is that i've got 15 ASP.NET applications running on that server and i need to find which application(s) are causing the problem. Please i'll need help on which counters to set up that will enable me pin point the rouge application. Thanks Emeka. ...Show All

• Windows Forms Is it possible for two forms to reference the same instance of a dataset?

  Is it possible for two forms to reference the same instance of a dataset This is my reason for asking: I'm developing an MDI app. Form1 contains a datagridview that shows all the records in Table1. Form2 contains text boxes and is designed as a data-entry form for the user to add rows to Table1. Everything works fine so far; data is retrieved and displayed fine on Form1 and new records added by Form2 are saved to the database. However, the datagridview on Form1 does not update its records to show any new rows added by Form2. This is understandable as both Form1 and Form2 use their own instances of the same DataSet, so any changes made to Form2.DataSet are not reflected in Form1.DataSet, even if DataSource.ResetBindings is called. The ...Show All

• Visual Studio Adding Web Projects to VSS 2005 from VS 2005

  Hello folks. I've already read some of the threads here about the subject, I've also looked at Alin Constantin's VSS page ( http://alinconstantin.homeip.net/webdocs/scc/ ) and I've read some of the documentation at MSDN: MSDN - Visual SourceSafe < http://msdn2.microsoft.com/en-us/library/ms299291.aspx > MSDN - Visual Studio - Source Control for Visual Studio < http://msdn2.microsoft.com/en-us/library/zxd4dfad.aspx > MSDN - Visual Web Developer - Source Code Control for Web Sites < http://msdn2.microsoft.com/en-us/library/64fs8h82.aspx > But I'm still a little bit confused... What is the correct way of adding a Web Project to VSS 2005, using Visual Studio 2005 I want to add three existing intranet projects a ...Show All

• Visual Studio Express Editions I can't get my add new database Source Function to work

  I can't get my add new database Source Function to work. I get this error message:format of initialized string does not conform to specification starting at index 0 I enter the data source configuration wizard. I push the [NEW CONNECTION] button I change the data source from SQL to Access and then press [OK] button and a messagebox appears: format of initialized string does not conform to specification starting at index 0 I was adding a new database source then pointed to microsoft database access file, and when I pressed enter I got this error messege: format of the initialized string does not conform to specification starting at index 0 ...Show All

• SQL Server EncryptByKey Function always returning null

  When I use EncryptByKey function to encrypt text using AES 128 bit key, I get always null result. this is how I do the encryption: ALTER PROCEDURE [dbo].[ProcMyProc](@ClearText nvarchar(50)) AS BEGIN OPEN SYMMETRIC KEY MyKey DECRYPTION BY PASSWORD= 'MY_Password_128'; Declare @Temp varbinary(8000); Set @Temp =EncryptByKey(Key_GUID('MyKey'),@ClearText); close symmetric key MyKey; select @Temp as temp; END The result I get for this procedure is null. Is there something wrong with this code Hi Muhammad, The way our built-ins work is that they return null instead of returning an error. I don't remember why exactly this is the case, but I think it has to do with backwards compatibility and parsing logic of the built-ins. Sung ...Show All

• SQL Server How to migrate updated data alone?

  Hi, Can anybody pls help me with this, i have to migrate data from one sql server(1) to another sql server(2) using SSIS,Which is a bit easy,the concern here is that after doing it the data in server(1) is getting updated due to inserts,now i need to bring the updated data alone.Is anybody having experience in this can anyone pls help me or give me sugessions on how i need to proceed. Thanks in advance. Regards, Sg Hi Phil, This is ok with inserts what about the updated rows and deleted rows Thanks, sg. ...Show All

• Visual C++ How to retrieve the ORACLE_HOME location from Registry Editor through VC++ irrespective of ORACLE Version???

  How to retrieve the ORACLE_HOME location from Registry Editor through VC++ irrespective of ORACLE Version use GetEnvironmentVariable function to get the value for ORACLE_HOME variable name , it should return a full path to the installation directory. ...Show All

• Windows Live Developer Forums Autozooming

  Hello to everyone. My problem is: when i am adding a new pushpin to the map, its (map) autozooming on that pushpin. I don't need it. How can I prevent it note: map autozooming when I using Find method and not when I adding new pushpin. function AddPoint(lat, lon) { var pin = new VEPushpin(pinID, new VELatLong(lat, lon), null , "Opportunity name: " + names[pinID], "Expected Revenue: " + descriptions[pinID] ); map.AddPushpin(pin); pinID++; } ...Show All

• Software Development for Windows Vista Lockup

  Hi. I like CardSpace, and I have had it working since it came in Windows Updates. But today when I ran it (and I've tried a few times) It just sticks at "Please wait while Windows CardSpace loads". It doesn't do anything, except stick there and display the egg-timer cursor. My only way to get out of it (as Windows key doesnt work, ALT+F4 doesn't work, CTRL+ALT+DEL doesn't work, is to restart (I use the hardware reset button). Anyone know why it's locking up Yeah I've seen that. But the progress bar hasn't appeared yet, and under the Tasks bit there is a blacked out box (I'm blaming the fact that it's being slow). In Event Viewer there is only one error for Ca ...Show All

• Windows Forms Upgrade application using setup project (VS 2003)

  Hi!. I have a program done in .NET . I use setup project to deploy it. This program has a DLL in GAC order that it can be acceded by other programs. The question is, if I want to update the DLL or the EXE, what must i do At the moment I increase the versi o n of the DLL and the EXE , if I try to execute the installer says to me that already I have a versio n installed of this application, if I change the version to the setup project I have two options: 1.-To change the product code and then installs them to me as a new program.... 2.-Not to change the product code and then says to me that already I have the installed product Thank you Thank you. Is there anyway to reinstall at the same path of the pre ...Show All

• Visual C# Unable to add an identical cell to a row twice

  Hi everybody, I'm hoping you can help me understand why this doesn't work, and perhaps someone can suggest a way for me to solve my problem. Essentially, I'm trying to add a row with a single cell twice in a table. Both cells are identical and therefore I don't want to duplicate everything in the code. My function determines at runtime if there should be two identical cells or just a single cell. Here is some sample code, which only displays the contents of a single cell. protected void Page_Load(object sender, EventArgs e) { Table atable = new Table(); TableRow arow = new TableRow(); TableCell acell = new TableCell(); HyperLink alink = new HyperLink(); alink.NavigateUrl = "aaaaaaaaaa"; alink. ...Show All

• SQL Server .mdf files

  What are .mdf files and how do I use or open them I have two .mdf files, but have no idea how to open them. I don't have an .ldf file and want to access the .mdf file. How do I attach it to the database I don't have SQL Server. What should I do ...Show All

• .NET Development Generic performance... benefit?

  Hi, in every article about generics is written that they improve performance because no boxing, etc. occurs. So I wrote this simple test code and was astonished that the non generic part actually performs a couple milliseconds faster than the generic part About 59.8 seconds for the generic and 59.1 seconds for the non generic (avg. of 10 runs). Am I missing something here [code] using System; using System.Collections.Generic; using System.Text; using System.Xml; using System.Collections; namespace ConsoleApplication6 { class Program { static void Main(string[] args) { string s = ""; Test<string> test = new Test<string>("hi"); DateTime start = DateTime.Now; for (int j = 0; j < 1000000; j++) { foreac ...Show All

• Visual Basic count

  hi, i am very new to vb and have been looking for a solution for this problem for hours! i think that i have been looking at it for to long and have just completly lost the point of it, so any reply will be greatly appreciated!! anyway, here it is... i have a project where i must display the total number of items from 4 textboxs in between a certain range. for example if 10, 3, 4, 11 are entered into the textboxes, i want to display the total of numbers in between 0 and 5, thus 2 would be displayed. i know the answer will probably be something simple that i have overlooked, but i am near the end of my rope mentaly due to this !!!!!!!!!!!!     First of all you want to display these things in a fashio ...Show All

• SQL Server FTS Catalogs won't populate

  Hi After creating a full text catalog in SQL Server 2000 and performing the initial population, the catalog say has an index count of 1 (should be several thousand) and all "contains" queries return no results. The gather log contains the following error message: Error Fetching URL, (80070002 - The system can not find the file specified) . Any catalog I try to make has the same problem. All catalogs were working fine last week. Any help would be very appreciated. Thanks! Hey, we fixed our problem by re-registering tquery.dll on SQL Server. See http://support.microsoft.com/kb/817301/en-us . Hope this helps. ...Show All