读取文件夹中的文件并修改数据库中的数据
OraHelper OraHelper = new OraHelper();
private void btnRead_Click(object sender, EventArgs e)
{
string[] strFiles = Directory.GetFiles(@"E:\网站\百联项目\goodshtml");
string strProductid = string.Empty;
string strSql = string.Empty;
string output = string.Empty;
foreach(string strFile in strFiles)
{
strProductid = Path.GetFileName(strFile);
strProductid = strProductid.Substring(0, strProductid.IndexOf("."));
StreamReader sr = new StreamReader(strFile, System.Text.Encoding.Default);
output = sr.ReadToEnd();
//output=output.Replace(""
strSql = "update web_goods set producthtml= :output where productid='"+strProductid+"'";
OracleParameter[] ps=new OracleParameter[1];
ps[0] = new OracleParameter();
ps[0].ParameterName = ":output";
ps[0].OracleType = OracleType.Clob;
//ps[0].Size = 2000;
ps[0].Value = output;
OraHelper.ExecuteNonQuery(OraHelper.CONN_STRING,CommandType.Text,strSql,ps);
sr.Close();
}