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
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
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
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
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
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.