C#

NarendraSinghJTV wrote:

application which generates database through coding

public static void AttachDatabase(Server server)
{
    string databaseName;
    StringCollection dbFiles = new StringCollection();
    Dialogs.DBFilesDialog dbfd = new Dialogs.DBFilesDialog();
    if (dbfd.ShowDialog() == DialogResult.OK)
    {
        dbFiles.Add(dbfd.PrimaryFileName);
        dbFiles.AddRange(dbfd.DataFiles);
        dbFiles.AddRange(dbfd.LogFiles);
        databaseName = dbfd.DatabaseName;

        // Attach the database
        if ((dbFiles[0] != null) && (dbFiles[0] != string.Empty))
        {
            // Are you sure?  Default to No.
            if (MessageBox.Show(@"Do you really want to Attach the " + dbFiles[0] +
                @" database?", Application.ProductName, MessageBoxButtons.YesNo,
                MessageBoxIcon.Question,
                MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            server.AttachDatabase(databaseName, dbFiles, AttachOptions.RebuildLog);
        }
    }
}

StreamReader sr = new StreamReader(@"C:\YourFile.txt");
StreamWriter sw = new StreamWriter(@"C:\YourNewFile.txt");

string line = string.Empty;

while ((line = sr.ReadLine()) != null)
{
   if (line != string.Empty)
      sw.WriteLine(line);
}

sw.Close();