|
-
September 10th, 2008, 05:14 AM
#1
Not able to save a column added dynamically to an existing table
I need to add a new column in the database but cannot. Can someone help me. My code is as below
My code:
private void UpdateDatabase()
{
DataTable dtprojectinfo = GetTable("ProjectInfo");
DataTable dtparticipants = m_DBClient.GetTable(TABLETYPE.PARTICIPANTS);
DataColumn dc = new DataColumn("PaymentStatus");
dc.DataType = System.Type.GetType("System.Boolean");
dc.DefaultValue = false;
dtparticipants.Columns.Add(dc);
SaveTable(dtparticipants);
}
public DataTable GetTable(string TableName)
{
OleDbDataAdapter dataAdapter;
DataTable datatable = null;
OpenConnection();
dataAdapter = new OleDbDataAdapter();
datatable = new DataTable();
dataAdapter.SelectCommand = new OleDbCommand(@"SELECT * FROM [" + TableName + "]", m_DBConnection);
dataAdapter.SelectCommand.Parameters.Add("@Icon", OleDbType.Binary);
dataAdapter.Fill(datatable);
datatable.TableName = TableName;
return datatable;
}
Public void SaveTable(DataTable dataTable)
{
OleDbDataAdapter dataAdapter;
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand(@""ALTER TABLE [" + ActualTableName + "] ADD COLUMN Payment TEXT(25)", m_DBConnection);
OleDbCommandBuilder cb = new OleDbCommandBuilder(dataAdapter);
dataAdapter.AcceptChangesDuringUpdate = true;
OpenConnection();
dataAdapter.Update(dataTable);
}
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|