third method:- 2) Initialise 1st data adapter 3) Initialise 2nd data adapter 4) Initialise 3rd data adapter 1) Open sql connection 2) fill for the data table 1. 3) fill for the data table 2. 4) fill for the data table 3. 6) close connection. 5) Process my work As to your second method... you do know that the DataAdapter will handle the open/close for you don't you? Better yet, don't use DataAdapters, but that's another subject. P.S. And why use separate ones rather than only one?

If it is in another server you need to read it using Unc path.. You cant access Web Config from http requests as they are secure to the web site. Web config is applied to a virtual directory in the IIS. So you can have web.config file for each folder within your project. If not found it applies the parent. :rose: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

firstly what is your machine OS? Is it Windows XP or VISTA? You can install sql server enterprise edition on Server OS . none of above OSs allow you to install enterprise. secondly you can see your sql server services and find that if you have sql server 2000/2005 instances. you must go to Control panel-> administrative tools->services then find all MSSQL services or something like this. Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

Why dont you install SQL 2005 or 2008 they will work Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

The error is quite general so: - recheck the connection string at client side (protocol, instance name, server name etc.) - check that the server side is listening on desired protocol (also check it's settings) - check that there are no firewalls blocking the conversation. If needed open the port in Vista firewall The need to optimize rises from a bad design.My articles[^]

Why post this on General IT Issues? First decide which technology you want to use to solve this and then post on appropriate forum (General database, C# etc). One thing you have to consider is the design of your database. Now you're not using the db in a relational way. If you put the airport list into a separate table (1 record for each airport) you would easily test the existence of an airport. The need to optimize rises from a bad design.My articles[^] modified on Monday, December 8, 2008 2:20 PM

Along with the Point that has been mention by CG , you can read this one Improving ASP.NET Performance[^] cheers, Abhijit My Recent Article : Beginner's Guide To View State

So true... Christian Graus Driven to the arms of OSX by Vista.

Yes. This is generally setting of web.config file <sessionState mode="InProc" timeout="5"/> Here time out is for 5 min you can chage it as per your requirment. you can also change it on SessionStart Event of Global.asax file as Session.TimeOut=5; cheers, Abhijit

Post the code of your webservice method. Ahsan Ullah Senior Software Engineer

You cant convert it to asp:Image, but you can display it to the user 1. Convert the hex string to a byte array by the help of HexEncoding class available in this article[^] 2. Display this data either using BinaryWrite method of Response class or HttpHandlers[^] *jaans

pubududilena wrote: So How do we catch Runtime errors and Log them? When any uncaught exception occurs, ASP.NET fires Application_Error event. Global.asax is having the event handler defined, you can use that. Or write a custom HTTP module and hook application error event. For logging, I have used log4net[^] - it's a great product. Alternatively you can use web.config's custom error section. When any error occurs, it will be redirected to the specified page. But if the application is running in heavy traffic, this won't be a good approach. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

Hi, thanks a lot for reply. I will check with your codes and comeback soon. Is there a problem ,when I am using Join() method?. I need to run my 3 methods paralaly. all the 3 methods return same type of arrays.

A couple of observations: 1. If you return a value from a method you call in a different thread, your calling method might be long gone by the time your called method completes execution. You will have to rethink your design. 2. If there are many items in your collection, you might end up spawning a huge number of threads. This is not a very good idea. Cheers, Vikram. "The weak can never forgive. Forgiveness is the attribute of the strong." - Mahatma Gandhi.

dude! please get in the habbit of using pre and code tags for code in your posts, its hard to read if you dont Harvey Saayman - South Africa Junior Developer .Net, C#, SQL think BIG and kick ASS If (Programming != Your Passion) { you.suck = true; } else { you.suck = false; }

If you haven't got a backup of your database to restore from, you're not going to be able to retrieve your lost data. Perhaps this will teach you the importance of taking regular backups of your database... Paul Marfleet