HI I Also tried this. Thanks Paul

Thanks for your sugession Renu, I exaclty did the same what u mentioned in the above example, but i am used to connect with sql server 2000, but the error says that sql server 2005. Is there any conflict to connedct with Sql server 2000 from ASP.NEt 2.0 remotely.

HI I have got some error while connecting Sql Server 2000 from ASP.NEt 2.0 i.e My ASP.NET Application and SqlServer 2000 are avaliable in diffrent machine.I remotly connecting the sql server 2000. I am getting the following error "System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at _Default.click_Click(Object sender, EventArgs e) in d:\WebSite2\Default.aspx.cs:line 27" Please send me ur sugessions. Thanks Paul

HI I have got some error while connecting Sql Server 2000 from ASP.NEt 2.0 i.e My ASP.NET Application and SqlServer 2000 are avaliable in diffrent machine.I remotly connecting the sql server 2000. I am getting the following error "System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at _Default.click_Click(Object sender, EventArgs e) in d:\WebSite2\Default.aspx.cs:line 27" Please send me ur sugessions. Thanks Paul

Hi all, For Windows Application, I have more than one DataTable in a Dataset, I want to show different columns from diferent DataTable in a row. For Eg: DataTable 1: contains Fiels like 1C1,1C2,1C3 DataTable 2: contains Fiels like 2C1,2C2,2C3 DataTable 3: contains Fiels like 3C1,3C2,3C3 I want to show the record in DataGridView in one row like, 1C1,1C2,1C3,2C1,2C2,2C3,3C1,3C2,3C3 use of Binding And also I want to update all the dataTables back to DataBase. How to achieve this.. Thanks raja

thankx

Hi All Wht are all the steps to convert a class file into dll. and how to use the dll in various applications..... Thanks Paul

Thank you.. if i didn't use visual studio for generate class file. I am using Note pad and compile it in the command line compiler.. In this case how can i use that assembly in my new class Thanks Paul

Hi All, I have created a class file and compile it ,make it as .dll file and also created strong name and i just installed it into the GAC. How to use this assembly in my newly developed class file.. How to accesss the methods in an assembly..? Thanks paul

Hi All, I have a doubt in datagrid. I created a datagrid with Header template columns. In a button click event how to disable the Header template column of datagrid. Pls gve me suggestion.. Thanks PAul Paul

Hi all, I am writing the following code to download the word document when button clicked... when i clek the button it open a popup window "File download".. in this popup there are open,save,cancel and moreinfo buttons are avaliable. When i click the save,cancel and moreinfo buttons, it is nicly working. when i click the open button.. it again diaplay the same popup window "File download" ,again i click the open .. now it is opening... But when i click the open button first it doesn't open the file instead of it again show the File download popup.. how to sole this problem. The code with in the button click is: string filename="Doc1.doc"; if (filename != "") { string path = Server.MapPath(filename); System.IO.FileInfo file = new System.IO.FileInfo(path); if (file.Exists) { Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); Response.ContentType = "application/octet-stream"; Response.WriteFile(file.FullName); Response.End(); } else { Response.Write("This file does not exist."); } } pls any one give me the solution Paul

Hi all, how to assign value to input file type tag. i.e i want to assign value to the control. when i give file.value="india.gif" it shows a error.. how to solve it. Pls help mee. thanks Paul

Hi all when i execute the following code it dosent display the single quotes(') with in the textbox. how to solve this problem any one pls suggest me. Dim t As String t = "'" Dim str As String str = "" str = str & "

" Response.Write(str) By Paul PAul

Hi All, I need a clarification? How to open a windows application from the asp.net page. Pls give a suggesstion with sample code. Thanks PAUL PAUL -- modified at 5:14 Tuesday 25th April, 2006

I am tring the code to develop without datagrid/list? Is it possible to do the same using HTMl Controls?? Paul

Thnak you for your suggession. But I am trying to do the datagrid functionalty to the html table. THanks you again By Paul Paul

Hi all, How to bind the records from sql server tables and display into the HTML table control. The data should be displayed in the HTML table with all features of datagrid(paging,edit and delete and go to page No).Simply with out using the datagrid. Pls suggest me with some sample codings. Thakx Paul Paul

What is CVS and what is the use of CVS? Any web link for learing CVS? Pls Help Me Thanks PAUL PAUL -- modified at 7:15 Saturday 22nd April, 2006

Thanks for your sugession. how to add the control into form..(Not in Panel and placeholder) -- modified at 4:34 Thursday 20th April, 2006

Hi All, How to add controls(textbox,dropdownlist and etc)into the webpage in runtime .? And how to handle the events of these controls? Just add the control in form not in Panels Pls give me suggession with sample code. thanks paul Paul -- modified at 3:08 Thursday 20th April, 2006