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
> <[email protected]> wrote:
>> http://www.amazon.com/ADO-Programming-Dummies-CD-ROM-Krumm/dp/0764507478
>>
>> -----Oorspronkelijk bericht-----
>> Van: Net Developer [mailto:[email protected]]
>> Verzonden: zondag 30 oktober 2011 23:41
>> Aan: [email protected]
>> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
