SiraB's Q&A profile

• SQL Server SMO: size of columns in a table?

  Using VS.2005 I wrote a program that loops through all databses on a server, all tables in each database, all columns in each table etc....Here's an excerpt... For Each MyCol In MyTable.Columns MessageBox.Show(MyCol.Name) MessageBox.Show(MyCol.DataType.ToString) ' e.g. nvarchar but nvarchar ( ). What's " " .... But I can't figure out how to determine the length of a field. (This info is readily available in E ...Show All

• Visual C++ I have a problem with SetDlgItemInt

  int a; void CCALCULATOR01Dlg::OnBnClickedButton1() { // TODO: Add your control notification handler code here GetDlgItemInt(IDC_EDIT1, &a ,TRUE); SetDlgItemInt(IDC_EDIT2, a ,TRUE); } In VC++ When i compile it 1>------ Build started: Project: CALCULATOR01, Configuration: Debug Win32 ------ 1>Compiling... 1>CALCULATOR01Dlg.cpp 1>Linking... 1>Embedding manifest... 1>Build log ...Show All

• Visual Basic Connecting to Different servers

  I am writing an application (VB 2005.net) that will be installed on different sites; hence the Connection string needs to change depending on the location. How can get the application to change the connection string that have been setup in the Project /settings when developing the application, to a different connection depending on the Location i.e. different SQL server EG developed on Myserver\dev need to be run on newsever\prod or ol ...Show All

• SQL Server sql 2005 express install problems

  I have been trying to install SQL 2005 express on Window SBS SP-1. i keep getting a setup error when i run the installer.  error is 1601 the log dump is: === Verbose logging started: 1/04/06  20:19:41  Build type: SHIP UNICODE 3.01.4000.2435  Calling process: C:\WINDOWS\system32\msiexec.exe === MSI (c) (10:18) [20:19:41:383]: Resetting cached policy values MSI (c) (10:18) [20:19:41:383]: Machine policy value 'Debu ...Show All

• SQL Server 2005 April CTP Install Failure

  SQL Server Setup could not conect to the database service for server configuration. The error was: [Microsoft}{SQL Native Client} Named Pipes Provider:  Could not open a connection to SQL Server [2].  Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log File" in SQL Server Books Online. That is the error when attempting to install to W2003 run ...Show All

• Visual Studio Team System FxCop Custom Rule: To check for variable name

  Hi, I am trying to check if variables declared inside functions follow coding standards. I have implemented the code to check for Boolean variable. Variable name must start with 'b' public override ProblemCollection Check(Member member) { if (member.NodeType == NodeType.Field) { //Local local = list ; Field field = member as Field; if (field != null ) { //type = field.Type.ToString(); if (field ...Show All

• Software Development for Windows Vista [XPS] Query on PrintFilterPipelineSvc service

  Hi XPS Team, One of the PPTs (Filter-based_PrintDrvs.ppt) from MS XPS website has the info given as below. Service: PrintFilterPipelineSvc NT Authority\Local Service Normal non-admin user SeImpersonatePrivilege SeCreateGlobalPrivilege SeChangeNotifyPrivilege Controls Filter Creation and Communication Scheduler Inter Filter Communicator Property Bag Handle notifications from / to spooler We were able to find this exe call ...Show All

• Visual Studio Express Editions 'char *' into 'LPTSTR'

  how to convert 'char *' into 'LPTSTR' It depends what you are trying to do. Go to the Visual C++ 2005 Help | Index and search for "wide characters". That page and others will give you information about moving between wide characters and narrow (single-byte) characters. If you know that you are doing Unicode, then use L"..." strings and L'...' characters. To make storage and arrays of ...Show All

• Visual Basic Visual Basic and graphics - for the novice/beginner

  Hi there I have no training in programming, but would like to start writing my own little programmes. In my work (civil engineer), I am increasingly frustrated by the lack of simple, time saving programmes to make my life easier, and hence the urge to write my own programmes. Of course, the start will be no more than programmes for one-off formulas, but having said that, I would like to (in many year's time) be able to write more complicated ...Show All

• Visual Studio Express Editions System.IO Namespace in VS Express

  Is it possible to use the system.io namespace in VS Express and if so how I want to be able to use directoryinfo in my app to populate a dropdownlist with file names from a specific directory. Thanks! Duncan http://www.programmersheaven.com/2/Les_VBNET_15_p1 Ed ...Show All

• Microsoft ISV Community Center Forums Calling procedure upon deactivate

  I am using the following code which gives me a run time error 1004 "Select Method of Range class failed" when the yellow line is executed from the worksheet_deactivate procedure. However, the code runs fine when executed directly from the Save button. This code is located in the Item Entry worksheet module. Can someone explain why and how to get this code to execute. I am guessing it has to do with the worksheet being deactivated. However, by de ...Show All

• Windows Forms Generic ComboBox<T>???

  Is there a way to create / get a combobox that will only accept items of a specified type thereby negating the need to cast from Object I tried creating a subclass of ComboBox but that didn't seem to work as Items is a property instead of a method and is not virtual. That's what I was afaid of. I will give it a try with a simple one. Thanks. ...Show All

• Visual FoxPro Dear Visual Foxpro 9...

  Dear VFP 9. Although I have known your great grand parents Foxpro and Foxbase, there is still much to learn about you. Its a few months since we met for the first time, and I was wondering if I can ask you a few questions about you. I am sure we'll have a much better relationship once I know the answers... - When I use incremental search in your combos, is there a way for you to avoid stopping the search when I use the space bar ...Show All

• Software Development for Windows Vista how

  Please explain the steps of windows sdk installation and usage. I know that I have to burn it to a dvd, but that is as far ans I can get. -Ben Go to http://www.microsoft.com/downloads/details.aspx FamilyId=13F8E273-F5EA-4B7B-B022-97755838DB94&displaylang=en Either click to download the setup.exe and have it run installation, or download the ISO If you download the ISO, follow the Instructions, ...Show All

• Visual Studio Team System IServiceProvider Error after getting reloading project

  After getting latest on the project (through the h.exe get /recursive option) the project tries to refresh itself (After clicking reload).  First of all, this reload step is taking anywhere from 5-10 minutes (just to reload the project into the Visual Studio environment). In any case, sometimes during the reload process we receive the following error: "Unsupported Behavior Warning IServiceProvider::QueryService was called on a background th ...Show All