List<string> columns = new List<string>() {"Col1", "Col2"};
List<object> data = new List<object>() {1, DateTime.Now};
var tableName ="Table1";
var strCol = string.Join(",",columns);
var strParam = string.Join(",", columns.Select(r => "@" + r));
var sql = "INSERT INTO [" +tableName+ "] (" +strCol+ ") VALUES (" +strParam+ ")";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sql , connection);
for (int i = 0; i < strParam.Length; i++)
{
cmd.Parameters.AddWithValue(strParam[i], data[i]);
}
return (int)command.ExecuteScalar();
}</string></string>