/// <summary>
/// 将csv格式文件导成dataset
/// </summary>
/// <param name="filePath">文件路径</param>
/// <param name="fileName">文件名</param>
/// <returns></returns>
private DataSet getCsv(string filePath,string fileName)
{
string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
strConn += filePath;
strConn += ";Extensions=asc,csv,tab,txt;";
OdbcConnection con = new OdbcConnection(strConn);
DataSet data = new DataSet();
string sql = "select * from " + fileName;
OdbcDataAdapter adp = new OdbcDataAdapter(sql, con);
// con.Open();
adp.Fill(data);
return data;
} /// <summary>
/// 把DataSet数据插入数据库
/// </summary>
/// <param name="_Ds"></param>
/// <param name="_TableName">表名</param>
/// <returns></returns>
public bool BulkData(DataSet _Ds, string _TableName)
{
string strConn = "server=.;database=filesSync;uid=sa;pwd=123"; SqlConnection SqlCon = new SqlConnection(strConn); SqlCon.Open(); SqlBulkCopy SqlBulk = new SqlBulkCopy(SqlCon); SqlBulk.DestinationTableName = _TableName; try
{
SqlBulk.WriteToServer(_Ds.Tables[0],DataRowState.Unchanged); return true; } catch
{
return false; } finally
{ SqlCon.Close(); SqlCon.Dispose(); SqlBulk.Close(); } }DataSet ds = getCsv("E:\\", "yx.csv");
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
bool isbool = BulkData(ds, "td_Data");
if (isbool)
{
Response.Write("<script>alert('导入成功');</script>");
}
else
{
Response.Write("<script>alert('导入失败');</script>");
}把csv文件导成dataset成功,但是把dataset的内容导入数据怎么失败
SqlBulk.WriteToServer(_Ds.Tables[0],DataRowState.Unchanged);这句报错
无法访问目标表 tb_Data
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货