Saving a Created DataBase (Not Solved, But found an alternative way)

[Tec-Nico]

Alright, I am using ADO.Net... And so I created the DataBase with a lot of efforts... Good!

But now.. How do I save it?

Here is what I did:

this.oDs = new DataSet(DictionaryModule.myDB.Nombre);
Console.WriteLine("DataBase:" + DictionaryModule.myDB.Nombre);
DataTable oDtbl;
DataColumn oDclm;

foreach(DictionaryEntry myEntry in DictionaryModule.myDB){
	Tabla tbl = DictionaryModule.myDB.Item(myEntry.Key.ToString());
	Console.WriteLine("Table: " + tbl.Nombre);
	oDtbl = new DataTable(tbl.Nombre);
	foreach(string col in tbl.Columnas){
		oDclm = new DataColumn(col);
		Console.WriteLine("Column: " + col);
		oDtbl.Columns.Add(oDclm);
	}
	this.oDs.Tables.Add(oDtbl);
}
			
//Create DataBase
System.IO.FileStream fileDB = new System.IO.FileStream(this.DBName + ".mdb", System.IO.FileMode.Create);
//How do I save it? :(		
fileDB.Close();
this.oDs.Dispose();

[Tec-Nico]

Well, I still don't know how to write it into a file... But I know how to do it with XML...

If it helps you, you can always do something like:

this.oDs.WriteXML(fileDB);

And if you want to read it, just do it like this:

this.oDs.ReadXML(fileDB);

But still I don't know how to do it like a mdb. (I already solved my problem using XML, but this is for future reference)

[Pirate]

Check these two links :
http://www.manning.com/dotnetbooks/c...to_access.html
http://www.dotnet247.com/247referenc.../18/91315.aspx

[Tec-Nico]

Thanks, Pirate... I will check it.