Nguyễn phúc minh phầN 1 DataProvider

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 Microsoft.Office.Interop.Excel;

using System.Data.OleDb;

namespace KetNoiExcel

{

public partial class Form1 : Form

public Form1()

{

InitializeComponent();

private static string filePath = "F:\\test.xlsx";

//dọc

private void btnDoc_Click(object sender, EventArgs e)

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + filePath + "';Extended Properties=\"Excel 12.0;HDR=YES;\"");

{

conn.Open();

DataSet ds = new DataSet();

a.Fill(ds);

dg1.DataSource = ds.Tables[0];

conn.Close();

}
}
//ghi

private void docDL(string sheet)

{

using (OleDbConnection conn = new OleDbConnection(kn))

conn.Open();

OleDbDataAdapter objDA = new System.Data.OleDb.OleDbDataAdapter

("select * from[" +sheet + "$]", conn);

DataSet excelDataSet = new DataSet();

objDA.Fill(excelDataSet);

dg1.DataSource = excelDataSet.Tables[0];

}

}

{

{//ghi du lieu vao file excel

{

try

conn.Open();

OleDbCommand cmd = new OleDbCommand();

cmd.Connection = conn;

cmd.CommandText = @"Insert into[Sheet1$] (stt, hovaten, quequan) VALUES(‘1′,’Khoa’,’An Giang’);";

cmd.ExecuteNonQuery();

}

catch (Exception ex)

//exception here

}

finally

conn.Close();

conn.Dispose();

}

}

}

}

private void btnCapNhat_Click(object sender, EventArgs e)

{

{//UPDATE DU LIEU

{

try

conn.Open();

OleDbCommand cmd = new OleDbCommand();

cmd.Connection = conn;

string cl = "UPDATE[Sheet1$] SET hovaten = '" +

txtHoVaTen.Text + "', quequan = '" +txtQueQuan.Text + "' where STT =" +txtSTT.Text;

cmd.CommandText = cl;

cmd.ExecuteNonQuery();

}

catch (Exception ex)

//exception here

}

finally

txtHoVaTen.Text = "";

txtQueQuan.Text = "";

conn.Close();

conn.Dispose();

}

docDL("Sheet1");

}

}

{

if(e.RowIndex >= 0)

DataGridViewRow row = this.dg1.Rows[e.RowIndex];

txtSTT.Text = row.Cells[0].Value.ToString();

txtHoVaTen.Text = row.Cells[1].Value.ToString();

txtQueQuan.Text = row.Cells[2].Value.ToString();
txtSTT.Enabled = false;

}

}