A data adapter object utilizes the Fill method to populate a DataSet or a DataTable object with data retrieved by a SELECT command. Internally, the Fill method makes use of a data reader to get to the data and the metadata that describe the structure and content of the source tables. The data read is then copied into ad hoc memory containers (that is, the DataTable).
If the GetData method cannot find data in the specified format, it attempts to convert the data to the format. If the data cannot be converted to the specified format, this method returns a null reference (Nothing in Visual Basic). To determine whether data is associated with, or can be converted to, a format, call GetDataPresent before calling GetData. Call GetFormats for a list of valid formats for the data stored in this instance. Note Data can be converted to another format if it was stored specifying that conversion is allowed, and if the requested format is compatible with the stored format. For example, data stored as Unicode can be converted to text. Return Value from GetData will be a null reference (Nothing in Visual Basic). If you have a write with no results you could use the Getdata in Visual Basic Erv -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Roen Sent: Friday, October 20, 2006 6:08 PM To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Call tableadapter stored procedurefromcode 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 ------------------------------------------------------------------------- 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
