private void Generate()
{
_scriptCreator = new ScriptGenerator();
_scriptCreator.ConnectionString = ConnectionString();
string whereClause = String.Empty;
string fileName = String.Empty;
fileName = txtPath.Text + "\\" + txtFileName.Text;
if (txtExcludeField.Text.Trim() != String.Empty)
_scriptCreator.ColumnToExclude = String.Format(",{0},",txtExcludeField.Text.Trim());
if (txtWhereClause.Text.Trim() != String.Empty)
whereClause = txtWhereClause.Text.Trim();
_scriptCreator.GenerateInsertStatement(txtTableName.Text.Trim(), whereClause, fileName);
_scriptCreator = null;
}