Home
Search results “Xslt oracle sql”
Oracle Retrieve data from XML Document using XMLQuery
 
14:48
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2202 Sridhar Raghavan
26 Using XSLT with XML
 
03:26
Views: 2514 SAJOL AHMED
SQL Server 2012 - Generating XML from SQL Server tables
 
09:10
This video describes how to generate XML from SQL Server tables. The SQL code used in the video is available at: http://askadba.blogspot.com/2012/08/generating-xml-from-sql-server-tables.html
Views: 65273 askadba
Oracle Retrieve data from XML Document using XMLTable
 
17:49
Oracle retrieve data from xml document using xmltable
Views: 5101 Sridhar Raghavan
Develop and test XSLT with XSLT Project Manager (XPM)
 
06:31
Sample Database Application: https://apex.oracle.com/pls/apex/f?p=56455 Download trial version: http://www.mirmas.si/oracle-apex-reporting/try-region2xsltreport2/
Views: 169 Miro Masnoglav
Встроенные возможности СУБД Oracle по работе с XML
 
02:03:45
Доклад Александра Павловского на DEV Labs 2013: Oracle Technologies
Views: 1474 LuxoftTrainingCenter
common xslt elements
 
06:00
Views: 304 Moh Mrh
XMLTABLE : Convert XML into Rows and Columns using SQL
 
03:11
This video gives a quick overview of the XMLTABLE functionality, which can be used to convert XML documents in to rows and columns in SQL. For more information see: https://oracle-base.com/articles/misc/xmltable-convert-xml-data-into-rows-and-columns-using-sql https://oracle-base.com/articles/misc/sqlxml-sqlx-generating-xml-content-using-sql Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Hichwa : Twitter : https://twitter.com/mikehichwa1 Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 18452 ORACLE-BASE.com
XML SQL Function
 
06:58
How to make a function to create dynamic XML by passing values
Views: 245 Chris Thayer
CAM Editor Open-XDX demonstration: SQL to XML file
 
05:27
This video is a quick technology demonstration of creating a working Open Data API using the CAM Editor and Open XDX software tools along with Oracle WebLogic web services. Illustrates creating XML file output from SQL tables and then sharing that via web services API. Also shows creating Query/Response mechanism using Java. It is the "Part 2" of the full Introduction video - just jumps straight to the technology demonstration - as we know the technically inclined are impatient and want to see code. We take a sample MySQL database and mock patient prescriptions data and quickly build a working NIEM XML query/response web service. We show how this is done using code-free methods and XML templates to configure the information exchange components. For working code samples, latest downloads and more information please visit the open source project web sites: http://www.verifyxml.org/ and http://www.cameditor.org/#Open_Data_APIs_and_Open-XDX For the article in ODTUG on Open-XDX, SQL to XML please see: http://goo.gl/q74Zk
Views: 2163 David Webber
Introduction to Oracle Open-XDX for Open Data API delivery from SQL to XML
 
10:42
This video is in two five minute sections. The first section provides an executive level introduction to the concepts and overall operational view. This is then followed by a 5 minute demonstration of creating a working Open Data API using the CAM Editor and Open XDX software tools along with Oracle WebLogic web services. For the demonstration we take a sample MySQL database and mock patient prescriptions data and quickly build a working NIEM XML query/response web service. We show how this is done using code-free methods and XML templates to configure the information exchange components. For working code samples, latest downloads and more information please visit the open source project web sites: http://www.verifyxml.org/ and the CAM editor toolkit site: http://www.cameditor.org
Views: 2041 David Webber
"Changing XML with XSLT and XQuery" - Radu Coravu - Oxygen Users Meetup - Washington 2017
 
54:16
XSLT and XQuery are first class citizens inside Oxygen. Not only do we help those developing them but many of our features are based on these technologies. For example, for Oxygen's Author mode you can create specialized actions based on XSLT and XQuery/Update scripts. "XML Refactoring" is another powerful and flexible feature through which you can change XML documents. It offers a set of predefined operations but users are free to create their own just by XSLT and XQuery Update scripts. In this presentation, we will cover: - solve various tasks in the Author mode though XSLT, XQuery(Update) scripts - use XML Refactoring to to solve a couple of use cases - create new XML Refactoring scripts and see how to share them with the team
Views: 89 oxygenxml
Querying JSON with XSLT, XPath, & XQuery
 
04:19
Learn how XPath, XSLT, and XQuery can be used to query JSON documents or transform JSON data to other formats, such as HTML. Check out the example files featured in the video by downloading a free trial of XMLSpy: https://www.altova.com/xmlspy-xml-editor/download
Views: 831 Altova
Installing and Using Saxon for your XSLT Development
 
11:28
This is a voice-over video of the Saxon PowerPoint I use in my Web Services (XML) course offered by Computer Careers at South Central College, North Mankato, MN 56003 USA. You will learn how to install Saxon and use it to create XSLT documents. Created by Peter K. Johnson - Web Explorations http://WebExplorations.com
Views: 8304 Peter WebExplorations
XSD 2 Oracle SQL
 
01:29
Demonstration of the Sciumo XSD to Oracle DDL SQL tool available at: http://sciumo.com/xsd2sql/XSD2PLSQL.html This tool takes XML XSD and rewrites it into Oracle DDL to create table structures. Creating Oracle DDL from XSD is not necessarily a good idea. Better ways exist for utilizing XML which is a format for data in motion and not a format for data integration.
Views: 2831 Sciumo
Начальный курс - Oracle PL/SQL12
 
01:39:26
Начальный курс - Oracle PL/SQL12 - ссылку на скачивание продолжения можно получить от автора
T-SQL 2012: XML
 
05:00
Рассмотрены основы работы с типом данных XML в transact-sql Статья с кодом из видео находится на сайте http://snakeproject.ru/
Views: 300 Mihail Kozlov
SQL XML Queries
 
23:10
Follow the Books: http://amzn.to/1RjjJCf Get the slides and Scripts at: http://www.aaronbuma.com/2015/09/xml-queries-xquery-relative-absolute-and-data-function Lots of other free SQL Sessions at: http://www.aaronbuma.com/category/sql-training/
Views: 4225 Aaron Buma
XSLT XPATH and XQuery Fundamentals Course On UDemy
 
01:41
www.bharaththippireddy.com UDemy Coupon Codes: https://www.udemy.com/microservices-rest-apis-using-spring-data-rest/?couponCode=SPRINGDATAREST Spring Framework in easy steps: https://www.udemy.com/springframeworkineasysteps/?couponCode=SPRINGFORALL Java Web Services https://www.udemy.com/java-web-services/?couponCode=WSDISCOUNT4ALL Java Web Services Part 2 https://www.udemy.com/javawebservicespart2/?couponCode=WSPART2FORALL Core Java Made Easy https://www.udemy.com/corejavamadeeasy/?couponCode=COREJAVAFORALL Junit and Mockito Crash Course https://www.udemy.com/junitandmockitocrashcourse/?couponCode=JUNITFORALL JDBC Servlets and JSP https://www.udemy.com/jdbcservletsandjsp/?couponCode=JAVAWEBFORALL XML and XML Schema in easy steps https://www.udemy.com/xml-and-xml-schema-definition-in-easy-steps/?couponCode=XMLANDXSDFORALL XSLT XPATH and XQuery Fundamentals https://www.udemy.com/xslt-xpath-and-xquery-fundamentals/?couponCode=XSLTXPATHANDXQUERY Free Java Script Fundamentals https://www.udemy.com/javascriptfundamentals Free Maven Crash Course https://www.udemy.com/mavencrashcourse
Transaction Isolation Levels
 
05:12
www.bharaththippireddy.com UDemy Coupon Codes: https://www.udemy.com/microservices-rest-apis-using-spring-data-rest/?couponCode=SPRINGDATAREST Spring Framework in easy steps: https://www.udemy.com/springframeworkineasysteps/?couponCode=SPRINGFORALL Java Web Services https://www.udemy.com/java-web-services/?couponCode=WSDISCOUNT4ALL Java Web Services Part 2 https://www.udemy.com/javawebservicespart2/?couponCode=WSPART2FORALL Core Java Made Easy https://www.udemy.com/corejavamadeeasy/?couponCode=COREJAVAFORALL Junit and Mockito Crash Course https://www.udemy.com/junitandmockitocrashcourse/?couponCode=JUNITFORALL JDBC Servlets and JSP https://www.udemy.com/jdbcservletsandjsp/?couponCode=JAVAWEBFORALL XML and XML Schema in easy steps https://www.udemy.com/xml-and-xml-schema-definition-in-easy-steps/?couponCode=XMLANDXSDFORALL XSLT XPATH and XQuery Fundamentals https://www.udemy.com/xslt-xpath-and-xquery-fundamentals/?couponCode=XSLTXPATHANDXQUERY Free Java Script Fundamentals https://www.udemy.com/javascriptfundamentals Free Maven Crash Course https://www.udemy.com/mavencrashcourse
SQL-XML BASIC Part 1
 
10:32
This is another foundation video on how to use TSQL to produce XML data from a relational table. We will be expanding our knowledge by digging deep on this in various ways. Cheers, CHANDRA.
Views: 18430 Chandra V
Oracle BPM and Open Data Web Services with Open-XDX - Part 2
 
48:16
Developer level tutorial of using Oracle BPM with Open Data Web Services to build a working solution. We cover the details of configuring and deploying using JDeveloper, Oracle BPM, XML, SQL, Oracle BPM forms, Oracle WLS, and the associated development tools. This tutorial is designed to provide the details needed to code and engineer a working solution. We split this down into manageable chunks so you can follow each set of tasks, pause and rewind the video and follow along. Also sample code is available on GitHub at the VerifyXML project.
Views: 732 David Webber
SQL/XML on Oracle del 2
 
07:32
SQL/XML publishing functions
Views: 384 Kristian Torp
XSLT / XQuery Back-mapping in Altova XMLSpy
 
02:41
Learn how XSLT/XQuery back-mapping works and see how it can be used to speed up your XSLT and XQuery development and troubleshooting. Altova XMLSpy provides a unique solution for back-mapping that adds to its already powerful debuggers and profilers, giving developers the most advanced tools for their XSLT and XQuery development projects. Download a free 30 day trial of Altova XMLSpy from http://www.altova.com/.
Views: 1907 Altova
Opticca University: webMethods Lesson 6 - How to build an XSLT transformation service
 
05:59
Please watch our very own Larry as he walks us through how to build and XSLT transformation service. For more information, please visit us at www.opticca.com or subscribe to our channel.
Views: 8875 Opticca University
Mapping XML documents with XSD | XML Tutorial | Mr. Satish B
 
22:11
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/xml-training/ ? For Online Training: https://nareshit.com/course/xml-web-services-online-training/ #C# #.net #html #css #Tutorials #Training #Videos -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/nares... ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 13223 Naresh i Technologies
2  Lets see an Example First -  XML XPATH and XSLT Tutorials in Hindi
 
04:07
Please do Share. Website: http://www.projecthindi.com http://getskillsfast.com/ Join Facebook Group to learn through discussions: https://www.facebook.com/groups/1279756305383549/ Like Facebook page: https://www.facebook.com/Project-Hindi-1642018569381973 Making India Employable, Video Tutorials in Hindi. It is and will always be Free. Development for employability skills. Skills needed for Employment. Let's Teach India for Free.
Views: 3940 Project Hindi
XML Translation Class 3 - XLIFF core
 
31:51
This is the third session for the Portland State University XML Translations class, XML Fundamentals. Introduction to XLIFF XLIFF Core
Views: 449 Bryan Schnabel
Create XML Mappings and Transformations in MapForce
 
03:34
Learn how to use MapForce to map or transform XML data in a visual way, creating XSLT 1.0 or 2.0 transformation stylesheets, XQuery 1.0 documents, or program-code in Java or C#.
Views: 44867 Altova
Oracle SOA Composite - Working with File Adapters
 
22:53
This tutorial shows how to create a file adapter in a composite and write the data into a physical file.
Views: 3503 Oracle Fusion Hub
CS073 03.b. Oracle SQL Developer - 2 de 4
 
04:54
Instalación de un Database Driver, y de la herramienta visual cliente Oracle SQL Developer, la cual sirve para conectarse al Servidor de Base de Datos. Es parte del curso Base de Datos y SQL, disponible en http://www.mariontechacademy.org/category/mini-lectures/base-de-datos-y-sql/?order=ASC&orderby=NAME
Views: 7578 mariontechacademy
How to Add Validation in Oracle Service Bus
 
05:48
This demonstration shows you how to add validation in Oracle Service Bus 11g. You will see how to add logic to a Service Bus proxy service to check an incoming message, and if it is invalid, raise an error. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
XPath 2.0, XSLT 2.0, and XQuery 1.0 in Five Minutes with the XML Feature Pack
 
05:45
This demo shows how to use the XML Thin Client of the WebSphere Application Server (WAS) XML Feature Pack. It shows you how to get started with XPath 2.0, XSLT 2.0, and XQuery 1.0 in five minutes. For more information or to download the feature pack go to: http://bit.ly/XMLFEP Download links shown in the video: Thin Client Download - https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swg-wsasfpxml&S_PKG=code2 Demo files download - http://sites.google.com/site/wscbdownloads/spyker/thinclient-demo/thinclientdemo.zip?attredirects=0&d=1
Views: 10173 Andrew Spyker
Consultas usando Xml en SQL SERVER
 
26:21
Instrucciones para trabajar con XML en SQL 2008
Views: 11803 visoalgt
XSD NameSpace Concepts | XML Tutorial | Mr. Sarish B
 
21:24
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/xml-training/ ? For Online Training: https://nareshit.com/course/xml-web-services-online-training/ #C# #.net #html #css #Tutorials #Training #Videos -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/nares... ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 16796 Naresh i Technologies
oXygen XML Author and Relational Databases
 
02:51
oXygen XML Editor offers support for the following relational databases: IBM DB2, MySQL, Microsoft SQL Server, Oracle like browsing, querying using SQL or XQuery, editing XML content, importing from databases, generating XML Schema from database.
Views: 2307 oxygenxml
Optimistic vs Pessimistic Locking
 
03:49
www.bharaththippireddy.com UDemy Coupon Codes: https://www.udemy.com/microservices-rest-apis-using-spring-data-rest/?couponCode=SPRINGDATAREST Spring Framework in easy steps: https://www.udemy.com/springframeworkineasysteps/?couponCode=SPRINGFORALL Java Web Services https://www.udemy.com/java-web-services/?couponCode=WSDISCOUNT4ALL Java Web Services Part 2 https://www.udemy.com/javawebservicespart2/?couponCode=WSPART2FORALL Core Java Made Easy https://www.udemy.com/corejavamadeeasy/?couponCode=COREJAVAFORALL Junit and Mockito Crash Course https://www.udemy.com/junitandmockitocrashcourse/?couponCode=JUNITFORALL JDBC Servlets and JSP https://www.udemy.com/jdbcservletsandjsp/?couponCode=JAVAWEBFORALL XML and XML Schema in easy steps https://www.udemy.com/xml-and-xml-schema-definition-in-easy-steps/?couponCode=XMLANDXSDFORALL XSLT XPATH and XQuery Fundamentals https://www.udemy.com/xslt-xpath-and-xquery-fundamentals/?couponCode=XSLTXPATHANDXQUERY Free Java Script Fundamentals https://www.udemy.com/javascriptfundamentals Free Maven Crash Course https://www.udemy.com/mavencrashcourse
C# - Export Data From Database To [ HTML , XML and TXT ] File Using Csharp
 
08:50
C# - Export Data From Database To : 1.HTML 2.XML 3.TXT Classes and Form : https://www.dropbox.com/s/aftlvy02avhyj5y/Export%20Data.zip?dl=1
Views: 12744 SMPS TV
SOA Introduction Video Tutorial For Beginners | Basic Concepts
 
41:26
Visit Us: http://kerneltraining.com/ SOA Tutorial For Beginners, Know basics. In this session you can collect various information regarding this. Be aware of SOA introduction. All the details have to be known by the participants. Find the useful info on SOA concepts. Candidates need to pay special attention to it. Learn SOA Fundamentals by real time expert. Obtain details regarding installation, implementation and others. Get more information from SOA Tutorial for beginners. Know its various benefits, note down important points. In this session you will be learning about? Oracle SOA What is Oracle fusion middleware? What is SOA? Benefits of SOA SOA standards SOA service components. SOA introduction What is Oracle fusion middleware? It is collection of standards based software products that spans a range of tools and services. It offers complete support for deployment, development and applications management. SOA Fundamentals: SOA: Its stands for service oriented Architecture. It is known to be architecture for building business applications. It provides an enterprise architecture which supports building connected enterprise applications. Get more info SOA architecture tutorial. Benefits of SOA Loose coupling Interoperability Reusability Scalability Flexibility Set of integrated capabilities. Messaging. Service discovery Business rules Events framework Etc. Watch more SOA videos to know various concepts SOA standards: Service component architecture (SCA) assembly model. It provides the service details and there interdependencies to form composite applications. Find more on SOA development. Service data objects: It specifies a standard data method. XSL transformations (XSLT) It processes XML documents and transforms document data from one XML schema to another. Java connector architecture: It provides java technology solution to the problem of connectivity between many application services in EIS (that is enterprise information systems). Java message service (JMS): It provides a messaging standard that allows application components based on the Java 2 platform. Web services description language (WSDL) file: It provides the entry points into a SOA composite application. SOAP (simple object access protocol) It provides the default network protocol for message delivery. MDS (Meta data service) It is central repository inside OFMW. DVM (domain value maps) It is used at runtime to operate on actual data values. SOA service components: BPEL (business process execution language) Its provides process orchestration and storage of synchronous or an asynchronous process. Mediator: It routes event messages between different components. Business rule: It is use to design business decision based on rules. Also gather information on SOA administration. Thanks for watching SOA tutorial for beginners Kernel training provides SOA online training at affordable price. Classes will be taken by real time expert. For further details visit: http://kerneltraining.com/soa/ https://www.facebook.com/KernelTraining Free SOA demo class Get live interactive webinar. Access to LMS (Learning management system). Real time hands on experience 24/7 Support Visit our website: www.kerneltraining.com Contact us: Email Us: [email protected] Phone: 91 8099 77 6681 Regards Kernel training team.
Views: 34860 KernelTraining.Com
JAX-B (Java Architecture for XML Binding) | XML Tutorial | Mr. Satish B
 
38:47
** For Online Training Registration: https://goo.gl/r6kJbB ? Call: +91-8179191999 ? Visit Our Website for Classroom Training: https://nareshit.in/xml-training/ ? For Online Training: https://nareshit.com/course/xml-web-services-online-training/ #C# #.net #html #css #Tutorials #Training #Videos -------------------------- ? About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ? Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ? For Course Reg: https://goo.gl/r6kJbB ? Subscribe to Our Channel: https://goo.gl/q9ozyG ? Circle us on G+: https://plus.google.com/NareshIT ? Like us on Facebook: https://www.facebook.com/NareshIT ? Follow us on Twitter: https://twitter.com/nareshitech ? Follow us on Linkedin: https://in.linkedin.com/company/nares... ? Follow us on Instagram: https://www.instagram.com/nareshitech/
Views: 9214 Naresh i Technologies
Data source controls in asp net   Part 2
 
08:47
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/02/data-source-controls-in-aspnet-part-2.html Slides http://csharp-video-tutorials.blogspot.com/2013/10/part-2-data-source-controls-in-aspnet.html All GridView Text Articles http://csharp-video-tutorials.blogspot.com/p/free-asp.html All GridView Slides http://csharp-video-tutorials.blogspot.com/p/blog-page.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 The following are some of the different data source controls that are available in asp.net. SqlDataSource - Use to work with SQL Server, OLE DB, ODBC, or Oracle databases ObjectDataSource - Use to work business objects, that manages data AccessDataSource - Use to work with Microsoft Access XmlDataSource - Use to work with XML files LinqDataSource - Enables us to use LINQ, to retrieve and modify data from a data object EntityDataSource - Use to work with Entity Data Model Prior to the introduction of data source controls, developers had to write a few lines of code to retrieve and bind data with data-bound controls like DataGrid, GridView, DataList etc. With the introduction of these data source controls, we don't have to write even a single line of code, to retrieve and bind data to a data-bound control. SqlDataSource - Use to work with SQL Server, OLE DB, ODBC, or Oracle databases ObjectDataSource - Use to work business objects, that manages data AccessDataSource - Use to work with Microsoft Access XmlDataSource - Use to work with XML files LinqDataSource - Enables us to use LINQ, to retrieve and modify data from a data object EntityDataSource - Use to work with Entity Data Model We will discuss about, each of these data source controls in our upcoming videos. To bind data to a data bound control, like gridview there are 2 ways 1. Without using data-source controls 2. Using data-source controls If we are not using data source controls, then we have to write code to 1. Read connection string 2. Create connection object 3. Create SQL Command object 4. Execute the command 5. Retrieve and bind the results to the data-bound control. Code to bind data to a gridview control, without using data-source controls: string cs = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("Select * from tblProducts", con); con.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); } If we are using data source controls, we don't have to write even a single line of code. All, you have to do is, drag and drop a data-source control on the webform. Configure the data-source control to connect to a data source and retrieve data. Finally associate the data-source control, to a data-bound control using "DataSourceID" property. Points to remember: 1. "ConnectionString" property of the "SqlDataSource" control is used to determine the database it has to connect, to retrieve data 2. "SelectCommand" property specifies the command that needs to be executed. 3. DataSource control is associated, with the gridview control, using "DataSourceID" property of the GridView control. Please Note: All databound controls has DataSourceID property. A few examples of databound controls include 1. DropDownList 2. CheckBoxList 3. Repeater 4. DataList etc...
Views: 89735 kudvenkat
Database Query, Design, and Editing Tool - Intro to DatabaseSpy
 
02:09
Learn about Altova DatabaseSpy, the multi-database query, design, and editing tool from the makers of XMLSpy. DatabaseSpy works with all popular relational databases: Oracle, SQL Server, IBM DB2, MySQL, and more. You can open multiple database connections simultaneously even to different database types. Features like table browsing, data editing, SQL auto-completion entry helper, visual table design, multiple export formats, and more, all save time and ensure accuracy.
Views: 9758 Altova
SQL Server 2012 Querying - Basics of XML
 
09:14
http://www.trainsignal.com/SQL-Server-2012-Querying-Training.aspx?utm_source=YouTube&utm_medium=Social%20Media&utm_campaign=SQL%20Querying%20Demo In this free video from our SQL Server 2012 Querying Training, Christopher Harrison talks about the basics of XML and how it can be used with SQL Server. -~-~~-~~~-~~-~- This channel is an archive! Subscribe to Pluralsight for new IT Pro training ➨ https://www.youtube.com/user/Pluralsight?sub_confirmation=1 -~-~~-~~~-~~-~-
oXygen XML Author and Native XML Databases
 
03:00
oXygen XML Editor offers support for the following native XML databases: Berkeley, eXist, MarkLogic, Tamino, TigerLogic, X-Hive and Oracle XML like browsing multiple connections at the same time, querying using SQL or XQuery or editing XML content.
Views: 2996 oxygenxml