LINQ for absolute beginners

-
Language INtegrated Query


Check the demo below

Comments

Post a Comment

Popular posts from this blog

How to check the Hybrid Connection in Azure Website (Webapp)

-
Image
Introduction Hi, this article will helpful for you to check the hybrid connection in Azure Website (Web App). Scenario Lets assume we have 2 Web Apps and 2 On-Premises database servers, Both the webapps required on-premises database access, for this scenario we can use Azure Hybrid connection . Architecture of Web apps and Hybrid connection Website 1 : Wants to access DB Server 1 & DB Server 2 Website 2 : Wants to access DB Server 1 only To achieve this we need to create two hybrid connections for each db and we can share it with websites. Troubleshooting Once you successfully created hybrid connection and configured listener setup. we need to ensure whether our website connected to our DB Server or not. So open the Azure portal (old or new). 1. Select the website 2. Click Browse website       * Lets assume our website URL is https://myweb.azurewebsites.net       * Change the URL to https://myweb.scm.azurewebsites.net...
Read more

Know more about Azure Website KUDU?

-
Image
KUDU  is the web tool for analyzing and troubleshooting azure websites. Benefits of Kudu Know about operating system Environment variables Processors & cores Applications settings Connection strings Process explorer (running instances) Debugging console (Command prompt & PowerShell) Diagnostics Log (view & download) Site extensions management and more Environment details Command prompt Are your wondering to use KUDU?, its very simple open browser and type https://{ your azure website name }.scm.azurewebsites.net . To access KUDU you need to have your azure deployment credentials! Example Your azure website : https://textingwebsite.azurewebsites.net/ Kudu URL : https://textingwebsite.scm.azurewebsites.net/ for more information about Kudu click here
Read more

Using MS Access with C#.Net

-
Image
This video demonstrate the connection establishment with the MS Access database with the C#.Net Sample Screen : Table Structure Source Code : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace DatabaseConnection { public partial class Form1 : Form { OleDbConnection vcon=new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\admin\My Documents\Database2.accdb"); public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { vcon.Open(); } private void button3_Click(object sender, EventArgs e) { this.Close(); } private void button1_Click(object sender, EventArgs e) { string vsql = string.Format("insert in...
Read more