Pintu Shukla's Q&A profile

• SQL Server How to view status of disabled indexes

  I will be programmatically disabling and rebuilding indexes during my load process. Is there a way, visually or otherwise to check the status of an index The 'is_disabled' column in the sys.indexes catalog view will show a 1 if disabled, a 0 otherwise...just query on the appropriate object name and index name combination, like this: select i.is_disabled from sys.indexes i where object_name(i.object_id) = 'nameOfTable' and i.name = 'nameOfIndex' HTH ...Show All

• Visual Studio 2008 (Pre-release) Nullable columns in database table

  How they are handled in entity class property Thanks I've just see all the options for Column Attributes. I'll add to this post if I have any luck. ...Show All

• Windows Forms Problem refreshing DataTable

  Hello all, Problem: 1. Form1 opens and DataTables dt1 and dt2 are filled through DataAtapters da1 and da2 and SQL Server stored procedures. 2. A new record is added to dt1 through da1.InsertCommand. This is a stored procedure that creates the record in dt1 but also creates a corresponding record in dt2. 3. Because dt2 is now out-of-date da2.Fill is called. 4. An  ...Show All

• Visual Studio Error in installing msdn and VSS in Visual studio team system

  I have installed visual studio team suite successfully.I also have sql server express on my system. When I am installing VSS then I am getting this error In VSS 2005. The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2337. This is only the case with my systems in our software house. When I try to install DVD on other system perfectly (except one more system give same error). I have tried installing both from dvd and harddisk.Stoped all non related services.Deleting temp files but nothing is worked for me. This sounds like two ...Show All

• Visual Basic More Code Snippets

  I was wondering if it was possible to have more code snippets; like; - Open a file and place text in that file in a text box. - Save text in a text box into a file. - Save text in multiple text boxes into a file. - Open a file and place the image in that file in a picture box. - Save image in a picture box into a file. Hi Jason, I think you can do the first three tasks using snippets in the product.  The last two I'll give you the code for.  then you can use the code snippet editor tool that Lorenzo mentions to create the actual .snippet file.  You could be a hero by ...Show All

• Visual Studio problem with connector

  hi, i've got the following definition within my *.dsldd file. the problem is that i cannot connect 'RootFeatureShape' with ' FeatureSetShape' with the ' RelationshipFeatureSetConnector ' in the Designer DebugMode although this allowed within the connector definition. Any Ideas <connectors>           <connector name="DependencyLink">             <color color="blue" />             <dashStyle dashStyle="dash" />        &nb ...Show All

• Visual Studio 2008 (Pre-release) Problems with Extension syntax

  playing with the Linq examples and I am getting a compiler error when trying the extension example. This is not working; public static string CamelCase( this string identifier) The this causes the compiler to indicate a type expected from the demo video this should work.  Any idea what I might be missing. Thanks Make sure you are creating new LINQ project type. File -> New -> Proejct -> Visual C# -> LINQ Preview   If it's not available - then make sure you have IDE support installed (  "Install Visual Studio IDE Support.cmd" ). As well check content of your& ...Show All

• SQL Server How to read parent Package in Script Task

  Hi, In SQL2000 DTS, I set a variable to DTSGlobalVariables.Parent. Then I can manipulate the package. What is the equivalent way in SQL 2005 SSIS Thanks for all the help! TT In addition to Marianne's reply, check out this article for more information regarding the "DTSGlobalVariables.Parent" equivalent in SSIS. http://blogs.conchango.com/jamiethomson/archive/2005/02/28/SSIS_3A00_-Dynamic-modification-of-SSIS-packages.aspx ...Show All

• SQL Server Execute Stored Procs from Management Studio Express?

  Is it possible How do you do it Thanks, Bill ...Show All

• Visual C# How to Save datagrid back to datatable then back to text file

  Does anyone know what is the best way to save changes made to a datagrid back to the datasource so I can save it back to the text file I have an application that reads a TSV(Tabbed seperated file) file into an array then that arrary is stored inside a datatable. Then that datatable is binded to a datagrid. The user is able to make changes to the table but I want to be able to save the changes back to the datasource. I'm half way there I think just saving it back to the datasource is confusing to me. If anyone knows how to do this, id appreciate you help Thanks ahead Chan The Update method of the DataAdapter can be used to ...Show All

• SQL Server print blank page

  i export my report to pdf and its leaving one blank page with every alternative page is there any setting thanks Make sure your layout, pagesize and margins all agree. Also, search this forum. This topic has been addressed several times in the past. ...Show All

• Visual C++ How to change Focus on the DialogBox?

  Hi on my dialogbox focus is on the OK button. I try change this focus with object.SetFocus() but it doesn't work. what should I do I want focus be on another button(like Cancel button). thank. What you mean is not setting the focus, its about setting the CDialog::SetDefID function. With this function you define the button that will be executed by default when the user hits the Enter-key. You can check what button is the defualt button with GetDefID ...Show All

• Smart Device Development WCE 5.0 Test Kit -- Application Verifier Tools Can't Work

  Start Application Verifier from WCE 5.0 Test kit, this tools can't work, the error message is " Unable to enable shim engine on device!", env: vs 2005 beta2, DMA Transpot, Device Emulator manager , WM 5.0 for pocket pc SDK, Emulator is pocket pc phone emualtor, I can execute the drivers test suit,but all the Tools of CETK are work uncorrect, Is it any updtae or patch can resovle this problem A whitepaper was recently released with some information on running app verifier on CE5.0 and WM5.0 based devices. Take a look at the following and see if it helps. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnce50/ ...Show All

• Windows Forms removing item from combobox datasource ?

  Hello, Framework: 2.0 IDE: VBExpress Problem: I have a datagrid that contains a combobox type column. The grid is bound to a datatable. The comboboxes have a value member and a display member. If the user select a value in the combobox on the selected row, then all the list of items in the combobox should be updated so that this item is not shown anymore in the list for the other rows. I've managed to do this using a dataview. Unfortunately, as the item is no longer in the list, locations where it was selected do not show the display member anymore, they only show the value member. How can I do that Does anyone know a better ...Show All

• .NET Development msxml6, xslt and preserving newlines

  Hello, after the upgrade from MSXML4 SP2 to MSXML6 a simple XSLT (performed in C++) does not preserve newlines anymore... I just changed the document instance creation (DOMDocument40 to DOMDocument60) and the #import (msxml4.dll to msxml6.dll). with MSXML4 SP2 my simple XSLT generated the output: alpha bravo charlie now the same code (with just the changes described above) generates: alphabravocharlie what has changed many thanks andrea This is the XML file: < xml version="1.0" encoding="utf-8" > <ArticleList> <Article> <Name> ...Show All