Skip to main content

A Technical Talk on Microservices and Cloud Deployment

This is a full-length session of microservices development using Microsoft .Net Core WebAPI(C#.Net) and Mongo DB as backend. The session presentation available below   The source code of session available in GitHub , feel free to share your feedback and contribute to this project Full session video Prerequisites for development MongoDB (you can download from here ) Visual Studio 2019 DotNet Core 3.1.x SDK Postman (for API Testing)

Using MS Access with C#.Net




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 into student_details values({0},'{1}',{2},'{3}')", int.Parse( textBox1.Text), textBox2.Text, int.Parse(textBox3.Text), textBox4.Text);
OleDbCommand vcom = new OleDbCommand(vsql, vcon);
vcom.ExecuteNonQuery();
MessageBox.Show("Data stored successfully");
vcom.Dispose();
}

private void button4_Click(object sender, EventArgs e)
{
string vsql = "select * from student_details ";
OleDbCommand vcom = new OleDbCommand(vsql, vcon);
DataSet vds = new DataSet();
OleDbDataAdapter vda = new OleDbDataAdapter(vcom);
vda.Fill(vds, "res");
dataGridView1.DataSource = vds.Tables["res"];
vda.Dispose();
vcom.Dispose();
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text="";
textBox4.Text = "";
textBox3.Text = "";

}
}
}





Direct Link : Click here

Comments

Popular posts from this blog

Know more about Azure Website KUDU?

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

Resource Explorer (DLL/Exe) using C#

After long time we are with the Resource Explorer. This is verymuch usefull for the resource management in the Application/DLL. Purspose     You are having the images/icon in other dll then you can load and use that particular image/icon using the below concept Source Code: public partial class frmAssemblyHandling : Form { public frmAssemblyHandling() { InitializeComponent(); } private void btnSelectDLL_Click( object sender, EventArgs e) { //the required resources to filter from the available ArrayList arImageFilter = new ArrayList (); arImageFilter.AddRange( new string [] { ".png" , ".ico" , ".bmp" , ".png" }); OpenFileDialog fd = new OpenFileDialog (); fd.Filter = "DLL Files (*.Dll)|*.dll|Application Files (*.exe)|*.exe" ;

A Technical Talk on Microservices and Cloud Deployment

This is a full-length session of microservices development using Microsoft .Net Core WebAPI(C#.Net) and Mongo DB as backend. The session presentation available below   The source code of session available in GitHub , feel free to share your feedback and contribute to this project Full session video Prerequisites for development MongoDB (you can download from here ) Visual Studio 2019 DotNet Core 3.1.x SDK Postman (for API Testing)