计算机基础在线阅读,计算机基础知识

private void button1_Click(object sender, EventArgs e)

{

//测试，将excel中的sheet1导入到sqlserver中

string connString =

"server=localhost;uid=sa;pwd=sqlgis;database=master";

System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();

if (fd.ShowDialog() == DialogResult.OK)

{

TransferData(fd.FileName, "sheet1", connString);

}

}

public void TransferData(string excelFile, string sheetName, string

connectionString)

{

DataSet ds = new DataSet();

try

{

//获取全部数据

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data

Source=" + excelFile + ";" + "Extended Properties=Excel 8.0;";

OleDbConnection conn = new OleDbConnection(strConn);