SQL Server Articles

Category - SQL Server

02 Dec 2019 02 Dec 2019 Mudassar Khan 0 Comments 1136 Views

ASP.Net SQL Server GridView Entity Framework LINQ

Here Mudassar Ahmed Khan has explained with an example, how to use Group By Clause in LINQ with Entity Framework using C# and VB.Net.

This article will illustrate how to use Group By Clause in LINQ with Entity Framework and then later use it to populate GridView control in ASP.Net with C# and VB.Net.

22 Nov 2019 22 Nov 2019 Mudassar Khan 0 Comments 1703 Views

ASP.Net SQL Server jQuery CSS Entity Framework MVC WebGrid

Here Mudassar Ahmed Khan has explained with an example, how to highlight Selected Row of WebGrid in ASP.Net MVC Razor.

The WebGrid Row will be attached with a jQuery Click event handler. When the WebGrid Row is clicked and selected, it will be highlighted by applying a CSS class in ASP.Net MVC Razor.

10 Oct 2019 10 Oct 2019 Mudassar Khan 0 Comments 2862 Views

ASP.Net SQL Server GridView jQuery jQuery Plugins TextBox

Here Mudassar Ahmed Khan has explained with an example, how to implement jQuery AutoComplete TextBox inside GridView in ASP.Net using C# and VB.Net.

The jQuery AutoComplete Plugin is applied to all the TextBoxes and the data for the jQuery AutoComplete TextBox will be populated from the SQL Server database in ASP.Net using C# and VB.Net.

04 Oct 2019 04 Oct 2019 Mudassar Khan 0 Comments 8314 Views

ASP.Net JavaScript SQL Server GridView ASP.Net Validators

Here Mudassar Ahmed Khan has explained with an example, how to check for duplicate values while inserting in GridView without SQL in ASP.Net using C# and VB.Net.

When the Add Button is clicked, the values of TextBoxes will be compared with the Row values of the GridView using ASP.Net CustomValidator and JavaScript and if the values are duplicate, error messages will be displayed.

06 Sep 2019 06 Sep 2019 Mudassar Khan 0 Comments 10889 Views

ASP.Net Excel SQL Server Word PDF Image

Here Mudassar Ahmed Khan has explained with an example, how to download (save) VARBINARY data as File from SQL Server database table in ASP.Net using C# and VB.Net.

Files such as Images, PDF, Word or Excel Documents, Audio and Video files will be saved as VARBINARY data in SQL Server database table and later the VARBINARY data will be converted back to the file and downloaded in ASP.Net using C# and VB.Net.