I need to add a new column in a DB.
I write this code but it doesn't works (i have removed try catch block):
This code doesn't raise any exception, simply it doesnot put the new column on my access DB.Code:OleDbDataAdapter SingleMDBAdapter ; DataSet SingleMDBDataSet; string strQuery = "SELECT * FROM ["+ActualTableName+"]"; SingleMDBAdapter = new OleDbDataAdapter(strQuery,SingleMDBConnection); SingleMDBDataSet = new DataSet(); SingleMDBAdapter.Fill(SingleMDBDataSet); if (SingleMDBDataSet.Tables[0].Columns.Contains("String1")) { if (!SingleMDBDataSet.Tables[0].Columns.Contains("String2")) { SingleMDBDataSet.Tables[0].Columns.Add("String2"); SingleMDBAdapter.Update(SingleMDBDataSet); } }
Any suggestions?




Reply With Quote