Introduction While developing Ado.Net Applicaions most of the errors comes because of the wrong format of Connection String used to connect the application with the DataBase. I am publishing some Connection String formats to connect with different types of DataBase. Connection String Formats To connect with the Ms-Access 2003 DataBase Connection String Format: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Full […]
Tag Archives: SQL Server
I’ve recently been using AWS CloudWatch to collect, display and alert on various monitoring metrics. I initially found it quite hard to find and piece together [working] examples on the internet that were basic enough to be understandable, whilst showing enough complexity to demonstrate useful functionality. The main issue I found with examples on the […]
Recently I was tasked with creating a PayPal IPN Listener, so I started with getting familiar with the PayPal Instant Payment Notification (IPN) documentation:
For this implementation I’m using a MVC Web API Controller (VB.Net) for the listener, along with some helper classes/extensions/methods. I’m also using a SQL Server 2012 table and stored procedure to create a notifications log, which allows you to:
LoopBack is the leading open source, enterprise-ready Node.js framework for helping developers to create APIs integrated with legacy and next gen backends that at the same time enables mobile and micro services architectures.
LoopBack models connect to backend systems like databases via data sources that provide create, read, update and delete (CRUD) functions through the LoopBack Juggler: a modern ORM/ODM. These data sources are backed by connectors that implement connection and data access logic using database drivers or other client APIs. In addition, there are connectors for REST and SOAP APIs, NoSQL, messaging middleware, storage services and more. For example, StrongLoop maintains connectors for:
Hello all, in this article we’ll discuss the concept of pages in SQL Server and we’ll also check how data is stored in Data Pages.
We all know how to insert data into a table in a database and we also do that. When we execute a query to insert data into a table, we know that the data will be stored in the Data Pages. But do you ever think, how does SQL Server store that data in those Data Pages?
Have you ever tried to open those Data Pages to check, how your data looks in those Data Pages? What happens when you try to insert data, say 100 rows in a table and your data file can only take 60 rows, what about the remaining 40 rows? How and where does SQL Server store those 40 rows?
After entering records into a Data Page, how much free space is available in the Data Page?
If you don’t know the answer to all of that, not to worry, keep calm and just remain with me in this article.
So, before starting our journey, let’s create a couple of things with which we’re going to play, to understand the preceding questions. So, we’ll need a database and a table.
In this tutorial I will show you how to create a database search form that employs SQL wildcards. Additionally, we will create a dynamic query by populating a ComboBox with database records and using those records as search criteria.
4:08 Adding a SQL Compact Database
5:14 Create your SQL Control Class
28:46 Design your SQL Search Form
34:27 Set up the Database & Add Records
40:36 Fill the DataGridView from your Database
47:20 Create a Wildcard Search Sub
58:12 Create a Dynamic ComboxBox Search