omniscientist's Q&A profile

• SQL Server online index rebuild and update statistics

  Hi .. Please advice whether i have to do update statistics along with Index rebuild (online /off line) Thanks in advance This depends on the traffic on your DB. IF its an OLTP/heavily used DB you might keep this for off peak use. Your Index scripts could be scripted to either update or do not update stats. You dont *have to* update stats. Its optional. But generally its good to keep updated stats. Again, depending on your Db size and usage, you can turn Auto Statistics ON or OFF. ...Show All

• Visual C# adding name to the row and column of datagridview in windows c# application

  hi, how can i add name to the row and column of a datagridview in a windows c# application through dataset. actually i want to creat the matrix view using dataset. can anyone help me out thanks & regards Isaiyavan Babu Hi again, now how will i do it with asp.net gridview as i tried with the above codes but i received the error : " index out of scope" thanks & regards Isaiyavan ...Show All

• .NET Development DDL for Replication ID?

  Hello, I am trying to execute a DbCommand that will create a table in MS Access. And I cannot find the syntax for creating a column that has a guid datatype. In Access (when designing the table), you create a number column then change the field size to Replication ID. I am issuing a string with the DDL in it, so it looks like: "Create Table Bob (ID int, Name Text(10))" In the table above, int and Text are datatypes. But I cannot find the keyword for a guid or Replication ID. Thanks! Bob ...Show All

• Visual Basic property as combobox in VB.NET

  Hello I'm trying to add property as combo box in my user control Everything works but i don't know where i could add items to this combo box or maybe i do it wrong way Any advices please <Browsable( True )> _ Public Property GrowLimit() As ComboBox Get End Get Set ( ByVal value As ComboBox) End Set End Property It sounds like you want to add a custom property on your user control which will appear in the property browser as a drop down box with values you select. To do this, create an Enum with the values you want to appear and make the property that type. Below is a quick code sample: Public Enum LimitType BigInt SmallInt End Enum Public Class SubclassedT ...Show All

• Software Development for Windows Vista The Windows SDK for Windows Vista is available for download

  ISO Install: http://www.microsoft.com/downloads/details.aspx FamilyId=7614FE22-8A64-4DFB-AA0C-DB53035F40A0&displaylang=en Web Install: http://www.microsoft.com/downloads/details.aspx FamilyId=C2B1E300-F358-4523-B479-F53D234CDCCF&displaylang=en A lot of people from all over the greater Windows organization have spent years (literally!) creating great content for the Windows SDK Team to bring together for our developer customers. Hi Jason I believe.net framework 2 SDK was available on a low cost disk. Will .net framework V 3.0 SDK be available on low cost disk If yes, when and where can I get it in Autsralia and how much. Ta mate. ...Show All

• Visual Basic csv to array??

  I am new to .net programming so please bear with me if I seem like I don't know what I am talking about, because I probably don't. I used to play around with vb6 but never did any thing more than a few exercises from a Learn vb6 book. I want to read a csv file into something. I was thinking an array, but after searching the forums, I see TextFieldParser, Collections, Generic Collections, DataGridView, etc... I really don't know what all of this stuff is and would really appreciate some help. What I need to do is read in data from a csv file. (I started by using the StreamReader and am able to read the file line by line). The file is in the format of <Record Number>,<Date> <Time>,<0,1 or Null>,<0,1 or Null&g ...Show All

• Visual Studio Team System TFS server failure, Error after installing TFS Service Pack 1

  Hello, After installing TFS Service Pack 1, and the required prerequisite KB, on both our data tier and application tier Team Foundation Servers, I can no longer connect to source control (!!). Needless to say, this is VERY VERY VERY BAD. Did I mention that this server contains all the source code at our company I'm going to continue desperately troubleshooting this tonight as late as I can, but any help anyone can provide in the meantime is sorely appreciated. The error I get is: TF30059: Fatal error while initializing web service Information in the Event log: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administr ...Show All

• Visual C++ Ignore include directory in Release mode

  I'd like to ignore some specific files included in a project in release mode. I've already used #ifdef _DEBUG, but that still creates library objects for all those files in the Release folder when it builds. I'd like to completely stop it from reading those... Is it possible, or is there a better way I have cppunit included in my project, so i created a large number of test fixture classes, that I essentially dont want to build. It chocks up my Release folder with X.lib, X_test.lib, Y.lib, Y_test.lib etc etc etc. If it didn't build those classes I would be berry happy... If you want to skip a cpp file from building right click that file in solution explorer, select Properties, General, set Excluded From ...Show All

• Visual Studio BUG: Missing deployment project throws message box even when running command line

  I've been having a problem where sporadic GUI pop-up messages from devenv are stopping my builds, and I think I tracked down the issue: If you run devenv to build a solution file from the command line, and if that solution specifies a deployment project that does not exist in the file system, then you will get a GUI message saying "Unable to open project 'blahblahblah.vdproj'". Obviously this will halt your build scripts, and if you have a headless build machine like I do, then you are really stuck - only way to get around it is to end-task on devenv.exe. I am using: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.50727.4200) Microsoft .NET Framework Version 2.0.50727 Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM. ...Show All

• Visual Studio Team System Performance Problem #2

  We've got a project with 3200 objects. The project contains about 10 errors. When we attempt to double-click on one of the errors to bring up the file, Visual Studio will hang for anywhere between 3 and 10 minutes. The Task Manager shows 'devenv.exe' consuming about 90% of CPU resources for this entire time. We're using the RTM version of DBPro. Amos. Amos, What are the error numbers of the 10 errors Also how much memory do you have on the machine Is this project under source control If so did you try the same when it is not under source control or using manualy check-in check-out instead of automatic Thanks, -GertD ...Show All

• Visual C++ Migrating Visual C++ 6.0 project to Visual Studio 2005 --> Form Designer does not work

  Hi there! After migrating my Visual C++ 6.0 (MFC) project to Visual Studio 2005, I'm not able to open or modify any forms by using the form designer. I can compile the application without major problems (only some warnings about deprecated code, sprintf, etc...) and the program can be executed correctly. I can edit every source code file, but I can't see any chance how to modify a form or dialogue by using the form designer or any other graphical tool. I have simply opened the Visual C++ 6.0 project within Visual Studio 2005 and then agreed to convert the project file to the new version. There was no error message or warning. Any ideas Many thanks, Markus Thanks a lot for that! Looks like I ...Show All

• SQL Server Few Questions

  Hi, I have few questions about SQL Server, let me mention here.. How to generate XML File from SQL Server Is there anyway can we generate directly from Query What are Temporary tables (Regular & Global) and where do we need them in Real Time What are BCP Statements where do we need them How to pass XML Document to Proc, and insert the data, any example Types of Triggers Shink data, what is that What T-Read, Uncommitted read What is Replication Thanks Seshu hey this is not few... hahaha How to generate XML File from SQL Server Is there anyway can we generate directly from Query you can use the for XML clause example : select * from employees for xml auto What are Temporary tables (Regular & Gl ...Show All

• .NET Development Memory build up

  Hi, I have an application that uses .NET remoting. I am having some problems with regards to memory, the server application just keeps on building up memory and its not reclaiming it. My application includes formula calculations that may run a very long time. After the memory build up it throws an OutOfMemoryException. I tried disposing objects and object references and still no luck. The funny thing about it is I tried running a fewer batch of calculations just to see if the server is reclaiming its memory after calculating successfully, to my surprise it doesn't. Another wierd thing is that after the calculations, maximizing and minimizing the server console application does the trick of reclaiming the memory. Any opinions would be ve ...Show All

• SQL Server Server options are not being executed from local programatically code??

  Dear all, For example, executing a DTSX stored in a server, execution is fine and successfully but the log file attached to that DTSX is not created at all after the execution. Otherwise if I'm going to execute from the server everything is fine: log file is created and gathering the usual information. Let me know if exists any option for to enable this from the own DTSX. If I run local packages log files are created without problems. Thanks in advance, hi again, srvdesasql2005 is our development sql25k SSIS package: \\ srvdesasql2005\AdminSQL\My Documents\Visual Studio 2005\Projects\ABS-CAJEROS\probaenric.dtsx Or, the same that: "C:\Documents and Settings\AdminSQL\My Documents\Visual Studio 2005\Projec ...Show All

• Windows Forms Is there a bug w/ the DataGridView?

  Hi all, I'm using the following code: For Each SelectedRow As DataGridViewRow In grd.SelectedRows SelectedRow.Cells( "IsTrue" ).Value = True Next Ex. of my problem: Row|IsTrue 1    |0 2    |0 Using the above code will only make Row 1 True, and leave Row 2 as False. If I just Select Row 1, then the code above sets Row 1 to True just fine.   The ONLY way to make it work is to hard-code the following: grd.Item( "IsTrue" , 0).Value = True grd.Item( "IsTrue" , 1).Value = True grd.Item( "IsTrue" , 2).Value = True Any variable in the row index of grd.Item produces the same problem. It MUST be hard-coded. Anyone know why ...Show All