Step By Step MsAccess DataBase Connection To Visual Studio 2012 Using OleDb Connection in C#.Net Window Application

MsAccess DataBase Connection To Visual Studio

MsAccess DataBase Connection To Visual Studio Using OleDb Connection in Window Application  Store Values To MsAccess DataBase in Particular Persional Computer(PC) C#.Net.

"MsAccess Close After Table & Field Created "

" If Open MsAccess Does Not Work In Visual Studio"


                                 DEMO





C# CODING


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;


namespace MsAccess_Creation
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Database3.accdb");
            con.Open();

    OleDbCommand cmd = new OleDbCommand("insert into Register(name,mobile)values('"+txtName.Text+"','"+Convert.ToInt32(txtMobileNumber.Text)+"')",con);

            cmd.ExecuteNonQuery();

            MessageBox.Show("Data Register");

        }
    }
}



First - Open - MsAccess Sheet






Next -Create New DataBase







Next - Create Table Fields & ID Automatic Generates







Next - Add New - Field - Select DataType = Text







Next - Change The Field Name = name






Next - Add New Field DataType=Number






Next - Click Save Button 






Next - Open - PopUp  Window - Change Table Name = Register - OK






If Want To Change The DataType  - Right Click Table Name- Go - To Design View 







Next - Change The DataType In Particular Fields







Next - Open The DataBase Source Folder - Copy To Change Another Colon(Drive)







Next - Change  To E Colon







Next - Server Explorer - Connect To Server 






Next - Select - Change Button 






Next - Change Data Source = Microsoft Access DataBase File.






Next - Select - Browse Button 






Next - Select DataBase  From E Drive - Open







Next - Get The DataBase From Drive Path 







Next - Click The Test Connection - Connection Succceded - OK






Next - Open DataBase From Server Explorer






Next - Select TextBox From  ToolBox - Change Id 






Next - Select TextBox From  ToolBox - Change Id 







Next - Go To - Data - Select  - OleDbConnection  






Next - OleDb Connection - Property - ConnectionString - DataBase Select 






Next - DataBase - Connection String Path Get 






Next - Add OleDb Connection Name Spaces - Insert Query Using OleDb Connection - Mobile Number Change To Integer Because DataType = Number






Next - Run[F5] - Enter Values To TextBox  - Register






Next - Data Register 






Next - Open Registered Data in Visual Studio








Next - Open MsAccess DataBase 






Next - Select - Table Name - Open






Next - Show Registered Data's From MsAccess DataBase










0 comments:

Post a Comment