evald's Q&A profile

• SQL Server Using Stored Procedures with Report Builder

  New to the forum here. I'm having a trouble. My company is contemplating using Report Builder as an end user tool as opposed to giving everyone a copy of Visual Studio. I'm studying the feasability on this. A problem I'm running into, is that it doesn't seem possible to use a stored procedure as a data source. All of our standard reports are based off of stored procedures. Now granted, I'm talking about just Report Builder. I know how to base a report off of a SP using reporting services in VS. So, my question is, can you create a report off of a SP using only Report Builder, and if so, the steps Thanks guys! Stored procedures are not supported by Report Builder in this release. However, Chris Hays of sleazy hack fame has rep ...Show All

• SQL Server How to export the result of a sql 'for xml' query to an xml document

  I have a sql query with a 'for xml explicit' clause. I would like to export the results of the query as an .xml file. I specify the query as 'SQL Command' in an OLEDB source adapter, but I don't know see an adapter that I can use for the destination. Any ideas Thanks. Jamie Thomson wrote: There is no XML destination adapter however you can build one yourself in the script component. Donald Farmer's book shos you how. The title of the book is "The Rational Guide to Scripting with SQL Server 2005 Integration Services Beta Preview", correct I see he also has one called "The Rational Guide To Extending SSIS 2005 with Script" Pub. Date June 2006 but I can't locate a cop ...Show All

• .NET Development CreateParameter give bad performance

  We are working with MSSQL 2005 and ado.net framework 1 .1 During our performance tests over large DB (~1M records) I found out that when I run one of our queries, with embeded values in the query -string, instead of using the CreateParametr method, the query ran 40 times faster!!! The parameters are 2 strings (~30 characters) , the type in database is varchar(255). Wh at can cause such a huge difference in the execution time This is our AddParameter source: public void AddParameter( object parameterValue) { string paramName; IDataParameter IParam; //For string that is empty do nothing means null is entered to field. if (((parameterValue is string ) && (parameterValue.ToString( ...Show All

• .NET Development what is .net 2.0 frame work?

  what is .net 2.0 frame work how it help us how can we install this frame work which language it supports is it easy to learn is it support java The Microsoft .NET Framework version 2.0 extends the .NET Framework version 1.1 with new features, improvements to existing features, and enhancements to the documentation. The Microsoft .NET Framework version 2.0 redistributable package installs the .NET Framework runtime and associated files required to run applications developed to target the .NET Framework v2.0. The .NET Framework version 2.0 improves scalability and performance of applications with improved caching, application deployment and updating with ClickOnce, support for the broadest array of browsers and devices with ASP.NET ...Show All

• .NET Development Windows Service and Web.config file

  Hi, I'm creating a Windows service and a web site for an application. Code in the windows service should query the database used by the web site. In other words both these application communicate with the same database. How can i read the "Web.Config" file (for database connection string) from the windows service Regards, SS Anand You can read a config file just the same wa you would with a Windows or Console application, using the ConfigurationManager class, to be able to use it just make sure that you've added a reference to reference to System.Configuration.dll. Also, be sure to take a look at the ConfigurationManager.ConnectionStrings property which is designed for cases ...Show All

• Visual C# Completely Invisible/Hidden Application

  I wanna create such an small application/exe which will be completely hidden/invisible to the user when it is run. Even it will not be displayed in the taskbar, system tray, task manager(application tab). I've no problem if it is: a) a console application or any other types of application (but i don't wanna see the splash screen of MS-DOS screen when I'll click on my .exe file) b) only showed in the task manager (processes tab). Anybody can help me providing snippet of code/idea or anything else. Thanks Everybody, all of YOU are really helpfull. Finally I've decided to create a complete invisible/hidden application in this manner though Windows Service is a better solution: 1. FormBorderSt ...Show All

• SQL Server Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.

  Hello, Please bear with me as I am no Sql Server guru, but am getting this error that is preventing me from continuing with my development work.  I am the only developer on my team running Sql Server 2005 and it has been working just fine for the last week.  I opened the Management Studio this morning, just like every other morning and got this error: TITLE: Connect to Server ------------------------------ Cannot connect to (local). ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) Of co ...Show All

• Visual Studio Tools for Office Replacing XLA with COM Automation Add-In

  Hello all, We've got a bit of a problem here that we hope you can help us with. We've just developed a COM automation add-in in Visual Studio 2005 (C#) to replace an XLA add in. To ease the conversion, we named most of the functions exported by the COM library to the same name as those in the XLA file. However, our problem is that on removing the XLA file and adding in the COM automation add-in to a workbook, the excel spreadsheets cannot reference the new method calls which have the same name as the old calls in the XLA. If we create a new worksheet and add in the automation item, then the calls work fine. For example, the UDF call CBSpot existed in the XLA. When we remove the XLA and add in the automation DLL CBSpot can't be resolve ...Show All

• .NET Development C# query foxpro

  I have wrote a program that query a foxpro table that is located on a server via odbc. The query takes forever to run. Is there a way to speed this process up Hi Bear23, If there are indexes (CDX files) on the tables that exactly match expressions in the Join or Where clauses of your SQL then that would help. Do you have any CDX files that match the tables If so, do you know what the index expressions are ...Show All

• Visual Basic How do I get all declarations in my IDE Method dropdown

  I am fairly new to VB.Net 2005 - just installed it before the holidays and now I am converting old vb.net 2002 code to 2005. I have however worked with 2002 and 2003 for some time now. In the 2005 IDE I do not see all my declarations of code modules. I have the form selected in the class drop down but only some declarations show in the method drop down, not all of them that are in the form. 2002 and 2003 displayed all subroutines and funtions so is there a setting in the VB.Net 2005 IDE that will let me see all of the functions/subroutines that are in the form   Thanks Is anyone familar with this problem I converted a 2002 vb.net project to vb.net 2005 and in the IDE when th ...Show All

• Visual C# principal.IsInRole working locally but not remotely?

  Hi all, I have a function I wrote which grabs a list of security groups from a sql table and then combines that with the domain name to check the users security groups to decide what they have specific access too. The function works 100% perfect when I run it against a localhost database, the second I point it to a remote database with same data and same structure it dies returns all groups failed and I can't for the life of me figure out why. Thanks in advance for any help anyone can give :) <code> // AD Groups the user belongs too public Stack retGroups = new Stack(); #region Get security groups private void getSecGroups() { SqlConnection getGroups = new SqlConnection(connect); // Select distinct from the databa ...Show All

• .NET Development diffrence b/w .net 2.0 and .net 3.0?

  what is .net 3.0 frame work hw it is diffrent from .net 2.0 can we install it on windows xp service pack 2 you can install .Net 3.0 from http://www.microsoft.com/downloads/details.aspx FamilyId=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en To learn about .Net 3.0 please reffer to the following sites. http://www.netfx3.com/ and http://msdn2.microsoft.com/en-us/netframework/default.aspx Thanks, Manisha. ...Show All

• Smart Device Development Error: the operation could not be completed. the device is not connected

  One weird thing happened to one of my application. When I want to do the debug and sync with my pocket pc device it gave me this error. I have check the device and it's already connected. I even debug other programs and they are fine. why only this one is giving me this problem I solved this by recreating my application. Either i messed up some setup or configuration or not but i notice that Visual Studio crashes several times or at least unable to rebuild a project. ...Show All

• Visual Studio Express Editions create dll in visual studio express

  Hi everybody, I have a c file and a h file i have written, which compile successfully. I want to make this into a dll. I know this is kind of a newbie question, but how would I go about doing this in Visual C++ 2005 Express Edition I am not too proficient with using Visual Studio yet, so a step by step guide woudl be extremely helpful. Thanks a lot! Kiran Take a look at using the /LD option. For more information and hot to set that through the IDE, please take a look at http://msdn2.microsoft.com/en-US/library/2kzt1wy3.aspx Hope this helps! Thanks, Ayman Shoukry VC++ Team ...Show All

• SQL Server Newbie question: DataMart naming conventions

  We are creating a "financials" datamart that we think will be of use to the Accounting dept. But, later, other lines of business could make use of it. Would "DMFinancials" be a good name for this mart The name doesn't suggest who would use it but this could be both bad and good! TIA, Barkingdog Does the name describ what is held in the Datamart If this is a datamart for just Finacial data regardless of who is using it then the name is correct. My Opinion. David ...Show All