Uzytkownik "Raigo" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> Where is possible to see code samples for ASP.NET 2.0 and Firebird SQL?
I am not doing any ASP so I can't give you anything ready, but I did a
classLibrary connecting to Firebird and linked it to WebDeveloper, it worked
well.
examples for c# are on frebirdsql page in a provider development tab (just
browse a little and you'll find them), The syntax is analogous to the
SQLServer provider:
anyway try this as a spike - add a class, prepare this method, add a new
DataSet object on the webpage, fill it with the method below (mind that I
wrote this in email, so there might be syntax errors):
using FirebirdSql.Data.FirebirdClient;
public DataSet getData() {
// setup connection
string connectionString =
"User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection
lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet
Size=8192;ServerType=0"
FbConnection connection = new FbConnection(connectionString);
connection.Open();
// setup query
FbCommand command = new FbCommand("SELECT * FROM USERS", connection);
// setup adapter;
FbDataAdapter dataAdapter = new FbDataAdapter();
dataAdapter.SelectCommand = command;
// fetch data
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
afterwards you handle dataset, just the same way like you do with SQLServer
filled ones.
CUIN Kaczy
> Can I still use the visual controls (GridView, FormView etc)? I don't=20
> mind putting a few properties in code, if I still can build most of UI=20
> visually.
>
>
> Andrzej Kaczmarczyk wrote:
>
>>but, so you won't get wrong impression, you CAN access Firebird from Exp=
> ress=20
>>editions, you just have to do it from code not from graphical tools.
>>
>>CUIN Kaczy
>>
>>Uzytkownik "Raigo" <[EMAIL PROTECTED]> napisal w wiadomosci=20
>>news:[EMAIL PROTECTED]
>> =20
>>
>>>But then how to connect to Firebird from VS Express Edition ?
>>>I have exactly same problem, using Visual Web Developer Express. this t=
> ool=20
>>>rocks !!! but due lack of decent drivers, now limited to SQL Server. wo=
> uld=20
>>>be great to able to use this RAD, free, web development tool with=20
>>>open-source Firebird.
>>>
>>>Is it possible to modify the driver? or is there some other Firebird=20
>>>driver for .NET what works ?
>>>
>>>
>>>Carlos Guzm=E1n =C1lvarez wrote:
>>> =20
>>>
>>>>Hello:
>>>>
>>>> =20
>>>>
>>>>>just a reality check, is it possible to use Integrate Firebird .NET=20
>>>>>provider with Express version?
>>>>>
>>>>> =20
>>>>>
>>>>As i know DDEX support is not available on Express Editios :P
>>>>
>>>>
>>>>
>>>> =20
>>>>
>>>-------------------------------------------------------
>>>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
