My database's file is "C:\mydb.fdb". That file exists.
I created new Windows Application. I placed "FbConnection1" on a Form1 and
configurated its "ConnectionString" property - Data Source = localhost,
Database = "C:\mydb.fdb", Servet Type = "Embedded Server". I hit "Test"
button and the message was - Connection successful.
Then I placed "FbDataAdapter1", configured it ( i chose FbConnection1 as
connection, "Use SQL", "Select * from PEOPLE") and then, using
FbDataAdapter, I generated new DataSet "DS1".
Next, I placed "DataGridView1" on my form. I set up its properties -
DataSource = "DS1", DataMember = "Table".
Finally i wrote a code for Form1_Load event:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
FbDataAdapter1.Fill(DS, "Table")
End Sub
I started debugging my program and it worked fine :) All the data from my
table appeared in the grid.
I closed my program, returned to VisualStudio and in the "Server Explorer"
tab I chose Data Connection "localhost(MYDB)" by clicking on a "+" and
expanding that nod. Next, i debugged my program and i received that error -
"I/O error for file C:\MYDB.FDB. Error while trying to open file"
I've found 2 more (possibly) bugs...
1) When I placed FbDataAdapter and it generated DataSet - in "Generate
DataSet" window i couldn't choose existing Dataset ( that option is always
gray and inactive, even i've got another DataSet on my form) and, in bottom
section of thet window, there are 3 CheckBoxes - the first one says - "Add
this DataSet to the" To the what? The sentence is cut in a half...
2) If in my table a column has a name like "PEOPLE_I_LIKE", in DataSet the
name will be changed to PEOPLEILIKE. So that column won't be displayed in
DataGrid... I must change that name in DataSet manually...
Martin
Uzytkownik ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> napisal w
wiadomosci news:[EMAIL PROTECTED]
> Hello:
>> No, It's Windows Application.
>
> Huummmm and the the database file exists in that path in the firebird=20
> server machine ??
>
>
> --=20
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
> http://carlosga.blogspot.com/
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
