Home
Search results “Visual studio project user options file”
C# - How to save user settings
 
05:56
Instead of working with custom INI files save user settings using the .Net Framework by Fabio Scopel
Views: 69379 Fabio Scopel
C# how to associate file extension with application
 
18:19
In this tutorial i will show you how to associate file extension with your application and open file by just double-clicking them in windows explorer.
Views: 16551 Dawisko1
How to Create Setup Installation File in Visual Studio
 
12:15
How to Create Setup Installation File in Visual Studio. In this Tutorial, we will discuss how to create setup file like exe as well as msi installer using visual studio installer projects With a Sample Project. Best C# Books from Amazon (Affiliate) : ➤ http://geni.us/O6o6pe Download Project From : ➤ https://goo.gl/tExudr Buy me a Coffee (Channel Support By Donation) ➤ https://goo.gl/bPcyXW Subscribe to this channel ➤ https://goo.gl/RFY5C2 Link to this video ➤ https://youtu.be/tiHBwAp_Kz4 Our Website ➤ http://www.codaffection.com ______________ ✪ Related Links ________________ ✪ Picture Puzzle Game : https://goo.gl/8PdxnF ✪ MSI Installer Vs Exe Installer : https://goo.gl/KzMk7h ______________ ⌘ Social Media Links ________________ Blog : http://www.codaffection.com Facebook : https://www.facebook.com/codaffection Google plus : https://plus.google.com/+codaffection Twitter : https://twitter.com/codaffection Youtube : https://youtube.com/codaffection ______________ ↪ About this Channel ________________ CodAffection - for passionate programmers. This channel is all about teaching and inspiring developers to build applications/ websites in various technologies like Angular, NodeJS, Asp.Net MVC, JavaScript, SQL, React, Python etc. 2 Videos per Week - 12:30 PM UTC On MON and THU ______________ ₪ All Playlist ________________ https://goo.gl/gvjUJ7 : Asp.Net MVC https://goo.gl/ahk39S : Angular 5 https://goo.gl/viJcFs : Node JS https://goo.gl/itVayJ : Web API https://goo.gl/YJPPAH : MEAN Stack https://goo.gl/s1zJxo : C# Tutorial https://goo.gl/GXC2aJ : Asp.Net WebForm https://goo.gl/vHS9Hd : C# WinForm https://goo.gl/MLYS9e : MS SQL https://goo.gl/Ha71kq : Angular 4 https://goo.gl/5Vou7t : Crystal Report https://goo.gl/EPZ69B : Common C# Excercises https://goo.gl/qEWJCs : CG Exercises in C Program
Views: 79996 CodAffection
Visual Studio 2010 How to Create Setup Project Install Run and Uninstall a Program
 
16:34
🎓 Keep going, I’ll cheer you up! 🎓 🎉 Good news!!! if you are a student, you can call to consult your project development with me #iBasskung for free. 📡 This is the Live Project Editing Service (LPES) for my Udemy students and those who watch videos from my YouTube channel (👨‍🎓👩‍🎓 Only!). 📺 My Udemy: Online Course: https://www.udemy.com/vbnet-crystal-reports 📺 My YouTube Channel: 📽 https://www.youtube.com/c/iBasskung 📝 Note: Free service for everyone. No age limit around the world. 📞 Please feel free to contact me at any time: 📖 Facebook pages: 📌 Code A Minute 📌 IBasskung Tutorial 📌 Code with iBasskung 📌 IBasskung Guitar // ** // 🎥 Microsoft Visual Studio 2010 (VB.Net 2010) : How to Create Setup Project Install Run and Uninstall a Program (Create .exe file). 🙏 Subscribe for more ➜ http://bit.ly/2zAg8Ag ================================ 🚀 Online Programming Courses + Free Souce Code! 🚀 👨‍💼 Please check out my online course on Udemy: 🎥 Visual Basic .Net, Access Database, EAN-13 Barcode Generator, and Crystal Reports using a Project-Based Approach. "The Point Of Sale (POS) System". 🌟 Enroll Now. You can get started on your first lesson right away 🌟 🛒 http://bit.ly/2uTJcR9 ================================ 🎁 Buy Now! and Get the following 3 projects for free! 🎁 1. Point Of Sale (POS System) used in this course. 🛒 http://bit.ly/2uTJcR9 2. VB.Net (UAM) - Personnel Management 🎗 (Video Tutorial) : http://bit.ly/2wkrxWv 3. C# (UAM) - Personnel Management 🎗 (Video Tutorial) : http://bit.ly/2JBhLlL ================================ ⛳ Follow me around ⛳ ✔ Want to get updates on new courses or other cool free stuff? Just follow me on social media if that's your thing! Facebook pages (3): 📍 (Code A Minute) https://www.facebook.com/CodeAMinute 📍 (iBasskung Tutorial) https://www.facebook.com/IbasskungTutorial 📍 (Code with iBasskung) https://www.facebook.com/codewithibasskung YouTube Channel: 📍 https://www.youtube.com/c/iBasskung Twitter: 📍 https://twitter.com/#!/IBasskung 💯 THANK YOU SO MUCH! 💯 #vb #vbnet #visualbasic #visualbasicdatabase #RetailPOS #PointOfSale #POS #EmployeeTrainingManagement #EmployeeManagement #EmployeeManagementSystem #EmployeeTrainingRecords #PersonnelManagement ##PersonnelManagementSystem #BankManagementSystem #BankingManagementSystem #BankManagement #Software #javaforandroid #CodeAMinute #iBasskungTutorial #VisualCSharp #CSharp #Programming #MicrosoftAccess #AccessDatabase #SQLServer #MySQL #SQLite #phpMyAdmin #CrystalReports #EAN13BarcodeGenerator #Udemy #OnlineCourses #YouTube // ** // English Tags: vb vb.net visual basic visual basic access access database visual basic database how to connect database to vb.net how to connect access database to visual studio 2010 how to connect database to visual basic 2010 how to connect microsoft access database to visual basic 2010 programming in visual basic .net how to connect access database to vb.net database connectivity in vb.net vb.net login using access database vb.net login form using access database login form in vb.net with database access visual studio access database vb.net connect to database vb.net connect to access database Thai Keywords: เรียน เขียน โปรแกรม สอน เขียน โปรแกรม เขียน โปรแกรม vb.net สอน เขียน โปรแกรม ออนไลน์ เขียน โปรแกรม vb เรียน โปรแกรมเมอร์ โปร เจ ค จบ เขียน โปรแกรม ขาย สินค้า เรียน เขียน โปรแกรม ที่ไหน ดี โรงเรียน สอน เขียน โปรแกรม การ เขียน โปรแกรม visual basic
Views: 106287 iBasskung
Reading the Configuration from App.config file
 
22:12
In this video, we are going to discuss how to read the configuration from App.config file. For this we will take the help of System.Configuration utility of the Visual Studio. https://www.udemy.com/learn-testng-testing-framework-from-scratch/?couponCode=50 https://www.udemy.com/test-automation-with-selenium-webdriver/?couponCode=50 https://www.udemy.com/web-automation-using-selenium-rc-from-scratch/?couponCode=50 https://www.udemy.com/automation-testing-using-junit/?couponCode=50 Discount coupon https://www.udemy.com/automation-testing-using-junit/?couponCode=50PERCENT https://www.udemy.com/learn-testng-testing-framework-from-scratch/?couponCode=50PERCENT https://www.udemy.com/web-automation-using-selenium-rc-from-scratch/?couponCode=50PERCENT https://www.udemy.com/test-automation-with-selenium-webdriver/?couponCode=21PERCENTOFF https://www.udemy.com/bdd-with-selenium-webdriver-and-speckflow-using-c/?couponCode=21PERCENTOFF https://www.udemy.com/web-service-testing-using-apache-httpclient/?couponCode=DISOUNT50
Views: 14709 Rahul Rathore
Visual Studio 2010-Creating a Setup Project and adding File Types.mp4
 
12:25
Hi guys, I have uploaded this Video, with clean sound on my New Channel (http://www.youtube.com/user/theindiancoder/). Please do check it out for more videos of mine. I will not be using this channel anymore to add my Videos...
Views: 165937 Piyush Agarwal
HOW TO ADD HELP CHM FILE TO VB 2013 PROJECT
 
07:54
In software, there is a compiled Html help files that comes with it-the help file. Microsoft has a help file maker on its site. This file file usually comes with the extension .chm. This tutorial seeks to show how to add this type of file to your visual basic project. The mixcraft help file is just an example file. You can create your own with applications like helpsmith, helpmaker-my favorite, and offcourse microsoft helpmaker-free
Views: 5805 Mark Kwagbedzie
How to Export Programs as '.exe' (Visual Basic 2012, 2010, 2008, 2006)
 
02:39
This is how you export your program as an executable file, no coding required! If you need any help, or for some reason it doesn't work, just leave me a comment or a personal message. Steps (in order): 1. Select 'Project', 2. Then select '(Your Project Name) Properties', 3. Then select 'Publish' from the menu to the left, 4. Then where it says 'Install Mode and Setting' select 'The application is available online only', 5. Then select 'Prerequisites', 6. Then uncheck 'Create setup program to install prerequisite components' at the top, 7. Then select 'Options', 8. Then select 'Deployment' from the menu to the left, 9. Then uncheck 'Use ".deploy" file extension', 10. Then go ahead and publish! Please take the time to rate, and also subscribe and I plan to make more tutorials, and other videos focused on Visual Basic in the future. Music: 'This is Felicitus'-K-391 www.youtube.com/TheK391 www.facebook.com/TheK391
Views: 142509 iPCPhysics
How to Set Up Python in Visual Studio Code on Windows 10
 
16:21
In this video I am going to show How to Set Up Python Development environment in Visual Studio Code in windows 10. I am also going to show ow to debug your python code using vs code. This process will also cover How to Install Python and Visual Studio Code for Windows 10. -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 383080 ProgrammingKnowledge
Visual Studio Projects and Solutions
 
12:17
Learn the differences between projects and solutions, as well as how the two interact. To sign up for announcements about new videos and other training resources, fill out this form: http://eepurl.com/btLrsH (your email will be kept safe and you will not be spammed). -~-~~-~~~-~~-~- Please watch: "Top 10 C# Best Practices (plus bonuses)" https://www.youtube.com/watch?v=-9b8NRqjUFM -~-~~-~~~-~~-~-
Views: 59229 IAmTimCorey
openHAB 2 Basics - Editing Configuration Files | Installing Visual Studio Code
 
12:02
In this openhab 2 Basics video, I show you a complete step-by-step guide on setting up Visual Studio Code (VSCode) and the openhab extension by Kuba Wolanin, and show you how to use it to edit your items, sitemaps, rules, etc..I also show how to connect it to the openhabianpi and use the samba share to map it as a folder in Windows, for easy access to all openhab 2 configuration files. I'll also show how to use the built in preview window in Visual Studio Code to test your sitemap configuration for the Basic UI by using the Demo configuration we set up in the previous video. In this new series, I'll take you through the entire process from starting up with openHAB, to developing advanced rules and home automation functionality. Keep an eye out for future videos and subscribe to my channel! --- JOIN OUR DISCORD SERVER (https://discord.gg/jUr7J4u) for DIY electronics, home automation and other discussions! --- LINKS TO EQUIPMENT/PARTS USED (AFFILIATE): -Raspberry Pi kit w/case and power supply - https://amzn.to/2NMiceN -32GB Sandisk microSD card - https://amzn.to/2NORDFv -32GB Sandisk USB Drive - https://amzn.to/2LgvSg8 -USB SD/microSD Card Reader/Writer - https://amzn.to/2Ld4oZ2 --- LINKS TO INFORMATION/SITES: -openhabianPI Project/Image - https://github.com/openhab/openhabian/releases -openhabian Forum Topic - https://community.openhab.org/t/openhabian-hassle-free-openhab-setup/13379/1218 --- Thanks for watching my videos! If you want to support the channel, subscribe! You can also support me in the following ways: Patreon: https://www.patreon.com/BKHobby --- LINKS TO YOUTUBE GEAR: -Canon T3i camera - https://amzn.to/2LZGjbJ -Manfrotto Tripod - https://amzn.to/2AC5pZF -Rode Procaster Dynamic Mic - https://amzn.to/2KnsTkM -Behringer U-Phoria UMC22 USB Audio Interface - https://amzn.to/2MfoaDz --- Check out my (mostly functional) 3D designs - (https://www.thingiverse.com/bkpsu/about) ! If you like them and want to support my projects, use one of the links below when you're planning to buy anything from these sites (it won't cost you anything extra!). Thank you in advance! Banggood: https://goo.gl/uXGg84 AliExpress: https://goo.gl/KRNurW Amazon: https://goo.gl/nWhmjJ
Views: 34529 BK Hobby
Advanced Installer - Visual Studio Extension for setup projects
 
03:01
Create setup packages directly from Visual Studio with the Advanced Installer extension for VS. http://www.advancedinstaller.com/user-guide/ai-ext-vs.html Advanced Installer an application designed for building MSI and AppV packages, deploying applications updates, repackaging, MSI/MST editing... http://www.advancedinstaller.com/ http://www.advancedinstaller.com/feats-list.html http://www.advancedinstaller.com/download.html
Views: 25099 Advanced Installer
The log4net Tutorial: Logging in C# (hands-on from beginner to advanced)
 
01:37:46
To sign up for announcements about new videos and exclusive discounts, fill out this form: https://iamtimcorey.com/general-sign-up (your email will be kept safe and you will not be spammed). This video will teach you how to use log4net without fear. Instead of copying and pasting confusing config files that cause more problems than they solve, watch this video and you will understand how to make log4net do exactly what you want. You will be taken through step-by-step through the following sections: 1. Getting Started - installing log4net, initial configuration and getting it running in your code. 2. .NET 4.5 Changes - What additional options you have if you are using .NET 4.5. 3. Appenders - How to log to different data repositories like SQL Server, text files and more. 4. Filters - How to log only the data you want to capture while ignoring the rest. This will cover both the simple options as well as the more advanced possibilities. 5. Log Patterns - Learn how to capture a number of different pieces of data, what the pitfalls are of some data points and how to send data to your data source. 6. Advanced Logging - Take logging to the next level by capturing custom data in your own fields. Even capture data at the time of the error without any extra configuration. 7. Wrap Up - Review what has been learned and identify how to move forward with log4net. This video course is easy for a beginner to get started with but even if you didn't know anything coming in, if you follow the steps outlined in the video, you will become an advanced log4net user by the end of the video. The entire video is a hands-on demonstration of not just what to do but how to do it. You will be able to follow along with the video with ease. Also provided is a link to the source code for this video. The source code has been tagged at the end of each section to indicate where you can revert to in order to see the code at any point in the video. Course Resource: Course code: https://github.com/TimCorey/Log4netTutorial log4net Code Project article: http://www.codeproject.com/Articles/140911/log-net-Tutorial log4net homepage: http://logging.apache.org/log4net/ Video Quick Use Guide: 4:35 - Step 1: Add log4net package 5:25 - Step 2: Add log4net configuration 18:54 - Step 3: Add log4net assembly 20:47 - Step 4: Create log4net log reference 25:30 - Step 5: Log messages 27:56 - Creating LogHelper 32:37 - Appenders 1:04:46 - Filters 1:14:13 - Conversion pattern
Views: 110099 IAmTimCorey
How to create Setup exe file in Visual Studio 2017 2015 or 2013
 
11:41
in this video I teach how to create setup project in visual studio, you can download the template from this site: https://marketplace.visualstudio.com/items?itemName=UnniRavindranathan-MSFT.MicrosoftVisualStudio2013InstallerProjects Websites https://www.paypal.me/jocheojeda https://www.facebook.com/xafes/ https://www.facebook.com/xamarines/ https://www.facebook.com/BITFrameworks/ http://www.xamarin-android-apps.com/ http://www.xamarin-forms-apps.com/ http://www.xamarin-ios-apps.com/ https://www.youtube.com/c/JocheOjedaXAFXAMARINC http://www.vimeo.com/jocheojeda
Views: 142836 Joche Ojeda
Creating Web Test and Load Test using Microsoft Visual Studio
 
14:15
Contact me under: romankapela at gmail.com. Quick and easy example of how to create Web Performance Test and Load Test using Microsoft Visual Studio. I go through the simpliest way of creating Web Test recording, I'm also showing how to add Validation and Extraction Rules. Then I data bind the data source to the test. Finally I show how to create the load test, by utilizing the Web Test created. I also show how live changes to the web page code influence the performance of the application.
Views: 96402 Test Band
Creating angular 6 project
 
07:02
This is Part 1 of Angular 6 Tutorial for beginners. In this video 1. We will set up the development environment by installing the tools required for Angular 6 development 2. Create a brand new Angular 6 project using Angular CLI Text version of the video http://csharp-video-tutorials.blogspot.com/2018/08/creating-angular-6-project.html Slides http://csharp-video-tutorials.blogspot.com/2018/08/creating-angular-6-project-slides.html Angular 6 Tutorial https://www.youtube.com/playlist?list=PL6n9fhu94yhWNJaDgh0mfae_9xoQ4E_Zj Angular 6 Tutorial Text Articles & Slides http://csharp-video-tutorials.blogspot.com/2018/09/angular-6-tutorial-for-beginners.html Angular, JavaScript, jQuery, Dot Net & SQL Playlists https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd Pre-requisites Basic knowledge of Angular and Angular CLI If you are new to Angular, please check out our Angular 2 course and https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular CRUD course https://www.youtube.com/playlist?list=PL6n9fhu94yhXwcl3a6rIfAI7QmGYIkfK5 If you are new to Angular CLI, please check out our Angular CLI course https://www.youtube.com/playlist?list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Setting up Angular 6 Development environment Step 1 : Install Node and NPM using the link below. https://nodejs.org/en/download/ You need Node version 8.x or greater and NPM version 5.x or greater. To veriify the version of NODE and NPM you have, execute the following 2 commands using the command prompt window. Make sure you are running the command prompt as an administrator. node -v npm -v If you already have NODE and NPM installed and if you want to upgrade to the latest version simply download and run the installer again, and it will automatically update NODE and NPM to the latest version. Step 2 : Install Angular CLI. It is a command line tool that help us create angular applications quickly and easily while still following angular's best practices and conventions. It's a great tool to increase your productivity as an angular developer. If you do not have Angular CLI installed already, execute the following command and it will install the latest version. npm install -g @angular/cli If you already have Angular CLI installed, and you want to upgrade to the latest version, then execute the following command npm install -g @angular/[email protected] Step 3 : Download and install Visual Studio Code https://code.visualstudio.com/download Create a new Angular 6 project using the Angular CLI : Step 1 : Run the command prompt window as an administrator Step 2 : Execute the following command to create a new Angular 6 project. ng new Angular6Project -d Command Explanation ng - Is the Angular CLI new - For generating a new project Angular6Project - Is the name of the project -d - This is dry-run flag. This flag instructs Angular CLI just to list the files it's going to create. It does not actually create them. This is a great option, because it lets us see what files will be generated without actually generating them. In our case, we do not want test files to be generated so let's also use --skip-tests option to skip generating test files. The following generates a new Angular 6 project and all the required files. Notice, we have not used -d option, so Angular CLI will create the Angular project and all the required files. ng new Angular6Project --skip-tests Running the Angular 6 Project 1. In the command prompt window, use the following command to go to the project directory cd Angular6Project 2. Execute the following command to run the Angular 6 project. This command builds, launches your default browser and serves the application using the default port number 4200 (http://localhost:4200/) ng serve --open (short cut command : ng s -o) At this point you will see the following on the browser Welcome to Angular6Project! This message is coming from the root component AppComponent. The project structure and the files in angular project have not changed much between Angular 5 and Angular 6. One change I can point out at this time is the Angular CLI configuration file. Prior to Angular 6, the Angular CLI configuration file is called angular-cli.json. In Angular 6, it is renamed to just angular.json. It's not a simple rename, the file format is also slightly different. In the generated project there are several files and folders. If you are new to these files and folders, please check out Parts 7 and 8 from Angular CLI tutorial. https://www.youtube.com/playlist?list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_
Views: 221787 kudvenkat
VSCode Tutorials #4 - Git Integration
 
07:49
Learn about Visual Studio Code and why it's an exciting new text editor. Subscribe for more free tutorials https://goo.gl/6ljoFc Learn Meteor & React for modern real-time apps. https://www.leveluptutorials.com/store/products/tutorials/lut-dd012 Support Free Tutorials https://www.leveluptutorials.com/store/ The best shared web hosting http://www.bluehost.com/track/leveluptutorials/ Subscribe to Level Up Pro for extra features! https://www.leveluptutorials.com/store/products/pro Subscribe to the Level Up Newsletter http://eepurl.com/AWjGz To Support Level Up Tuts: http://leveluptuts.com/donations Simple cloud hosting, built for developers.: https://www.digitalocean.com/?refcode=67357174b09e Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with built-in support for JavaScript, TypeScript and Node.js and has a rich ecosystem of extensions for other languages (such as C++, C#, Python, PHP, Go) and runtimes (such as .NET and Unity).
Views: 95377 LevelUpTuts
Publish a Website with IIS from Visual Studio 2012
 
07:29
A short video showing how to use IIS to publish a website from Visual Studio 2012.
Views: 217333 Richard W
How to deploy an ASP.NET website using Umbraco as an example
 
22:29
This video gives you step by step instructions for how to deploy an ASP.NET website. I'm using an Umbraco site as an example, but it applies to any ASP.NET website. Create configurations and transforms Create different configurations Create config transforms for UAT and LIVE Delete Debug and Release Make sure all of the required files are included in the build Publish the web project Right click on the web project, and choose Publish Select a publish target, choose Custom Enter a profile name. You want one for each configuration. I'll start with UAT In publish method, choose File System In the target location, choose a relevant folder, if it doesn't exist it will create it for you. Click next Choose the configuration, so I will choose UAT File publish options, tick Delete all existing files prior to publish Click next Look at the path where it will be published to, make sure it is correct. Click on Publish Look at the output, make sure it builds correctly and outputs the files to the destination location. Now go to the folder where the files are, add them all to a zip file, with a name such as ProjectName YYYY-MM-DD.zip Saving the file in this format means even if they are sorted alphabetically they will be in the correct date order. Put the files onto the server Log onto your server using Remote Desktop (RDP) If you don't have a server, you could practice doing this on your computer. On the server, navigate to the web root folder, normally called wwwroot, could be in C:\inetpub Create a folder for the web project Paste the zip file inside this folder Right click, extract all Delete the zip file Sort out folder permissions Make sure the following users have permission to modify this folder: IUSR, IIS_IUSRS Backup the local database Open SQL Server Management Studio Connect Open out the databases tree view on the left Right click on the database for your project Choose tasks and backup In the destination section, choose disk Remove any that are already in the list below and click on add Choose a destination folder and put the name of the file in, something like ProjectName-DB-YYYY-MM-DD.bak, click on OK Click on OK in the main window. Create a database on the server Go to the destination folder where the backup is saved. Right click on it and add it to a zip file On the server, paste the db zip file somewhere. Right click, extract all Open SQL Server Management studio Connect to the server If you don't have a database already, right click on databases and choose New Database. Name it after your project, I like to add .UAT or .LIVE after the name. In options make sure the SQL version is the same as the database on your local machine. Restore the database using the backup Right click, tasks, restore In device, choose the backup file ending .bak In the dropdown, choose the database from the backup. In the destination dropdown choose the new or existing database on the server for the project Go to the files page, choose the relevant mdf and log files In options, make sure overwrite the existing database is ticked. Click on OK Sort out database permissions Under security, go to users and create a new login. Username, password etc SQL only In User mappings tick this database, reader, writer owner. Setup a site in IIS Create a site in IIS Point the site the dated folder you created Add the website url as the binding, e.g. mine is uat.fionawhitfield.com Start the site Eliminate any errors Make sure the connection string is correct ► Buy me a coffee ◄ https://codeshare.co.uk/coffee
Views: 5316 Paul Seal
Copying a Project in Visual Studio
 
02:01
The folder names and the setting names work separately in Visual Studio. Renaming a solution or project in Visual Studio doesn't rename the folders, and the same for the other way around too. This video explains how to change both the solution and project names (which updates the file names too), as well as rename the folders. Sorry about the breath sounds. They annoy me too on people's videos. This is why I usually avoid recording audio on my screen casts. At least I don't snap my tongue, so I've got that going for me, which is nice.
Views: 62967 Scott Pigeon
Part 2   Consuming a web service
 
15:47
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/11/part-2-consuming-web-service.html Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Here are the steps to consume the web service that we have created in Part 1. Step 1: Right click on WebServicesDemo solution in solution explorer and add new asp.net web application project and name it CalculatorWebApplication. Step 2: Now we need to add a reference to web service. To achieve this a) Right click on References folder in the CalculatorWebApplication project and select Add Service Reference option b) In the Address textbox of the Add Service Reference window, type the web service address and click GO button. In the namespace textbox type CalculatorService and click OK. Step 3: Right click on CalculatorWebApplication project in solution explorer and add new webform. Step 3: Copy and paste the following HTML Get the HTML for the page from my blog as youtube doesn't allows HTML in the description of the video. Step 4: Copy and paste the following code in the code-behind file protected void btnAdd_Click(object sender, EventArgs e) { CalculatorService.CalculatorWebServicesSoapClient client = new CalculatorService.CalculatorWebServicesSoapClient(); int result = client.Add(Convert.ToInt32(txtFirstNumber.Text), Convert.ToInt32(txtSecondNumber.Text)); lblResult.Text = result.ToString(); } In an interview the interviewer may ask you the following questions related to consuming a web service. 1. What is WSDL and what is it's purpose 2. How is a proxy class generated 3. What is the use of a proxy class 4. What actually happens when a web service reference is added The following 2 paragraphs should provide the answers for the above questions Visual studio generates a proxy class using the WSDL (Web Service Description Language) document of the web service. The WSDL document formally defines a web service. It contains 1. All the methods that are exposed by the web service 2. The parameters and their types 3. The return types of the methods This information is then used by visual studio to create the proxy class. The client application calls the proxy class method. The proxy class will then serialize the parameters, prepares a SOAP request message and sends it to the web service. The web service executes the method and returns a SOAP response message to the proxy. The proxy class will then deserialize the SOAP response message and hands it the client application. We don't have to serialize or deserialize dot net CLR objects to and from SOAP format. The proxy class takes care of serialization and deserialization and makes the life of a developer much easier.
Views: 273871 kudvenkat
How to unlock Protected Excel VBA Project and Macro codes without password
 
06:27
Doesn't work? Try this tool - https://youtu.be/4eO7e1Xu__w Wanna buy Coffee for me? Here you go http://bit.ly/buyCoffee Title: How to unlock Protected Excel VBA Project Macro codes without password or using any paid software If you need my assistance to unlock the Excel VBA, I'm offering this as paid service. I'm charging $5/Workbook. Kindly get in touch with me http://www.amarindaz.com/contact Blog: http://www.amarindaz.com/ Facebook Page:http://facebook.com/amarindaz Recommended Excel VBA books =================================================== http://www.amarindaz.com/go/excel-vba-24-hour-trainer/ http://www.amarindaz.com/go/excel-2016-power-programming-vba/ http://www.amarindaz.com/go/excel-2013-power-programming-vba/ ==================================================== If you have ever forgotten a password for the VBA Projects then you know how frustrating that can be. No needs to worry any more and in this video, you'll learn how to unlock VBA Project and codes which get stored in it. In this method, you no need to use any paid software to unlock VBA Macro Code. You can download the free Hex Editor tool from http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm Follow the below simple steps to unlock the Protected Excel VBA project Step 1 Make a copy of your Macro enabled xlsm workbook. Step 2 Change the file format of the Macro-enabled workbook from xlsm to zip Step 3 Unzip the zip file. Go to xl folder and inside that you'll find a binary file called "vbaproject.bin" Step 4 Open the VBA Project binary file using Hex editor. Find the word "DPB" and replace that with "DPx". Save the VBA Project binary file and close it Step 5 Come back and zip it again with any naming convention but with extension .xls Step 6 Go to VBA Project- Tools- VBA Project properties. Unchecked the option Lock project for viewing in the Protection tab. Save and close the workbook Step 7 Open the same workbook and now you can able to see the Modules and code reside in that. Congratulations You've successfully unlocked the VBA project code without using the password Please let me know if you have any doubts. Please subscribe!!!
Views: 155432 Amarindaz
How to Create (.exe) Setup File in Visual Studio 2015 for windows application? - Step By Step
 
13:52
Create Music Player App - http://bit.ly/create-music-player-app-in-c-sharp Download Visual Studio Installer Projects - https://marketplace.visualstudio.com/items?itemName=VisualStudioClient.MicrosoftVisualStudio2015InstallerProjects Download Free Icon - https://icons8.com/ Convert Icon to .ico file type - https://www.icoconverter.com/ ---------------------------------------------------------------------------------------------------------------- Other Tutorial Series BILLING SYSTEM in C# - http://bit.ly/billing-system-in-c-sharp-free-tutorial Simple Desktop App (E-Contact) - http://bit.ly/e-contact-app-in-c-sharp ---------------------------------------------------------------------------------------------------------------- Hello Everyone, Welcome to my channel (Vijay Thapa). In this, tutorial We'll create a simple setup (.exe) file for our simple music player we created in previous app (the link is in the top of this description). After we create the setup file, we'll be able to share our app with our family, friends even to our clients. At first, we need to download and install "Microsoft Visual Studio Project Installer" (link in the description above), which will allow us to create setup file easily. Then we need to create a icon for our App. If you're a good graphic designer then you can design your own. Else, we will download from icons8.com and download the icon to use in our app's setup file. Finally, we'll create the setup file in Microsoft Visual Studio, using all of these resources. So, Good Luck and Enjoy the Tutorial. LIKE, SHARE and SUBSCRIBE.
Views: 10380 Vijay Thapa
.NET Application Configuration
 
09:15
How the App.config file works and how to read appSettings from it.
Views: 3723 Wallace Kelly
VSCode Extensions - Git Lens
 
04:01
In this video we look at the Git Lens VSCode Extension. If you use VSCode and git as your "version control system" in any of your personal or work projects, then I think you are going to like this! https://marketplace.visualstudio.com/items?itemName=eamodio.gitlens
Views: 28787 Manorisms
How to create a Setup Project in Visual Studio 2012 and 2013 - Part 1
 
19:47
This short video walks you through how to create a new Setup and Deployment Project in Visual Studio 2012 using the new InstallShield Lite Project Type and how to add your project output to the installer and create the installer. Website: http://www.digioz.com
Views: 252811 DigiOz Multimedia
C# - Saving Application Settings
 
03:36
How to save the application settings in c# using application properties.
Views: 23327 DeveloperCSharp
CA Harvest SCM V13 0 3 Release Overview
 
04:19
In this video, let’s review the high-level overview of features that are added in this release. Cross-Project Merge—New Visual Interface from Workbench BizTalk Server Projects—Support in Visual Studio Plug-in Bulk Update Projects Remove User from User Group Reorder Linked Processes Workbench List View Performance Improvements in Listing Large Folders and Files Work Area Synchronisation Performance Improvements Cross-Project Merge—New Visual Interface from Workbench Provides you the transparency, and ability to select, preview, and resolve the conflicts / changes and validate the merge changes Cross-Project Merge - New Visual Interface from Workbench Through latest CPM, folder merge conflict is resolved. With the new CPM you now have a provision to select the required merges from selected packages for cross project merge. You can Merge New Paths/Items from Source Project You can Merge Rename Paths/Items from Source Project You can Merge Move Paths/Items from Source Project You can Merge Remove Paths/Items from Source Project BizTalk Server Projects - Support in Visual Studio Plug-in The current release supports your Visual Studio with BizTalk Server Project Templates Bulk Update Projects Expedites the Process and Access administration of Harvest projects simultaneously with the criteria of doing it once and replicating the same. add a new process delete a process modify access type and linked processes of existing processes access maintenance at state and project level of several projects simultaneously Remove a User from User Group This release lets you remove the user group association for the user by specifying the -rug (remove user group) option. Reorder Linked Processes Supports the reorder of execution for the linked process by clicking the up and down arrows on the Pre- and Post-Linked tabs. Workbench List View Preferences Improvements in Listing Huge Number of Folders and Files SCM List View is introduced to eliminate the delay of listing files in case of huge number of files under a package or a view path. Workbench List View Preferences Improvements in Listing Huge Number of Folders and Files Work Area Synchronisation Performance Improvements Enhanced performance improvements from frustrating experience to improved customer satisfaction For more information, Visit CA Harvest Software Change Manager Product Page and CA Harvest Software Change Doc Ops Space. Thank you for watching this video.
Views: 58 CA Harvest SCM
VSCode Settings.json | Switch back from Settings UI to Settings.JSON | VSCode.pro
 
02:50
[Part of the https://VSCode.pro course] — VSCode recently stopped displaying the split of VSCode default settings and users settings along with the settings.json file — hacker in me doesn't like the new UI Settings so — I moved them back. - 🔥 Learn to become a VSCode Power User → https://VSCode.pro/ - 🐦 Twitter: https://twitter.com/MrAhmadAwais - ✍️ Blog: https://AhmadAwais.com - 😮 GitHub: https://github.com/AhmadAwais - 🔗 LinkedIn: https://linkedin.com/in/MrAhmadAwais - 🔗 YouTube: https://YouTube/AhmadAwais P.S. If you like my work, feel free to share it, like it, and subscribe to my YouTube channel. Peace! ✌️ → Video Transcript: 🎸 (MUSIC PLAYING) While I was working with VSCode.pro course, one thing happened. Visual Studio kept updating every single month. Now if you press COMMAND (⌘) + COMMA (,) or if you press COMMAND (⌘) + SHIFT (⇧) + P and search for settings and open the settings, you get a shinny new UI, the user interface for settings area. But the hacker in me doesn't really like it. And throughout this course, I'll be teaching you to configure all the different settings through this particular file "settings.json" So, how about we go ahead and make this our default settings for the time being. Press COMMAND (⌘) + SHIFT (⇧) + P search for settings And click on Open Settings. Now search fro Settings again. And as you can see Workbench does settings that determines which setting editor to be used by default is set to UI. I want you to go ahead and set it to json. As soon as you do it, this bar basically indicates that this setting has been updated. After setting your Settings Editor to JSON Go down here, or search for "Use Split JSON" E.g. "Settings Use Split JSON" – and you'll meet this particular setting Here I want you to go ahead and check mark this setting It should be check marked so that you can see a split of All of your default settings as well as your "settings.json" file E.g. now if I press COMMAND (⌘) + COMMA (,) Your settings will look like this! You will have the "Default User Settings" on the left and your "User Settings" on the right. This is very important for this course becuase in this entire course I'll be doing all of the settings and searching for them through this area. Now if I go back and press COMMAND (⌘) + COMMA (,) The "settings.json" file opens up. That is exactly what we want for this course But if you would still like to access the UI for Settings, what can do is press COMMAND (⌘) + SHIFT (⇧) + P Search for Open Settings — and here it is Open Settings UI. If you click it, you'll be in the UI of the settings. But we can set up a keyboard shortcut for that as well. To do that, you can either go from here to the keyboard shortcuts Or you can press COMMAND (⌘) + K then COMMAND (⌘) + S And access these keyboard shortcuts. Search for open settings — this is the setting we want. Open Settings UI Click on the plus icon (+) and let's type COMMAND (⌘) + PERIOD (.) Press [ENTER] Now if you press COMMAND (⌘) + PERIOD (.) you will be opening up the UI settings. And if you will press COMMAND (⌘) + COMMA (,) you will be opening up the normal JSON settings. Let's try it out. I am going to press COMMAND (⌘) + COMMA (,) and it opens up the settings.json file. I am going to press COMMAND (⌘) + PERIOD (.) and there you have it. A new shiny UI of settings. So that's about it. You can obviously set a different keyboard shortcut here but I tend to go with this one. 👍 Tweet your progress with #VSCODEpro @MrAhmadAwais
Views: 4643 Ahmad Awais
Angular CLI Create new project
 
08:18
In this video we will dscuss 1. How to create a new angular project from scratch using Angular CLI 2. Run the app 3. Run unit and end-to-end test In this course we will use Visual Studio Code as the editor. Visual Studio Code is free and you can use it on any platform - Windows, Mac or Linux. If you have not installed it already, please install it by downloading from the following link. https://code.visualstudio.com/download To create a new Angular Project, open Command Prompt as an Administrator and execute the following command. This command creates all the required files and also installs all the required packages. Depending on your computer and internet connection speed, this command takes a few minutes to complete. ng new MyFirstApp ng is the Angular CLI new for creating a new application MyFirstApp is the name of your angular application There are several options that we can use with "ng new". We will discuss all these options in our next video. Once the above command has completed successfully you will see the following messages. Installed packages for tooling via npm. Project 'MyFirstApp' successfully created. So what did this "ng new" command do A new folder with name MyFirstApp is created All the required configuration and source files are created. All the npm dependencies are installed in node_modules folder Unit and end-to-end tests are created The Karma unit test runner is configured The Protractor end-to-end test framework is configured We will discuss unit tests, end-to-end tests, Karma and Protractor in our upcoming videos. Please note that all these code and configuration files are created by the Angular CLI out of the box while still following the angular teams best practices and conventions. Now, go to the folder (MyFirstApp) that contains our angular project, by executing the following command. cd stands for change directory cd MyFirstApp Now execute the following command at the command prompt to open the project folder in Visual Studio Code. Notice there is a single space and a DOT after the word code. code . At this point in Visual Studio Code you will see all the Angular project files. Also notice node_modules folder, that conatins all the installed packages. We will discuss, what all these files are and their purpose in our upcoming videos. To run the project using Angular CLI, type the following command at the command prompt. This command builds the application and opens it in our default browser. The flag --open, launches our default browser and runs the application. By default the application runs on port 4200. We can change this port number if required. We will discuss how to do that in our upcoming videos. ng serve --open At the moment, the angular development server is running in watch mode, meaning when a file changes, those changes are automatically detected, compiled and the browser reloads to reflect the changes. This is called live reload. We can turn this live reload functionality off, if required. Again we will discuss how to do this in our upcoming videos. To stop the server, press CTRL + C while you are on the command prompt and then "Y" and ENTER key. This will stop the server. To run all the unit tests, use the following command ng test To run all the end-to-end tests, use the following command ng e2e We will discuss Unit tests, end-to-end tests and all the options we can use to run them using Angular CLI in our upcoming videos. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/09/angular-cli-create-new-project.html Slides http://csharp-video-tutorials.blogspot.com/2017/09/angular-cli-create-new-project_27.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 70690 kudvenkat
How to publish Asp.net website on internet
 
06:45
This video shows how to publish visual studio web application to godaddy WebServer(Pleask Hosting used for windows application) by using FTP account, create ftp user name and password and use at the time of connection creation from Visual Studio few things you should have for that Visual Studio 2015/2017 Valid Godaddy account with Pleask Hosting valid Domain name to host site vaild FTP account Rest watch the complete video to learn how it's work, in case you are facing any issue Connect on comment section below i will try to give my answer. This tutorial crated on visual Studio 2015, 2017 version is coming soon. if you don't know ★★★ how to create FTP account in Godaddy server ★★★ Check it out ➩➩https://www.youtube.com/watch?v=r-BUkZ6LiYg ★★★ How to create Copy/Clone of your Visual Studio Website/Project ★★★ Check it out ➩➩https://www.youtube.com/watch?v=qZ3A5oSLhRc ★★★ How to Upload a Website to Live server Using FileZilla ★★★ Check it out ➩➩https://www.youtube.com/watch?v=ZefCK178k6k ★★★ how to insert form data in database using c# asp.net5 ★★★ Check it out ➩➩https://www.youtube.com/watch?v=N11GEGqUDZA&t=22s ★★★ How to Embed Bootstrap to Visual Studio ★★★ Check it out ➩➩https://www.youtube.com/watch?v=EH1PNh4GT9I&t=11s
Views: 66599 Lernen Tech
Visual studio 2013 tutorial for Beginners | Ep12 | Saving user settings
 
08:41
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thanks for watching hope you enjoyed! if so don't forget to leave a like! until next time hope you guys have a great day! CHECK OUT MY WEBSITE HERE http://goo.gl/6okWTw FOLLOW MY TWITTER HERE https://twitter.com/TheGh0stHacker VISUAL STUDIO PLAY LIST HERE https://goo.gl/fZzk7M FOLLOW MT GOOGLE+ HERE https://goo.gl/pvXy0A EMAIL ME HERE [email protected] Don't forget to Like, Comment, Subscribe :D -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Views: 17473 TheGhostHacker
Visual Basic How To: Changing from 32Bit to 64Bit
 
02:46
A quick run through on changing your program from x86 (32 bit) to x64 (64 bit). Make sure this is on: Tools ⇒ Options ⇒ Projects and Solutions ⇒ General ⇒ "Show advanced build configurations" VB2010 link: http://go.microsoft.com/?linkid=9709929
Views: 45554 robomatics
Create Login Window With User Authentication in C# step by step
 
26:49
This video teach how to create login window in c#, You will learn about user authentication, Login form will check if user while admin or client after every form act as admin or client mode.. it will very use for beginner to learn c sharp in step by step
Views: 516057 Vetrivel D
How to create custom installers in Visual Studio
 
04:54
This video demonstrates how to create a custom setup.exe installer file in Visual Studio. This project does not work in the express editions.
Views: 47628 Factrocks
C# Tutorial 89: How to Publish an Application in C# and Make the Installation Setup
 
10:55
How to Create Installation Setup for Your C# Application Project Howto make setup file from project in VS2012 C# How to Create an Installer For a WinForm Application How to make an installer for my C# application? How can I deploy a C# application Deploying a C# application Visual Studio Create Setup project How to make setup file using VS 2010 in C# window forms How do I create setup in c# Create a simple installer from Visual Studio How make Setup installation file of my Completed C# project Make an Installation program for C# applications C# publish application properties
Views: 201817 ProgrammingKnowledge
Revit Architecture: Working with the Project settings | lynda.com tutorial
 
06:18
This Revit Architecture tutorial explores how to work with the Project settings, units, instance properties, and more. Watch more at http://www.lynda.com/Revit-Architecture-2011-tutorials/essential-training/62086-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-62086-0303 This specific tutorial is just a single movie from chapter three of the Revit Architecture 2011 Essential Training course presented by lynda.com author Paul F. Aubin. The complete Revit Architecture 2011 Essential Training course has a total duration of 8 hours and 30 minutes and covers the entire building information modeling (BIM) workflow, from design concept to publishing Revit Architecture 2011 Essential Training table of contents: Introduction 1. Core Concepts 2. Getting Comfortable with the Revit Environment 3. Starting a Project 4. Modeling Basics 5. Links, Imports, and Groups 6. Sketch-Based Modeling Components 7. Complex Walls 8. Visibility and Graphic Controls 9. Rooms 10. Schedules and Tags 11. Annotation and Details 12. The Basics of Families 13. Sheets, Plotting, and Publishing Conclusion
Views: 130509 LinkedIn Learning
Deploy angular app to IIS
 
06:32
In this video we will discuss deploying angular application to IIS. Here are the steps Step 1 : Build your angular application. If you want to deploy a development build do a development build using the following Angular CLI command. The base-href option on the build command sets the base-href element in index.html to "/ePortal/" instaed of "/". In the IIS server, we will create an application with name "ePortal" in just a bit. ng build --base-href /ePortal/ If you want to deploy a production build do a production build using the following Angular CLI command. ng build --prod --base-href /ePortal/ In our case let's deploy a production build. After the build is complete, you will notice a folder with name "dist" in your Angular project folder. This folder contains all the build files. These build files need to be copied to a folder on the server where we have IIS installed. Step 2 : Create a folder on the server where you have IIS installed. You can name the folder anything you want. I am going to name the folder "ProductionBuild" and I am creating it in C:\ drive. Step 3 : Now copy all the contents of the "dist" folder into "ProductionBuild" folder Step 4 : Open IIS. There are several ways to do this. One way is to type "inetmgr" in the "Run" window and click "OK" Step 5 : Create an application in IIS. Name it "ePortal". This name has to match the value we have specified for the --base-href option in Step 1. a) Exapand the root IIS node b) Expand Sites c) Right click on "Default Web Site" and select "Add Application" from the context menu d) In the "Alias" textbox, type "ePortal" e) Set the "Physical Path" to folder that contains the build files. In our case it is "ProductionBuild" folder in C:\ drive At this point, if you launch the browser and navigate to http://localhost/ePortal/home, you will see the "home works" message as expected. When you click on the "Employees" tab it also works as expected. However, when you "Refresh" the page by pressing F5, you will see HTTP 404 error Step 6 : To fix this Page Refresh issue in Angular, include the following URL rewrite rule in you web.config file. This web.config file should be in copied the "ProductionBuild" folder where we have the rest of the build files. Please replace [ with LESS_THAN symbol and ] with GREATER_THAN symbol. [?xml version="1.0" encoding="utf-8"?] [configuration] [system.webServer] [rewrite] [rules] [rule name="AngularJS Routes" stopProcessing="true"] [match url=".*" /] [conditions logicalGrouping="MatchAll"] [add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" /] [add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" /] [add input="{REQUEST_URI}" pattern="^/(api)" negate="true" /] [/conditions] [action type="Rewrite" url="/ePortal" /] [/rule] [/rules] [/rewrite] [/system.webServer] [/configuration] Please note : You may also point the IIS application directly to the "dist" folder in RoutingDemo project folder. The downside of this is every time you rebuild your application, the "dist" folder is deleted and recreated. This means you will loose the web.config file and you have to create it again. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/11/deploy-angular-app-to-iis.html Slides http://csharp-video-tutorials.blogspot.com/2017/11/deploy-angular-app-to-iis-slides.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 56014 kudvenkat
Simple Visual Basic Database  Application using Data Control -Tutorial for beginners
 
10:13
(Browse the information of customers stored in NWIND.mdb Microsoft Access database using data control *without any programming) Create a simple database application with MS Access Database provided in visual basic installation folder in C Drive. Videos key points: (Without any programming ) How to link or connect to MS Access database with VB using data control. How to connect or link our textbox or label with database. How to hide the data control. How to add navigation button for moving the records from beginning to last or previous to next etc. First Step: Locate the Database Goto C: Drive and Open Program files.Now Find Microsoft Visual Studio folder.Open it and Select VB98 Folder and Open it also.Here you will find Two Access Databases NWIND.mdb and BIBLIO.mdb. Just Copy that files and place in another drive for user. Step:2 To connect database by Setting data control properties: Database Name,Access And Record Source. To display data with Text box or any other control by Setting control properties: Data Source and Data field You will be able to develop the same application after watching this video. Link for more info: http://selfcomputerlearning.blogspot.com/2015/09/a-simple-visual-basic-database.html please leave a comment for any suggestion or help. _____________________________________________________________ Here is my updated List of Tutorials. _____________________________________________________________ Create and store data in Microsoft Excel Sheet using visual basic https://youtu.be/qcUqaxFD2Dw Search records in listview control https://youtu.be/IvdwG_iIcgQ Create and Display Popup menu in Visual Studio https://youtu.be/Ue8s_EJggaw Search Records between Two dates using DataGrid https://youtu.be/hngeOF1hqcs How to Connect Listview with Database and Load data into Listview https://youtu.be/w2MXRpaXbNU Add Delete Search and Sort Listitems in Listview control https://youtu.be/5JNfrTYm7sI How to Reset Forgotten Password by User Verification in Visual Basic 6.0 https://youtu.be/mMuM99gPyoo How to Connect Datagrid control with Access database without VB6 ADODC https://youtu.be/QNqDcESIzCg How to Make installer for Visual Basic Database https://youtu.be/zd9MkOf1CI0 ImageCombo and ImageList-Display Image with Combo items in Combobox https://youtu.be/pctajfImKd4 Create Save Update Delete and Search Student Profile Using Visual Basic/Ms Access-Step by Step https://youtu.be/bL03PrGt8WY Advance Login System (Splash Screen with Progress Bar,User Registration,Login system,Welcome ) https://youtu.be/s-BU03egpWA Add Delete Update Search Records https://youtu.be/K8jq2H3aamk How to Print Data Report in VB6 https://youtu.be/vjQDtKMUCKk How to Use Data Manager in VB6 https://youtu.be/27IrMsEXlBc Create Tool Bar,Status Bar and Menu Bar https://youtu.be/3l6bciTAC7Q Common dialog control- Font and Color Dialog https://youtu.be/4DBy2ghmu7U Search Records in Database (By Name or ID) https://youtu.be/1yNScTVAqZ4 Login Form using Visual Basic 6.0 https://youtu.be/XXKjfta5kkg Add Delete Update and Clear records https://youtu.be/tYS7uncH8Ds Simple Visual Basic Database Application https://youtu.be/PldGe0-FnI8 Design Font Dialog Box in VB 6 https://youtu.be/C0CMtoXIFY4 Road Traffic lights Animated system https://youtu.be/74Zvl0bXeAY ListBox Control( Advanced) https://youtu.be/Q6NYtmH7z9Q ListBox Control -Add,Delete and Clear items https://youtu.be/YlmKSyk0l2k Custom Progress Bar with percentage completed on Splash Screen https://youtu.be/jGSxrhYZAbE Frame Control,Check Box and Option Buttons https://youtu.be/9x9dmM0V4CU Picture Viewer+Browser in Visual Basic https://youtu.be/POd1Kmpvc0M Splash Screen with Progress Bar- https://youtu.be/95hw5z7lq4A Create Menus,Drop Down Menus ,Nested menus in Menu Bar https://youtu.be/fNtJaQgnuEs for more Visual Basic tutorials,please visit Youtube Channel:https://www.youtube.com/user/sandydehrian Computer Gyan Blog:http://selfcomputerlearning.blogspot.in/ Subscribe to my Channel:-) #visualbasic #visualbasictutorial #vb6
Views: 167930 Sandeep Kaundal
Visual Basic Programming lesson 12 - Reading data from a text file
 
12:18
A lesson requested by a subscriber. This lesson teaches you how to read data from a text file. In the next few lessons we are also going to talk about how to store data in a text file, which will help you with projects such as develop a high score table in game creation. Visit http://www.magicmonktutorials.com to download source code.
Views: 77268 Magic Monk
Setting up Angular 2 in Visual Studio
 
11:18
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/05/setting-up-angular-2-in-visual-studio.html Slides http://csharp-video-tutorials.blogspot.com/2017/05/setting-up-angular-2-in-visual-studio_18.html Angular 2 Tutorial playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular 2 Text articles and slides http://csharp-video-tutorials.blogspot.com/2017/06/angular-2-tutorial-for-beginners_12.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss how to set up Angular 2 in Visual Studio. Step 1 : The first step is to install Node.js and npm. It is recommended that you have node version 4.6.x or greater and npm 3.x.x or greater. To check the versions that you have on your machine type the following commands in a command window. node -v npm -v You can get the latest version of Node.js from the following website. https://nodejs.org/en/download Step 2 : Make sure you have Visual Studio 2015 Update 3 installed. To check the version of Visual Studio you have click on the "Help" menu and then select "About Microsoft Visual Studio" Download links Visual Studio Enterprise 2015 - Update 3 http://download.microsoft.com/download/8/4/3/843ec655-1b67-46c3-a7a4-10a1159cfa84/vs2015.3.ent_enu.iso Visual Studio Professional 2015 - Update 3 http://download.microsoft.com/download/e/b/c/ebc2c43f-3821-4a0b-82b1-d05368af1604/vs2015.3.pro_enu.iso Visual Studio Community 2015 - Update 3 http://download.microsoft.com/download/b/e/d/bedddfc4-55f4-4748-90a8-ffe38a40e89f/vs2015.3.com_enu.iso Step 3 : Configure environment settings for node and npm in Visual Studio. 1. In Visual Studio click on Tools - Options. 2. In the "Options" window, expand "Projects and Solutions" and select "External Web Tools" 3. In the right pane, move the global $(PATH) entry to be above the internal path $(DevEnvDir) entries. This tells Visual Studio to look for external tools (like npm) in the global path before the internal path. 4. Click "OK" to close the "Options" window and then restart Visual Stduio for the changes to take effect Step 4 : Install TypeScript for Visual Studio 2015 To develop Angular applications you need TypeScript 2.2.0 or later To check the version of TypeScript, clik on the "Help" menu in Visual Studio and select "About Microsoft Visual Studio" Download and install the latest version of TypeScript for Visual Studio 2015 from the following URL https://www.microsoft.com/en-us/download/details.aspx?id=48593 Step 5 : Create Empty ASP.NET Web Application project Step 6 : Download the "Quick Start Files" from the Angular web site. https://github.com/angular/quickstart Step 7 : Copy the required "Starter files" to the web application project Step 8 : Restore the required packages. In the "Solution Explorer" right click on "package.json" file and select "Restore Packages" from the context menu. This takes a few minutes to load all the modules. You can see the status in "Visual Studio Output" window. After the restoration is complete, you will see a message "Installing Packages Complete". To see all the installed node modules, click on "Show all Files" icon in Solution Explorer. DO NOT include "node_modules" folder in the project. Step 9 : Run the project In the "RUN" window type "cmd" and presee enter Change the directory in the command prompt to the directory where you have the web application project. Type "npm start" and press "Enter" key This launches the TypeScript compiler (tsc) which compile the application and wait for changes. It also starts the lite-server and launches the browser where you will see the output - Hello Angular. At this point, open "app.component.ts" file from "Solution Explorer". This file is present in "app" folder in "src" folder. Change "name" value from "Angular" to "Angular 2!" and you will see the changes reflected on the web page automatically. At the moment we do not have the capability to run the project by pressing F5 or CTRL + F5. We will discuss how to do this in our next video.
Views: 442640 kudvenkat
Introducing Schema Compare for SQL Server Database Projects
 
06:14
Database developers can use the schema and data comparison features in Visual Studio 2013 to view and reconcile differences between physical SQL Server databases and SQL Server Database projects. In this video, we'll show you how to deploy schema updates from a SQL Server Database project to a SQL Server database, as well as how to discern and resolve data differences between two live SQL Server databases.
Visual Basic .Net : Search in Access Database - DataGridView BindingSource Filter Part 2/2
 
25:05
🚀 NEW UPDATE: Visual Studio 2019 | Visual Basic .NET (VB.NET 2019) Searching Data in an Access Database. *** Videos Without Editing *** 📺 (Part 1/3) https://youtu.be/_gW8EIrdJ9g 📺 (Part 2/3) https://youtu.be/WRuprNKbcyg 📺 (Part 3/3) https://youtu.be/RKYReKRJuz4 🔥 Related Videos 🔥 +++ Visual Studio 2019 (VB.NET 2019) How to Connect to Data in an Access 2016 Database. 📺 (Part 1/3) https://youtu.be/t68bCOPUzyM 📺 (Part 2/3) https://youtu.be/o3YxbM4Lcwo 📺 (Part 3/3) https://youtu.be/6UqEgH8mFi8 📢 See also: (Recommended video) +++ Download and Install Microsoft Visual Studio Community 2019. 🎦 Link: https://youtu.be/SYOMR6P9zeU 🔥 Premium Tutorials (Premium Courses) 🔥 🎓 Inventory Management System - Stock Management Database (Microsoft Access). 📺 http://bit.ly/2ZFgZec // ** // 🎓 Keep going, I’ll cheer you up! 🎓 🎉 Good news!!! if you are a student, you can call to consult your project development with me #iBasskung for free. 📡 This is the Live Project Editing Service (LPES) for my Udemy students and those who watch videos from my YouTube channel (👨‍🎓👩‍🎓 Only!). 📺 My Udemy: Online Course: https://www.udemy.com/vbnet-crystal-reports 📺 My YouTube Channel: 📽 https://www.youtube.com/c/iBasskung 📝 Note: Free service for everyone. No age limit around the world. 📞 Please feel free to contact me at any time: 📖 Facebook pages: 📌 Code A Minute 📌 IBasskung Tutorial 📌 Code with iBasskung // ** // 🎥 Visual Basic .Net (VB.Net): How to Search in Access Database using DataGridView DataSource, BindingSource Filter Part 2/2. 🙏 Subscribe for more ➜ http://bit.ly/2zAg8Ag ================================ 🎗 If you would like the source code and project file. Please donate me via PayPal. 💸 https://paypal.me/CodeAMinute/499 🎗 Discount! 💸 https://paypal.me/CodeAMinute/199 (USD Only). 📝 Please contact me: [email protected] ================================ 🚀 Online Programming Courses + Free Souce Code! 🚀 👨‍💼 Please check out my online course on Udemy: 🎥 Visual Basic .Net, Access Database, EAN-13 Barcode Generator, and Crystal Reports using a Project-Based Approach. "The Point Of Sale (POS) System". 🌟 Enroll Now. You can get started on your first lesson right away 🌟 🛒 http://bit.ly/2uTJcR9 ================================ 🎁 Buy Now! and Get the following 3 projects for free! 🎁 1. Point Of Sale (POS System) used in this course. 🛒 http://bit.ly/2uTJcR9 2. VB.Net (UAM) - Personnel Management 🎗 (Video Tutorial) : http://bit.ly/2wkrxWv 3. C# (UAM) - Personnel Management 🎗 (Video Tutorial) : http://bit.ly/2JBhLlL ================================ ⛳ Follow me around ⛳ ✔ Want to get updates on new courses or other cool free stuff? Just follow me on social media if that's your thing! 📺 Pages: 📍 https://www.facebook.com/CodeAMinute 📍 https://www.facebook.com/IbasskungTutorial 📍 https://www.facebook.com/codewithibasskung 📺 YouTube: 📍 https://www.youtube.com/c/iBasskung 📺 Udemy (Online Course): 📍 https://www.udemy.com/vbnet-crystal-reports 📺 Twitter: 📍 https://twitter.com/#!/IBasskung 📺 Blogger: 📍 http://bit.ly/2wjuwvs 💯 THANK YOU SO MUCH! 💯 #vb #vbnet #visualbasic #visualbasicdatabase #RetailPOS #PointOfSale #POS #EmployeeTrainingManagement #EmployeeManagement #EmployeeManagementSystem #EmployeeTrainingRecords #PersonnelManagement #PersonnelManagementSystem #CodeAMinute #iBasskungTutorial #VisualCSharp #CSharp #Programming #MicrosoftAccess #AccessDatabase #SQLServer #Udemy #OnlineCourses #YouTube // ** // English Tags: vb vb.net visual basic visual basic access access database visual basic database how to connect database to vb.net how to connect access database to visual studio 2010 how to connect database to visual basic 2010 how to connect microsoft access database to visual basic 2010 programming in visual basic .net how to connect access database to vb.net database connectivity in vb.net vb.net login using access database vb.net login form using access database login form in vb.net with database access visual studio access database vb.net connect to database vb.net connect to access database Thai Keywords: เรียน เขียน โปรแกรม สอน เขียน โปรแกรม เขียน โปรแกรม vb.net สอน เขียน โปรแกรม ออนไลน์ เขียน โปรแกรม vb เรียน โปรแกรมเมอร์ โปร เจ ค จบ เขียน โปรแกรม ขาย สินค้า เรียน เขียน โปรแกรม ที่ไหน ดี โรงเรียน สอน เขียน โปรแกรม การ เขียน โปรแกรม visual basic My Tags - Ignore this: Visual basic .Net 2010 Programming - Search in Access 2007 Database Filtering Data In Datagridview Using Textbox (DataGridView BindingSource Filter). address book address book software how to filter data in DataGridView DataGridView Sorting/Filtering in VB.NET VB.NET 2010 How To Filter DataGridView based on Text Box input How to filter a vb.net 2010 datagridview based on input entered in a text box using data binding source as a data source BindingSource.Filter
Views: 1822161 iBasskung
Running angular app locally
 
06:37
In this video we will discuss 1. How to compile and run an angular application locally on your development machine 2. What happens behind the scenes when we compile and run an angular application 3. What is bundling and why is it important for performance So far in this video series we have been using the following command to build and run our angular application. ng serve --open Have you ever thought about what happens behind the scenes when we execute this command. Behind the scenes, Angular CLI runs Webpack to build and bundle all JavaScript and CSS code. In most cases the following are the bundles. Bundle File What it contains inline.bundle.js WebPack runtime. Required for WebPack to do it's job main.bundle.js All our application code that we write polyfills.bundle.js Browser Polyfills styles.bundle.js Styles used by the application vendor.bundle.js Angular and 3rd party vendor files What is bundling and why is it important for performance A typical real world angular application is made up of many components. Each component code is in it's own .ts file which gets transpiled to JavaScript i.e to a .js file. Along the same lines, a component may also have it's own .css file for styles. So our angular application code is in many small files. In addition to our application code files, we also have vendor code files like Angular, jQuery etc. Web browsers have a limit on how many scripts or CSS files they can download simultaneously. Because of this browser limitation, your application may suffer from performance perspective, if it has many JavaScript and CSS files to download. Bundling can solve this problem by combining many small application and library files into a few bundles. As mentioned before, Angular CLI runs WebPack for building and bundling angular applications. There are several ways to see these generated bundles. 1. If you have executed the "ng serve --open" command in a command prompt window, upon build completion you can see the generated bundles in the command prompt window 2. If you have executed the "ng serve --open" command in Visual Studio Code Integrated Terminal, upon build completion you can see the generated bundles in the integrated terminal window 3. "ng serve --open" command builds and runs the application. By default the application runs at port number 4200. You can change this default port number if you want to. We will discuss how to do that in our upcoming videos. When the application is served in the browser you can see the generated bundles on the "Elements" tab in Browser Developer Tools. 4. You can also see these bundles on the "Sources" tab in Browser Developer Tools. 5. To see the bundles along with their sizes click on the Network tab. If you don't see the bundles, refresh the browser window by pressing F5. In addition to bundling, we can also use other optimisation techniques like Ahead-of-Time (AOT) Compilation, Minification, Uglification and TreeShaking to improve performance. We will discuss all these techniques and how to implement them in our upcoming videos. The ng serve command builds and serves the application from memory for a faster development experience. It does not write the build artifacts to the disk, so we cannot use this command if you want to deploy the build to another server. For example, if you want to deploy your angular application to a test server for testing, or to your production server we cannot use ng serve. We instead use ng build. This command writes the build artifacts to the specified output folder, so the application can be deployed elsewhere. We will discuss ng build in our upcoming videos. To customise the in-memory builds that the "ng serve" command produces, there are several options that we can use along with this command. We will discuss these options in our next video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/11/running-angular-app-locally.html Slides http://csharp-video-tutorials.blogspot.com/2017/11/running-angular-app-locally-slides.html Angular CLI Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CLI Text articles & Slides http://csharp-video-tutorials.blogspot.com/2017/10/angular-cli-tutorial-for-beginners.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 28323 kudvenkat
VB.NET - Student Information System Project In VB.Net And MySQL [With Source Code] Part 87 ( END )
 
04:51
Student Mangement System Project Using Visual Basic.Net And MySQL PART 87 Get Source Code: https://1bestcsharp.blogspot.com/2019/04/vbnet-students-information-system-source-code.html All My Programming Projects Here --- http://bit.ly/2HrU8hK My Source Code Store --- http://bit.ly/2OsC0TU VB.Net Course -- http://bit.ly/2wnNiVt Programming Projects: http://1bestcsharp.blogspot.com/p/programming-projects.html facebook: https://www.facebook.com/1BestCsharp twitter: https://www.twitter.com/1BestCsharp_ subscribe: http://goo.gl/nRjPKk In this vb.net project tutorials serie we will see how to create a basic student informations management system using vb.net with visual studio and mysql database before starting this serie you must : - learn first vb.net core - download and install visual studio - have some knowledge in database - downoad and install XAMPP or WAMPP server(we will use XAMPP) and while creating this vb.net project we will see how: - design and create a login form so the users can enter a password and a username , if the username or password are incorrect show an error message, else show a main form - the user can show and hide password characters using a checkbox control. - in the main form the user will see a menu and he can choose what to do next. The Student Part - in the manage student the user can add a new student,update student,remove student, - a datagridview populated witth student records, - if the user select a row from datagridview the selected student data will be displayed into textboxes and gender in radiobutton (radiobutton to manage the student gender male or female) - a label with the total students in the database - a from to show the total students and percentage of male and female The Course Part - in the manage courses the user can add a new course,update course,remove course, - a listbox populated witth courses names, - if the user select an item from listbox the selected course data will be displayed into data fields - a label with the total courses in the database - a navigation buttons to go to the first, next, previous, last. The Score Part - in scores you can add a score to a student for a course, - remove a student score for a course, (you can not edit a student score to do that you have to delete it and reenter a correct data) - a datagridview to show the scores and the students records - show average score by course. NOTE: if we delete a student or a course all scores associated with them will be also deleted subscribe for more tutorials VB.Net - How To Insert Update Delete Search Display Images From SQL SERVER 2014 [With Code] Part 1 https://www.youtube.com/watch?v=0T_hMrB2KqI Datagridview Header In Visual Basic.Net https://www.youtube.com/watch?v=5vUfGuot8ms Get Mouse Coordinates https://www.youtube.com/watch?v=Mr0PJcTR7M0 VB.NET And MySQL Database Tutorials: Connect MySQL Database To Visual Basic .Net: https://www.youtube.com/watch?v=dObsPynYdO0 Populate Datagridview: https://www.youtube.com/watch?v=BxjY1kIPy_4 Populate ComboBox: https://youtu.be/GpRdQ9oAVoU Populate ListBox: https://youtu.be/MC6jdMy14tM Visual Basic.Net Show Date MySQL Database: https://youtu.be/v4TW_bcAOcg Display Data From MySQL Depending On Combobox Value: https://www.youtube.com/watch?v=h3uq4DB6Ldc Insert Data: https://youtu.be/Tu5Pe1tQswg Update Data: https://www.youtube.com/watch?v=te1KIcv0318 Search Data: https://www.youtube.com/watch?v=6QeHcPh2G1Y Delete Data: https://youtu.be/8DqUdKTfswQ Insert Update Delete Search In MySQL Database: Part 1: https://www.youtube.com/watch?v=nDYNomQge7E Part 2: https://www.youtube.com/watch?v=VUviWo55Wn8 Search Data In MySQL Between 2 Date: https://www.youtube.com/watch?v=xF6OLZlZ8Ss Insert Image: https://www.youtube.com/watch?v=VL-GzIgL7Pg ExecuteScalar (COUNT, MAX, MIN, AVG): https://www.youtube.com/watch?v=E_MLJ7ClI6U Retrieve Image: https://www.youtube.com/watch?v=aV8pRDhhZJA Update Image: https://www.youtube.com/watch?v=OQvYWuWz41c Insert All DataGridView Data: https://www.youtube.com/watch?v=vnb-0zixxfE Add Item To MenuStrip From MySQL: https://www.youtube.com/watch?v=Vt91qq50Zmc Create Menu from MySQL Database Using Visual Basic .Net: https://www.youtube.com/watch?v=qxLqlA6HiYA Using Stored PROCEDURE: https://www.youtube.com/watch?v=t3Shg3OCVc0 Share This Video: https://youtu.be/H3L8TBtVNyU
Views: 641 1BestCsharp blog
Publish Windows Forms Application
 
08:52
Publish a Windows Forms Applications in Minutes using Click Once in Visual Studio.
Views: 42304 Sunny Iyer
How to debug javascript in visual studio
 
04:16
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/10/how-to-debug-javascript-in-visual-studio.html In this video we will discuss, How to debug JavaScript in Visual Studio Here are the steps 1. In Visual Studio, right click on a web form and select "Browse With..." option from the context menu 2. In the "Browse With" window, a) select "Internet Explorer" b) Click "Set as Default" button c) Finally click "Browse" button 3. Close the internet explorer window that opens and run the visual studio project in Debug Mode. 4. In Visual Studio, throw a break point on the JavaScript function that you want to debug. At this point, in the internet explorer perform the action (i.e clicking on button or changing a selection in the DropDownList) that calls the JavaScript function. The JavaScript execution should stop at the breakpoint and we should be able to step over and step into code using F10 and F11 keys respectively. At this point we should also be able to use watch, quick watch and immediate windows in visual studio. This approach will not work in visual studio 2008, if you are using any other browser apart from Internet Explorer.
Views: 165748 kudvenkat
Angular and ASP NET Web API
 
07:35
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/08/angular-and-aspnet-web-api.html Slides http://csharp-video-tutorials.blogspot.com/2017/08/angular-and-aspnet-web-api_7.html Angular 2 Tutorial playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhWqGD8BuKuX-VTKqlNBj-m6 Angular 2 Text articles and slides http://csharp-video-tutorials.blogspot.com/2017/06/angular-2-tutorial-for-beginners_12.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss creating ASP.NET Web API service that retrieves employees data from a database table. In our next video we will discuss, how to call this ASP.NET Web API service using Angular Step 1 : Execute the following SQL Script using SQL Server Management studio. This script creates 1. EmployeeDB database 2. Creates the Employees table and populate it with sample data Create Database EmployeeDB Go Use EmployeeDB Go Create table Employees ( code nvarchar(50) primary key, name nvarchar(50), gender nvarchar(50), annualSalary decimal(18,3), dateOfBirth nvarchar(50) ) Go Insert into Employees values ('emp101', 'Tom', 'Male', 5500, '6/25/1988') Insert into Employees values ('emp102', 'Alex', 'Male', 5700.95, '9/6/1982') Insert into Employees values ('emp103', 'Mike', 'Male', 5900, '12/8/1979') Insert into Employees values ('emp104', 'Mary', 'Female', 6500.826, '10/14/1980') Insert into Employees values ('emp105', 'Nancy', 'Female', 6700.826, '12/15/1982') Step 2 : To keep Angular and Web API projects separate, let's create a new project for our Web API Service. Right click on "Angular2Demo" solution in the Solution Explorer and select Add - New Project. Step 3 : In the Add New Project window Select "Visual C#" under "Installed - Templates" From the middle pane select, ASP.NET Web Application Name the project "EmployeeWebAPIService" and click "OK" Step 4 : On the next window, select "Web API" and click "OK". At this point you should have the Web API project created. Step 5 : Add ADO.NET Entity Data Model to retrieve data from the database. Right click on "EmployeeWebAPIService" project and select Add - New Item In the "Add New Item" window Select "Data" from the left pane Select ADO.NET Entity Data Model from the middle pane In the Name text box, type EmployeeDataModel and click Add Step 6 : On the Entity Data Model Wizard, select "EF Designer from database" option and click next Step 7 : On the next screen, click "New Connection" button Step 8 : On "Connection Properties" window, set Server Name = (local) Authentication = Windows Authentication Select or enter a database name = EmployeeDB Click OK and then click Next Step 9: On the nex screen, select "Employees" table and click Finish. Adding Web API Controller 1. Right click on the Controllers folder in EmployeeWebAPIService project and select Add - Controller 2. Select "Web API 2 Controller - Empty" and click "Add" 3. On the next screen set the Controller Name = EmployeesController and click Add 4. Copy and paste the following code in EmployeesController.cs using System.Collections.Generic; using System.Linq; using System.Web.Http; namespace EmployeeWebAPIService.Controllers { public class EmployeesController : ApiController { public IEnumerable[Employee] Get() { using (EmployeeDBEntities entities = new EmployeeDBEntities()) { return entities.Employees.ToList(); } } public Employee Get(string code) { using (EmployeeDBEntities entities = new EmployeeDBEntities()) { return entities.Employees.FirstOrDefault(e =] e.code == code); } } } } At this point when you navigate to /api/employees you will see all the employees as expected. However, when you navigate to /api/employees/emp101, we expect to see employee whose employee code is emp101, but we still see the list of all employees. This is because the parameter name for the Get() method in EmployeesController is "code" public Employee Get(string code) { using (EmployeeDBEntities entities = new EmployeeDBEntities()) { return entities.Employees.FirstOrDefault(e =] e.code == code); } } but in the default Web API route in WebApiConfig.cs file the parameter name is {id}. Change this to "code" as shown below config.Routes.MapHttpRoute( name: "DefaultApi", routeTemplate: "api/{controller}/{code}", defaults: new { code = RouteParameter.Optional } ); With this change if we navigate to /api/employees/emp101 we see just that employee whose employee code is "emp101" In our next video we will discuss, how to call this ASP.NET Web API service using Angular
Views: 112652 kudvenkat