Concurso – Desarrollo Web Express
Publicado: 21/07/2006 Archivado en: Informática e Internet Deja un comentario »Pasar vectores y dataset a servicios web
Publicado: 13/07/2006 Archivado en: Informática e Internet Deja un comentario »<WebMethod()> _
Public Function MetodoArray(ByVal strArray() As String, ByVal intIndice As Integer) As String Return strArray(intIndice) End Function<WebMethod()> _
Public Function MetodoDataSet(ByVal oDs As DataSet, ByVal intIndice As Integer) As String Return oDs.Tables(0).Rows(0).Item(intIndice).ToString End Function
Y la prueba desde el código en un formulario web:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim MiArray(10) As String
For i As Integer = 0 To 9
MiArray(i) = i.ToString
Next
Dim oWs As New ServicioWeb.WebService
Me.Label1.Text = oWs.MetodoArray(MiArray, 1)
End Sub
Pedido
Publicado: 11/07/2006 Archivado en: Informática e Internet 1 comentario »Cuando uno espera… llega!
Publicado: 10/07/2006 Archivado en: Informática e Internet 2 Comentarios »DataSet como RecordSet
Publicado: 07/07/2006 Archivado en: Informática e Internet 1 comentario »Imports
System.DataPublic
Class RecordSet Implements IDisposable#
Region "Local Variables" Private _strPath As String = "" Private _strCurrentTable As String = "" Public Enum RecordsetPropertiesDischargeChanges
AutoUpdateChanges
End Enum Private Enum ActionStatusStandBy
NewRecord
End Enum Private _EnuStatus As ActionStatus Private _EnuActions As RecordsetProperties Private _Ds As DataSet Private _lngI As Long = -1 Private _Dr As DataRow#
End Region#
Region "New Functions" Public Sub New(ByVal Path As String, ByVal Table As String, ByVal Action As RecordsetProperties)_strPath = Path
_strCurrentTable = Table
_EnuActions = Action
ResetObject()
End Sub Public Sub New(ByVal Path As String, ByVal Table As String)_strPath = Path
_strCurrentTable = Table
_EnuActions = RecordsetProperties.DischargeChanges
ResetObject()
End Sub Public Sub New(ByVal Path As String)_strPath = Path
_EnuActions = RecordsetProperties.DischargeChanges
ResetObject()
End Sub Public Sub New()_EnuActions = RecordsetProperties.DischargeChanges
ResetObject()
End Sub#
End Region#
Region "Open Functions" Public Function Open(ByVal Path As String, ByVal Table As String, ByVal Action As RecordsetProperties) As Boolean_strPath = Path
_strCurrentTable = Table
_EnuActions = Action
Try_Ds =
New DataSet_Ds.ReadXml(_strPath)
ResetObject()
Return True Catch ex As Exception Throw ex End Try End Function Public Function Open(ByVal Path As String, ByVal Table As String) As Boolean_strPath = Path
_strCurrentTable = Table
Try_Ds =
New DataSet_Ds.ReadXml(_strPath)
ResetObject()
Return True Catch ex As Exception Throw ex End Try End Function Public Function Open(ByVal Table As String) As Boolean If _strPath.Trim.Length <> 0 Then_strCurrentTable = Table
If _strCurrentTable.Trim.Length <> 0 Then Try_Ds =
New DataSet_Ds.ReadXml(_strPath)
ResetObject()
Return True Catch ex As Exception Throw ex End Try Else Throw New Exception("No table name given") End If Else Throw New Exception("No path given") End If End Function Public Function Open() As Boolean If _strPath.Trim.Length <> 0 Then If _strCurrentTable.Trim.Length <> 0 Then Try_Ds =
New DataSet_Ds.ReadXml(_strPath)
ResetObject()
Return True Catch ex As Exception Throw ex End Try Else Throw New Exception("No table name given") End If Else Throw New Exception("No path given") End If End Function#
End Region#
Region "Common Functions" Private Sub ResetObject()_lngI = -1
_EnuStatus = ActionStatus.StandBy
End Sub#
End Region#
Region "RecordSet handling" Public Function MoveNext() As Boolean Try_lngI += 1
If _lngI < _Ds.Tables(_strCurrentTable).Rows.Count Then Return True Else Return False End If Catch ex As Exception Throw ex End Try End Function Public Function MoveBack() As Boolean Try_lngI -= 1
If _lngI >= 0 Then Return True Else_lngI = 0
Return False End If Catch ex As Exception Throw ex End Try End Function Public Function MoveLast() As Boolean Try_lngI = _Ds.Tables(_strCurrentTable).Rows.Count – 1
Return True Catch ex As Exception Throw ex End Try End Function Public Function MoveFirst() As Boolean Try_lngI = 0
Return True Catch ex As Exception Throw ex End Try End Function#
End Region#
Region "Administrative Functions" Public Function getItem(ByVal ColumnName As String) As String Try Return _Ds.Tables(_strCurrentTable).Rows(_lngI).Item(ColumnName) Catch ex As Exception Throw ex End Try End Function Public Function getItem(ByVal ColumnIndex As Integer) As String Try Return _Ds.Tables(_strCurrentTable).Rows(_lngI).Item(ColumnIndex) Catch ex As Exception Throw ex End Try End Function Public Function RecordCount() As Long Try Return _Ds.Tables(_strCurrentTable).Rows.Count Catch ex As Exception Throw ex End Try End Function Public Function DeleteRecord() As Boolean Try_Ds.Tables(_strCurrentTable).Rows(_lngI).Delete()
Select Case _EnuActions Case RecordsetProperties.AutoUpdateChangesSave()
End Select Return True Catch ex As Exception Throw ex End Try End Function Public Function UpdateRecord(ByVal ColumnName As String, ByVal Value As String) As Boolean Try Select Case _EnuStatus Case ActionStatus.NewRecord_Dr(ColumnName) = Value
Return True Case ActionStatus.StandBy_Ds.Tables(_strCurrentTable).Rows(_lngI).Item(ColumnName) = Value
Select Case _EnuActions Case RecordsetProperties.AutoUpdateChangesSave()
End Select Return True End Select Catch ex As Exception Throw ex End Try End Function Public Function UpdateRecord(ByVal ColumnIndex As Integer, ByVal Value As String) As Boolean Try Select Case _EnuStatus Case ActionStatus.StandBy_Ds.Tables(_strCurrentTable).Rows(_lngI).Item(ColumnIndex) = Value
Select Case _EnuActions Case RecordsetProperties.AutoUpdateChangesSave()
End Select Return True Case ActionStatus.NewRecord_Dr(ColumnIndex) = Value
Return True End Select Catch ex As Exception Throw ex End Try End Function Public Function FinalizeRecord() As Boolean Try If _EnuStatus = ActionStatus.NewRecord Then_Ds.Tables(_strCurrentTable).Rows.Add(_Dr)
_EnuStatus = ActionStatus.StandBy
Select Case _EnuActions Case RecordsetProperties.AutoUpdateChangesSave()
End Select Return True Else Return False End If Catch ex As Exception Throw ex End Try End Function Public Function NewRecord() As Boolean Try_Dr = _Ds.Tables(_strCurrentTable).NewRow
_EnuStatus = ActionStatus.NewRecord
Return True Catch ex As Exception Throw ex End Try End Function Public Function Save() As Boolean Try_Ds.WriteXml(_strPath)
Return True Catch ex As Exception Throw ex End Try End Function Public Function SaveAs(ByVal Path As String) As Boolean Try_Ds.WriteXml(Path)
Return True Catch ex As Exception Throw ex End Try End Function#
End Region#
Region ".Net Functions" Public Overridable Sub Dispose() Implements IDisposable.Dispose Try_Ds.Dispose()
_Ds =
NothingCatch ex As Exception End Try End Sub
#
End RegionEnd
Class
