AspnetO

We code, that works!

Best 100+ Frequently Asked Interview Questions in .Net SQL

| Folls In: Asp.net, Interview Questions, OOP, SQL Server |

In this tutorial, I’m going to post common and frequently asked technical interview questions in .net sql oops with answers for fresher as well as experience developers. I also wrote many other tutorials on Interview Questions, Asp.net, SQL Server, OOP Concepts as well as Top 10 OOPS Concepts in details. I recommend you to read those tutorials, I’m sure, you’ll enjoy it! It’s very difficult to predict what interviewer will ask during interview, right? . . I think so, but I can assure that following are the best list of possible technical interview questions that I’d faced during my job interviews and also I asked as an interviewer in my professional carrier.

Import CSV Data in SQL Server Using .NET Bulk Insert

| Folls In: Asp.net, C#, SQL Server, VB |

In my previous tutorials, I’d explained get gridview selected row hiddenfield value using jquery, how to keep gridview selected rows during paging, how to print gridview data on print button click event and other more cracking tutorials on GridView, Asp.net here. Now here in this tutorial, I’ll explain how to read csv or excel file data into datatable and then do bulk insert into sql server using SqlBulkCopy in asp.net using c# and vb.net with example code.

Pass DataTable in Stored Procedure Parameter in .Net

| Folls In: Asp.net, C#, Interview Questions, SQL Server, VB |

In my previous tutorials, I’d explained passing table valued parameters in stored procedure in sql server, get gridview selected row hiddenfield value using jquery, exporting gridview data to word excel text or pdf and other more cracking tutorials on Asp.net, SQL Server here. Now here in this tutorial, I’ll explain how you can pass datatable in stored procedure parameter in asp.net using c# or vb.net with example code and step by step guide.

Passing Table Valued Parameters in SQL Stored Procedure

| Folls In: SQL Server |

In my previous tutorials, I’d explained how to pass TVP or DataTable as Stored Procedure Parameter in asp.net, exporting gridview data to word excel text and pdf, how to show alert message from code-behind and other more cracking tutorials on SQL Server, Asp.net here. Now here in this tutorial, I’ll explain how you can pass a table valued parameters variable into a stored procedure parameter and perform required DML operations in sql server with example demo code.

Asp.net GridView Inline Insert Update Delete Data In C# Vb

| Folls In: Asp.net, C#, SQL Server, VB |

In my previous tutorials, I’d explained about how to bind data to gridview, how to get connection string, insert update delete gridview data using parameterized query, difference between executereader executenonquery and executescalar and other more cracking tutorials on GridView, Asp.net, SQL Server here. Now here in this tutorial, I’ll explain how to show data in gridview and then perform CRUD operations on gridview data. I’ll cover asp.net gridview inline insert update delete data in c# as well as vb with example code.

Simple Insert Update Delete Gridview Records In Asp.net C# Vb

| Folls In: Asp.net, C#, SQL Server, VB |

In my previous tutorials, I’d explained about how to bind data to gridview, how to get connection string, gridview inline insert update delete, difference between executereader executenonquery executescalar and other more cracking tutorials on GridView, Asp.net, SQL Server here. Now here in this tutorial, I’ll explain how to show data in gridview and then insert update delete gridview records (perform CRUD operation) in asp.net using c# as well as vb.net with example code.

The Man Behind AspnetO

Subscribe To Newsletter

Enter your email address to subscribe to this blog and receive notifications of new posts right to your inbox

Join 1000+ other subscribers

Hot on AspnetO

Icon
Gridview Insert Update Delete Example in Asp.net, C#, Vb.net 7260 downloads 39.76 KB
Icon
Gridview Insert Update Delete Example in Asp.net, C#, Vb.net 6219 downloads 39.76 KB
Icon
Gridview Insert Update Delete Example in Asp.net, C#, Vb.net 6217 downloads 39.76 KB
Icon
Export gridview all rows or selected rows to word, excel, text, pdf examples 3066 downloads 1.01 MB
Icon
Export gridview all rows or selected rows to word, excel, text, pdf examples 3000 downloads 1.01 MB