Anand Narayan's Q&A profile

• SQL Server Dynamically Create Columns

  Hi, i'm a newbie to reporting services. May i know if it is possible to dynamically create columns for a report I know that there's a way to hide the columns on the fly. However, for my case, i will only know the amount and the detail information (column name etc..) of columns while the report is running. Thanks in advance. I think i have posted the message in the wrong forum. I should post it in the SQL 2k forum. Sorry ...Show All

• Visual Studio Team System RUP (Features, Use Cases, Supplementary Req) to MSF Agile (or not)

  We have been using the RUP (a very scaled down version of it) for quite a while now.  We define a vision document with feature requirements that are traced to use cases and supplementary requirements.  Our use cases have multiple subflows and define all of the possible alternate flows.  They also contain special requirements (like maximum field length, which functions are available under different circumstances, etc.).  I am trying to come up with a good way to take our current process and use it inside of the team system without a ton of disruption to what we do.  I really want to move away from rational to the ...Show All

• Visual C# connecting to sybase server on network from a .net application

  there is a sybase server installed in a one of the machines in our network, say machine A. and in my machine i hv installed sybase network client. how can i set connection string in my application to use the server on Machine A at present my connection string is : AsaConnection connEQ = new AsaConnection("Data Source=eq2gents;UID=DBA;PWD=SQL" ); pls help me. sajitha The connectionstring format: Data Source='SERVER';Port=5000;Database='DatabaseName';UID='Username';PWD='Password';   Now, just use the values you need, you should replace SERVER for the server name you want. ...Show All

• .NET Development Precision/Scale error??

  I've read the other posts related to this issue, but I'm just REALLY confused as to whats happening in my case. Like everyone else it was working fine in SQL 2000 but now in SQL 2005 there is an issue. I'm calling a stored procedure with parameters defined like this: @action varchar(10), @GLTransactionID int = NULL OUTPUT , @GLBatchID int = NULL , @GLAccountID int = NULL , @CurrencyID int = NULL , @LocalDebit decimal(28, 13) = NULL , @LocalCredit decimal(28, 13) = NULL , @BaseDebit decimal(28, 13) = NULL , @BaseCredit decimal(28, 13) = NULL , @TransID int =NULL, @Description varchar(255) = NULL I am calling this proc from VS.NET 2003 ...Show All

• SQL Server Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files

  We have RS 2000 running in our lab environment where I recently installed the .NET Framework 2.0 Redistributable Package.  After installation, reporting services stopped working with the following error: Security Exception Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Ver ...Show All

• Windows Forms VB.Net Newbie Design Layout Question

      I'm new to VB.Net so please bear with me.      I have a desktop form that takes one 800X600 screen. Half of the form is a an active checklist of steps that the computer has validated. The other half of the form is a group of controls for the user to input data for those calculations.        At  ...Show All

• Visual C# Syntax Error in Update Statement

  Dear All, I had encountered Syntax Error in Update Statement when I execute the following code. private void UpdateNewPwd( string EmpID, string NewPwd) { string strUpdate = "Update Users SET Password = '" + NewPwd + "'" + " where EmployeeID = '" + EmpID + "'" ; string connectionString1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms. Application .StartupPath + "\\Local_Database\\DryEtch.mdb;User Id=admin;Password=;" ; OleDbDataAdapter dbAdapter = new OleDbDataAdapter (); OleDbCommand dbCom = new O ...Show All

• SQL Server Do not export navigations

  Hi, Is there a way  NOT to export the navigation within reports I often use navigation to other reports, but when I export those reports to excel, the links are still there and are more a pain in the *ss then helping me managing the data... any ideas thx, Frank M. That would be an option, thx. Do you know if it's also possible to 'hide' the "Hyperlink Action" in a similar way I can't put a function there to check if a parameter is true or false... ...Show All

• Visual Studio Express Editions Fire event at predetermined time

  I need to make an application that performs a task at a given time each day, based on the system time.  For a simple example, lets say I want to delete all the files in a folder at 11:00 am everyday.  The program would obviously be running on a computer thats always on.  What is the best way to do this   Do I continuously compare the current time with the target time & when they're equal fire the event   This seems like a waste of cpu resources, but maybe thats the only way to do it.  Can somebody post some code to get me started on this   Thanks... Had the same chalange ...Show All

• Smart Device Development MAPI

  hello guys, i have a C++ class that uses mapi functionalities to send emails with attachment, how can i set the sender of the email i am using PPC2003 SE thanks for your help Set the following two properties on the message: PR_SENDER_NAME, PR_SENDER_EMAIL_ADDRESS, For both, using Value.lpszW as your value string. --- Lao K Visit my Blog for Windows Mobile Pocket PC Smartphone Programming Hints and Tips ...Show All

• Visual C# is a 'Type' but is used like a 'Variable'

  Hello, I'm new to C# and am having some syntax issues. The following line of code is throwing this error "... is a 'Type' but is used like a 'Variable' return LoanSubAccount(AddSubAccount( new LoanSubAccount ())); I'm sure if I assigned AddSubAccount( new LoanSubAccount ()); to a variable and returned it, that would work. What I don't understand is why what I have doesn't work Thanks in advance, Preston <SNIPPET> private SubAccount AddSubAccount( SubAccount Account) { SubAccountID = GetNextSubAccountNumber(); SubAccounts.Add(SubAccountID, Account); return GetSubAccount(SubAccountID); ...Show All

• Smart Device Development How to run visual studio 2005 beta 2 project EXE on a smartphone device

  I am developing applications for a smartphone using visual studio 2005 beta 2. I am unable to run my dotnet exe on my smartphone device.Does it needs any framework to be installed If So,how to install and where to install that frame work Thank You, Amar. I am not getting any errors.But when i execute my exe on smartphone device it just gives no response. help me Amar ...Show All

• Visual C# Why can't I use the Escape Key as shortcut?

  Hello people, how are you I hope fine. I'm trying to set the Espace key (char 27) as a shortkey in a ToolStripMenuItem in the Visual Studio 2005, through the Shortcutkey property. But the VS says that: "The value of argument 'value' (27) is invalid for Enum type 'Keys'. Parameter name: value" Is this a bug Or is it not possible to do Thanks Andre I saw the post about it being by design. I think this issue wasn't evaluted well enough. There are 2 issues here. It's easy to workaround the 1st issue by trapping the escape key. But that is not all of it. The 2nd issue is the display of the ESC. How do ...Show All

• Visual Studio Express Editions SDK for WinXP x64

  Good day, I have AMD64 processor with winXPPro x64 and tried to download the x86 SDK but it wouldn't install (I thought it would install into the x86 folder). I then downloaded the AMD64 SDK and installed from the web...well, I thought I had...but when I went into the "Program Files\Microsoft SDK" folder (after getting a success message) I discovered that none of the sub-directories (include, bin, etc) had installed there. I found them one level up in the Program Files directory. My Question's: 1. Will the AMD64 SDK work with VC++ express to learn how to make win32 apps (I am starting with the Petzold book, ...Show All

• Windows Forms HTML Editor Control

  Hi, I want to give an HTML editor in my Windows Form application so the user can compose and format HTML text message (same as message editor in this forum when we compose a message) . In web application, there are many controls can do that like FCKEditor, RichTextBox, etc. Can someone point me out how to do that in Windows Form Any Free/OpenSource 3rd party controls is ok. Thanks in advance, Melinjo Hi, Lutz Roeder has one, Writer for .NET (has Writer.Html.HtmlControl inside it), you can download from his website: http://www.aisto.com/roeder/dotnet/ Here's how you can get the control to yo ...Show All