mrwebster's Q&A profile

• SQL Server group numbering issue

  Hi everyone, The problem is about numbering groups. I'm trying to display data like this- 1. U.S 1.1 San Francisco 1.1.1 employee1 1.1.2 employee2 1.2 Dallas 1.2.1 employee3 2. UK 2.1 London 2.1.1 employee4 I've tried using RunningValue(1, Sum, "group_name") but it gives erroneous results. I'm using 3 lists, one at each group level. The outermost list (1st list) is grouped by "country" (group_1), 2nd one is grouped by city (group_2) and the innermost (3rd one) by employee name (group_3). I can't figure whats wrong. Can anyone help me Thanks in advance. We were using Access reports before moving to SQL serv ...Show All

• Smart Device Development How do I read/write a binary key in the registry on a pocket pc?

  Here is my test code buy I get a error every time. I have been able to reas and write dword and string keys with the basic same code with no errors but I am stumped on this. Dim test As Byte test = Microsoft.Win32.Registry.GetValue( "HKEY_LOCAL_MACHINE\Software\Microsoft\Color" , "SHColor" , Nothing ) If test = &H1B Then CheckBox2.CheckState = CheckState.Checked CheckBox2.Enabled = False End If If CheckBox1.Enabled = True And CheckBox1.CheckState = CheckState.Checked Then Microsoft.Win32.Registry.GetValue( "HKEY_LOCAL_MACHINE\Software\Microsoft\Color" , "SHColor" , &H5a ) End If Thanks in advance, Mark ...Show All

• Visual Basic I Need Some Help on Problem Solving My VB Assignment

  I am new to programming and am having some issues. Here is my situation. I am working on a Small Group project but do to unknown reasons the majority of my fellow students have been unavailable to assist me. I am on Active Duty in the Army and have the assignment due tomorrow but I have duty for 24hrs tomorrow so completing the project in a timely manner will be difficult for me. I have been spending three frustrating days to make it work but with no luck even after interacting with other students outside my group. Here is what needs to happen: I need to create a dynamic Sudoku game board using my existing Visual Basic code that uses random number generation when you click on the random button. I have created some of the code but hav ...Show All

• Visual Studio Express Editions Calling another application?

  I have another .exe application that I wish to envoke from a C# program and pass it a parameter. Normally I would open a command line and run the .exe this way "merg.exe inputfile.xml". I'm looking for a way in C# to detect a file name in a certain directory and then call the merg.exe application with the file name as a parameter. Thanks, David use the ProcessStartInfo class: System.Diagnostics.ProcessStartInfo theProcess = new System.Diagnostics.ProcessStartInfo( filename ); theProcess.Arguments = argumentsHere ; System.Diagnostics.Process.Start(theProcess); does this help you can also redirect your standard input/output and error messages using the ProcessStart ...Show All

• Visual C# Operator '+' cannot be applied to operands of type 'T' and 'T'

  One day, the Microsoft C# team will stop treat us as kids, and this code will become possible:   public static ABIDataVoidNull<T> op_Addition_NV_NV<T>(ABIDataVoidNull<T> inValueL, ABIDataVoidNull<T> inValueR)        {            if (inValueL.IsVoid)            {                return (ABIDataVoidNull<T>)inValueR;            }            else if (inValueR.IsVoid) ...Show All

• SQL Server Bulk Insert from CSV - trouble with .FMT

  I need to bulk insert from multiple files which are comma-separated with quotes as delimiters around each column. I cannot use DTS because the filenames are variable (unless someone knows how to get DTS to read 'DIR *.csv' and then load each file ) This .fmt doesn't work because SQL sees "","" as "" - meaning no terminator - then ,"" where it expects whitespace. 8.0 6 1 SQLCHAR 0 1 "","" 3 Prefix SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 1 "","" 5 Forenames SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 1 "","" 4 Surname SQL_Latin1_General_CP1_CI_AS 4 SQLCHAR 0 1 "","" 6 Job_Title SQL_Latin1_General_CP1_CI_AS 5 SQLCHAR ...Show All

• Visual Studio Need Help on SHFB.

  Hi, I am using Sandcastle Help File Builder, HTML Help workshop, VisualStudio SDK and Sandcastle. When I am trying to build Documentation(Chm) for a project by selecting an Assembly(it's pulling relavant XML file). XML file is created by changing the properties of Solution file of Build option by check the XML Documentation option. So while build the application XML file is created automatically. That XML file contains only XML documentation tag comments (i.e /// comments). My Question: #1. How to include single line and multiline comments into that XML file (// and /* */) #2. By default SHFB taking public methods, how to add private and other methods into Documentation Please help me regarding this. Thanks &am ...Show All

• SQL Server time out expired error

  Hi all, I am so glad to find this discussion forums for SQL NS. I’m badly stuck and need help. Background: I am currently working on an VB.NET + ASP.NET + SQL 2000 + SQL Notification Services based application. I maintain / enhance it. The application uses Notification Services to send automated emails to the users. (Event based subscriptions only). My application has two notification services running, one of them started failing about a week back while the other one continued to run without any problem. Original Problem: About a week back the Notification Service stopped working, On debugging I found that the event batch quantum was greater than the specified event throlle. (This was the error message in the Application Log). The AppAD ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to draw an arbitrary segment of triangles from a VertexBuffer?

  Good Evening- I basically have a VertexBuffer containing 20 triangles, but I want to be able to just draw 2 of them at a time and then change settings (for example the World matrix). I don't see how this is possible in Managed DirectX... for example if I use DrawPrimitives(), you can specify an offset to start rendering but it will continue rendering until the end of the buffer is reached. I want to specify an offset and a length... Could someone please show me how or point me in the direction of a different method of storing/drawing triangles that would Thanks, Philski yeah... that's what I get for coding late at night. I was putting in the vertexes per triangle as the third option... (napolean dynamite) ...Show All

• Windows Forms Generated DataBinding and ComboBox Problem

  Hi, I make use of the automatic databinding in VB 2005. I have got two tables. One is called customers and the other is called WorkingStations. Every Customer is assigned to one WorkingStation. I have created the dataset that displays thw rows from both tables. The customer table contains a column called WorkingStationID that is related to the primary WorkingStation key. Now I created a form that allows me to edit a customers data. I load one single customer by his ID. The basic editing works without any troubles. Now I added a combobox that has following attributes: Source: WorkingStationBindingSource Member: WorkingStationName Valuemember: WorkingStationID Value: Customers.WorkingStationID I load both tableAdapters(the one for the custom ...Show All

• Visual C# SQLExpress Smallint into C#

  Hi Everyone, I'm connecting to an SQLExpress database to retrieve some data, and am having some problems with retrieving int's. I can successfully retrieve standard length int's, but am unable to retrieve smallint's. I'm using the following code: cmd.CommandText = qry; // type DbCommand with input SELECT string DbDataReader reader = cmd.ExecuteReader(); if(reader.HasRows) { while(reader.Read()) { Int64 tkNo = reader.GetInt64(0); // works fine .. .. .. Int32 comp = reader.GetInt32(6); // error occurs // also tried the following // Int16 comp = reader.GetInt16(6); // int comp = reader.GetInt32(6); // Int64 comp = reader.GetInt64(6); } } The error is: Second System.InvalidCastException: Specified cast is not ...Show All

• Internet Explorer Development catches IE Events

  Hi, i am writing an extension for internet explorer i have already created the extension however i need to catch IE events like "NavigateComplete" is there anyway to catch the events using visual c# thanks Regards Roy Ya I am using ... Anyway, in SHDocVw there is a method which i can use.Anyway, thanks a lot for the help given. Regards Roy ...Show All

• Visual C# Security error while trying to run C# application

  Hi I have a C# windows application which I run by giving the arguments to local files eg:- HelloWorld c:\testdata\hello\ c:\testdata\sign\ It gives me an error The given path's format is not supported. at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.AddExpressions(String[] str, Boolean checkForDuplicates, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String[] pathList, Boolean checkForDuplicates, Bool ...Show All

• Visual Studio MSBuild Editor

  Hi, Currently Visual Studio automatically creates the MSBuild file in the form of the Project file. However the MSBuild file could be be used for far more than just managing the project. Now I can understand why you would not want a user to be modifying the Visual Studio project, but why not provide the ability to add new MSBuild files, and allow for these files to editted within Visual Studio using the XML editor and providing intellisense, and then more importantly provide the ability to execute an MSBuild file independant of a project. This would then cater for the development of more advanced build files and essentially providing majority of the features that people would normally use NAnt for, but from within the Visual Studio environ ...Show All

• .NET Development TimeSpan and XML

  I am saving a timespan as a string in an XML file and I am wondering is there any way to deserialize that back into a timeSpan or read it in as a string and then converting it to a timespan ...Show All