Adding data columns to a disconnected database

[canoewhiteh2o]

I am having trouble adding data columns to a disconnected database. I
first load a datatable using:
private DataTable dtMacros = new DataTable();
private ArrayList macro = new ArrayList();
private SQLiteConnectio n cn;
private SQLiteDataAdapt er adapterMacros;
cn = new SQLiteConnectio n("Data Source = irDatabase.db3" );
SQLiteCommand commandMacros = new SQLiteCommand() ;
commandMacros.C ommandText = "SELECT * FROM irMacros";
adapterMacros = new SQLiteDataAdapt er(commandMacro s.CommandText,
cn);
SQLiteCommandBu ilder builderMacros = new
SQLiteCommandBu ilder(adapterMa cros);
adapterMacros.F ill(dtMacros);
dtMacros.Primar yKey = new DataColumn[]
{ dtMacros.Column s["MacroName"] };

I am using an arraylist (macro) to store values for a new row - all
values are strings.

Later I update the data with the following code:
private void UpdateMacroData base(ArrayList macro, string macroName)
{
//Add datatable columns if needed for the datatable in
memory
if (dtMacros.Colum ns.Count <= macro.Count)
{
int i = dtMacros.Column s.Count;
while (i <= macro.Count)
{
dtMacros.Column s.Add("Command" + (i-1).ToString(),
typeof(String)) ;
i++;
}
}
//update the datatable in memory
DataRow row = dtMacros.Rows.F ind(macroName);
if (row == null)
{
row = dtMacros.NewRow ();
row[0] = macroName;
for (int i = 0; i < macro.Count; i++)
{
row[i+1] = macro[i];
}
dtMacros.Rows.A dd(row);
}
else
{
row["MacroName"] = macroName;
for (int i = 1; i <= macro.Count; i++)
{
row[i] = macro[i - 1];
}
}
adapterMacros.U pdate(dtMacros) ;
dtMacros.Accept Changes();
macro.Clear();
}

The datatable in memory adds the new columns and rows as it should.
The database on disk will add the new rows and will update the
columns, but will not add the new columns.

Thanks for any help.

Regards,
Gary B

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
You need to add the columns in the "real" DB, which makes me wonder, why
they are not there in the first place?

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
"canoewhite h2o" <ca***********@ yahoo.comwrote in message
news:4e******** *************** ***********@z11 g2000hsf.google groups.com...

>I am having trouble adding data columns to a disconnected database. I
first load a datatable using:
private DataTable dtMacros = new DataTable();
private ArrayList macro = new ArrayList();
private SQLiteConnectio n cn;
private SQLiteDataAdapt er adapterMacros;
cn = new SQLiteConnectio n("Data Source = irDatabase.db3" );
SQLiteCommand commandMacros = new SQLiteCommand() ;
commandMacros.C ommandText = "SELECT * FROM irMacros";
adapterMacros = new SQLiteDataAdapt er(commandMacro s.CommandText,
cn);
SQLiteCommandBu ilder builderMacros = new
SQLiteCommandBu ilder(adapterMa cros);
adapterMacros.F ill(dtMacros);
dtMacros.Primar yKey = new DataColumn[]
{ dtMacros.Column s["MacroName"] };

I am using an arraylist (macro) to store values for a new row - all
values are strings.

Later I update the data with the following code:
private void UpdateMacroData base(ArrayList macro, string macroName)
{
//Add datatable columns if needed for the datatable in
memory
if (dtMacros.Colum ns.Count <= macro.Count)
{
int i = dtMacros.Column s.Count;
while (i <= macro.Count)
{
dtMacros.Column s.Add("Command" + (i-1).ToString(),
typeof(String)) ;
i++;
}
}
//update the datatable in memory
DataRow row = dtMacros.Rows.F ind(macroName);
if (row == null)
{
row = dtMacros.NewRow ();
row[0] = macroName;
for (int i = 0; i < macro.Count; i++)
{
row[i+1] = macro[i];
}
dtMacros.Rows.A dd(row);
}
else
{
row["MacroName"] = macroName;
for (int i = 1; i <= macro.Count; i++)
{
row[i] = macro[i - 1];
}
}
adapterMacros.U pdate(dtMacros) ;
dtMacros.Accept Changes();
macro.Clear();
}

The datatable in memory adds the new columns and rows as it should.
The database on disk will add the new rows and will update the
columns, but will not add the new columns.

Thanks for any help.

Regards,
Gary B

[canoewhiteh2o]

Well they are not there in the first place because I am allowing the
user to increase the number of columns based on user need. I am using
the db to store mouse clicks within a macro.

Anyway, I did figured it out. I threw away the CommandBuilder and
constructed my on sql strings. Probably should have taken that
approach in the first place.