ΝKANTZELIS.GR-ΣΕΜΙΝΑΡΙΑ ΠΛΗΡΟΦΟΡΙΚΗΣ-ΣΧΕΔΙΑΣΜΟΣ WEB SITES

Using WCF Data Services in WPF applications
In this post I will provide you with hands-on examples on how to retrieve data from a WCF Data Service and bind the data to WPF data bindable controls that reside inside a WPF window.The client application in this case will be a WPF application again.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1694&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using WCF services in WPF applications
In this post I will provide you with hands-on examples on how to retrieve data from a WCF service and bind the data to a WPF data bindable control that resides inside a WPF window. This is not going to be a post that will look into WCF Services in great detail. In the near future I will be writing posts on WCF.In a nutshell WCF provides a unified programming model for building service oriented applications. <img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1681&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Windows forms and WPF Interoperability
In this post I will not be investigating at what some people call the "Windows single technology applications" which basically means that we build WinForms apps for the windows operating systems using only Windows Forms controls or alternatively build a windows WPF application using only the built-in or 3rd party WPF controls.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1658&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using WCF Services in Silverlight 4.0 applications
In this post I would like to present in detail how we can consume WCF services from a Silverlight 4 application.I strongly suggest that you have a look in this post of mine where I talk about using web services .asmx in our silverlight applications.I do advise against using .asmx web services.WCF is strongly recommended by Microsoft and is the distributed technology that MS supports and will continue to support.In many cases you will see a difference in performance.WCF is significantly faster.Have a look in this very useful article in MSDN where it compares performance of WCF distributed systems with other existing distributed technologies. <img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1636&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using ASP.Net web services in Silverlight 4 applications
In this post I would like to present in detail how we can consume .asmx web services from a Silverlight 4 application. Silverlight supports and "recognises" web services in a similar way that ASP.Net applications can "talk" to web services.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1623&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using Common Table Expressions in SQL Server
In this post I would like to talk about Common Table Expressions or CTE . I know there are samples of how to use CTE in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.CTEs were introduced in SQL Server 2005. You can think of them as temporary views.They last only for the duration of the execution of the query<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1612&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using large data types in SQL Server
In this post I would like to talk about the large value data types and how we can use them to store large amounts of data. We can store up to 2^31 bytes of character, binary, and Unicode data. I know there are samples of how to use large value data types in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1607&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using HierarchyID system data type in SQL Server 2008
In this post I would like to talk about the new system data type HierarchyID which was introduced in SQL Server 2008. I know there are samples of how to use HierarchyID in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.It is used for storing hierarchical data.The most common scenario is that we want to store the data (relations and positions) of an organisational chart.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1594&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Looking into exceptions in SQL Server
In this post I would like to talk about exceptions in SQL Server. Well, let me make a general statement. All humans make mistakes.That includes application developers,database developers e.t.c. So all developers must be familiar with the various exception mechanisms and tools that each language has. Everyone who has worked with Visual Basic has used the "ON ERROR GOTO" statement and all .NET languages have exception handling techniques e.g Try Catch statements-blocks.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1579&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

A thorough look into transactions in SQL Server
In this post I would like to look into transactions in SQL Server. A transaction is a group of tasks that perform as a single unit of work.In database terms all parts of the transaction must be saved in tha database or must be abandoned.It is a great feature in the relational world since through transactions we make sure the database is never in an inconsistent state.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1548&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Looking into Resource Governor in SQL Server 2008
In this post I would like to talk about a new feature in SQL Server 2008, Resource Governor and what this new feature offers us in terms of performance and good use of resources.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1539&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Looking into Transparent Data Encryption
In this post I would like to look into Transparent Data Encryption (TDE) works in SQL Server 2008.I would like to stress that this is an SQL Server 2008/R2 Entreprise/Developer editions feature only.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1528&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Looking into Security in SQL Server
In this post I would like to talk about Security in SQL Server. This is a very big topic and you should embrace yourselves for a very long post. I know there are samples of how to use secure data in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. Many people have found useful my style of posting. They feel they can follow the steps and master the technology. At the beginning I will give a short introduction about the various security threats that our systems face and then look into aspects of Security in SQL Server .Then I will provide many examples on how to secure data in SQL Server.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1477&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Performing Auditing in SQL Server environments
In this post I would like to talk about SQL Server Audit. This new way of auditing was introduced with SQL Server 2008.This feature is supported in SQL Server 2008 Enterprise edition.Auditing is simply the process of monitoring and tracking changes to the SQL Server system.All the DBAs need to implement auditing at some point to satisfy business requirements. There is something called "SQL Server Extended Events" engine.The extended events engine allows any process to define and raise events and consumers to receive events.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1416&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Data compression features in SQL Server 2008
In this post I would like to talk about data compression/backup compression features available to us in SQL Server 2008 and R2 editions. I will talk about Data Compression and Backup Compression. Data Compression is only available in Enterprise (SQL Server 2008 & SQL Server 2008 R2) edition or higher, not in the standard edition for SQL Server 2008/ R2. Backup compression was introduced in SQL Server 2008 Enterprise.Backup compression is available in the SQL Server 2008 Standard edition R2.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1422&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Looking into Triggers in SQL Server
In this post I would like to show a few examples of how to use triggers in SQL Server. I would like to talk about the uses of triggers, the type of triggers and some misconceptions about the triggers.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1403&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using built-in functions in SQL Server
In this post I would like to show a few examples of built in T-SQL functions and global functions. I teach T-SQL to people from all walks of life and many of them have asked me to write a simple post with examples of the most commonly used T-SQL functions and global functions.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1385&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Looking into Views in SQL Server
In this post I would like to look into Views in SQL Server. As always I will demonstrate all the various concepts with hands on examples. I know that all these concepts are well documented elsewhere. I will try to show all these with step by step instructions and many screenshots. Many people have found useful my style of posting. They feel they can follow the steps and master the technology. Views have many advantages and when used correctly can benefit our applications.Please note that I will use T-SQL to create/alter/drop views. I will not use SSMS wizzards and graphic tools. Views are virtual tables.What is stored in SQL Server as a distinct object is the definition of the view(SELECT statement) and nothing else. Some people refer to views as a stored query producing a virtual table.The data that is accessible through the view is not stored in the database.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1342&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using Type Converters in WPF
In this post I would like to talk/show you how to implement type conversions in WPF. We must talk a little bit for Binding in WPF before we move on to explain why we use type converters and show a hands on example. So what is Binding in WPF? In WPF we can bind any property of any object to any other property of some other object.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1320&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

An introduction to MVVM pattern using WPF
In this post I will show you how to build a simple WPF Application using the popular and well know MVVM pattern. I assume that you know the basics of XAML,WPF. I am going to use a hands-one example using Visual Studio and 2010.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1278&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Create a master details application with WPF and the Entity framework
I have been studying WPF for some time now and I am impressed with its extensive API and the incredible-stunning applications that one can build. In this post I would like to show you how to create a WPF application that will fetch data from a database<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1246&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

How to change the master page depending on the client’s browser
In one of my seminars on ASP.Net, I was asked a question from a student regarding master pages and the various browser appications. He basically asked if it was possible to have a different master page depending on the client’s browser. My initial answer was to find the browser’s version programmatically and according to this [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1234&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

How to use cookies in ASP.Net applications
In this post we are going to see a step by step example on how to read,write,delete cookies in asp.net websites. Cookies are small pieces of text that you can associate with a website which are transfered down to the user’s computer when the user visits the website. You can use any of the versions [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1231&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Caching an ASP.Net page
The issue of “caching” keeps coming up in my asp.net seminars so I though it would be a good idea to write a post. I know it is a well documented feature and widely used but I really believe most people will be able to use this rather simple example and understand the concepts behind [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1228&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Caching an asp.net page depending on the user’s browser language
This is my second post regarding caching in asp.net applications. A friend of mine asked me if he can control caching of an asp.net page depending on the user’s language browser. Let’s see how we can accomplish that with a step by step example. You can use any of the versions of Visual studio (VS [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1222&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Linq to Objects in ASP.Net
In this post I would like to talk about Linq to Objects in an ASP.Net application. In all my classes people seem to have the following answer to this question, “What kind of data can we query with LINQ?“ Most people say “Well, we can query an SQL server database” . I am not very [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1219&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Cross-Page postbacks in ASP.Net
In this post I would like to talk about cross-page postbacks in ASP.Net. When you have a .aspx page with a button on it and you click that button the page will be posted back to the original page.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1215&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Send email in ASP.Net applications
I know that this topic is also well documented in the web. But I decided to have a go, after so many people ask me the same question "How can I send emails from asp.net web applications?"<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1211&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Session State in ASP.Net
In this post I will talk about ASP.Net State management. I will provide a hands on example with VS and VB.Net. Before I go on with my example I would like to give a short introduction first. Web applications are built on Hypertext Transfer Protocol (HTTP). HTTP is a stateless protocol and each request to the server from the client is understood as an independent request.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1208&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Populate web server controls in ASP.Net applications from a web service
In this post I would like to present you with a very simple example on how to create a simple web service that access data from a database. Then we will create a consuming application that will consume the web service. I will use VS 2010 Ultimate edition and C# as the development language.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1205&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Using profile in ASP.Net applications
With Profile we store user specific data that is accessible anywhere in our ASP.Net application.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1201&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Tracing at application and page level in ASP.NET applications
When we debug our applications we need to have as much information as possible at our disposal. There are a lot of techniques and ways to achieve that. One way to get lots of debugging information is to use Tracing. We can enable Tracing at the Page Level and Application Level. We can view the viewstate information and the events chain when a page is executing, among other things.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1181&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

JQuery and ASP.Net – How to access all textboxes using JQuery
I am going to start a series of posts on ASP.Net and JQuery that will explain a lot of common tasks that can be accomplished using this fantastic open source Javascript library.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1175&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Change the master page depending on the client’s browser
In one of my seminars on ASP.Net, I was asked a question from a student regarding master pages and the various browser appications. He basically asked if it was possible to have a different master page depending on the client's browser.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1164&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Tableless menu control in ASP.Net 4.0
One of the issues I really like to read and learn is client side technologies. I am an ASP.Net guy at heart but I find CSS particular useful and I have been blogging about CSS in my other blog. Have a look here if you want to have a look at some interesting posts on [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1153&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Hidden Div elements in ASP.Net 4.0
This is a very short post for a new feature that ships with VS 2010 and ASP.Net 4.0. It is about the hidden fields in ASP.Net 4.0. We do know that ASP.Net is using hidden fields as a state control mechanism. It is used to preserve viewstate and control state. They are usually included in [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1148&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

301 permanent redirects and ASP.Net 4.0
We can permanently redirect traffic to the new pages without losing page rankings by using the 301 permanent redirect. RedirectPermanent help us to achieve that.<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1142&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

ASP.Net 4.0 and session state compression
The important setting that was added in ASP.Net 4.0 is the last setting, compressionEnabled="true".<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1139&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

Maintaining scroll position in ASP.Net applications
How to maintain the scroll position-location when a postback occurs in an ASP.NET application<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1132&subd=dotnetstories&ref=&feed=1" width="1" height="1" />

How to deploy Asp.Net applications in retail mode
I have this friend of mine who is responsible of a team of asp.net developers that develop applications for people from all walks of life. One of his main concerns were that he had to check the deployment stage of every application very carefully and constantly had to correct common mistakes in the web.config file. [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=dotnetstories.wordpress.com&blog=1661705&post=1129&subd=dotnetstories&ref=&feed=1" width="1" height="1" />