Re: [Firebird-net-provider] Executing Firebird stored procedure from ASP.NET

[Net Newbie]

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=&quot;C:\Program 
Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB&quot;;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&#153; now supports Android&#153; Apps 
for the BlackBerry&reg; PlayBook&#153;. 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