Home
Videos uploaded by user “kudvenkat”
Part 5   ASP NET Web API Content Negotiation
 
08:23
In this video we will discuss Content Negotiation in Web API. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-content-negotiation.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-content-negotiation_5.html Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html
Views: 176923 kudvenkat
Part 32 - C# Tutorial - Abstract classes in c#.avi
 
09:50
In this part of the c sharp tutorial we will learn about abstract classes Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-32-c-tutorial-abstract-classes.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-32-abstract-classes.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 286515 kudvenkat
Part 4   Delete duplicate rows in sql
 
03:26
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 337698 kudvenkat
Part 6  ViewData and ViewBag in mvc
 
06:19
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/04/part-6-viewdata-and-viewbag-in-mvc.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-6-view-data-and-view-bag-in-mvc.html All ASP .NET MVC Text Articles http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-tutorial-for-beginners.html All ASP .NET MVC Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What is ViewData 2. What is ViewBag 3. Difference between ViewData and ViewBag Both ViewData and ViewBag are used to pass data from a controller to a view. ViewData is a dictionary of objects that are stored and retrieved using strings as keys. The syntax of ViewData is very similar to that of ViewState, SessionState and ApplicationState. // Storing data in ViewData ViewData["YourData"] = "SomeData"; // Retrieving data from ViewData string strData = ViewData["YourData"].ToString(); ViewData does not provide compile time error checking. For example, if you mis-spell the key names you wouldn't get any compile time error. You get to know about the error only at runtime. ViewBag uses the dynamic feature that was introduced in to C# 4. It allows an object to have properties dynamically added to it. Using ViewBag the above code can be rewritten as below. // Storing data in ViewBag ViewBag.YourData = "SomeData"; // Retrieving data from ViewBag string strData = ViewBag.YourData; Just like ViewData, ViewBag does not provide compile time error checking. For example, if you mis-spell the property name, you wouldn't get any compile time error. You get to know about the error only at runtime. Internally ViewBag properties are stored as name/value pairs in the ViewData dictionary. Please Note: To pass data from controller to a view, It's always a good practice to use strongly typed view models instead of using ViewBag & ViewData. Strongly typed view models provide compile time error checking. We will discuss view models in a later video session.
Views: 448295 kudvenkat
Clustered and nonclustered indexes in sql server   Part 36
 
16:49
In this video we will learn about 1. Different types of indexes in sql server 2. What are clustered indexes 3. What are NonClustered indexes 4. Difference between clustered and non clustered indexes Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/09/clustered-and-non-clustered-indexes.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-36-clustered-nonclustered-indexes.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 470840 kudvenkat
FIRST VALUE function in SQL Server
 
02:48
In this video we will discuss FIRST_VALUE function in SQL Server FIRST_VALUE function Introduced in SQL Server 2012 Retrieves the first value from the specified column ORDER BY clause is required PARTITION BY clause is optional Syntax : FIRST_VALUE(Column_Name) OVER (ORDER BY Col1, Col2, ...) FIRST_VALUE function example WITHOUT partitions : In the following example, FIRST_VALUE function returns the name of the lowest paid employee from the entire table. SELECT Name, Gender, Salary, FIRST_VALUE(Name) OVER (ORDER BY Salary) AS FirstValue FROM Employees FIRST_VALUE function example WITH partitions : In the following example, FIRST_VALUE function returns the name of the lowest paid employee from the respective partition. SELECT Name, Gender, Salary, FIRST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary) AS FirstValue FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/firstvalue-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/firstvalue-function-in-sql-server_6.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 33754 kudvenkat
Lead and Lag functions in SQL Server 2012
 
07:27
In this video we will discuss about Lead and Lag functions. Lead and Lag functions Introduced in SQL Server 2012 Lead function is used to access subsequent row data along with current row data Lag function is used to access previous row data along with current row data ORDER BY clause is required PARTITION BY clause is optional Syntax LEAD(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) LAG(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) Offset - Number of rows to lead or lag. Default_Value - The default value to return if the number of rows to lead or lag goes beyond first row or last row in a table or partition. If default value is not specified NULL is returned. We will use the following Employees table for the examples in this video SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 1000) Insert Into Employees Values (2, 'John', 'Male', 2000) Insert Into Employees Values (3, 'Pam', 'Female', 3000) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 5000) Insert Into Employees Values (6, 'Mary', 'Female', 6000) Insert Into Employees Values (7, 'Ben', 'Male', 7000) Insert Into Employees Values (8, 'Jodi', 'Female', 8000) Insert Into Employees Values (9, 'Tom', 'Male', 9000) Insert Into Employees Values (10, 'Ron', 'Male', 9500) Go Lead and Lag functions example WITHOUT partitions : This example Leads 2 rows and Lags 1 row from the current row. When you are on the first row, LEAD(Salary, 2, -1) allows you to move forward 2 rows and retrieve the salary from the 3rd row. When you are on the first row, LAG(Salary, 1, -1) allows us to move backward 1 row. Since there no rows beyond row 1, Lag function in this case returns the default value -1. When you are on the last row, LEAD(Salary, 2, -1) allows you to move forward 2 rows. Since there no rows beyond the last row 1, Lead function in this case returns the default value -1. When you are on the last row, LAG(Salary, 1, -1) allows us to move backward 1 row and retrieve the salary from the previous row. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (ORDER BY Salary) AS Lag_1 FROM Employees Lead and Lag functions example WITH partitions : Notice that in this example, Lead and Lag functions return default value if the number of rows to lead or lag goes beyond first row or last row in the partition. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lag_1 FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server_5.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 50631 kudvenkat
AngularJS tutorial -  What is AngularJS
 
10:28
AngularJS tutorial - What is AngularJS In this video we will discuss What is AngularJS Benefits of AngularJS A simple AngularJS example What is AngularJS AngularJS is a JavaScript framework that helps build applications that run in a web browser. Who developed AngularJS Google is the company that developed AngularJS. AngularJS is an open source project, which means it can be be freely used, changed, and shared by anyone. AngularJS is an excellent framework for building both Single Page Applications (SPA) and Line of Business Applications. Many companies are using Angular today, and there are many public facing web sites that are built with angular. There is a website, https://www.madewithangular.com, that has the list of web sites that are built using AngularJS. Within this list you can find many popular websites. What are the benefits of using AngularJS 1. Dependency Injection : Dependency Injection is something AngularJS does quite well. If you are new to Dependency Injection, don't worry, we will discuss it in detail with examples in a later video. 2. Two Way Data-Binding : One of the most useful feature in AngularJS is the Two Way Data-Binding. The Two Way Data-Binding, keeps the model and the view in sync at all times, that is a change in the model updates the view and a change in the view updates the model. 3. Testing : Testing is an area where Angular really shines. Angular is designed with testing in mind right from the start. Angular makes it very easy to test any of it's components through both unit testing and end to end testing. So there's really no excuse for not testing any of your angular application code. 4. Model View Controller : With angular it is very easy to develop applications in a clean MVC way. All you have to do is split your application code into MVC components. The rest, that is managing those components and connecting them together is done by angular. 5. Many more benefits like controlling the behaviour of DOM elements using directives and the flexibility that angular filters provide. We will discuss directives, filters, Modules, Routes etc with examples in our upcoming videos in this series. To build angular applications you only need one script file and that is angular.js. To get the script file visit https://angularjs.org. From here 1. You can download the angular script file 2. CDN link - We discussed the benefits of using CDN in Part 3 of jQuery tutorial. 3. Various resources to learn angular - Here you will find videos, Free courses, Tutorials and Case Studies. You will also find API reference which is extremeley useful. To get started with angular 1. Add a reference to the angular script 2. Include ng-app attribute What is ng-app In angular, ng-app is called a directive. There are many directives in angular. You can find the complete list of directives on https://angularjs.org. The ng prefix in the directive stands for angular. The ng-app directive is a starting point of AngularJS Application. Angular framework will first check for ng-app directive in an HTML page after the entire page is loaded. If ng-app directive is found, angular bootstraps itself and starts to manage the section of the page that has the ng-app directive. So the obvious next question is, where to place the ng-app directive on the page It should be placed at the root of the HTML document, that is at the [html] tag level or at the [body] tag level, so that angular can control the entire page. However, there is nothing stopping you from placing it on any other HTML element with in the page. When you do this only that element and it's children are managed by angular. Double curly braces are called binding expressions in angular. These All the following are valid expressions in angular {{ 1 == 1 }} - Evaluates to true {{ { name: 'David', age : '30' }.name }} - Returns the name property value {{ ['Mark', 'David', 'Sara'][2] }} - Returns the 2nd element from the array Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/what-is-angularjs.html
Views: 1690156 kudvenkat
Self join in sql server - Part 14
 
11:19
In this video we will learn about 1. Self Join - Joining a table with itself 2. Self Join is not a different type of join. It can be classified as Inner Self Join, Outer Self Join (Left, Right and Full), or Cross Self Join. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/self-join-in-sql-server-part-14.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-14-self-join.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 347353 kudvenkat
Part 26   What is a windows service
 
05:56
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2014/02/part-26-what-is-windows-service_8.html Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss 1. What is a windows service and how do they differe from regular applications and programs 2. How to view all the services installed on a windows machine 3. What is the use of windows services 4. When would an asp.net developer use a windows service What is a windows service and how do they differ from regular applications and programs A windows service is similar to any other program or application running on a windows machine. The following are the differences between a windows service and a regular application 1. Windows service runs in the background 2. They can be configured to start automatically when the system starts 3. They don't have user interface. How to view all the services installed on a windows machine 1. Open run windows by pressing Windows + R key 2. Type services.msc and press enter 3. The services window should display all the services installed on your computer What is the use of windows services Windows services provide core operating system features such as Event Logging - Windows Event Log Service Providing Security - Windows Firewall Service Error reporting - Windows Error Reporting Service When would an asp.net developer use a windows service In general, we should create a Windows Service to run code in the background all the time, without any sort of user interaction. An asp.net developer can use a windows service to host a wcf service. We can then configure the windows service to start automatically when the computer starts. This makes our WCF service always available for clients to consume, even if no-one is logged on, on that computer. In our next video, we will discuss, creating a windows service to host a WCF service
Views: 78949 kudvenkat
Part 72   HandleError attribute in mvc
 
10:10
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/08/part-72-handleerror-attribute-in-mvc.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss HandleError attribute in asp.net mvc. HandleErrorAttribute is used to display friendly error pages to end user when there is an unhandled exception. Let us understand this with an example. Step 1: Create a blank asp.net mvc 4 application. Step 2: Add a HomeController. Copy and paste the following code. public ActionResult Index() { throw new Exception("Something went wrong"); } Notice that, the Index() action method throws an exception. As this exception is not handled, when you run the application, you will get the default "yellow screen of death" which does not make sense to the end user. Now, let us understand replacing this yellow screen of death, with a friendly error page. Step 3: Enable custom errors in web.config file, that is present in the root directory of your mvc application. "customErrors" element must be nested under "[system.web]" [customErrors mode="On"] [/customErrors] Step 4: Add "Shared" folder under "Views" folder. Add Error.cshtml view inside this folder. Paste the following HTML in Error.cdhtml view. [h2]An unknown problem has occured, please contact Admin[/h2] Run the application, and notice that, you are redirected to the friendly "Error" view, instead of the generic "Yellow screen of death". We did not apply HandleError attribute anywhere. So how did all this work? HandleErrorAttribute is added to the GlobalFilters collection in global.asax. When a filter is added to the GlobalFilters collection, then it is applicable for all controllers and their action methods in the entire application. Right click on "RegisterGlobalFilters()" method in Global.asax, and select "Go To Definition" and you can find the code that adds "HandleErrorAttribute" to GlobalFilterCollection. public static void RegisterGlobalFilters(GlobalFilterCollection filters) { filters.Add(new HandleErrorAttribute()); } Is the friendly error page displayed for HTTP status code 404? No, but there is a way to display the friendly error page. In the HomeController, we do not have List() action method. So, if a user navigates to /Home/List, we get an error - The resource cannot be found. HTTP 404. To display a friendly error page in this case Step 1: Add "ErrorController" to controllers folder. Copy and paste the following code. public class ErrorController : Controller { public ActionResult NotFound() { return View(); } } Step 2: Right click on "Shared" folder and add "NotFound.cshtml" view. Copy and paste the following code. [h2]Please check the URL. The page you are looking for cannot be found[/h2] Step 3: Change "customErrors" element in web.config as shown below. [customErrors mode="On"] [error statusCode="404" redirect="~/Error/NotFound"/] [/customErrors] Make sure to replace [ with LESSTHAN and ] with GREATERTHAN symbol.
Views: 101597 kudvenkat
Part 33 - C# Tutorial - Difference between abstract classes and interfaces.avi
 
05:15
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-33-c-tutorial-difference-between.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-33-abstract-classes-vs-interfaces.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this part of the c sharp tutorial we will learn about the differences between abstract classes and interfaces
Views: 329486 kudvenkat
Async and await in C# example
 
11:56
In this video we will discuss async and await keywords and their use with an example. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/10/async-and-await-in-c-example.html Slides http://csharp-video-tutorials.blogspot.com/2016/10/async-and-await-in-c-example_31.html All C# Text Articles http://csharp-video-tutorials.blogspot.com/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All C# Videos https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 190794 kudvenkat
Part 31 - C# Tutorial - Explicit interfaces implementation.avi
 
12:49
In this part of the c sharp tutorial we will learn about explicit interface implementation. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-31-c-tutorial-explicit-interface.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-31-explicit-interface.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 243918 kudvenkat
Joins in sql server - Part 12
 
17:43
In this video we will learn about 1. The different types of Joins in sql server 2. Cross Join 3. Inner Join 4. Outer Join -- Left , Right and Full Outer Join. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/joins-in-sql-server-part-12.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-12-joins.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 591887 kudvenkat
Angular reactive forms
 
10:49
In this video we will discuss reactive forms in Angular. There are 2 ways to create forms in Angular 1. Template Driven Forms 2. Reactive Forms (Also called Model Driven Forms) Here is the link to Angular CRUD playlist. We discussed Template forms in Part 5. https://www.youtube.com/playlist?list=PL6n9fhu94yhXwcl3a6rIfAI7QmGYIkfK5 Text version of the video http://csharp-video-tutorials.blogspot.com/2018/09/angular-reactive-forms.html Slides http://csharp-video-tutorials.blogspot.com/2018/09/angular-reactive-forms-slides.html Angular 6 Tutorial https://www.youtube.com/playlist?list=PL6n9fhu94yhWNJaDgh0mfae_9xoQ4E_Zj Angular 6 Tutorial Text Articles & Slides http://csharp-video-tutorials.blogspot.com/2018/09/angular-6-tutorial-for-beginners.html Angular, JavaScript, jQuery, Dot Net & SQL Playlists https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd As the name implies, Template Driven Forms are heavy on the template meaning we create the form completely in HTML. Template driven forms are easy to build and understand. They are great for creating simple forms. However, creating complex forms using template driven approach is not recomended as the HTML can get very complicated and messy. It is not easy to unit test template forms as the logic is in the HTML. Reactive forms on the other hand allow us to build the form completely in code. This is more flexible and has many benefits over template forms. For example, it is easy to add form input elements dynamically and adjust validation at runtime based on the decisions made in code. It is also easy to unit test as most of the logic and validation is in the component class. The only downside of reactive forms is that they require more code than template forms. In this video and in our upcoming videos we will discuss everything we need to know to build complex reactive forms. With a reactive form, we create the entire form control tree in the component class code. Let us understand this by creating a simple form with just 2 form controls as shown below.
Views: 34778 kudvenkat
Cookies in asp.net   Part 60
 
10:51
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/11/cookies-in-aspnet-part-60.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-60-cookies-in-aspnet.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Cookies can be used to send data from one webform to another. Cookies store small amounts of information on the client's machine. In general, web sites use cookies to store user preferences or other information that is client-specific. Cookies can be broadly classified into 2 types 1. Persistent cookies - Remain on the client computer, even after the browser is closed. You can configure how long the cookies remain using the expires property of the HttpCookie object. 2. Non-Persistent cookies - If you don't set the Expires property, then the cookie is called as a Non-Persistent cookie. Non-Persistent cookies only remain in memory until the browser is closed.
Views: 135125 kudvenkat
DotNet Program Execution
 
18:00
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists My Blog: www.csharp-video-tutorials.blogspot.co.uk My Channel: www.youtube.com/user/kudvenkat In this video we will learn 1. .NET application execution 2. Understand Managed code and Unmanaged code 3. Intermediate language 4. Advantages of CLR
Views: 409762 kudvenkat
Two way databinding in AngularJS
 
07:30
2 way data binding angularjs angularjs directive two way binding angularjs two way binding example ng-model directive example angularjs ng-model example In this video we will discuss, Two way databinding in AngularJS. Along the way we also discuss one of the very useful directive in angular ng-model. One of the most useful feature in AngularJS is the Two Way Data-Binding. The Two Way Data-Binding, keeps the model and the view in sync at all times, that is a change in the model updates the view and a change in the view updates the model. When the model changes the view is automatically updated. This is achieved using the data binding expression in the view. How about the other way round. How to keep the model up to date when the view changes. That's exactly is the purpose of ng-model directive. In the html below, notice the input element is decorated with ng-model directive. This ensures that whenever the value in the textbox is changed, angular will automatically update the message property of the $scope object. This means the ng-model directive automatically takes the form values and updates the model. The binding expression does the opposite, i.e whenever the model changes the view is automatically updated. Because of the two way data binding provided by angular, as you type in the textbox, the value is immediately displayed on the view just below the textbox. This two way binding feature provided by angular, eliminates the need to write any custom code to move data from the model to the view or from the view to the model. ng-model directive can be used with the following 3 html elements input select textarea Two way binding example with complex object is also discussed. Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/11/two-way-databinding-in-angularjs_3.html
Views: 388688 kudvenkat
Part 38 - C# Tutorial - Delegates usage in c# continued.avi
 
11:34
In this part we will learn replacing hard coded logic using delegates Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-38-c-tutorial-delegates-example-ii.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-38-delegates-usage-in-c-ii.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 268380 kudvenkat
Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008   Part 24
 
11:52
In this video we will learn about commonly string functions in sql server 2008 like Replicate, Space, Patindex, Replace, and Stuff. We will look at some real time examples of where we can use these functions. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/replicate-space-patindex-replace-and.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-24-string-functions-continued.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 178650 kudvenkat
IHttpActionResult vs HttpResponseMessage
 
08:56
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/02/ihttpactionresult-vs-httpresponsemessage.html Slides http://csharp-video-tutorials.blogspot.com/2017/02/ihttpactionresult-vs-httpresponsemessage_22.html All ASP .NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html All ASP .NET Web API Videos https://www.youtube.com/playlist?list=PL6n9fhu94yhW7yoUOGNOfHurUE6bpOO2b All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In Web API 1, we have HttpResponseMessage type that a controller action method returns. A new type called "IHttpActionResult" is introduced in Web API 2 that can be returned from a controller action method. Instead of returning HttpResponseMessage from a controller action, we can now return IHttpActionResult. There are 2 main advantages of using the IHttpActionResult interface. 1. The code is cleaner and easier to read 2. Unit testing controller action methods is much simpler. We will discuss, how easy it is to unit test a method that returns IHttpActionResult instead of HttpResponseMessagein a later video. Consider the following StudentsController. Notice both the Get() methods return HttpResponseMessage. To create the HttpResponseMessage, we either use CreateResponse() or CreateErrorResponse() methods of the Request object. public class StudentsController : ApiController { static List[Student] students = new List[Student]() { new Student() { Id = 1, Name = "Tom" }, new Student() { Id = 2, Name = "Sam" }, new Student() { Id = 3, Name = "John" } }; public HttpResponseMessage Get() { return Request.CreateResponse(students); } public HttpResponseMessage Get(int id) { var student = students.FirstOrDefault(s =] s.Id == id); if(student == null) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student not found"); } return Request.CreateResponse(student); } } In the following example, we have replaced both instances of HttpResponseMessage with IHttpActionResult. To return status code 200, we used Ok() helper method and to return status code 404, we used NotFound() method. To the Ok() method we have passed the type we want to return from the action method. Also notice, the code is now much cleaner and simpler to read. public class StudentsController : ApiController { static List[Student] students = new List[Student]() { new Student() { Id = 1, Name = "Tom" }, new Student() { Id = 2, Name = "Sam" }, new Student() { Id = 3, Name = "John" } }; public IHttpActionResult Get() { return Ok(students); } public IHttpActionResult Get(int id) { var student = students.FirstOrDefault(s =] s.Id == id); if(student == null) { return Content(HttpStatusCode.NotFound, "Student not found"); // return NotFound(); } return Ok(student); } } In addition to Ok() and NotFound() helper methods, we have the following methods that we can use depending on what we want to return from our controller action method. All these methods return a type, that implements IHttpActionResult interface. BadRequest() Conflict() Created() InternalServerError() Redirect() Unauthorized()
Views: 44388 kudvenkat
What is ASP.NET Part 1
 
11:48
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/10/what-is-aspnet-part-1.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-1-what-is-aspnet.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists asp.net tutorial for beginners. asp.net c# tutorial. asp.net tutorial for beginners using c sharp In this video we will learn 1. What is ASP.NET 2. What is a Web Application 3. What other technologies can be used to build web applications 4. What are the advantages of Web applications over desktop applications 5. How ASP.NET Web applications work
Views: 2032739 kudvenkat
Cross apply and outer apply in sql server
 
08:16
cross apply sql server example sql server outer apply example sql server join table function with parameter sql server inner join table valued function In this video we will discuss cross apply and outer apply in sql server with examples. We want to retrieve all the matching rows between Department and Employee tables. This can be very easily achieved using an Inner Join as shown below. Select D.DepartmentName, E.Name, E.Gender, E.Salary from Department D Inner Join Employee E On D.Id = E.DepartmentId Now if we want to retrieve all the matching rows between Department and Employee tables + the non-matching rows from the LEFT table (Department) This can be very easily achieved using a Left Join as shown below. Select D.DepartmentName, E.Name, E.Gender, E.Salary from Department D Left Join Employee E On D.Id = E.DepartmentId Now let's assume we do not have access to the Employee table. Instead we have access to the following Table Valued function, that returns all employees belonging to a department by Department Id. Create function fn_GetEmployeesByDepartmentId(@DepartmentId int) Returns Table as Return ( Select Id, Name, Gender, Salary, DepartmentId from Employee where DepartmentId = @DepartmentId ) Go The following query returns the employees of the department with Id =1. Select * from fn_GetEmployeesByDepartmentId(1) Now if you try to perform an Inner or Left join between Department table and fn_GetEmployeesByDepartmentId() function you will get an error. Select D.DepartmentName, E.Name, E.Gender, E.Salary from Department D Inner Join fn_GetEmployeesByDepartmentId(D.Id) E On D.Id = E.DepartmentId If you execute the above query you will get the following error Msg 4104, Level 16, State 1, Line 3 The multi-part identifier "D.Id" could not be bound. This is where we use Cross Apply and Outer Apply operators. Cross Apply is semantically equivalent to Inner Join and Outer Apply is semantically equivalent to Left Outer Join. Just like Inner Join, Cross Apply retrieves only the matching rows from the Department table and fn_GetEmployeesByDepartmentId() table valued function. Select D.DepartmentName, E.Name, E.Gender, E.Salary from Department D Cross Apply fn_GetEmployeesByDepartmentId(D.Id) E Just like Left Outer Join, Outer Apply retrieves all matching rows from the Department table and fn_GetEmployeesByDepartmentId() table valued function + non-matching rows from the left table (Department) Select D.DepartmentName, E.Name, E.Gender, E.Salary from Department D Outer Apply fn_GetEmployeesByDepartmentId(D.Id) E How does Cross Apply and Outer Apply work The APPLY operator introduced in SQL Server 2005, is used to join a table to a table-valued function. The Table Valued Function on the right hand side of the APPLY operator gets called for each row from the left (also called outer table) table. Cross Apply returns only matching rows (semantically equivalent to Inner Join) Outer Apply returns matching + non-matching rows (semantically equivalent to Left Outer Join). The unmatched columns of the table valued function will be set to NULL. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/cross-apply-and-outer-apply-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/cross-apply-and-outer-apply-in-sql_8.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 75698 kudvenkat
Strong naming an assembly
 
14:19
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists Complete 7 part Dot Net basics video series: http://www.youtube.com/playlist?list=PL8598C97BA1D871C1&feature=view_all My Blog: www.csharp-video-tutorials.blogspot.co.uk My Channel: www.youtube.com/user/kudvenkat In this video we will learn: 1. Strong naming an assembly, that is signing an assembly with strong name using private and public key pair 2. Assembly Versioning 3. Using strong naming tool - sn.exe
Views: 140726 kudvenkat
Creating altering and dropping a database - Part 2
 
15:17
In this video we will learn 1. Creating, altering and dropping a database 2. Putting a database in single user mode Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/08/creating-altering-and-dropping-database.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-2-creating-altering-and-dropping.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 987896 kudvenkat
Part 36 - C# Tutorial - Delegates in c#.avi
 
11:54
In this c sharp tutorial we will learn the basics of delegates Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-36-c-tutorial-delegates.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-36-delegates.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 401248 kudvenkat
Part 34 - C# Tutorial - Problems of multiple class inheritance.avi
 
05:06
In this part of the c sharp tutorial we will learn about the problems of multiple class inheritance Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-34-c-tutorial-problems-of-multiple.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-34-problems-of-multiple-class.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html Complete C# tutorial https://www.youtube.com/playlist?list=PLAC325451207E3105 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 172796 kudvenkat
Call ASP NET Web API from jQuery
 
08:26
Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/call-aspnet-web-api-from-jquery.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/call-aspnet-web-api-from-jquery_20.html All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html All ASP.NET Web API Videos https://www.youtube.com/playlist?list=PL6n9fhu94yhW7yoUOGNOfHurUE6bpOO2b All Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
Views: 103888 kudvenkat
What is ASP NET Core
 
09:04
Text version of the video http://csharp-video-tutorials.blogspot.com/2018/03/what-is-aspnet-core.html Slides http://csharp-video-tutorials.blogspot.com/2018/03/what-is-aspnet-core-slides.html Full ASP.NET Core course https://www.youtube.com/playlist?list=PL6n9fhu94yhVkdrusLaQsfERmL_Jh4XmU All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd What is ASP.NET CORE? Asp.net core is a free and open source web framework used to develop the next generation of ASP.NET applications. ASP.NET Core is developed and powered by Microsoft as well as the community user base It is a modular Framework that has the capability to run on legacy .NET Framework that runs on Windows as well as on cross platform systems Originally it was called asp.net next version and then later it was supposed to be called asp.net 5 when it is ready. However, Microsoft later changed the name to ASP.NET core during the first release. The first version was released on 17th may 2016 As of this video recording asp .NET core 2.0 is being used and it was released on 14 August 2017 The first question that comes into our mind when we need to use asp.net core as we have The Legacy asp.net applications. If you take a look at the comparison table below given by Microsoft it’s fairly listed out when we need to choose asp.net core against ASP.NET In spite of these points, we can say that .NET Core is not a replacement for .NET Framework and we still need to use the .NET Framework applications when we need to use third party like .NET libraries where Nuget packages which are not available for any .NET Core apps. We still need to use ASP.NET as we don't have capability of WCF service implementation using asp.net core at this point of time. However, the asp.net Core web applications can consume the WCF Services and they should not be a problem in the application development from the front end Windows workflow Foundation related services and WCF Data Services are only available in .NET framework and Microsoft doesn't have any plans to bring this to ASP.NET Core The windows presentation Foundation is still running on the sp.net and there are no plans to put them to the .NET Core. Why should I choose and use ASP.NET Core? 1. Cloud based application development is current trend and using asp.net core along with a blend of cloud is an additional advantage for any developer to learn asp.net Core applications 2. Microsoft is moving towards community based application development rather than their traditional application development which brings the change faster to the asp.net core and gives an advantage over the traditional asp.net applications Why is Microsoft Promoting Core? 1. Developers don’t stick to SQL server development 2. Platform Independence is in demand 3. Flexibility in hosting apps to Amazon/Google/Microsoft clouds 4. Community development brings rapid changes I hope the above points clarify why Microsoft is proceeding towards the direction of ASP.NET Core Features of ASP.NET Core 1. Improved support for cloud development 2. Nuget based support 3. High performance 4. Modular framework 5. Cross platform compatibility 6. Flexibility of being open source 7. Hosting independence 8. Built-in support for dependency injection 9. Support for JSON based configuration 10. Unit testing with xunit.net What Next? In the next session, Lets learn how to create and run a web application using ASP.NET Core
Views: 107950 kudvenkat
Part 1   Can you store different types in an array in c#
 
07:18
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Can you store different types in an array in c#? Yes, if you create an object array. Here is an example. Since all types inherit (directly or indirectly) from object type, we can add any type to the object array, including complex types like Customer, Employee etc. You need to override the ToString() method if you want meaningful output when ToString() method is invoked. class Program { static void Main() { object[] objectArray = new object[3]; objectArray[0] = 101; // integer objectArray[1] = "C#"; // string Customer c = new Customer(); c.ID = 99; c.Name = "Pragim"; objectArray[2] = c; // Customer - Complext Type // loop thru the array and retrieve the items foreach (object obj in objectArray) { Console.WriteLine(obj); } } } class Customer { public int ID { get; set; } public string Name { get; set; } public override string ToString() { return this.Name; } } Another alternative is to use ArrayList class that is present in System.Collections namespace. class Program { static void Main() { System.Collections.ArrayList arrayList = new System.Collections.ArrayList(); arrayList.Add(101); // integer arrayList.Add("C#"); // integer Customer c = new Customer(); c.ID = 99; c.Name = "Pragim"; arrayList.Add(c); // Customer - Complext Type // loop thru the array and retrieve the items foreach (object obj in arrayList) { Console.WriteLine(obj); } } }
Views: 364476 kudvenkat
Instead of insert trigger   Part 45
 
15:05
In this video we will learn using instead of insert trigger to insert a row into a view that is based on multiple tables. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/instead-of-insert-trigger-part-45.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-45-instead-of-insert-trigger.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 154470 kudvenkat
Identity Column in SQL Server - Part 7
 
15:12
In this video we will learn 1. What is Identity column 2. Creating an Identity column 3. Supply explicit values for identity columns using IDENTITY_INSERT 4. Reset identity value using DBCC CHECKIDENT command Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/identity-column-in-sql-server-part-7.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-7-identity-column.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 388396 kudvenkat
Angular dependency injection
 
08:14
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/08/angular-dependency-injection.html Slides http://csharp-video-tutorials.blogspot.com/2017/08/angular-dependency-injection_22.html Angular 2 Tutorial playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular 2 Text articles and slides http://csharp-video-tutorials.blogspot.com/2017/06/angular-2-tutorial-for-beginners_12.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What is Dependency Injection 2. How dependency injection works in angular Let us understand Dependency Injection in Angular with an example. Consider this piece of code in EmployeeListComponent. export class EmployeeListComponent implements OnInit { private _employeeService: EmployeeService; constructor(_employeeService: EmployeeService) { this._employeeService = _employeeService; } ngOnInit() { this._employeeService.getEmployees() .subscribe( employeesData =] this.employees = employeesData, error =] this.statusMessage = 'Error'); } // Rest of the code } 1. We register a service with the angular injector by using the providers property of @Component decorator or @NgModule decorator. 2. When a component in Angular needs a service instance, it does not explicitly create it. Instead it just specifies it has a dependency on a service and needs an instance of it by including the service as a constructor parameter. 3. When an instance of the component is created, the angular injector creates an instance of the service class and provides it to component constructor. 4. So the component which is dependent on a service instance, receives the instance from an external source rather than creating it itself. This is called Dependency Injection. What is Dependency Injection It's a coding pattern in which a class receives its dependencies from an external source rather than creating them itself. So if we relate this definition to our example, EmployeeListComponent has a dependency on EmployeeService. The EmployeeListComponent receives the dependency instance (i.e EmployeeService instance) from the the external source (i.e the angular injector) rather than creating the instance itself. 1. Why should we use Dependency Injection? 2. What benefits it provide? 3. Why can't we explicitly create an instance of the EmployeeService class using the new keyword and use that instance instead in our EmployeeListComponent? We will answer these questions in our next video.
Views: 52242 kudvenkat
Part 8 - C# Tutorial - Arrays in C#.avi
 
09:36
Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/06/part-8-c-tutorial-arrays-in-c.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-8-arrays-in-c.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this part of the c sharp tutorial we will learn 1. Arrays in c# 2. Advantages and dis-advantages of arrays
Views: 321909 kudvenkat
Creating your first aspnet mvc application - Part 3
 
12:30
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/04/creating-your-first-aspnet-mvc.html Slides http://csharp-video-tutorials.blogspot.com/2013/04/creating-your-first-aspnet-mvc.html All ASP .NET MVC Text Articles http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-tutorial-for-beginners.html All ASP .NET MVC Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-slides.html ASP.NET MVC Playlist https://www.youtube.com/playlist?list=PL4cyC4G0M1RQAV0xCaEjfwAeaFaUuHXuf All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss about 1. Creating an asp.net mvc application 2. Understand how mvc request is processed as apposed to webform request Creating an mvc application: 1. Open visual studio 2. Click File - New Project 3. Select "Web" from "Installed Templates" section 4. Select ASP.NET MVC 4 Web Application 5. Set Name="MVCDemo" 6. Click OK 7. Select "Empty" template. Select "Razor" as the ViewEngine. There are 2 built in view engines - Razor and ASPX. Razor is preferred by most mvc developers. We will discuss about Razor view engine in detail in a later video session. 8. At this point you should have an mvc application created. Notice that in the solution explorer, you have several folders - Models, Views, Controllers etc. As the names suggest these folders are going to contain Models, Views, and Controllers. We will discuss about Models, Views, and Controllers in a later video session. Now let's add a controller to our project. 1. Right Click on "Controllers" folder 2. Select Add - Controller 3. Set Controller Name = HomeController 4. Leave rest of the defaults and click "Add" We should have HomeController.cs added to "Controllers" folder. At this point run the application by pressing CTRL+F5. Notice that you get an error. To fix this error, we need to add a view with name, "Index". We will discuss about views in detail in a later video session. Let's fix it another way. The following is the function that is automatically added to HomeController class public ActionResult Index() { return View(); } Change the return type of Index() function from "ActionResult" to "string", and return string "Hello from MVC Application" instead of View(). public string Index() { return "Hello from MVC Application"; } Run the application and notice that, the string is rendered on the screen. When you run the application, by default it is using built-in asp.net development server. Let's use IIS, to run the application instead of the built-in asp.net development server. 1. In the solution explorer, right click on the project and select "Properties" 2. Click on "Web" tab 3. Select "Use Local IIS Web Server" radio button 4. Notice that the Project Url is set to http://localhost/MVCDemo by default 5. Finally click on "Create Virtual Directory" button //configuring iis to run mvc application.png Run the application, and notice that the URL is "http://localhost/MVCDemo/" Now change the URL to "http://localhost/MVCDemo/Home/index" In the URL "Home" is the name of the controller and "Index" is the method within HomeController class. So the improtant point to understand is that the URL is mapped to a controller action method. Where as in web applications, the URL is mapped to a physical file. For example, in a web application, if we have to display the same message. 1. We add a webform and in the Page_load() event include Response.Write("Hello from ASP.NET Web Forms Application"); 2. We then access WebForm1.aspx as shown below http://localhost/WebFormsApplication/WebForm1.aspx 3. The Page load event gets executed and the message string is displayed.
Views: 777413 kudvenkat
Indexes in sql server   Part 35
 
11:14
In this video we will learn about What are indexes Why do we use indexes Advantages of indexes These concepts are applicable to sql server 2000, 2005 and 2008 Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/indexes-in-sql-server-part-35.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-35-indexes.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 385344 kudvenkat
Advanced or intelligent joins in sql server - Part 13
 
12:02
In this video we will learn 1. Advanced or intelligent joins in SQL Server 2. Retrieve only the non matching rows from the left table 3. Retrieve only the non matching rows from the right table 4. Retrieve only the non matching rows from both the left and right table Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/advanced-joins-part-13.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-13-advanced-joins.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 326611 kudvenkat
Closures in JavaScript
 
05:43
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/12/closures-in-javascript.html In this video we will understand closures in JavaScript with an example. What is a closure A closure is an inner function that has access to the outer function’s variables in addition to it's own variables and global variables. The inner function has access not only to the outer function’s variables, but also to the outer function’s parameters. You create a closure by adding a function inside another function. JavaScript Closure Example function addNumbers(firstNumber, secondNumber) { var returnValue = "Result is : "; // This inner function has access to the outer function's variables & parameters function add() { return returnValue + (firstNumber + secondNumber); } return add(); } var result = addNumbers(10, 20); document.write(result); Output : Result is : 30 The following code Returns the inner function expression function addNumbers(firstNumber, secondNumber) { var returnValue = "Result is : "; function add() { return returnValue + (firstNumber + secondNumber); } // We removed the parentheses. This will return the inner function expression without executing it. return add; } // addFunc will contain add() function (inner function) expression. var addFunc = addNumbers(10, 20); // call the addFunc() function and store the return value in result variable var result = addFunc(); document.write(result); Returning and executing the inner function function addNumbers(firstNumber, secondNumber) { var returnValue = "Result is : "; function add() { return returnValue + (firstNumber + secondNumber); } // We removed the parentheses. This will return the inner function add() expression without executing it. return add; } // This returns add() function (inner function) definition and executes it. Notice the additonal parentheses. var result = addNumbers(10, 20)(); document.write(result);
Views: 83197 kudvenkat
Part 7  Models in an mvc application
 
11:15
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/04/part-7-models-in-mvc-application.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-7-models-in-mvc-application.html All ASP .NET MVC Text Articles http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-tutorial-for-beginners.html All ASP .NET MVC Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss models in an mvc application. Let's understand models with an example. We want to retrieve an employee information from tblEmployee table and display it in a view. To encapsulate Employee information, add Employee model class to the Models folder. To do this 1. Right click on "Models" folder - Add - Class 2. Name the class as Employee.cs 3. Click "Add" Copy and paste the following code in Employee.cs class file. public class Employee { public int EmployeeId { get; set; } public string Name { get; set; } public string Gender { get; set; } public string City { get; set; } } Now let's Add EmployeeController class to "Controllers" folder. To do this 1. Right click on "Controllers" folder - Add - Controller 2. Use EmployeeController as the name 3. Click "Add" We want to use "Employee" model class in EmployeeController. So copy and paste the following "using" statement in "EmployeeController.cs" using MVCDemo.Models; By default an Index() Action method is created in EmployeeController. Change the name of the function to Details(). Create an instance of Employee class. For now we will hard code Employee data in this class. In a later video session, we will discuss about retrieving employee information from the database table tblEmployee. At this point EmployeeController should look as shown below. public ActionResult Details() { Employee employee = new Employee() { EmployeeId = 101, Name = "John", Gender = "Male", City = "London" }; return View(); } Now, we need to pass the employee model object that we constructed in EmployeeController to a view, so the view can generate the HTML and send it to the requested client. To do this we first need to add a view. To add a view 1. Right click on Details() action method and select "Add View" from the context menu 2. Set a)View Name = Details b)View Engine = Razor c)Select "Create strongly typed view" check box d)From the "Model class" dropdownlist, select "Employee (MVCDemo.Models)" Note: If Employee class is not visible in the dropdownlist, please build your project and then try adding the view again. 3. Finally click "Add" At this point, Details.cshtml should be added to "Employee" folder. Please note that "Employee" folder is automatically created and added to "Views" folder. Copy and paste the following code from my blog http://csharp-video-tutorials.blogspot.com/2013/04/part-7-models-in-mvc-application.html At this point if you run the project, and if you navigate to the following URL, you get a runtime error stating - Object reference not set to an instance of an object. localhost/MVCDemo/Employee/Details To fix this error, pass "Employee" object to the view. The "return" statement in Details() action method need to be modified as shown below. return View(employee); That's it. Run the application and navigate to localhost/MVCDemo/Employee/Details. We should get the output as expected.
Views: 491311 kudvenkat
Part 21 - C# Tutorial - Inheritance in c#.avi
 
22:04
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/06/part-21-c-tutorial-inheritance-in-c.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-21-inheritance.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this part of the c sharp tutorial we will learn 1. Why Inheritance 2. Advantages of inheritance 3. Inheritance Syntax 4. Inheritance Concepts
Views: 356553 kudvenkat
Different ways to replace NULL in sql server - Part 15
 
11:42
In this video we will learn about the different ways to replace NULL values in sql server. 1. ISNULL() function 2. CASE statement 3. COALESCE() function Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/different-ways-to-replace-null-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-15-different-ways-to-replace-null.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 272169 kudvenkat
IsPostBack in asp.net Part 8
 
17:43
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/10/ispostback-in-aspnet-part-8.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-8-ispostback-property-in-aspnet_13.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will learn about 1. What is IsPostBack property in ASP.NET 2. Real time practical use of IsPostBack in ASP.NET IsPostBack is a Page level property, that can be used to determine whether the page is being loaded in response to a client postback, or if it is being loaded and accessed for the first time. In real time there are many situations where IsPostBack property is used.
Views: 239124 kudvenkat
Asp.net session state   Part 62
 
11:25
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/11/aspnet-session-state-part-62.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-62-aspnet-sessionstate.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Different techniques to send data from one webform to another 1. Cross Page Postback: Discussed in Part 55 and Part 56 2. Context.Handler object - Discussed in Part 58 3. Query strings - Discussed in Part 59 4. Cookies - Discussed in Part 60 and Part 61 5. Session state - Will be discussed in this session The following concepts will be discussed in the subsequent sessions 6. Application state Just like Query strings, Session State variables can also be used to send data from one webform to another. Points to remember about session state variables: 1. Session state variables are stored on the web server by default, and are kept for the life time of a session. 2. The default session state mode is InProc. We will discuss about different session state modes in a later video session. 3. The life time of a session is determined by the time-out value in web.config file. The default is 20 minutes. The time-out value can be adjusted according, to your application requirements. 4. Session state variables are available across all pages, but only for a given single session. Session variables are like single-user global data. 5. It is always a good practice to check, if a session state variable is null before calling any of its methods, such as ToString(). Otherwise, we may run into runtime NullReferenceExceptions. if (Session["Name"] != null) { lblName.Text = Session["Name"].ToString(); } 6. Application performance can be improved by disabling session state, if it's not required. Session state can be turned off at the page or application level. a)To turn of the session state at the page level, set EnableSessionState="False" in the page directive b)To turn of the session state at the application level, set SessionState mode=false in web.config file.
Views: 176135 kudvenkat
Part 3 - C# Tutorial - Built - in types.avi
 
10:36
Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/06/part-3-c-tutorial-built-in-types.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-3-built-in-types-in-c.html All C# Text Articles http://csharp-video-tutorials.blogspot.co.uk/p/free-c-video-tutorial-for-beginners.html All C# Slides http://csharp-video-tutorials.blogspot.com/p/c.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video, we will discuss the different built-in types that are available in c#. Built-in types in C# 1. Boolean type -- Only true or false 2. Integral Types - sbyte, byte, short, ushort, int, uint, long, ulong, char 3. Floating Types -- float and double 4. Decimal Types 5. String Type Escape Sequences in C# http://msdn.microsoft.com/en-us/library/h21280bw.aspx Verbatim Literal is a string with an @ symbol prefix, as in @"Hello". Verbatim literals make escape sequences translate as normal printable characters to enhance readability. Practical Example: Without Verbatim Literal : "C:\\Pragim\\DotNet\\Training\\Csharp" -- Less Readable With Verbatim Literal : @"C:\Pragim\DotNet\Training\Csharp" -- Better Readable
Views: 464404 kudvenkat
Using XSLT transform with XMLDataSourceControl   Part 5
 
06:14
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/02/transform-xml-using-xslt-and-bind-to.html Slides http://csharp-video-tutorials.blogspot.com/2013/10/part-5-transform-xml-using-xslt-and.html All GridView Text Articles http://csharp-video-tutorials.blogspot.com/p/free-asp.html All GridView Slides http://csharp-video-tutorials.blogspot.com/p/blog-page.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In Part 4 of the asp.net gridview tutorial, we discussed about binding an xml file to a gridview control using xmldatasource control. XmlDataSource control did not work as expected, when the xml file, contained child xml nodes. We had to manually rewrite the entire xml file using attributes instead. However, manually rewriting the xml file is laborious and error prone, especially if the file is very large. We can use an XSLT transform file, to dynamically convert the child xml nodes to attributes. Countries xml with child nodes is shown below. Create an asp.net web application. Add a folder with name=Data to the project. Right click on the "Data" folder and add an XML file with name=Countries.xml. Drag "XmlDataSource" control from the toolbox, onto WebForm1.aspx. Click on the smart tag button of the "XmlDataSource" control, and then click on "Configure Data Source". Click on "Browse" button next to "Data file" textbox and select "Countries.xml" from "Data" folder. Now, click on "Browse" button next to "Transform file" textbox and select "CountriesXSLT.xslt" from "Data" folder. Finally click OK. Now, drag and drop a gridview control on WebForm1.aspx. Click on smart tag button on the gridview control, and select "XmlDataSource1" from "Choose Data Source" dropdownlist. Notice that, the gridview control displays xml data as expected. If you want to display the same xml data in a gridview control without using xslt transform, then load the xml data into a dataset and then bind it to the gridview control. DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/Data/Countries.xml")); GridView1.DataSource = ds; GridView1.DataBind();
Views: 37205 kudvenkat
Part 63   Partial methods in c#
 
14:52
Tags no defining declaration found for implementing declaration c# partial abstract method .net partial class override method partial class virtual method partial methods must have empty bodies a partial method cannot have access modifiers c# partial method multiple implementations Our Blog http://csharp-video-tutorials.blogspot.com https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd 1. A partial class or a struct can contain partial methods. 2. A partial method is created using the partial keyword. 3. A partial method declaration consists of two parts. i) The definition (only the method signature) ii) The implementation. These may be in separate parts of a partial class, or in the same part. 4. The implementation for a partial method is optional. If we don't provide the implementation, the compiler removes the signature and all calls to the method. 5. Partial methods are private by default, and it is a compile time error to include any access modifiers, including private. 6. It is a compile time error, to include declaration and implementation at the same time for a partial method. 7. A partial method return type must be void. Including any other return type is a compile time error. 8. Signature of the partial method declaration, must match with the signature of the implementation. 9. A partial method must be declared within a partial class or partial struct. A non partial class or struct cannot include partial methods. 10. A partial method can be implemented only once. Trying to implement a partial method more than once, raises a compile time error
Views: 78354 kudvenkat
Over clause in SQL Server
 
09:13
over partition by in sql server 2008 sql server over clause partition partition by clause in sql server 2008 over partition by clause in sql In this video we will discuss the power and use of Over clause in SQL Server. The OVER clause combined with PARTITION BY is used to break up data into partitions. Syntax : function (...) OVER (PARTITION BY col1, Col2, ...) The specified function operates for each partition. For example : COUNT(Gender) OVER (PARTITION BY Gender) will partition the data by GENDER i.e there will 2 partitions (Male and Female) and then the COUNT() function is applied over each partition. Any of the following functions can be used. Please note this is not the complete list. COUNT(), AVG(), SUM(), MIN(), MAX(), ROW_NUMBER(), RANK(), DENSE_RANK() etc. Example : SQl Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go Write a query to retrieve total count of employees by Gender. Also in the result we want Average, Minimum and Maximum salary by Gender. This can be very easily achieved using a simple GROUP BY query as show below. SELECT Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender What if we want non-aggregated values (like employee Name and Salary) in result set along with aggregated values You cannot include non-aggregated columns in the GROUP BY query. SELECT Name, Salary, Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender The above query will result in the following error : Column 'Employees.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause One way to achieve this is by including the aggregations in a subquery and then JOINING it with the main query as shown in the example below. Look at the amount of T-SQL code we have to write. SELECT Name, Salary, Employees.Gender, Genders.GenderTotals, Genders.AvgSal, Genders.MinSal, Genders.MaxSal FROM Employees INNER JOIN (SELECT Gender, COUNT(*) AS GenderTotals, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender) AS Genders ON Genders.Gender = Employees.Gender Better way of doing this is by using the OVER clause combined with PARTITION BY SELECT Name, Salary, Gender, COUNT(Gender) OVER(PARTITION BY Gender) AS GenderTotals, AVG(Salary) OVER(PARTITION BY Gender) AS AvgSal, MIN(Salary) OVER(PARTITION BY Gender) AS MinSal, MAX(Salary) OVER(PARTITION BY Gender) AS MaxSal FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server_29.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 87213 kudvenkat
Part 1   Introduction to WCF
 
10:09
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/11/part-1-introduction-to-wcf.html Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video we will discuss What is WCF Why should we use WCF What is WCF? WCF stands for Windows Communication Foundation and is part of .NET 3.0. WCF is Microsoft platform for building distributed and interoperable applications. What is a distributed application? In simple terms a distributed application, is an application where parts of it run on 2 or more computers. Distributed applications are also called as connected systems or applications. Examples: A web application running on one machine and a web service that this application is consuming is running on another machine. An enterprise web application may have the following tiers, and each tier may be running on a different machine 1. Presentation tier 2. Business tier 3. Data Access tier Why build distributed applications? There are several reasons for this 1. An enterprise application may need to use the services provided by other enterprises. For example an ecommerce application may be using paypal service for payments. 2. For better scalability. An enterprise web application may have Presentation tier, Business tier, and Data Access tiert, and each tier may be running on a different machine. What is an interoperable application? An application that can communicate with any other application that is built on any platform and using any programming language is called as an interoperable application. Web services are interoperable, where as .NET remoting services are not. Web services can communicate with any application built on any platform, where as a .NET remoting service can be consumed only by a .net application. What technology choices did we have before WCF to build distributed applications? Enterprise Services Dot Net Remoting Web Services Why should we use WCF? Let's take this scenario We have 2 clients and we need to implement a service a for them. 1. The first client is using a Java application to interact with our service, so for interoperability this client wants messages to be in XML format and the protocol to be HTTP. 2. The second client uses .NET, so for better performance this client wants messages formmated in binary over TCP protocol. Without WCF 1. To satisfy the first client requirement we end up implementing an ASMX web service, and 2. To satisfy the second client requirement we end up implementing a remoting service These are 2 different technologies, and have complete different programming models. So the developers have to learn different technologies. So to unify and bring all these technologies under one roof Microsoft has come up with a single programming model that is called as WCF - Windows Communication Foundation. With WCF, You implement one service and we can configure as many end points as want to support all the client needs. To support the above 2 client requirements, we would configure 2 end points. In the endpoint configuration we can specify the protocols and message formats that we want to use. In Part 2, we will discuss implementing 1. A web service to exchange messages in XML format using HTTP protocol for interoperability. 2. A remoting service to exchange messages in binary format using TCP protocol for performance. Along the way, we will get a feel of how different these technologies are. In Part 3, we will dicuss implementing a single WCF Service and configuring different end points to support different transport protocols and message formats.
Views: 759969 kudvenkat
Installing Angular CLI
 
05:34
angular cli setup angular cli install windows angular cli how to install angular cli installation steps npm angular cli error In this video we will discuss how to install Angular CLI The prerequisites for installing Angular CLI : To install Angular CLI you should have installed Node 6.9.0 or higher, and NPM 3 or higher To check the versions that you have on your machine type the following commands in a command window. node -v npm -v You can get the latest version of Node and NPM from the following website. Click on the correct download link depending on the Operating System you have. https://nodejs.org/en/download/ Once you have Node and NPM installed. Run Command Prompt as an administrator and execute the following command. Flag -g installs Angular CLI globally on your machine. npm install -g @angular/cli You can also use i as shortcut for install. So the above command can also be rewritten as shown below npm i -g @angular/cli If you see a tree structure, you have Angular CLI installed successfully. To verify the version of Angular CLI installed, execute the following command ng -v At the time of this recording, I have Angular CLI version 1.4.2 installed on my machine. If you run into any problems installing Angular CLI, follow these steps and hopefully Angular CLI will be installed successfully. Step 1 : Delete "npm" folder from the following path C:\Users\Your_UserName\AppData\Roaming Please note : If you cannot find "AppData" folder, make sure in your windows operating system, you have "Show hidden files, folders, and drives" option is turned on. "AppData" is a hidden folder. Step 2 : Once you have the "npm" folder deleted, uninstall node.js. On a windows machine you can uninstall node.js from Control Panel\All Control Panel Items\Programs and Features. Right click on "Node.js" and select "uninstall" from the context menu. Step 3 : Reinstall Node.js by downloading the appropriate installer for your operating system from the following link. https://nodejs.org/en/download/ Step 4 : Run Command Prompt as an Administrator and try to install Angular CLI again using the following command. Hopefully this time it installs successfully. If not, please leave the problem you are facing as a comment on this video and we will try to help as soon as we can. Also, if you had a problem and you solved it yourself, please let us know what the problem is and how you solved it by leaving a comment, so it could help others with a similar problem. After all, it's all about sharing and learning from each other. npm install -g @angular/cli In our next video, we will discuss creating an Angular project from scratch using Angular CLI. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/09/installing-angular-cli.html Slides http://csharp-video-tutorials.blogspot.com/2017/09/installing-angular-cli_26.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 71442 kudvenkat