Videos (502) - Page 22

How to connect asp.net to a database 

This video teaches you to connect a front end to sql data source through form-view, grid-view and details-view controls

C# interview questions on ENUM :- How to convert String to a ENUM? 

In this video we will try to understand how to convert String to a ENUM.

C# interview questions :- Explain typesafe,casting , implicit casting and explicit casting ? 

This video explains typesafe,casting , implicit casting and explicit casting .

Explain Coalescing operator (??) in C# ? C# and .NET interview questions with answers 

"??" is a NULL coalescing operator. If you see the English meaning of coalescing it says "consolidate together". Coalescing operator returns the first NON-NULL value from a chain. For example below is a simple coalescing code which chains four strings. So if "str1" is null it will try "str2" , if "str2" is null it will try "str3" and so on until it finds a string with a non-null value. string final =str1 ?? str2 ?? str3 ?? str4;

Differences between ISNULL and NULLIF - sql server interview questions 

Hi friends, in this session I am gonna discuss the differences between ISNULL and NULLIF. Both ISNULL and NULLIF are built in system functions in sql server. Lot of people get confused between these 2 system functions. Lets discuss about each of these system functions separately so that you will get better idea. 1st lets discuss about ISNULL. ISNULL: ISNUL is a system function which replaces NULL with the specified replacement value. The functionalityof ISNULL is : 1. 1st it will Evaluate the expression which is in parameter 1. 2. it will compare the evaluated expression with null. if the paramter 1 = NULL ? 3. If parameter1 is equal to null i.e., if parameter 1 is null, then isnull function returns replacement value. if parameter1is not NULL, then ISNULL function returns parameter1 I hope we are clear on ISNULL. Lets move on to the next system function, that is NULLIF. NULLIF: NULLIF is a system function which returns a null value if the two speci ...

Differences between primary key and unique key - SQL Server Interview Questions 

Hi Friends, In this in this session we are going to learn the differences between primary key and unique key This is one of the most frequently asked sql server interview questions. Before we discuss the difference between primary key and unique key, let's see what a primary key is and what a unique key is. Primary Key: Primary key is a key which uniquely identifies each row/record in the table. This implies if you have a primary key on a table, you can identify each and every row in that table uniquely using primary key. Unique Key: Unique key constraint enforces the uniqueness on the columns in which it is defined. That is Unique key will make sure only unique values are allowed in the columns in which it is defined. Similarities: Both Primary key and unique Key enforces uniqueness on the columns on which they are defined. • Primary key and unique Key columns allow only unique values. • Primary key and unique Key columns will avoid duplicates • Both Primary ...

ADO.NET Entity interview questions: - Insert, Update and Delete using Entity Framework. 

This video will discuss about Insert, Update and Delete using Entity Framework.

c# Fragile class problem ( .NET and c# interview question videos) 

Inheritance is a great power by which developers can increase reusability in parent-child relationship. But with great powers comes greater responsibility and also problems. One of the problems which creep's in is the "Fragile parent class problem".

What are Async and Await ( .NET 4.5 Interview question with answers)? 

Async and await are markers which mark code positions from where control should resume after a task (thread) completes.

What are Portable Class library in c# ? (C# and .NET interview questions) 

The whole point of creating a class library project is reusability. Now we want this reusability not only within a .NET application, not across .NET applications but across different types of .NET applications. Now different types of .NET application means WPF, Windows, Silver light, Windows phone etc. That's where portable class libraries are useful. By creating a portable class we can reference it in any kind of .NET project types.

What is NuGet ?(C# Interview questions with answers) 

In this video we try to understand need of Nuget and how to use the same.

Response.Redirect (False vs True) ASP.NET Interview questions with answers. 

This video explains what is the difference between Response.redirect true vs false.