Roopesh Kumar's Q&A profile

• SQL Server Convert row data into Column

  Hi members I got the result set as shown below (By executing another query i got this). Month Status Count ===== ====== ===== April I 129 April O 4689 April S 6 July I 131 July O 4838 July S 8 June I 131 June O 4837 June S 8 May I 131 May O 4761 May S 7 But, I need the same result set as below Month I O S ===== = = = April 129 4689 6 July 131 4838 8 June 131 4837 8 May 131 4761 7 Can anyone provide me the tips/solution. What you then could do is to query for a table as the following Month January February March (...) ======================================= O 2 10 100 ---------------------------------------------------------------------- I 15 ...Show All

• Smart Device Development Secure deployment

  I am trying to deploy some apps to PPC. I would like to know some security issue regarding CA, signing my apps and install them on PPC. My main purpose is to prevent the user from installing my apps on a different machine than i assigned and to install other apps other than mine on that PPC. Sorry I am still new to the deployment and security area. I'm more of a developer. Anybody knows any good articles about it .netcf does not have any built in mechanism to do the types of licence checking you are looking for. Have you looked into what Handango ( http://www.handango.com ) offers ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I cannot compile any XNA tutorials

  I have Microsoft Visual C# express and XNA Game Studio Express, but when I create a new project and follow the tutorial (any tutorial) and copy and paste the code into a new project, i cannot compile because there are errors when i press F5. Example in tutorial 1: displaying a 3d model on the screen i follow all the directions and when i copy and paste the code at the end and hit f5 i get the first error in this line: myModel = content.Load< Model >( "Content\\Models\\p1_wedge" ); and i cannot continue. I have tried several tutorials in the past weeks and none run. I need help for doing this for school. Thanks I copied the one file into the models folder and the other into textu ...Show All

• .NET Development Cannot terminate Webbrowser control after security popup

  Hi, I have written a c# Net 2.0 application that uses a webbrowser control for displaying some web content. (the actual web content is beyond my control, however). In order to handle browser crashes, html errors, virus alerts and the like, I have implemented a timeout counter, that kills an unresponsive webbrowser form by using the Application.Exit() method. This works well on PCs with IE5.5 and IE6, but does not function on IE7 if there is an IE security popup of any kind. I can see that the timeout event fires correctly, but Exit() cannot terminate the application. I tried to find a way to suppress these security messages altogether, because in this case I would like to stop rendering anyway, but to no avail. Since the timeout solution o ...Show All

• .NET Development ConfigurationManager.AppSettings not reading my app.config

  I am having a frustrating issue that everyone tells me should be very simple to execute. I'm using the new ConfigurationManager object from System.Configuration.dll which I have referenced in my project. I do not have any compliation problems or warnings, yet I cannot get a single key value out of my app.config file. My config file looks like this: < xml version="1.0" encoding="utf-8" > <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings> <add key="KeyName" value="KeyValue"/> </appSettings> </configuration> and am trying to just assign this to a string like this: string path = System.Configuration.ConfigurationMan ...Show All

• SQL Server alfanumeric counters?

  Hi there, T-sql 2005 is offering the possibility to define alfaphanumeric counters I mean, stuff like this: a,b,c...z, a1, b1...zn...a2.. Is it possible or it must be built for yourself I'm awared of IDENTITY function when I ran Sql2k but it doesn't target my goal. Thanks for your time, You could do this in a Data Flow in one of two ways- 1 Use a Script Component, and included in you could also consider a custom component, at the end of the day the code will be the same, just how you package it. 2 Use a Derived Column. You would also need a row number, so either from the source, a script component or the Row Number Transform. Using the row number you could derive the a, a1, c2 etc format you requir ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. creating custom effects for .x models

  I want to use a .x file just for the vertex data so I can create my own shaders and try to implement different effects. Does anyone have any samples or tutorials on this Here you can find an example on how to do this ...Show All

• SQL Server Network share/Multi user deployment

  Can a SQL Server 2005 Compact Edition database file be deployed on a file share and be accessed by multiple (5-10) concurrent users This is a current scenario being implemented at several sites using MS Access databases. Each client would have the SQLce engine installed on it and would only access the database via a managed C# application. .... which is another good reason to use datasets with CE rather than the much pushed recordset model.... ie open connection fill dataset close connection would allow a certain amount of sharing Brian ...Show All

• .NET Development Dictionaries and invalid keys: return the key in the exception?

  Dictionary<TKey, TValue>.Add throws an ArgumentException if the key already exists. Dictionary<TKey, TValue>.Item throws a KeyNotFoundException if the getter is called and the key does not exist. Why do neither of these exceptions contain the key that's causing the error It seems like it would be easy to do by using Exception.Data, or at least providing the key in the KeyNotFoundException class. Hi Usually exceptions are generic errors that do not contain information about the context. Why don't you add the information when the exception is thrown You can catch the exception and get the key that your are trying to assign. Cheers ...Show All

• Visual Studio How to get list of files in a solution?

  How can I get a list of all files on which a solution depends By this, I mean all the files which would be required to build the solution on another, new, machine. I'd prefer a method that can create a file containing the list of files. Perhaps a makefile would have this information. Hi, The article I created gives you a reference to the IDE object. From there on, you can follow this example: http://www.mztools.com/articles/2006/MZ004.htm Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Windows Forms Can't select new columns in DataGridView

  2005.net, 2005 sql I have a DataGridView displaying most of the cols in a table. I added a new col to the sql table and it is a live field in the app ok. The new column displays in the server explorer after a refresh. Now, I want to add that new col to my DGV. I select ADD from the columns collections editor and I cannot select the new column as it is not in the list. I have saved, restarted 2005 .net and even rebooted. I even deleted it and added a new one with the same name. Still I cannot see the new column to add it. Why can't I add a new col to a stupid DGV. Any clues Solved. I found my way thru the maze and edited the dataset control which eventually allowed me to reference the new column in the co ...Show All

• SQL Server Calculate Median Value

  I am converting a report created using Crystal Reports 10 to Reporting Services.  The report contains a list of items with dollar values.  The original report displays both the Average and Median value.  I can easily ( using avg(Field1.Value!) ) determine the average but cannot find a function to determine the median. How can I add the Median to the report   Thanks in advance, Greg Median is not currently supported, and is on our wishlist for future releases. For now, you can use custom code to calculate median: 1. define a array in custom code and a function that takes a value and adds it to the array 2. wrap the call to the function in an aggregate and add i ...Show All

• SQL Server Sequel 2005 installation Perflib problem

  Hey everyone, I'm trying to install SQL 2005 developers edition on my local PC and I get the following error during the System Configuration Check: - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. I looked it up in MSDN and i'm having problems resolving the problem. How to: Increment the Counter Registry Key for Setup in SQL Server 2005 says I should match the values of "Last Help" and "Last Counter" f ...Show All

• Visual C# Need suggestion on Charting component for use in C# application

  Hi. Not really sure where to put post this question but I figure this is the closest (I hope). I am currently looking for a good charting component. Need to plot number in a graph. Does anyone have any suggestion on which once to look at I am currently trying th Graphics Server .Net one and would like to try out other products. I just want something that is easy to use. Specially something that is easy to plot numbers coming for result sets, result sets that are dynamic for every query execution. What I mean is, for the same query, it will return different number of columns (almost always). Please let me know. Thanks, Rick.. Hi, I have used Dundas charts in the past http://www.dundas.com ...Show All

• SQL Server rs:clearsession

  Hi . I am using rs:clearsession for refreshing of report data from my page.i had passed rs:clearsession parameter from aspx page to report URL, but when i am navigating from parent report to child report then rs:clearsession is not appended. so is there any way by which we can set some property in reporting service and we can get the result of "rs:clearsession" variable in itself report. Thanks in advance, Sanket. Thanks for your reply. I am rendering a report in a web browser via URL access at that time from my application page(ASPX page), i am passing rs:ClearSession=true via URL, so i am getting new data every time. but when i am drilling down to second report via navigation(Jump to report ...Show All