ASP.NET Web Forms website Part 10 - Connect with MySQL database ...
ASP.NET Web Forms website Part 10 - Connect with MySQL database ... | how to create web form in asp net

You Will Never Believe These Bizarre Truths Behind How To Create Web Form In Asp Net | How To Create Web Form In Asp Net

Posted on

In this article, we will actualize a Distinct Folio Appliance (SPA) appliance the server-side Blazor concepts with the advice of Entity Framework Amount database aboriginal approach. Single-Page Applications are web applications that amount a distinct HTML folio and dynamically amend that folio as the user interacts with the app.

ASP.NET Web Forms website Part 10 - Connect with MySQL database ..
ASP.NET Web Forms website Part 10 – Connect with MySQL database .. | how to create web form in asp net

We will be creating a sample Agent Almanac Management System and accomplish CRUD operations on it. A modal popup will affectation the anatomy to handle inputs and the anatomy additionally will accept a dropdown list, which will bind to a database table. We will additionally accommodate a clarify advantage to the user to clarify the agent annal based on agent name.

We will be appliance Visual Studio 2017 and SQL Server 2017 for our demo.

Let us attending at the final application

The absolution of Blazor 0.5.0 allows us to run Blazor applications on the server. This agency that we can run Blazor apparatus on the server-side with .NET Amount while added functionalities such as UI updates, accident handling, and JavaScript interop calls are handled by a SignalR affiliation over the network.

For added information, accredit to my antecedent commodity on Compassionate Server-Side Blazor.

Visual Studio 2017 versions beneath v15.7 do not abutment the Blazor framework.

Get the antecedent cipher for this appliance from GitHub.

We will be appliance two tables to abundance our data.

Execute the afterward commands to actualize both tables.

Now, we will put some abstracts into the Cities table. We will be appliance this table to bind a dropdown account in our web appliance from which the user will baddest the adapted city. Use the afterward admit statements.

Now, our Database allotment is complete. Therefore, we will advance to actualize the server ancillary appliance appliance Visual Studio 2017.

Open Visual Studio and baddest Book >> New >> Project.

After selecting the project, a “New Project” chat will open. Baddest .NET Amount central Visual C# card from the larboard panel. Then, baddest “ASP.NET Amount Web Application” from accessible activity types. Put the name of the activity as ServerSideSPA and columnist OK.

Erste Schritte mit ASP.NET 10.10 Web Forms und Visual Studio 10 ..
Erste Schritte mit ASP.NET 10.10 Web Forms und Visual Studio 10 .. | how to create web form in asp net

After beat on OK, a new chat will accessible allurement you to baddest the activity template. You can beam two drop-down airheaded at the top larboard of the arrangement window. Baddest “.NET Core” and “ASP.NET Amount 2.1” from these dropdowns. Then, baddest “Blazor (Server-side in ASP.NET Core)” arrangement and columnist OK

This will actualize our server-side Blazor solution. You can beam the binder anatomy in band-aid explorer, as apparent in the beneath image,

The band-aid has two activity files:

In approaching releases of Blazor, these two projects ability be alloyed into one, but, for now, the break is appropriate due to the differences in the Blazor accumulation model.

We are appliance Entity Framework amount database aboriginal admission to actualize our models. We will actualize our archetypal chic in ServerSideSPA.App project.Navigate to Accoutrement >> NuGet Amalgamation Manager >> Amalgamation Manager Console. Baddest ServerSideSPA.App from the Absence activity drop-down. Accredit to the angel below,

First, we will install the amalgamation for the database provider that we are targeting which is a SQL Server in this case. Hence, run the afterward command:

Since we are appliance Entity Framework Accoutrement to actualize a archetypal from the absolute database, we will install the accoutrement amalgamation as well. Hence, we run the afterward command.

After you accept installed both the packages, we will arch our archetypal from the database tables appliance the afterward command:

Do not balloon to put your own affiliation cord (inside ” “). After this command gets accomplished successfully, you can beam a Models binder has been created central ServerSideSPA.App activity and it contains three chic files: myTestDBContext.cs, Cities.cs, and Employee.cs. The name of your DB Ambience chic will be the name of your database suffixed with the chat Context. Actuality my database name is myTestDB, appropriately the ambience chic name is myTestDBContext. We accept now auspiciously scaffolded our Models appliance EF Amount database aboriginal approach.

Right-click on ServerSideSPA.App activity and afresh baddest the Add >> New Binder and name the folder DataAccess. We will be abacus our chic to handle database accompanying operations central this binder only.

c# - Create and Edit ASP.net web forms project on VisulaStudio 10 ..
c# – Create and Edit ASP.net web forms project on VisulaStudio 10 .. | how to create web form in asp net

Right bang on the DataAccess binder and baddest Add >> Class.

Name your chic EmployeeDataAccessLayer.cs. Accessible EmployeeDataAccessLayer.cs and put the afterward cipher into it:

Here, we accept authentic the methods to handle database operations. GetAllEmployees will back all the agent abstracts from Agent table. Similarly, AddEmployee will actualize a new agent almanac and UpdateEmployee will amend the almanac of an absolute employee. GetEmployeeData will back the almanac of the agent agnate to the agent ID anesthetized to it and DeleteEmployee will annul the agent almanac agnate to the agent id anesthetized to it. GetCityData will back the account of all the cities from the Cities table.

Right-click on the Services binder and baddest Add >> Class. Set the name of the chic as EmployeeService.cs and bang Add. This will add the EmployeeService chic to the Casework folder.

Open EmployeeService.cs and put the afterward cipher into it:

We will adjure the methods in the  EmployeeDataAccessLayer class from our service. The account will be injected into our apparatus and the apparatus will alarm the account methods to admission the database.

At this point, the ServerSideSPA.App activity has the afterward structure:

To accomplish the account accessible to the apparatus we charge to configure it on the server-side app. Accessible the ServerSideSPA.App >> Startup.cs file. Add the afterward band central the ConfigureServices method of the Startup class.

Refer to the angel below:

Now we will advance to actualize our appearance component.

We will add the Razor folio in the ServerSideSPA.App /Pages folder. By default, we accept “Counter” and “Fetch Data” pages provided in our application. These absence pages will not affect our appliance but for the account of this tutorial, we will annul the fetchdata and adverse pages from the ServerSideSPA.App/Pages folder.

Right-click on ServerSideSPA.App /Pages binder and afresh baddest Add >> New Item. An “Add New Item” chat box will open, baddest “ASP.NET Core” from the larboard panel, afresh baddest “Razor Page” from the templates console and name it EmployeeData.cshtml. Bang Add.

How to create asp net web forms application using C# (Part 10) - YouTube - how to create web form in asp net
How to create asp net web forms application using C# (Part 10) – YouTube – how to create web form in asp net | how to create web form in asp net

This will add an EmployeeData.cshtml folio to the Pages folder. This Razor folio will accept two files, EmployeeData.cshtmland EmployeeData.cshtml.cs Now, we will add cipher to these pages.

Open the EmployeeData.cshtml folio and put the afterward cipher into it.

Let’s go over this code. At the top, we accept authentic the avenue of this folio as “/fetchemployee”. This agency if we adjoin “/fetchemployee” to the basis URL of the app, we will be redirected to this page.

We are additionally inheriting the EmployeeDataModel class, which is authentic in EmployeeData.cshtml.cs file. This will acquiesce us to use the methods authentic in the EmployeeDataModel class.

After this, we accept authentic a on to add a new agent record. When clicked, this on will accessible a modal popup to handle the user inputs.

We accept additionally authentic a chase box and agnate on to clarify the agent annal based on agent name. If you access an agent name and bang on the clarify on, it will appearance all the agent annal for which the name matches the amount entered in the field. If we bang on the clarify on after entering any amount in the chase box, it will acknowledgment all the agent records.

We will abundance the agent annal alternate from the database in the empList variable. If the capricious is not absent afresh we will bind the ethics to a table to affectation the agent annal in a collapsed fashion. Each agent almanac will additionally accept two activity links, Adapt to adapt the agent almanac and Annul to annul the agent record.

To handle the user inputs we are appliance a form. We are appliance a distinct anatomy for both Add Agent and Adapt Agent functionality. The anatomy is authentic in a modal popup and the modal popup is displayed on the awning based on the amount of a Boolean property, isAdd. The amount of this Boolean acreage is set in the cipher abaft the (.cshtml.cs) page.

The Burghal dropdown account central the anatomy is bounden to our Cities table in the database with the advice of the  cityList variable. cityList will be busy as the appliance boots up.

The anatomy will accept a Save on which will adjure the SaveEmployee method, authentic in the cipher abaft the book to Add or amend an agent record.

Similar to the Add modal popup, we additionally accept a Annul modal popup. It will be a read-only modal and ask for a acceptance to annul an agent record. Upon beat “Yes”, it will adjure the DeleteEmployee adjustment to annul the agent record.

Open EmployeeData.cshtml.cs and put the afterward cipher into it.

Let’s go over this code. We accept authentic a class,  EmployeeDataModel, that will authority all of the methods that we will be appliance in the EmployeeData.cshtml page.

c# - Create and Edit ASP.net web forms project on VisulaStudio 10 ..
c# – Create and Edit ASP.net web forms project on VisulaStudio 10 .. | how to create web form in asp net

We are injecting our EmployeeService  into the EmployeeDataModel class so that the client-side methods can adjure our services.

The variables empList and cityList hold the abstracts from the Employee table and Cities table, respectively. The variables are initialized inside OnInitAsync to accomplish abiding that the abstracts is accessible to us as the folio loads.

We will use the FilterEmp adjustment to clarify the agent abstracts based on the agent name property. This acreage will avoid the argument case of the chase cord and allotment all the annal that match, either absolutely or partially, with the chase string.

Clicking on the “Add Employee” on will adjure the AddEmp method. It will initialize an abandoned instance of the Agent archetypal and set the amount of the  isAdd Boolean banderole to true. This will accessible a modal popup with a form, allurement the user to access a new agent record. Similarly, we accept authentic an EditEmployee method, which will back the almanac of the agent based on the agent id for which it is invoked. It will additionally set the amount of isAdd to accurate to accessible the modal popup to adapt the agent record.

The SaveEmployee adjustment will analysis if it is invoked to add a new agent almanac or to adapt an absolute agent record. If the EmployeeId acreage is set afresh it is an “edit” appeal and we will adjure the Adapt adjustment of our service. If EmployeeId is not set afresh it is a “create” appeal and we will adjure the Actualize adjustment of our service. We will afresh back the adapted agent almanac by calling the GetEmployee method and additionally set the amount of isAdd to false, appropriately closing the modal popup.

The DeleteConfirm adjustment is invoked on beat the Annul on agnate to an agent record. It will set the amount of the isDeleteBoolean banderole to true, which will affectation a Annul acceptance modal popup. Upon beat YES central this popup, the DeleteEmployee method is invoked which will annul the agent almanac and set the isDelete Boolean banderole to apocryphal to aing the modal popup.

The aftermost footfall is to add the articulation to our “EmployeeData” folio in the aeronautics menu. Accessible ServerSideSPA.App/Shared/NavMenu.cshtml folio and put the afterward cipher into it.

This completes our Distinct Folio Appliance appliance the server-side Blazor.

Press F5 to barrage the application.

A web folio will accessible as apparent in the angel below. The aeronautics card on the larboard is assuming aeronautics links for Agent abstracts page.

Click on “Employee data” link, it will alter to EmployeeData view. Actuality you can see all the agent abstracts on the page. Notice the URL has “/fetchemployee” added to it.

Click on Add Agent on to accessible the “Add Employee” modal popup. Access the abstracts in all the fields and bang on Save to actualize a new agent record.

html - unable to make webform Structure like as shown in image in ..
html – unable to make webform Structure like as shown in image in .. | how to create web form in asp net

This will actualize a new agent almanac and affectation the abstracts on the appearance table. Add few added annal and the appearance will be agnate as apparent below:

Click on Adapt on, it will afresh accessible the modal popup for alteration the agent record. Adapt the ascribe fields and bang on save to amend the agent record.

To clarify the annal of the employee, access the agent name in the chase box and bang on Clarify on. The chase argument is case absolute and the clarify operation will acknowledgment all the agent annal analogous the name entered in the chase field. Accredit to the angel below:

If you bang on the Annul on agnate to the agent record, it will accessible a annul acceptance popup allurement for a acceptance to annul the agent record.

Clicking on YES will annul the agent abstracts and appearance the adapted account of advisers by auspicious the appearance table.

We accept created a server-side Blazor appliance appliance Entity Framework Amount DB aboriginal approach. We acclimated Visual Studio 2017 and SQL Server 2017 to actualize our application. A modal popup is acclimated to handle user inputs via a anatomy and implemented the chase functionality on the agent records.

Please get the antecedent cipher from GitHub and comedy about to get a bigger understanding.

You can analysis my added accessories on Blazor here.

You Will Never Believe These Bizarre Truths Behind How To Create Web Form In Asp Net | How To Create Web Form In Asp Net – how to create web form in asp net
| Pleasant to be able to my website, on this time I will teach you with regards to how to create web form in asp net
.

Create the Project | Microsoft Docs - how to create web form in asp net
Create the Project | Microsoft Docs – how to create web form in asp net | how to create web form in asp net
ASP.NET Tutorial 10- How to Create a Login website - Creating ..
ASP.NET Tutorial 10- How to Create a Login website – Creating .. | how to create web form in asp net
Create an ASP
Create an ASP | how to create web form in asp net
Getting Started with ASP.NET 10.10 Web Forms and Visual Studio 10 ..
Getting Started with ASP.NET 10.10 Web Forms and Visual Studio 10 .. | how to create web form in asp net

Gallery for You Will Never Believe These Bizarre Truths Behind How To Create Web Form In Asp Net | How To Create Web Form In Asp Net