SQL Server Articles

Category - SQL Server

04 Feb 2019 04 Feb 2019 Mudassar Khan 0 Comments 327 Views

Here Mudassar Ahmed Khan has explained with an example, how to retrieve data from Database and set the value in TextBox in ASP.Net using C# and VB.Net.

This article will illustrate how to fetch records (data) from SQL Server Database using SqlDataReader and then set the retrieved values in TextBoxes in ASP.Net using C# and VB.Net.

01 Feb 2019 01 Feb 2019 Mudassar Khan 0 Comments 595 Views

ASP.Net SQL Server GridView

Here Mudassar Ahmed Khan has explained with an example, how to upload and download PDF file from SQL Server Database in ASP.Net using C# and VB.Net.

The PDF file will be uploaded using FileUpload control and will be inserted into SQL Server Database Table.

A GridView control will display the PDF file present in the SQL Server Database Table along with an option to download the selected PDF file from Database in ASP.Net.

22 Jan 2019 22 Jan 2019 Mudassar Khan 0 Comments 1098 Views

ASP.Net JavaScript AJAX SQL Server jQuery Charts HTML5

Here Mudassar Ahmed Khan has explained with an example, how to implement Open Source charts in ASP.Net using C# and VB.Net.

The Chart.js library is an Open Source Chart library which uses HTML5 Canvas for creating Charts.

The HTML5 Canvas charts will be populated from database using jQuery AJAX in ASP.Net.

21 Jan 2019 21 Jan 2019 Mudassar Khan 0 Comments 690 Views

ASP.Net SQL Server Entity Framework MVC TextBox Model

Here Mudassar Ahmed Khan has explained with an example, how to retrieve (display) data from Database in TextBoxes in ASP.Net MVC Razor.

The data (records) from Database will be fetched using Entity Framework and will be displayed in TextBoxes created using Model class in ASP.Net MVC Razor.

20 Nov 2018 20 Nov 2018 Mudassar Khan 0 Comments 2501 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC

Here Mudassar Ahmed Khan has explained with an example, how to insert (save) data (records) to database by calling Stored Procedure using Entity Framework in ASP.Net MVC Razor.

First the multiple rows (records) will be insert into an HTML Table and then the data from all the rows of the HTML Table will be sent to Controller using jQuery AJAX which will be ultimately saved to database by calling Stored Procedure using Entity Framework in ASP.Net MVC Razor.