• Microsoft SQL Server

    Microsoft SQL Server articles, samples, code snippets, applications, books, products.

    How to Save the Data Submitted into SQL Database

    by  • January 11, 2016 • Microsoft ADO.NET, Microsoft ASP.NET MVC, Microsoft SQL Server • 0 Comments

    Here we will discuss, how can we save the data submitted by the user into a database. We don’t directly interact with the database. For database interaction, we have to add ADO.NET entity framework data model as we did in the previous article. After adding the ADO.NET entity framework data model, we write a two methods...

    Read more →

    How to Create Visual Studio Report (rdlc) in ASP.NET MVC 4?

    by  • October 5, 2015 • Microsoft .NET Framework, Microsoft ASP.NET MVC, Microsoft SQL Server • 0 Comments

    Introduction: In this article I will explains how to use Microsoft Report(rdlc) in ASP.NET MVC 4. Most of the developers use Microsoft Report (rdlc) for generating report in ASP.NET MVC 4 application. Below i am explaining how to use Microsoft Report (rdlc) in ASP.NET MVC 4. Prerequisite: .NET framework 4.0 to 4.5 Entity Framework...

    Read more →

    How to create a stored procedure with table valued parameter in SQL Server

    by  • May 28, 2014 • Microsoft SQL Server • 0 Comments

    SQL Server provides a facility to create stored procedure with table valued parameter. This facility was introduced in SQL Server 2008 and it is indeed a great feature of SQL Server. Table valued parameter provides a great ease and flexibility to the development process because we can avoid constructing and parsing XML data. Now,...

    Read more →