Yes, finally! Thanks Erv.
I am new to VB.Net. What is the purpose of the GetData method? Rick -----Original Message----- From: Ervin Kleinschmidt [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 3:18 PM To: [EMAIL PROTECTED]; For users and developers of the Firebird .NET providers Subject: RE: [Firebird-net-provider] Call tableadapter stored procedure fromcode To get data back use the fill method. An Example from one of my projects. Note I'm setting '@' in the parameters name field in the dataset. Me.NewRecipientTableAdapter.Fill(Me.PremiumsDataSet.NewRecipient, Me.PremiumsDataSet.ORDERS(0).CUSTID, txtRcpLastName.Text, txtRcpFirstName.Text, txtRcpAddr1.Text, txtRcpAddr2.Text, txtRcpCity.Text, txtRcpSate.Text, txtRcpZip.Text, Nothing, Nothing, txtRcpFEDID.Text, Nothing) Another example would be. Note: dataset names need to change to match yours. Me.NewRecipientTableAdapter.Fill(Me.PremiumsDataSet.NewRecipient,@INVOICENUM , @LOGOFOLDER, @DOCTYPE) Erv -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Roen Sent: Friday, October 20, 2006 3:45 PM To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Call tableadapter stored procedure fromcode Well, hopefully I understood this correctly. Before I had in my GetData method: GetData(INVOICENUM, LOGOFOLDER, DOCTYPE) And now I have GetData(@INVOICENUM, @LOGOFOLDER, @DOCTYPE) So now I call like this Dim sdInfo As New RGardenDataSetTableAdapters.P_XML_SALESDOCTableAdapter sdInfo.GetData(920553, "c:\temp", 5) MessageBox.Show("row count: " & RGardenDataSet.P_XML_SALESDOC.Rows.Count and I get no error, but no output either - the row count is 0. When I input the same values in the Preview Data of the data set designer, I get 1500 rows. What else could it be, and thanks for your help so far. P.S. when I do this the "old" (according to Jiri) way with an FBCommand, I also get the results I am looking for. Rick -----Original Message----- From: Carlos Guzmán Álvarez [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 1:55 PM To: [EMAIL PROTECTED] Subject: Re: [Firebird-net-provider] Call tableadapter stored procedure from code Hello: > Invoicenum - Int64 > LogoFolder - String > Doctype - Int64 Change the names to be: @Invoicenum @LogoFolder @Doctype -- Carlos Guzmán Álvarez Vigo-Spain ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
