C#

foreach (GrpCombi grp in res)
{
    dataTable.Clear();
    dataAdapter = new OleDbDataAdapter("Select * From [Analysis] WHERE HOLDER_IDENTIFIER = '" + grp.AccountNo + "'", conn);
    OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(dataAdapter);
    dataAdapter.Fill(dataTable);

    if (dataTable.Rows.Count != 0)
    {
        MessageBox.Show(dataTable.Rows[rowPos]["HOLDER_IDENTIFIER"].ToString());
        dataTable.Rows[rowPos]["SapoBal"] = grp.AccountBal.TrimStart(myChar);
        dataAdapter.Update(dataTable);
        progressBar1.Invoke(new updatebar(this.UpdateGroupProgress));
    }

    else
    {
        sw.WriteLine(grp.AccountNo + "," + grp.AccountBal);
    }

System.InvalidOperationException was unhandled<br />
  Message="Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."<br />
  Source="System.Data"<br />
  StackTrace:<br />
       at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(RowUpdatingEventArgs rowUpdatedEvent, DataRow dataRow)<br />
       at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)<br />
       at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)<br />
       at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)<br />
       at SasolDataAnalysis.Form1.GroupImport() in C:\Documents and Settings\Bernard\My Documents\Visual Studio 2005\Projects\SasolDataAnalysis\SasolDataAnalysis\Form1.cs:line 233<br />
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)<br />
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)<br />
       at System.Threading.ThreadHelper.ThreadStart()<br />

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using Word=Microsoft.Office.Interop.Word;
using System.Runtime.InteropServices;
using core= Microsoft.Office.Core;
using System.Diagnostics;
namespace WordProcess
{
	/// <summary>
	/// Description of MainForm.
	/// </summary>
	public partial class MainForm : Form
	{
		
		Word.Application wordApp;
		Word._Document wordDocument;
		

		object document;
		object wordFalse = false;
		object wordTrue = true;
		object dynamic = 2;
		
		object wordMissing = System.Reflection.Missing.Value;
		public MainForm()
		{
			//
			// The InitializeComponent() call is required for Windows Forms designer support.
			//
			InitializeComponent();
			
			//
			// TODO: Add constructor code after the InitializeComponent() call.
			//
		}
		
		void Button1Click(object sender, EventArgs e)
		{
			
			System.Diagnostics.Process[] wordPro = System.Diagnostics.Process.GetProcessesByName("winword");
			if (wordPro.Length==0){
				//No word Open start a new word process.
				Process p= Process.Start("WINWORD.EXE");
				p.WaitForInputIdle();
				
				
			}
			try{
				object filePath =@"C:\test.doc";
				object filePath1 =@"C:\test1.doc";
				wordDocument = new Word.DocumentClass();
				
				
				wordApp = (Word.Application)Marshal.GetActiveObject("Word.Application");
				
				
				wordApp.Documents.Open(ref filePath, ref wordMissing, ref wordFalse, ref wordMissing,
				                       ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing,
				                       ref wordMissing, ref wordMissing, ref wordMissing, ref wordTrue,
				                       ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing);
				
				
				
				wordDocument.SaveAs(ref filePath1, ref wordMissing, ref wordFalse, ref wordMissing,
				                    ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing,
				                    ref wordMissing, ref wordMissing, ref wordMissing, ref wordTrue,
				                    ref wordMissing, ref wordMissing, ref wordMissing, ref wordMissing);
				
				wordDocument.Close(ref wordFalse, ref wordMissing, ref wordMissing);//Close the document no saving


				wordApp.Quit(ref wordMissing, ref wordMissing, ref wordMissing);//Remove the instance opened
				
				
			}catch(MarshalDirectiveException mw){
				MessageBox.Show(mw.ToString());
			}catch(Exception ex){
				MessageBox.Show(ex.ToString());
			}
			
			
		}
		
		
		
	}

}