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

Reply via email to