public static void InsertDataList(DataSet ds, string tableName)
{
SqlConnection conn = new SqlConnection(AppConfig.sqlConnection);
conn.Open();
try
{
string strSQL1 = "";
bool isFirstColumn = true;
foreach (DataColumn dc in ds.Tables[tableName].Columns)
{
string columnName = dc.ColumnName;
if (isFirstColumn)
{
strSQL1 += columnName;
isFirstColumn = false;
}
else
strSQL1 += "," + columnName;
}
foreach (DataRow dr in ds.Tables[tableName].Rows)
{
string strSQL2 = "";
isFirstColumn = true;
foreach (DataColumn dc in ds.Tables[tableName].Columns)
{
string columnValue = "NULL";
if (!dr.IsNull(dc.ColumnName))
columnValue = GetValue(dc, dr[dc]).ToString();
if (isFirstColumn)
{
strSQL2 = columnValue;
isFirstColumn = false;
}
else
strSQL2 += "," + columnValue;
}
string strSQL = "Insert into " + tableName + "(" + strSQL1 + ") values (" + strSQL2 + ")";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
catch (SqlException exp)
{
throw exp;
}
catch (Exception exp)
{
throw exp;
}
finally
{
conn.Close();
}
}