Susan S's Q&A profile

• Visual Studio Referencing custom environment variables in MSBuild.

  Hello, Ultimately all I want to do is set an environment variable with a value, so it can be referenced within my Build script. Sounds easy I know, but I can’t find an answer anywhere to this problem. Summarised below are the steps which I am currently taking to achieve my goal: Set environment variable in DOS (i.e. SET TEST=TEST1). Type SET to ensure the variable had been created, which it has. In my build script write a target to reference the newly created environment variable. < Target Name = " ReferenceEnvironmentVariable " > < Message Text = " TEST1= $(TEST1) " /> </ Target > I invoke the above target by ...Show All

• SQL Server help with stored procedure

  I wanted to know how can I use the LIKE '%@id)_number%' in a stored procedure. I tried this but it did't work: IF EXISTS ( SELECT * FROM persons WHERE id_number LIKE % @id_number % ) Just in addition, if the variable is numeric, SQL Server will try to do numeric addition and fail with the statment, therefore you would have to CONVERT / CAST the Value to a characters first, using something like: if exists( select 1 from persons where id_number like '%' + CAST(@id_number AS VARCHAR(100)) + '%' ) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# How to post to a new aspx page

  Hi all, I had a log in screen where by I will validate the user name and password. Once the username and password is validated, I would like to post to a new page "test.aspx" May I know what is the method to use Thanks NpgsqlCommand command = new NpgsqlCommand ( "select UserName from employee where UserName = '" +UserName+ "' and Password = '" +Password+ "'" , conn); try { NpgsqlDataReader dr = command.ExecuteReader(); if (dr.Read()) { lblErrMsg.Text = "success" ; // how to redirect to a new page } else { lblErrMsg.Text = "failure" ; } } catch ( NpgsqlException NplSqlEx) { lblErrMsg.Text = NplSqlEx.Me ...Show All

• Visual Basic selecting data

  hi ...Show All

• Windows Forms DataGridView: prevent column reorder for one column

  It is more a beautification issue, but nevertheless what is a GUI for.... I have a DataGridView and it displays depending on the data different columns. I allow the user to reorder and resize columns, but also give him an "AutoSize" button to readjust the widths of the columns if he messes up. Because I do not know how long the data in the columns is, I start with sizing the columns by "AllCells" except the very last one (highest DisplayIndex) which I size to "Fill". Now I discovered that this looks really ugly when the last column is just a CheckBoxColumn, so to cover all cases more nicely I added one dummy column with no header text which should always stay the last column and sizes to fill remaining spac ...Show All

• .NET Development How do I remove or stop empty namespace created when apply xsl code to xml?

  Hi I have a code to remove all empty elements useing XSL but the out put xml file look like the one shown below My question is How do I remove or stop empty namespace (xmlns="") beieng created. Note: My xsl code top element has <TalkMessage xmlns =" http://www.mydomain.co.uk/CM/envelope "> If I use <TalkMessage> then the output xml file is fine Xsl code <xsl:stylesheet version="1.0" xmlns:xsl=" http://www.w3.org/1999/XSL/Transform "> <xsl:output omit-xml-declaration="yes" indent="yes"/> <xsl:template match="DataSet"> <TalkMessage xmlns =" http://www.mydomain.co.uk/CM/envelope "> ''''''' ''' ...Show All

• Visual Studio 2008 (Pre-release) Error: Mapping not found in workspace

  I just start a new model from a simple database and receive this error when I try manipulate some data: The mapping for Entity Container 'ADONextLib.ADONext' was not found in Workspace. The samples from the CTP is working properly. There is a connectionstring in a .config file called "ADONextLib.ADONext" A suggestion to help out here: You can keep related metadata files in a separate directory and load them up at runtime. This allows you to for example, share the same metadata files accross solutions, or can help you to manage different metadata files for different projects in one location. We'll have better ways to manage these files in future CTPs. ...Show All

• Microsoft ISV Community Center Forums How to send parameter from ms access to excel workbook ?

  How to send parameter from ms access to excel workbook I 'm developing MS Access application (GUI & Database used VBA programming ), but i sending report to MS Excel template. when user want to view that report .them will click button as open workbook from MS Accecc user interface. system will open workbook & pop-up from wait for user select input, submit and system will receive data from MS Access Database output to that worksheet. And now I need update that appication by select data item from listView from MS Access user interface and sendind some parameter for queries data same listview item to MS Excel template. On workbooks openning VBA will used parameter from MS Access and queries data same parameter from Database ...Show All

• Audio and Video Development Focused Buttons and State not working.

  Code sample below. My buttons are acting kinda screwy. I can activate them by clicking, but they exhibit the focus and active states only when I click. Focus is not happening when I mouse over. Also the buttons quickly get out of sync or something. I wonder if I am not dealing with state properly. < xml version="1.0" > <root xml:lang="en" xmlns="http://www.dvdforum.org/2005/ihd" xmlns:style="http://www.dvdforum.org/2005/ihd#style" xmlns:state="http://www.dvdforum.org/2005/ihd#state"> <head> <styling> <style id="BTNSTYLE" style:position="absolute" style:backgroundFrame="0" style:width="137px" style:height=" ...Show All

• SQL Server Problem appending to a raw file

  I have subscription records for five different magazine titles that i process by looping each one though a dataflow using a for-each loop. I am using the following instructions to append to the raw file: http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx This works fine when I pass four different magazine titles. when i try to run all of the titles(five), i get the following errors: [Raw File Destination [131195]] Warning: The parameter is incorrect. [DTS.Pipeline] Error: component "Raw File Destination" (131195) failed the pre-execute phase and returned error code 0x80070057. Any ideas Thanks. Frank Well I'm a bit stumped I'm afraid. I can't think of a reaso ...Show All

• Windows Forms Typed DataSet's with Large Amounts of Data

  Is there any documented maximum number of tables, relations, or records in a typed DataSet object in .Net 2.0 I have a large DataSet (the select command returns 24 result sets with tens of thousands of records total (approximately 90K records of varying sizes.)) If I fill from a DataAdapter into an untyped DataSet, the fill operation returns in just over 1 minute (approximately the time of the select procedure.) If I then merge this untyped DataSet into my typed data set (after calling BeginLoadData on each table) with constraints turned off (EnforceConstraints = false) the merge takes approximately 20 minutes. If I then enable constraints, the program runs for slightly over 20 minutes, and returns an Out of Memory exception. I expec ...Show All

• SharePoint Products and Technologies Custom IRM Protector

  The SDK has some light documentation on creating custom IRM protectors, but no reference as to where to get the interfaces or the class definitions for the supporting classes. Is there a typelib somewhere I can't find it. A sample project would be nice too. The documentation has a sample pseudo-implementation, but there's no way to get started without the COM interface definition. Interesting, I figured out why I couldn't find it. The link you provided is to the beta version of the ECM Starter Kit. The MOSS 2007 SDK now includes the ECM Starter Kit as part of its install. That's what I have installed, and that header file is missing from the SDK install. Looks like somebody maybe missed a fil ...Show All

• Visual C# part of the alphabet

  Is there a prewritten funtion that I can use to check if a string only contains the english alphabet You may be able to use regular expressions. Check this out: http://msdn2.microsoft.com/en-us/library/20bw873z.aspx ...Show All

• Windows Forms P PlugIn

  Pls,How can i expose my application in VB.Net so that another developer can plug into my application and use my modules or my functions. For an Example,I can plug into microsoft Excel and use its in-bult functions for my application. Please I will need an Example code using VB.NET 2005 Thanks Maybe this will article by Roy Osherove or this sample from Billy Hollis . ...Show All

• Internet Explorer Development VBScript doesn't execute. No error. Could it be disabled in IE7 ?

  HI. To get the LCID, we use the vbscript function getlocale(). After upgrading from IE6 to IE7 the function doesn’t return anything. I tried the simple sample below and was surprised that nothing happens when using the button. There is no script error in the status bar. I didn't see any option to disable VBscript. Any idea Jerome <HTML> <HEAD><TITLE>A Simple First Page</TITLE> <SCRIPT LANGUAGE="VBScript"> <!-- Sub Button1_OnClick MsgBox "Mirabile visu." End Sub --> </SCRIPT> </HEAD> <BODY> <H3>A Simple First Page</H3><HR> <FORM><INPUT NAME="Button1" TYPE="BUTTON" VALUE="Click H ...Show All