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;
 }