Ramanuj's Q&A profile

• SQL Server How do I determine a measure's data type in an ADOMD cellset?

  Given an ADOMD Cellset how do I determine the data type of a cell such as currency, percentage, integer, etc. I have found no way of doing this other than explicilty looking for percent signs and currency symbols which is an inheritly BAD thing to do. I've looked through the properties arrays as well as tried different DIMENSION PROPERTY settings and have not found a way to retrieve the data types. Thank you, Terry Yes, "ultimately somebody needs to know what these numbers mean." That is why I'm trying to format the user interface correctly! Contrary to your reply, when looking at values on a chart knowing whether they are amounts or percentages is NOT "only a small portion of such semantic". It ...Show All

• Visual C++ CPU temperature

  Hi, I need to measure the CPU temperature. I understand that I need to use WMI for this. Using wbemtest.ext (present on every computer) i connect to root\wmi namespace and query "select * from MSAcpi_ThermalZoneTemperature". When I search for currenttemperature propery , it shows "null". does that mean that I will not be able to measure the CPU temperature Im using windows XP. Can anyone please help. If I cannot use this meathod, is there any other method that I can use Any information in this regard will be very helpful. Thanks, Manasi You can use the microsoft.public.win32.programmer.wmi newsgroup for this; the online interface is at Discussions in win3 ...Show All

• SQL Server Error: Could not find stored procedure !!

  Hi, Error: Could not find stored procedure. I Installed the SQL Server SP2 and the error still occurs when ever I call the stored procedure from my windows app!!   Any Help In design window its : GetMonthRecord;1 in code window its: GetMonthRecord_1 I tried to rename it to : GetMonthRecord the same error occurs !! ...Show All

• SQL Server Casting...

  I've got an ftp task that will be downloading a couple of files each night. today they're called blah20060830blah the date value in the middle changes each day. I'm trying to adjust this value with an expression. The expression doesn't want to cast my getdate function into a string that this property will accept. I know i'm missing something stupid. Thank you Maybe I'm completely missing the boat here. in an ftp task, there is a property called "Remote Path" As I understand, this designates what the path and filename of the remote file to be downloaded. Here's my leap of understanding. I want that value to change daily, I'm assuming that I can define this using an expression. I will concat the ...Show All

• SQL Server Parameters failing when supplied by a query and set up to execute

  I have a query that provides a list of detachments that are used as a parameter for the user to select when running a report. It works fine. I want to set up this report to also run on a schedule. When I set the prameters on the report for any value other than the first one in the list it fails to execute with the following error. Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) (there are no other details provided) The query results are All A B C D E G H I N V W X I get this error if I input a value in the list other than All or any value that is not in the list. Any suggestions We are running Report Services 2000 SP1 Many thanks Ayla ...Show All

• Visual C# writing into *csv file: inconsistent result

  string cur_drive = c2.const2 ( ); // this is just the current drive ("D:") string pathq = cur_drive + " \\VFP_Projects\\Data\\Stoxx\\ " + symbol + ".csv"; File.Delete ( pathq ); using ( StreamWriter sw = new StreamWriter ( pathq ) ) { sw.Write ( response ); sw.Close ( ); } response is a string variable that contains a whole *.csv file downloaded from Yahoo. The trouble is: I find the file (a) deleted, (b) created, and (c) the very first line filled in 100% of cases. The rest of the file appears EMPTY in about 50%. I have to look into the file and repeat the operation which is a great inconvenience. Is there a way to improve performance Why does it happen How can I get a feedback as to th ...Show All

• Visual C++ Use of const CString

  Hi,Today I have reviewed some code of my team mate. One of the class contains a definition like this const CString BITMAP_FILE_NAME = _T( "res/temp.bmp" ); I suggested use LPCTSTR or const TCHAR* (PTCHAR) instead of CString because it has some more overheads that a normal string literal. So my question is. 1. When a CString defined as const, does it really have some performance over heads 2. At the time of compilation, normally the the value of the const will be place in the code at compile time. For CString and other const object, how it is handling is it replacing the address of the const object As off my knowledge later will be happened. Could you please put some light on this Mike, Thanks alot for ...Show All

• Visual C# undo manager

  Hi all, I have a C# application that was written using VS2003 and has since been converted to VS2005. When I try to debug the application, I get the following error message: Error connecting to undo manager of source file pagename.aspx.designer.cs Can anyone shed some light regarding what this is Thanks, Dan Any additional update/word on this I'm seeing the same thing intermittently in VS.NET 2005 Team Edition for Devs. I should point out that the solution/project I'm seeing it with isn't a 2003 conversion. It does, however, use the MS Web Application Projects add-in for 2005. http://msdn.microsoft.com/asp.net/reference/infrastructure/wap/default.aspx ...Show All

• Smart Device Development Read SMS already on phone

  So how do i exactly read the sms that is already in the phone (mobile window 5.0 ppc) do i access cemapi.vol Can anyone pls help This has been answered before - try searching the forum Some answers that may help see: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=521509&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=926049&SiteID=1 ...Show All

• .NET Development Get filesize in megabytes

  Is there a function to get the size of a file in megabytes within the framework The System.IO.FileInfo.Length property will give you the file size in bytes. Divide by 1,048,576 (1024 x 1024) to get the size in megabytes. Ian --Ian Nelson http://ianfnelson.com ...Show All

• SQL Server Run SSIS package as an sql server job

  Hi There, I have sqlserver agent running with a windows user account which is member of administrator group. I try to set up the job to run an ssis package and set up to run as sql server agent service account. For some reason, the job fails and it doesn't give much error info if I look at job History. Can somebody plzz help me I am unable to understand what extra permissions must that user have to run the ssis package as a sql job And how do I configure the job to give more error details Any suggestions are greatly appreciated. Thanks. ...Show All

• SQL Server SQL Server Managment Studio Express 2005 Import/Export Wizard

  I've created a new database and restored the database from a backup. I'm wanting to import raw data from an excel spreadsheet into the tables of the new database. When I right click on the database, and hover over tasks the import/ export data menu options are not in the menu.The menu items ends at 'Generate Scripts'. I'm connected on a local instance to a registered server. Can anyone advise hi, Lee Rivers wrote: I've created a new database and restored the database from a backup. I'm wanting to import raw data from an excel spreadsheet into the tables of the new database. When I right click on the database, and hover over tasks the import/ export data menu options are not in the ...Show All

• Visual C# Why did I only get part of what I intend to get?

  No error was complained! The following program is to write a whole year's month,day,weekday in a MSSQL table. But somehow, for many times I have tried, but each time I got only part of what I intend to get: the whole year with 12 monthes, instead, I only got 3 or 4 months' content in the table. Can anybody tell me why calendar.dll using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using database; namespace calendar { public class calendar { private int _nian; //year private int _yue; //month private int _ri; //day private int _xingqi; //weekday private string _errorInfo; public int nian { get {return _nian;} set {_nian=value;} } public ...Show All

• Visual Studio Reactivation (deactivation followed by activation on a different machine)

  Hello, I am replacing my laptop and removing/uninstalling and wiping the drive before turning it in for a new machine. I will be re-installing all of my legally licensed Microsoft products, including Office and Visual Studio 2005 Standard. Since these products have already been activated on my old machine, will I have a problem activating them again, once my new laptop arrives Thanks !! That depends, Visual Studio is not a product that needs to be activated on contrary to non-VLK Office editions. Anyway since this forum is about Visual Studio, you will not encounter any issues with Visual Studio. ...Show All

• Windows Forms How to get the identity key when adding rows?

  Hi! I have a DataGridView control bounded to a table in SQL Server 2005. This table has an identity primary key with auto increment of 1. Facts: 1.- I add the rows manually with success: I create the DataRow from the related table in the typed dataset. Then I just update the table adapter and the row is created without a problem. 2.- However in the DataGridView I display another column of the table, not the one with the primary key. I would like to know: a) How do I know which was the newly added row in the datagridview (please consider fact 2). Right now I have to look row by row! (I know, I know: this is a brute force solution). b) When adding the row to the dataset is there any way to know the newly created row's ke ...Show All