Erl Egestad's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. Can't use Microsoft Points to subscribe to XNA Creators Club?

  Hello, I want to become a member of the XNA Creators Club, and because I don't own a credit card I went out and bought 2 x 2100 Microsoft Points (because it also showed "redeem code" as a payment method). After entering both the 25-character codes, it didn't accept this as a payment method.. So now I'm stuck with 4200 Microsoft Points and an empty wallet. Is there a way to become a member using the Microsoft Points Or do I really need to use a credit card Because then I'm screwed.. Thanks. George Clingerman wrote: You don't have to have an actual credit card (although you still threw away the money on the points). You can go down to your local bank and get a pre-paid credit card and ...Show All

• Smart Device Development Error occuring while querying multiple table data from database to dataset

  Hi dataAdapter = new SqlCeDataAdapter ( new SqlCeCommand ("select * from sample;select * from Test", connection) DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); error Occured: Message = "There was an error parsing the query. [ Token line number = 1,Token line offset = 22,Token in error = select ]" Note: Same code working with sql client, I set the table mapping in both the cases. anyone, any suggestions please Hi the following code is published on MSDN website DataSet dataset = new DataSet(); dataset.Tables.Add("aaa"); dataset.Tables.Add("AAA"); adapter.Fill(dataset, "aaa"); // Fills "aaa", ...Show All

• Visual Studio Font color in TextBox on rdlc

  Hi everybody, is there any way to select dynamicly font color in TextBox on rdlc report The color has to depend on data in TextBox. I use local WinForm report. When in TextBox is CompanyName1 I would like to set red color in TexBox but if there is CompanyName2 to set blue color font. help please! Thanks for your help, I received an error: Error 1 The BackgroundColor expression for the textbox ‘myCompany1' refers to the field ‘textbox’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. I am trying to resolve my problem but I am afraid it's impossible :( best regards Robert ...Show All

• SQL Server How to eliminate duplicate data

  I have a table with 68 columns. If all the columns hold the same value except for one which is a datetime column I want to delete all but one of the duplicate rows. Preferably the latest one but that is not important. Can someone show me how to accomplish this You can use the Group By fucntion SELECT col_a, col_b, col_c From Table GROUP BY col_a, col_b, col_c If you want the newest date - you can also using HAVING Clause SELECT col_a, col_b, col_c From Table GROUP BY col_a, col_b, col_c HAVING max(col_date) WHERE col_a - col_c are the columns with the same data and col_date is your date column AWAL ...Show All

• Visual Studio Express Editions Running programs that are outside my own

  the objective is to make a menu for a autorun CD that once clicked on an item runs a particular .exe file separate from my own. the file is very old dos file made from .bas with QB7.1 but i got it to work with the command "System.Diagnostics.Process.Start()" though it doesn't show the PRINT as this: prog inputs: dia#: Mes#: ano# But does't show nor this print for input nor the result print: the screen is black but if you press the keys it goes to next line as if it was working but not showing. Any sugestions Thank you, JDuarte. If I understand this correctly... the .exe works when executed from the command line (or Windows Explorer), but not with Process.Start() Does i ...Show All

• Visual C++ exception '0xC0020001: The string binding is invalid.' on application exit

  I have a managed app that uses a native library wrapped in a managed wrapper. After making adding a wrapped class to the library it started to produce the above exception on exit. I couldn't find any help with this specific issue when searching and am posting this in case it helps the next person to have this issue. I resolved it by following the the instructions here: http://support.microsoft.com/ id=814472 The odd thing is that I don't get the linker errors which the article describes. I solved it! The problem was a static CWnd window in one of my classes. After changing the static member to a "normal" member, everything works fine. Thanks again for your help. Jus ...Show All

• Visual Basic KeyDown event problem

  I am currently using the KeyDown event to make a picturebox named "bar" move left and right with the arrow keys but my problem is that when I press left or right the bar moves once, then is followed by about half a second of not moving, then continues to move. How can I modify my code to get rid of the delay Private Sub Form1_KeyPress( ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase .KeyDown If e.KeyCode() = Keys.Left And pad.Left > 0 Then pad.Left = pad.Left - 10 End If If e.KeyCode = Keys.Right And pad.Left + pad.Width + 16 <= Me .Width Then pad.Left = pad.Left + 10 End If End Sub ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sprite animation

  Let me start off by saying that I ALREADY KNOW how to animate sprites. I think the way I've been doing my animation, though, isn't really recommended as it can cause hiccups. Here's what I've been doing: I've got a sprite class. This class has a DateTime member called startTime. It also has a TimeSpan member called timePassed. In my constructor I have the following bit of code at the very end: public Sprite() { ... DateTime startTime = DateTime.Now; } which sets the initial point of reference for the sprite. I've also got an UpdateFrame function that basically checks the current time, sees if enough milliseconds have passed, and either exits or changes the frame of the sprite: //this will check to see if it's time to change the animati ...Show All

• Visual Studio Express Editions problem installing a programme - clr20r3 invalidoperationexception

  Hi, I have a VB2005 app that works perfectly on my PC and the other PCs in my house, and on my work pc, all of which have MSOffice2003. The programme uses a COM MS Spreadsheet control. However, when trying to install the programme on another computer, which I think may have an earlier version of Office, I get the following error message: " Sudoku Solver has encountered a problem and needs to close. We are sorry for the inconvenience. Error signature EventType:clr20r3 P1:sudoku.exe P2:4.0.3.2 P3:454667c2 P4:sudoku P5:4.0.3.2 P6:454667c2 P7:f P8:c6 P9:system.invalidoperationexception " The Error Report itself has the contents of 66 Modules, 11 Threads and 386 Memory Ranges. I've refe ...Show All

• SQL Server Do you need to be a programmer to use SSIS?

  Hello I've been looking for SSIS examples where you need to import data from a OLE DB datasource and export it to a OLE DB destination source whilst the data in a colum is being transformed with a simple SQL statement. For example: SELECT ( CONVERT ( datetime , Left( Counterdatetime , 23 ))) datum FROM CounterData It seems to me that you have to use the Script Task Component ans start coding in Visual Basic.Net (or whatever) Am I missing something here or is it normal you have to be a programmer to do simple thins like that Many thanks! If i understand your question correctly, the Script Component may be overkill. You could just drag over the OLE DB Dest and Source. Between the two item ...Show All

• Visual Basic How to access the 'table description' data using VBA in MS Access.

  I want to be able to use VBA to access the 'table description' data that I have entered in the properties form for each table I have created in my Access database. I can access the table names via the AllTables collection but this does not allow me to access the data I have entered as a 'description' for each table. Can someone help me with the code as to how I can extract and use the 'Table Description' data which I have entered via the Properties form for each table Many thanks... Michael Daly (31 Jan 2007) MichaelDaly, According to your VBA question, I just searched the related objects and method. I suggest you to read some of the information on CurrentData/CodeData Object on Access 2003 VB ...Show All

• Windows Forms IE7 hangs when using Click Once Deployment from VS2005

  My workstation got updated recently to IE7 from IE6. I use the Click Once Deployment feature of Visual Studio 2005 on a daily basis. When using Click Once deployment, the app gets published and IE comes up to the publish.htm page to Install the app. With IE7 however, after the app is published and IE comes up - it just hangs with the message "Connecting". When I go to close down IE7 - I get the "Application not responding" dialog box. The application still gets published, and if I go to the publish.htm page manually from IE7, I can reach the page and install the app, or if I set up a hyperlink to the page. But when the page is brought up by Click Once Deployment from VS2005, IE just hangs. Has anyone else had this pro ...Show All

• Visual Studio Team System Error in Team Explorer

  We've got a number of projects defined in our TF system, but on one the Documents folder refuses to expand. The project in question is very new - in fact, there has only been one document change at this time. There's a little red "x" on the folder and no documents or sub-folders are listed. Refreshing the view doesn't change anything and right-clicking the folder does not open a context menu. I've done some searching and come up with this thread which describes similar problem symptoms, but the cause is not permissions related. My account is set as a project administrator on the site and the project. https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=183669&SiteID=1 The project portal works fine. I can access all ...Show All

• .NET Development Receiving Data From PDA and Read its data error.. pls help

  I am currently creating a project for which my PDA will send its mouse event over to the remote PC and the program at the remote PC will read its data. but i am currently get a "ArgumentException was unhandled" : "Argument Length must be greater or equal to zero" in the function Private Sub SerialPort1_DataReceived( ByVal sender As Object , ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived txtreceive.Invoke( New myDelegate( AddressOf updateTextBox), New Object () {}) End Sub my full program belows: Public Sub updateTextBox() txtreceive.Text = "" With txtreceive .AppendText(SerialPort1.ReadExisting) ' & vbCrLf) ...Show All

• Visual FoxPro Filename and nullchars

  I hope everyone had a good xmas and santa gives you a lot of presents :) Now, my question: try this code in VFP9: pParam1 is a parameters which contains a folder name. The folder must contains EMLs, but can be another file, just change the extension. cString =pParam1 + Chr(0) nEMLs =aDir(aEMLs, pParam1 + "\*.EML") For iEMLs =1 To nEMLs cString =cString + aEMLs[iEMLs, 1] + Chr(0) EndFor StrToFile(cString, "C:\FileNames.TXT", 0) If you open the TXT file with Notepad.EXE you will see squares and other unreadable chars. If you open the file with FileToStr() and post the content in the VFP _screen, the names are ok, but if you send it to a messagebox() you'll see an empty messagebox. Thus, if you send to the messagebox( ...Show All