Praveenkmenon's Q&A profile

• Visual Basic SQL Select Statements for database

  I have a database that contains Zip Codes and Cities. The Zip Code is the primary key. I am using VB .Net 2003 and Access 2003 for this project. I want the user to be able to type in a portion of a city name and the program to display in its datagrid all the cities that begin with the string the user typed in. My code looks like this: Private Sub btnZip_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt ...Show All

• Smart Device Development How to increment time picker interval in CF2.0

  Hi: I find out today we can use the new control in vs2005 date/time picker to set it as a time picker ( spin box ) by change it's Format poperty to time or custom....which is great. But what I want is I can able to set a increment interval like the numricUpDown control... Does any one know how to do that I try inherit and override the onValueChangeEvent but seems quite difficult find out is there on button up or down, any suggestion wil ...Show All

• SQL Server Running a LIKE statement when searching for a date field...

  I am trying to run a like statement that has a datetime column and for some reason it does not return any values. I looked in the SQL help files and in states in there that when trying to select using a datetime that the preferred way of doing it is using a like statment. Does anybody know a better way of doing this Here is my example: (I have dates in this column ie 2006-02-13 11:30:54.220) SELECT * FROM workorderhistory WHERE wh ...Show All

• Visual Basic REGEX

  Please help me find regular expression for wild character match. Say the regex should return true or false depending upon the validated expression. USA --> IsMatch("US*") should return true USA --> IsMatch("U*") should return true USA --> IsMatch("*A") should return true USA --> IsMatch("*SA") should return true USA --> IsMatch("*A*") should return true USA --> IsMatch(&q ...Show All

• Visual Basic DAta Sources Toolbox functionality reversed

  When I am looking at a code window all of my data sources are visible in the data sources toolbox. When I am looking at a form, the toolbox is empty and greyed out and no options can be accessed. This is exactly opposite from how it worked in beta 1, 2 and RC1. Anyone know what the deal is with this As of right now I cannot drag/drop a table onto a form because all the tables are hidden when I am looking at a form. Thanks, Josh ...Show All

• SQL Server Encryption and database restore

  Hi Can anyone help I have a database using encryption with symmetric keys created using asymmetric keys. I backed up this database and restored it on another machine along with the service master key. I can read the encrypted data fine. But all the encrypted stored procs that are associated with the application that uses the data cannot read the data, they just return Nulls. If I regenerate all the encrypted stored procs from scri ...Show All

• SQL Server Custom source adapter UI

  I am currently writing a custom source adapter that extracts data from a JD Edwards OneWorld system. In the custom user interface of the source component I need to allow the user to set a query (a custom property), and then refresh a list of output columns that will be extracted based upon that query (similar to the list shown in the advanced editor). My question is, can I apply the custom property change to the component and build my output ...Show All

• Visual Studio Help disabling Just-In-Debugging

  I installed .net 2.0 yesterday and now Just-In-Time Debugging has taken over my apps I work on outside of VS.net. I have followed all steps I have found to disable JIT with no results. So then I uninstalled 2.0 and reverted back to 1.1. Still, the JIT dialogue pops up. The pages I am working on are classic asp pages and the last thing I need is these JIT popups. I have been unable to find any information beyond the checkboxes in VS.net. Could an ...Show All

• Visual Basic ActiveX Web Browser - Is this possible?

  I was wondering if someone could tell me if the following is possible, and perhaps set me on the right track: Create an ActiveX Web Browser on a form, navigate to a certain page, programatically click links on said page, programatically manipulate a drop-down box on the page, programatically click a button on the page, capture the pop-up web browser which comes up and parse the data from that browser. I would be most grateful for any help I mi ...Show All

• SQL Server Remote Connection problem on MS SQL 2000

  Hello, First, I want to say I read all threads similar this thread and I couldn't solve problem. My firewall is always off when I tried to connect remotly to SQL Server. I opened 1433 port from my router's configuration page and forwarded it to 10.0.0.4:1433. When I started SQL Server service and checking "netstat" with "-na" paramters. It shows only one row as "TCP - 0.0.0.0:1433 to 0.0.0.0:0". What "0.0.0.0" means and why foreign ad ...Show All

• Windows Forms Tip: use Reflector!

  Hi all, I wanted to share another great tool with all of you. I'm sure many of you use it already, but I have also seen quite a few people that are not familiar with it yet: Reflector ! It is my number one .NET tool, especially when using WinForms. Using Reflector you can disassemble executables and DLLs. It does a very good job and comes up with readable Delphi, C# or Visual Basic code (and IL, but I doubt whether IL code is readable for ...Show All

• Visual Studio Team System Can a build in VSTS been deleted?

  In VSTS, under Team Explorer, I build some builds. And now I want to delete them. Is there any method to make this happen Thanks a lot! Leon 1. If you just published it from IDE, you can select the pulished run in the publish view of Test Result UI and click Delete button 2. At any time if you want to delete a published run, you can go to the Team Explorer -> Team Project -> Team Builds -> Build Type -> and open the bu ...Show All

• Visual Studio Express Editions Custom controls

  Is it possible to write custom controls in VB Express Edition Also, if it is, how do I add the custom control to the Express Edition IDE Thanks, hi, Blair i'm sure you know what i mean , i don't ask you to stop saying your opinion i just talk about the way you express it ( sux, dog ... etc) i used to feel offended from that and i'm sure many others as well do you remember one of our friends used to refuse this way b ...Show All

• Visual FoxPro Windows Service

  How create Windows Service in VFP 6 To run a VFP application as a service you need a helper application like SRVANY.EXE from the Windows Resource Kit. However, VFP 6 is not the most suitable version to do this. While you can turn a VFP 6 EXE into a service, it's very difficult to make it run stable, because VFP 6 was designed with desktop applications in mind. VFP 9 is much better in this regard. ...Show All

• SQL Server Is it possible to have sqlcmd connect to local sqlexpress without a parameter?

  (SQL Server Express 2005) sqlcmd will connect to the local SQLExpress server just fine if I give the -S parameter: SQLCMD -S .\SQLExpress but is there any way to have it default to that so I can just say: SQLCMD Thanks, dwh They probably have a default instance installed. If /S is not specified, SQLCMD will try to connect to the dedfault instance.  When installing Express, choose Advanced Options and ...Show All