Home
Search results “Oracle return single row” for the 2013
Find Duplicate Rows in SQL - Select Statement Tutorial
 
02:06
Find duplicate row values in a field or multiple fields in SQL Server table with this tutorial. Do this for one column, or multiple columns. Uses SQL Server Management Studio for the demonstration.
Views: 46643 Edward Kench
TSQL: Get Last Row of Data In A Table
 
06:32
Return the final row of data in a table
Views: 7356 SQLInSix Minutes
Shortcut to SELECT Single Row from Table - SQL in Sixty Seconds #046
 
00:45
Very common practice by developer to SELECT only 1 row from the table. There is no shortcut for the same so developers have to type it again and again. In this quick video we will see how to create a shortcut to SELECT a single row from a table. Read more here: http://bit.ly/WYEW9l
Views: 7100 Pinal Dave
Oracle Database 12c Security - Oracle Virtual Private Database (VPD)
 
12:29
Learn how to use Oracle Virtual Private Database (VPD) to secure your data. See all lessons at http://skillbuilders.com/12c-TSDP-Tutorial First, Virtual Private Database. What is it? Answer: It's a declarative technique for enforcing security. Typically, it's based on user application context. That was the first limitation of 8i. Backed with 8i context were session-specific. The context variables were sort in the PGA. That means you simply couldn't use this in a web environment. However, global context, with use of 9i, Virtual Private Database became usable for web applications with connection pooling. But whether you're using it to client server or on a three tier environment, it's declarative technique rather than a programmatic technique. I can go behind the back of the application as a DBA and generate predicates to get appended to all SQLs. Select, insert, update, delete the end users. Issue the SQL and I will generate a predicate that filters the access. It's impossible to bypass. All users will have predicates appended to all their code. It doesn't matter whether they're using SQL Plus, Discoverer, Business Objects, Crystal Reports, eBusiness Suites, whatever they're using, I as DBA can filter their access to roles. The end result, different users see different data sets while running the same code and accessing the same tables, hence, the name Virtual Private Database. Different users will think they're seeing a totally different set of tables, but in fact it's one column database, one set of tables hosting a single application shared by all the users. The mechanism - you can apply VPD to tables, to views, to synonyms, and a declarative technique. Once the technique you write a function that generates the predicate, you associate the function with the table. From then on whenever the user issue SQL against that table the Cost-Based Optimizer rewrites the code. The Cost-Based Optimizer rewrites the user SQL to call the function to generate the predicate. The predicate is then appended to the SQL and it's the modified SQL that is parsed and executed. Let's see how this actually works. I'm working here by the way. This is just a perfectly normal 12.1 database. But what I'm going to demonstrate at this point will in fact work on 11g as well. I'm not going to be using any of the 12c enhancements to VPD for this little demonstration. I'll work in the scott schema. What do we have to do? We write a function to generate the predicate string. Create function. And I'll my function vpdf. The function must conform to a fixed specification. It must take two varchar arguments. One of the arguments is intended to be the schema to which the function will be applied. The other argument is the object within the schema to which the function will be applied. And it must return a varchar2, which is the generated predicate. Let's begin. Within this function you can do just about anything. There are some limitations. It's impossible for the function to query or update the table against which the VPD calls here is going to be applied or we violate the rules of purity that we come across so often with PL/SQL. But apart from that, it can do just about anything - including a number of dreadful side effects can be introduced by writing VPD functions. I'm going to do a very simple one on this one. I'll shall simple return immediately a predicate. What predicate? Ename, which is the ename column from this scott.emp table. Ename should equal sys_context. I'll go to the local context, my user end context, and just extract session user. We can see that John has tested this earlier today and therefore the object already was suggesting and he's just dropping it now and cleaning up the recreate. I hope you realize these really are live demonstrations. I'm not just running scripts. I've created a function. What's that function going to do? It's going to return this value here. Test it. Always test it and see what it's actually going to do. I'll select vpdf. I have to give it a couple of arguments. This one will do for now.
Views: 4633 SkillBuilders
TSQL: Group Items With Comma Separation
 
06:20
Grouping items separated by a column.
Views: 4327 SQLInSix Minutes
Reload data into cache automatically when data in the table changes   Part 132
 
12:11
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/02/reload-data-into-cache-automatically.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-132-reload-data-into-cache.html All ASP .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-aspnet-video-tutorial.html All ASP .NET Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In Part 130 of asp.net video tutorial, we discussed about reloading data into cache automatically, when the xml file from which the data was initially retrieved, has changed. In this video, we will discuss about reloading data into cache automatically when data in the underlying database table has changed. Please watch Part 131, before proceeding with this video. To load data automatically into cache, when cached data is removed, we need to define a callback method. This callback method will be invoked when the respective item is removed from cache. So, the code to reload and re-cache data can be written in this method. The callback method signature should match, with the signature of "CacheItemRemovedCallback" delegate. The call back method is defined below. public void CacheItemRemovedCallbackMethod(string key, object value, CacheItemRemovedReason reason) { string CS = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(CS); SqlDataAdapter da = new SqlDataAdapter("spGetProducts", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); da.Fill(ds); CacheItemRemovedCallback onCacheItemRemoved = new CacheItemRemovedCallback(CacheItemRemovedCallbackMethod); SqlCacheDependency sqlDependency = new SqlCacheDependency("Sample", "tblProducts"); Cache.Insert("ProductsData", ds, sqlDependency, DateTime.Now.AddHours(24), Cache.NoSlidingExpiration, CacheItemPriority.Default, onCacheItemRemoved); } Now, create an instance of "CacheItemRemovedCallback" delegate, and to the contructor pass the name of the callback method, that should be executed automatically when, the cached item is removed. CacheItemRemovedCallback onCacheItemRemoved = new CacheItemRemovedCallback(CacheItemRemovedCallbackMethod); In Part 131, to cache data, we used cache object's, Insert() method that takes 3 parameters, as shown below. Cache.Insert("ProductsData", ds, sqlDependency); Instead, let's use the overloaded version that takes 7 parameters and pass "onCacheItemRemoved" as an argument for "CacheItemRemovedCallback" parameter. Cache.Insert("ProductsData", ds, sqlDependency, DateTime.Now.AddHours(24), Cache.NoSlidingExpiration, CacheItemPriority.Default, onCacheItemRemoved); That's it. We are done. Now, please run the application. When "Get Data" button is clicked for the first time, the data is loaded from database. Once the data is loaded into cache, we always get it from cache when we click "Get Data". Now, execute an update statement on the database table. Notice that, when we click "Get Data" button now, we still get data from cache, but notice that, the updated data is loaded.
Views: 41511 kudvenkat
How To Convert an InputText Field to a Static List of Values
 
06:48
How To Convert an InputText Field to a Static List of Values in Fusion Applications using Oracle JDeveloper and ADF
Cursors in sql server   Part 63
 
13:58
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/01/cursors-in-sql-server-part-63.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-63-cursors-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Relational Database Management Systems, including sql server are very good at handling data in SETS. For example, the following "UPDATE" query, updates a set of rows that matches the condition in the "WHERE" clause at the same time. Update tblProductSales Set UnitPrice = 50 where ProductId = 101 However, if there is ever a need to process the rows, on a row-by-row basis, then cursors are your choice. Cursors are very bad for performance, and should be avoided always. Most of the time, cursors can be very easily replaced using joins. There are different types of cursors in sql server as listed below. We will talk about the differences between these cursor types in a later video session. 1. Forward-Only 2. Static 3. Keyset 4. Dynamic Let us now look at a simple example of using sql server cursor to process one row at time. We will be using tblProducts and tblProductSales tables, for this example. On my machine, there are 400,000 records in tblProducts and 600,000 records in tblProductSales tables. If you want to learn about generating huge amounts of random test data, please watch Part - 61 in sql server video tutorial. The link is below. http://www.youtube.com/user/kudvenkat/videos?flow=grid&view=1 Cursor Example: Let us say, I want to update the UNITPRICE column in tblProductSales table, based on the following criteria 1. If the ProductName = 'Product - 55', Set Unit Price to 55 2. If the ProductName = 'Product - 65', Set Unit Price to 65 3. If the ProductName is like 'Product - 100%', Set Unit Price to 1000 For the SQL code samples used in the demo please visit my blog at the following link http://csharp-video-tutorials.blogspot.com/2013/01/cursors-in-sql-server-part-63.html The cursor will loop thru each row in tblProductSales table. As there are 600,000 rows, to be processed on a row-by-row basis, it takes around 40 to 45 seconds on my machine. We can achieve this very easily using a join, and this will significantly increase the performance. We will discuss about this in our next video session. To check if the rows have been correctly updated, please use the following query. Select Name, UnitPrice from tblProducts join tblProductSales on tblProducts.Id = tblProductSales.ProductId where (Name='Product - 55' or Name='Product - 65' or Name like 'Product - 100%')
Views: 220399 kudvenkat
C# Tutorial 10:  How to Link Combobox with Database values
 
08:50
------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------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 -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------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 ---------------------------------------------------------------------------- how to bind combobox to textbox in C# ComboBox and TextBox‎ C# How to show combo box selected value in a text box‎ C# selecting an item in combobox and display corresponding Populate combobox from database C# How to get data in combobox from database? Populating a Combobox from a Dictionary How to fill different ComboBoxes in a DataGridView C# code add database column to datagridview combobox C# Populate combobox from database How to get data in combobox from database? Populating a Combobox from a Dictionary How to fill different ComboBoxes in a DataGridView code add database column to datagridview combobox Enter values into combobox from database‎ Enter values into combobox from database‎ C#
Views: 232950 ProgrammingKnowledge
Oracle Part 7 Where clause and Update
 
25:02
Default clause, where condition, update statement
Views: 1077 Free OpenMentor
C# Tutorial 11:Database values in textbox if select Combobox
 
12:15
------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------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 -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------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 ----------------------------------------------------------------------- how to bind combobox to textbox in C# ComboBox and TextBox‎ C# How to show combo box selected value in a text box‎ C# selecting an item in combobox and display corresponding Populate combobox from database C# How to get data in combobox from database? Populating a Combobox from a Dictionary How to fill different ComboBoxes in a DataGridView C# code add database column to datagridview combobox C# Populate combobox from database How to get data in combobox from database? Populating a Combobox from a Dictionary How to fill different ComboBoxes in a DataGridView code add database column to datagridview combobox Enter values into combobox from database‎ Enter values into combobox from database‎ C#
Views: 208865 ProgrammingKnowledge
SQL - AGGREGATE functions
 
02:25
Tutorial link: http://www.itcuties.com/sql/sql-aggregate-queries-tutorial-video/ An SQL Aggregate Queries contain functions in the SELECT statement but no GROUP BY clause. It always returns a single row calculated from values in a column, except the HAVING clause is used...
Views: 5113 ITCuties
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 93868 kudvenkat
Basic Monte Carlo Simulation of a Stock Portfolio in Excel
 
11:30
https://alphabench.com/data/monte-carlo-simulation-tutorial.html Demonstration of a simple Monte Carlo simulation technique or Monte Carlo method that utilizes the Excel Data Table feature to replicate iterations. This tutorial models annual investments in an S&P 500-like environment. No add-ins are used; 100% pure Excel. Monte Carlo simulation in Excel typically makes use of add-in software for Excel like Palisades Decision Suite or Oracle's Crystal Ball, but we can do a reasonable job modeling Monte Carlo Simulation with Excel, using just Excel. Monte Carlo Simulation is one of the most highly used and important numerical techniques used in finance. A dynamic histogram can be added to further characterize a return profile. See my video on the topic if interested: https://youtu.be/WsQH3AtJqxY For a Monte Carlo simulation to approximate individual stock price movement see: https://youtu.be/1ot7HOI3wQE
Views: 217278 Matt Macarty
C# Tutorial 22: Checkbox , radiobutton and groupbox with Database in C#
 
14:34
GroupBox How to auto create radiobutton and groupbox C# C sharp tutorial How to build two radio button groups in Visual C# 2010 I need to build two groups of radio buttons, so that client can put an answer in ... your radio boxes will be grouped by which group box they are in. ... Defining environment variables for visual studio 2010 to use during build? Radio buttons and check boxes to display selected in textbox Getting User Choices: Using Check Boxes and Radio Buttons Check box, Radio button, and Group box in Visual . Let's now use the check box, radio button, and group box in a single application Radio Buttons - Visual C#
Views: 153318 ProgrammingKnowledge
C# WPF Tutorial 17- Show database values in Table or DataGrid
 
15:07
C# - How to get user entered data from datagridview to windows Insert, Update and Delete from DataGridView to sqlite WPF ,MySql Sql database WPF WPF Microsoft Visual C#/CLI Windows Controls The Data Grid View C# Tutorial - Binding a DataGridView to a Database c# - How to save datagridview records on database table how can i use data grid view to update data in database using C# WPF Delete in Datagridview and SQL database‎ WPF Save From datagridview to access database‎ WPF Update database from DataGridView‎ transferring multiple row data from listview to datagridview c sharp‎ retrieving seleted value from combobox in datagridview‎ WPF Updating database table from DataGridView‎ WPF update DataSet from DataGridView, and update database from How to Create a Simple Windows Forms C# Database Application Searches related to c# datagridview database c# datagridview without database WPF c# datagrid view WPF How to insert data from DatagridView to MS Access Database WPF
Views: 118871 ProgrammingKnowledge
Creating Functions in Oracle PL SQL By Dr. RD Balaji
 
12:47
Help us caption & translate this video! http://amara.org/v/DWUu/
C# Tutorial 23: How to use DateTimePicker and save date in Database
 
14:04
Visual C# .NET Controls The Date Time Picker - Date Picker C# - How do I set my datetimepicker date? visual C# - DateTimePicker date to string C# How to compare the time of a DateTimePicker control and the How do I get value from Date time picker and Month calendar C# How to pass values to a dateTimePicker control‎ C# How to change DateTimePicker control to 24h time format ? Getting started with the DateTimePicker Visual Studio 2012 RC - Age calculation from Converting date time picker value into t_time type date time picker‎ - 7 posts DateTimePicker - Visual C# assign SYSTEMTIME to DateTimePicker Control‎ C#
Views: 331321 ProgrammingKnowledge
Aggregate functions in SQL Lecture, BCA, MCA  by Ritu Kumawat.
 
03:50
Aggregate functions calculate the values of a column and return single value as result. These are: 1.avg() 2.min() 3.max() 4.count() 5.sum() 6.first() 7.last()
Views: 4986 Guru Kpo
Transactions in SQL
 
02:06
Follow this tutorial to learn how to use Transactions in SQL and see how we can roll back to previous changes done in database. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ A transaction in SQL is basically the process of one or more changes being made in the database. In this tutorial we will learn the three basic controls of transactions in SQL which are COMMIT, ROLLBACK, and SAVEPOINT Step 1- Commit Command The Commit command is used to save the changes made in the database. To see its implementation, start by first beginning the transaction. Before starting any Transaction in SQL, we have to write the Begin Transaction statement. After that, write the actual action which is required, for example delete from the employee table, where the salary is greater than $2500. After that, write the Commit keyword which confirms that the query is logically correct and can be executed. The Query in this case would be: begin trandelete from EMP where SAL 2500 commit Now when we run the query, a message appears below the Query Editor which shows the number of rows that have been affected by our query. Step 2- Effect of Commit Command After that, fetch all the records from the employee table and it can be seen that all the records which have a salary above $2500 have been deleted. Step 3- Save Points Now let's examine the SAVE POINT command. To understand the concept, we will take an example of a departmental table. Start writing the query by beginning a transaction and then entering in the "Save Transaction" command followed by the transaction name. After that, let's delete a record with the Department number as 10 and then again save the transaction. This time, define the save point as point2. With that done, delete another department, and save the transaction, defining it as point3. Actual Query would be like this: begin tran save tran point1 delete from DEPT where DEPTNO=10 save tran point2 delete from DEPT where DEPTNO=20 save tran point3 After executing it, 2 rows would get affected. Step 4- Departments Deleted Now, see the department table to view the changes. For that, let's fetch all the records from the table. It can be seen that department "10" and "20" has been deleted from the table. Step 5- Roll Back If we want to track back to the previous changes, we can use the save points created earlier along with the Rollback transaction command. The rollback transaction allows us to remove all the modifications made to the data, either from the start of the transaction or to a defined save point. For that, we will use the rollback transaction statement and define the save point after that. Over here, let's roll back to point number 2. The Query would be: rollback tran point2 select * from DEPT Once we execute the query, and fetch all the records from the table, it can be seen that the table now contains the data up till point number 2 in the query. And this is how we can use Transactions in SQL.
Full Back Workout (In just 23 MINUTES!!)
 
33:45
Say goodbye to 60-90 minute workouts forever (and build muscle much faster!) http://athleanx.com/x/neverovertrain If you want to build a thick, wide back you've got to train hard...that we know. However, does it mean that we have to train for hours? Not at all. In this video, I show you that you can get an incredibly effective back and lat workout in under 25 minutes! It all comes down to the intensity of your workouts. I say all the time, you can workout long or you can workout hard but you can't do both. This complete back workout shows you to turn 4 classic back exercises into a workout that will help you to add more width to your back and thickness to your rhomboids. To completely develop your back muscles you have to include both horizontal rowing exercises and vertical pulling exercises. This workout shows you the pullups and neutral grip lat pulldowns (both vertical pulling back exercises). One arm dumbbell rows and barbell rows are included as horizontal rowing movements. The full back workout is as follows: - Weighted Pullups into Bodyweight Pullups - 3 sets to failure (drop set) - Barbell Rows - 3 sets to failure (10-12 RM) - Neutral Grip Pulldowns - 3-4 sets to failure (6-10RM) - One Arm DB Rows - 3 sets each arm The original back workout that was sent in (which inspired me to film this workout response) included an additional back exercise...seated rows. Due to the redundancy of this movement as well as the exaggerated volume in place already (5-6 sets for each of the exercises above), I removed the rows from the workout. Regardless...even if I had performed them, I would have still completed this entire back workout in less than 40 minutes. As it was, this back workout took me just 23 minutes to complete. And that is the main point. You can either workout long or hard, but you cannot do both. This back workout is short but explosive. It trades in workout length for workout intensity. When you do this, you see faster results in shorter time. Your back will be wider. Your mid back will be thicker and your lats will flare. For a complete workout program that will give you more than just a wide, thick full back then head to http://athleanx.com/x/neverovertrain and get your ATHLEAN-X training program. This complete workout will provide just the stimulus your muscles need to grow without causing you to overtrain. For more complete workouts for your back, chest, shoulders, legs and more (as well as nutrition and supplement videos) be sure to subscribe to us here on youtube by visiting http://youtube.com/user/jdcav24
Views: 1754009 ATHLEAN-X™
Update and Insert data in database from datagridview
 
07:27
Connect with me On LinkedIn: https://www.linkedin.com/in/bhubanshrestha Sometime user needs to update large amount of data in such case updating data from datagrid view is good choice because user gets all information in a row format. In this video tutorial you will learn how to update database table from datagrid view. You can insert, upadate and delete data of database from datagrid view. In this video tutorial deleting is not shown but it is very simple. Just select row then update. NOTE You have to include primary key column in data grid view. If you want to hide primary key column to user then you can achieve this by datagridview1.Columns[0].Visible=false ;//0 is the index of primary key column OR datagridview1.Columns["PrimaryKey"].Visible=false; //PrimaryKey is a column header text of primary key.
Views: 443685 Bhuban Shrestha
06-05-subqueries-in-from-select.mp4
 
08:02
Help us caption and translate this video on Amara.org: http://www.amara.org/en/v/Blwu/ Help us caption & translate this video! http://amara.org/v/Blwu/
Views: 57305 Stanford Dbclass
Using Out Parameter in plsql procedure to return multiple values.
 
10:58
Using Out Parameter in pl sql procedure to return multiple values. Oracle tutorial to get multiple values through oracle pl sql stored procedure
Views: 4728 Subhroneel Ganguly
Database Lesson #3 of 8 - The Structured Query Language (SQL)
 
01:18:25
Dr. Soper gives a lecture on using the structured query language (SQL) to work with databases. Topics include CREATE, ALTER, and DROP statements, SELECT, INSERT INTO, UPDATE, and DELETE FROM statements, subqueries, and inner and outer joins.
Views: 206066 Dr. Daniel Soper
Battlefield 4 Gameplay Walkthrough Part 1 - Campaign Mission 1 - Baku (BF4)
 
22:38
NEW Battlefield 4 Gameplay Walkthrough Part 1 includes Mission 1 of the Single Player Campaign for Xbox 360, Xbox One, Playstation 3, Playstation 4 and PC in HD. This Battlefield 4 Gameplay Walkthrough will also include a Review, all Missions and the Endings. Subscribe: http://www.youtube.com/subscription_center?add_user=theradbrad Twitter: http://twitter.com//thaRadBrad Facebook: http://www.facebook.com/theRadBrad Battlefield 4 (also known as BF4) is a first-person shooter video game developed by EA Digital Illusions CE (DICE) and published by Electronic Arts. The game is a sequel to 2011's Battlefield 3. The year is 2020, and the world is teetering on the edge of chaos. As the conflict between the Russian Federation and the U.S. raged for the past six years, a new storm is brewing in China. Admiral Chang plans to overthrow the current Chinese government; if he is successful, he will have full support from the Russians. To make matters worse, the U.S. has been implicated in the assassination of Jin Jié, China's "future leader and voice of peace." In response to the assassination, Chang has taken this opportunity to cancel elections for a new leader and declares martial law. Civilians protest and clash with the police in the streets, causing turmoil and ruin everywhere. Both U.S. and Russian naval forces have stationed themselves off the coast of China, waiting for the proverbial tinderbox to catch fire and engulf the world in the conflagration of another great war. Campaign Missions include: Baku, Suez, Tashgar, Kunlun Mountains, South China Sea, Shanghai and Singapore. Characters of Battlefield 4 include US Armed Forces: Tombstone Squad, Daniel Recker, Kimble Graves, Clayton Pakowski, Dunn, Laszlo Kovic, Hannah, Chang, Jin Jié, Bohai, Garrison, Oracle and Dima.
Views: 6329792 theRadBrad
TSQL: One Way To Get Rowcount of Tables
 
07:46
One approach to obtaining the row count of tables.
Views: 817 SQLInSix Minutes
Crystal Report V- using  DataSet in c#
 
06:52
This Video Will Teach How to Create Reports using Dataset method..
Views: 76065 Vetrivel D
13-Oracle PL/SQL (Creating Stored Procedures And Functions Part 1) By Eng-Helal Ahmed
 
10:02
13-Oracle PL/SQL (Creating Stored Procedures And Functions Part 1) By Eng-Helal Ahmed https://www.facebook.com/free4arab http://www.free4arab.com https://twitter.com/free4arab1 https://plus.google.com/114278484973373035289 نور الهدى لتكنولوجيا المعلومات
SQL Tutorials by Kash - Using SQL Select statement in MS SQL 2012
 
12:02
http://www.sqlserver2012tutorial.com/ In this SQL Server 2012 training video, we show you how to use the select statement in MS SQL Server. We first start looking at the customers table in Northwind database. We show you how to use SQL Select query in SQL 2012 to return all the customers from the table, specific columns or fields from a table and also select specific rows or records from the table with WHERE clause. We finish the SQL Server 2012 training session by going over the select ORDER BY clause to sort the data and DISTINCT clause and GROUP BY clause with the select SQL statement. SELECT * FROM CUSTOMERS WHERE COUNTRY='USA'
Views: 387 baghul
C# Tutorial 6:  Insert/Save data to database
 
13:48
------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------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 -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------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 -------------------------------------------------------------------------------- How to: Insert New Records into a Database Database Access with Visual C#.NET sql server - Insert Data into database in C# How to insert Data to Ms SQL server 2008 using C#.net .net - C# insert data into SQL table Using Visual C# and SQL cannot insert data into table..‎ c# import data from text file into sql databse line by line‎ store xml in SQL Server 2008 from C#‎ Using SQL in C# - Cannot insert data into SQL table visual C# - Could not Insert the data using VC# in MYSQl Add, save & retrieve data in SQL insert data in sql 2005 from excel file through c# asp.net‎ insert data into SQL table from pre filled boxes in C# 4.0‎ insert into database unsing ado.net and C#‎ Insert DateTime into SQL Server using C#‎ Searches related to c# insert data into sql c# insert data into sql table c# insert data into sql server inserting data into sql table insert query sql insert statement from another table
Views: 376567 ProgrammingKnowledge
C# Tutorial 13:Show database values in Table or  DataGridView
 
12:35
C# - How to get user entered data from datagridview to windows Insert, Update and Delete from DataGridView to sql server,MySql Sql database Microsoft Visual C#/CLI Windows Controls The Data Grid View C# Tutorial - Binding a DataGridView to a Database c# - How to save datagridview records on database table how can i use data grid view to update data in database using C Delete in Datagridview and SQL database‎ Save From datagridview to access database‎ Update database from DataGridView‎ transferring multiple row data from listview to datagridview c sharp‎ retrieving seleted value from combobox in datagridview‎ Updating database table from DataGridView‎ update DataSet from DataGridView, and update database from How to Create a Simple Windows Forms C# Database Application Searches related to c# datagridview database c# datagridview without database c# datagrid view How to insert data from DatagridView to MS Access Database
Views: 335276 ProgrammingKnowledge
Multiple Grand Totals in Excel Pivot Table
 
03:35
http://www.contextures.com/xlPivot13.html Visit this page for the written instructions, and to download a sample file. In an Excel pivot table, you can show subtotals, to summarize the values by Sum, Count, and other functions. By changing a setting, you can show more than one subtotal for each item. This option is not available for grand totals, but with a workaround, you can show multiple lines for a grand total, such as Sum, Average, and Max Watch this short video to see the steps
Views: 54622 Contextures Inc.
NBA2k13 My Career : Bobcats Miss 27 Threes.... +  44 - 5 Run In the 4th Quarter! ...
 
08:40
My Previous Video - 83 Point DEMOLISHING of Mavs: http://youtu.be/Ch_eHGekyto Oh Lord have Mercy. The Bobcats.... We tear up their defense and end up going on a 48-5 run to in the 4th Quarter. The game should've ended with a 48-2 run but Kevin Martin pulls up from Near Halfcout resulting in Nothing but Net :P They get demolished by over 100 points as Ryan Anderson drops 23 points (Just in the Fourth haha) alongside Ray Allen, Kevin Durant and Andre Iguodala also scoring. Skip the times below to skip to the main points of the vid for the impatient ones XD 0:34 I do my best LeBron Impersonation 0:46 Worst Turnover Ever. Derp Song Time :D 1:05 I get Posterized by DeAndre 1:30 Payback Time! 360 Over DJ 1:51 Goodness Iggyyyy XD Mean Slam 2:11 Ray Allen Caps off one half with a buzzer beater 3:04 Durant Caps off 3rd Quarter with a near buzzer beater 4:11 Allen Finishes Off the Break 4:23 Ryan Anderson Knocks Down 3 Three's In a Row XD 5:14 Uh ohh... Make that 4 In a Row 5:37 Aaron Brooks Hits The Deck! Go back to China :P 6:00 Ryan Anderson knocks down 2 more threes... The Assassin 6:41 Allen the steal and the breakaway slam 6:51 Finally the Bobcats score!! 7:23 Allen Fading Away Dagger 7:37 No Pramu22 Vid is complete without a U Mad Bro moment. Kevin Martin From Wayyyyy DownTown! I am mad bro :P 2k13 My Career Mode Playlist: http://www.youtube.com/playlist?list=PLklwxQutmWPZBDSCv7ZeBXKb572xq32tf NBA 2k13 BEST Jump Shot! Make It Rain From ANYWHERE: http://youtu.be/U2VBPdKkHhY NBAk 2k13 How to get an A+ Teammate Grade Every Game: http://youtu.be/_fIxPvSp6io NBA 2k13 My Career NBA 2k13 Best Jump Shot NBA 2k13 Perferct Releases NBA 2k13 My Career Tutorial NBA 2k13 Shot Base NBA 2k13 Shot Release
Views: 6011 pramu22
Multiple Index tables
 
02:50
Explains how to index more than one table at a single time
Views: 287 Ben Stranieri
TSQL: Adding Columns To Existing Tables
 
05:38
Adding new columns to an existing table.
Views: 538 SQLInSix Minutes
StoredProcedure Insert
 
02:58
stored procedure,ict 130,web dev't and internet technology,Insert statement
Views: 4110 Arnie Mateo
1-oracle apex multi select list
 
11:07
oracle apex multi select list Code DECLARE l_selected APEX_APPLICATION_GLOBAL.VC_ARR2; BEGIN -- -- Convert the colon separated string of values into -- a PL/SQL array l_selected := APEX_UTIL.STRING_TO_TABLE(:P7_AUTHORS); -- -- Loop over array to insert department numbers and sysdate -- FOR i IN 1..l_selected.count LOOP INSERT INTO AUTHOR_BOOK (AUTHOR_ID_, BOOK_ID_) VALUES (l_selected(i),:P7_BOOK_ID); END LOOP; END;
Views: 9265 Dr.Firas Aswad
Part 66   Check uncheck all checkboxes with another single checkbox using jquery
 
19:46
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/07/part-66-check-uncheck-all-checkboxes.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss, how to check/uncheck all checkboxes with another single checkbox using jquery in an asp.net mvc application. Please watch Part 65, before proceeding. Here is the requirement 1. When the checkbox in the header is selected, all the checkboxes in the respective rows should be selected. If we deselect any of the checkbox, then the header checkbox should be automatically deselected. 2. When the checkbox in the header is deselected, all the checkboxes in the respective rows should be deselected as well. If we start to select each checkbox in the datarows, and upon selecting checkboxes in all the datarows, the checkbox in the header should be selected. 3. We also need a client side confirmation, on the number of rows to be deleted. The selected rows should be deleted from the database table, only when OK button is clicked. If cancel button is clicked, the form should not be posted to the server, and no rows should be deleted. Here's the required jQuery script. Please paste this in the "Index.cshtml" view. [script src="~/Scripts/jquery-1.7.1.min.js" type="text/javascript"][/script] [script type="text/javascript" language="javascript"] $(function () { $("#checkAll").click(function () { $("input[name='employeeIdsToDelete']").attr("checked", this.checked); $("input[name='employeeIdsToDelete']").click(function () { if ($("input[name='employeeIdsToDelete']").length == $("input[name='employeeIdsToDelete']:checked").length) { $("#checkAll").attr("checked", "checked"); } else { $("#checkAll").removeAttr("checked"); } }); }); $("#btnSubmit").click(function () { var count = $("input[name='employeeIdsToDelete']:checked").length; if (count == 0) { alert("No rows selected to delete"); return false; } else { return confirm(count + " row(s) will be deleted"); } }); }); [/script] jQuery file can also be referenced from the following website jQuery - http://code.jquery.com/jquery-latest.min.js Google - http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js Microsoft - http://ajax.microsoft.com/ajax/jQuery/jquery-1.9.1.min.js Make sure to replace [ with LESSTHAN and ] with GREATERTHAN symbol.
Views: 61981 kudvenkat
Date type conversion from any date format to any date format in DataStage
 
04:30
Use the type conversion functions to change the type of an argument. StringToDate Returns a date from the given string in the given format. You do not have to specify a format string if your string contains a date in the default format yyyy-mm-dd. Input: string (string) [,format (string)] Output: result (date) Examples: If the column mylink.mystring contains the string ″1958--08--18″, then the following function returns the date 1958--08--18. StringToDate(mylink.mystring) If the column mylink.mystring contains the string ″18:08:1958″, then the following function returns the date 1958--08--18. StringToDate(mylink.mystring,"%dd:%mm:%yyyy")
Views: 6136 WingsOfTechnology
how to create paging,pagination in php and display 10 records per page in php
 
10:50
Need Help Or Need code? Feel Free To Contact Us Here http://www.noblecomputer.co.in/support.php using this tutorial you can easily understand that how paging created in php.
Views: 168941 Amit Andipara
Part 62   Implementing search functionality in asp net mvc
 
17:32
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/07/part-62-implementing-search.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss, implementing search page in an asp.net mvc application. We should be able to search by Employee Name and Gender. We will be using table tblEmployee for this demo. Use the script below to create and populate the table with sample data. Create table tblEmployee ( ID int identity primary key, Name nvarchar(50), Gender nvarchar(10), Email nvarchar(50) ) Insert into tblEmployee values('Sara Nani', 'Female', '[email protected]') Insert into tblEmployee values('James Histo', 'Male', '[email protected]') Insert into tblEmployee values('Mary Jane', 'Female', '[email protected]') Insert into tblEmployee values('Paul Sensit', 'Male', '[email protected]') Step 1: Create an empty asp.net mvc 4 application. Step 2: Generate ADO.NET entity data model from database using table tblEmployee. Change the entity name from tblEmployee to Employee. Save changes and build the application. Step 3: Add HomeController with the following settings. a) Controller name = HomeController b) Template = MVC controller with read/write actions and views, using Entity Framework c) Model class = Employee d) Data context class = SampleDBContext e) Views = Razor Step 4: Modify the Index() action method in HomeController as shown below. public ActionResult Index(string searchBy, string search) { if (searchBy == "Gender") { return View(db.Employees.Where(x =] x.Gender == search || search == null).ToList()); } else { return View(db.Employees.Where(x =] x.Name.StartsWith(search) || search == null).ToList()); } } Step 5: Copy and paste the following code in Index.cshtml view. @model IEnumerable[MVCDemo.Models.Employee] @{ ViewBag.Title = "Index"; } [div style="font-family:Arial"] [h2]Employee List[/h2] [p] @using (@Html.BeginForm("Index", "Home", FormMethod.Get)) { [b]Search By:[/b] @Html.RadioButton("searchBy", "Name", true) [text]Name[/text] @Html.RadioButton("searchBy", "Gender") [text]Gender[/text][br /] @Html.TextBox("search") [input type="submit" value="search" /] } [/p] [table border="1"] [tr] [th] @Html.DisplayNameFor(model =] model.Name) [/th] [th] @Html.DisplayNameFor(model =] model.Gender) [/th] [th] @Html.DisplayNameFor(model =] model.Email) [/th] [th]Action[/th] [/tr] @if (Model.Count() == 0) { [tr] [td colspan="4"] No records match search criteria [/td] [/tr] } else { foreach (var item in Model) { [tr] [td] @Html.DisplayFor(modelItem =] item.Name) [/td] [td] @Html.DisplayFor(modelItem =] item.Gender) [/td] [td] @Html.DisplayFor(modelItem =] item.Email) [/td] [td] @Html.ActionLink("Edit", "Edit", new { id = item.ID }) | @Html.ActionLink("Details", "Details", new { id = item.ID }) | @Html.ActionLink("Delete", "Delete", new { id = item.ID }) [/td] [/tr] } } [/table] [/div] Please make sure to replace [ with LESSTHAN and ] with GREATERTHAN symbol.
Views: 136037 kudvenkat
Access 2013 10 - Opening A Form To A Specific Record
 
04:57
File available here: http://www.accessallinone.com/access-2013-no-vba-downloads/ Please select: Access2013_DB_10 Topics covered: Where Condition OpenForm Macro
Views: 115607 Access All In One
How to combine lookups to improve performance
 
01:34
Download the free Informatica PowerCenter mapping here: https://community.informatica.com/solutions/mapping_combine_lookups_performance. There are instances when in a mapping, multiple Lookup transformations are needed to get the necessary data.If the lookups are performed on the multiple source tables with referential integrity relationship, then it is possible to have a single Lookup transformation based on a view or a query override that will join the tables in the database. This will reduce the number of instances of the Lookup transformation in the mapping and the related overhead. This video shows how you could replace multiple lookups by a single lookup to improve session performance.
Views: 1228 InfaMarketplace
display selected row from datagridview to textbox in c#
 
07:52
Need Help Or Need code? Feel Free To Contact Us Here http://www.noblecomputer.co.in/support.php using this tutorial you can easily understand that how you can get selected record in textbox when you click on datagrid,display selected row from datagridview to textbox in c#, database valuesin textbox when click on datagrid, displat selected record,datagridview selected row
Views: 68308 Amit Andipara
OSIsoft: Read RDBMS/SQL data with a Single Tag query [PI RDBMS]
 
06:48
0:21 Common RDBMS Architecture 0:44 Single Tag query basics 1:38 Single Tag SQL SELECT syntax 2:10 Single Tag timestamp options 3:10 Download the User Manual 3:38 Build a PI Tag: Name and Point source 4:24 Build a PI Tag: Location codes 5:06 Build a PI Tag: ExDesc or InstrumentTag 5:56 Validate that the PI Tag works This video covers writing the SQL SELECT statement, PI Tag point source, location codes, and ExDesc attributes for a Single Tag pull with the Relational Database (RDBMS via ODBC) (RDBMSPI) PI Interface. Find the feature list and User Manual here: http://intsearch.osisoft.com/interfaceDetails.aspx?id=PI-IN-OS-RELDB-NTI The interface allows bi-directional transfer of data between the PI System and any Relational Database Management System (RDBMS) that supports Open DataBase Connectivity (ODBC) drivers. SQL statements are generated by the end user, either in the form of ordinary ASCII files, or are directly defined in the ExtendedDescriptor of a PI Tag. The interface makes internal use of the PI API and PI SDK in order to keep a standard way of interfacing from a client node to the PI Server node. Video content is copyright of OSIsoft, LLC © 2013. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than for your personal and non-commercial use.
Views: 10112 OSIsoft Learning
Optional parameters in sql server stored procedures  Part 68
 
27:52
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/09/part-68-optional-parameters-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-68-optional-parameters-in-sql_16.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Parameters of a sql server stored procedure can be made optional by specifying default values. We wil be using table tblEmployee for this Demo. CREATE TABLE tblEmployee ( Id int IDENTITY PRIMARY KEY, Name nvarchar(50), Email nvarchar(50), Age int, Gender nvarchar(50), HireDate date, ) Insert into tblEmployee values ('Sara Nan','[email protected]',35,'Female','1999-04-04') Insert into tblEmployee values ('James Histo','[email protected]',33,'Male','2008-07-13') Insert into tblEmployee values ('Mary Jane','[email protected]com',28,'Female','2005-11-11') Insert into tblEmployee values ('Paul Sensit','[email protected]',29,'Male','2007-10-23') Name, Email, Age and Gender parameters of spSearchEmployees stored procedure are optional. Notice that, we have set defaults for all the parameters, and in the "WHERE" clause we are checking if the respective parameter IS NULL. Create Proc spSearchEmployees @Name nvarchar(50) = NULL, @Email nvarchar(50) = NULL, @Age int = NULL, @Gender nvarchar(50) = NULL as Begin Select * from tblEmployee where (Name = @Name OR @Name IS NULL) AND (Email = @Email OR @Email IS NULL) AND (Age = @Age OR @Age IS NULL) AND (Gender = @Gender OR @Gender IS NULL) End Testing the stored procedure 1. Execute spSearchEmployees - This command will return all the rows 2. Execute spSearchEmployees @Gender = 'Male' - Retruns only Male employees 3. Execute spSearchEmployees @Gender = 'Male', @Age = 29 - Retruns Male employees whose age is 29
Views: 74752 kudvenkat
Part 12  Creating a view to insert data using mvc
 
10:40
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/05/part-12-creating-view-to-insert-data.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-12-creating-view-to-insert-data.html All ASP .NET MVC Text Articles http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-tutorial-for-beginners.html All ASP .NET MVC Slides http://csharp-video-tutorials.blogspot.com/p/aspnet-mvc-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, creating a view to insert a new employee into the database table tblEmployee. Please watch Part 11, before proceeding with this video. We want to present the end user with a form to enter data. Copy and paste the following "Create" action method, in EmployeeController class. [HttpGet] public ActionResult Create() { return View(); } Please note that, the method is decorated with "HttpGet" attribute. This makes this action method to respond only to the "GET" request. Now let's add a "Create" view. To do this, right click on the "Create" action method and select "Add View" from the context menu. Set 1. View name = "Create" 2. View engine = "Razor" 3. Select "Create Strongly-typed view checkbox 4. Select "Employee" class, from "Model class" dropdownlist 5. Scaffold Template = Create 6. Click "Add" button At this point "Create.cshtml" view will be added in "Employee" folder. If you have the following "Scripts" section at the bottom of the view, please delete it. We will discuss about sections and scripts in a later video session. @section Scripts { @Scripts.Render("~/bundles/jqueryval") } Run the application and navigate to the following URL "http://localhost/MVCDemo/Employee/Index" Click on "Create New" link. You will be naviaged to the following URL "http://localhost/MVCDemo/Employee/Create" A form with textboxes to add a new employee is rendered. For employee "Gender" it is ideal to have a dropdownlist instead of a text box. Run the application and notice that, a dropdownlist is now displayed for "Gender". If you click on "Create" button, you will get an error message stating - The resource cannot be found. This is because we donot have the "Create" controller action method that can handle HTTPPost request. We will discuss fixing this in our next video.
Views: 332333 kudvenkat

Free boat fucking video
Married dating sites ashley
La campana del infierno online dating
Corbin fisher fucking travis video
Did you fuck momy