Nihal Chand's Q&A profile

• Visual Studio SourceSafe, VS.NET 2003 and Stored Procedure Versioning

  Hi, Any Help I am version controlling my stored procedures via .NET IDE & VSS. Background: ================== I have VS .NET 2003, Visual SourceSafe v6.0d and MS SQL Server 2000. When one wants to version control their stored procedures, they can do this fairly easily through the VS.NET IDE. As an FYI - If you care - Here is an old sample of how to do this http://weblogs.asp.net/fmarguerie/archive/2003/02/24/2880.aspx ================== Problem: The VSS database has MOVED (in this case, to a different server). Everything involving the SP versioning is now haywire. The problem seems to be rooted in the fact t ...Show All

• SQL Server No grouping?

  Hi to all! To count(something), it is usually required to use a group by function, however, that is not applicable in this case: I would like to select records that have similar values for 'col2' and 'col3', given a certain 'col1', and how many records each 'col1' returns. The following example hopefully makes it clear. The table: Col1 Col2 Col3 ------------------------ s1 A B s1 C D s2 A B s2 C D The result should be: col1 col2 col3 Expr --------------------------------- s2 A B 2 s2 C D 2 I had figured out the not-working-query: SELECT *, count(col1) FROM table as t1 INNER JOIN table as t2 ...Show All

• Windows Forms DataGrid currency formatting

  Based in the examples in TaskVision, I wrote a custom implementation of the DataGridTextBoxColumn that only overrides the Paint method: protected override void Paint(Graphics g, Rectangle bounds,                               CurrencyManager source, int rowNum,       Brush backBrush, Brush foreBrush,     ...Show All

• .NET Development merge two datasets

  hello all, i have 2 datasets. one is filled from the remote database(Sql Server 2000) and the other is filled from my local computer sql server 2000. I want to see if the remote dataset(filled from remote server) has some updated data. If it is so, i want to get this updated data in the local dataset and then update this local dataset to the local sql server at my computer. Please write to me soon. Any other method will also be helpfull to do this task. thanks to all, Hi! If both databases have same schema then dreate two datasets, one for each database. Merge remote dataset with local and accept changes. If at all ...Show All

• .NET Development MD5Crypt in .net

  Hi. I'm working on a project in which I need to use MD5 cryptography. The requirements are vague, but I need to do both: compute the MD5 hash of a string and perform the MD5Crypt function on the string. I know that class MD5CryptoServiceProvider provides the ComputeHash() function (for the first part). However, I don't think it provides an MD5Crypt function. Actually, I have no idea what the MD5Crypt function is. From what I know MD5 is a hashing algorithm, so am I looking for a MD5 cryptography algorithm I don't think one exists (not under this name). All I know about the MD5Crypt function is that it is a popular UNIX and BSD function. ...Show All

• Visual Studio Problem connecting Crystal Reports after password change

  It seems a lot of people have been having similar issues to this so I'll try to be as precise as possible when explaining my problem. I am working on a web application, a simple "Log In, and select your report"..So I am working on Visual Studio 2005 Beta 2 and had absolutely no problem creating the reports or displaying them, that is, until the password I use to log into the database(via ODBC) expired. Once I reset this password none of the reports connect directly, they all display a login screen no matter what I do. It seems this password I had when creating the Reports somehow got hardcoded somewhere in the report itself because no matte ...Show All

• Visual C# Retrieve info from SQL db

  How do i retrieve info from my db I want to create method that validates password which is stored in db.         public bool IsValidPassword()         {             if ( Password == " ") // I need to chech DB for password                 return true;             else                 return false;   ...Show All

• SQL Server How to find how Activation has failed

  I have seen the posting on determining how activation has failed and looking through the system logs is very helpful in determining why activation is not occuring, however, short of looking through the SQL Server logs is there another way to get the same information Access to the SQL Server logs is fairly restricted. Does anyone know another way that this can be done I have used the execute as technique described in the article on "Troubleshooting Activation Stored Procedures" and found it helpful in some cases. Gary There is a profiler trace event for "Broker:Activation" which ...Show All

• Visual Basic Finding Folders

  Well i find files like this: Imports System.IO Imports VB = microsoft.visualbasic 'Gets the files Dim App_Path = My .Application.Info.DirectoryPath Dim desktopDir As String = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) Dim dir As New DirectoryInfo(Path.Combine(desktopDir, App_Path)) For Each file As FileInfo In dir.GetFiles( "*.txt" ) 'end 'takes 4 letters off the end of the filename Dim AMAZING As String = VB.Right(file.Name, 4) Me .ListBox1.Items.Add(Replace(file.Name, AMAZING, "" )) 'end Next So i was wondering if (and how) this could b ...Show All

• Visual Studio Express Editions How do I pass return codes on exit?

  I would like to call a program using Call Shell(), wait for it to finish, then (if possible), collect the data it returns (as if it were a function). My question is, how do I make a program that sends data back when it exits, and how do I make another program that calls this program, then gets the data Environment . ExitCode = MyExitStatus ...Show All

• .NET Development Deploying .NET 2.0 Apps with Installshield

  My Code Project article covers deploying .NET 2.0 Apps with Installshield. Basically, it involves adding a Custom Action to run a script that starts a program to detect whether the target has v2.0 of .NET installed and then runs dotnetfx.exe as required. http://www.codeproject.com/useritems/InstallDotNet2.asp I've supplied full source code + .exe, the script and instructions for adding it to a project using InstallShield X. There's also a sample project. It doesn't handle the problem of installing to a target that doesn't have Windows Installer 3.0 because there doesn't seem to be a way to install Windows Installer 3.0 from anoth ...Show All

• SQL Server NT Login Authentication

  Hello My sql server 2000 is installed on Win2k3 Server and it is located on one of my corporate domains say DomainX. Now i want to add NT user login to the users who are located in a different domain say DomainY. But the SQL Server Enterprise manager lists only DomainX as the domain from where the user logins can be added. The quesion is how do i add nt login users who are not associated with the same domain as my SQL Server. Thanks & Regards Clement Did you find these helpful Opening up trust relationships is of course not necessarily recommended either (depending on your scnerario) ...Show All

• .NET Development confused by generic methods

  Hi, in the code sample that follows how do i get from the MethodInfo object given the variable name 'method' in main (this method takes a string as its parameter) to the MethodInfo object that took the generic parameter in the class MyGeneric (i.e. the MethodINfo that originally described the method) I would guess by using MethodInfo.GetGenericMethodDefintion() but is says this isn't allowed due top the state of the object. I think i would be nearer to understanding my problem if i knew why IsGenericMethod is returning false below when i think it should be true... (IsGenericMethodDefiniton is also false). thanks in advance, c ...Show All

• .NET Development "Child list for field 'Customer' cannot be created".

  I converted my VS2003 app to VS2005 Pro. Everything is fine except that one or two datasets are causing problems. If I run the form in question, the following code is highlighted - ((System.ComponentModel.ISupportInitialize)(this.dsMySalesInvoice)).EndInit(); and the message is "Child list for field Customer cannot be created". Supprisingly, the Customer datatable does not even belong to that dataset. The Customer datatable belongs to an untyped dataset called(CustomerDataSet). I have generated a new dataset for the dataadapters and worked for a while. After making some significant changes the new one is now behaving th ...Show All

• Visual C++ ActiveX control width and height

  I need to find out the width and the height of an ActiveX control. Once the control is drawn on the screen, getting the size is no problem. However, I need to know the size BEFORE the control is drawn, since I need to create a graphics backbuffer for off-screen drawing. (Ideally, in the constructor or the WM_CREATE message handler.) Theoretically, I would just want the values of the WIDTH and HEIGHT parameters of the HTML <object> tag that instantiates the control. Is there a way to achieve this I tried to get the control's extent using the m_sizeExtent member variable and convert that with the AtlHiMetricToPi ...Show All