Query Resources

Share

Related resources for Query

Query List from Another SharePoint Online Sub Site Using REST API In SharePoint Online And Office 365 Using Nintex Workflows11/15/2019 10:28:26 AM. In this article, we explore how to query/filter the SharePoint online list from another SharePoint online sub site using REST API In SharePoint online.
Asp.Net MVC jQuery AJAX Form Submit using Serialize Form Data into a Model 11/6/2019 7:48:27 AM. In this article, we will learn Asp.Net MVC jQuery AJAX Form Submit using Serialize Form Data into a Model.
jQuery Traversing on DOM11/5/2019 10:30:57 PM. In this session, I will discuss about jQuery Traversing, DOM, and how can we traverse a DOM. We will also look into the types of traversing.
PowerQuery - Dynamically Pass Database Name as Parameter to fetch the Records from Different Datasets using Managed Parameters and Functions11/5/2019 7:38:00 AM. In this article, we will talk about how we can get the database name using Stored Procedure based on the Customer ID and pass that Database Name to another stored procedure as a Parameter to load the
Effective Paging, Sorting And Filtering Using SQL Server Stored Procedure10/29/2019 1:46:26 AM. In this article, I will cover and discuss the Effective Paging, Sorting and Filtering with Stored Procedure in MS SQL Server.
Reverse Geo Coding Using Google Maps API In Power Query10/23/2019 8:04:47 AM. In this article, you will learn how to reverse Geo coding using Google Maps API in Power query.
Introduction to HTML510/23/2019 3:51:27 AM. HTML5 is the latest version of HTML and XHTML with new features like Drawing, Animation, Video and Audio etc. It is used to solve some of the more common structural problems encountered with HTML 4.1.
The FAST number_rows Query Hint In SQL Server10/16/2019 9:50:00 AM. In this article, you will learn about fast number_rows query hint in SQL Server.
Create Azure Search Index, Load Data And Query From .NET SDK10/16/2019 8:07:57 AM. In this article, we will learn how to create Azure search index, load document/data to it and query the search results.
jQuery DataTables With ASP.NET Core Server Side Processing10/15/2019 6:57:52 AM. In this article we will try to look at jQuery DataTables with Asp.Net Core Server Side. The goal of this article is to make multiple column server-side sorting and searching along with pagination and
Get items from SharePoint List with ODATA Filter Query using FLOW10/9/2019 11:34:16 AM. In this video article we will see how to use ODATA filters queries to get items from SharePoint list using Microsoft FLOW.
TypeScript With JQuery10/9/2019 5:19:44 AM. In this article, you will learn about TypeScript with JQuery.
ASP.NET MVC - jQuery Tooltip Plugin10/3/2019 8:56:50 AM. This article is about the integration of jQuery Qtip plugin with ASP.NET MVC5 platform.
QueryString to Object (Custom Properties)9/25/2019 12:37:36 AM. In this article I have described how to handle a QueryString with minimal effort using the features of C#, reflection and generics.
Call WCF Service Using jQuery - Part 19/23/2019 12:02:31 AM. In this article you will learn WCF Service using jQuery.
Must Know 50 JQuery Interview Questions9/12/2019 10:08:17 PM. Here is a list of top JQuery interview questions and answers for freshers and experienced jQuery Developers. Get ready for your next jQuery interview.
How to Create Tooltip In jQuery9/11/2019 7:21:04 PM. This article explains how to create a simple tooltip using jQuery.
Display SharePoint List Data With jQuery DataTable In SharePoint Framework(SPFx) WebPart9/11/2019 12:19:45 AM. In this article, we will learn how to display SharePoint list data in the jQuery data table.
MVC - Return A File (Excel) From A Controller’s Action Method And Create An Excel Blob In To The jQuery Along With Loader Effect9/10/2019 8:45:41 AM. In this article, you will learn about returning a File (Excel) from a Controller’s Action method and creating an Excel Blob in to the jQuery along with Loader effect
Top 5 Tricky/Important SQL Queries And Their Answers9/5/2019 8:05:56 PM. In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.
Calling WCF Services Using jQuery9/3/2019 5:28:34 AM. This article provides a quick overview of how to call a simple WCF service using jQuery Ajax Method in ASP. Net.
Web Based Game Using JavaScript9/2/2019 11:01:02 AM. In this tutorial, I will discuss how we can create a web-based small game using HTML, CSS, and JavaScript.
CQRS Pattern - Command And Query Responsibility Segregation9/2/2019 10:48:00 AM. In this article, we are going to learn what CQRS Pattern is, how to use CQRS Pattern, when do we use CQRS Pattern, and how It affects our app.
Some Simple And Important SQL Server Query Based Interview Questions9/1/2019 9:33:58 PM. In this article I explain some important SQL query qustions that are commonly asked when you go for an interview for a position requiring one to three years of experience in this field.
Consuming WCF/ASMX/REST service using JQuery8/29/2019 5:54:16 AM. This step by step tutorial demonstrates how to consume WCF, ASMX, and REST service from an application using JQuery.
Searching, Sorting, Paging in ASP.NET GridView Using jQuery8/24/2019 9:56:40 PM. In this article, you will learn how to perform Searching, Sorting and Paging in an ASP.NET Gridview Control with simple JQuery.
Image Zoom in and Zoom Out Effect in JQuery On Mouse Move8/24/2019 9:20:22 PM. This code example explains use of mouseover() and mouseout () functions to zoom-in and zoom-out images in jQuery.
Zoom Image On Mouse Over Using jQuery8/24/2019 9:02:51 PM. In this article, I will explain how to zoom an image on mouse over using jQuery in ASP.NET.
How To Use Query Strings In ASP.NET8/22/2019 8:12:31 PM. In this article, we will learn how to use Query Strings in ASP.NET Websites.
Query String Using JavaScript8/20/2019 1:16:37 AM. This article explains how to use the query string properties and methods available in JavaScript.
SQL For Beginners8/9/2019 11:42:01 AM. In this video series, we will learn dive deep into the concept of Structured Query Language (SQL) from the very basics. This article is ideal for beginners who want to learn SQL from scratch.
ASP.NET - jQuery Datatables Plugin With Dynamic Numbers Of Columns8/8/2019 10:28:15 AM. This article is about dynamic number of columns loading using Jquery Datatables plugin with ASP.NET MVC5 platform
SQL Assessment API (Public Preview)8/6/2019 10:55:07 AM. Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.
How To Convert HTML To PDF With CSS And SVG(Chart) Using jQuery8/1/2019 12:08:32 AM. In this blog, I will explain how to make a PDF of my HTML page with CSS and SVG (since all charts give the SVG object). I will use jspdf.debug.js, html2canvas.min.js, and canvg.min.js in this article
Comparison Of Different SQL Query Responses Of SQL Server On Windows And Ubuntu Linux7/26/2019 2:28:39 PM. The article consists of some benchmark tests of SQL Server on different Operating Systems, the parameters considered are CPU Time, Elapsed Time and Total Execution Time.
On vs Where Clause in SQL Server 20127/18/2019 6:29:30 AM. Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
Calculating Factorial of a Number in SQL Server 20127/15/2019 4:16:13 AM. Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.
SQL Join Query With LINQ7/15/2019 3:51:55 AM. In this article, I will show you how to create SQL queries in LINQ. LINQ Join queries.
ASP.NET MVC 5 - Time Picker Plugin7/11/2019 2:31:14 AM. This article is about integration and basic usage of the Bootstrap Time Picker jQuery plugin in ASP.NET MVC5 platform.
Best Practices And Programming Guidelines In SQL Server - Part One7/11/2019 1:40:24 AM. In this article, we will learn the best Practices, and Programming Guidelines in SQL Server.
Distributed Databases in SQL Server7/10/2019 6:27:35 AM. In this article, I will cover on distribution of SQL queries where each system manages a single copy of data, and uses distributed transaction mechanisms to access local and remote data.
Working With Command Object in ADO.NET7/9/2019 2:35:03 AM. In this article, we will learn how to work with the Command Object in ADO .NET and the Execute Methods in the Command Object.
Count All vs Count Distinct in SQL Server7/8/2019 9:53:12 AM. In this article, you will see the SQL aggregate function count in two forms, Count All and Count Distinct.
Tips to Improve SQL Database Performance7/4/2019 12:25:52 AM. The performance is main concern of any application. Database plays very important role in application. There are some points that can help us to improve the performance of SQL Server.
Display Stored Procedure Output Parameter Value With Query Window in SQL Server 20127/2/2019 1:05:32 AM. In this article, I am showing you how to display return value from stored procedure output parameter in Query Window in SQL Server 2012.
Check If String Contains Substring In JQuery7/1/2019 2:29:01 AM. In this article, learn how to search string or substring in JQuery or JavaScript. JQuery Substring or JavaScript Subscript code example.
T-SQL Query Performance Tuning Tips6/30/2019 9:47:40 PM. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
Batch Query Using sp-pnp-js6/21/2019 5:35:46 AM. In today's coding world, most of the developers think that everything should be reusable. Based on this point, I am writing this article for reusable batch query in SPFx using SP-Pnp-Js.
Adding Subquery in a Select Statement in SQL Server 20126/20/2019 6:09:57 AM. Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
.Slice() Method In jQuery6/10/2019 8:02:37 AM. jQuery Slice() method gets a subset of the matched elements by giving a range of indices. Here is a jQuery.Slice() code example.
Implementation Of jQuery Data Table In ASP.NET Web Forms6/9/2019 11:58:57 PM. In this article, we will discuss how to implement jQuery data table in ASP.NET web forms.
Query Optimization in SQL Server6/7/2019 5:05:09 AM. This article offers suggestions on how to optimize query performance in SQL Server 2005.
Apply Filter Query With Get Items SharePoint Action In Microsoft Flow6/4/2019 8:20:13 AM. In this article, we will talk how we can apply the Filter Query within the “Get Items” action of SharePoint.
How To Optimize SQL Queries5/28/2019 5:08:37 AM. In this article, you will learn how to optimize SQL Query.
Tips to Increase SQL Server Query Performance: Part 25/28/2019 5:05:43 AM. This article provides more tips to increase SQL Server query performance.
Tips to Increase SQL Server Query Performance: Part 15/28/2019 5:04:36 AM. In this article we will learn how to increase the query performance in SQL Server.
IQueryable Vs Queryable X IEnumerable Vs Enumerable Vs IEnumerator X IList Vs List 5/22/2019 9:24:58 AM. In this article, we will learn the differences and importance of each one - IQueryable, Queryable, IEnumerable, Enumerable, Enumerator, IList, and List.
Custom Alert, Prompt, And Confirm Box Using jQuery And Bootstrap5/17/2019 8:40:17 AM. In this article, you will learn about custom alert, prompt, and confirm box using jQuery and bootstrap.
All The Steps For Query Execution In Entity Framework5/13/2019 9:25:18 AM. In this article, we will be exploring the life cycle of query execution in Entity Framework.
Querying a Data Table Using Select Method and Lambda Expressions in C#5/9/2019 1:06:47 AM. In this article, we are explaining how we can perform several queries on a DataTable object using the select method and Lambda expression.
SharePoint 2013 - Showing List Data In jQuery Datatable With Advanced Feature4/18/2019 8:15:34 AM. In this article, we will explore how we can retrieve the data from the SharePoint List using the REST API and bind it to the jQuery DataTable.
Fetching Data Based On Date Field Using WebAPI4/9/2019 8:48:35 AM. This article is about using WebAPI request for datatime field in Dynamics 365 CE
How To Load Partial Views In ASP.NET MVC Using jQuery Ajax4/9/2019 6:06:56 AM. In this article, we'll discuss partial views in ASP.NET MVC and loading them via jQuery AJAX.
IEnumerable Vs IQueryable In LINQ4/7/2019 11:11:13 PM. In this article, I will demonstrate how to use IEnumerable and IQueryable in C#. Also learn the differences between IEnumerable and IQueryable.
Top 30 Important SQL Queries For Developers4/1/2019 9:21:52 AM. In this SQL article, I will introduce you to some important SQL queries and technical points. This article is a guide for you to learn the concepts related to SQL. It starts with the basic SQL queries
Query On Stored Data In MongoDB - Part Three3/18/2019 12:31:16 AM. In this article, we will discuss about different process to fetch document data from MongoDB.
Advanced Query Search On Stored Data In MongoDB - Part Four3/18/2019 12:30:47 AM. In this article, we will discuss the advanced search command of a MongoDB Database. If you want to read the previous articles of these series, then follow the links.
GET and POST Calls to Controller's Method in MVC3/17/2019 10:13:24 AM. In this article I am going to cover some really interesting material that is very useful today in web application development. You will learn how to make jQuery Ajax GET and POST calls to controller m
jQuery PJAX Implementation In ASP.NET Core2/25/2019 8:48:57 AM. You can make an entire website work asynchronously using PJAX plugin of jQuery. I will show you how to implement it in ASP.NET Core.
Quick Start With Azure Cosmos DB - Day Five2/18/2019 1:15:57 AM. In this article, we will see how we can execute SQL queries on JSON documents and get filtered results.
Azure Cosmos DB With SQL Query Cheat Sheet PDF2/17/2019 11:45:26 PM. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly
Querying Cosmos DB In Azure Databricks Using Cosmos DB Spark Connector2/17/2019 11:36:45 PM. We will create a Cosmos DB service using SQL API and query the data in our existing Azure Databricks Spark cluster using Scala notebook. We use Azure Cosmos DB Spark Connector for this.
All About IEnumerable and IQueryable2/12/2019 9:00:34 AM. When we talk about LINQ, we consider two collections, IEnumerable and IQueryable. In this article, we will learn all about IEnumerable and IQueryable, except how they are evaluated. Possibly, I will c
Difference Between IQueryable, IEnumerable, And IList In LINQ2/10/2019 11:15:21 PM. This article explains how to work with IQueryable and IEnumerable and IList in LINQ. Also, it tells when to use IQueryable and IEnumerable in real-time scenarios.
Dealing With JSON - Using Power Query In Azure Analysis Services2/6/2019 6:08:41 AM. In this article, I’ll explain some of the mechanics of the solution, using fake data to “hide the innocent” but still offer some concrete details you can use in your own solutions.
Use Of DISTINCT Keyword In T-SQL (SQL Server)2/5/2019 6:24:45 AM. In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.
ASP.NET Web API Query String Parameter1/28/2019 9:43:02 AM. In this article, we are going to learn query string parameters in ASP.NET Web API.
Server-Side Processing With Custom Range Filtering Using MVC And Entity Framework1/26/2019 2:43:23 PM. I have added my own custom search area with input fields to implement server-side processing with custom range filtering in jQuery DataTables.
Expand/Collapse Table Rows With jQuery 1/24/2019 9:33:54 AM. In this article, we will explore two ways to expand/collapse HTML table rows.
Paging and Sorting ListViews with ASP.NET MVC and jQuery1/24/2019 3:34:45 AM. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an AS
Paging and Sorting ListViews with ASP.NET MVC and jQuery using VB.NET1/23/2019 11:55:52 PM. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an AS
SQL Database Query Editor In Azure Portal - An Introduction1/16/2019 11:47:22 PM. Learn SQL Database Query Editor In Azure Portal.Query Editor is a great tool but it has very limited features. It has a subset of the functionality of SQL Server Data tools and SQL Server Management S
ASP.NET MVC 5 - Matchheight.js📦 - Create Equal Height Of Columns In Row Using jQuery1/16/2019 12:59:49 AM. Here, we are going to learn how to match the height of the tallest of each row by the column height and why should learn this.
NHibernate Querying In Core 2.2 Framework1/14/2019 8:47:06 AM. NHibernate O/RM framework is one of the competitors of Entity Framework and one of the most popular of the old frameworks of .NET. Let's learn about NHibernate Querying In Core 2.2 Framework.
Remote DataBinding In Kendo SpreadSheet12/31/2018 11:00:57 PM. From this article you will learn how to implement the remote data binding in Kendo spreadsheets.
jQuery DataTables in ASP.NET MVC12/19/2018 4:01:33 AM. This article explains jQuery DataTables in ASP.NET MVC. jQuery DataTable plugin has good performance if an application renders thousands of records on a web page.
Basic Calculator Using Cordova12/12/2018 10:54:35 PM. This article explains how to create your own hybrid app using Cordova (Phone Gap) and jQuery Mobile. The sample is a simple basic calculator.
7 Ways To Avoid jQuery .each() Method With An Equivalent JavaScript .forEach() Method12/6/2018 9:36:50 AM. This tutorial explains the 7 important ways to work with the JavaScript .forEach() method so that you can replace your jQuery .each() method's code with it.
Inserting Data Using jQuery Ajax POST Method In ASP.NET MVC 512/6/2018 3:33:52 AM. In this article, we will learn how to insert data using jQuery Ajax Post method in ASP.NET MVC 5.
How to Add jQuery Datepicker in MVC12/3/2018 4:07:06 AM. In this article you will learn how to add a jQuery Datepicker in MVC. ASP.NET MVC DatePicker sample. jQuery provides built-in support for a DateTime picker.
How To Install MongoDB Locally And Perform CRUD Operations (Basic-Query)12/1/2018 7:19:54 AM. This video explains how to perform basic CRUD operation on MongoDB using MongoShell. We will learn the functionality and usage of find, insertOne, insertMany, deleteOne, deleteMany, updateOne,updateMa
Dynamic LINQ Query In C#11/30/2018 5:25:13 AM. This article shows how to use a dynamic LINQ library in C#. We will learn how to use SELECT Statement at runtime in Linq C#
Using OData Query Options In ASP.NET Web API11/28/2018 9:26:08 AM. Here is how we can use OData query Option in ASP.Net Web API, What are OData Query options: There can be a requirement wherein client sends some parameters in request URI and those parameters are appl
Useful Way to Call Controller Actions From HTML Using jQuery11/27/2018 4:29:48 AM. In this topic, I am showing some useful ways to call controller actions to be executed and return results to your UI (view) page. $.get() method, $.post() method, $.ajax() method.
Performance Issue In jQuery DataTable About Fetching Records And Steps To Fix It11/26/2018 9:46:07 AM. To resolve this performance issue, I am going to show you datatables server-side paging, sorting and filtering in asp.net MVC application.
Creating A Custom DataTable In MVC Using Entity Framework And jQuery/AJAX11/25/2018 11:09:15 PM. In this article, I will create a Custom Datatable in MVC using Entity Framework and Jquery / Ajax. Although there is jquery’s Datatable which can be used easily but here I will do server - side pagina
Understand jQuery Ajax Function: Call Code-behind C# Method11/23/2018 4:44:20 AM. In this article we will learn how to an implement ajax method in JQuery.
Reading An Excel File Using HTML 5 And jQuery11/22/2018 3:01:08 AM. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
Difference Between JavaScript And jQuery11/18/2018 11:08:23 PM. This article is mainly for developers who are new into web development. People who start their career will questions like why jQuery while there is JavaScript or difference between JavaScript and jQue
Some Common Mistakes When Querying SQL Database11/12/2018 5:10:18 PM. When I started learning SQL, I found out several issues, which I thought to be interesting to share. For our needs, let us use AdventureWorks2012 database, which can be obtained here.

C# Corner

Topics