I have created an ASP.NET tutorial. This tutorial is was designed in VS.NET 2003 using a SQL Server 2000 backend.
The tutorial contains the following.
1) A simple DML (Data Manipulation Layer) class containing common database functionality.
2) Examples of the following...
a) Datagrid Paging
b) Displaying images in a datagrid
c) Inserting/Updating/Deleting database records through stored procedure calls.
I have scripted out the database, so you can run the sql script in query analyzer and create all of the required database objects (tables, stored procedures, etc...).
I have also included a states.xls spreadsheet that can be imported into the "States" table (using DTS) once the database and all objects have been created.
When I start the application i receive the main screen, where i push "Departments". I receive a new screen whith one department (name 1). I try to add one, so i push "Add New Department". He asks me a name, i give in "2" and push on submit.
I receive the earlier screen of the departments, but only the "1" is on the screen. Same problem for positions and employees.
I have question about the tutorial I made database named project from query on the .sql file and it created the table and everthing fine.
When I access the webpages file in IE but when i Click on Department it takes forever then errors out. He is the error
Error: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ASPNETTesting.DataManipulationLayer.Query(String strProcedureName) in C:\Inetpub\wwwroot\www01\ASPNETTesting\clsDML.vb:line 29
I check the permissions on the database and the user I add to it was on there with admin rights. looked at the clsDML.vb and seen this line where it connects to the Sql server.
Public strConnectionString As String = "Server=(local);Database=Project;User ID=steve;Password=jensen;"
So I changed it to this to try and tried to connect the sql server but it didnt work.
Public strConnectionString As String = "Server=(local);Database=Project;User ID=admin;Password=xdmzx3065;"
thanks for the great tutorial so I am no expert but just trying to learn about asp.net with Sql server
i want to create a new website on which user can serch for job in short job serching web site .for this website i can't get idea what will be the different tables,database etc.. is anyone help me!!!
With all respect, this tutorial is targeted at an older version of SQL Server and Visual Studio. Unless you are specifically using these versions, I would suggest you look elsewhere for samples, there are plenty available.