I have been now reading MSDN and understand that the way to go is always 
to open/close connection as the pool itself takes care of it.

with help of sample in MSDN I got this to work

             String fullname = TxtBox_name.Text;
             String email = TxtBox_email.Text;
             String phone = TxtBox_phone.Text;
             String pwd = TxtBox_pwd.Text;

             System.Configuration.Configuration rootWebConfig 
=System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
             System.Configuration.ConnectionStringSettings connString;
             if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count 
 > 0)
             {
                 connString 
=rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString2"];
                 if (connString != null)
                 {

                     using (FbConnection conn = new 
FbConnection(connString.ConnectionString))
                     {
                         conn.Open();
                         using (FbCommand cmd = conn.CreateCommand())
                         {
                             cmd.CommandText = "select * from 
SP_PARTY_INS (?, ?, ?, ?, ?);";
                             cmd.Parameters.Add("@email", email);
                             cmd.Parameters.Add("@name", fullname);
                             cmd.Parameters.Add("@websiteurl", null);
                             cmd.Parameters.Add("@phone", phone);
                             cmd.Parameters.Add("@pwd", pwd);
                             int i = (int)cmd.ExecuteScalar();

                             if (i != null)
                             {
                                 Button2.Text = "New user id: " + i;
                             }

                         }
                         conn.Close();
                     }

                 }

             }




however is there any advantages of using FbCommand over just doing with 
Visual Studio SqlDataSource command? because this code is a lot shorter

             String fullname=TxtBox_name.Text;
             String email=TxtBox_email.Text;
             String phone=TxtBox_phone.Text;
             String pwd = TxtBox_pwd.Text;


             SqlDataSource1.SelectParameters.Add("@email", email);
             SqlDataSource1.SelectParameters.Add("@name", fullname);
             SqlDataSource1.SelectParameters.Add("@websiteurl", null);
             SqlDataSource1.SelectParameters.Add("@phone", phone);
             SqlDataSource1.SelectParameters.Add("@pwd", pwd);

             DataView dv = 
(DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
             int i = (int)dv.Table.Rows[0][0];
             if (i != null)
             {
                 Button1.Text = "New user id: " + i;
             }



is there any difference in performance? or some other advantage?



On 18.12.2011 11:19, Jiri Cincura wrote:
> On Sun, Dec 18, 2011 at 12:20 AM, Net Newbie<netfireb...@gmail.com>  wrote:
>> how to do this in a better way?
> Look at connection pooling topic at MSDN.
>


------------------------------------------------------------------------------
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