View Data

Imports System.Data
Imports System.Data.OleDb 
' some code here 
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 
' create a connection string 
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Northwind.mdb" 
Dim myConnection As OleDbConnection = New OleDbConnection() 
myConnection.ConnectionString = connString 
' create a data adapter 
Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Customers", myConnection) 
' create a new dataset 
Dim ds As DataSet = New DataSet() 
' fill dataset 
da.Fill(ds, "Customers") 
' write dataset contents to an xml file by calling WriteXml method 
' Attach DataSet to DataGrid 
DataGrid1.DataSource = ds.DefaultViewManager 
End Sub 
End Class 






View and Insert



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

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

        private void Form1_Load(object sender, EventArgs e)
        {
            FillGrid(); 

            
        }
     public void FillGrid()
        {
            string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=book.mdb";
            OleDbConnection myConn = new OleDbConnection(strCon);
            string strCom = "SELECT * FROM bookstock";

            //Make a DataSet
            DataSet myDataSet = new DataSet();

            myConn.Open();
            //Using the OleDbDataAdapter execute the query
            OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
            //Fill the Data set with the Table 'bookstock'
            myCommand.Fill(myDataSet, "bookstock");
            //  dg.DataSource=myDataSet  ;

            DataView dv = myDataSet.Tables[0].DefaultView;
            dg.DataSource = dv;
            //Close the OleDbConnection
            myConn.Close();
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=book.mdb";
            OleDbConnection myConn = new OleDbConnection(strCon);
            myConn.Open();
            string strSQL = "INSERT into bookstock(bookid,booktitle,bookauthor,bookprice,bookstock)VALUES('" + t_id.Text + "','" + t_title.Text  + "','" + t_author.Text  + "','" + t_price.Text  + "','" + t_stock.Text + "')";
           //ExecuteStatement(strSQL);
            OleDbCommand mycomm=new OleDbCommand(strSQL,myConn);
            mycomm.ExecuteNonQuery ();
            FillGrid();
            t_id.Text="";
            t_title.Text="";
            t_author.Text ="";
            t_price.Text ="";
            t_stock.Text  = "";

             
        }

        private void dg_Edit(object sender, DataGridViewEditMode e)
        {
            MessageBox.Show("Hell");
            string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=book.mdb";
            OleDbConnection myConn = new OleDbConnection(strCon);
            myConn.Open();
            string strSQL = "UPDATE into bookstock SET "+ 
               " bookid='" + t_id.Text + "',+"+
            "booktitle='" + t_title.Text + "',+"+
            "bookauthor='" + t_author.Text + "',+"+
            "bookprice='" + t_price.Text + "',+"+
            "bookstock='" + t_stock.Text + "'"+
            "WHERE bookid=e.ToString";
            //ExecuteStatement(strSQL);
            OleDbCommand mycomm = new OleDbCommand(strSQL, myConn);
            mycomm.ExecuteNonQuery();
        }

      

            }


        }