Re: Creating tables in a JET database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Instead of cat.ActiveConnection = "..........", use
cat.let_ActiveConnection("...............");

Foll. is the code, which I wrote

<snip>

ADOX.Catalog cat = new CatalogClass();
ADOX.Table tbl = new ADOX.TableClass();

try
{
cat.let_ActiveConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB");
}
catch (Exception e)
{
Console.WriteLine(e.InnerException.ToString());
}

tbl.Name = "kalpesh12345";

tbl.Columns.Append("Column1",ADOX.DataTypeEnum.adInteger ,0);
tbl.Columns.Append("Column2", ADOX.DataTypeEnum.adInteger,0);
tbl.Columns.Append("Column3", ADOX.DataTypeEnum.adVarWChar, 50);

cat.Tables.Append(tbl);
</snip>

HTH
Kalpesh

.

Relevant Pages

  • Re: OleDbSchema Guid
    ... to seperate functions & proedures ... HTH ... Kalpesh ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Function parameter gets changed
    ... See this excellent explanation on parameter passing by Jon skeet & you ... HTH ... Kalpesh ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: variable label control
    ... > on server side execution ... > HTH ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Splitting up a string
    ... down to the difference in linefeeds/carraige returns on *nix/Windows. ... HTH ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ...this makes me so....
    ... HTH ... Prev by Date: ...
    (uk.people.silversurfers)