Εχω το εξής πρόβλημα μέσα απο ενα Webrefernce το οποιο εχει μια function που δέχετε μια τιμή και επιστρεφει ενα DATAADAPTER οταν την καλώ απο το απο το webform δεχομε το εξής error..
Σημ. Οταν δηλώσω στην function tou WEBREFERΕNCE οτι επιστρέφει SqlDataAdapter δεν μπορώ να επιστρέψω τιποτα.Μονο ετσί παιζει όπως γράφω παρακάτω
Server was unable to process request. --> There was an error
generating the XML document. --> The type
System.Data.SqlClient.SqlDataAdapter was not expected. Use the XmlInclude or
SoapInclude attribute to specify types that are not known statically.
WEBREFERNCE ------------
Public Function GETDATA_ADVENT_DA(ByVal code As String)
Dim SQLSTR As String
Dim da As New SqlDataAdapter
Dim cnn As New System.Data.SqlClient.SqlConnection
cnn.ConnectionString = GetCNN("SQL")
cnn.Open()
SQLSTR = "SELECT isnull(Code_as,'0') FROM Advent_Data_Acounts where Code_as = '" & code & "'"
da = New SqlDataAdapter(SQLSTR, cnn)
cnn.Close()
Return da
End Function
WEBREFERNCE ------------
WEBFORM --------------------- OPOU KALEITE....
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim wr As New localhost1.ReturnData
Dim result As New SqlDataAdapter
result = wr.GETDATA_ADVENT_DA(TextBox1.Text, False) --------------> EDW PERNW TO ERROR!
Dim ds As DataSet = New DataSet
result.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End Sub