horatiu's Q&A profile

• SQL Server SQL 2005 DB design

  Hi All: There is a design issue that I like to know your opinions. We are designing a database that will manage the data of many customers. All of the customers will use a same web site to communicates to the database. There are the requests of most customers that they like to have their data as separated as possible from the others and they also need to do offline bi-direction data exchange to this database from their databases( possibly through web services). Basically the data structure is the same. THe customers number, however, can go upto a thousand potentially. And each of their data volumn is about in the middle range. I h ...Show All

• Microsoft ISV Community Center Forums Add a column to Grantt Chart to MS Project

  Hi there, i want to add a column to a grantt chart , this is my code snippet: TableEdit Name:="&Entrada", TaskTable:=True, NewName:="", _ FieldName:="", NewFieldName:="% completado", Title:="", _ Width:=10, Align:=2, ShowInMenu:=True, LockFirstColumn:=True, _ DateFormat:=255, RowHeight:=1, ColumnPosition:=1, AlignTitle:=1 TableApply Name:="&Entrada" SelectTaskColumn Column:="% completado" EditDelete I have an spanish version thats why appear those strings "% completado" (Task Percent Complete), like you'll see thats a not what a looking for...i want something like this: Columns.Add(ColumnType:= enumTaskPercentC ...Show All

• Software Development for Windows Vista CreateWorkflow failing validation

  I am trying to start a workflow using a xoml file. I am getting Workflow failed validation in CreateWorkflow with a very simple workflow containing start, delay 1 sec and stop. Is there a trick in getting this to work Thanks. // create and start an instance of the workflow runtime WorkflowRuntime runtime = new WorkflowRuntime (); runtime.StartRuntime(); // get an XML reader to the XAML-based workflow definition System.Xml. XmlReader xaml = System.Xml. XmlTextReader .Create(txtWorkflowFile.Text); // create a running instance of our workflow WorkflowInstance instance; try { instance = runtime.Creat ...Show All

• Smart Device Development Updated emulator?

    Hi Everyone -   Is there an updated emulator   I have version Pocket PC 2002 Version 3.0.11171  Build 11178   I would like to use the version 4.0 of the system   thanks tony     There is a new emulator, called the "Device Emulator" that ships with Visual Studio 2005. It is not a direct upgrade from the emulator you're using:  the DeviceEmulator runs Pocket PC 2003 Second Edition and newer OSes. If you're interested in trying it out, you can download the standalone version from http://msdn.microsoft.com/mobility ...Show All

• Visual Basic array variable

  How can we create an array variable in vb. The size of the array should be defined only during runtime. Please give the sample code. Try this: Console.WriteLine("Enter size of array: ") Dim numElements As Integer = Integer .Parse(Console.ReadLine()) Dim strings(numElements) As String For i As Integer = 0 To strings.Length - 1   strings(i) = "Hello, World" Next For Each s As String In strings   Console.WriteLine(s) Next You can also use ReDim Preserve strings(numElements) to resize an existing array keeping current elements. (You can omit Preserve if you want to throw away existing elements. ...Show All

• SQL Server High CPU utilization during full-text population in SQL 2005

  Hi, In SQL 2005 a full-text population of a text field in a table containing 1.2 million records utilizes very high CPU resources. A dual Xeon 3Ghz, 1GB memory was running at 95% during the population of the full text catalog. There was no other activity on this server besides the full-text population. It performed the population in approximately 28 minutes, which is allot faster than SQL 2000, however, the high CPU utilization would be of great concern in a production environment. I have not tested incremental or change tracking as yet but i plan to look at this very soon. Is this unusual behaviour or does the SQL full-text ...Show All

• Windows Forms Problem with RowChanging event

  Hi, if have a DataSet (SQLExpress) whith 2 Tables. On one table I add a RowChanging event handler. When I add a record in a boud datagridview then an exception occures in the handler. (After changing the postion in the DGV the event is fired). Here my handler: void PCs_RowChanging( object sender, DataRowChangeEventArgs e) { if (PCsBindingSource.IsBindingSuspended) { return ; } try { MessageBox .Show(e.Action.ToString()); } catch ( Exception eX) { MessageBox .Show(eX.Message); } }   I get and "Index out of range" exception and my DGV is a red rectangle with red lines across it. After the exception I can see m ...Show All

• SQL Server Installing SQL Server 2005 on Windows XP Pro x64

  On MSDN, I have downloaded "SQL Server 2005 CTP - September 2005 - Enterprise Edition - 64-bit Extended - Servers (English)" that I am trying to install on WinXP Pro x64 (EMT64 machine). Unfortunately, I am not able to install SQLSRV2005, indeed during the setup the option such as "SQL Server Database Services" are grayed (i.e. not clickable, idem for Analysis Services). The only thing that I can select is "Workstation components". Is it possible to use SQL Server 2005 on a WinXP x64 OS Thanks in advance, Joannes Enterprise Edition isn't supported on WinXP.  Please see the following link for system ...Show All

• SQL Server 64 bit cluster cannot connect using dtutil

  Hi, I have a 64 bit Itanium SQL Cluster that I'm trying to set up. The database engine seems fine, but I'm trying to install some SSIS packages using dtUtil and I keep getting a connection error. The error is as follows "Login timeout expired An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default seetings SQL Server does not allow remote connections. Named Pipes Provider: Could not open a connection to SQL Server [2}. (Microsoft SQL Native Client)" Also, in Management studio, I can make a connection to my SS ...Show All

• Windows Forms DataGridView DataError argument is wrong

  I'd like to report a DataGridView bug (or at least something that is misleading).  One of my DataGridViews was thorwing an error.  It's DataError event's DataGridViewDataErrorEventArgs parameter (e) said the event occured for column "A" (e.ColumnIndex). However, the parameter's exception message (e.Exception.Message) said the problem (which was a NoNullAllowedException) was with column "B". The exception message had it right. The argument's ColumnIndex was directing me to the wrong column.   See code below.  The two handlers do not point me to the same column. private void dataGridView1_DataError(object send ...Show All

• Software Development for Windows Vista "LoaderLock was detected"

  I get this message after closing any VS2005 application in Debug mode.... VS2005 stays in debug mode until I explicitly kill my app. At first, I thought it was only on Avalon apps, but I get it on any regular WinForms app, even ones that I am recompiling on VS2005... Any idea what it means LoaderLock was detected Message: Attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang. I found it best to load your form, or executable, create what you need and make sure ...Show All

• SQL Server CLR Trigger

  Hi,       I want to call webservice in the Trigger.  How to call the webservice from CLR Triggers .If anybody knows teh detail let me know.   And i worked out  the following Example code for CLR Trigger. using System.Data; using System.Collections.Generic; using System.Text; using System.Data.Sql; using System.Data.SqlTypes; using System.Data.SqlServer; namespace CLR {     public class Class1     {         public static void InsertTrigger()         {  &nbs ...Show All

• Visual Studio Team System Parsing method body

  Hi I am trying to parse a method body in a custom rule for FXCOP and filter some words. e.g. void SomeMethod() {     statement1;    statement2;    statement3;  }  The method.Body.Statements does not contain the text of the statement.  Is there any other method to get the result Thanks That is correct. If you need to perform source-based analysis, you could consider writing a VS add-in and using the C# code model to do the work you're interested in. Michael ...Show All

• Windows Forms mask in DataGridView

  How can I check the mask when the user edit the cell. I already set the custom format in DataGridViewCellStyle using CellFormatting event. But, when I key in the value, it doesn't check the format. ( for example, maxlength... ) ( EX : 1. CellFormating Event - format  setting : AA-AA-AAAA          2. When the data display : in Database&nb ...Show All

• .NET Development .NET programming for Terminal Services

  Hello, Are there any special considerations to be followed when creating .NET programs on MS Terminal Servers   If so, is there a way to detect if the user is running Terminal Services Thank you very much. David, Thank you very kindly for your reponse.  That is what I needed to know. Regards Mister T ...Show All