i've created a database using FlameRobin. it currently contains two tables:
Film & Units. however i'm only able to access the Units table. i've
searched quite a few posts the last couple of days but just can't see what
i'm doing wrong.
versions:
=========
Firebird - AD0.NET 2.0 provider 2.0.0.0
Firebird embedded 1.5.3
Microsoft Visual C# codename Orcas Version 9.0 Beta 1
Microsoft .NET Framework 2.0
the c# code:
=============
public FbConnection k2Conn;
public FormMain()
{
InitializeComponent();
// rak is a global structure for application
RakStruct rak = new RakStruct();
rak.packageName = "rak-photography";
rak.version = Application.ProductVersion;
rak.header = rak.packageName + " " + rak.version;
this.Text = rak.header;
string dbFile = AppDomain.CurrentDomain.BaseDirectory +
"rak-photo.fdb";
string connStr;
connStr = "User=SYSDBA;" +
"Password=masterkey;" +
"Database="+dbFile+";" +
"ServerType=1";
k2Conn = new FbConnection(connStr);
}
private void FormMain_Load(object sender, EventArgs e)
{
FbDataAdapter da = new FbDataAdapter("SELECT * FROM UNITS",
k2Conn);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
========
i've tried: ds.Tables[1]
ds.Tables["FILM"]
thanks for any help.
--
View this message in context:
http://www.nabble.com/fb-embedded-accessing-more-than-one-table-tf4142167.html#a11782491
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
