I have defined a ConnectionString in web.config
succesfully I have started using it for linking SqlDataSource to
controls (TextBox, Grid etc). I want to use that same connection to
excecute FbCommand. I need it for executing StoredProcedures. how to do
that?
I can connect and execute FB stored procedures with following code
using (FbConnection conn = new FbConnection("data
source=localhost;initial catalog=C:\\Program
Files\\Firebird\\examples\\EMPLOYEE.GDB;user id=SYSDBA;password=masterkey"))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "execute procedure
ADD_EMP_PROJ(@a, @b);"; ;
cmd.Parameters.Add("@a", FbDbType.Integer).Value = 2;
cmd.Parameters.Add("@b", FbDbType.VarChar).Value =
"DGPII";
cmd.ExecuteNonQuery();
}
conn.Close();
}
but this opens and closes the connection each time. I want to use
already existing connection globally across application (ASP.net
webforms). I am new to Visual Studio and .NET and sorry for asking basic
question, but if I write using (ConnectionString) then this
ConnectionString is unknown, despite that on same form it is used behind
a SqlDataSource control....
how to do this in a better way?
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
