using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
public class Form1
{

    System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=shreyas; User=root;Password=;");
    System.Data.Odbc.OdbcCommand cmd;
    System.Data.Odbc.OdbcDataAdapter adp;

    DataSet ds = new DataSet();
    private void Form1_FormClosing(object sender, System.Windows.Forms.FormClosingEventArgs e)
    {
        cn.Close();
    }


    private void Form1_Load(System.Object sender, System.EventArgs e)
    {
        // Fill the data grid viewer
        cn.Open();
        cmd = new System.Data.Odbc.OdbcCommand("Select * from trial1", cn);
        adp = new System.Data.Odbc.OdbcDataAdapter(cmd);
        adp.Fill(ds, "trial1");
        this.DataGridView1.DataSource = ds;
        this.DataGridView1.DataMember = "trial1";

    }

    private void Button1_Click(System.Object sender, System.EventArgs e)
    {
        //Update records using a Command Builder
        // The variable i gives the number of records updated
        System.Data.Odbc.OdbcCommandBuilder cmdbuilder = new System.Data.Odbc.OdbcCommandBuilder(adp);
        int i = 0;
        try {
            i = adp.Update(ds, "trial1");
            Interaction.MsgBox("Records Updated= " + i);
        } catch (Exception ex) {
            Interaction.MsgBox(ex.Message);
        }
    }
    public Form1()
    {
        Load += Form1_Load;
        FormClosing += Form1_FormClosing;
    }


}