Pankaj Sabnis's Q&A profile

• Windows Forms Starting processing after form-load

  How can i get proccessing to begin after the form has displayed  If put in the Form_Load sub it waits till after it has finished before displaying the form. If you being processing something after the form has been shown then  ...Show All

• Windows Forms combo box requirement

  Hi, My requirement with combo box is like this. When focus comes to the combo box then only it should display drop button, when the focus looses It should just display like text box. Thanks for the advanced help. Regards pavan kumar Hi Omerkamal , The solution which you have given is working fine. But I am using Enter event rather than GotFocus event, because when I click the combo box using mouse, the Gotfo ...Show All

• Visual Studio Team System sqlservr memory usage at 2GB

  I was just poking around on our TFS server investigating some unrelated issues, and noticed that sqlservr is using 2GB of memory (1GB physical, 1GB virtual), while msmdsrv is only using 225MB total (113MB physical, 114MB virtual). This machine has 2GB of RAM on it, and Task Manager shows about 450MB "Available". From the backups, it looks like we only have about 160MB of data (TFS dbs+reporting+STS). We have about 5 users using this machine. Is ...Show All

• SQL Server Behind the Scenes SQL commands

  Hello, I am running SQL 2000 SP4 on a Windows 2003 standard edition server. The SQL database gets changed/updated through a web interface. I was wondering if there was any way for me to see which SQL commands were being run on the database when changed like deleting/inserting users are being applied from the Web frontend Any help is appreciated, thanks. Robert Take a look in Books On Line at usi ...Show All

• SQL Server SQL Server Management Studio Express CTP - not working

  The SQL Server Management Studio Express CTP application is not working anymore after having done so for a day. No messages, nothing when I double click the icon. Everything else seems to be working OK. I have tried a de-install and reinstall with no success. Some of you who know where to start looking Regards TorB. Sorry for making a new tread. The matter is solved in another tread here. Regards TorB. ...Show All

• Visual Basic Can Classes be used to include or display UI as well or just for code and functionality

  I wonder if it s good development habit to use classes to diplay and collect data from users Thanks A form is a class as well. But you don't put UI-logic in you data classes for example, if you have a class that manipulate data in the database, you should not use UI logic there. You need to sepperate these things. ...Show All

• Visual C++ CWind::Invalidate Problem

  Hi, I have a dialog box that allows you to enter text, when you press 'ok' the window underneath, from which the dialog box came, is updated with the new text.  Fairly straigh forward stuff.  However when you enter into the dialog box the '&' sign followed by anything else, it removes the & sign and underlines the next character in string upon clicking 'ok'.  To my knowledge the string is not actually altered because ...Show All

• Visual Studio Team System Custom rule for investigating a switch statement

  Hello I've been playing with custom rules for the last couple of weeks. In one of my rules, I'd like to investigate switch statement for the existance of a default case. I wish to obtain a list of cases within a switch statement. I investigate instruction lists of a method, but all I can find are elements with a 'switch' OpCode. Do you guys know how can I do it Any suggestions are welcome. Regards, Luke ...Show All

• Visual FoxPro empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike Where EMPTY(field1) This will work for all data Types. If you want to check every filled you will need: Where EMPTY(field1) or EMPTY(field2) or EMPTY(field3)... if you want some ...Show All

• SQL Server calculated sum

  I have a dataset that returns a measure and a bunch of dimensions. What I need to be able to do is calculate a sum of this measure based on one dimension. ie.. Sum(measure) where dimension = "Top". Any ideas on how to accomplish this. Not sure if this solution will work for you, but you can add a Calculated Field to the Data Set, say: "FilteredQty", defined as (assuming Quantity is an integer): CInt(iif(Fields!C ...Show All

• Visual Studio Team System Using Team Build to Publish WebSites

  I have followed the useful blog http://blogs.msdn.com/nagarajp/archive/2005/10.aspx  to build and publish my website to a remote iis machine and it works great. What I also want to be able to do is Publish websites from previous builds - say for example the latest build is found to have so many bugs that we want to regress to the previous build of a known quality. What is the best way to attack this Create some sort of batch file on th ...Show All

• Visual C# parallel to an ActiveX control or Applet in C#

  Hello, I wanted to know how to build an application in C# that is parallel to an ActiveX control or Applet i.e it should be able to run on Internet Explorer. Thank You. using windows.forms controls in internet explorer WM_FYI thomas woelfer ...Show All

• Visual Basic Radio Check Options in Menu Strip?

  First off, I'm completely new to the world of Visual Basic. I took a little break from programming for about 20 years :) What a change... and THANK GAWD! I'm trying to keep current in my studies and am using VB.NET 2005 beta 2 at the moment and training with App Dev's VB .NET course... I've got the basics down, nagivation, understanding of objects, properties, etc... but for the life of me, i can't find what i'm looking for... and what I THOUGH ...Show All

• SQL Server Linked Server slow query return

  Hello can some one explain this to me and give me some advice. I have sqlserver1 and sqlserver2 I have a linked server set up [ipaddress] on both servers. When I pass a variable to the stored proc or the query it takes up to 20 seconds to return 1 row but if I replace my varibles like email='sqlboy@coxnet' and firstname='ted' and lastname='clien' it returns the one row im looking for in about 2 seconds but if I pass email =@email ,fname=@fname,l ...Show All

• Windows Forms files location

  This is for a windows.forms application that supports multiple users. Here each user's personal preferences are to be stored within their own "user folder" ( C:\Documents and Settings\%user%\somewhere ) is what i had in mind. I noticed that most big software companies use a certain "application data" folder within each user's section. Preferrably this software should follow the practice - but so far I haven't seen any ...Show All