Ning's Q&A profile

• Visual Studio Express Editions From *.vb to *.exe, how?

  I have tried to search google and the forums here on how to make your program an exe but to no avail. I have the 2005 Express version and would like to make my test program into a .exe that I can install. Any assistance on this or how to do it I would apreciate :) No 3rd party required to compile application, VB will build you an executable. Something to consider is that although it generates an EXE file - you cannot just copy and run this necessarily as it has a dependency upon the .net framework being installed. You should look at the Publish option which would create you a setup which will install any requirements such as the .net framework on a machine if its not already on there, A good little ...Show All

• SQL Server Error: unable to retrieve column information from the data source

  Hi, I am trying to set up a data flow task. The source is "SQL Command" which is a stored procedure. The proc has a few temp tables that it outputs the final resultset from. When I hit preview in the ole db source editor, I see the right output. When I select the "Columns" tab on the right, the "Available External Column List" is empty. Why don't the column names appear What is the work around to get the column mappings to work b/w source and destination in this scenario. In DTS previously, you could "fool" the package by first compiling the stored procedure with hardcoded column names and dummy values, creating and saving the package and finally changing the procedure back to the actual o ...Show All

• SQL Server iif statement problem

  hi all, i've browsed some of the smilar iif expression problems but no idea how to solve mine. i get an #Error when i wrote the following expr : =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0)) but no error when it's =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0) - iif(Fields!revenue_type.Value= "T" , Fields!amount.Value,0)) If i filter the dataset and just take in data where revenue_type = "R" then there won't be error... how come did i do something wrong please help... this seems so simple yet i couldn't get it.. thanks Maciej. it works! but i don't get why the expr needs to be ...Show All

• Software Development for Windows Vista Creating managed cards problem

  I have unzipped and installed with success the batch file in Creating Managed Cards.zip. However, when the browser attempts to enter the page https://www.fabrikam.com/CardSpace appears in the browser the HTTP 401.3 - Access denied by ACL on resource Internet Information Services page. During the installation a pop-up alert came about the Automatically detected proxy! should I configure the proxy what address should I use Thanks in advance Amadeum It is because your iis does not have access to the website directory residing in your cardspace sample. You need to give the internet information service user and aspnet access to the files. If you are using ...Show All

• Visual Basic Problem with Singleton Code

  I have a class that is invoked in multiple ways, but no matter how it is invoked, I only want one instance to exist at any one time. The class looks like this: [code langauage="VB"] Imports System.Threading Public Class SingletonClass Private Shared _mu As New Mutex Private Shared _instance As SingletonClass Public Shared ReadOnly Property GetInstance() As SingletonClass Get _mu.WaitOne() Try If _instance Is Nothing Then MsgBox("Creating New Instance of SingletonClass") _instance = New SingletonClass End If Finally ...Show All

• Visual Basic How do I open an application using a drop down menu?

  I would like to know how I open an application using a `Tool Strip Menu`. Try something like this: Private Sub RunNotepadToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RunNotepadToolStripMenuItem.Click System.Diagnostics.Process.Start("notepad.exe") End Sub ...Show All

• Windows Forms DataGridView - switch cols and rows

  I really need the DGV to display its cols (fields) down the left (as rows) and the data (there's a single row) as another col. I can't see how to do this. Is this possible Thanks, R Yes - it looks that this solution (via a coded intermediate table) will indeed switch/pivot the rows/cols. But it also seems that we lose the DB auto-updating functionality. And also, we lose the ability to define col attributes (since these are now rows). It seems a pity that the DataGridView doesn't have a way to just natively pivot! Thanks for your help and time Chi, Roger ...Show All

• Smart Device Development Bitmap.Save() in Windows CE5.0

  Hey, I am working on a project using the Symbol MC3000 mobile computing device Running CE5.0 with .NET CF 2.0 SP1). This particular device has an imager which we are using to capture a picture. After the picture is captured, we are creating a bitmap object (System.Drawing.Bitmap) to store the image while we create a Graphics object (with the bitmap as its image). We use the graphics object to post a date/time stamp to the image (drawString()). After that is completed, we are using the Bitmap.Save() method to specify a filename and image format. However, it is crashing on the save with a Not Supported Exception. Here is the code: Dim captureBitmap As Bitmap captureBitmap = New Bitmap(imageStream) 'imageS ...Show All

• Software Development for Windows Vista WWF Scenario using ASP.NET

  Hi, I want to implement a WorkFlow in ASP.NET using Windows Workflow Foundation. I have a Web Form where user 1 fills in the form and submits it. This form and the saved data is then sent to user 1's boss who reviews the data and submits the Web Form to his boss and so on and on until it goes to the top of the Organisation where it is finally approved or rejected. Each time the form is subnitted an email is sent to the next person on the Organisation hierarchy letting them know that the Web Form is awaiting their approval. 2 Questions: 1) Can I use Windows Worflow Foundation in conjunction with ASP.NET. Alot of examples I see use WinForms 2) In relation to my Business Process Scenario can I implement above using ASP.NET and ...Show All

• Visual Studio 2008 (Pre-release) Bug ? The Enabled control is not effective by MenuItem.Command.

  When the menu is displayed with the ALT+F key in the following codes, MenuItem doesn't become effective. MenuItem becomes effective if it clicks with the mouse. Is this a bug Window1.xaml file <Window x:Class="MenuBtnTst.Window1" xmlnshttp://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:l="clr-namespace:MenuBtnTst" Title="MenuBtnTst" Height="300" Width="300" > <DockPanel> <ToolBar DockPanel.Dock="Top"> <Button Name="btn" Click="OnOpenFileMenu"> <Button.Content><AccessText Text="_File"/></Button.Content& ...Show All

• SQL Server Java App Connecting to SQL Server 2005 Express Database

  Hey All, I am having a problem connecting to a database I have with a java app I am creating for my senior project. I am using the latest MS JDBC for connecting to the SQL Server. Below is the code I am trying to run: try { ds.setIntegratedSecurity(true); ds.setServerName("localhost\\SQLEXPRESS"); ds.setDatabaseName("*databasename*"); con =ds.getConnection(); } catch (Exception ex) { ex.printStackTrace(); } The ds and con variables are declared and initialized correctly. The error I am getting now is this: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "*databasename*" requested by the login. The login failed. Any suggestions on what I could be doing wrong ...Show All

• Visual C# Generate random location

  Hi, I've encountered a weird problem. I'm working on a small game, using C# and VS2005. You're supposed to move a character (the "hero", its basically just an image drawn on the form) around the form to pick up an item; another image drawn on the form. When the item has been picked up it moves to another location (you move up a level). When the item's location is hardcoded or moved using int x = 50; int y = 50; ... x += 10; //when item's found, move it y += 10; item.Location = new Point(x, y); everything works fine, when the character image "touches" the item, it is found. The problem is when I try to set a new location to the item using Random Random rand = new Random(); int x, y ...Show All

• Visual Studio 2008 (Pre-release) Does the .NET 3.0 July CTP include ADO.NET 3.0?

  The .NET 3.0 July CTP can be downloaded from here: http://www.microsoft.com/downloads/details.aspx FamilyId=62057A6F-185F-41DB-ABE5-678F6FC388F0&displaylang=en Does this include ADO.NET 3.0 If not, when ADO.NET 3.0 is released, will it be part of a .NET 3.0 CTP ...or a standalone CTP Michael. I'll take the heat on behalf of the company on this one :) Let me try to shed some light on versioning story, focused on how it impacts ADO.NET: The current version of the .NET Framework is 2.0. The next version that will ship when Windows Vista ships is .NET Framework 3.0. As per Soma's blog it will ship with Windows Vista and will also be available for Windows XP and Windows Server 2003. The 3.0 release contains the 2.0 bi ...Show All

• SQL Server How to increase SSIS performance

  Hello again, I'll just throw my question: how could I increase SSIS-performance I have a really heavy job with thousands of records my base selection, then I perform some lookups (I replaced most of them by sql) and derived columns (again, I replaced as much as possible by sql). Finally, after a slowly changing dimension task, I do update/insert on a given table. Is there a trick to speed up lookups and inserts (something like manipulating the buffer sizes - just asking). Fact is that I replaced a script task by pure sql-joins and gained 6 of the 12 hours this job took. Any ideas Greets, Tom Tom De Cort wrote: Hello again, I'll just throw my question: how could I increase SSIS-performance I have a really h ...Show All

• Windows Live Developer Forums Calculating boundingbox

  If I have the center and zoom-level of a tile, how do I calculate the extents of the tile In other words, what are the extents of a tile I know this changes because of the mercator-projection. The new tilesource spec returns a tileContext which only holds the three values mentioned above, which I think is far from enough to create a dynamic generated layer from a different datasource based on long/lat. Especially if you have t to perform on-the-fly reprojection to Mercator. Is it possible to extract the Mercator-coordinates, and translate the zoom-value to a tile-size based on these units Thanks for the link. I finally hacked it and ended up with this: http://showcase.sharpgis.net/ve . ...Show All