public int Excel_InsertProductList(DataTable dtData, int index, int Total)
{
int Result = 0;
string strSql = string.Empty;
string strSql_Midden = string.Empty;
string strSql_End = string.Empty;
strSql = "Insert into product_list (";
for (int i = 0; i < dtData.Columns.Count; i++)
{
string Value = dtData.Rows[0][dtData.Columns[i].ColumnName].ToString();
if (Value == string.Empty)
{
continue;
}
if (strSql_Midden == string.Empty)
{
strSql_Midden = dtData.Columns[i].ColumnName;
}
else
{
strSql_Midden = strSql_Midden + "," + dtData.Columns[i].ColumnName;
}
if (strSql_End == string.Empty)
{
strSql_End = Value;
}
else
{
strSql_End = strSql_End + "," + Value;
}
}
strSql = strSql + strSql_Midden + ") VALUES(" + strSql_End + ")";
Result = dbhelpersqlformess.BatchOperateDATA(strSql, index, Total);
return(Result);
}