Jump to content

shyam

Members
  • Content Count

    24
  • Joined

  • Last visited

Community Reputation

0 Neutral

About shyam

  • Rank
    Newbie
  • Birthday 03/07/1989

Previous Fields

  • Languages
    c#.net

Contact Methods

  • Website URL
    http://
  • ICQ
    0

Profile Information

  • Location
    gujrat,india
  • Interests
    sql<br /><br />asp.net
  1. shyam

    Problem With Localhost

    Hello all,i made a project in visual studio 2008 with .net frame work 2.0 and sql server 2005its completelly run on vs 2008when i want run it on localhost it shows below error:::::::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.Server Error in '/projectwork' Application. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error: Line 41: Line 42: cmd.CommandType = CommandType.StoredProcedure; Line 43: cn.Open(); Line 44: Line 45: cmd.Parameters.AddWithValue("@id",Convert.ToString(c.id));Source File: C:\Inetpub\wwwroot\my school\App_Data\sqldata.cs Line: 43 Stack Trace: [sqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +421 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 my_school.sqldata.checklogin(classfile c) in C:\Inetpub\wwwroot\my school\App_Data\sqldata.cs:43 my_school._Default.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\my school\login.aspx.cs:37 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746 Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 thans for seeing my problem
  2. shyam

    Grid View

    solution of this problemwrite code in pageload eventgridview1.databind();its enough for binding
  3. before reading this post i want to clearify that i have no problem in this ..It is just for beginnerHOW TO INSERT DATA IN ACCESS DATABASE USING C#.NET string con = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= C:/Documents and Settings/shyam/My Documents/Visual Studio 2008/Projects/databaseofaccess/db1.mdb; User Id=; Password="; OleDbConnection conn = new OleDbConnection(con); string cmd = "insert into logindetail (id,pwd) values(@id,@pwd)"; OleDbCommand cmdd = new OleDbCommand(cmd, conn); conn.Open(); //cmdd.Parameters.Add("id",OleDbType.Char,ValueType=TextBox1.Text.ToString()); //cmdd.Parameters.Add("pwd", OleDbType.Char), ValueType = TextBox2.Text.ToString()); cmdd.Parameters.Add("@id", OleDbType.Char).Value = TextBox1.Text.ToString(); cmdd.Parameters.Add("@pwd", OleDbType.Char).Value = TextBox2.Text.ToString(); cmdd.ExecuteNonQuery(); conn.Close();
  4. shyam

    Excel Connection

    HELLO ALL,I AM SHYAMI KNOW HOW TO CONNECT .ASPX PAGE WITH SQLSERVER2005 BUT AT NOW I WANT TO LEARN HOW TO CONNECT DATABASE WITH EXCEL CAN ANY ONE SEND ME A LINK WEB PAGE OR PDF I MEAN ANY KIND OF MATERIAL RELATED TO THIS PLEASE HELP ME THANKS FOR READING MY PROBLEMMMMM$$$$$$$$$$$$$$$$$$$$$$$$$$
  5. shyam

    Grid View

    there is no code inside1) i create one grid view2) another box when selected index changed event called TEXT BOXES CONTAIN ONE PARTICULAR VALUE3) WHEN I CHANGED THAT VALUE AND PRESS UPDATE BUTTON I WANT TO MAKE REFRESH THE GRIDVIEWWTHANKS FOR HELPINGGGG
  6. shyam

    Grid View

    how to reassign that gridview please tell meeeeeee
  7. shyam

    Grid View

    HELLO ALL,i am using visual studio 2008 and c#.net;i want to refresh the gridview on any click event .What should i have to wrote????THANKS FOR READING MY PROBLEAM....
  8. shyam

    Property

    thank you, allTO HELP MEEE
  9. shyam

    Print Command

    thank you sir
  10. shyam

    Property

    HELLO ALL,i am using c#.net in visual studio2008in my login form there is one password text box.i want that password is shown in * wayyy.which property i have to set???
  11. shyam

    Print Command

    hello all,i am using c#.net in vs2008i want to print one table when i click click on button ,what should i have to wrote( i want to print only one table..)command just print any particular part i mean it may print a page, table,panel or any thing..
  12. shyam

    Print Table

    hello all,i am using c#.net in vs2008i want to print one table when i click click on button ,what should i have to wrote( i want to print only one table..)
  13. shyam

    Stored Procedure Prob

    thank you sir (once again)Igot the answeri have to pass the value which already contain '%'
  14. shyam

    Stored Procedure Prob

    SORRY SIR i am using sql server 2005
  15. shyam

    Stored Procedure Prob

    table name is "generalreg"database name is not need in stored procedure because procedure it self lies in database
×
×
  • Create New...