Hi Mauricio, Few days ago I got similar exception of type ArgumentNullException. I have found out this conclusion..
Unfortunately the Provider checks whether SourceColumn property is filled with some string and if not it throws an exception. So my solution was very simple - I had mapped my "trouble-making-parameter" to some of my column (the value of the parameter is changed on the RowUpdating event), in order to satisfy the Provider and make it execute the command. Hope this will help you Btw. Maybe that Carlos will give us some better advice how to manage such situation (Parameter with no SourceColumn)... Regards Marek Leitl > Date: Thu, 5 Oct 2006 15:48:58 -0300 > From: "Mauricio I. Magni" <[EMAIL PROTECTED]> > Subject: [Firebird-net-provider] Update parameter without SourceColumn > To: [email protected] > Message-ID: <[EMAIL PROTECTED]> > > Hello > > I'm using NetProvider 2.0.1 RC1 and Firebird 2.0 RC4. > > I'm trying to update a datatable with a store procedure, one > sp's parameters > is a SessionID, I want this parameter take a value from a > SessionManager > object instead of a table's column. > > When i build the command use > param = _updateCommand.Parameters.Add("@Session_Id", > FbDbType.Integer, 0); > param.Value = SecurityDal.Instance.SessionId; > > The trouble raises when executing > adapter.Update(table); > > This command throws an exception with the message > "SourceColumn is required > to be a non-emtpy string. Parameter name: sourceColumn." > > Could anybody point me in the right direction? > > Thanks in advance. > Mauricio I. Magni. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
