SHISHIR WAHI's Q&A profile

• SQL Server Severe bug with typed xml - Is there a fix available?

  I keep getting the error message "An error occurred while executing batch. Error message is: Unexpected end of file has occurred." when selecting a column that contains typed xml. I can save the xml into the column ok, load it into a variable ok, but when I try and select this column using the select statement I get the error. After spending months in development we have finally launched our system into production and are flooded with hundreds of these errors. It does not occur all the time only for some values. This is definately a bug with the xml parser. Is there anyway I can formally submit this as a bug Here is some code to reproduce the problem. Funny thing is that by modifying the xml only by a single character or ...Show All

• SQL Server How to Convert String Data type to DateTime in Derived Column Control In SSIS Package

  Hi , I am Using Derived column between Source and Destination Control. the Source input column PriceTime is String Data type. but in the Destination is should be a DATE TIME column. How to Convert this string to DateTime in the Derivied Column Control. I already tried to in the Derived column control PRICEDATETIME <add as new column> ((DT_DBTIMESTAMP)priceDateTime) database timestamp [DT_DBTIMESTAMP] But still throwing Error showing type case probelm Pls help me on this Thanks & Regards Jeyakumar.M If you mean a SQL Server Tmestamp, then that has nothing to do with dates and times. If you mean DT_DBTIMESTAMP, then it works fine for me. Can you be clearer what your probl ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I need help displaying text in an XNA game

  I need help displaying text in my game I have everything in the game (sprite movements, game rules, and other stuff like that). I just don't know how to go about displaying text I tried looking for tutorials, but they were kind of confusing. Thanks in advance. Well, there isn't any native or built in text support in XNA. So basically when you want to draw text, you are just drawing another sprite. Typically, what you do is create a single image with your font in it. So you draw out an A, B, C, D, etc. (all of the letters, number, symbols, etc) that you want to draw. Then in your code you have to write functions that will draw those for you. So when you want to draw the letter "A", your code ha ...Show All

• Visual Studio Express Editions Cancel deletion

  I have a FormView on my ASP.Net page with EDIT, DELETE and NEW command, connectet to SqlDataSource1 I want a MsgBox to pop up when I click DELETE to confirm deletion. How do I cancel deletion in the MsgBox code The other thing to be very careful of on ASP.net pages is the use of things like msgbox methods which will occur on the server and not on the client. This is almost certainly not what you actually want but whne your are developing and you machine and the web server are the same machine - it can present you with a illusion that the messagebox will appear on client machine when you run the application.... Any Asp.net questions best answered on asp forums. ...Show All

• Smart Device Development Freeze Columns DataGrid

  Hi, Please, how to freeze the first column DataGrid when moved scrollbar. My application for WinCE.Net 4.2. Thanks Only by using 3rd party data grid with this feature or by writing your own data grid, I'm afraid. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Keyboard Text Input

  Is there an easy way to get a standard ascii (ok, unicode, whatever..) character from the XNA keyboard input   I'm looking to type some normal text in - and need to be able to support different keyboard layouts(particularly UK/US) and preferably international characters as well. I actually checked that before posting(Keys, go to definition), but I need more keys than just a-z, 1-0, and I'd really prefer not to hard code it when it is supposed to be in windows already, people get confused if it defaults to a different keyboard layout than the one they are using.  I guess I can rewrite the entire keyboard layout driver/thing, but that seems like silly duplication somehow and ...Show All

• Visual C++ destructors and SEH

  got code class A { public: ~A () { std::cout << "~A\n"; } }; void f2 () { int u = 0; //int z = 9 / u; throw (0); } void f () { A a; f2 (); } int main () { __try { f (); } __except (EXCEPTION_EXECUTE_HANDLER) { std::cout << "exc\n"; } } output : exc code : class A { public: ~A () { std::cout << "~A\n"; } }; void f2 () { int u = 0; //int z = 9 / u; throw (0); } void f () { A a; f2 (); } int main () { try //__try { f (); } //__except (EXCEPTION_EXECUTE_HANDLER) catch (...) { std::cout << "exc\n"; } } Output : ~A \n exc code: class A { public: ~A () { std::cout << "~A\n" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA networking help

  Hi, I ' m just starting to work with XNA and I'm having a doubt planning my project. I would like to make any application (for example the Space Invaders) and develope a multiplayer on-line version for this. What would you think it could be the best idea for this I have thought on these ideas: -Using the libraries of System.net for send messages between two players, but it could be very slow... -Use an existing game server (a game engine, that includes everything related with communications etc) and try to connect this with XNA game. I am looking for a free-source game server, to include my xna game in any place, but I haven’t found anything.... Do you know any way to solve these Thanks! I ...Show All

• Visual Studio Installation problem solved in SCSF...

  Hi, I am using .net 2.0/VS 2005 , Prev. I have used entlib 2.0 jan 2006,so its alreay installed in my Win XP-SP2 machine Now I have another reqmnt. to develop a smart client appln. using smart client s/w factory. so successfully installed GAT, but not GAX(it shows the fatal error) , last week tried to create guidance packages thru vs 2005 -->new project.. but in the templates page( RH Side) theres no smart client dvlpmnt project . so i tried to unsitall GAX/GAT, so that i will get a fresh installation. but during the Uninstallation i got "Fatal error during installation". so i hav gone thru this forums , & deleted the entries from recipeframework.xml file,( got from Tom Hollanders blog) && also deleted the entries ...Show All

• Software Development for Windows Vista User assignment via ActiveDirectoryRole?

  Hello! I'm trieng to find some kind of out-of-the-box user assginment or to implement it. I took a look at the ADRole-SDK-Sample: There is a ActiveDirectoryRole created and added to a WorkflowRoleCollection. But they were not really used. What can I do with these Activities Can I assign an Actitivity, for example a code activity, to a ActiveDirectoryRole Can I get the manager of a user with the getmanager-method How will the user be informed about the workitem do i've to implement some kind of mail delivery Therefore do I use the WorkflowRoleCollection These sample also works with windows ideties. Therefore Thanks a lot, kind regars, Matti In the sample the HandleExternalEventActivity Initia ...Show All

• SQL Server Same effect as Cross Join?

  How can I achieve the same effect as a cross join (since the merge operator doesn't have a cross join) Situation is this... a flat file has some header and footer information that I need to keep and attach to each row. So for simplicity sake of an example lets just say header has only 1 thing we care about - a row that says DATE=01/01/06. I take the file and run a split to split into "Date" "Data" and "other" (other has all the throwaway rows in header and footer I don't care about). Then I use a derived column object to get all the columns out of the "Data". Finally I want to add that Date metadata back to every row in the data... I thought this would be an easy thing to do.. but I can't s ...Show All

• SQL Server Convert row with text field to column

  Hi experts; How can I generate the result using typical SQL statement based on the following tables Table a - Salesman (salesId, Name) pk : salesId Table b - Invoice(InvoiceNo, salesId, InvoiceAmt) pk : invoiceNo fk : salesId -> Table a The result set : salesId, Name, sum(InvoiceAmt), InvoiceNos with comma separator For example: Table a SalesId Name S001 Peter S002 Alice Table b InvoiceNo SalesId InvoiceAmt INV001 S001 $100 INV002 S001 $100 INV003 S001 $400 INV004 S002 $200 Result set SalesId Name Sum(InvoiceAmt) InvoiceNos S001 Peter $600 INV001, INV002, INV00 ...Show All

• Visual Studio Team System how can I build the VS2003 program automatically?

  I use VS.net 2003 to do my work, in order to use the source control of the TFS, I download the Visual Studio Team Foundation Server MSSCCI Provider, now the source control can meet my need, but the dailybuild failed, how can I build the VS2003 program automatically Thanks a lot ! There's not a great way to go about it as VS 2005 doesn't build 1.1-only apps and msbuild doesn't understand VS 2003 solution files, but the best approach is to use MSBee. http://blogs.msdn.com/gautamg/archive/2006/04/19/578915.aspx Buck ...Show All

• Windows Live Developer Forums Windows Live Search API (Needs to be Simplified)

  I was pretty disappointed with the amount of code it takes to return search results from the Windows Live MSN Search API. Why should I have to maintain three separate class and 60+ lines of code to return a simple list of related search items. My recommendation would be something like. '--------Return a simple list of results-------------------- Dim objMSNSearch as New com.msnSearch.www Dim strXML as string objMSNSearch.Results = 3 objMSNSearch.KeywordSearchText = txtKeyword.text objMSNSearch.AppID = "ABCDEFG" objMSNSearch.DisplayCache = True strXML = objMSNSearch.WriteSearchResultsXML 'This would return...... <MSN> <SearchResult> <SearchTitle>Star Wars: Welcome to the Official Site</SearchTitl ...Show All

• Visual Studio Express Editions progress bar....please help

  can anyone please help with this progress bar Dim i As Integer Dim TrackLength As Integer = 100 Dim TrackPosition As Integer = 0 Dim TrackPositionPercentage As Integer = 1 Bar1.Value = 1 If TrackLength > 0 Then TrackPositionPercentage = CInt (TrackPosition / TrackLength * 100) For i = 1 To 100 Bar1.Step = 1 Next (i) End If I thought that was it in red edit.......do you give up now......lol Private Sub Timer1_Tick( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Bar1.Minimum = 0 Bar1.Maximum = 100 If TrackLength > 0 Then TrackPositionPercentage = CInt (TrackPosition / ...Show All