Good Morning Manu
I would like to Refer you to an Article , but i have never seen an Article with such requirements. In the Forums there are Laws and sometimes we become lenient to users who want to learn. My advice to you is that you learn this technologies separately. this will confuse you if you want learn collection Projects with different topics
Manu wrote : which connects to a SQL Server or Acess database and has got a login form
Bealive me, the is a Big Different between connecting to SQL, Access or Oracle. .Net uses different Providers for this RDBMS's and you will be shocked how you code will differe from this Providers.
My point is that Start by looking at small topics that will build you skills e.g for this Request
Start by Reading the following article
1)
http://www.dotnetfunda.com/articles/article307-paging-without-a-wizard-sqldatasource-control-in-aspnet.aspx
In this Article i showed how you bind the Gridview with a Dataset and do manual Pagination
2) Creating a login Page and doing some Validation is easly follow this Thread
http://www.dotnetfunda.com/forums/thread459-check-login-user.aspx
In this Thread , i explain to the User was he can do the Login, if you want more its easy to do.
3)When it comes to Reports , you can use Gridview or Crystall reports, but you must bare in mind there will be licensing issue in the Crystall reports.
Manu wrote :
Lastly i would also like to have a simple search facility to extract records from the database and populate the many side records into a gridview and the one side record into text boxes.
Look at what i did in this Article, but note that this was a Windows Application not web, not the steps are the same
http://www.codeproject.com/KB/cs/N-Tier22.aspx
Thank you For Posting at Dotnetfunda
Were are looking forward for your reply
Vuyiswa Maseko
Thank you for posting at Dotnetfunda
[Administrator]
Manu, if this helps please login to Mark As Answer. | Alert Moderator