Matthew Crockett's Q&A profile

• SQL Server Generating a correct xpath_namespaces

  I want to open a XML document with a xmlns declaration, i open the xml with: -- Open the XML doc EXEC sp_xml_preparedocument @itemHandle OUTPUT, @xml, '<PriceList xmlns:maxbo="http://maxbo.no/schema/PriceList.xsd" />' Then i try to select somthing (this returns nothing) select * from OPENXML(@itemHandle, N'/PriceList') Here are the first few rows. < xml version="1.0" encoding="iso-8859-1" > <PriceL ...Show All

• Visual Basic dateformats

  Im using backend as ms-access 2003 the default date format for field of datetime type is mm/dd/yy 1st question Can we change the format to dd/mm/yy in ms-access itself 2nd question Im using front end as windows forms appln using vbasic every time when i retrieve the date value from backend, it requires me to convert to dd/mm/yy format. can u tell me the method for this conversion and everytime i insert a date value in to ...Show All

• Visual Studio Tools for Office HorizontalAlignment

  Hello, (Disclaimer: I am new to VB .Net) I am trying to create an application that automates a spreadsheet (creates worksheets, populates and formats). I want to center the column heading text. This seems to work: xlsheet.range("1:1").HorizontalAlignment = -4108 Why does this work (using -4108) I suspect this is not the obvious way to do this. Hi, The code that you wrote works be ...Show All

• .NET Development I expect a client cert will return after starting System.Net.HttpListener in "Negotiate" mode

  I want to write a HttpListener requires browser to submit its client cert before response.  When start following code, the browser prompts for password only and nothing is returned in the server side statement .GetClientCertificate() .  Instead, the response headers("Authorization") has a long base64 string [Negotiate TlRMTVNTUAADA...].  I suspect it is the client cert that I want.  However, I fail to create the cert from it. ...Show All

• SQL Server Four Checkboxes of Bit Datatype in IIF() not working correctly

  There are four checkboxes (datatype of bit), and it the user hasn't checked any of the four, then I throw an "X", else it needs to be blank (if they've checked 1, 2, or even 3 of the boxes).  I'm getting an "X" every time, even for a record that's got two checkboxes checked. The expression is as follows: =IIF( (Fields!Cost_Load_Report.Value = 0) and (Fields!Spend_Plan.Value = 0) and (Fields!Resource_Load_Report.Value = 0) and (Fields!Target ...Show All

• Windows Forms setting one forms controls data from other form

  Hi friends, I am developing a windows forms application. I am strucked up with  a problem. I had two forms. Main form sub form. First i displayed main form and from main form i invoked sub form. later i want to exit from sub form nd display some&nbs ...Show All

• Visual Studio Team System <AspNetDevelopmentServer> Question

  I have this attribute before each of my web service unit test methods: <AspNetDevelopmentServer( "PlannerServer" , "C:\Visual Studio Projects\Planners\PlannersBusinessLayer" )> This will start up the web server before running the test. This works fine.  But what about when another member of the development team wants to run the unit tests, or if we want to run them automatically as part of our nightly build   Do we have to ...Show All

• Visual C# static destructor ?

  So in an effort to try and improve my skills I'm going trough the spec. So around page ~33 I get bloody confused and install the express edition on my machine to spike some stuff out. The thing that confused me is the static constructor. I've learned the singlton pattern w/ a private contructor rather than the static constructor, so I have never really seen it before. But I was wondering how I would ever get rid of the structures that a ...Show All

• SQL Server Merge Replication Without Merging Client To Server

  I want to SYNC the data on the server to the client, but never the client data to the server. Is such a configuration possible with Merge Replication under SQL CE Thanks again! Merge is designed to be bidirectional but RDA is intended for scenarios like yours. Remote Data Access (RDA) with tracking turned OFF on your SQL Mobile tables is the way to solve this.  You already have the IIS infrastructure in place since you're doi ...Show All

• SQL Server Connection String has to be reset every time when DTS package is started

  Hi All, I am trying to import data from flat file to sql server 2005 DB table using SSIS. There are 4 different text files in the input folder. I am using for loop to iterate reading and importing 4 times. In order to do this I have set "Connection String" property of a connection manager to a package level variable using expression. There is a script which supplies the source file name and assigns to this variable. The package w ...Show All

• Visual Studio Target .NET 1.1 using Visual Studio 2005

  Hi all, Looking into MSBuild is something new for me. Is there a way to target projects for the .NET 1.1 framework in Visual Studio 2005. I have seen a couple of suggestions, but none have worked so far. Any help is appreciated. Thanks in advance, Zane You can use the Toolkit for .NET 1.1 to build v1.1 projects on the command-line using MSBuild, but there is no way to work on v1.1 projects from within ...Show All

• SQL Server NOT build index while loading data into a DW

  Hi Champs I am importing huge amout of row into a DW, that I then want to build Cubes from. This process is slow, as SQL insists of concurrently building an index, whil loading. Is there a possebility to delay the build of Index to After the data is loaded into the DW /Many thanks If you are building an index then surely it is in your control as to when that happens Pe ...Show All

• Windows Forms Need help with VB.net involving simple array look-up

  Hi guys, I'm trying to have a State Name and Abbreviation finder, that stores the stuff in an array, but I'm not sure on how to go about doing it. So far, I've gotten this stuff done: Public Class frmVBACSL Inherits System.Windows.Forms.Form [Windows Form Designer generated code] Structure StateInfo Dim StateName As String Dim Abbreviation As String End Structure Dim States(56) As State ...Show All

• .NET Development Server.Execute: How to transmit variables between VB and C#

  Hi. I've got two scripts test1.aspx [code] <%@ Page Language="VB" %> <% Dim myVar As String myVar = "Hello!" Server.Execute("test2.aspx") %> [/code] test2.aspx [code] <script language="C#" runat="server"> void Page_Load(Object Src, EventArgs E) { myPage.Text = myVar; } </script> <asp:literal id="myPage" runat="server"/> [/ ...Show All

• Windows Forms Computer reset after running setup

  Hi I'm using vs2005. With a publish tool I have created a setup files. When I'm trying to run setup file i can only see popup window giving me the choice [Install|Dont install] - when I press 'Install'  I got computer reset :( Why is this happening What I did wrong :) In a publish tool I also got warnings according to publishing crystal reports resources Ex.: 'Warning 3 Unable to apply publish properties ...Show All