thank you very much for this link. I am having some small problems in getting the connection to work. Instead of hard coding it to every ASP.NET WebForm I am looking for a way to use it from Web.config I tried this way but I think I am lacking provider as this gives me error "Keyword not supported: dialect.", how to add here Firebird provider? in web.config it is defined as following <add name="ConnectionString" connectionString="dialect=3;port=3050;data source=localhost;initial catalog="C:\Program Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB";user id=sysdba;password=masterkey" providerName="FirebirdSql.Data.FirebirdClient" />
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand("ADD_EMP_PROJ", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@emp_no", SqlDbType.Int); cmd.Parameters["@emp_no"].Value = 2; cmd.Parameters.Add("@proj_id", SqlDbType.Text); cmd.Parameters["@proj_id"].Value = "DGPII"; try { //open connection conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { //handle error throw (ex); } I am sorry to ask so basic questions but I am new to .NET and Firebird .NET provider usage could also be better documented and could come with samples. thanks. On 31.10.2011 8:07, Gerdus van Zyl wrote: > http://blog.cincura.net/227021-firebird-net-provider-and-calling-stored-procedures-with-parameters/ > > and > > http://www.lmgtfy.com/?q=stored+procedure+ado.net+firebird > > On Mon, Oct 31, 2011 at 7:54 AM, Alexander Muylaert > <amuylaert_gel...@hotmail.com> wrote: >> http://www.amazon.com/ADO-Programming-Dummies-CD-ROM-Krumm/dp/0764507478 >> >> -----Oorspronkelijk bericht----- >> Van: Net Developer [mailto:netfireb...@gmail.com] >> Verzonden: zondag 30 oktober 2011 23:41 >> Aan: firebird-net-provider@lists.sourceforge.net >> Onderwerp: [Firebird-net-provider] Executing Firebird stored procedure from >> ASP.NET >> >> How to execute a Firebird stored procedure from ASP.NET application? >> I have VS2010. Sucessfully can over SQLDataSource connect and do queries. >> >> please provide a code sample. >> thanks. >> >> >> ------------------------------------------------------------------------------ Get your Android app more play: Bring it to the BlackBerry PlayBook in minutes. BlackBerry App World™ now supports Android™ Apps for the BlackBerry® PlayBook™. Discover just how easy and simple it is! http://p.sf.net/sfu/android-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider