Thanks for your advice. Later I found the problem was with the name resolving of our network. I replaced the server name with the IP address of the server in the connection string and now its working fine. :)

Thanks a lot. It works fine when server name is replaced with ip address.:)

I have one of my c# applications coded using .net framework 1.1, which works fine. Recently I installed Visual Studio 2005 - Professional edition on the same machine (Arter formating and reinstalling Windows 2000 with SP4) and now the above application takes a long time to open the connection to SQL Server 7. My connection string is as follows "user id=sa;password=;initial catalog=FINISHED_GOODS_STOCK;data source=naturubmain;Connect Timeout=30" Once I try to open the connection it gave me 'Time out expired' error. I set the 'Connect Time out' to 0 just to find how long does it take to open the connection. It took above 1 minute and opend the connection. Pls help me. Withot fixing this I will not be able to enjoy the new features of VS2005

:((:((:((:(( I have one of my c# applications coded using .net framework 1.1, which works fine. Recently I installed Visual Studio 2005 - Professional edition on the same machine (Arter formating and reinstalling Windows 2000 with SP4) and now the above application takes a long time to open the connection to SQL Server 7. My connection string is as follows "user id=sa;password=;initial catalog=FINISHED_GOODS_STOCK;data source=naturubmain;Connect Timeout=30" Once I try to open the connection it gave me 'Time out expired' error. I set the 'Connect Time out' to 0 just to find how long does it take to open the connection. It took above 1 minute and opend the connection. Pls help me. Withot fixing this I will not be able to enjoy the new features of VS2005 Thanx a lot

Try the XCeed Grid. I have been using it for couple of months for my C# apps, and It has got many features. You can download it free (trial version) and hack is available in the net. - Rohitha

As far as I know you cant pass parameters to a view. As an alternative what you can do is create a user defined function in sql server (2000 and later) where you can pass parameters to the function,do what ever the process or selections you want and then return a table from the function. Rohitha M.Hewa Senior IT Executive Naturub Group of Companies - Sri Lanka

Try this. Set the 'CommandTimeOut' of the Connection and the SQLCommand object you r using to execute the sql to 0 (Zero) Rohitha M.Hewa Senior IT Executive Naturub Group of Companies - Sri Lanka

I use crystal reports 9 as my reporting tool for my c# applications. For the reports which I need some kind of processing (calulations etc..) what I do is do all the processing in C# code and pass a data set to the 'SetDataSouce' method of the ReportDocument object in c# code where I call the report (I am using crystal report engine to call the reports in my c# application and to pass the paramenter fields, to set the selection formula etc.. at runtime) This mechanism works fine in the computer where I develop my application. But once I make a setup package in install the application in a user machine (I installed MDAC7, .Net 1.1 framework, Crystal reports 9 and then my setup package in the user machine) the report does not show any data. I user visual studio 2003. .net framework 1.1 Pls help me... Thanks Rohitha M.Hewa Senior IT Executive Naturub Group of Companies - Sri Lanka