archive-gr.com » GR » D » DOTNETZONE.GR

Total: 987

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Dot Net Rules : Οκτώβριος 2012 - Δημοσιεύσεις
    not and could not be a detailed tutorial on HTML 5 There are other great resources for that Navigate to the excellent interactive tutorials of W3School Another excellent resource is HTML 5 Doctor Two very nice sites that show you what features and specifications are implemented by various browsers and their versions are http caniuse com and http html5test com At this times Chrome seems to support most of HTML 5 specifications Another excellent way to find out if the browser supports HTML 5 and CSS 3 features is to use the Javascript lightweight library Modernizr In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2012 Express edition You can download it here Let me move on to the actual example This is the sample HTML 5 page DOCTYPE html html lang en head title Liverpool Legends title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css script type text javascript src jquery 1 8 2 min js script script type text javascript src tabs js script head body header h1 Liverpool Legends h1 header section id tabs ul li a href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 9143136 first tab Defenders a li li a href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 9143136 second tab Midfielders a li li a href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 9143136 third tab Strikers a li ul div id first tab h3 Liverpool Defenders h3 p The best defenders that played for Liverpool are Jamie Carragher Sami Hyypia Ron Yeats and Alan Hansen p div div id second tab h3 Liverpool Midfielders h3 p The best midfielders that played for Liverpool are Kenny Dalglish John Barnes Ian Callaghan Steven Gerrard and Jan Molby p div div id third tab h3 Liverpool Strikers h3 p The best strikers that played for Liverpool are Ian Rush Roger Hunt Robbie Fowler and Fernando Torres br p div div section footer p All Rights Reserved p footer body html This is very simple HTML markup I have styled this markup using CSS The contents of the style css file follow margin 0 padding 0 header font family Tahoma font size 1 3em color 505050 text align center tabs font size 0 9em margin 20px 0 tabs ul float left background 777 width 260px padding top 24px tabs li margin left 8px list style none html tabs li display inline tabs li tabs li a float left tabs ul li active border top 2px red solid background 15ADFF tabs ul li active a color 333333 tabs div background 15ADFF clear both padding 15px min height 200px tabs div h3 margin bottom 12px tabs div p line height 26px tabs ul li a text decoration none padding 8px color 0b2f20 font weight bold footer background color 999 width 100 text align center font size 1 1em color 002233 There are some CSS rules that style the various elements in the HTML 5 file These are straight forward rules The JQuery code lives inside the tabs js file document ready function tabs div hide tabs div first show tabs ul li first addClass active tabs ul li a click function tabs ul li removeClass active this parent addClass active var currentTab this attr href tabs div hide currentTab show return false I am using some of the most commonly used JQuery functions like hide show addclass removeClass I hide and show the tabs when the tab becomes the active tab When I view my page I get the following result Hope it helps Posted Παρασκευή 19 Οκτωβρίου 2012 2 26 πμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net jquery html5 tabs Scrolling an HTML 5 page using JQuery In this post I will show you how to use JQuery to scroll through an HTML 5 page I had to help a friend of mine to implement this functionality and I thought it would be a good idea to write a post I will not use any JQuery scrollbar plugin I will just use the very popular JQuery Library Please download the library minified version from http jquery com download Please find here all my posts regarding JQuery Also have a look at my posts regarding HTML 5 In order to be absolutely clear this is not and could not be a detailed tutorial on HTML 5 There are other great resources for that Navigate to the excellent interactive tutorials of W3School Another excellent resource is HTML 5 Doctor Two very nice sites that show you what features and specifications are implemented by various browsers and their versions are http caniuse com and http html5test com At this times Chrome seems to support most of HTML 5 specifications Another excellent way to find out if the browser supports HTML 5 and CSS 3 features is to use the Javascript lightweight library Modernizr In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2012 Express edition You can download it here Let me move on to the actual example This is the sample HTML 5 page DOCTYPE html html lang en head title Liverpool Legends title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css script type text javascript src jquery 1 8 2 min js script script type text javascript src scroll js script head body header h1 Liverpool Legends h1 header div id main table caption Liverpool Players caption thead tr th Name th th Photo th th Position th th Age th th Scroll th tr thead tfoot class footnote tr td colspan 4 We will add more photos soon td tr tfoot tbody tr class maintop td Alan Hansen td td figure img src images Alan hansen large jpg alt Alan Hansen figcaption The best Liverpool Defender a href http en wikipedia org wiki Alan Hansen Alan Hansen a figcaption figure td td Defender td td 57 td td class top Middle td tr tr td Graeme Souness td td figure img src images graeme souness large jpg alt Graeme Souness figcaption Souness was the captain of the successful Liverpool team of the early 1980s a href http en wikipedia org wiki Graeme Souness Graeme Souness a figcaption figure td td MidFielder td td 59 td tr tr td Ian Rush td td figure img src images ian rush large jpg alt Ian Rush figcaption The deadliest Liverpool Striker a href http it wikipedia org wiki Ian Rush Ian Rush a figcaption figure td td Striker td td 51 td tr tr class mainmiddle td John Barnes td td figure img src images john barnes large jpg alt John Barnes figcaption The best Liverpool Defender a href http en wikipedia org wiki John Barnes footballer John Barnes a figcaption figure td td MidFielder td td 49 td td class middle Bottom td tr tr td Kenny Dalglish td td figure img src images kenny dalglish large jpg alt Kenny Dalglish figcaption King Kenny a href http en wikipedia org wiki Kenny Dalglish Kenny Dalglish a figcaption figure td td Midfielder td td 61 td tr tr td Michael Owen td td figure img src images michael owen large jpg alt Michael Owen figcaption Michael was Liverpool s top goal scorer from 1997 2004 a href http www michaelowen com Michael Owen a figcaption figure td td Striker td td 33 td tr tr td Robbie Fowler td td figure img src images robbie fowler large jpg alt Robbie Fowler figcaption Fowler scored 183 goals in total for Liverpool a href http en wikipedia org wiki Robbie Fowler Robbie Fowler a figcaption figure td td Striker td td 38 td tr tr class mainbottom td Steven Gerrard td td figure img src images steven gerrard large jpg alt Steven Gerrard figcaption Liverpool s captain a href http en wikipedia org wiki Steven Gerrard Steven Gerrard a figcaption figure td td Midfielder td td 32 td td class bottom Top td tr tbody table div footer p All Rights Reserved p footer body html The markup is very easy to follow and understand You do not have to type all the code simply copy and paste it For those that you are not familiar with HTML 5 please take a closer look at the new tags elements introduced with HTML 5 When I view the HTML 5 page with Firefox I see the following result I have also an external stylesheet style css body background color efefef h1 font size 2 3em table border collapse collapse font family Futura Arial sans serif caption font size 1 2em margin 1em auto th td padding 65em th thead background 000 color fff border 1px solid 000 tr nth child odd background ccc tr nth child even background 404040 td border right 1px solid 777 table border 1px solid 777 top middle bottom cursor pointer font size 22px font weight bold text align center footnote text align center font family Tahoma color EB7515 a color 22577a text decoration none a hover color 125949 text decoration none footer background color 505050 width 1150px These are just simple CSS Rules that style the various HTML 5 tags classes The jQuery code that makes it all possible resides inside the scroll js file Make sure you type everything correctly document ready function top click function html body animate scrollTop mainmiddle offset top 4000 middle click function html body animate scrollTop mainbottom offset top 4000 bottom click function html body animate scrollTop maintop offset top 4000 Let me explain what I am doing here When I click on the Middle word top click function this relates to the top class that is clicked Then we declare the elements that we want to participate in the scrolling In this case is html body html body animate These elements will be part of the vertical scrolling In the next line of code we simply move navigate to the element class mainmiddle that is attached to a tr element scrollTop mainmiddle offset top Make sure you type all the code correctly and try it for yourself I have tested this solution will all 4 5 major browsers Hope it helps Posted Πέμπτη 18 Οκτωβρίου 2012 10 52 πμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net jquery html5 scroll Looking into the SQL Server Log In this post I will be looking into the SQL Server Log and how we can use it so we can identify and troubleshoot potential problems Recently I asked someone that gave me a call regarding an SQL Server issue to have a look at the SQL Server Log and he Διαβάστε περισσότερα Posted Τετάρτη 17 Οκτωβρίου 2012 9 38 μμ από το μέλος nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία Sql Server Disabling the right click sub menu using JQuery Recently I needed to disable the right click contextual menu in an HTML page for a very simple HTML application I was creating for a friend This is going to be a short post where I will demonstrate how to disable the right click contextual menu I will use the very popular JQuery Library Please download the library minified version from http jquery com download Please find here all my posts regarding JQuery In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2012 Express edition You can download it here I am going to create a very simple HTML 5 page with some text and an image The HTML markup for the page follows DOCTYPE html html lang en head title HTML 5 CSS3 and JQuery title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css script type text javascript src jquery 1 8 2 min js script script type text javascript function document bind contextmenu function return false jQuery script head body div id header h1 Learn cutting edge technologies h1 h2 HTML 5 JQuery CSS3 h2 div figure img src html5 png alt HTML 5 figure div id main h2 HTML 5 h2 article p HTML5 is the latest version of HTML and XHTML The HTML standard defines a single language that can be written in HTML and XML It attempts to solve issues found in previous iterations of HTML and addresses the needs of Web Applications an area previously not adequately covered by HTML p article div body html This is the JQuery code I use function document bind contextmenu function return false jQuery I simply disable cancel the contextmenu event When I load the simple page on the browser and I right click the context menu does not appear Hope it helps Posted Κυριακή 14 Οκτωβρίου 2012 9 38 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net jquery html5 Resizing text in an HTML 5 page using JQuery This is going to be the ninth post in a series of posts regarding HTML 5 You can find the other posts here here here here here here here and here In this post I will demonstrate how to implement a very common feature found in websites today enabling the visitor to increase or decrease the font size of a page You can use the JQuery code I will write in this post for HTML pages which do not follow the HTML 5 standard As I said earlier we need to write JavaScript to implement this functionality I will use the very popular JQuery Library Please download the library minified version from http jquery com download In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2012 Express edition You can download it here The HTML markup for the page follows DOCTYPE html html lang en head title HTML 5 CSS3 and JQuery title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css script type text javascript src jquery 1 8 2 min js script script type text javascript function a click function var getfont p css font size var mynum parseFloat getfont 10 var newmwasure getfont slice 2 p css font size mynum 1 2 newmwasure if this id increase p css font size mynum 1 4 newmwasure script head body div id header h1 Learn cutting edge technologies h1 h2 HTML 5 JQuery CSS3 h2 div div id resize a href id increase Increase Font a a href id decrease Decrease Font a div div id main h2 HTML 5 h2 article p HTML5 is the latest version of HTML and XHTML The HTML standard defines a single language that can be written in HTML and XML It attempts to solve issues found in previous iterations of HTML and addresses the needs of Web Applications an area previously not adequately covered by HTML p article div body html There is nothing difficult or fancy in the HTML markup above I have a link to the external JQuery library and the JQuery code is included inside the html page I have two links on this page that will increase decrease the font size of the contents enclosed inside the p p tags Let me explain what the JQuery code does When the user clicks on the link I store in a variable the current font size of the p element that I get back from the CSS function var getfont p css font size So now we have the original value That will return a value like 16px 1 2em Then I need to get the unit of measurement px em I use the slice function var newmwasure getfont slice 2 Then I want to get only the numeric part of the returning value I do that using the parseFloat function Have a look at the parseFloat function Finally with this bit of code I choose a ratio I am devising a very simple algorithm for increasing and decreasing and apply it to the p element I still use the CSS function You can get but also set the font size for a particular element with the CSS function So I check for the id increase and if this matches I will increase the font size of the p element If it does not match we will decrease the font size p css font size mynum 1 2 newmwasure if this id increase p css font size mynum 1 4 newmwasure The code for the css file style css follows body background color eaeaea p font size 0 8em font family Tahoma resize width 200px background color dadada resize a text decoration none The above CSS rules are very easy to understand Now I save all my work I view my page on the browser for the first time Have a look at the picture below Now I increase the font size by clicking the respective link Have a look at the picture below Finally I decrease the font size by clicking on the respective link Have a look at the picture below Once more we see that the power and simplicity of JQuery library enables us to write less code but accomplish a lot at the same time Hope it helps Posted Σάββατο 6 Οκτωβρίου 2012 8 16 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/10.aspx (2015-07-15)
    Open archived version from archive


  • Dot Net Rules : Σεπτέμβριος 2012 - Δημοσιεύσεις
    using System Data Entity in the beginning of the class file I would like to talk at this point a little bit about Code First Data Annotations With Data Annotations we can configure our domain entity classes so that they can take best advantage of the EF We will decorate our entity classes with declarative attributes Let me give you an insight on how EF Code First works EF Code First at run time looks at the entity domain classes and infers from them the in memory data that it needs to interpret the queries and interact with the database For example it assumes that any property named ID represents the key property of the class Please have a look at this post of mine to find out more about Data Annotations 9 Let s create a new class and add it in the DAL folder I will call it PosterInsert cs In this class I will have the code to initialise the database and insert values The code for this class follows public class PosterInsert DropCreateDatabaseIfModelChanges PosterContext protected override void Seed PosterContext context var pcategory new List PosterCategory new PosterCategory PosterCategoryName Midfielders CategoryDescription Posters of active and past Liverpool Midfielders Posters new List Poster new Poster PosterName King Kenny PosterDescription King Kenny lifting the European Cup PosterImgpath Images posters kenny dalglish jpg PosterPrice 18 95 new Poster PosterName John Barnes PosterDescription El mago a true genius in the midfield PosterImgpath Images posters john barnes jpg PosterPrice 16 95 new Poster PosterName Steven Gerrard PosterDescription The Captain PosterImgpath Images posters steven gerrard jpg PosterPrice 28 95 new PosterCategory PosterCategoryName Defenders CategoryDescription Posters of active and past Liverpool Defenders Posters new List Poster new Poster PosterName Jamie Carragher PosterDescription Th greatest defender in the last ten years PosterImgpath Images posters jamie carragher jpg PosterPrice 21 95 new Poster PosterName Alan Hansen PosterDescription The legendary defender Alan Hansen PosterImgpath Images posters alan hansen jpg PosterPrice 13 95 new Poster PosterName Martin Skrtel PosterDescription The most promising defender playing right now PosterImgpath Images posters martin skrtel jpg PosterPrice 19 95 new PosterCategory PosterCategoryName Strikers CategoryDescription Posters of active and past Liverpool Strikers Posters new List Poster new Poster PosterName Ian Rush PosterDescription The greatest striker to wear a Liverpool shirt PosterImgpath Images posters ian rush jpg PosterPrice 18 45 new Poster PosterName Robbie Fowler PosterDescription Robbie a goal scoring machine PosterImgpath Images posters robbie fowler jpg PosterPrice 18 45 new Poster PosterName Michael Owen PosterDescription The youngest deadliest striker Anfield has even known PosterImgpath Images posters michael owen jpg PosterPrice 16 95 pcategory ForEach post context PosterCategories Add post base Seed context In this class I inherit from the DropCreateDatabaseIfModelChanges PosterContext class and I will override the default behaviour of that class with my class I will ovverride the Seed method with some data Then I create 3 instances of the PosterCategory entity and 9 entities of the Poster entity Then through a simple lambda expression I add the data to the database using this last line of code base Seed context 10 Now we need to make one more change in the Global asax cs In the Application Start event handler routine runs when the application starts we will add this code Database SetInitializer new PosterInsert 11 I have also created a Posters folder inside the Images folder and placed in it the 9 images 12 Build and run your application Everything should compile now Have a look at the picture below to see the structure of the web application so far 13 Now we will create a test page to see if the database is created and populated with values Add a web form page to the application Name it PostersTest Add a gridview web server control on the page Make the page as the Start Page In the Page Load event handling routine type PosterContext ctx new PosterContext var query from postcat in ctx PosterCategories select postcat PosterCategoryName GridView1 DataSource query ToList GridView1 DataBind Build and run your application Have a look below to see the result I have got It seems to work The database is created and populated through the magic of EF Code First Have a look at the web config for the connection string In the Solution Explorer look into the App Data folder If you open the Server Explorer and open the connection to the database in my case PostersOnLine DAL PosterContext mdf I am using LocalDB which is anew version of SQL Express For more information have a look here Have a look at the picture below These are the results when I query the tables Please make sure you follow all the steps I will post soon part 3 Hope it helps Posted Τρίτη 25 Σεπτεμβρίου 2012 4 14 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net Entity framework data access layer Code First LocalDB Visual Studio 2012 EF 5 0 Building an ASP Net 4 5 Web forms application part 1 I am going to start a new series of posts on how to build an application using ASP Net 4 5 Web forms A few days back I have been asked to present a number of presentations on ASP Net 4 5 Ι will demonstrate how to create a website that sells posters on line In this web forms application I will design and implement the main functionality that is needed in order to have an operational e shop I will also use this series of posts to highlight the various features in ASP Net and most particularly the new features available in ASP Net 4 5 This is going to be part 1 of the application where I will explain what I am going to do In the final post on this series of posts I will demonstrate on how to deploy the web site to Windows Azure I will use Visual Studio 2012 Ultimate edition but you can use the Visual Studio Express 2012 for Web You can download it here The Net framework will be installed automatically In case you have trouble installing Visual Studio please have a look at this link You can download everything you will need for this project if you use the Web Platform Installer You must be administrator in your machine to run the Web Platform Installer I will try to explain everything in detail and with many screenshots I would say that it would be very helpful if one has some knowledge of HTML CSS Javascript relational databases Object oriented concepts This is not going to be a 100 level beginner level tutorial and very experienced developers will lot not gain much from this series of posts The development language will be C I will create a Web Application Project and not a Web Site Project There are a lot of web developers out there that use ASP Net MVC ASP Net MVC provide us with a new way of writing ASP Net applications It does not replace web forms It is just an alternative project type It still runs on ASP Net and supports caching sesions and master pages There is more emphasis on test driven development and separation of concerns with ASP Net MVC If I have time I will create another series of posts where I will create the exact same application using ASP Net MVC 4 0 There are two posts in my blog regarding ASP Net MVC You can find them here and here I always thought that people who are familiar with RAD tools the best way to learn web applications on the Net framework is the ASP Net Web forms paradigm It is a control based event driven development model that suits most people that know how to create Windows Forms Applications or WPF applications Let s start with the actual demo application 1 Launch Visual Studio Create a New Project File New Project From the available templates choose ASP Net Web Forms Application Have a look at the picture below 2 Make sure that you spend some time reviewing the structure of the application and the files in the Solution Explorer We have aspx files js files including the JQuery library css files e t c Make sure you run the application and navigate to the various pages Make sure you realise that ASP Net is a server side technology The built in web server dynamically generates the HTML that is rendered on the browser If you want to learn more about Page lifecycle events have a look at this post of mine We have a functional web application out of the box There is common structure layout in this web application This feature is known as Master Pages Please have a look at the HTML rendered in your browser The ASP Net application template uses HTML 5 Modernizr open source javscript Library is also included for browsers that do not support HTML 5 If you want to find more about HTML 5 have a look at these posts Have a look at the picture below You can also use register and log in to the web site If you want to learn more about membership controls and the Membership provider in ASP Net have a look here Another important feature I want to highlight is NuGet and Nuget packages If you have a look at the JQuery js files that are included in the web site out of the box you will notice that this is not the latest version We can download the latest version of JQuery Library using Nuget If you go to Tools Library Package Manager Manage NuGet Packages For Solution you can locate the latest version of JQuery and download it in your solution You can also do with the other libraries and tools NuGet is really great because when you install a package through NuGet it copies all the files to the solution adding references and making changes to the web config Find more about Nuget in this post Please have a look at the picture below In the next post I will make some changes in the css files and master pages to give a unique look and feel to our site Hope it helps Posted Τρίτη 25 Σεπτεμβρίου 2012 10 11 πμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία jquery Code First html5 LocalDB EF 5 0 ASP NET 4 5 Sorting the columns of an HTML table using JQuery In this post I will show you how easy is to sort the columns of an HTML table I will use an external library called Tablesorter which makes life so much easier for developers Τhere are other posts in my blog regarding JQuery You can find them all here You can find another post regarding HTML tables and JQuery here We will demonstrate this with a step by step example I will use Visual Studio 2012 Ultimate You can also use Visual Studio 2012 Express Edition You can also use VS 2010 editions 1 Launch Visual Studio Create an ASP Net Empty Web application Choose an appropriate name for your application 2 Add a web form default aspx page to the application 3 Add a table from the HTML controls tab control from the Toolbox on the default aspx page 4 Now we need to download the JQuery library Please visit the http jquery com and download the minified version Then we need to download the Tablesorter JQuery plugin Please donwload it here 5 We need to reference the JQuery library and the external JQuery Plugin In the head section Ι add the following lines script src jquery 1 8 2 min js type text javascript script script src jquery tablesorter js type text javascript script 6 We need to type the HTML markup the HTML table and its columns body form id form1 runat server div h1 Liverpool Legends h1 table style width 50 border 1 cellpadding 10 cellspacing 10 class liverpool thead tr th Defenders th th MidFielders th th Strikers th tr thead tbody tr td Alan Hansen td td Graeme Souness td td Ian Rush td tr tr td Alan Kennedy td td Steven Gerrard td td Michael Owen td tr tr td Jamie Garragher td td Kenny Dalglish td td Robbie Fowler td tr tr td Rob Jones td td Xabi Alonso td td Dirk Kuyt td tr tbody table div form body 7 Inside the head section we also write the simple JQuery code script type text javascript document ready function liverpool tablesorter script 8 Run your application This is how the HTML table looks before the table is sorted on the basis of the selected column 9 Now I will click on the Midfielders header Have a look at the picture below Tablesorter is an excellent JQuery plugin that makes sorting HTML tables a piece of cake Hope it helps Posted Δευτέρα 24 Σεπτεμβρίου 2012 9 51 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net jquery tables sorting Highlighting rows and columns in an HTML table using JQuery A friend of mine was seeking some help regarding HTML tables and JQuery I have decided to write a few posts demonstrating the various techniques I used with JQuery to achieve the desired functionality Τhere are other posts in my blog regarding JQuery You can find them all here I have received some comments from visitors of this blog that are complaining about the length of the blog posts I will not write lengthy posts anymore I mean I will try not to do so We will demonstrate this with a step by step example I will use Visual Studio 2012 Ultimate You can also use Visual Studio 2012 Express Edition You can also use VS 2010 editions 1 Launch Visual Studio Create an ASP Net Empty Web application Choose an appropriate name for your application 2 Add a web form default aspx page to the application 3 Add a table from the HTML controls tab control from the Toolbox on the default aspx page 4 Now we need to download the JQuery library Please visit the http jquery com and download the minified version 5 We will add a stylesheet to the application Style css 5 Obviously at some point we need to reference the JQuery library and the external stylesheet In the head section Ι add the following lines link href Style css rel stylesheet type text css script src jquery 1 8 2 min js type text javascript script 6 Now we need to highlight the rows when the user hovers over them 7 First we need to type the HTML markup body form id form1 runat server div h1 Liverpool Legends h1 table style width 50 border 1 cellpadding 10 cellspacing 10 thead tr th Defenders th th MidFielders th th Strikers th tr thead tbody tr td Alan Hansen td td Graeme Souness td td Ian Rush td tr tr td Alan Kennedy td td Steven Gerrard td td Michael Owen td tr tr td Jamie Garragher td td Kenny Dalglish td td Robbie Fowler td tr tr td Rob Jones td td Xabi Alonso td td Dirk Kuyt td tr tbody table div form body 8 Now we need to write the simple rules in the style css file body background color eaeaea hover background color 42709b color ff6a00 8 Inside the head section we also write the simple JQuery code script type text javascript document ready function tr hover function this find td addClass hover function this find td removeClass hover script 9 Run your application and see the row changing background color and text color every time the user hovers over it Let me explain how this functionality is achieved We have the hover style rule in the style css file that contains some properties that define the background color value and the color value when the mouse will be hovered on the row In the JQuery code we do attach the hover event to the tr elements The function that is called when the hovering takes place we search for the td element and through the addClass function we apply the styles defined in the hover class rule in the style css file I remove the hover rule styles with the removeClass function Now let s say that we want to highlight only alternate rows of the table We need to add another rule in the style css alternate background color 42709b color ff6a00 The JQuery code comment out the previous JQuery code follows script type text javascript document ready function table tr odd addClass alternate script When I run my application through VS I see the following result You can do that with columns as well You can highlight alternate columns as well The JQuery code comment out the previous JQuery code follows script type text javascript document ready function td nth child odd addClass alternate script In this script I use the nth child method in the JQuery code This method retrieves all the elements that are nth children of their parent Have a look at the picture below to see the results You can also change color to each individual cell when hovered on The JQuery code comment out the previous JQuery code follows script type text javascript document ready function td hover function this addClass hover function this removeClass hover script Have a look at the picture below to see the results Hope it helps Posted Κυριακή 23 Σεπτεμβρίου 2012 11 57 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net jquery tables Using Native Drag and Drop in HTML 5 pages This is going to be the eighth post in a series of posts regarding HTML 5 You can find the other posts here here here here here here and here In this post I will show you how to implement Drag and Drop functionality in an HTML 5 page using JQuery This is a great functionality and we do not need to resort anymore to plugins like Silverlight and Flash to achieve this great feature This is also called a native approach on Drag and Drop I will use some events and I will write code to respond when these events are fired As I said earlier we need to write Javascript to implement the drag and drop functionality I will use the very popular JQuery Library Please download the library minified version from http jquery com download I will create a simple HTML page There will be two thumbnails pics on it There will also be the drag and drop area where the user will drag the thumb pics into it and they will resize to their actual size The HTML markup for the page follows doctype html html lang en head title Liverpool Legends Gallery title meta charset utf 8 link rel stylesheet type text css href style css script type text javascript charset utf 8 src jquery 1 8 1 min js script script language JavaScript src drag js script head body header h1 A page dedicated to Liverpool Legends h1 h2 Drag and Drop the thumb image in the designated area to see the full image h2 header div id main img src thumbs steven gerrard jpg big large images steven gerrard large jpg alt John Barnes img src thumbs robbie fowler jpg big large images robbie fowler large jpg alt Ian Rush div id drag p Drop your image here p div body html There is nothing difficult or fancy in the HTML markup above I have a link to the external JQuery library and another javascript file that I will implement the whole drag and drop functionality The code for the css file style css follows main float left width 340px margin right 30px drag float left width 400px height 300px background color c0c0c0 These are simple CSS rules This post cannot be a tutorial on CSS For all these posts I assume that you have the basic HTML CSS Javascript skills Now I am going to create a javascript file drag js to implement the drag and drop functionality I will provide the whole code for the drag js file and then I will explain what I am doing in each step function var players main img players attr draggable true players bind dragstart function event var data event originalEvent dataTransfer var src this attr big data setData Text src return true var target drag target bind drop function event var data event originalEvent dataTransfer var src data getData Text var img img img attr src src this html img if event preventDefault event preventDefault return false target bind dragover function event if event preventDefault event preventDefault return false players bind dragend function event if event preventDefault event preventDefault return false In these lines var players main img players attr draggable true We grab all the images in the main div and store them in a variable and then make them draggable Then in following lines I am using the dragstart event players bind dragstart function event var data event originalEvent dataTransfer var src this attr big data setData Text src return true In this event I am associating the custom data attribute value with the item I am dragging Then I create a variable to get hold of the dropping area var target drag Then in the following lines I implement the drop event and what happens when the user drops the image in the designated area on the page target bind drop function event var data event originalEvent dataTransfer var src data getData Text var img img img attr src src this html img if event preventDefault event preventDefault return false The dragend event is fired when the user has finished the drag operation players bind dragend function event if event preventDefault event preventDefault return false When this method event preventDefault is called the default action of the event will not be triggered Please have a look a the picture below to see how the page looks before the drag and drop takes place Then simply I drag and drop a picture in the dropping area Have a look at the picture below It works Hope it helps Posted Τρίτη 18 Σεπτεμβρίου 2012 5 56 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net html5 native drag drop Using CSS3 media queries in HTML 5 pages This is going to be the seventh post in a series of posts regarding HTML 5 You can find the other posts here here here here here and here In this post I will provide a hands on example on how to use CSS 3 Media Queries in HTML 5 pages This is a very important feature since nowadays lots of users view websites through their mobile devices Web designers were able to define media specific style sheets for quite a while but have been limited to the type of output The output could only be Screen Print The way we used to do things before CSS 3 was to have separate CSS files and the browser decided which style sheet to use Please have a look at the snippet below HTML 4 media queries link rel stylesheet type text css media screen href styles css link rel stylesheet type text css media print href print styles css Τhe browser determines which style to use With CSS 3 we can have all media queries in one stylesheet Media queries can determine the resolution of the device the orientation of the device the width and height of the device and the width and height of the browser window We can also include CSS 3 media queries in separate stylesheets In order to be absolutely clear this is not and could not be a detailed tutorial on HTML 5 There are other great resources for that Navigate to the excellent interactive tutorials of W3School Another excellent resource is HTML 5 Doctor Two very nice sites that show you what features and specifications are implemented by various browsers and their versions are http caniuse com and http html5test com At this times Chrome seems to support most of HTML 5 specifications Another excellent way to find out if the browser supports HTML 5 and CSS 3 features is to use the Javascript lightweight library Modernizr In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2012 Express edition You can download it here Before I go on with the actual demo I will use the http www caniuse com to see the support for CSS 3 Media Queries from the latest versions of modern browsers Please have a look at the picture below We see that all the latest versions of modern browsers support this feature We can see that even IE 9 supports this feature Let s move on with the actual demo This is going to be a rather simple demo I create a simple HTML 5 page The markup follows and it is very easy to use and understand This is a page with a 2 column layout DOCTYPE html html lang en head title HTML 5 CSS3 and JQuery title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css head body div id header h1 Learn cutting edge technologies h1 p HTML 5 JQuery CSS3 p div div id main div id mainnews div h2 HTML 5 h2 div div p HTML5 is the latest version of HTML and XHTML The HTML standard defines a single language that can be written in HTML and XML It attempts to solve issues found in previous iterations of HTML and addresses the needs of Web Applications an area previously not adequately covered by HTML p div class quote h4 Do More with Less h4 p jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing event handling animating and Ajax interactions for rapid web development p div p The HTML5 test html5test com score is an indication of how well your browser supports the upcoming HTML5 standard and related specifications Even though the specification isn t finalized yet all major browser manufacturers are making sure their browser is ready for the future Find out which parts of HTML5 are already supported by your browser today and compare the results with other browsers The HTML5 test does not try to test all of the new features offered by HTML5 nor does it try to test the functionality of each feature it does detect Despite these shortcomings we hope that by quantifying the level of support users and web developers will get an idea of how hard the browser manufacturers work on improving their browsers and the web as a development platform p div div div id CSS div h2 CSS 3 Intro h2 div div p Cascading Style Sheets CSS is a style sheet language used for describing the presentation semantics the look and formatting of a document written in a markup language Its most common application is to style web pages written in HTML and XHTML but the language can also be applied to any kind of XML document including plain XML SVG and XUL p div div div id CSSmore div h2 CSS 3 Purpose h2 div div p CSS is designed primarily to enable the separation of document content written in HTML or a similar markup language from document presentation including elements such as the layout colors and fonts 1 This separation can improve content accessibility provide more flexibility and control in the specification of presentation characteristics enable multiple pages to share formatting and reduce complexity and repetition in the structural content such as by allowing for tableless web design p div div div div id footer p Feel free to google more about the subject p div body html The CSS code style css follows body line height 30px width 1024px background color eee p font size 17px font family Comic Sans MS p h2 h3 h4 margin 0 0 20px 0 main header footer width 100 margin 0px auto display block header text align center border bottom 1px solid 000 margin bottom 30px footer text align center border top 1px solid 000 margin bottom 30px quote width 200px margin left 10px padding 5px float right border 2px solid 000 background color F9ACAE quote last child margin bottom 0 main column count 2 column gap 20px column rule 1px solid 000 moz column count 2 webkit column count 2 moz column gap 20px webkit column gap 20px moz column rule 1px solid 000 webkit column rule 1px solid 000 Now I view the page in the browser Now I am going to write a media query and add some more rules in the css file in order to change the layout of the page when the page is viewed by mobile devices media only screen and max width 480px body width 480px main moz column count 1 webkit column count 1 I am specifying that this media query applies only to screen and a max width of 480 px If this condition is true then I add new rules for the body element I change the number of columns to one This rule will not be applied unless the maximum width is 480px or less As I decrease the size width of the browser window I see no change in the column s layout Have a look at the picture below When I resize the window and the width of the browser so the width is less than 480px the media query and its respective rules take effect We can scroll vertically to view the content which is a more optimised viewing experience for mobile devices Have a look at the picture below Hope it helps Posted Τρίτη 18 Σεπτεμβρίου 2012 10 47 πμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net html5 css3 media queries Using rounded corners in modern websites with CSS3 This is going to be the sixth post in a series of posts regarding HTML 5 You can find the other posts here here here here and here In this post I will provide a hands on example on how to use rounded corners rounded corners in CSS3 in your website I think this is the feature that is most required in the new modern websites Most websites look great with their lovely round panels and rounded corner tab style menus We could achieve that effect earlier but we should resort to complex CSS rules and images I will show you how to accomplish this great feature with the power of CSS 3 We will not use Javascript Javascript is required for IE 7 IE 8 and the notorious IE 6 The best solution for implementing corners using CSS and Javascript without using images is Nifty corners cube There are detailed information how to achieve this in the link I provided This solution is tested in earlier vesrions of IE IE 6 IE 7 IE 8 and Opera Firefox Safari In order to be absolutely clear this is not and could not be a detailed tutorial on HTML 5 There are other great resources for that Navigate to the excellent interactive tutorials of W3School Another excellent resource is HTML 5 Doctor Two very nice sites that show you what features and specifications are implemented by various browsers and their versions are http caniuse com and http html5test com At this times Chrome seems to support most of HTML 5 specifications Another excellent way to find out if the browser supports HTML 5 and CSS 3 features is to use the Javascript lightweight library Modernizr In this hands on example I will be using Expression Web 4 0 This application is not a free application You can use any HTML editor you like You can use Visual Studio 2012 Express edition You can download it here Before I go on with the actual demo I will use the http www caniuse com to see the support for web fonts from the latest versions of modern browsers Please have a look at the picture below We see that all the latest versions of modern browsers support this feature We can see that even IE 9 supports this feature Let s move on with the actual demo This is going to be a rather simple demo I create a simple HTML 5 page The markup follows and it is very easy to use and understand DOCTYPE html html lang en head title HTML 5 CSS3 and JQuery title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css head body div id header h1 Learn cutting edge technologies h1 div div id main h2 HTML 5 h2 p id panel1 HTML5 is the latest version of HTML and XHTML The HTML standard defines a single language that can be written in HTML and XML It attempts to solve issues found in previous iterations of HTML and addresses the needs of Web Applications an area previously not adequately covered by HTML p div body html Then I need to write the various CSS rules that style this markup I will name it style css body line height 38px width 1024px background color eee text align center panel1 margin auto text align left background color 77cdef width 400px height 250px padding 15px font size 16px font family tahoma color fff border radius 20px Have a look below to see what my page looks like in IE 10 This is possible through the border radious property The colored panel has all four corners rounded with the same radius We can add a border to the rounded corner panel by adding this property declaration in the panel1 border 4px 000 solid We can have even better visual effects if we specify a radius for each corner This is the updated version of the style css body line height 38px width 1024px background color eee text align center panel1 margin auto text align left background color 77cdef border 4px 000 solid width 400px height 250px padding 15px font size 16px font family tahoma color fff border top left radius 20px border top right radius 70px border bottom right radius 20px border bottom left radius 70px This is how my page looks in Firefox 15 0 1 In this final example I will show you how to style with CSS 3 rounded corners a horizontal navigation menu This is the new version of the HTML markup DOCTYPE html html lang en head title HTML 5 CSS3 and JQuery title meta http equiv Content Type content text html charset utf 8 link rel stylesheet type text css href style css head body div id header h1 Learn cutting edge technologies h1 div div id nav ul li a class mymenu id activelink href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 8934038 Main a li li a class mymenu href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 8934038 HTML 5 a li li a class mymenu href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 8934038 CSS 3 a li li a class mymenu href http weblogs asp net controlpanel blogs posteditor aspx SelectedNavItem Posts ionid 1153 postid 8934038 JQuery a li ul div div id main h2 HTML 5 h2 p id panel1 HTML5 is the latest version of HTML and XHTML The HTML standard defines a single language that can be written in HTML and XML It attempts to solve issues found in previous iterations of HTML and addresses the needs of Web Applications

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/09.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Αύγουστος 2012 - Δημοσιεύσεις
    Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Αύγουστος 2012 Δημοσιεύσεις Optimising SQL Server for ad hoc workloads In this post I will be demonstrating with hands on examples how to optimise your SQL Server for ad hoc workloads I will be using the view LookIntoPlanCache that I created in this post Make sure to read this post if you are not familiar with terms Διαβάστε περισσότερα Posted Παρασκευή 10 Αυγούστου 2012 2 53 πμ από το μέλος nikolaosk 0 σχόλια Looking into the contents of Plan Cache in SQL Server In this post I will be demonstrating with hands on examples how to look into the contents of Plan Cache I will be explaining what the Plan Cache Procedure Cache is the process of query optimization and the generation of execution plans in detail Διαβάστε περισσότερα Posted Πέμπτη 9 Αυγούστου 2012 1 55 πμ από το μέλος nikolaosk 0

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/08.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Ιούλιος 2012 - Δημοσιεύσεις
    2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Ιούλιος 2012 Δημοσιεύσεις Using THROW statement in SQL Server 2012 In this post I would like to demonstrate with a hands on example how to use the new THROW statement available to us for error handling in SQL Server 2012 Well most of you know that we have TRY CATCH statements for exception handling since SQL Server Διαβάστε περισσότερα Posted Παρασκευή 20 Ιουλίου 2012 10 39 μμ από το μέλος nikolaosk 0 σχόλια Looking into new and enhanced DMVs and DMFs in SQL Server 2012 In this post I would like to demonstrate with a few examples how to use the new DMOs Dynamic Management Objects DMVs DMFs that are available to us with the RTM version of SQL Server 2012 Some of them were present in SQL Server 2008 R2 SP1 but Διαβάστε περισσότερα Posted Παρασκευή 20 Ιουλίου 2012 4 39 μμ από το μέλος nikolaosk 0 σχόλια Using Page Restore in SQL Server 2012 using SSMS In this post I would like to provide you with a hands on example on how to perform a Page Restore using the SSMS in SQL Server 2012 We could perform page restores in SQL Server 2005 2008 with T SQL but in SQL Server 2012 we have SSMS UI support for Διαβάστε περισσότερα Posted Πέμπτη 19 Ιουλίου 2012 1 11 μμ από το μέλος nikolaosk 0 σχόλια Stored procedure compilation and caching In this post I will explain when the actual caching the stored procedure is placed in the procedure cache takes place Many people think that the execution plan of a stored procedure is cached in the procedure cache when the stored procedure is created Διαβάστε περισσότερα Posted Τρίτη 17 Ιουλίου 2012 5 13 πμ από το μέλος nikolaosk 0 σχόλια Using T SQL Functions in the WHERE clause of query In this post Ι would like to demonstrate with a hands on example the negative performance implications when using built in or user defined functions in a WHERE statement of a SQL query read more Διαβάστε περισσότερα Posted Δευτέρα 16 Ιουλίου 2012 9 54 μμ από το μέλος nikolaosk 0 σχόλια Using SQL Space Map In this rather short post I would like to talk about a very handy and easy to use tool SQL Space Map that makes it very easy to identify space utilisation for a particular database in our SQL Server instance read more Διαβάστε περισσότερα Posted Δευτέρα 16 Ιουλίου 2012 7 11 μμ από το μέλος nikolaosk 0 σχόλια Using SQL Server 2012 Performance Dashboard Reports In this post I would like to talk about various reports SQL Server 2012 Performance Dashboard Reports that are available to us through Microsoft Download and their purpose is to give us an overview of the overall performance of an SQL Server instance Basically Διαβάστε περισσότερα Posted Δευτέρα 16 Ιουλίου 2012 7 10 μμ από το μέλος nikolaosk 0 σχόλια Looking into Concat string function in SQL Server

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/07.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Ιούνιος 2012 - Δημοσιεύσεις
    Entities Linq to Sql LocalDB logging login controls master page master detail membership Mobile Views Model First MS Office objectdatasource performance Polymorphism SEO session state silverlight Sql Server Sql Server 2005 SQL Server 2008 sql server 2012 sqlcommand SQLDataReader stored procedures tables tips and tricks Tracing transaction log transactions UpdatePanel validation VB 2005 VB 2008 VB 9 0 ViewState Visual Basic 10 0 Visual Studio Visual Studio 2005 Visual Studio 2008 Visual Studio 2010 Visual Studio 2012 VS 2010 VS 2012 WCF wcf data service web server controls web service web config window forms windows forms WPF XAML XHTML XML XML Literals Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Ιούνιος 2012 Δημοσιεύσεις Restoring a database from SQL Server Enterprise Edition to any other edition of SQL Server In this post I would like to demonstrate with a hands on example that is not always possible to

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/06.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Μάιος 2012 - Δημοσιεύσεις
    Server 2005 SQL Server 2008 sql server 2012 sqlcommand SQLDataReader stored procedures tables tips and tricks Tracing transaction log transactions UpdatePanel validation VB 2005 VB 2008 VB 9 0 ViewState Visual Basic 10 0 Visual Studio Visual Studio 2005 Visual Studio 2008 Visual Studio 2010 Visual Studio 2012 VS 2010 VS 2012 WCF wcf data service web server controls web service web config window forms windows forms WPF XAML XHTML XML XML Literals Πλοήγηση Αρχική σελίδα Εκδηλώσεις Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Μάιος 2012 Δημοσιεύσεις Automating SQL Server Administration Tasks In this post I would like to demonstrate with hands on examples how to use automation jobs alerts operators notifications in SQL Server to automate SQL Server administration tasks The importance of automating tasks is profound The following tasks could Διαβάστε περισσότερα Posted Πέμπτη 24 Μαΐου 2012 12 02 πμ από το μέλος nikolaosk 0 σχόλια Configuring Database

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/05.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Απρίλιος 2012 - Δημοσιεύσεις
    VIsual Studio 2011 The importance of filegroups in database performance In this post I would like to explain you with a hands on example the importance of filegroups in Sql Server databases This is not a post that experienced advnanced DBAS developers should read The target audience is beginners Level 100 Most beginners Διαβάστε περισσότερα Posted Παρασκευή 20 Απριλίου 2012 9 52 μμ από το μέλος nikolaosk 0 σχόλια Looking into SPARSE Columns in SQL Server In this rather short post I would like to provide you with a hands on example on SPARSE columns Sparse columns are very useful when we have tables and columns with many zero and NULL values This feature was introduced in SQL Server 2008 We have a better Διαβάστε περισσότερα Posted Πέμπτη 19 Απριλίου 2012 2 10 πμ από το μέλος nikolaosk 0 σχόλια Looking into the various ways you can find out the Recovery model of databases in an SQL Server instance This is going to be a rather short post I have been teaching the Official Microsoft SQL Server courses in my capacity as MCT and to be totally honest with you I enjoy it very much One of my favorite subject is Backup Restore This is maybe the Διαβάστε περισσότερα Posted Τετάρτη 18 Απριλίου 2012 6 04 μμ από το μέλος nikolaosk 0 σχόλια Looking into Nested Transactions and Rollback operations In this post I would like to show you what happens when we issue ROLLBACK operations in nested transactions Have a look in this post of mine to find out more information about transactions A lot of people are confused on how a Rollbackstatement impacts Διαβάστε περισσότερα Posted Τετάρτη 18 Απριλίου 2012 2 52 πμ από το μέλος nikolaosk 0 σχόλια Using Log4Net in an ASP Net application In this post I would like to show you a fairly simple example on how to use Log4Net logging service to log information in a text file You can log information to a text file a database table or Windows event viewer using the Log4Net logging assembly This read more Posted Δευτέρα 16 Απριλίου 2012 11 56 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net logging Log4Net Looking into DENY and GRANT security permissions In this post I would like to talk about DENY and GRANT security permissions I will provide some examples that will demonstrate that DENY takes precedence over GRANT but there are some special cases We use DENY and GRANT T Sql commands to give permissions Διαβάστε περισσότερα Posted Σάββατο 14 Απριλίου 2012 1 47 μμ από το μέλος nikolaosk 0 σχόλια How to bind a XPO Data Source to an ASPxGridView control I have been involved with an ASP Net project recently and I have implemented it using the awesome DevExpress ASP Net controls In this post I will show you how to bind an XPODataSource control to an ASPxGridView control If you want to implement this read more Posted Πέμπτη 12 Απριλίου 2012 9 18

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/04.aspx (2015-07-15)
    Open archived version from archive

  • Dot Net Rules : Μάρτιος 2012 - Δημοσιεύσεις
    Ιστορικό Δημοσιεύσεων Ιούνιος 2015 4 Μάρτιος 2015 2 Ιούνιος 2014 1 Δεκέμβριος 2013 2 Νοέμβριος 2013 14 Οκτώβριος 2013 2 Σεπτέμβριος 2013 5 Ιούλιος 2013 1 Ιανουάριος 2013 8 Δεκέμβριος 2012 11 Νοέμβριος 2012 3 Οκτώβριος 2012 12 Σεπτέμβριος 2012 16 Αύγουστος 2012 6 Ιούλιος 2012 13 Ιούνιος 2012 3 Μάιος 2012 4 Απρίλιος 2012 15 Μάρτιος 2012 8 Ιανουάριος 2012 3 Δεκέμβριος 2011 7 Νοέμβριος 2011 13 Οκτώβριος 2011 6 Σεπτέμβριος 2011 8 Αύγουστος 2011 6 Ιούλιος 2011 2 Μάιος 2011 1 Μάρτιος 2011 9 Φεβρουάριος 2011 15 Ιανουάριος 2011 14 Δεκέμβριος 2010 9 Νοέμβριος 2010 2 Οκτώβριος 2010 11 Σεπτέμβριος 2010 1 Αύγουστος 2010 3 Απρίλιος 2010 2 Μάρτιος 2010 5 Ιανουάριος 2010 1 Οκτώβριος 2009 2 Σεπτέμβριος 2009 4 Ιούνιος 2009 5 Απρίλιος 2009 1 Μάρτιος 2009 3 Φεβρουάριος 2009 2 Δεκέμβριος 2008 3 Νοέμβριος 2008 10 Σεπτέμβριος 2008 1 Αύγουστος 2008 1 Ιούλιος 2008 9 Ιούνιος 2008 10 Μάρτιος 2012 Δημοσιεύσεις Using Entity Framework Table splitting customisations in an ASP Net application I have been teaching in the past few weeks many people on how to use Entity Framework I have decided to provide some of the samples I am using in my classes First let s try to define what EF is and why it is going to help us to create easily data centric read more Posted Σάββατο 31 Μαρτίου 2012 10 23 μμ από nikolaosk 0 σχόλια Δημοσίευση στην κατηγορία asp net Entity framework table splitting Using the bcp utility to insert rows in a table with triggers and constraints In this post I would like to talk about how to import and export data using the bcp utility I will also explain how the bcp utility works with tables that have constraints and triggers attached on them No databases exist in isolation We need to import Διαβάστε περισσότερα Posted Δευτέρα 26 Μαρτίου 2012 2 08 πμ από το μέλος nikolaosk 0 σχόλια Using the BULK INSERT statement to insert rows in a table with triggers and constraints In this post I would like to talk about how to import data from a text file using the BULK INSERT statement If you want to find out more about BULK INSERT have a look here I will also explain how the BULK INSERT statement works with tables that have Διαβάστε περισσότερα Posted Δευτέρα 26 Μαρτίου 2012 2 06 πμ από το μέλος nikolaosk 0 σχόλια Create a master detail Windows Forms application with EF I have been teaching in the past few weeks many people on how to use Entity Framework I have decided to provide some of the samples I am using in my classes In this post I will show you a step by step example on how to build a Windows Forms Master Διαβάστε περισσότερα Posted Πέμπτη 15 Μαρτίου 2012 7 11 μμ από το μέλος nikolaosk 0 σχόλια How to configure WAS for TCP endpoints in IIS In this post I would like to show you how to activate Windows

    Original URL path: http://www.dotnetzone.gr/cs/blogs/dotnetrules/archive/2012/03.aspx (2015-07-15)
    Open archived version from archive



  •