HI, I am using SQL SERVER 2005. I need to find what is the best performance method for my 3 sql Data adapters. first method:- 1) Open sql connection 2) Initialise 1st data adapter and fill for the data table 1. 3) Initialise 2nd data adapter and fill for the data table 2. 4) Initialise 3rd data adapter and fill for the data table 3. 5) Process my work 6) close connection. second method:- a) 1. Open sql connection 2. Initialise 1st data adapter and fill for the data table 1. 3. close connection. b) 1. Open sql connection 2. Initialise 2nd data adapter and fill for the data table 2. 3. close connection. c) 1. Open sql connection 2. Initialise 3rd data adapter and fill for the data table 3. 3. close connection. d) 1. Use thread concept for a) ,b) and c) and take results for adapters. 2. process my work. so can any one tell me what is the best performance method? first method or second method? Thanks

Hi All, We have 2 sites. 1) suppose that one of the 2 sites has been uploaded under following url:- http://www.abc.com/ 2) we need to read above site web.config for our other site which has uploaded in different location. http://www.abctest.com/ How do we read 1) site web.config from second site using c#, asp.net? Thanks in advance.

Hi All, first I installed SQL SERVER 2005 dev edition in my machine and after that I have uninstall it. so I have installed sql server 2000 enterprice in my machine. BUT when I am going to connect to sql server 2000 through my application, I have received following error message:- "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" This error message is belong to sql server 2005 and NOT FOR sql server 2000 !!!. but there is no sql server 2005 in my machine at the moment.so how can i get sql server 2005 error message for sql server 2000 ? please help . Thanks in advance..

HI, what are the correct SQL SERVER versions for Windows server 2003 x64 edition operating system? becasue we have tried to install SQL SERVER 2000 enterprise edition on there,but it was failed. Thanks in advance.

Hi all, I have a problem to find the correct license for sql server 2005 standard edition. this is the our requirement. we are going to install the SQL standard edition in a new server(Windows server 2003 x64 edition.) our web application is in the a another server and we are accessing sql server from there. so what type of license do we need to use SQL server 2005 standard edition? processor liecense or device license or user license? Is user license enough for our work?. becasue processor license cost is very high. Thanks in advance.

Hi All, OUR DB is SQL SERVER 2000 and it is in a server which having windows 2003 standard x64 edition. and our client machine is having windows web server 2008 and we are trying to connect SQL DB for there. But we have recieved error like below. " A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) " can you please help to fix the issue? Thanks in advance.

Hi All, there is a varchar value from SQL SERVER 2000 database like this originalvalue='ABV,ABZ,ACC,ADD,AGP,ALA,AMD,AMS,ANR,ATH,ATQ,AUH,AXD,BAH,BCN,BDQ,BER,BGO,BHX,BJM,BLL,BLQ,BLR,BOD,BOM,BRE,BRS,BRU,BTS,BUD,BUH,CAI,PAR,CAS,CCJ,CCU,CFU,CGN,CJB,CMB,COK,CPH,CPT,CTA,CWL,DAR,DBV,DEL,DLA,DMM,DOH,DUB,DUS,DXB,EBB,EDI,FBM,FIH,FLR,FRA,GLA,GOI,GOT,GVA,HAJ' Now There is a another varchar variabled called "ValueNew" like below. valueNew='BVA,CDG,JDP,JPU,LBG,ORY,POX,XDT,XEX,XGB,XPG,PAR' we need to check 'valueNew' airport codes are exists in the originalvalue or not.. How do we it with easy way? Thanks in advance..

Hi All, We have a problem..We have developed asp.net web project and ready to deploy. Now we have 2 servers.We are thinking to upload database to another server and website to other server. Is it giving us best performance rather than uploading database and site to the same server? please send your ideas about that. thanks in advance.

Hi, we have developed asp.net 2.0 ,C# Application and ready to upload. before that, we need to stop decompiling manage dlls in our porject. How can we do it? please help. Thanks in advance.....

Hi All, In our web Application,Session is TimeOut Very Quickly.Is there a way to increase the TimeOut period? Is there a any solution for that? Please help me to solve this. Thanks in advance...

Hi All, I have created a XML Web Service with ASP.NET 2.0 . it is working fine with the client application in my local machine,but when i uploaded to the server which is having asp.net 2.0 framework,webmethod return an error called "Method SessionCreate can not be reflected" I am unable to find this issue since it is working fine in my computer(which is also having asp.net 2.0) can any one help me to solve the issue? Thanks in Advance.......

Hi, I have debugged the code. but I can not find a error. while I am debugging the XML Webservice method,client side displaying the error message. why is that? Is it like timeout error?

Hi All, I am developing a WebApplication using ASP.NET and C#. there is a exception occurs when i call for a XmlWeb Service --Web Method. This is the code. try{ DataXML service=new DataXML(); service.Timeout = 10 * 60 * 1000; object[] results = service.GetProductionData(); }catch(Exception ex) { str=ex.Message; } Here we have to wait around 100 seconds to get the response. But before that there is exception occurs and the error message says 'The underlying connection was closed: The connection was closed unexpectedly So the client side returns a exception before results come. why is that?? can any one help on this? Thanks in advance..

Hi All, I have developed a ASP.NET application and I am using XML webservice. In there I have set the timeout property as 10 minitues. But I am getting following error after one minitue. The underlying connection was closed: The connection was closed unexpectedly. code part is as follows lobjService = new MyService(); lobjService .Timeout = 10 * 60 * 1000; object[] results = lobjService .AgentAvailabilities(lobjCriteria); How can I avoid the exception and take results? . thanks in advance.

thanks for reply. It is a hexadecimal string. It is comming with xml files. So we need to convert hexadecimal string to a Image to show on the asp.net web page.

Hi, we have Image stream with hexadecimal values. 0xFFD8FFE000104A46494600010101 Now we need to convert it to asp.net image (System.Web.UI.WebControls.Image) ? can any one assit for that?

Hi, We have developed website using ASP.NET,C#. But they are runtime errors and we got yellow pages. So How do we catch Runtime errors and Log them? please advice.

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.

hi, thanks for reply. I am joining 3 threads with Join() method. Then 3 threads can execute parallary. There are 3 methods ,all are return same types of arrays.

Hi, I have created a XMLWeb Service and there is a class like this class CUSTOMER { public string user; public string password; } I have to used above two attributes in many classes inside the namespace .That 's why I have to declare them as public. In addition , I need to hide above attributes when clients access my xmlwebservice. becasue those variables are using inside the namespace classes only. abcservice lobjservice=new abcservice() lobjservice.customer.user=""; lobjservice.customer.password=""; How do I hide 'user' and 'password' ,when we are accessing the service?