Shiby's Q&A profile

• SQL Server Change included columns when modifying table

  Is there a reason you can't modify included columns when modifying an index on a table Well, the primary reason would be due to the fact that adding additional included columns would touch all of the leaf pages in an index, and probably force a fair majority of pages to split multiple times, so in reality most of the time recreating the index from scratch would probably be faster and more efficient once completed. Additionally, a heavy heavy number of disk seeks would be incurred jumping from the position last updated in the index to the table data to read the data to be added and then jump back again. Basically, I'm sure you'd fin ...Show All

• Visual C++ convert int to string

  Hi, I want to make the following code work but I can't find a method to convert the int to a string.  Any ideas   string ErrorMessage( int intRec, string strKey){    return (DateTimeStamp()+ char (7) + "Record number" + char (7) + intRec+ char (7) + " contains an invalid Key:" + char (7) + strKey+ ".\n" ); } char(7) is typecasting the value 7 to some unprintable character, and there is no overloaded + operator on std::string that handles character operands. You need to use the itoa function, but when you do so you have to provide a separate buffer in which to do the conversion.  ...Show All

• Visual C# Unrecognized configuration section 'connectionStrings'

  Hello ,can someone help me in the following :  I have some pages that have been created with VWD express but when I try to test these pages with Dreamweaver or when I upload these pages on to a Host provider I get the following error message: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Unrecognized configuration section 'connectionStrings' Source Error: Line 10: <configuration> Line 11: <appSe ...Show All

• Windows Forms Weird - Applying visual styles!

  I used the application.enablevisualstyles method when using dotnet 1.1 with xp pro. I have set the control property FlatStyle to System where necessary. When I execute the application, no effects are visible and it appears with the standard (non XP) look. But when I run the application exe from another machine it works fine and does rendering and everything. I&n ...Show All

• SQL Server for loop container to process all Excel files

     I'm having a problem getting the for loop container to process all excel files in a folder.  I set the collection folder to where my .xls files are, and i set a variable in the for loop container to the FileName.  I then changed my source connection and added expressions for ConnectionString: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=" +  @[User::ExtProperties] (the ExtProperties was necessary to get the double quotes in.  ) ServerName: @[User::FileName] It cannot connect.  I used a similar process to loop thru Access .mdb files, but did not set th ...Show All

• Windows Forms custom scrollbars

  Is there a way to design custom scrollbars with custom colors that can be attached to any control. ...Show All

• Windows Forms changing row colors in a datagrid

  Hi Everyone I have a small prob that I hope someone can help me with I have a datagrid which has various appointments on it - what I want to be able to do is change the color of the row depending on whether the date of the booking is for today to reminder the user Does anyone know how to do this as I am stumped Thanks  ...Show All

• Visual Studio File difference from command line

  Hi, I am writing a script and I want to do the following: Whenever I run the script, I give the VSS project and the filename as an input. I want to diff the most recent version of the file against the previous version of the file. (The version numbers keep changing. So I do not want to hardcode the version numbers inside the script). Any pointers Thanks, Karthik You may want to consider writing a simple program using IVSS http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvss/html/msdn_vssole.asp Here is how to start: Imports Microsoft.VisualStudio.SourceSafe.Interop ...Show All

• Smart Device Development /GR- cl.exe option causes WM_INITDIALOG not to fire.

  Project->Properties: Configuration Properties/C++/Language: Enable Run-Time Type Info = No (/GR-)  causes WM_INITDIALOG not to fire when invoking DoModal() for a dialog instantiated from within OnInitialUpdate() of a single document MFC application (i.e., from within OnInitialUpdaet() for a subclass of CView). Compiling with /GR does not produce this problem. To reproduce this, use VS2005 to create a single document app, use the IDE to add OnInitialUpdate() to your CView subclass, create a test dialog, instantiate and invoke DoModal() for the test dialog from within OnInitialUpdate() for the CView subclass. Build using /GR- and inv ...Show All

• Windows Forms Class Event triggering a method on a Form...

  Hi all, i have a Class that handles Barcode scanning functionality, and a Windows Form that contains an instance of this Barcode class. One of the Properties of the Barcode Class is an Event, which is triggered when the user executes a successful barcode scan. What I want is to be able to somehow call a method belonging to the Form from within the handled event that sits in Barcode class. How can I do this The extremely watered down code is below... // Barcode Class class clsBarcodeScanner { // Declare and initialise EventsHandlers. private System.EventHandler MyEventHandler = null; private bool InitReader() { ...Show All

• .NET Development System.Data.OleDb.OleDbException: Unspecified error

  I am facing one problem while trying to open connection of Oledb Data for microsoft Access database. error description is given below....please help me i m trying to find solution for last one week but yet i haven't solve this problem. Line 173: 'Try Line 174: Line 175: Cn.Open() Line 176: Line 177: OlRdr = OlComm.ExecuteReader Stack Trace: [OleDbException (0x80004005): Unspecified error] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +203 namanassociates.UsersDetail.CheckUse ...Show All

• Windows Forms Control Box

  Hi Stefano, Thanks for the trick about backGround image I will try to use this trick in my work. I have a question: How can I disable only the C loseBox of a ControlBox of windows form and keep the MinimizeBox and MaximizeBox enabled Previously thanks. Here is the code that will help you achievw what you want to do- public class FormCloseButtonDisabler { private const int MF_BYPOSITION = 0x400; private const int MF_REMOVE = 0x1000; private const int MF_DISABLED = 0x2; [ DllImport ( "user32.dll" , EntryPoint = "DrawMenuBar" )] static extern Int32 DrawMenuBar( Int32 ...Show All

• Visual Basic How do I get list of pc's in Active Directory

  Anybody have some sample code to query the computers in Active Directory on a domain I would like to build an array from a list of computers within Active Directory. I am building an application that checks for existing files on computers on our network to tell me whether a particular program was installed or not. Thanks, Arkman5 to get started with, read about DirectoryServices. it cannot be imported by default using Imports System.DirectoryServices so you should add a reference to it in the solution explorer. from there you can play around the DirectoryEntry Class. ...Show All

• Windows Forms using IndexOf()

  I'm trying to do a quick search on a string array. I'm using IndexOf() but I'm not getting the desired results. I've tried two ways, the first I thought should work, the second is just to prove to you I don't know what I'm doing. private int CheckIsDate(string ColumnName) { string strDate = "Date"; int position = strDate.IndexOf(ColumnName); return position; } private&nb ...Show All

• Visual Studio Express Editions Visual Basic Express won't install.

  I recently tried to install the VB express edition. I went through all the agreemetns and such,but when it came time to install, it wouldn't. It has done this on several occasions. it will being to install but then stop and says it cannot be installed. It gives me no error messages or anything. It just says: "The following item could not be installed: Microsoft .NET Framework 2.0." Anything I could do   What version of VB express do you have Is it a beta version Have you have ANY .DOTNet software running on your system prior to this attemtped installation Look in <sysdevice>:/windows/microsoft.net/framework Do yo ...Show All