 H2K Infosys provides world-class online IT training, staffing and software testing solutions to customers worldwide. H2K Infosys supports 100% job-oriented training, hands-on project work, cloud test lab, resume preparation and review, mock interviews, rubber syllabus. One-time pay, lifetime access to live classes and videos. H2K Infosys has won the trust of thousands of students worldwide. For free demo class, visit H2Kinfosys.com Hi guys, welcome to H2K Infosys. Myself Ankit Reddy, I'm having more than 6 years of experience in IT industry as well as in teaching field. Here I'll be taking the classes for .NET. .NET will be covering C-Shop.NET, ASP.NET and SQL Server database. So in order to complete an application, it is required to have database as well. So here, as part of this course, we'll be covering C-Shop.NET, ASP.NET and SQL Server. There are other databases also there, but we'll be taking SQL Server database for our course. Here, we can develop with .NET many kind of applications. One is a console application. The other one is a Windows application, we call it as. The other one is a web applications. The fourth one is mobile applications. So these many kinds of applications we can develop by using Visual Studio. And if somebody asks you that, which language are you learning? Please do not go and say that I'm learning .NET. So .NET is a framework. Please remember that .NET is a framework, not a language. Under which there are many languages that are supported by Microsoft Visual Studio. Examples are C-Shop.NET, VB.NET, J-Shop.NET, like many other languages are there. Under which languages which are got famous is C-Shop.NET and the next famous is VB.NET. So according to your choice, you can choose the one which you wanted to learn. And in the market, more requirement is there for C-Shop.NET. Organizers are expecting that a candidate should have experience in a C-Shop.NET, along with ASP.NET. The combinations are like C-Shop.NET plus ASP.NET. And VB.NET plus ASP.NET. So whichever you are taking, ASP.NET will be a common. Why is this ASP.NET common is this ASP.NET for developing a web applications. So whenever you hear the word ASP.NET, you think that it is for web applications. So whenever you want to create a web application, you learn about ASP.NET. So you think about ASP.NET, that is for web application purpose. And SQL Server is required. Why it is required is it is a database whenever you wanted to frequently use one application or a website like social networking or such. Nowadays we are using Facebook, Gmail, Twitter, whatever it is. So today we have registered into that social networking site. And tomorrow we wanted to login to the same website, how it is possible. So at the time of registration, we will be storing data into our database. And whenever it comes back and login to the same application, we are checking that is credentials are existing or not. If it is existing, we will be allowing you to login to that particular website or application. So that a database is required. Here, this console application will be as same as our command prompt. Let me show you that command prompt, how it looks like. This is a CMD command to open a command prompt. A console application will look like this. So console application will be used to know about more about C shop.net. We will be learning more in this console application about the logic, what we are going to implement and the basic things. Very basic things you should start from here. The thing is, if you start learning directly web application, you will not understand the basic things and your base will not be strong. So whatever it is, whatever the language you are learning, basic things are very, very important. So we will be starting with the console application. Once you understand the console application concepts, then it is easy to understand the web application. And I am skipping these Windows applications. Why? The other name for Windows application is a standalone application. This means a name is a self-explanatory stand alone. It doesn't require anything. And as how a C shop.net got famous like compared to VB.net, same way web applications are famous compared to Windows applications. Organizers are expecting a candidate should be possessed experience with a web application but not a Windows application. Yes, I agree with Windows application experience is also required but percentage wise very less. Maybe out of 100 people required 5 to 6 resumes from Windows application. The remaining 90% resumes in need from the web application experience. Why? Why is it not got famous and why it is so much famous with web application? What is the advantages of web application? What are the problems with Windows application? Let us see in a quick source. I have an application that says Windows application. Here I said that Windows application is a standalone application. A standalone means applications which we will be running like example. Let me tell you that. Calcium. So it is a calculator. This is a calculator which had come along with the operating system that we have got installed into our computers. So this doesn't require anything to run this application. Means that it is independent from all the things. So when you install something into your computer, then that will be a standalone application. So you don't want to have to connect to anything like it should not be in a network, it should not be required internet access. So this is called a standalone application. And remember that your client is asking you to prepare or you to come up with an application that is a standalone application. Example I am showing this one. Maybe this kind of application your client is asking to develop. So today you have developed this and given to him. A standalone application or a Windows application will be having .exe files. You would have seen this .exe files. Whenever you are installing something into your computers, you should double click on this .exe file. You will be running this file. So after you developed an application accordingly as per the user requirements, you will be giving .exe file. Suppose it is a calc then you will be distributing to his customers. Say 1000 customers are there or 2000 customers are there for him. The client will be having customers. He has given this .exe to his 2000 employees. After some point of time your client feel that he wanted to add some additional features in it. Suppose in this place of calculator he wanted to add his company name or some other features he wanted to add. How to do that? So your client will come back to you and ask you to do the changes for the existing application. Yes. You analyze that and you feel that ok we can add it to this existing application. You agreed for the terms and conditions. What will happen? After 6 months of time or 1 month or 1 year time, you have added the new features for the existing application. Then it will become calc 1.0 version .exe has given to the client. So what will happen? After sending you these requirements you will be creating this new application. Then you have to hand over this new application to the client. Then client what we will do is again he will take this new .exe file and he has to submit to the 2000 employees. Then what those 2000 employees need to do is they should uninstall this one and then they should install this one just because they need to see the company name here. There is a small change. So this is very cumbersome job. The maintenance will be very tough and this kind of additional features added taking to the all the clients is very much a tough job because it is a calculator and it won't take much space in your computer. In reality the applications will also be taking much more space in your project, I mean in your computers. If you don't have space again you need to delete something else to provide required space for this application. That's also a problem. So the web applications in the case of web applications you don't need to provide any .exe files to the clients. What will happen is after creating the web application we will be keeping that in a server. So server will be a physical thing. It will be there somewhere else. We will be hearing these words. Server is done for some point of time. So server is not reacting. Whenever you are trying to access any web applications on your own maybe server is done for this particular time. This kind of message will be seen. So what is that? Actually server is a web server we call it as. After creating your web application instead of having this .exe funda what will happen is we will be keeping a web application in a web server. Keeping a web application in a web server. So what will happen? Why do we keep it in a web server? When you keep your application in a web server your clients or your customers, whoever it is they can access your application called a web application via web browser. What is that web browser? Web browsers are Internet Explorer, Google Chrome, Mozilla Firefox, Opera, whatever it is. Web browsers we are using. So to access the web application user required a web browser with internet connection. That's it. So he no need to install anything and he don't need to provide some space also of comparatively very less space. So you require some KBs to open a web browser. That's it. How big the application is doesn't matter. You can access from the website from your web browser. And here the enhancements for the current application you no need to give every time this EX is. What will happen? Via internet only they can access the new features. And if you observe in a banking application sometime they will be giving some messages saying that our application is under maintenance. Please come back after so and so time. Otherwise they'll be providing some timing before the maintenance taking place from 3-4 days before only they will be giving some messages saying that on particular day on particular time our application will be down. These and these services will not be available. The other services will be available like that. And you will be wondering that some social networking websites like Facebook, Twitter, whatever it is. They are also coming up with everyday new new features. But have you ever seen that a message is saying like this in a social networking websites? Definitely no. How it is happening again. I said that we'll be keeping a web application in a web server. A web server is there and for a time being to have a backup to make application as robustness what they will do is instead of depending on a one server they'll buy that another web server. So in these two places your applications will be there. What will happen is users can be accessed first from the web server one and they will be making changes in a web server too. So as long as you are changing or you are adding some enhancements to the web application the current web application that will be taking part in a web server too. So users will be connecting to the web server one. They will be accessing that application without any interruption. Once they feel that all the applications enhancements is done they'll be testing that after they feel that everything is working fine then they'll connect you to the web server too. That time immediately they can see that new features. Once they log off and login they can see that new features. So that way the maintenance is very easy the comfort and user friendly for customers with this web application. So only nowadays whoever develop an application they wanted to be on the go. Nowadays it is like not only web application they wanted a mobile application. They wanted to hold in their hand and they wanted to take it wherever they want to go. So standalone application means you'll be installing it on a computer and you cannot get this online updates because it doesn't require to connect to the internet. But with web application it will be connecting with the online updates. So there are more advantages with web application projects compared to the windows applications. Still there are requirements are there with windows applications as well but comparatively very low with this web application. So people will be preferring to learn and organizations also preferring to recruit the persons who is having web application experience. So that's why we'll be covering most of the times with web application and console application. And let me take one a practical example instead of telling this everything theoretical. I'm having visual studio 2012 that's ultimate version. Let me open a project. How to open it? After clicking on it you can just click here and choose a new click on project. Let it load. We'll take a few seconds. Let it load. See here. The console application is there. Now let me take this sample program. So this is our project name. Click on OK. It will be creating. Let it create. See this. Once you have created your application the 15 lines of code has come automatically. You have not written anything. Now what I'm going to do is I'm going to write a program. The program is we are going to check that dividing a number. So we require a numerator and denominator. The conditions are like if you ask a user to enter a number suppose please enter a number if I ask he may press 5 or 10 or there are chances that somebody ping me we need to familiarize the Java or is this a question or a statement? Sarita. No. It doesn't require to have any knowledge before joining this .NET. I'll make you people that in a site flows a non-IT background guy also can prepare or can create an application or a project on his own at the end of the course. Today if you don't know anything what I need from you is you should understand English language and you should follow my instructions and you should do the assignments what I'm giving and I'm there always to help you if you are getting anything trouble from the technical thing. I'm always there to help you via technical things. So if you attend my all sessions without fail and if you follow that sessions and if you do the assignments simple simple assignments that I'm going to give definitely you'll be in a position at the end of the course you can create your own project that's my promise from my end. Okay. And suppose if you enter a number by mistake like this and this is not a number so the first condition is if he type anything other than a number we need to tell him that the program should let the user know only numbers can be added and one more thing is if user enters a very large number at that time also we'll be telling that large numbers are not allowed then we'll be giving some range. So first condition is if the user enters some alphabetic number suppose if I ask you to enter a number you may press like 10 so that time the program should let the user numbers are allowed so if the user enters 10 instead of 10 actually the number I'm telling instead of number 10 if you type like this 10 then the program should let the user know the program should let the user know only numbers are allowed this is the first condition and then one more condition if the user enters very large number if the user enters very large number that time also the program should let the user know about the range allowed the program should let the user know only the range is allowed and when you're doing that division the denominator should not be 0 should not be 0 that is this one I guess if you have a denominator 0 what will happen suppose let me show you 10 divided by 0 see cannot divided by 0 so if any of these things happen we wanted to show this kind of messages if user enters 10 digits like this alpha characters we need to show these are not allowed if he enters a very large number again we need to show this large numbers are not allowed and we'll be giving some range within that range only you need to enter and denominator should not be 0 like that also we can take this so let me take this an example with this visual studio so this is of a console application with this we can have this program by using cshop.net see you can see .cs this stands for cshop if you have selected visual basic here you can see .vb at the time of installation only it will be asking you whether you need cshop or vb.net there will be a checkbox if you choose cshop then your program or projects will be under cshop if you choose vb at the time of installation you can be seeing the programs in a vb only now in a console application he had told that we'll be asking please enter a number so how to write to a console something here we have seen already the command prompt normal command prompt how it look like so as similar to this visual studio also will be looking the same way how to write to console a console class is there and we'll be using a method called a write line method do not worry about this class what is that I'm talking a console is a class a program is a class it's a namespace in a regular class we'll be discussing each and everything in a simple simple terms what and all these main method is scheme what is this void means what is this args means this method right line is what are this why is these lines are required we'll be covering all the things in our regular classes as of now just concentrate on that how we are achieving these things ok just follow me and just see that how the visual studio is and how the cshop is and how the console application is ok now we have a class called console and a right line is a method cshop beautyness is if you just mouse over on it it will be giving the information see I told that console is a class you can verify it by mouse offering on it it will be then the first word itself a class system.console what is that system again system is say this one namespace if you remove this suppose how to remove this let me delete it see immediately we are getting another message so this is the beauty of this visual studio it will be teaching you more see what is telling the name console does not exist in the current contact so to avoid that we can give here only the system a fully qualified name we can call it as see now it is not throwing error and not only in one place will be using this console class in our program will be using most of the places console class so instead of typing every time system.console we can type only at one place then onwards we can use it wherever we want that console class so that is the reason we will be keeping in this place system so we are given a tool on top of this application you know to give every time you can directly use a console class wherever you want so how to write to console is by using console class write line method please enter a number for numerator he will be typing then how to read it how to read from the console then again we have read line so by this we can read the number ok we can read it but we wanted to store some other place for our calculations how to do that as the person will be entering a number right so we have data types in our visual studio again do not worry about the data types word data type means it will be holding the data accordingly accordingly in the sense numbers will be stored somewhere else names will be storing somewhere else so as it is a number I will be taking integer numerator that is equals to this one again here it is throwing error why is this error is coming it just moves over it and you can read that error message at the end cannot implicitly convert type string to integer so this is of type integer and this is of type string it just moves over on it and read the first line it is showing string console.readline what we are trying to do is we are trying to convert type of data to other type of data that is why it is throwing error so we need to tell that please convert into some data type called integer 32 before assigning the value will be converting into the integer then we can assign it to the another integer in the same way we need for other number also denominator also will be required please enter number for denominator then again here it is numerator here it is denominator here it is denominator so we have two numbers one is numerator another one is denominator here it is there what we can do we wanted to store or we wanted to calculate that numerator by denominator that will be integer integer result is equals to numerator divided by denominator now here we wanted to display this to the user whatever user is entering we wanted to display to the user about the result now to write something on a console again we will be using console.writeline here result is like this console.readkey see I will tell that why I wrote this console.readkey till now I told only two methods under console a write line is to to display something on a console so I wrote here how to write to a console and how to read from the console your user has given one number then how to read it by using console.readline how to write it is console.writeline then this is our logic we have created integer result is equal to number divided by numerator divided by denominator and then how to display the result to the end user whatever he has asked he asked the division of this number by this number now how to run this program there are two things for all the programs in visual studio one is compilation other one is this one execution so compilation will be doing like this build, build solution this is called compilation then execution is you can click on this start button or else go to debug and you can click this one this can be done from your keyboard also please press F5 keyboard if I use keyboard you cannot see it so most of the 10s I will be utilizing the options which are there on the screen so I am clicking on start let me use the font size so it is asking please enter a number for numerator suppose I press 10 please enter a number for denominator sorry I am spelling 2 now result is 5 find it application is working fine now what for concept we need to have these conditions to verified if user enters 10 what will happen for that let me check it that also suppose by mistake instead of 10 like this I pressed this is the one it is showing see this kind of error messages will be irritated to the normal customers they do not understand what is this error about by mistake they would have pressed like this and if you are showing like this message users will get frustrated and they cannot understand the error message also and handle the exception first of all this is technical term what is the exception you do not understand it here it is showing input string was not in a correct format how to handle this kind of exceptions let me show you that how to handle instead of showing this big error messages will be showing some user friendly error messages to do that we always need try catch block helps all the thing we have kept in a try catch catch we have format exception console dot write line what my intention is instead of showing this technical errors to the end users we require to give user friendly error messages so that users can understand what happened or what went wrong so that you can rectify that error message when next time execution please enter numbers only now let me execute it what will happen see compare to that earlier message and this error message which one is good definitely this kind of error message to end users is always preferable instead of showing technical error messages it was showing unhandled exceptions that time so this is how a good way of showing error message to the end users now next thing is if user enters very large number the program should let the user know only the range is allowed how to do that first let me type very large number suppose the numbers only I am pressing sorry only numbers if I press by mistake like this see again what we are getting unhandled exception system.overflow exception where you say the two large are too small for integer 32 how to make it understand that users should understand what has went wrong sorry again we will close this now we will have something called overflow exception so that number should be not less than or not greater than that number whatever user is entering let me take this help catch then here it is overflow exception please enter numbers in this range otherwise we will give some other meaningful error messages like only numbers between this and that are allowed only numbers within some range we can mention only numbers between are allowed and then which numbers those are here let me mention that integer dot min value is there comma integer dot max value is there so what will happen is if you enter big number it won't allow you or if you enter less than this number it won't allow you what are these numbers first let me show you that sorry so before picking this and be taking this minimum values here it is maximum value this one so your value should be within this range either minimum value and maximum value whether how it is allowing the minimum value should be this one and maximum value is this one not less than this number and not greater than this number suppose if I enter let me enter the big number now see only numbers between this it is showing so you cannot enter a very large number as it is smaller than this number or greater than this number now let me show that as it is minimum value right suppose if I go with minus 2 1 4 7 4 8 3 6 instead of 4 8 I am giving less number 4 9 so in minus it is there right 4 9 so 4 8 is a bigger value 4 9 is a smaller value if I press enter it will be showing error message only numbers between this is the one is allowed the program is logically following the conditions whatever client had put user enters very large number the program should let the user know only the range is allowed and suppose if I enter a maximum value more than that specified what will happen this is the one 2 1 4 7 4 8 3 6 4 8 again it is throwing message so this will be showing only the numbers between this range now another condition denominator should not be 0 how to achieve that let us take another catch let me take help from this divided by 0 exception here we can so if I don't have this first of all what will happen let us see that so before putting this catch we need to do something called 50 then second number is 0 see what's happened and I had an exception so instead of showing this kind of error message to the user will be catching that exception and then will be showing that user friendly error messages instead of showing this kind of error messages close it and let me this denominator cannot be 0 meaning user should enter only the numbers here it is if he enters something else than numbers will be throwing this error message and users are entering numbers only but if they are entering very huge numbers then only I am showing this error messages and he is enter number only and he entered within a range only because 0 again that is also not allowed because we cannot do division by 0 whatever the number it is suppose 8 is there if I divided by 0 it cannot be divided by 0 so that exception also we are following now let us see that number is there and if I press 0 it is showing that denominator cannot be 0 understand all the conditions that the client had put for us and sometimes you cannot expect that maybe you can get other exception also apart from these exceptions console dot something else we can put at other message like let me take here es dot message this error message we cannot predict so whatever the error message comes at the time of execution it will show that particular message example like when you are dealing with a database and when you are connecting to the database and you are getting the data that time the database server also may be down we cannot predict it so that type of error messages will be covered here and remember that this exception is the final exception that can cover all the exceptions and the remaining exceptions should be there before this exception suppose if you have this exception after this exception it will throw error message immediately see a previous catch clause already catches all exceptions of this R of super type means that this exception will be there under this format exception so let me comment this sorry let me comment this thing also now still this program will work let us see this suppose if I press like this input string was not the correct format still this is not in a user friendly error message what user can understand input string so always think from user perspective you don't aware of this what is this string called is you don't know what is this string so we need to give user friendly error messages so only we have given please enter not here in catch only please enter numbers only so this is also a good error message but compared to this error message like this kind of error message will be always giving some more information to the client to enter his valid input understand like in the same way if I give this one input was either too large or too small for into 32 still you cannot understand it we are giving a big clarity of this information so only we will be using this kind of error message will be showing end users hope you understand this hope you understand how to catch exceptions and how to deal those exceptions instead of showing this technical error message to the end users please follow that showing a meaningful error messages to the end users please let me know if you have any question here with this program and to conclude there are many opportunities for this .NET resources who are having .NET resource their skill set like c-shop ASP.NET and this SQL server there are plenty of job opportunities you will be getting and for that H2K Infos will be always helping you to get jobs as well and they will be providing some mock interviews also please contact them for this more details and from my end I will be helping you for all the technical related questions whatever you have for the subject and my promise is that when you join today or when you join any day you don't need to have any knowledge in any of the course if you have some interest then that will make you to understand .NET you should have something like you need to attend classes regularly and you should follow the instructions what I am telling and you should do the assignments what I am going to give simple simple assignments definitely it is not a school or a college it will be following you everyday like have you done or not it is like if you have problems you should approach me then I will be helping you it's like not a micro management will be doing whether I have done it or not it is depends on your interest so you will be reaching me do you have any questions via email call this one at the rate of gmail.com not only in the class if you feel any hesitation to ask a question in a class you can always reach me via this email and sometimes you may not get a question in the class after having the class you may be getting the question anything which is related to the technical things you can please approach me via this email area I will be there always to help you guys if anybody have any questions please let me know so with this a demo class is done if anybody have any questions please stay back otherwise you can log off for the day one question from the other student it may be helpful for other students also the question was how easy is .NET compared to Java the thing is learning perspective it is very easy compared to the Java you need to write all the things in .NET you don't need to write so many things all the things are already there you just need to use the things you will be having toolbox you need to use the things what are there suppose if you wanted to write or if you wanted to display a textbox you don't need to type anything a small line of code also you need to take that just there are many applications are available I mean many controls are available you just drag and drop there is the biggest advantage with any of the other technologies compared to .NET yes the other question is what are all the .NET topics are covered if you take this course that's a good question I will show you that the syllabus that is there in a H2K website only here you can go to the courses in Microsoft.NET come down then you can see this course highlights and deep syllabus is written here topic wise Microsoft.NET course details these the syllabus will be covering not more than this and not less than this till final project work I guess nobody is there in this class students you don't need to submit a project in your colleges I guess and then what is the difference between console application and web application a console application will be looking like this we have seen here and web application is like we have this one this is a web application one kind of application example and facebook is a web application and another question is duration of the class and how long that's correct question let me tell you that every day Monday to Friday I will be taking the same time I think 8pm to 9.30pm that is 90 minutes of the class every day and duration is 9 weeks to 10 weeks it's like 2 and a half months Monday to Friday I will be taking 8pm to 9.30pm it's a 90 minutes class 9 weeks to 10 weeks I will be taking the class it's like 2 and a half months another question another question from another student could you explain if .NET is server or client-side programming these are server-side programming only client-side is javascript, html whatever it is it is pure server-side programming sheshop.net, asp.net we are going to discuss that is a server-side programming still we will be taking help from the javascript it is a client-side programming it is required as well for our anything we are doing validation still that and also we will be discussed as part of this syllabus that you can see here in syllabus we mentioned that also introduction to web technology javascript is there here we will be discussing about javascript as well as part of the course any other questions the entire class or entire course asp.net when is this course going to start other question it's already started only one or two classes done if you can join then it will be easy for you to pick up the classes so that one or two classes I will be taking you guys separately then we will club into the regular class please ask me if you have any other questions other question is do you teach basic programming definitely from basic to advanced this course will be covering these are all basic things we will be covering see here when you look at the syllabus these two chapters will be discussing about theoretical part and from here only we will be starting a programming thing from five windows ones hello world compiling anything why do we need to study all the things are very very basic things I will be giving examples for each topics then I will be making you to understand then only I will be moving to the next topic everybody in the class should understand then only we will be moving to the next topic thank you Sarita any other questions please let me know so that the question which you are asking it will be helpful other students also yeah you are welcome Polina yes the next question is how is the dotnet market I know java is open source but dotnet is not exactly the one is correct but these two are very much competitive in the dotnet market java and dotnet definitely you will be getting jobs in the market of dotnet more because there are many options are available if you learn java only java will be there in dotnet you can learn shishop, asp.net, vb.net any other languages also you can learn so there is more chances for you to get jobs under the dotnet still there is a big debate will be there java and dotnet in the internet some guys will say java is good some guys will say dotnet is good forget about that it's up to us that which one to select and it is depend on our interest as well which one we want to learn there are more jobs available for dotnet thank you yes the other question is does dotnet need to be upgraded periodically in terms of knowledge skills yes I should agree for this correct not only dotnet whatever the technology you are taking whatever language you are learning everyday or every time you need to upgrade yourself being it is a software industry it should be in a position that it should catch the new things which are getting everyday otherwise you will be not treated as learner or the things which are getting you are not taking into the world resume yes that is the first level is junior developer and again in organizations in different organizations different positions will be there that name will be different sometimes some organization called junior developer assistant engineer like that it is like a fresher kind of jobs you will be finding forget about the name they had given it is like entry engineer how do you get experienced as a senior I did not get your question how do you get experienced so as yes say if you want to get experience you should work in something else so only you can get it and again it is depending on the performance you are providing in your company and you will be there reviews of your performance depending on that performance reviews will be promoted to senior developer it is not like fix number of years to get senior developer it depends on again in your organization sometimes some guys wanted to make you to put in a senior developer position they can make it you after 2 years or 3 years what is the toughest part where you see students struggle a bit the toughest part is logical thinking say some students will be lacking logical thinking those who do not have logical thinking it is a toughest part the only thing in this IT industry for a developer is to have logical thinking if you have any more questions please drop an email to here for technical things will always be helpful you welcome thank you for attending we will meet again if you are going to join the class thank you bye