读取Excel中的数据方法()
using System.Data.OleDb;
private void btnGetDS_Click(object sender, EventArgs e)
{
OpenFileDialog o=new OpenFileDialog();
DataTable dt =New DataTable();
if(o.ShowDialog()==DialogResult.OK)
dt =ExecleDs(o.FileName, "sky").Tables[0];
string strConn = "Data Source=.;DataBase=gongnuan;Uid=sa;Pwd=sa";//连接自己数据库的字符串,自己写吧
OleDbConnection cn = new OleDbConnection(strConn);
for (int i = 0; i < dt.Rows.Count; i++)
{
//日期 excel列名【这里获得某行的每列的值组成插入Sql语句。自己填完整吧,记得,如果某列是string类型的话要加单引号‘’】
string pininputdate = dt.Rows[i]["depId"].ToString() + dt.Rows[i]["depName"].ToString() + "其它的列,你自己写吧";
string insertstr = "insert [表名] values("+ pininputdate+")";
OleDbCommand cmd = new OleDbCommand(insertstr, cn);
try
{
cmd.ExecuteNonQuery();//插入某一行,直到FOR循环完结,即插入完成
}
catch (Exception ex) //捕捉异常
{
MessageBox.Show(ex.Message);
}
}
//至于treeView刷新,这个你应该知道的,和你初始化时一样,清空后,再添加一次就可以拉
}
public DataSet ExecleDs(string filenameurl, string table)
{
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn);
odda.Fill(ds, table);
return ds;
}
不行的话,再叫我~~~
温馨提示:内容为网友见解,仅供参考