Mike!'s Q&A profile

• Visual Studio Express Editions VB 2005 - dataset copy

  Hi, I have a dataset and I'm using it to display information on a datagridView. When I want to filter this dataset to search for rows, I don't want to change what is displayed on the datagridView. To make a copy of this dataset seems to be the appropriate solution, but I have my doubts: I'm using the TableAdapter querys to fill my dataset (FillBy...); Can I create a new dataset for the same connection and the same tables for the same datasource (mdb file) ; Using the TableAdapter querys is indeed the easyest way to preform the querys I want, I cannot make a copy by code and still have TableAdapter querys, can I Can someone help Thanks, Pedro When your DataGridView.DataSource is ...Show All

• SQL Server Best Way To Update Existing Rows

  IUpdating existing rows in a SQL server 2005 destination table --I have a CSV file and every row needs to perform an update on a production table The most straight forward is to use an OLEDB Command Data Flow Transformation Object that sends one SQL statement per row coming in. How do I configure this object That might be okay if you've only got a small number of updates, however if you've got a large set, I prefer landing this set to a temporary table and then doing Set based updates in a following Execute SQL task. Can you please tell me how I can set up the Execute SQL Task to do set based updates in the Control flow thanks in advance Dave Mr Pro Tools wrote: IUpdating e ...Show All

• SQL Server Error Locating Server/Instance Specified

  I am having a problem connecting to my sql server express instance from a remote computer. I continue to get the above mentioned error. If I connect for the localhost everything works fine however when I try to connect from a different computer on the LAN it gives me this error. I have turned on remote access and still no luck. Any ideas Any help would be appreciated. Odds are you haven't created exceptions in the firewall on the remote computer to allow SQL to communicate through it. Check out the complete instructions for enableing remote connections to SQL Express in the KB, http://support.microsoft.com/default.aspx scid=kb;EN-US;914277 . FYI - This info is in the FAQ at the top of the forum is you ...Show All

• Community Chat My Creation, "The Door Game"

  This is really my first actual program I made, it's pretty simple but amusing, the only this is I need to know how to get it to randomly choose between which message to display when a button is pressed then have the other button say the remaining choice, I also need it to show a specific image, depending on which message the random message generator chooses item the random message when a button is clicked, I keep getting the "Cannot implicitly convert type 'string' to 'System.Drawing.Image' " message, please help, the code is below if you want to mess around with it and let me know what you find. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using Sy ...Show All

• Visual Studio 2008 (Pre-release) Xaml troubles

  Great to be a part of the community.  I'm having a lot of trouble with the implementation of xaml files with vs2005.  I've installed everything neccesary to run winfx stuff (the winfx rtc, windows sdk, winfx ctp extensions dec 2005 and vs2005) successfully but am having difficulty getting a xaml file to run with presentationhost.exe.  Here is an example.  I write this and save as test.xaml... < xml version="1.0" standalone="yes" > <Window>   <Button>Hello World</Button> </Window> and i get this... "An error has occurred in the application you were using" window + more details.. Startup URI: C:\Documents and Settings\CJ\Desktop\test.xaml Application Identity: file:///C ...Show All

• Visual Studio Express Editions How do I test for nulls in a date column?

  Visual Basic 2005 Express: When a patient record is added to the SQL database table, the default date is being entered, but, if the user deletes it, the program aborts with a: System.Data.SqlClient.SqlException was unhandled   Message="Cannot insert the value NULL into column 'BirthDate'   column does not allow nulls. UPDATE fails. BirthDate is part of the primary key, so, I cannot specify "Allow DbNulls". I added 2 different "If" statements, but neither one of them is catching the condition: If IsDBNull(PatientBindingSource.Current( "BirthDate" )) Then    PatientBindingSource.Current( "BirthDate" ) = DefaultDate End If If PatientBindingSource.Current( "BirthDate" ).ToString = "" T ...Show All

• Windows Forms DataGrid and DataGridView issue?

  I am trying to use either a DataGrid or a DataGridView to list records that could later be edited through the click even of a row. My problem is this: while I am developing, I have to basically re-create the control by editing the designer generated code if changes are made to the control after compiling the app. Is there a way to get around this, or am I doing something wrong I understand that, and even as we speak, I have made some changes in the properties window, and when I compiled the app again, I got a an error that tesst me that the datadrig control does not exist.  However, when i look at the designer code, the Datagrid is there as a private variable, and is not available to the UI th ...Show All

• Visual Studio Team System Ignore users

  I have created a project from the Production DB, in each DB, QA, staging and development different set of users may exist. How do I set the VS to ignore users when building and deploying. How do I set VS to drop and re-create all SP Views and Function on change. We have used the if exists drop to refresh the Date Created in SQL Server 2000, as you know the alter will not change that. But we an live with the ALTER. As for users my setting for Generate DROP statements that are in the target database but are not in the database project is OFF. And the user doensn't exist in the Production DB but exists in the QA. When running the build the server DROPS this user from the QA DB: PRINT N'Alt ...Show All

• .NET Development DataSet Merging

  While merging a dataset ino another, i am getting the error datatype mismatch for the column <column name> ds1 have 5 columns ds2 have 3 columns, i want to merge both, before that i want to install values into the dataset ds2 guide me please The error msg already explained what happened. The columns with the same name in ds1 and ds2 have different data types. BTW, posting the code & detailed error msg is always helpful to the diagnosis. ...Show All

• Visual Basic Question about executing a program written in Java from an application being developed in VB .NET.

  Hi, I would like to execute a program written in Java from an application that I am developing in VB .NET. Can this be done by writing: System.Diagnostics.Process.Start("java MyClass", "arg1, arg2, ..., argn") Any advice will be helpful! Thank you. Thanks for all your help previously. I thought you may be interested in the fact that a java program can also be called from VB .NET through cmd.exe by passing the name of the java program to myProcess.StartInfo.Arguments. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can't get model to display properly

  Hi, I have a created a airplane in 3DS Max (it's not finished), but i have rendered it you can see it here: http://home.exetel.com.au/feldaspar/plane_rendered.gif When I go to diplay it while running the game from XNA stuidio express all I get is this: http://home.exetel.com.au/feldaspar/game.gif I think it is probably more the way it is being output from 3DS Max, but i'm new to both XNA and 3DS so I dont know. I exported it using the FBX extension, filmbox. This is my code: protected override void LoadGraphicsContent( bool loadAllContent) { if (loadAllContent){ mymodel = content.Load< Model >( @"Content\Models\p11" ); } } ........ protected override void Draw( Ga ...Show All

• SQL Server The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro) after SP1

  Having installed SP1, my SSIS packages using the OLE-DB Provider for Visual Foxpro no longer work. Using the latest version obtained from here: http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en When attempting to create one SSIS from scratch, the message thrown is: "The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro)." The radio button option of "Copy data from one or more tables or views" and then selecting the "Next >" throw the error. It has to be the SP1 causing the problem because nothing else changed on the Server and everything was working fine prior to this. Microsoft, any feedback on this ...Show All

• Visual C++ Multi-dimension arrays in VC++ 2005 for n00bs

  Okay, a little background: I'm an aerospace engineer, not a programmer, but I'm experienced in C, and I'm using VS2005 to make some simple-ish tools for our group. I'm trying to declare a multi-dimensional array in VC++ through the 'standard' method... double test[5][5]; ...and then access it in the 'standard' way... test[0] = something I'm putting in there.; ...but it's not working. When I debug, the Watch says that test is a double[][] of length 5. So far, so good, but when I expand it, instead of the 'standard' syntax, it comes up like this.... test[0,1] Length 0 double[] test[0,2] Length 0 double[] ...and so on. I've dug through our copy of MSDN, and online and there ...Show All

• .NET Development How can i use SqlTransaction with TableAdapter in generated DataSet?

  Hello, I have created TableAdapter in dataset. now i use Insert method of tableAdapter for enter data into table. i have a master and detail table. now somehow if error generate while i am entering data in detail table so on time master record autometcily remove from master table. so anyboday can help me that how can i use SqlTransaction in this senario The first technique didn't seem to do anything for me.  I'm using a firebird database, so perhaps it is a weakness in their .NET implementation.  It might be that I need to write additional code to make sure that System.TransactionScope uses the Firebird .NET client.  I have no idea... When I try the second technique with the explicit transaction, I get the fol ...Show All

• SQL Server How to align the text in justify format with SQL Server Reporting Services?

  How to align the text in justify format In SQL server Reporting Services Is there any code to do so Hi, I'm afraid that if you want to have this kind of functionality, you will need to write a custom control. Here is an example: http://msdn2.microsoft.com/en-us/library/ms345265.aspx . The issue with custom controls is that it needs to be known by all the reportservers that will render your report. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All