PeterLlwr's Q&A profile

• SQL Server debugging script task

  Hi, I'm trying to debug a Script Task. I set a breakpoint then start debug. I always get a COM Exception error: unhandled exception occurred in DTAttach.exe[3332] File position not valid for new breakpoint Can someone suggest me something Thanks Was facing the same issue even after trying all of the above. Have found workaround for this annoying problem Everytime you get this error, right click on the problematic project in solution explorer and select 'clean' and then select 'rebuild' Debugging should then work ok. ta arun ...Show All

• Visual Studio Team System Question of build?

  Hi, I have this scenario, I have some Team Project called "W" I did some branch of code from W version 1.1, so, I want to know if I run or build my Branch Project this automatically takes all componets from the base project in this case "W" My branch project have only for expample the version 1.2 so what happens when I build my branch project The whole purpose of branching is to create isolation. When you create a branch, a copy of the source code at that level will be created in the branch and both will be isolated from each other. So, I think when you build branch the original branch (trunk) source code will not be built. In fact you can continue separate development in both the branches. That is how you can have bug-fixes in or ...Show All

• SQL Server change value type from Int64 to Int32 ?

  I have a query which calculates a number... but by default the number is represented as a 64 bit integer. I cannot remember the function name but it is only using SQL9.0 built in functions. Is there a way to cast the number This is not a trivial issue since I have found an easier way to do this which did not involve the number, although any input would be greatly appreciated. Thank you :) I don't quite understand your question. But you can cast a value to a different data type using CAST function. You may or may not get runtime errors depending on the data. See Books Online for more details. So in your query, you can do something like below: select cast(<expr> as int) from ... ...Show All

• SQL Server I did So..

  dear sir, i am facing problem while making perspectives in sql server2005(Analysis Services) through C#.perspectives are made well but cant update within a Cube...i mean cant be added to a cube... i dont know what is the problem.so if someone can help me in this regard i will be really thankful to u. Thanks. dear sir, i did post it on many of other forums like code project and microsoft india...but i dont know i got no clear response.anyhow thanks alot for giving me time and considering my problem... thanks. Adnan Khan. ...Show All

• Visual Basic Visual Basic Express!

  HI, everybody Iam using now visual basic express, i used to use visual baisc 6. I want to know what is the difference between Visual basic Express and Visual basic 6 Because I am trying to acess reference and I can't find the reference for acess. I want to acess a database created in acess, and I can't. ther error says...."the namespace" or " the declaration is not found". am getting anoided with... The differences are too numerous to list. It would be best to get a beginning Visual Basic 2005 book of some kind. With your background, you should become productive rather quickly :-) -Ryan / Kardax ...Show All

• Visual Basic Backgroundworker?

  Does anyone know how to add a backgroundworker to this class This is my main form's code below. I want the user to click the btnImport_Click button and not freeze up the form. Imports System Imports System.IO Imports System.Windows.Forms Public Class Form1 Inherits Form Dim ds As DataSet Dim bs As BindingSource Private Sub btnImport_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click 'verify a file was choosen If ComboBox1.Text = "Select a file..." Then MessageBox.Show( "Please select a file from the drop down box." , "Try again..." ) Exit Sub Else Me .Cursor = Cursors.WaitCursor ...Show All

• Windows Forms negative value of custom control property: strange behavior in designer

  I have a custom control which contains a custom version of the ProgressBar. This control accepts double minimum and maximum values which define the range of the custom ProgressBar. If I set, for example, a min val of -10 the Progressbar is correctly drawn and the code runs without problem. Then, if I reload the designer, the min value is changed to 10 (positive) in the designer window, but in the code it is still -10. If then I build and run the project it behaves correctly. Then, if I modify something in the designer window forcing to reload the form code, min value is set to 10, according to the value in the designer window. Why does this happen Is it a parsing problem "Property accessors" are ...Show All

• Smart Device Development Capture Hotkeys - the solution

  Hi everybody, I worked for quite some time now on developing a solution to capture the hotkeys on a WM5 smartphone. Searching on the internet didn't help, every suggestion to the problem had a serious drawback. So I developed my own, maybe it helps somebody who encounters the same problems as I did. Basically I use the Game API and call GXOpenInput to block the hotkeys. After that you can program the keys by catching them in the standard KeyDown event of the form. If your form has a textbox for input or uses the softkeys for menus you have another problem, the keypresses are eaten by the Game API and don't get to the form. So if I detect a press of the back key in the KeyDown event, I call GXCloseInput, resend the keypress via keybd_event ...Show All

• Visual Studio DTE2.OpenFile(string FileName, string ViewKind(????))

  Hi All, I have a question about the method I mentioned in the subject. What is exactly the ViewKind parameter I couldnt find the answer...... :-( When I looked up at the internet, I found something like vsViewKindAny, or vsViewKindDesigner . But still I couldnt solve it. FYI, I'm making DSL for such a graph editor project. And with that method, I want to open my DSL file. So, could any of you suggest me what kind of ViewKind parameter I should best use And with some explanation will help me alot! TIA. Herru Thanks Carlos, But your answer is not enough for me. I think I didnt really explain where is my problem. So in my DSLPackage project I can reference to DTE2 object. More specifically in the MyDSLCommandSet class. ...Show All

• Visual Studio Cann't debug ???

  Hi all ! I'm using VS .NET 2003. I have installed VS but I cannot debug.When I press F5 ,VS show an error dialog like this :"Error while trying to run project :Unable to start debugging on the webserver .There is no managed code running in the process.In oder to attach a process with .NET debugger managed code must be running in the process before attaching ". But after adjusting Enable managed debugging to true in the property dialog,the error dialog doesn't appear when I press F5 but VS doesn't run to function I want to debug (I cann't debug). Help me ! Thanks a lot ! ...Show All

• Software Development for Windows Vista Workflow sample compilation

  I've downloaded Win SDK for Wista, and try to compile a sample Workflow project. I get messages that "an assembly is missing" and so on. Why I can't compile it I've succeded in installing full redist package found at: X86: http://download.microsoft.com/download/1/D/A/1DA1A5D6-4DF6-45AA-9C2F-E87EFF6F6F78/dotnetfx3.exe ...Show All

• SQL Server SQL Statement not producing any error for invalid column in a table

  Hi, I am using SQL Server 2005 with SP1 patch update.I have tow tables X table fields: ClientID,ClientName,ClientRegisteredNumber,HoldingName,HoldingRegisteredNumber,NumberOfHoldings Y table fields: ClientID,ClientName,RegisteredNumber,HoldingName,HoldingRegisteredNumber,NumberOfHoldings If i run a query for X table: SELECT RegisteredNumber FROM X it produces the error like this Msg 207, Level 16, State 1, Line 1 Invalid column name 'RegisteredNumber'. But if i run the query for X,Y table: SELECT * FROM Y WHERE RegisteredNumber NOT IN (SELECT RegisteredNumber FROM X ) It's not producing any errors. Why this Is this the SQL Bug or my query problem Can anyone explain how to solve ...Show All

• Windows Forms DataGridView - columns versus rows

  Hi, I wonder if anyone can help. First, I use Visual Studio 2005 pro with C#. My application is entering a new phase and I've had some limited experience with the DataGridView. Initially I posted a question whether the DataGridView could be transposed (colums and rows swap roles) and nobody replied, so I guessed that was a big fat "NO". As I need to work with transposed data, I found an article which returns a new dataset from an existing dataset, but it swaps the roles before populating the DataGridView. This is OK, I can live with that, but the data I will be working with will consist of about 70 rows maximum, but the number of columns is my main concern. I could end up with over 500 columns, though I doubt it would ...Show All

• Visual Studio How to Add a project reference using DTE?

  Hi All, How can we add a project (C# class library) reference to a Web Services project using Application Object Model (DTE) Best regards, Imesh Opps, I edited out a vital line of code. Dim MyVSProject As VSLangProj.VSProject = CType(project.Object, VSProject) ...Show All

• SQL Server Date format in a merged field

  In the footer from a report I want to print the UserID and the Date. I added a textbox with de following code: =User!UserID & " " & Globals!ExecutionTime Now I want to change the date format in dd-MM-yyy uu:mm. This is not possible in the textbox properties because I added the UserID to the same textbox. Is there a way to change the format Try this: = User!UserID & " " & Format(Globals!ExecutionTime,"dd-MM-yyyy hh:mm") cheers, Andrew ...Show All