Authenticate, Search And Add Records In GridView In ASP.Net

Today, I am going to show you how to create a website project that's able to authenticate login and add and search data in DataGridViews, in ASP.NET and using C#.

The ProDatabase is a website project created in ASP.NET based on C# language (Visual Studio 2010). This project is just an example of something used in the Ministry of Education in Afghanistan, in the field of procurement. I have not included the registration form because if someone wants to use it, he/she should write an application letter for a username and password; then, the administrator can assign him/her access. However, you can add your registration form.

NOTE: If you want to download the project, then you can easily do that. But, you have to create an empty C# website project first and then select and copy all the files from what you have downloaded and paste them in your project.

Let’s start.

1. Open Visual Studio and select new C# ASP.NET website (not an empty website at this stage). So, you have two pages named as Default.aspx and About.aspx and four folders named Accounts, App_Data, Scripts and styles along with a master page with web.config file and Global.asax. For the moment, forget about these things. Just select the Account and App_Data folders and delete them. Good, no problem.

2. Now, click on your website and add a new item, a web form. Name it as login.aspx ( do not select its master page option, because here we use it to avoid the access to the other pages. Thus it should be an empty form). Now, add two textboxes (TextBox1, and TextBox2), a button (Button1), and a label to give you the right message. Of course, make this page as default start page, so that it loads first. For this, right click on it (in Solution Explorer) and make it the Start Page, like this:

Have you done it? If not, here is the source code for designing such a form:

3. Very smart !! Now, add another item, a SQL database and name it database.mdf. This will automatically create a folder named App_Data and will settle there. Double click on it and the Server Explorer will open. Now, make a new table in the db and name it UserData. This table should have two fields, UserName and Password. (It will be better to click on the table and select show table data and add a user or two, because we don’t have registration system.)

4. Now, click on the login page code side and write this code.

5. Now, go to the Master page and try to make it something like this, or as per your preference. I have added two extra menu items and a footer. I guess there is no need for its source code.

6. Was that hard to understand? If not, then let's continue. Well, add another form and name it as Projects.aspx. This is the form that we use for adding the projects to our database (from now on, all our new forms should inherit our Master page. So, select its Master page option). Very simple! Just add a table with two columns, eight rows, some textboxes and a GridView. Try to make something like the following:

If you have not done it yet, don’t worry. Here is the source code: