Visual Basic

BobsAfro10-May-07 6:29

10-May-07 6:29

Okay I have imported it into both projects so they are both using the dll.
But it still says
"namespace.classname can not be converted to web_service_name.classname"

Same problem as before.

Dave Kreskowiak10-May-07 6:34

Dave Kreskowiak

10-May-07 6:34

Did you remove the old class definitions from your code?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

BobsAfro10-May-07 6:37

10-May-07 6:37

I have removed the old class.

BobsAfro10-May-07 6:39

10-May-07 6:39

Removed the reference and added it again and still no luck.

nlarson1110-May-07 7:57

10-May-07 7:57

before you re-addedit, did you first compile the webservice with the new class?

nlarson1110-May-07 6:35

10-May-07 6:35

are you using web reference or going after the webservice dynamically?

if web reference -- try to remove the reference and re-add it...

BobsAfro10-May-07 22:04

10-May-07 22:04

I am adding a web reference to it.
I have removed it, recompiled the service and added it again and still has the same problem.

BobsAfro10-May-07 23:11

10-May-07 23:11

Well I have managed to achieve what I want to but in a pretty crude way.
I have written a function to serialize a class and one to deserialize it.
Like this -

        Public Function Object2XML(ByVal obj As Object) As String<br />
            Dim SW As New StringWriter<br />
            Dim Ser As New XmlSerializer(obj.GetType())<br />
            Try<br />
                Ser.Serialize(SW, obj)<br />
                Return SW.ToString<br />
            Catch ex As Exception<br />
                Throw ex<br />
            End Try<br />
        End Function<br />
<br />
    Public Function XML2OBject(ByVal xml As String, ByVal Type As Type) As Object<br />
        Dim Obj As New Object<br />
        Dim SR As New StringReader(xml)<br />
        Dim Serializer As New System.Xml.Serialization.XmlSerializer(Type)<br />
        Try<br />
            Return Serializer.Deserialize(SR)<br />
        Catch ex As Exception<br />
            Throw ex<br />
        End Try<br />
    End Function

But surely there is a better way to do it than this?

nlarson1111-May-07 4:09

11-May-07 4:09

if you want, you can email your solution and I can take a quick look (strip out any unnecessary code)

BobsAfro11-May-07 5:02

11-May-07 5:02

Thats a very kind offer but It is as very large project and I can't strip it easily.
Don't think my boss would appreciate me sending you the whole of our site.
Thanks anyway.

Have you managed to pass a custom class to a web service before successfully?

nlarson1111-May-07 5:27

11-May-07 5:27

yes we do it all the time. we do not however use web references (not that I think that's the problem). we go after the webservice dynamically...

BobsAfro11-May-07 5:33

11-May-07 5:33

How do you go after the webservice dynamically as you put it?

nlarson1111-May-07 6:12

11-May-07 6:12

let me put a quick sample together...

nlarson1111-May-07 11:07

11-May-07 11:07

example:

include system.web.services in your exe project
make the webservice (if not already) a virtual directory

the line - Me.Url = "http://localhost/cpwebproj/PopulateMyObj.asmx"
allows you to change localhost to any ip/dns name

hope this helps...

********this goes in your dll***********

<Serializable()> _
Public Class MyObj
Public sName As String
Public sAddr As String
Public sCity As String
Public sState As String
Public sZip As String
End Class

********this goes in your exe***********
Public Class Form1
Inherits System.Windows.Forms.Form

Private Sub Form1_Load1(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim oEntity As New CPDllProj.MyObj
Dim oTrans As New Trans

oEntity = oTrans.Request(oEntity)

MsgBox(oEntity.sName)
MsgBox(oEntity.sAddr)
MsgBox(oEntity.sCity)
MsgBox(oEntity.sState)
MsgBox(oEntity.sZip)

End
End Sub
end class

Imports System.Web.Services
Imports System.Web.Services.Protocols

<System.Diagnostics.DebuggerStepThroughAttribute(), _
System.ComponentModel.DesignerCategoryAttribute("code"), _
System.Web.Services.WebServiceBindingAttribute(Name:="CPHandlerSoap", [Namespace]:="CPWebProj/PopulateMyObj")> _
Public Class Trans
Inherits System.Web.Services.Protocols.SoapHttpClientProtocol

<System.Web.Services.Protocols.SoapDocumentMethodAttribute("CPWebProj/PopulateMyObj/Request", _
RequestNamespace:="CPWebProj/PopulateMyObj", _
ResponseNamespace:="CPWebProj/PopulateMyObj", _
Use:=System.Web.Services.Description.SoapBindingUse.Literal, _
ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _
Public Function Request(ByVal oEntity As CPDllProj.MyObj) As CPDllProj.MyObj
Dim oa() As Object

Me.Url = "http://localhost/cpwebproj/PopulateMyObj.asmx"
Me.Timeout = 60000

oa = Me.Invoke("Request", New Object() {oEntity})
Return CType(oa(0), CPDllProj.MyObj)
End Function
End Class

********this goes in your webservice***********

Imports System.Web.Services

<System.Web.Services.WebService(Namespace:="CPWebProj/PopulateMyObj")> _
Public Class PopulateMyObj
Inherits System.Web.Services.WebService

#Region " Web Services Designer Generated Code "

Public Sub New()
MyBase.New()

'This call is required by the Web Services Designer.
InitializeComponent()

'Add your own initialization code after the InitializeComponent() call

End Sub

'Required by the Web Services Designer
Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Web Services Designer
'It can be modified using the Web Services Designer.
'Do not modify it using the code editor.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
components = New System.ComponentModel.Container
End Sub

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
'CODEGEN: This procedure is required by the Web Services Designer
'Do not modify it using the code editor.
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub

#End Region

<WebMethod(), _
System.Xml.Serialization.XmlInclude(GetType(CPDllProj.MyObj))> _
Public Function Request(ByVal oEntity As CPDllProj.MyObj) As CPDllProj.MyObj
oEntity.sName = "me"
oEntity.sAddr = "123 test st"
oEntity.sCity = "testy town"
oEntity.sState = "IL"
oEntity.sZip = "60000"
Return oEntity
End Function
End Class

BobsAfro14-May-07 3:26

14-May-07 3:26

Thanks very much for your help.
But i'm afraid you've got a bit beyond me there.

nlarson1114-May-07 3:41

14-May-07 3:41

maybe, maybe not...

do this and I'll show you how I got the code I sent:

+add a webrefence to your asmx page.
+right-click on the new reference and left-click on view in object browser
+expand the plus
+right-click on your class name
+left-click on goto definition

if you look the upper part of the code, its your routine name showing it's pointing to localhost. this is the code I sent you...

BobsAfro14-May-07 3:48

14-May-07 3:48

"+add a webrefence to your asmx page."
You mean add a webreference to my web service?
In which case a reference to what?

If you meant add a web reference to my consuming project I have and tried clicking view in browser but it was greyed out.

BobsAfro14-May-07 3:53

14-May-07 3:53

For some reason view in browser is no longer gereyed out (no idea what I've done).
but there is no option to view in object browser.

nlarson1114-May-07 3:54

14-May-07 3:54

in your exe, rightclick on the references and choose add web reference
yes point to your web service

using my example is would look like

http://localhost/cpwebproj/populatemyobj.asmx

not view in browser, view in 'object browser'

BobsAfro14-May-07 3:59

Datagrid dropdownlist, populated from Access database. [modified]

14-May-07 3:59

The webreference appears as a folder with 3 files inside none of which have an option to view in object browser on right click.

robw188810-May-07 1:06

robw1888

10-May-07 1:06

Hi all,

First of all I'll apologise in advance! I'm very new to this and have been trying to learn through books and what I can pick up on the net so I'm hoping someone can help me understand where I'm going wrong with the following...

I've set up a datagrid which works perfectly when I use textboxes, however I'm trying to limit user choice by adding dropdownlists to the datagrid. I get as far as clicking to edit the field and get the following error:

---------------------------
System.IndexOutOfRangeException: StatusID

Source Error:

Line 345:
Line 346: <edititemtemplate>
Line 347: <asp:dropdownlist id="ddlStatusctrl" runat="server"
line="" 348:="" datatextfield="Status" 349:="" datavaluefield="StatusID"
=""
----------------------------

my="" coding="" for="" the="" dropdownlist="" is="" as="" follows:

="" <asp:templatecolumn="">
<headertemplate>
Status

<itemtemplate>
<%# Container.DataItem("Status") %>

<edititemtemplate>
<asp:dropdownlist id="ddlStatusctrl" runat="server"
="" datatextfield="Status" datavaluefield="StatusID" datasource="<%# GetStatus() %>" selectedindex="<%# GetSelectedIndex(Container.DataItem("StatusID")) %>">

and VB code is :

to populate the dataset ('Dim DS as DataSet = New DataSet()' declared globally) ...

Function GetStatus() as DataSet

Dim DBConn as OleDbConnection
Dim DBCommand as OleDbDataAdapter

DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("data/Auto_log.mdb") & ";")
DBCommand = New OleDbDataAdapter("SELECT StatusID, Status from Status ORDER BY Status", DBConn)

DBCommand.Fill(DS, "Status")
DBConn.Close()

Return DS

End Function
----------------
to get selected index -

Function GetSelectedIndex(ByVal StatusID As String) As Integer
'Loop through the DataSet DS
Dim iLoop As Integer
Dim DT As DataTable = DS.Tables("Status")
For iLoop = 0 To DT.Rows.Count - 1
If StatusID = DT.Rows(iLoop)("StatusID").ToString Then
Return iLoop
End If
Next iLoop
End Function
-----------

... & to update the database (cut to show coding related to ddl)-

Sub dg_Update(s As Object, e As DataGridCommandEventArgs)

Dim ddlStatus As DropDownList = FindControl("ddlStatusctrl")

strCmd = "UPDATE AutomationHist SET System=@System, Status=@ddlStatus, ProgramNo=@ProgramNo, VersionNo=@VersionNo, LastJobNo=@LastJobNo, Date_Last_Amended=@Date_Last_AmendedParam, Date_Authorised=@Date_AuthorisedParam, Coded_by=@Coded_by, Location=@Location, Calculation=@Calculation, Writeback=@Writeback, Letter_output=@Letter_output, Exceptions=@Exceptions, Comments=@Comments WHERE Primary_Key=@Primary_Key"

objCmd.Parameters.Add("@ddlStatus", ddlStatus)

objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()

dgAutomationHist.EditItemIndex = -1
BindData()
End Sub

------------------

Thanks very much in advance...

Smile | :)

-- modified at 7:21 Thursday 10th May, 2007

-- modified at 7:27 Thursday 10th May, 2007

-- modified at 7:41 Thursday 10th May, 2007

Robster

exlude from column ordering a field

sal219-May-07 23:53

sal21

9-May-07 23:53

I have maked this code and it work nice, for me Wink | ;-)

Now i want to exclude fronm column ordering the filed named "DATA_AGG" how to?
here the mdb in access:www.mytempdir.com/1323897

Option Explicit
Sub ORDER_FILEDS()

Dim DATABASE As DAO.DATABASE
Dim TABELLA As DAO.TableDef
Dim CAMPO_TEMP As DAO.Field
Dim POSIZIONE() As Integer
Dim CAMPO_NOME() As String
Dim INT_TEMP As Integer

Set DATABASE = OpenDatabase("\\GCD01F4500\DATI\PUBBLICA\ANTIRIC\OPERATORI.MDB")
Set TABELLA = DATABASE.TableDefs("TEST")

With TABELLA

ReDim POSIZIONE(0 To .Fields.Count - 1) As Integer
ReDim CAMPO_NOME(0 To .Fields.Count - 1) As String

For INT_TEMP = 0 To .Fields.Count - 1
POSIZIONE(INT_TEMP) = .Fields(INT_TEMP).OrdinalPosition
CAMPO_NOME(INT_TEMP) = .Fields(INT_TEMP).Name
Next INT_TEMP

For Each CAMPO_TEMP In .Fields
CAMPO_TEMP.OrdinalPosition = 1
Next CAMPO_TEMP

End With

DATABASE.Close

End Sub

Re: exlude from column ordering a field

nlarson1110-May-07 4:14