Rikard's Q&A profile

• SQL Server Variable problem in Excute SQL Task

  Hi there I have a bit confusing problem, In Execute SQL Task I am having a stmt like : (Select * from Emp where EmpNm= ) also I m passing variable value through Parameter Mapping. Problem I am facing is that if I remove brakets from both end task is executed successfull but if I but those braket as they are task execution fails. and i need those brakets as it is inside a if statement. Problem is with parameter passing ,even if i put some value as EmpNm="ABC " with brakets, it runs successfully Any Solution to above problem Thanks and Regards Rahul Kumar, Software Engineer Parameters often do not work with complicated queries, and a sub-query is classed as com ...Show All

• Windows Forms PictureBox

  i'm coding a Solitaire game.in this game we can change the card image.i mean game>bunch.i hope u get what i said. i think we'll choose the image from the picturebox and then with a parameter we'll send this image to another form and show the image there.i couldn't write the code.please help me . sorry it was my inattention :( and now the code is working but i cant see the pictureboxes.is there sth like that form.controls.add(picturebox) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Games Article in XBOX Magazine.

  Congrats to the teams who built iFactor, Eternity's Child, Racing Game, Wildboarders, and Last Alarm : The A.R.G.U.S Complex. All these games have write-ups with screenshots in the lates copy of "Official XBOX Magazine". (Just got  it in the mail yesterday) Also in the magazine, details on the next DBP contest. They list the prizes and they are very nice I must say!   Yes, however the magazine calls it "Racing Game". And the screenshot for the logo shows "Racing Game". It's the one by Benjamin Nitschke. Possible XNA Racer was a working title As for listing the prizes. I'll let the XNA guys do that... don't want to steal their thunder. ...Show All

• Visual J# vjc error

  Hi; Ok, while building my solution using nant vjc is throwing an exception. I told it to debug in VS 2005 and the error is at malloc.c: void * __cdecl _malloc_base (size_t size) { void *res = NULL; // validate size if (size <= _HEAP_MAXREQ) { for (;;) { // allocate memory block res = _heap_alloc(size); where size = 0. It throws the exception deep under that code but I think the size=0 may be the problem. The call stack is: kernel32.dll!7c812a5b() [Frames below may be incorrect and/or missing, no symbols loaded for kernel32.dll] kernel32.dll!7c812a5b() vjsc.dll!6d90d727() vjsc.dll!6d930468() vjsc.dll!6d930480() vjsc.dll!6d8f53a6() ntdll.dll!7c9118f1() ntdll.dll!7c911902() ...Show All

• SQL Server limiting the number of child rows

  Hi I have got two related tables (tblMembers and tblTickets) that have a 1 to 2 relationship i.e a member can have 1 or 2 tickets, but not more. How do I enforce this condition in SQL . Please help Hi Does this apply to SQL Server 2000 too Because right now, I'm experiencing quite different behavior.... I have temporal table where each row hase ActiveFrom, ActiveTo column. There is "primary key", but there can be more than one row with same primary key value as long as rows has different, not overlaping time interval specified by ActiveFrom and ActiveTo columns... There is no way to create real primary key here so i'm trying to create table level constraint using UDF which checks this..... ...Show All

• Windows Forms c# Insert Text into Textbox

  I have a series of textboxes on a Windows Form and a Series of buttons aswell. What I am trying to achieve sounds quite simple but I cannot figure out how to do it. Basically all Im trying to achieve is each button has some predefined text associated with it and when the user clicks the button, it inserts that text into the textbox which has the focus. The problem with this is that when you click on the button you lose the focus from the Textbox. The only way I have figured out is to save which control has focus before the button is clicked. This works but when you have 32 textboxes on a form, surely there is a better way than creating an On_Enter Method or similar to set the value of the Control which needs the text. Any help would be ...Show All

• Visual Studio Express Editions Chart Control

  I have upgraded a VB 6 application that has a chart.  The upgrade was successful but when I run the application I get the following error: System.InvalidOperationException was unhandled   Message="An error occurred creating the form. See Exception.InnerException for details.  The error is: Unable to get the window handle for the 'AxMSChart' control. Windowless ActiveX controls are not supported."   Source="WindowsApplication1"   StackTrace:        at WindowsApplication1.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 180        at WindowsApplication1.My.MyProject.MyForms.get_Form1()   &nb ...Show All

• Community Chat IBM Hawk

  I got to know abt a Logging tool IBM Hawk..Can any one help me for getting details about this tool related to Logging   AbhijeetSingh wrote: I got to know abt a Logging tool IBM Hawk..Can any one help me for getting details about this tool related to Logging Given that this is an MS forum, you're probably in the wrong place pal. I'd recommend: www.google.com  and www.ibm.com for starters.   ...Show All

• Commerce Server Unrecognized configuration section membership

  After my update from CS 2002 to CS 2007 i need to redevelope the hole User Logging System. Before in the old version the Microsoft.Solutions.Framework was used for the authentification but now I'd like to use the standard ASP.Net logging. As I read, I need to add The UpmProvider to my web.config but the result ist that i get the following Error: Error 101 ASP.NET runtime error: Unrecognized configuration section membership. What do I have to do now Does anyone have something like a complete example how to implement this Loggin System which would probably help me Regards OK, but where do I have to change this things I just took the ProfileSQL_Start.sql Script from the StaterSite an ...Show All

• Software Development for Windows Vista Install GINA DLL

  Hi, all Didn't find a forum on Windows XP, so my post is here. I have a stange problems with install/uninstall custom GINA. Running under Windows XP SP2: 1. Copy msgina.dll to the smgina.dll; 2. Set HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\GinaDLL to the smgina.dll and LogonType to the 0; 3. Reboot, logon; 4. Remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\GinaDLL and set LogonType to the 1. Or remove HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\GinaDLL, then set Welcome screen mode in User Accounts. Do not reboot; 5. Suspend/hibernate computer; 6. Return computer from standby; 7. Catch blue screen. Any ideas about reasons Anton ...Show All

• Visual Studio Tools for Office Manual Page breaks vs automatic page breaks in WordML

  Hi, I have a scenario where I'm programmatically generating WordML documents based on data from a database table. Sometimes, because of the source data in the database table, the output WordML a <wx:sect> tag spans more than one page in Word. Is there a way to insert a manual page break in the WordML for this section whenever this happens This way, I can make sure that for every row in the database table, the output will start on a fresh page in Word. At the same time, I want to avoid having consecutive page breaks which seem possible if I get this working. Thanks, JGP Be sure to let me know if I'm boring you... :-) Mail merge letters do this so that you can have a "Differ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiple Instances of the Same Model

  I've hit a really weird problem with the game I'm writing for the DBP competition. The reason it's so weird is because I'm sure it wasn't a problem before. Basically, I'm implementing the p1_wedge model in a class I have created called Player. Originally, I only had one player on screen but now I've added a second player. The problem I'm having is that it only draws the model for the second player. However, once the second player gets destroyed it then starts to display the model for the first player. It's as if the first player can't be drawn because the second player is using the model. I haven't done anything special to implement the Player class. I have made the main class a Singleton so that I have access to the graphics and content o ...Show All

• SQL Server Profiler for SQL Server Express 2005

  Dear All, I need a tool to see what transactions and in what order are being issued against the SQL Server Express 2005 DB. Because of the SQL Server tools don't come with SQL Server Express 2005, then i run SQL Server 2000's Profiler with SQL Server Express 2005. But It prompt error "Failed to start a new trace". FYI, i don't want to use the backend sql trace .in command prompt.. Pls advise me on how to run the sql profiler to trace the transaction being executed in SQL Express 2005 Thank you. Thanks for replying the email. I got the idea of this "SQL Server 2000's Profiler works with SQL Server 2005" from some other forum. However it doesn' t work at all. So is there any ...Show All

• .NET Development Exception Details.

  System.Data.OleDb.OleDbException: No value given for one or more required parameters. This is the trouble ~ But i don't know how solve it :P The code follow's down: public void bindDataGrid( string ProductId) { OleDbConnection myConn = new OleDbConnection (); OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter (); string sqlStr, connStr; DataSet myDataSet = new DataSet (); connStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=C:/Inetpub/wwwroot/csharp2005/Products.mdb" ; sqlStr = "SELECT ProductId, ProductName, Price FROM Products WHERE Price > 40 ORDER BY Price" + ProductId; myConn = new OleDbConnection (connStr); myConn.Open(); myOl ...Show All

• .NET Development Using Datareader with Access database

  I'm using VB.Net 2005 and my project has a MS Access database. It also has a table adapter, a binding source and a dataset. I would like to use a datareader or some other convenient method to display the first 2 columns from a table in the DB. Is it possible to use any of the other objects (like the binding source, or the table adapter) to do the same thing If not, how do I declare and use the datareader in VB You can use Brad Roberts example to use a datareader, however you can use a binding source as you suggested....Use a select query that only pulls the columns that you need and then bind a Datagridview to that binding source... Select Column1Name, Column2Name, Column3Name FROM MyTable ...Show All