firebird-net-provider Mailing List for Firebird (Page 2)

Hello:

> do you have a freshmeat project where to put the news ? 
> it could be nice to have a page there :) 

There are any special to do for announce the new version of Firebird 
.NET Data provider ( 1.1 Alpha 2 ) at freshmeat ?? :D



Thanks in advance



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello:


Hello:

Firebird .NET Data Provider 1.1 Alpha 2 ( for .NET 1.0 ) available for 
download.


Release Changes:


Alpha 2 ( 2003-06-23 )
------- --------------

- Updated API Reference documentation.

- BugFixes.

- Added Firebird Events API Support, see KNOWN.TXT ( Thanks to Tedd for 
his help and feedback ).

- Added a new example in VB.NET contributed by Andrew C. Goodall.


         ---------------------------------------------------



You can view the changelog at:

https://sourceforge.net/project/shownotes.php?release_id=167251


You can download binarys ( for Windows and .NET Framework 1.1 ) at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2-Doc.zip?download





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello:

> FirebirdSql.Data.Firebird: 1.1.1253.20777
> DotNet Framework
> * 1.0.2914
> * 1.0.3705
> * 1.1.4322
> Firebird_1_5
> 
> 
> Any suggestions?


The .NET provider 1.1 was built with .NET Framework 1.1, are you using 
VS 2002 ?? ( VS 2002 works only with .NET Framework 1.0 )




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hi
I just installed the Firebird.Net Data Provider and using their=20
ASP.Net example with the security.fdb database and it comes up with the =
below error.
I tried the same thing with IB6 and get the same error.
I can use Easysoft ODBC driver & IB6 with ASP.Net.

Error: Invalid PInvoke metadata format.

It bombs on the=20
myConnection.Open();

Stact Trace
[TypeLoadException: Invalid PInvoke metadata format.]
   FirebirdSql.Data.Firebird.ConnectionPool.Create(String =
connectionString) +72
   FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(String =
connectionString) +443
   FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(String =
connectionString) +32
   FirebirdSql.Data.Firebird.FbConnection.Open() +108
   ASP.CSharpExample_aspx.Connection() in C:\Program =
Files\FirebirdNETProvider1.1\examples\ASP.NET\CSharpExample.aspx:29
   ASP.CSharpExample_aspx.cmdConnect_Click(Object sender, EventArgs e) =
in C:\Program =
Files\FirebirdNETProvider1.1\examples\ASP.NET\CSharpExample.aspx:40
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   =
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Rais=
ePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler =
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) =
+33
   System.Web.UI.Page.ProcessRequestMain() +1263

Win2000
IE: v6.02
FirebirdSql.Data.Firebird: 1.1.1253.20777
DotNet Framework
* 1.0.2914
* 1.0.3705
* 1.1.4322
Firebird_1_5


Any suggestions?
Thanks
Glenn

Hello:

> I'm easy on this...
> I'm afraid I rarely use this syntax in the world of ASP, I use
> MyConnection.Execute("EXECUTE STORED PROCEDURE(..")
> since it reduces overhead a little more than having to create parameters
> etc.
> 
> Doesn't the old ADO way of doing it mean that the @ID parameter is not
> explicit either?
> doesn't the old way go something like
> 
> command.CommandType = CommandType.StoredProcedure;
> command.CommandText = "SP_NAME";
> 
> then you create and add the parameters to the command


I'm reviewing how the Sql Server provider works and seems that you are 
right:


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

I'm easy on this...
I'm afraid I rarely use this syntax in the world of ASP, I use
MyConnection.Execute("EXECUTE STORED PROCEDURE(..")
since it reduces overhead a little more than having to create parameters
etc.

Doesn't the old ADO way of doing it mean that the @ID parameter is not
explicit either?
doesn't the old way go something like

command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_NAME";

then you create and add the parameters to the command


Alan


> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Carlos Guzman Alvarez
> Sent: Saturday, 21 June 2003 8:11 PM
> To: Firebird .Net Provider
> Subject: [Firebird-net-provider] Stored Proc execution question
>
>
> Hello:
>
>
> Now the CommandText for execute an stored proc needs to have the EXECUTE
> PROCEDURE and the begin:
>
>
> 	command.CommandType = CommandType.StoredProcedure;
>     	command.CommandText = "EXECUTE PROCEDURE SP_NAME(@ID)";
>
> I'm thinking in add a change to the 1.1 branch for allow stored proc to
> be executed as:
>
> 	command.CommandType = CommandType.StoredProcedure;
> 	command.CommandText = "SP_NAME(@ID)";
>
> And add a check to the CommandText when the CommandType =
> CommandType.StoredProcedure for see if it's needed to add the EXECUTE
> PROCEDURE string at the begining automatically.
>
>
>
> Any thoughts ????
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Hello:


Now the CommandText for execute an stored proc needs to have the EXECUTE 
PROCEDURE and the begin:


	command.CommandType = CommandType.StoredProcedure;
    	command.CommandText = "EXECUTE PROCEDURE SP_NAME(@ID)";

I'm thinking in add a change to the 1.1 branch for allow stored proc to 
be executed as:

	command.CommandType = CommandType.StoredProcedure;
	command.CommandText = "SP_NAME(@ID)";

And add a check to the CommandText when the CommandType = 
CommandType.StoredProcedure for see if it's needed to add the EXECUTE 
PROCEDURE string at the begining automatically.



Any thoughts ????



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Yeh thanks - I had to make sure, I have two servers on the same box -=
 wanted
to know which one was actually responding.
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Carlos Guzman Alvarez
> Sent: Saturday, 21 June 2003 8:06 PM
> To: Alan McDonald
> Cc: Firebird .Net Provider
> Subject: Re: [Firebird-net-provider] where to get .net provider and
> examples
>
>
> Hello:
>
> > Does the gds client incorporated into the provider support custom=
 port
> > numbers for the connection?
>
>
> Yes you can specify one in the connection string, iusing the Port e=
lement:
>
> string connectionString =3D
> =09"User=3DSYSDBA;"=09=09=09+
> =09"Password=3Dmasterkey;"=09=09+
> =09@"Database=3DEMPLOYEE.GDB;" =09+
> =09"DataSource=3Dlocalhost;"=09=09+
> =09"Port=3D3060;"=09=09=09+=09<--------------
> =09"Dialect=3D3;"=09=09=09+
> =09"Charset=3DNONE;"=09=09=09+
> =09"Role=3D;"=09=09=09+
> =09"Connection lifetime=3D15;"=09+
> =09"Pooling=3Dfalse;"=09=09+
> =09"Packet Size=3D8192";
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Par=
tner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commis=
sion!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.=
php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Hello:

> Does the gds client incorporated into the provider support custom port
> numbers for the connection?


Yes you can specify one in the connection string, iusing the Port element:

string connectionString =
	"User=SYSDBA;"			+
	"Password=masterkey;"		+
	@"Database=EMPLOYEE.GDB;" 	+				
	"DataSource=localhost;"		+
	"Port=3060;"			+	<--------------
	"Dialect=3;"			+
	"Charset=NONE;"			+
	"Role=;"			+
	"Connection lifetime=15;"	+
	"Pooling=false;"		+
	"Packet Size=8192";





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Carlos,
Does the gds client incorporated into the provider support custom port
numbers for the connection?

Alan

Hello:

> Here's and undate to the examples I gave with the html section and some
> comments:
> 
> Here's some examples in VB one for a reader, a dataadapter, and a
> ExecuteNonQuery. I save the result to an xml file that I can use later
> instead of pounding the database with more queries.  Note on the
> ExecuteNonQuery you have to have a Commit to get it to work unlike SQL
> Client or OleDb Client.


Attached to this email is a modified version of your sample ( nice 
sample !! ) that works with the EMPLOYEE.GDB database that ships with 
Firebird i'm going to add it to the CVS :D, thanks very much






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

""David B"" <NO_...@ya...> wrote in message
news:bcts6o$ovf$1...@ne......
> Hi,
>
> Could somebody please tell me where I can get the .Net provider for
firebird
> and possibly a good xample of connecting to a database, issuing select
> statements, using stored procedures from VB.NET.
>
> I am been searching through the archieves for this group and think that I
> can piece together various bits of info to make a connection once I have
the
> provider, although an example would be good.
>
> My back group has mostly been in classic ASP development to MS SQL
> databases, so hopefully I won't find this toooo hard.
>
> any help is very much appreciated.
>
>
> cheers
>
> martin.

Here is my  C# example. I've come to this code when I was learning how to
run procedures in asp.net with firebird( a few days ago :)  ).
It hasn't been fully tested and I haven't put any error control stuff but
it's working fine and helped me to learn.

Based on the book ASP.NET Website programming - problem -designed -solution
I've "adapted" a few functions to run with Firebird that will make like
easier when running stored procedures.

Base class that provides support functions as well as automatic
instantiation and configuration of FbConnection object:

FbDbObject.cs

using System;
using System.Data;
using FirebirdSql.Data.Firebird;


namespace FbData
{
 public class FbDbObject
 {
  protected FbConnection Connection;
  protected FbTransaction tx;
  private string connectionString;

  public FbDbObject(string newConnectionString)
  {
   connectionString = newConnectionString;
   Connection = new FbConnection(connectionString);
  }

  protected string ConnectionString
  {
   get
   {
    return connectionString;
   }
  }

  private FbCommand BuildIntCommand(string storedProcName, IDataParameter[]
parameters)
  {
   FbCommand command= BuildQueryCommand(storedProcName,parameters);

   command.Parameters.Add(new
FbParameter("ReturnValue",FbType.Integer)).Direction =
ParameterDirection.ReturnValue;

    return command;
  }

  private FbCommand BuildQueryCommand(string storedProcName,
IDataParameter[] parameters)
  {

   FbCommand command = new FbCommand(storedProcName,Connection,tx);
   command.CommandType = CommandType.StoredProcedure;

   foreach(FbParameter parameter in parameters)
   {
    command.Parameters.Add(parameter).Direction = ParameterDirection.Input;
   }

   return command;
  }

  private FbCommand BuildQueryCommand(string storedProcName)
  {
   FbCommand command = new FbCommand(storedProcName,Connection,tx);
   return command;
  }

  public int RunProcedure(string storedProcName, IDataParameter[]
parameters, out int rowsAffected)
  {
   int result;
   Connection.Open();
   tx = Connection.BeginTransaction();
   FbCommand command = BuildIntCommand(storedProcName, parameters);
   rowsAffected = command.ExecuteNonQuery();
   result = (int)command.Parameters["ReturnValue"].Value;
   tx.Commit();
   tx.Dispose();
   Connection.Close();

   return result;
  }

  public void RunProcedure_1(string storedProcName, IDataParameter[]
parameters)
  {
   Connection.Open();
   tx = Connection.BeginTransaction();
   FbCommand command = BuildQueryCommand(storedProcName, parameters);
   command.ExecuteNonQuery();
   tx.Commit();
   tx.Dispose();
   Connection.Close();
  }


  public FbDataReader RunProcedure(string storedProcName, IDataParameter[]
parameters)
  {
   FbDataReader returnReader;
   Connection.Open();
   tx = Connection.BeginTransaction();
   FbCommand command = BuildIntCommand(storedProcName, parameters);
   command.CommandType = CommandType.StoredProcedure;

   returnReader = command.ExecuteReader(CommandBehavior.CloseConnection);
   tx.Commit();
   tx.Dispose();

   return returnReader;
  }

  public DataSet RunProcedure(string storedProcName, IDataParameter[]
parameters, string tableName)
  {
   DataSet dataSet = new DataSet();
   Connection.Open();
   tx = Connection.BeginTransaction();
   FbDataAdapter fbDA = new FbDataAdapter();
   fbDA.SelectCommand = BuildQueryCommand(storedProcName, parameters);
   fbDA.Fill(dataSet, tableName);
   tx.Commit();
   tx.Dispose();
   Connection.Close();

   return dataSet;

  }

  public DataSet RunProcedure(string storedProcName, string tableName)
  {
   DataSet dataSet = new DataSet();
   Connection.Open();
   tx = Connection.BeginTransaction();
   FbDataAdapter fbDA = new FbDataAdapter();
   fbDA.SelectCommand = BuildQueryCommand(storedProcName);
   fbDA.Fill(dataSet, tableName);
   tx.Commit();
   tx.Dispose();
   Connection.Close();

   return dataSet;
  }


  public void RunProcedure(string storedProcName, IDataParameter[]
parameters, DataSet dataSet, string tableName)
  {
   Connection.Open();
   tx = Connection.BeginTransaction();
   FbDataAdapter fbDA = new FbDataAdapter();
   fbDA.SelectCommand = BuildQueryCommand(storedProcName, parameters);
   fbDA.Fill(dataSet, tableName);
   tx.Commit();
   tx.Dispose();
   Connection.Close();
  }
 }
}

To use this I created a simple web page with one datagrid, 2 textboxes, a
combobox and a submit button.
Here is part of the codebehind file (I removed unnecessary parts):

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using FirebirdSql.Data.Firebird;
using FbData;
using System.Configuration;


namespace fire
{
 public class WebForm1 : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.TextBox txtName;
  protected System.Web.UI.WebControls.TextBox txtEmail;
  protected System.Web.UI.WebControls.DropDownList cboActivated;
  protected System.Web.UI.WebControls.Button btnInsert;
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  FbDbObject dataT;

 //get the connection sctring from web.config
 static string myConnectionString =
ConfigurationSettings.AppSettings["connStr"];


/********* in web.config *************/
<configuration>
   <appSettings>
    <add key="connStr"
value="User=xxxxx;Password=xxxx;Database=f:\fire\data\firetest.fdb;DataSourc
e=localhost;Port=3050;Dialect=3;Charset=ISO8859_1;Role=;Connection
lifetime=30;Pooling=true;Packet Size=8192" />
  </appSettings>
</configuration>
/********************************/


  private void Page_Load(object sender, System.EventArgs e)
  {
   dataT  = new FbDbObject(myConnectionString);
   ShowData();
  }

  // Populates the datagrid
private void ShowData()
  {
   DataGrid1.DataSource = dataT.RunProcedure("SELECT * FROM
GET_CLIENTES","clientes");
   DataGrid1.DataBind();
  }

//inserts new row
private void btnInsert_Click(object sender, System.EventArgs e)
  {
   FbParameter[] parameters = {new FbParameter("@NAME",FbType.VarChar),
          new FbParameter("@EMAIL",FbType.VarChar),
          new FbParameter("@ACTIVATED",FbType.Char)};

   parameters[0].Value = Server.HtmlEncode(txtName.Text);
   parameters[1].Value = Server.HtmlEncode(txtEmail.Text);
   parameters[2].Value = cboActivated.SelectedItem.Value;
   dataT.RunProcedure_1("EXECUTE PROCEDURE
ADD_CLIENTE(@NAME,@EMAIL,@ACTIVATED)",parameters);

      ShowData();
  }
 }
}


If I did anything wrong or if someone has ideas how to improve it, I welcome
them :)

Miguel

Hello:

> Here's some examples in VB one for a reader, a dataadapter, and a
> ExecuteNonQuery. I save the result to an xml file that I can use later
> instead of pounding the database with more queries.  Note on the
> ExecuteNonQuery you have to have a Commit to get it to work unlike SQL
> Client or OleDb Client.

Can I add these VB.NET samples to the Firebird .NET Data Provider 
distribution ?? :D




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello:

> I need help and advise on how to manage the deployment of
> FirebirdSql.Data.Firebird.dll
> 
> My web applications are starting to build and currently I have a separate
> bin folder under each web app containing the
> FirebirdSql.Data.Firebird.dll
> 
> But this is not going to be easy to manage.
> 
> I know that there is a better way to do this - I would like one central
> location that I can refer to, can I put the dll in the GAC ? If so how?

Actual .NET Provider installation installs the dll in the GAC yet, if 
you want to make it by your own you can use gacutil program that ships 
with .NET Framework.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

All,


I need help and advise on how to manage the deployment of
FirebirdSql.Data.Firebird.dll

My web applications are starting to build and currently I have a separate
bin folder under each web app containing the
FirebirdSql.Data.Firebird.dll

But this is not going to be easy to manage.

I know that there is a better way to do this - I would like one central
location that I can refer to, can I put the dll in the GAC ? If so how?

TIA,

Andrew Goodall


-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
fir...@li...
Sent: Thursday, June 19, 2003 10:09 PM
To: fir...@li...
Subject: Firebird-net-provider digest, Vol 1 #125 - 2 msgs


Send Firebird-net-provider mailing list submissions to
	fir...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
or, via email, send a message with subject or body 'help' to
	fir...@li...

You can reach the person managing the list at
	fir...@li...

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Firebird-net-provider digest..."


Today's Topics:

   1. Events API implementation Status and a Question (Carlos Guzman
Alvarez)
   2. where to get .net provider and exmples (David B)

--__--__--

Message: 1
Date: Thu, 19 Jun 2003 22:50:53 +0200
From: Carlos Guzman Alvarez <car...@te...>
To: "Firebird .Net Provider" <fir...@li...>
Subject: [Firebird-net-provider] Events API implementation Status and a
Question

Hello:

Little by little and thanks to the Help of Tedd the Events API=20
implementation is in the right way, here is a little example of use:


public static void Main(string[] args)
{
	string connectionString =3D
		"User=3DSYSDBA;"			+
		"Password=3Dmasterkey;"		+
		@"Database=3DTESTDB.GDB;" 	+

		"DataSource=3Dlocalhost;"		+
		"Port=3D3050;"			+
		"Dialect=3D3;"			+
		"Charset=3DNONE;"			+
		"Role=3D;"			+
		"Connection lifetime=3D15;"	+
		"Pooling=3Dfalse;"		+
		"Packet Size=3D8192";

	FbConnection connection =3D new FbConnection(connectionString);
	connection.Open();
	FbTransaction transaction =3D connection.BeginTransaction();

	FbEvents fbEvents =3D new FbEvents(connection);

	FbEventAlertEventHandler e =3D new=20
FbEventAlertEventHandler(EventAlertHandler);

	fbEvents.EventAlert +=3D e;
	fbEvents.RegisterEvents("new row", "updated row");

	// First Event Request
	fbEvents.QueEvents();

	FbCommand command =3D new FbCommand("UPDATE test_table_01 SET
char_field=20
=3D 'events test' WHERE INT_FIELD =3D 3", connection , transaction);
=09
	command.ExecuteNonQuery();

	transaction.Commit();
=09
	fbEvents.QueEvents();

	transaction =3D connection.BeginTransaction();

	// Second Event Request
	fbEvents.QueEvents();

	command =3D new FbCommand("DELETE FROM test_table_01 WHERE int_field =3D

3", connection , transaction);
	command.ExecuteNonQuery();
=09
	command.CommandText =3D "UPDATE test_table_01 SET char_field =3D 'events

test'";
	command.ExecuteNonQuery();

	command.CommandText =3D "UPDATE test_table_01 SET char_field =3D 'events

test 2'";
	command.ExecuteNonQuery();

	command.CommandText =3D "INSERT INTO test_table_01 (int_field) VALUES
(3)";
	command.ExecuteNonQuery();=09=09=09=09=09

	transaction.Commit();
=09
	fbEvents.QueEvents();
=09

	connection.Close();

	Console.ReadLine();
}

public static void EventAlertHandler(object sender, FbEventAlertEventArgs e)
{
	for (int i =3D 0; i < e.Counts.Length; i++)
	{
		Console.WriteLine(e.Counts[i]);
	}
}




Tedd has asked to me if the programmer should be responsible for calling=20
QueEvents each time an event is received? or should the provider do it?


I think that it's better to left this responsability to the programmer=20
but i want to know opinions about this.





--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain



--__--__--

Message: 2
To: fir...@li...
From: "David B" <NO_...@ya...>
Date: Fri, 20 Jun 2003 14:40:10 +1200
Organization: Firebird and InterBase Community Site
Subject: [Firebird-net-provider] where to get .net provider and exmples

Hi,

Could somebody please tell me where I can get the .Net provider for firebird
and possibly a good xample of connecting to a database, issuing select
statements, using stored procedures from VB.NET.

I am been searching through the archieves for this group and think that I
can piece together various bits of info to make a connection once I have the
provider, although an example would be good.

My back group has mostly been in classic ASP development to MS SQL
databases, so hopefully I won't find this toooo hard.

any help is very much appreciated.


cheers

martin.





--__--__--

_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


End of Firebird-net-provider Digest

http://info.borland.com/devsupport/interbase/opensource/     <-- where you
can get interbase open source

http://sourceforge.net/project/showfiles.php?group_id=9028   <--- see
firebird-net-provider

I'm using Webmatrix to code my asp.net webforms with VB codebehind. 
See http://www.asp.net/webmatrix/default.aspx?tabIndex=4&tabId=46

Hey I like as much free stuff as I can get my hands on :)


Here's some examples in VB one for a reader, a dataadapter, and a
ExecuteNonQuery. I save the result to an xml file that I can use later
instead of pounding the database with more queries.  Note on the
ExecuteNonQuery you have to have a Commit to get it to work unlike SQL
Client or OleDb Client.



<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="FirebirdSql.Data.Firebird" %>
<script runat="server">

Dim public shared myConnectionString As String
Dim public shared myConnection As FbConnection
Dim public shared myTxn As FbTransaction
Dim public shared selectCmd As String
Dim public shared mycommand As FbCommand
Dim public shared myReader As FbDataReader
Dim shared myXMLfile As String = "data.xml"
    
Sub Connect()

myConnectionString =
"Database=C:\\interbase\\xxx\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;Server
=localhost;Pooling=False"

myConnection = new FbConnection(myConnectionString)

End Sub
    
Sub Page_Load(Sender As Object, E As EventArgs)
    
    
              If Not (IsPostBack) 'Start postback
    
                  Connect()
                  myConnection.Open()
    
                  selectCmd ="SELECT * FROM TBLSYSTEMS"
    
                  myTxn = myConnection.BeginTransaction()
                  myCommand = new FbCommand(selectCmd,myConnection,myTxn)
                  myReader = myCommand.ExecuteReader()
    
                  selectsystem.DataSource = myReader
                  selectsystem.DataBind()
                  myReader.close()
                  myTxn.Dispose()
                  myCommand.Dispose()
                  myConnection.Close()
    
    
             End If 'End postback
    
End Sub
    
   
Sub BindGrid()

            Dim dataAdapter As FbDataAdapter
            Dim DS As New DataSet()    

		Connect()
            myConnection.Open()
    
             dataAdapter = new FbDataAdapter()
    
             myTxn = myConnection.BeginTransaction()
    
             selectCmd = "SELECT * FROM QRYDB(@sdate,@edate,@alias) "     
             myCommand = new FbCommand(selectCmd,myConnection,MyTxn)
    
             myCommand.parameters.add("@sdate",fbtype.date)
             myCommand.parameters("@sdate").value =
DateAdd("h",-1,DateTime.Now)

             myCommand.parameters.add("@edate",fbtype.date)
             myCommand.parameters("@edate").value =
DateAdd("h",1,DateTime.Now)
    
             myCommand.parameters.add("@alias",fbtype.VARCHAR,20)
             myCommand.parameters("@alias").value = strCPU
    
   
              Try
                      dataAdapter.SelectCommand = myCommand
                      dataAdapter.Fill(DS, "TempInfo")  'filldataset
    
                      mydatagrid.DataSource = DS.Tables("TempInfo")
                      mydatagrid.DataBind()
    
                      dataAdapter.Dispose()
                      myTxn.Dispose()
                      myCommand.Dispose()
                      myConnection.Close()
    
                      Message2.Style("color") = "green"
                      Message2.InnerHtml = "Matching Records = " &
myDataGrid.Items.Count
    
                      Catch Exp As FbException
                        Message.Style("color") = "red"
                        Message.InnerHtml = "ERROR:" & Exp.Message & "<br>"
& selectcmd
                        myTxn.Dispose()
                        myCommand.Dispose()
                        myConnection.Close()
                      Exit Sub
                   End Try
    
 
DS.WriteXml(Server.MapPath(myXMLfile),XmlWriteMode.WriteSchema)
    
    End Sub
    
Sub BindXML()
    
         Dim myDataSet as New DataSet()
         Dim fsReadXml As New
System.IO.FileStream(Server.MapPath(myXMLfile), System.IO.FileMode.Open)
         Dim myView As New DataView()
       
         Try
             myDataSet.ReadXml(fsReadXml)
             myView = myDataSet.Tables(0).DefaultView
    
             mydatagrid.DataSource = myView
             mydatagrid.DataBind()
             Message2.Style("color") = "green"
             Message2.InnerHtml = "Matching Records = " &
myDataGrid.Items.Count
         Catch ex As Exception
             Message.Style("color") = "red"
             Message.InnerHtml = ex.message.ToString()
         Finally
             fsReadXml.Close()
         End Try
    End Sub
    
    
         Sub GetNew(Sender As Object, E As EventArgs)
    
         BindGrid()
    
         End Sub
    
    
         Sub UseSaved(Sender As Object, E As EventArgs)
    
         BindXML()
    
         End Sub


Sub MyDataGrid_Add(Sender As Object, E As DataGridCommandEventArgs)
    
	Connect()
	myConnection.Open()
    
      Dim InsertCmd As String

	Insertcmd = "INSERT INTO INFOAR(MSGNO, SEVERITY, MSG, KEYWORD)
values(@msgno,@sev,@msg,'NONE')"

	myTxn = myConnection.BeginTransaction()
    
      MyCommand = New FbCommand(InsertCmd, MyConnection, myTxn)
    
    
      MyCommand.Parameters.Add("@msgno", FbType.Integer)
      MyCommand.Parameters("@msgno").Value = E.Item.Cells(6).Text
    
      MyCommand.Parameters.Add("@sev", FbType.VarChar, 18)
      MyCommand.Parameters("@sev").Value = E.Item.Cells(7).Text
    
      MyCommand.Parameters.Add("@msg", FbType.VarChar, 250)
      MyCommand.Parameters("@msg").Value = E.Item.Cells(8).Text
    
    
      Try
      	MyCommand.ExecuteNonQuery()
            myTxn.Commit()
            myTxn.Dispose()
            myCommand.Dispose()
            Message.Style("color") = "Green"
            Message.InnerHtml = "<b>Record has been Added.</b><br>"
            Message2.Style("color") = "green"
            Message2.InnerHtml = "Matching Records = " &
myDataGrid.Items.Count
    		myConnection.Close()
    
    
      Catch Exp As FbException
		myTxn.Rollback()
            myTxn.Dispose()
            myCommand.Dispose()
            Message.Style("color") = "red"
            Message.InnerHtml = Exp.Message
            myConnection.Close()
    
      End Try
End Sub



Hope this is of help.

Regards,

Andrew Goodall.

Hello=3A

=3E Could somebody please tell me where I can get the =2ENet provider =

=3E for firebird

http=3A//www=2Eibphoenix=2Ecom/main=2Enfs=3Fa=3Dibphoenix=26page=3Dibp=5F=
download=23NET

=3E and possibly a good xample of connecting to a database=2C issuing sel=
ect
=3E statements=2C using stored procedures from VB=2ENET=2E

There are some examples that ships with the =2Enet data provider but all =

of them are in C=23




--
Best regards
Carlos Guzm=E1n =C1lvarez
Vigo-Spain

If u want an example in C# (connecting, running stored procedures) i can
give it to you


""David B"" <NO_...@ya...> wrote in message
news:bcts6o$ovf$1...@ne......
> Hi,
>
> Could somebody please tell me where I can get the .Net provider for
firebird
> and possibly a good xample of connecting to a database, issuing select
> statements, using stored procedures from VB.NET.
>
> I am been searching through the archieves for this group and think that I
> can piece together various bits of info to make a connection once I have
the
> provider, although an example would be good.
>
> My back group has mostly been in classic ASP development to MS SQL
> databases, so hopefully I won't find this toooo hard.
>
> any help is very much appreciated.
>
>
> cheers
>
> martin.
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Hi,

Could somebody please tell me where I can get the .Net provider for firebird
and possibly a good xample of connecting to a database, issuing select
statements, using stored procedures from VB.NET.

I am been searching through the archieves for this group and think that I
can piece together various bits of info to make a connection once I have the
provider, although an example would be good.

My back group has mostly been in classic ASP development to MS SQL
databases, so hopefully I won't find this toooo hard.

any help is very much appreciated.


cheers

martin.

Hello:

Little by little and thanks to the Help of Tedd the Events API 
implementation is in the right way, here is a little example of use:


public static void Main(string[] args)
{
	string connectionString =
		"User=SYSDBA;"			+
		"Password=masterkey;"		+
		@"Database=TESTDB.GDB;" 	+				
		"DataSource=localhost;"		+
		"Port=3050;"			+
		"Dialect=3;"			+
		"Charset=NONE;"			+
		"Role=;"			+
		"Connection lifetime=15;"	+
		"Pooling=false;"		+
		"Packet Size=8192";

	FbConnection connection = new FbConnection(connectionString);
	connection.Open();
	FbTransaction transaction = connection.BeginTransaction();

	FbEvents fbEvents = new FbEvents(connection);

	FbEventAlertEventHandler e = new 
FbEventAlertEventHandler(EventAlertHandler);

	fbEvents.EventAlert += e;
	fbEvents.RegisterEvents("new row", "updated row");

	// First Event Request
	fbEvents.QueEvents();

	FbCommand command = new FbCommand("UPDATE test_table_01 SET char_field 
= 'events test' WHERE INT_FIELD = 3", connection , transaction);
	
	command.ExecuteNonQuery();

	transaction.Commit();
	
	fbEvents.QueEvents();

	transaction = connection.BeginTransaction();

	// Second Event Request
	fbEvents.QueEvents();

	command = new FbCommand("DELETE FROM test_table_01 WHERE int_field = 
3", connection , transaction);
	command.ExecuteNonQuery();
	
	command.CommandText = "UPDATE test_table_01 SET char_field = 'events 
test'";
	command.ExecuteNonQuery();

	command.CommandText = "UPDATE test_table_01 SET char_field = 'events 
test 2'";
	command.ExecuteNonQuery();

	command.CommandText = "INSERT INTO test_table_01 (int_field) VALUES (3)";
	command.ExecuteNonQuery();					

	transaction.Commit();
	
	fbEvents.QueEvents();
										
	connection.Close();

	Console.ReadLine();
}

public static void EventAlertHandler(object sender, FbEventAlertEventArgs e)
{
	for (int i = 0; i < e.Counts.Length; i++)
	{
		Console.WriteLine(e.Counts[i]);
	}
}




Tedd has asked to me if the programmer should be responsible for calling 
QueEvents each time an event is received? or should the provider do it?


I think that it's better to left this responsability to the programmer 
but i want to know opinions about this.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

> > Related to this question, I'm downloading the mono C#
> > compiler tools, but I wondered how (and perhaps why
> > not) I might build the source for the .NET provider
> > within VS.NET2003?  I want to pull out the exception
> > throw when transaction is found to be null - I don't
> > quite understand any reason the transaction is always
> > required.
> 
> The transaction is always required beacuse Firbird requires it always 
> :), i can modify the provider for "solve" this ?? yes, i like this ?? in 
> first place no :), if you start always a transaction your code will work 
> with both Firebird and SQL Server ( and other too ).

I am using VS.NET 2002. It compiles sources of FB.NET provider pretty good. Just add all the source files of provider (all files with .cs extension from "source" folder and subfolders) to your c# code, and that's all.
You can't just pull out the exception when transaction==null, because each statement in firebird server requires a valid transaction (This requirement sounds really unusual on "select" statements, but in firebird or interbase you can select from stored procedure, which updates data). But you can add code that checks transaction, and if it's null, then start new transaction and commit it after executing statement.

> Thanks for jumping in here!
>

Jason,
What you are probably unaware of is that all transaction based SQL databases
require transactions to do all things... read , update and delete. What you
are being insulated from with MSSQL and with many ODBC drivers is that when
you issue the select statement, it starts a transaction (an implicit one)
for you and commits it after giving you the answer (result set). All half
decent drivers will also give you the opportunity to include more than one
statement in this transaction by way of opening (starting manually) your own
explicit transaction, issuing serverl astatements and then explicitly
closing the transaction. If you explicitly open a transaction you must
explicitly close it (commit or rollback). If you leave it to the implicit
transaction, then each and every statement that you issue will be carried
out under it's very own little transaction.
Hope this helps
Alan

Hello:

> Now, I still don't understand why Firebird MUST have a
> transaction for reading, but then it really doesn't
> matter, though - it works!

Well i can try to modify this on the .NET Provider for ExecuteReader and 
ExecuteScalar , opinions ??






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello:

> I think the material I commented out is important, but
> there must be an MS equivalent I'm not including. I'll
> download NANT and try with that (never heard of it
> before now - and I can't yet figure out how to build
> it with Mono).

For mono on Linux the Provider has a makefile, for Windows you can try 
to build it with NAnt.



 >//
 >==============================================================
 >// at the following Commit, an
 >"InvalidOperationException" fires
 >//
 >==============================================================
 >  trans->Commit();
 >  dataReader->Close();

Try this:

	dataReader->Close();
	trans->Commit();	




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-España

Thanks for jumping in here!

Here's an example of the problem I'm having.

This is a slightly modified version of the example
found on MSDN for SqlDataReader and such.

As Carlos pointed out, if I use the transaction for
Sql2000 (MS), it should work for all users. I still
can't get my mind to accept just WHY a transaction is
required to read data, as it isn't for most SQL
engines I've used thus far, and from ADO (while my
ODBC connector trial was still working), Firebird
didn't require them either, as I could tell.

The example below is in two sections, the first is for
Firebird, the second (commented out) is for MS SQL. I
switch to that by removing the comment blocks, and
commenting out the upper portion for Firebird.

The target is compiled for a managed target, console
application (as setup from MSDN), so "letting go" of
pointers like it does is "acceptable" - though not so
much to me - it works without complaint in MS SQL, and
illustrates the problem.

In the Firebird version, the trans->Commit() causes an
"InvalidOperationException" - so it can't continue.
Since the "ExecuteReader" won't work without a
transaction, I'm at a loss for just how to use the
same connection a second time without first closing
it. 

On the other hand, the MS SQL version runs as it is,
and runs fine without the transaction object.

I tried replacing the commit with rollback, and just
letting the transaction fall out of scope. Rollback
fires the same exception as commit, and even when the
transaction object falls out of scope, the connection
still has a transaction open, and won't allow another
reader to be executed (even when the previous reader
is closed).

What am I not understanding here?

BTW, I tried building the source for the Firebird
provider in VS.NET 2003. I created a managed DLL
target, tossed in all of the CS modules, relocated the
"SNK" file, and with only commenting out the
System.Drawing and the "ToolBox" entry, it compiled
without errors or complaints. However, for reasons I
don't yet understand, while the target applications
link properly, the fire an exception complaining they
can't find the assembly, even when RegASM is used, and
the original Firebird....dll is tucked away elsewhere.
I think the material I commented out is important, but
there must be an MS equivalent I'm not including. I'll
download NANT and try with that (never heard of it
before now - and I can't yet figure out how to build
it with Mono).




#using <mscorlib.dll>
using namespace System;

#using "System.dll"
#using "System.Data.dll"
#using
"d:\firebirdnetprovider\FirebirdSql.Data.Firebird.dll"



using namespace System::ComponentModel;
using namespace System::Data;
using namespace System::Data::SqlClient;

using namespace FirebirdSql::Data::Firebird;


void main()
{
	// Query user for user id and password

	// Connect to the SQL Database and issue a SELECT
command all in one statement
	String *query = "SELECT * FROM DEPARTMENT";
	// build connect string with the userid and password

    String *connectString =
"Database=d:\\firebird\\examples\\employee.fdb;User=xxxxxx;Password=xxxxxxx;Dialect=3;Server=192.168.0.1;";




	//You can use this format if you are connecting with
a known user name and password,
	// however it is not recommended to store these in
the source for security reasons
	//String *connectString =  S"Data
Source=localhost;Database=Northwind;UID=sa;Password=;";

	FbConnection* sqlconn = new
FbConnection(connectString);
	sqlconn->Open();



	FbCommand *sqlCommand = new FbCommand(query,
sqlconn);

    FbTransaction *trans =
sqlconn->BeginTransaction();
    sqlCommand->Transaction = trans; 

	// Create a SqlDataReader to enumerate the result of
executing the command against the database.
	FbDataReader *dataReader =
sqlCommand->ExecuteReader();

	// Find number of columns in result
	int numCols = dataReader->FieldCount;

	// Display number of columns returned from query
	Console::Write(S"No. of columns:");
	Console::WriteLine(numCols);
 
	// Display the data, separated by tabs
	while(dataReader->Read())
	{
		for (int c = 0; c < numCols; c++)
		{
			Console::Write(dataReader->Item[c]->ToString());
			Console::Write(S"\t");
		}
		Console::WriteLine(S"");
	}


//
==============================================================


// at the following Commit, an
"InvalidOperationException" fires


//
==============================================================

   trans->Commit();
   dataReader->Close();

	sqlCommand = new FbCommand(query, sqlconn);

    trans = sqlconn->BeginTransaction();
    sqlCommand->Transaction = trans; 

	// Create a SqlDataReader to enumerate the result of
executing the command against the database.
	dataReader = sqlCommand->ExecuteReader();

	// Find number of columns in result
	numCols = dataReader->FieldCount;

	// Display number of columns returned from query
	Console::Write(S"No. of columns:");
	Console::WriteLine(numCols);
 
	// Display the data, separated by tabs
	while(dataReader->Read())
	{
		for (int c = 0; c < numCols; c++)
		{
			Console::Write(dataReader->Item[c]->ToString());
			Console::Write(S"\t");
		}
		Console::WriteLine(S"");
	}


   trans->Commit();
   dataReader->Close();


}




/*
void main()
{
	// Query user for user id and password

	// Connect to the SQL Database and issue a SELECT
command all in one statement
	String *query = S"SELECT * FROM [Order Details]";
	// build connect string with the userid and password
	String *connectString = S"Data
Source=192.168.0.1;Database=Northwind;UID=xxxxxxx;Password=xxxxxxxxx;";

	//You can use this format if you are connecting with
a known user name and password,
	// however it is not recommended to store these in
the source for security reasons
	//String *connectString =  S"Data
Source=localhost;Database=Northwind;UID=sa;Password=;";

	SqlConnection* sqlconn = new
SqlConnection(connectString);
	sqlconn->Open();

    SqlTransaction *trans =
sqlconn->BeginTransaction();
	SqlCommand *sqlCommand = new SqlCommand(query,
sqlconn);
    sqlCommand->Transaction = trans;

	// Create a SqlDataReader to enumerate the result of
executing the command against the database.
	SqlDataReader *dataReader =
sqlCommand->ExecuteReader();

	// Find number of columns in result
	int numCols = dataReader->FieldCount;

	// Display number of columns returned from query
	Console::Write(S"No. of columns:");
	Console::WriteLine(numCols);

	// Display the data, separated by tabs
	while(dataReader->Read())
	{
		for (int c = 0; c < numCols; c++)
		{
			Console::Write(dataReader->Item[c]->ToString());
			Console::Write(S"\t");
		}
		Console::WriteLine(S"");
	}

    trans->Commit();
    dataReader->Close();


    trans = sqlconn->BeginTransaction();
	sqlCommand = new SqlCommand(query, sqlconn);
    sqlCommand->Transaction = trans;

	// Create a SqlDataReader to enumerate the result of
executing the command against the database.
	dataReader = sqlCommand->ExecuteReader();

	// Find number of columns in result
	numCols = dataReader->FieldCount;

	// Display number of columns returned from query
	Console::Write(S"No. of columns:");
	Console::WriteLine(numCols);

	// Display the data, separated by tabs
	while(dataReader->Read())
	{
		for (int c = 0; c < numCols; c++)
		{
			Console::Write(dataReader->Item[c]->ToString());
			Console::Write(S"\t");
		}
		Console::WriteLine(S"");
	}



   trans->Commit();
   dataReader->Close();


}

*/



__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com