Jump to content

shyam

Members
  • Content Count

    24
  • Joined

  • Last visited

Everything posted by shyam

  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
  16. shyam

    Stored Procedures

    USE database;CREATE PROCEDURE simpleproc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM t; END;if your table contain two field id and nameu should writeCREATE PROCEDURE simpleproc (OUT param1 INT) BEGIN SELECT COUNT(id) INTO param1 FROM t; END;you can write name instand of id;
  17. shyam

    Stored Procedure Prob

    HELLO ALL, i have a problem with below querycreate procedure selectallreg@name varchar(50)asselect * from generalreg where name like @name'%'I WANT TO CREATE A QUERY WHICH RETURN THE NAME START WITH GIVEN DATA;EXAMPLEIF "SA" IS GIVEN AS A VALUE TO @NAMETHEN IT WILL RETURN DATA START NAME WITH "SA"HELP PLS....
  18. please be clear your question!!and any button or anyting on .aspx file will automatically called its event..thanks
  19. This is answer if you are using vb.net(web application as i know)in properties of datagrid AUTOGENERATE COLUMNAUTOGENERATE DELETE BUTTONAUTOGENERATE EDIT BUTTONOR AND YOU CAN ADD COLUMN ON CLICK IN ADD NEW COLUMN (( AT THERE SEE DOWN ( WHERE U SELECT A DATASOURCE)))
  20. shyam

    Notifications On Asp.net?

    MR.HostingASPNet is right.u can use notification and ajax control tool to show ..as you said like pop up and that all...
  21. shyam

    In Sql Auto Increment

    THANK YOU SIRTHANKU ALLI GOT THE ANSWER..........CREATE TABLE new_employees( id_num int IDENTITY(1,1), fname varchar (20), minit char(1), lname varchar(30))INSERT new_employees (fname, minit, lname)VALUES ('Krin', 'M', 'JREs')
  22. HELLO all,i am shyam parmar from indiai am a student and learning asp.net and sqli thank to all repliers who helped to solve my question once again thank you all
  23. shyam

    In Sql Auto Increment

    hello sir,can YOU please tell me a query for below table or procedure to do socrate table tablenameid int,name varchar(20),and birthdate varchar(10)I WANT TO INCREMENT ""ID""thanks for last reply
  24. shyam

    In Sql Auto Increment

    hello all,i want to crate a table which contain one AUTO_INCREMENT FIELD ,BUT i cant do that PLS HELP ME...I AM USING SQL SERVER 2005
×
×
  • Create New...