firebird-net-provider

[Firebird-net-provider] FB.Net Provider Error

[Sandeep C. <sa...@cf...>]

I'm using FB.Net provider to connect to a database. I can connect to 
the database, but when I try to execute a query I get this error

"Object reference not set to an instance of an object".

I'm just trying simple updates to a table. (Same query that is in Help
on FbConnection)

What am I doing wrong?

I put this question on IBSupport and I was old to post it to this email
address. Where do I read the reply to this posting?

Regards

Sandeep

Re: [Firebird-net-provider] FB.Net Provider Error

[<car...@te...>]

Hello:


> I'm just trying simple updates to a table. (Same query that is in Help
> on FbConnection)


The examples was wrong try this:

	
		FbConnection  myConn = new FbConnection(connectionString);
		
		myConn.Open();

		FbTransaction myTxn  = myConn.BeginTransaction();
		string		 myInsertQuery = "INSERT INTO PROJECT(proj_id, proj_name, 
product) Values ('FBNP', '.Net Provider', 'N/A')";
		FbCommand	 myFbCommand   = new FbCommand(myInsertQuery, myConn, myTxn);
				
		myFbCommand.ExecuteNonQuery();
		myConn.Close();

		Console.ReadLine();		


I have modified the example and updated the CVS, thanks.


 >>I put this question on IBSupport and I was old to post it to this 
 >>email address. Where do I read the reply to this posting?

http://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Best regards
Carlos Guzmán Álvarez
Vigo-Spain