OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.InitialDirectory = "c:";//注意这里写路径时要用c:而不是c:
openFileDialog.Filter = "文本文件|*.*|C#文件|*.cs|所有文件|*.*";
openFileDialog.RestoreDirectory = true;
openFileDialog.FilterIndex = 1;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{ string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
str += @openFileDialog.FileName.Substring(0, openFileDialog.FileName.LastIndexOf('\\') + 1) + ";Extended Properties=\"Text;HDR=Yes;FMT=Delimited\""; dsuser = Conn.ReturnDataSet(str, CommandType.Text, "Select * From " + openFileDialog.FileName.Substring(openFileDialog.FileName.LastIndexOf('\\') + 1, openFileDialog.FileName.Trim().Length - (openFileDialog.FileName.LastIndexOf('\\') + 1)), "data"); foreach (DataColumn dc in dsuser.Tables[0].Columns)
{
MessageBox.Show(dc.ColumnName);
//文件格式如下,提示发现只有一列,名列为h_no_name_zino_qx_flag_ziwen_card_pwd,tab用下划线来了
}
}
}
jh no name zino qx flag ziwen card pwd
8 9 朝生 0 0
openFileDialog.InitialDirectory = "c:";//注意这里写路径时要用c:而不是c:
openFileDialog.Filter = "文本文件|*.*|C#文件|*.cs|所有文件|*.*";
openFileDialog.RestoreDirectory = true;
openFileDialog.FilterIndex = 1;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{ string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
str += @openFileDialog.FileName.Substring(0, openFileDialog.FileName.LastIndexOf('\\') + 1) + ";Extended Properties=\"Text;HDR=Yes;FMT=Delimited\""; dsuser = Conn.ReturnDataSet(str, CommandType.Text, "Select * From " + openFileDialog.FileName.Substring(openFileDialog.FileName.LastIndexOf('\\') + 1, openFileDialog.FileName.Trim().Length - (openFileDialog.FileName.LastIndexOf('\\') + 1)), "data"); foreach (DataColumn dc in dsuser.Tables[0].Columns)
{
MessageBox.Show(dc.ColumnName);
//文件格式如下,提示发现只有一列,名列为h_no_name_zino_qx_flag_ziwen_card_pwd,tab用下划线来了
}
}
}
jh no name zino qx flag ziwen card pwd
8 9 朝生 0 0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货