John123's Q&A profile

• Visual Basic More flat file questions

  I've lots of success using the following code snippet to load my user screens, but I am having a problem because of the size of the input file. The Supplier file contains 845 rows with 11 fields of data per row. I think I want to load the entire file into memory and then be able to access the data on the fly, rewriting the file back to disk upon close of the application (since there is the possibility of data update). Using MyReader As New _ Microsoft.VisualBasic.FileIO.TextFieldParser( "C:\Program Files\Papillon\Vendors.txt" ) MyReader.TextFieldType = FileIO.FieldType.Delimited MyReader.SetDelimiters( "," ) Were this 10 years ago, I would build a multi-dimensional array to store the data, ...Show All

• SQL Server summing a column, using a pivot table, accounting for NULL

  hello, i'm using sql200 and i am attempting to create a table that has an hourly-incrementing 'Date_Time' column, with a corresponding 'Total' column (which keeps a running total of values off of another table) . The code I am using right now is... declare @date as smalldatetime set @date = dateadd ( yy , - 1 , cast ( convert ( char ( 11 ), current_timestamp , 101 ) + '00:00:00' as smalldatetime )) select dateadd ( hh , i , @date ) as Date_Time , sum (Subtotal ) as Total into #POGtable from Pivot , OrderGroup where i between 0 and 24 and CreationDate between @date and dateadd ( hh , i , @date ) group by i select dateadd ( hh , i , @dat ...Show All

• Windows Forms Can't convert int into string from sql database to listbox!

  Greetings! I started a course in C# and SQL and I'm kind of newbie. I know how to store values into sql database but i have problem loading integer values from the database to my C# application into the listbox. The only values the listbox shows are strings. But i want to also view my integers. So i need to simply convert my integers into string but since I'm newbie i would appriciate help from experienced people. I provided the code in the link below. http://pastehere.com/ biaphq you should really avoid the use of cast as it can have a perf issue/decrease and causing more work for SQL than what it had to be. you should be sure that the datatypes are correct before hand before finally inserting and using ...Show All

• Visual Studio Express Editions Program produces different results on different computers

  Hi all, I wrote a program about six months ago and uploaded it to a site. What the program does is read a text file and puts the results into a database. Obviously the program works ok on my system & I know it works ok on other users systems but I've had 2 reports of the program not working as it should on other systems that are using the same OS as me ( windows XP service pack 2 ) . I told one user to download the latest visual basic runtime files which he did and still there is no difference, I also got him to send me his text file which I tried on my system & it worked ok. The visual basic file he downloaded is ; Visual_Basic_6.0_-VB6-_runtime_SP5.exe I'm no expert on VB, far from it but this sounds really strange ...Show All

• Visual Studio Tools for Office what references do I need now I've updated to VSTO second edition

  Hi I've just upgraded my development machine to Office 2007, and now my Vis studio app won't build, as the following lines won't build Imports Word = Microsoft.Office.Interop.Word Imports Office = Microsoft.Office.core Friend WithEvents ThisDocument As Word.Document Friend WithEvents ThisApplication As Word.Application I expect that's coz the existing COM references aren't found - what do I need to do to get it going again I installed VSTO second edition.... My code is doing some word mail-merging .. ! Thanks ...Show All

• Visual Studio 2008 (Pre-release) Difficulty installing .NET 3.0 on Windows XP

  I'm trying to get .NET 3.0 working with VS 2005 so that I can use WPF. I've followed the instructions at: http://msdn.microsoft.com/windowsvista/downloads/products/getthebeta/#runWinFXApps I've installed on two machines - one a clean Windows XP machine - without any luck. The installation order has been: Visual Studio (already on both machines), Net 3.0 and then the SDK. No additional project types are shown in VS after install and an attempt at installing Orcas results in the error message that .NET 3.0 isn't installed. Any suggestions mikej .NET Framework 3.0 RC1 Windows SDK RC1 Visual Studio "Orcas" Extensions for .NET Framework 3.0 RC1 (also see readme for ...Show All

• .NET Development How to move the DB of my application and not die in the attempt

  Hi, I just finished my first application in C# that includes access to a DB. Everything (VS, code, SQL Express, DB) is on my computer. Now I would like to install the application in my coworker's PCs and have them all sharing the same database. What do I need to do - Should I install SQL in the server or just the DB - What files do I copy from my PC to the server - To change the connection is enough to the VS Database explorer, browse and find the new connection, hit the test connection button Sorry for all these questions. I did the SQL part using the VS Wizards, and now I'm completely stuck to do the DB related changes and have everybody sharing the same DB. Thanks, Isa ...Show All

• Smart Device Development .Net Compact Framework 1.0 SP3 cab file differences and release numbers...

  Hi, What is the difference between a netcf.all.* and a netcf.core.* file Also is there a way to find the release number of the file I'm having to check file size and file date to figure out which release it is Newb thanks, Jamie "all" is for CE 4+ based devices, "core" for PPC 2000/2002. CAB files have no "release numbers". ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 2D Lines

  I'm still a little new to this, and I was wondering if there was an easier way to draw 2D lines. I'm making a 2D shooter, and all the sample codes and tutorials I've found so far seem very complicated for just drawing a simple 2D line on the screen (for things like user-interface purposes). So the gist of it, as I understand it so far is : Create a List<Vector2> Create a VertexBuffer Create an IndexBuffer Setup transformation matrices (really needed for just 2D ) Call DrawIndexedPrimitves Correct If not, what am I doing wrong Any easier solutions -Charlie I got my 2D lines working, but now they won't change colors. I'm just gonna post my code, and if anyone sees why I can't get my lines ...Show All

• SQL Server Error installing SQL Server Management Studio Express

  Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express.  Today I noticed I needed to download the Management Studio seperate download.  I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:   Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..   Solved my own problem.  Once I moved the msi to C:\ the installation worked.  Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.   ...Show All

• SQL Server Dymamic connection strings in SSIS...

  I was reading through the following post regarding dynamic connection strings: http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=812814&SiteID=17 In this posting they talk about setting up a configuration file to setup the connection string, but I am not sure how to apply that connection string to my connection manager. When I go into my configuration file, I can see the connection string, and when I go into the advanced properties of the connection manager, under the "Named ConnectionString\FileName" property, I set the property value to the name of my configuration file, but when I test the connection I get an error that the connection string property has not been initialized. Can someone please assist me w ...Show All

• Visual Studio VS 2k3 Team install under Vista Business?

  Hi, all! Running Vista Business (MSDN subscriber) with latest patches. I'm attempting to install VS 2k5 Developer, and I'm getting a Compatability warning from Vista. Before going any further, I wanted to find out what (if any) were the gotchas I need to keep an eye out for (like this compat warning), or if I just plain can't run VS 2k5 under Vista yet. Also, my d/l of VS 2k5 is a couple months old, so should I just bag it and re-d/l, or is this image good I'm aware of the VS SP's, but I'm not at that point yet. Any suggestions welcome! Thanks! Steve http://pointerx.net/blogs/glozano/archive/2006/11/16/Visual-Studio-2005-on-Windows-Vista-RTM.aspx ...Show All

• SQL Server Semi-Additive Function not aggregrating on non-time dimension

  I have an on-hand quantity measure in my SQL Server 2005 Analysis Services cube. I set the Aggregate function to LastNonEmpty so that the measure will not sum up across the time dimension but will sum up across the product dimension. My problem is that this measure will not sum up across the product dimension when using LastNonEmpty. It properly displays the data at the leaf level of product but won't sum up for any of the parent levels. When I change the Aggregate function to Sum, it properly rolls up to the parent levels. But, of course, also rolls up the time dimension which I don't want it to do. Can someone provide me with some guidance on this Michael, I'm not sure what you mean ...Show All

• Windows Forms Can you make non-constant transparency :)

  Like this http://www.youtube.com/watch v=RAtbXP_BiXk Gradient in some places and opaque in another, and custom shadow. It's without copying pixels from background windows, as you can see there is no delay in animation unders window and outside it. Even if you think it's not good for general interface it's very good for antialiased window edges Also that rotating window effect ;) It works in WinXP and people say in Win2000 too with additional gdiplus.dll Hi Rambalac, The application in the video appears to be using Windows Presentation Foundation (WPF). You can find out more information here: http://wpf.netfx3.com/ Let me know if this helps! Scott Morrison Program Manager ...Show All

• Windows Forms WebBrowser doesn't have a "find" method?

  Hey, I'm a novice here and I've been looking though the MSDN documentation on the WebBrowser control and noticed there was no method for finding text in a document. This is a pretty serious omission. Is there a way of getting this functionality I don't see that property in the link I provided. There is a "Document" property but no documentText. I'm okay with making my own method, but I don't see how I'd achieve it since I need a way to select a word in the document. ...Show All