From: Peter M. <P.m...@de...> - 2004-03-19 07:59:44
|
I have been taking the long road to make typed datasets: Create the = table within MS SQL (now for free for personal use), drag it into my project = , creating the xsd and typed dataset, extract the SQL statements to = create the table and feed it into Firebird. If you have anything working in that area, I'd be interested. I have = been writing some code to create SQL from a dataset (which is not a feature = in .net to my knowledge), see previous posting. Peter -----Oorspronkelijk bericht----- Van: fir...@li... [mailto:fir...@li...] Namens = JS.staff Verzonden: vrijdag 19 maart 2004 0:38 Aan: fir...@li... Onderwerp: RE: [Firebird-net-provider] Visual Studio.NET and = C#.[Scanned] Hia Austin, =20 I'm using the provider with VS 2003. You need to install the components = on the toolbar, ('Tools' menu, then 'add remove toolbox items', then find = the assembly for the .net provider, usually in C:\Program Files\FirebirdNETProvider1.5 =20 Then select the 'FirebirdSql.Data.Firebird.dll' file. This should make = the FbConnection, FbCommand etc components appear in the toolbox. =20 It works independently of the OLE DB components - nothing to do with = them. =20 Oh, another 'gotcha' - you'll need to add the assembly to the = 'References' section of each project that uses it. Otherwise you get an error when = you drop the components onto the form. =20 If you need help making typed datasets, ive got some code to make it a little easier - not as slick as the SQL Server tools though. =20 John -----Original Message-----=20 From: Austin Sauls [mailto:aus...@sp...]=20 Sent: Thu 18/03/2004 22:29=20 To: fir...@li...=20 Cc:=20 Subject: [Firebird-net-provider] Visual Studio.NET and C#.[Scanned] =09 =09 I have created a Firebird database (C:\CMDRPT.FDB). When I am in Visual Studio.NET and using C#, I am trying to add a data form. The data form wizard asks me some questions. It has a Data Link Properties page. The first tab is for Provider and there are only OLE DB providers in the list. Do I have to place the firebird .net data provider into a special folder, etc. Also the second tab on the Data Link Properties page is a connection test. I am using server name of local host and using = =E2=80=9CC:\CMDRPT.FDB=E2=80=9D as the database on the server. I can not connect to the Firebird DataBase. Thanks, Austin Sauls N=18HS^=E9=9A=8AX'u=E0=BE=BC=04=02S=E9=87=BA+l=16.) =DB=AD=DE=B1 y=16 zThm=E0=B8=A7=02'^=D6=A7t! :(=E0=A0=B5!=DE=89h'-=E6=AB=9D +axwZ = j[-=CC=ACvh=E1=AE=A7kj=E4=BD=92=1Bmv,vw(=E9=8F=9B=E6=9D=89=E3=BD=96ZrAb=E0= =A0=AD=06=19'^=E0=A0=AEf)+-=16*=E5=99=89n*=DD=9Di=ED=AE=8Bu=E6=BD=A3=C5=8A= lq zm=E0=BE=B6?X=EE=AC=B6(=1E~zw=ED=A9=ADX=0Fb=CA=9D?~*=E2=80=A0n*=DD=9Di=E0= =AE=8B |