o-t's Q&A profile

• SQL Server Need help importing .CSV file

  Hi all- I am in need of some help importing a .CSV file into a SQL Server 2005 Express database. I can't use SSIS because it's SQL Server Express. The operation needs to run as a parameterized Stored Proc which I will call from ASP.NET. The problem is that I need to get the only 2 columns from the text file, then "tack on" 3 more columns that will have data that changes, which will come in as parameters to the T-SQL stored proc. This prevents me from using a straight BULK INSERT. The data in each of these columns will be the same for each record in that column - that is, every record in every field in column 3, for example, will be the same. Some of the files will have 4 million records and up, so speed is of the esse ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Platform options only at project creation?

  Hi, Like most I have talked with, I am doing most of my development / debugging on the PC and then deploying to the XBox360. One thing I have been unable to do is change the platform of a particular project. Instead, I have to have 2 projects and I literally just copy the files over or include from a common directory (where it seems to copy locally to that project directory for the c# using directives). In the project properties, the drop down box for platform only allows either x86 or xbox360 depending on what type of project you start, not both. Can I change the platform of a particular project from x86 to x360 The Windows Game Library can be added as a reference to an XBox 360 Game Project. From reading about the CLR, I assume this wi ...Show All

• SQL Server import flat file

  I am trying to import a flat file using SQL Server Management Studio and am receiveing the error: Error 0xc0202055: Data Flow Task: The column delimiter for column "Column 19" was not found. (SQL Server Import and Export Wizard) I would like to capture the rows that are causing the error and have the import continue. Am I able to edit the behavior somehow Thanks. Well, I read that you can 'use the Error Output Page of the Flat File Source Editor dialog box to select error-handling options'. How do I do this Thanks. ...Show All

• .NET Development ASP 2.0

  hello...! There is someone who can help me how to send a form into a database... or email it using ASP 2.0 Either way will be helpfull.. Thanks http://www.asp.net/forums / is where you want to ask this question. Thanks. ...Show All

• Visual C# How to give all users full rights to registry key ?

  Hello! I create some keys in registry and I want to each user has full rights to this keys. So I use AddAccessRule like: RegistrySecurity rs = new RegistrySecurity(); rs.AddAccessRule(new RegistryAccessRule(" Users ", RegistryRights.FullControl, InheritanceFlags.None, PropagationFlags.None, AccessControlType.Allow)); key = Registry.LocalMachine.CreateSubKey(someKey, RegistryKeyPermissionCheck.ReadWriteSubTree, rs); key.SetAccessControl(rs); It works when I run this on english version of OS because there is user group like ' Users '. But it does not work on other language version of OS (there isn't any group like 'Users'). How to solve this problem Thanks a lot. Sebastian I am not sure how to ...Show All

• SQL Server Unzipping a zip file-The magic number in GZip header is not correct.Make sure you are passing in a GZip stream.

  I have the following code in an SSIS package and I get the following error: Error: 0x0 at Unzip downloaded file, Boolean ReadGzipHeader(): Unable to decompress C:\ETL\POSData\IngramWeekly\INVEN.zip; The magic number in GZip header is not correct. Make sure you are passing in a GZip stream. Error: 0x4 at Unzip downloaded file: The Script returned a failure result. Task failed: Unzip downloaded file The zip file unzips perfectly using winzip utility, so that file is definitely not a problem here. The code I am using in a script task is as follows: ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Import ...Show All

• Visual Basic SQL formatter add-in for VS.Net?

  Anyone know of a SQL formatter add-in for VS.Net(2005) We're looking for something that will format sql as some of our developers format their sql different ways and yet others use the query builder in VS.Net for their stored procedure code (and query builder produces some pretty ugly sql). A formatter would help facilitate everyone formatting the same way. - Brad ...Show All

• Windows Forms Minimize child form with parent form problem!!

  Hi, I have FormA and FormB, FormA is the main form and I have a button in FormA when click will bring up FormB. The problem is whenever I Minimize FormA, FormB doesn't minimize with it. Please help me on how to do that, makes FormB minimize with FormA. Thanks Jason In FormB ButtonClick SubForm frm = new SubForm() frm.Owner = this.Owner; // Maybe and only this will work frm.show Best Regards Misa ...Show All

• .NET Development Internal .Net FrameWork Data Provider Error 12.

  Hi, I am using .Net Framework 2.0. And for accessing data Oledb data provider. This is used in a multi-threaded windows service. I am getting the following error on a select query. The stack trace is as follows. Internal .Net Framework Data Provider error 12. at System.Data.ProviderBase.DbConnectionInternal.CreateReferenceCollection() at System.Data.ProviderBase.DbConnectionInternal.AddWeakReference(Object value, Int32 tag) at System.Data.OleDb.OleDbConnection.AddWeakReference(Object value, Int32 tag) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteScalar() at File_Transfer.clsDataAccessObject.GetCellValue(String strSql) I don't h ...Show All

• Visual Studio Express Editions Write native Windows 98 Application in VB Express

  Is it possible to write an application in Visual Basic Express which runs 'natively' (i.e. without the need for .NET frameworks) on Windows 98 If so, how is this done If not, what's the best alternative for developing such an application on a Windows XP machine Thanks John Its only the first application which would be time consuming. After its installed once, all subsequent applications would detect the framework is present and wouldnt try installing again. So basically the first 2005 application installed on the machine puts most of the requirements down and everything after that should install pretty quickly. ...Show All

• Visual Studio Tools for Office From add-in to application

  I write add-in for Word 2007 ,like add-in it work .Then I create Windows application(on C#) put DsoFramer (for displaying word in my window) and put same functionality in this application then resolve all cross thread functions calls then not all functionality work in my app. Some times(when I add new content controls in BindingBlockGalery and then call functions for changing cursor position) my app not responding(Word.Application.MoveLeft(...)).What is can be Changing cursor position near or in BuildingBlockGalery not possible!Word not responding after that!            Object unit = WdUnits.wdCharacter;             Object e ...Show All

• Visual Studio 2008 (Pre-release) WCF and localization

  Is there anything out-of-the-box in WCF that allows the passing of CultureInfo I would like to have the service thread run w/ the same CurrentCulture and CurrentUICulture as the client side thread that made the service call. Is there something in WCF specifically for this or do I need to put that in message header and pass it that way Thanks, Ting WCF doesn't flow that information automatically, because that's really an application choice to make. You would have to use a header to flow that information and this would likely be a case for a custom client and server behavior extension and why we have those extensibility points. Clemens ...Show All

• SQL Server How to structure query

  I need to count distinct postalcodes from the customer table and then next to it put the number of times that postalcode was used and the state for the zipcode. Example output: 85007 / 12 / AZ 90210 / 4 / CA This is about as far as my knowledge takes me: select count(distinct postalcode) from customers Any help generating this query would be greatly appreciated. thanks! jeskey wrote: I need to count distinct postalcodes from the customer table and then next to it put the number of times that postalcode was used and the state for the zipcode. Example output: 85007 / 12 / AZ 90210 / 4 / CA This is about as far as my knowledge takes me: select count(distinct postalcode) from custome ...Show All

• Visual C++ Convert project .dsw from VS 6 to VS 2005 from command-line

  Hi, I was wondering how to compile a .dsw project written in Visual Studio 6 in Visual Studio 2005 from the command-line. The GUI would give me an option to convert but I need to use the command-line in Dos to compile from a script. When I try to use devenv project.dsw /upgrade, it just doesn't work. It prompted me to convert the project first. Does anyone know how to force it or work around Is there a tool to convert to VC 2005 automatically without using GUI Thanks. If I convert .dsp to .vcproj and compile the project.vcproj sucessfully. Would this the same as compiling the .sln I'm trying to understand the differences and possible effects of the output (.dll) when you compile .vcproj instead of the ...Show All

• Windows Forms Apply blue background color to Toolstrip control

  I would like to add a toolstrip control to our existing app with the blue background color. If I create a new test win app and add a toolstrip control the background color is blue. If I set the background color to the toolstrip to SystemColor.Control the toolstrip I get the grey background color. This is OK. But if I just add en empty form to our existing application and add a new toolstrip control, it always get the same background color as the form. And I would like the toolbar to have the blue background in Windows XP Style, and the silver background in XP Classic style, just my test app is showing. The only difference I can see is that in our existing application I'm starting the form from a Infragistics tabcontrol. The toolstip' ...Show All