Menu
▾
▴
firebird-net-provider
|
From: Alan M. <al...@me...> - 2003-11-10 02:41:34
|
Just trying to setup #Develop with the appropriate components... I have installed the firebird components into the toolbox - no problem. I can drop the connection, command and adapter onto the form and set the properties ok. But I can't figure out how to connect the adapter into a dataset so I can populate a datagrid. I suppose there must be some raw code to do here - but I'm sort of hoping I can get a simple app running with properties set in components a la what I could do in Delphi. Anyone know how this might be done? thanks Alan |
|
From: Alan M. <al...@me...> - 2003-11-10 09:50:58
|
I'd love to make a sample app using #Develop with simple firebird components, standard datagrid etc maybe using the employee database Has anyone got anything along these lines which they'd like to share? Alan |
|
From: Mirek S. <m.s...@tr...> - 2003-11-10 10:49:37
|
Hi I've the same problem with VS .NET. I can't connect adapter to dataset in graphical environment. I found out that I can do it programaticaly: fbDataAdapter1.Fill(dataSet1, "tb1"); //where tb1 is table name Dnia 2003-11-10 03:39, U=BFytkownik Alan McDonald napisa=B3: >Just trying to setup #Develop with the appropriate components... >I have installed the firebird components into the toolbox - no problem. >I can drop the connection, command and adapter onto the form and set the >properties ok. >But I can't figure out how to connect the adapter into a dataset so I ca= n >populate a datagrid. I suppose there must be some raw code to do here - = but >I'm sort of hoping I can get a simple app running with properties set in >components a la what I could do in Delphi. > > =20 > In VS.NET I can work with MS database components so easy like in Delphi,=20 connection DataAdapter to DataSet is easier with MS components, becouse=20 there is a wizzard, but Fill methode must be called any way. >Anyone know how this might be done? > >thanks >Alan > > =20 > |
|
From:
<car...@te...> - 2003-11-10 11:38:37
|
Hello: > I've the same problem with VS .NET. > I can't connect adapter to dataset in graphical environment. Because there are no design time support for the FbDataAdapter class ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alan M. <al...@me...> - 2003-11-10 12:04:53
|
> Hello: > > > I've the same problem with VS .NET. > > I can't connect adapter to dataset in graphical environment. > > Because there are no design time support for the FbDataAdapter class ;) > > > > > -- > Best regards > > Carlos Guzmán Álvarez pity... |
|
From: Alan M. <al...@me...> - 2003-11-10 12:06:41
|
When I put a connection string into the fbConnection component, both the datasource and database property gets set to the database path... I get an error on fbconnection.open(); (just attached to a button click) is the connection error because the connection string does not get parsed correctly? Alan |
|
From:
<car...@te...> - 2003-11-10 12:33:40
|
Hello: > When I put a connection string into the fbConnection component, both the > datasource and database property gets set to the database path... > > I get an error on fbconnection.open(); (just attached to a button > click) is > the connection error because the connection string does not get parsed > correctly? More than probably the connection string is not being parsed when setting it in the properties panel, for this there are a connection string editor but sharpdevelop doesn't show the button for access it ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Mirek S. <m.s...@tr...> - 2003-11-10 13:08:49
|
Hi,
It is possible to see SQL statement generated and send by provider
during update to firebird.
In following sequence:
fbtb1.Fill(dataSet1, "tb1");
... I insert new row in dbgrid
fbtb1.Update(dataSet1,"tb1");
and exception is catched.
Can I see this statemant before send to firebird
Mirek Sobczak
|
|
From:
<car...@te...> - 2003-11-10 13:15:52
|
Hello: > It is possible to see SQL statement generated and send by provider > during update to firebird. > In following sequence: > fbtb1.Fill(dataSet1, "tb1"); > ... I insert new row in dbgrid > > fbtb1.Update(dataSet1,"tb1"); > and exception is catched. > Can I see this statemant before send to firebird If you are using a FbCommandBuilder yes, if i understand well you want to check the SQL statement before made the Update, i'm right ??. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Mirek S. <m.s...@tr...> - 2003-11-10 13:54:05
|
Dnia 2003-11-10 14:15, U=BFytkownik Carlos Guzm=E1n =C1lvarez napisa=B3:
>
> If you are using a FbCommandBuilder yes, if i understand well you want=20
> to check the SQL statement before made the Update, i'm right ??.
>
>
Yes, I'm using FbCommandBuilder, and can call:
textBox1.Text =3D fbcb1.GetInsertCommand().CommandText;
and I've got:
INSERT INTO "TB1" ("IDTB1", "IDTB2", "ILO", "CENA") VALUES (?, ?, ?, ?)
but I want to see this statement filled with data.
Mirek Sobczak
|
|
From:
<car...@te...> - 2003-11-10 15:15:25
|
Hello:
> Yes, I'm using FbCommandBuilder, and can call:
> textBox1.Text = fbcb1.GetInsertCommand().CommandText;
> and I've got:
> INSERT INTO "TB1" ("IDTB1", "IDTB2", "ILO", "CENA") VALUES (?, ?, ?, ?)
> but I want to see this statement filled with data.
It's not filled with data, you need to check parameters values in
Parameters collection.
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Alan M. <al...@me...> - 2003-11-10 12:11:56
|
I've also noticed that if the CHARSET is actually NONE, then I need to omit this in the connection string because CHARSET=NONE throws an exception... I can now see that setting the port number to something other than 3050 also thtorws an exception, I can connection with User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s hortblack;Port=3050;Dialect=1;Role=;Connection lifetime=30;Pooling=true;Packet Size=8192; but not with User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s hortblack;Port=3051;Dialect=1;Role=;Connection lifetime=30;Pooling=true;Packet Size=8192; Alan |
|
From: Alan M. <al...@me...> - 2003-11-10 12:17:59
|
> I've also noticed that if the CHARSET is actually NONE, then I > need to omit > this in the connection string because CHARSET=NONE throws an exception... > > I can now see that setting the port number to something other > than 3050 also > thtorws an exception, I can connection with > User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;Da > taSource=s > hortblack;Port=3050;Dialect=1;Role=;Connection > lifetime=30;Pooling=true;Packet Size=8192; > > but not with > User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;Da > taSource=s > hortblack;Port=3051;Dialect=1;Role=;Connection > lifetime=30;Pooling=true;Packet Size=8192; > > Alan > Sorry - my mistake - I was making two connections.. Alan |
|
From:
<car...@te...> - 2003-11-10 12:30:22
|
Hello:
> I've also noticed that if the CHARSET is actually NONE, then I need to
> omit
> this in the connection string because CHARSET=NONE throws an exception...
I have tested this in my local tree and it's working fine:
string connectionString =
@"Database=test.fdb;" +
"User=SYSDBA;" +
"Password=masterkey;" +
"Server=localhost;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=NONE;" +
"pooling=false;" +
"Role=;";
FbConnection connection = new FbConnection(connectionString);
connection.Open();
connection.Close();
> I can now see that setting the port number to something other than
> 3050 also
> thtorws an exception, I can connection with
> User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s
> hortblack;Port=3050;Dialect=1;Role=;Connection
> lifetime=30;Pooling=true;Packet Size=8192;
>
> but not with
> User=SYSDBA;Password=masterkey;Database=c:\ib-data\employee.gdb;DataSource=s
> hortblack;Port=3051;Dialect=1;Role=;Connection
> lifetime=30;Pooling=true;Packet Size=8192;
And you have the server listening on port 3051 ??
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Alan M. <al...@me...> - 2003-11-10 12:25:00
|
> Hi > I've the same problem with VS .NET. > I can't connect adapter to dataset in graphical environment. > I found out that I can do it programaticaly: > fbDataAdapter1.Fill(dataSet1, "tb1"); //where tb1 is table name > > Dnia 2003-11-10 03:39, Użytkownik Alan McDonald napisał: Bingo - thanks that's nice Alan |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X