Harjeet S's Q&A profile

• SQL Server SQL Server 2000 Database Limitation

  Hello All, I am currently consulting with a company who uses MS SQL Server 2000 standard. They currently have a software application that they lease (ASP) to clients and host on their own server. Each instance of the application requires its own database. They are currently at 1050 databases on a single database server, but anticipate increaseing their client base to about 5000. To date their administrator has not noted any performance issues with having 1050 databases other than Enterprise Manager taking 10+ minutes to enumerate them (to build the treeview i assume). Using Query Analyzer is lightening fast as usual. Does anyone know if the ...Show All

• Software Development for Windows Vista Multiple workflow/more complex examples.

  Hi, I gone through the labs, examples etc for WWF and whilst they all demonstrate different aspects of WWF, they are all rather simplistic, implementing only a single workflow. What happens where there is more than one For example, in ASP.NET there can only be one instance of the workflow engine per app domain. On page1.aspx, I need to execute some workflow and take action based on the result so I add an event handler, eg: workflowRuntime.WorkflowCompleted += new EventHandler < WorkflowCompletedEventArgs >(WorkflowRuntime_Workflow1Completed); Another page, page2.aspx also executes workflow, so again it seems I have to h ...Show All

• Visual Studio Express Editions DateTimePicker - non-English characters

  I have a small program where in one element the user selects the date from a DateTimePicker control. This date is then used as part of a file name in the format "23May2006". Recently the program was installed on a PC that had Chinese language Windows XP installed and the month part of the date was changed into what I assume were Chinese characters. Does anyone know how I can force the output to remain in 'English' characters. The reason for this is that the file produced is transferred to another machine where the date is parsed from the file name (and it falls over when it encounters the non-English characters!). Thank ...Show All

• Windows Forms Strongly-typed DataColumn change events

  The DataSet Designer in Beta1 produced strongly-typed DataColumn change events, event args, and event handlers. These seem to be gone from Beta 2. Are these gone permanently Hi JJ, Yeah, we decided to remove these as they didn't add they much value compared to the amount of code we had to generate.  You can see more detailed info about DataSets going on a diet at: http://blogs.msdn.com/vbteam/archive/2005/01/12/351495.aspx There's lots more info about this and other stuff at: http://blogs.msdn.com/vbteam/archive/category/4754.aspx And our new team blog is at: http://blogs.msdn.com/smartclientdata/default.aspx Steve Lasker Progr ...Show All

• Visual C++ Simple prblem with VS.Net 2005 Intellisense

  I keep having problems with the intellisense (IS) not working properly. That is, say I have a class Foo and I declare a variable Foo f; When I try to get the intellisense to start working by typing f. nothing comes up. To reporduce the problem in a simple setting here is what I have done. Create a new project, add a new class Foo. Now add a new member function to the .h file and call it OldFunction(). Problem 1: Click over to the Foo.cpp file and type void Foo:: and the OldFunction() does not appear in the IS list like it did in 2003. Problem 2: Now in your _main function declare a variable Foo f; and the OldFunction that you have j ...Show All

• Smart Device Development Blank IO Exception

  Hi. I'm trying to write to a serial, COM, port on the mobile device. using .NET 2.0 here and WM2005. After months of trying to find out, I found out a couple of ways of doing so. Yesterday I tried the serialport class, unfortunatly when it writes to the serial port, it gives me a blank IOException - no idea why. The COM port is 3 and is enabled in the system settings by default. Next step was to go low level stuff - so I imported coredll.dll so I can use CreateFile(). I seem to be getting a handle, cool! But I guess its a limitation - if i want to give that handle to .NET using the FileStream class, it doesnt have it in the . ...Show All

• Visual C# why i=i++ is undefined and have very strange behaviour

  hello i having problem with this code int i=10; i=i++; console.writeline(i); //it is printing 10 at console why not 11 please tell me the details of compiler I believe the answer that you are getting is correct. You are assigning i to i then incrementing the original value of i by one. The value that is assigned is 10. if you were to change your code to read the following then you would get 11. int i=10; //actually all that you would have to do is ++i // or you could change your code to read just i++, which would also give you 11 i=++i; console.writeline(i); ...Show All

• Windows Forms showing item text in checkedlistbox

  Dear all,      I have a checkedlistbox which "multicolumn" property set to true. When the bind dataitem is having a lengthy content, it will be cutoff. For example: the data which is having "Perth-Western Australia" is being cut and only showing "Perth-Wes". I am thinking of creating a tooltips like control to show the full content& ...Show All

• Visual Studio Team System Rename TFS Server

  The Team Foundation Administrators Guide has a section titled "How to: Rename the Data Tier, Application Tier, or Active Directory Server or Client", but there is no content in it yet.  Anyone have any success in doing this   Is there a tool to be used to facilitate this, or do you need to edit configuration files by hand.  If the latter, does anyone have a list of the files that need to be edited Yes this is B3, but I was refering to the fact that the documentation is late or non-existant in places. Yes, TfsAdminUtil does ship (on the AT) with B3. ...Show All

• SQL Server SqlConnection does not support parallel transactions.

  hello i have a problem when i try to begin transaction in sql this is the massege "SqlConnection does not support parallel transactions." but the connection dosent have another transAction what can i do thanks i found the problem i forgot close the connection before reusing so be sur to close all the connections because it stay in the bool with the transaction ...Show All

• Visual Studio Unistallation help required

  I am unable to complete the uninstall process of visual studio 2005 beta 2. can any of you give me some guidence to complete the process of the same. i have uninstalled all the products from my control panel other than the visual studio 2005 beta 2 english version. i used some of the utilities which i found in the same site to complete the process even though i am not able to complete the process. some one please guide me to complete this. Thank you. You can also try the updated clean up tool at: http://go.microsoft.com/fwlink/ LinkID=47598 ...Show All

• SQL Server INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstring + "service_request, store_number_senditem, register_number, street_address" cstring = cstring + "city, state, zip_code, area_code, phone_num, product_desc, service_center" ...Show All

• Microsoft ISV Community Center Forums Vba commands used to connect to sql

  HI, Use the FileSystemObject... Sub OpenTextFileTest Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile( "c:\testfile.txt" , ForAppending , TristateFalse ) f.Write "Hello world!" f.Close End Sub ...Show All

• Visual C# datagrid view real NOOB

  Hi i never used the datagrid. As i see in this forum and others the datagrind has most questions but il put a simple one How to fill a column from a datagrid view Hope is easy, and i would apriciate a good tutorial (BTW forgive my english) Thanks!! Well to resfresh the datagridview is quite easy. All you do is type: dgvname.Refresh(); Now as far as the progressbar goes it's quite simple as well, but it all depends on what you want the progressbar to show... Updates, Deletions, or Pulling in data into the grid and if updates how you are updating your info. But basically there are events placed inside of the datagridview such ...Show All

• Visual Studio Team System June Beta 2 compatibilty with team fundation july CTP...

  Hi, Is it possible to connect to team system server july CTP with a Visual studio beta 2 client Is it also possible to connect a July ctp client to a beta 2 team fundation server Alain Martineau Publishing Business System For more information about upgrading from Beta 3 to RTM, see Soma's blog: http://blogs.msdn.com/somasegar/archive/2005/08/22/451026.aspx ...Show All