如何导入excel文件时候update 数据库相关字段

[forwardchen]

如题

[levin9]

剛做好的
public static string imp_currency(int yearly,int monthly,System.Web.UI.HtmlControls.HtmlInputFile FileUp)
{
string result="",currency="";
int i=0,times=1,ErrorType=0;
float rate=0;
System.Text.StringBuilder sb=new System.Text.StringBuilder();
System.Text.StringBuilder logs=new System.Text.StringBuilder();
Components.FileUpModem fileMod=new FileUpModem();
DataSet ds=new DataSet();
fileMod=Components.UpFile.UploadFile(FileUp,"FileUpLoad");
string filePath=fileMod.CurrentPath;
ds=Components.Staff.ExcelToDs(filePath);
System.Collections.Hashtable hs_Currency=imp_Currency();
System.Collections.Hashtable hs_set_currency=set_Currency(yearly,monthly);
for ( i=0;i<ds.Tables[0].Rows.Count;i++)
{
try
{
rate=float.Parse(ds.Tables[0].Rows[i][3].ToString());
}
catch
{
ErrorType=1;
}
currency=ds.Tables[0].Rows[i][2].ToString().Trim();
string currencyCH = (string)hs_Currency[currency];
if (currencyCH==null)
{
ErrorType=2;
}

if (ErrorType==0)
{
string tmp2=(string)hs_set_currency[currency];
if (tmp2==null)
{
sb.Append(" insert into pubCurrency (yearly,monthly,Currency,CurrencyCH,Rate) values ("
+ yearly + "," + monthly + ",'" + currency + "','" + currencyCH + "'," + rate +") ; ");
}
else
{
sb.Append(" update pubCurrency set Rate=" + rate + "where yearly=" + yearly + " and monthly=" + monthly + " and currency='" + currency + "' ;");
}
times ++;
}
else
{
//logs.Append(addLogs(ds.Tables[0].Rows[i],ErrorType));
logs.Append("</br>");
}
if (times%10==0)
{
Components.db.SqlBase.ExecSql(sb);
sb.Remove(0,sb.Length);
}
}
if (i>0) Components.db.SqlBase.ExecSql(sb);
return result;
}

[forwardchen]

能不能用sql语句直接搞定啊