Hi,
I'm working on a project which includes XML WebServices and Windows Form
application.
The Windows Form application will call the XML WebServices to retrieve data
from database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset
returned contain errors (marked by calling the SetColumnError( ) method or
setting the RowError property of the DataRow), I get the following error
message in the Windows Form application,
"There is an error in XML doument (x,xxxxxxx)"
If I forced the Windows Form application to run on .NET Framework 1.0,
everything works fine.
Here's the partial code for the WebService project
Code:
<WebMethod()> _
Public Function RetrieveDataSet () As DataSet
Dim ds As New DataSet
Dim dt As New DataTable
Dim row As DataRow
Dim i As Integer
dt.TableName = "TestTable"
dt.Columns.Add( "TestColumn 1", GetType(String) )
dt.Columns.Add( "TestColumn 2", GetType(Integer ))
ds.DataSetName = "TestDataSe t"
ds.Tables.Add(d t)
For i = 0 To 10
row = dt.NewRow
row("TestColumn 1") = "This is row " & i
row("TestColumn 2") = i
dt.Rows.Add(row )
' The following code trigger the error after the DataSet
' is returned to the calling Window Form application
row.SetColumnEr ror("TestColumn 1", "Error message here")
Next
Return ds
End Function
For the Windows Form application, you need to insert a datagrid control
(assumed as datagrid1). It will look something like this,
Code:
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
Dim ws As localhost.Servi ce1
Dim ds As DataSet
Try
ws = New localhost.Servi ce1
ds = ws.RetrieveData Set
Me.DataGrid1.Se tDataBinding(ds .Tables(0), "")
Catch ex As Exception
MsgBox(ex.Messa ge)
Finally
If (Not (ws Is Nothing)) Then
ws.Dispose()
End If
End Try
End Sub
I really hope someone could help me out with this one.
Thanks in advance.
ps: Please, before anyone reply to state that I did not choose the
appropriate groups when making this post a crossposts post, please know that
I'm currently in blind on what is causing this error. Is it the WebService?
or is it the ADO .Net? or is it Windows Form application? or is it VB .Net?
Well, it has something to do with WebService as it only happens to the
DataSet returned by WebService. It also has something to do with ADO .Net as
I'm using DataSet. And it definitely has something to do with Windows Form
application as if I force the Windows Form application project to run on
..Net Framework 1.0, everything works fine. 6 1231
I (as well as others) have posted multiple times in different groups and
have yet to recieve any response on this issue. It is extremely frustrating
because it is easy to reproduce and yet I have seen no one from MS offer to
look into it or acknowlege it. It would at least be comforting to hear them
say "yes, there is a problem and we are looking into it" but I haven't even
got that yet. Being able to set RowErrors is a powerful tool but as you see,
it will not work through web services returning a dataset as it will produce
the message you indicate below.
Roger
"Programati x" <pr*********@no spam.com> wrote in message
news:Op******** ******@TK2MSFTN GP12.phx.gbl... Hi,
I'm working on a project which includes XML WebServices and Windows Form application.
The Windows Form application will call the XML WebServices to retrieve
data from database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset returned contain errors (marked by calling the SetColumnError( ) method or setting the RowError property of the DataRow), I get the following error message in the Windows Form application,
"There is an error in XML doument (x,xxxxxxx)"
If I forced the Windows Form application to run on .NET Framework 1.0, everything works fine.
Here's the partial code for the WebService project
Code:
<WebMethod()> _ Public Function RetrieveDataSet () As DataSet Dim ds As New DataSet Dim dt As New DataTable Dim row As DataRow Dim i As Integer
dt.TableName = "TestTable" dt.Columns.Add( "TestColumn 1", GetType(String) ) dt.Columns.Add( "TestColumn 2", GetType(Integer ))
ds.DataSetName = "TestDataSe t" ds.Tables.Add(d t)
For i = 0 To 10 row = dt.NewRow row("TestColumn 1") = "This is row " & i row("TestColumn 2") = i dt.Rows.Add(row )
' The following code trigger the error after the DataSet ' is returned to the calling Window Form application row.SetColumnEr ror("TestColumn 1", "Error message here") Next
Return ds End Function For the Windows Form application, you need to insert a datagrid control (assumed as datagrid1). It will look something like this,
Code:
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load Dim ws As localhost.Servi ce1 Dim ds As DataSet
Try ws = New localhost.Servi ce1 ds = ws.RetrieveData Set
Me.DataGrid1.Se tDataBinding(ds .Tables(0), "") Catch ex As Exception MsgBox(ex.Messa ge) Finally If (Not (ws Is Nothing)) Then ws.Dispose() End If End Try End Sub
I really hope someone could help me out with this one.
Thanks in advance.
ps: Please, before anyone reply to state that I did not choose the appropriate groups when making this post a crossposts post, please know
that I'm currently in blind on what is causing this error. Is it the
WebService? or is it the ADO .Net? or is it Windows Form application? or is it VB
..Net? Well, it has something to do with WebService as it only happens to the DataSet returned by WebService. It also has something to do with ADO .Net
as I'm using DataSet. And it definitely has something to do with Windows Form application as if I force the Windows Form application project to run on .Net Framework 1.0, everything works fine.
I guess today I searched on the right keywords - I have looked before but
did not find the following: http://support.microsoft.com/default.aspx?scid=kb;[LN];818587
Knowledge Base Article 818587
Fix: Regression in Dataset Serialization in Visual Studio .NET 1.1 when a
datarow contains a rowError or a ColumnError Property
Roger
"Programati x" <pr*********@no spam.com> wrote in message
news:Op******** ******@TK2MSFTN GP12.phx.gbl... Hi,
I'm working on a project which includes XML WebServices and Windows Form application.
The Windows Form application will call the XML WebServices to retrieve
data from database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset returned contain errors (marked by calling the SetColumnError( ) method or setting the RowError property of the DataRow), I get the following error message in the Windows Form application,
"There is an error in XML doument (x,xxxxxxx)"
If I forced the Windows Form application to run on .NET Framework 1.0, everything works fine.
Here's the partial code for the WebService project
Code:
<WebMethod()> _ Public Function RetrieveDataSet () As DataSet Dim ds As New DataSet Dim dt As New DataTable Dim row As DataRow Dim i As Integer
dt.TableName = "TestTable" dt.Columns.Add( "TestColumn 1", GetType(String) ) dt.Columns.Add( "TestColumn 2", GetType(Integer ))
ds.DataSetName = "TestDataSe t" ds.Tables.Add(d t)
For i = 0 To 10 row = dt.NewRow row("TestColumn 1") = "This is row " & i row("TestColumn 2") = i dt.Rows.Add(row )
' The following code trigger the error after the DataSet ' is returned to the calling Window Form application row.SetColumnEr ror("TestColumn 1", "Error message here") Next
Return ds End Function For the Windows Form application, you need to insert a datagrid control (assumed as datagrid1). It will look something like this,
Code:
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load Dim ws As localhost.Servi ce1 Dim ds As DataSet
Try ws = New localhost.Servi ce1 ds = ws.RetrieveData Set
Me.DataGrid1.Se tDataBinding(ds .Tables(0), "") Catch ex As Exception MsgBox(ex.Messa ge) Finally If (Not (ws Is Nothing)) Then ws.Dispose() End If End Try End Sub
I really hope someone could help me out with this one.
Thanks in advance.
ps: Please, before anyone reply to state that I did not choose the appropriate groups when making this post a crossposts post, please know
that I'm currently in blind on what is causing this error. Is it the
WebService? or is it the ADO .Net? or is it Windows Form application? or is it VB
..Net? Well, it has something to do with WebService as it only happens to the DataSet returned by WebService. It also has something to do with ADO .Net
as I'm using DataSet. And it definitely has something to do with Windows Form application as if I force the Windows Form application project to run on .Net Framework 1.0, everything works fine.
But... there is no way to download it. Sigh...
"RogerS" <no****@hotmail .com> wrote in message
news:uf******** ******@TK2MSFTN GP10.phx.gbl... I guess today I searched on the right keywords - I have looked before but did not find the following: http://support.microsoft.com/default.aspx?scid=kb;[LN];818587
Knowledge Base Article 818587 Fix: Regression in Dataset Serialization in Visual Studio .NET 1.1 when a datarow contains a rowError or a ColumnError Property
Roger
"Programati x" <pr*********@no spam.com> wrote in message news:Op******** ******@TK2MSFTN GP12.phx.gbl... Hi,
I'm working on a project which includes XML WebServices and Windows Form application.
The Windows Form application will call the XML WebServices to retrieve data from database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the
dataset returned contain errors (marked by calling the SetColumnError( ) method
or setting the RowError property of the DataRow), I get the following error message in the Windows Form application,
"There is an error in XML doument (x,xxxxxxx)"
If I forced the Windows Form application to run on .NET Framework 1.0, everything works fine.
Here's the partial code for the WebService project
Code:
<WebMethod()> _ Public Function RetrieveDataSet () As DataSet Dim ds As New DataSet Dim dt As New DataTable Dim row As DataRow Dim i As Integer
dt.TableName = "TestTable" dt.Columns.Add( "TestColumn 1", GetType(String) ) dt.Columns.Add( "TestColumn 2", GetType(Integer ))
ds.DataSetName = "TestDataSe t" ds.Tables.Add(d t)
For i = 0 To 10 row = dt.NewRow row("TestColumn 1") = "This is row " & i row("TestColumn 2") = i dt.Rows.Add(row )
' The following code trigger the error after the DataSet ' is returned to the calling Window Form application row.SetColumnEr ror("TestColumn 1", "Error message here") Next
Return ds End Function For the Windows Form application, you need to insert a datagrid control (assumed as datagrid1). It will look something like this,
Code:
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load Dim ws As localhost.Servi ce1 Dim ds As DataSet
Try ws = New localhost.Servi ce1 ds = ws.RetrieveData Set
Me.DataGrid1.Se tDataBinding(ds .Tables(0), "") Catch ex As Exception MsgBox(ex.Messa ge) Finally If (Not (ws Is Nothing)) Then ws.Dispose() End If End Try End Sub
I really hope someone could help me out with this one.
Thanks in advance.
ps: Please, before anyone reply to state that I did not choose the appropriate groups when making this post a crossposts post, please know that I'm currently in blind on what is causing this error. Is it the WebService? or is it the ADO .Net? or is it Windows Form application? or is it VB .Net? Well, it has something to do with WebService as it only happens to the DataSet returned by WebService. It also has something to do with ADO
..Net as I'm using DataSet. And it definitely has something to do with Windows
Form application as if I force the Windows Form application project to run on .Net Framework 1.0, everything works fine.
Does this mean I have to pay US99 to get the fix?
"Programati x" <pr*********@no spam.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. .. But... there is no way to download it. Sigh...
"RogerS" <no****@hotmail .com> wrote in message news:uf******** ******@TK2MSFTN GP10.phx.gbl... I guess today I searched on the right keywords - I have looked before
but did not find the following: http://support.microsoft.com/default.aspx?scid=kb;[LN];818587
Knowledge Base Article 818587 Fix: Regression in Dataset Serialization in Visual Studio .NET 1.1 when
a datarow contains a rowError or a ColumnError Property
Roger
"Programati x" <pr*********@no spam.com> wrote in message news:Op******** ******@TK2MSFTN GP12.phx.gbl... Hi,
I'm working on a project which includes XML WebServices and Windows
Form application.
The Windows Form application will call the XML WebServices to retrieve data from database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset returned contain errors (marked by calling the SetColumnError( ) method or setting the RowError property of the DataRow), I get the following
error message in the Windows Form application,
"There is an error in XML doument (x,xxxxxxx)"
If I forced the Windows Form application to run on .NET Framework 1.0, everything works fine.
Here's the partial code for the WebService project
Code:
<WebMethod()> _ Public Function RetrieveDataSet () As DataSet Dim ds As New DataSet Dim dt As New DataTable Dim row As DataRow Dim i As Integer
dt.TableName = "TestTable" dt.Columns.Add( "TestColumn 1", GetType(String) ) dt.Columns.Add( "TestColumn 2", GetType(Integer ))
ds.DataSetName = "TestDataSe t" ds.Tables.Add(d t)
For i = 0 To 10 row = dt.NewRow row("TestColumn 1") = "This is row " & i row("TestColumn 2") = i dt.Rows.Add(row )
' The following code trigger the error after the DataSet ' is returned to the calling Window Form application row.SetColumnEr ror("TestColumn 1", "Error message here") Next
Return ds End Function For the Windows Form application, you need to insert a datagrid
control (assumed as datagrid1). It will look something like this,
Code:
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load Dim ws As localhost.Servi ce1 Dim ds As DataSet
Try ws = New localhost.Servi ce1 ds = ws.RetrieveData Set
Me.DataGrid1.Se tDataBinding(ds .Tables(0), "") Catch ex As Exception MsgBox(ex.Messa ge) Finally If (Not (ws Is Nothing)) Then ws.Dispose() End If End Try End Sub
I really hope someone could help me out with this one.
Thanks in advance.
ps: Please, before anyone reply to state that I did not choose the appropriate groups when making this post a crossposts post, please
know that I'm currently in blind on what is causing this error. Is it the WebService? or is it the ADO .Net? or is it Windows Form application? or is it VB .Net? Well, it has something to do with WebService as it only happens to the DataSet returned by WebService. It also has something to do with ADO .Net as I'm using DataSet. And it definitely has something to do with Windows Form application as if I force the Windows Form application project to run
on .Net Framework 1.0, everything works fine.
> Does this mean I have to pay US99 to get the fix?
(sorry about that last post, I hit the wrong key)
Anyway, hopefully not. From the same page:
"NOTE: In special cases, charges that are ordinarily incurred for
support calls may be canceled if a Microsoft Support Professional
determines that a specific update will resolve your problem. The usual
support costs will apply to additional support questions and issues that
do not qualify for the specific update in question."
It remains to be seen what they consider a "special case".
Unfortunately, it sounds like they still charge you up-front, and then
maybe refund it later...
I live in Malaysia, US99 is about RM396 which is 1/3 of my monthly salary.
Anyway, why should Microsoft do that? It is a fix to their own mistakes
(bugs). Sigh...
"Joe White" <ip***@hotmail. com> wrote in message
news:3F******** ******@hotmail. com... Does this mean I have to pay US99 to get the fix?
(sorry about that last post, I hit the wrong key)
Anyway, hopefully not. From the same page:
"NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question."
It remains to be seen what they consider a "special case". Unfortunately, it sounds like they still charge you up-front, and then maybe refund it later... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Programatix |
last post by:
Hi,
I'm working on a project which includes WebServices and Windows Form
application.
The Windows Form application will call the WebServices to retrieve data from
database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset
returned contain errors (marked by calling the SetColumnError() method or
|
by: Programatix |
last post by:
Hi,
I'm working on a project which includes XML WebServices and Windows Form
application.
The Windows Form application will call the XML WebServices to retrieve data
from database. The data will be returned as DataSet.
Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset
returned contain errors (marked by calling the SetColumnError() method or
|
by: Programatix |
last post by:
Hi,
I'm previously haunted by a bug which is now in Knowledge Base Article
818587 (Fix: Regression in Dataset Serialization in Visual Studio .NET 1.1
when a datarow contains a rowError or a ColumnError Property) which can be
found at http://support.microsoft.com/default.aspx?scid=kb;en-us;818587.
Please note that this bug only shows itself if the Windows Form Application
is run on dotNetFramework 1.1 but does not shows itself if the same...
|
by: Adam Short |
last post by:
I am trying to write a routine that will connect a .NET server with a
classic ASP server.
I know the following code doesn't work! The data is being returned as a
dataset, however ASP does not recognise datasets and requires a recordset.
Can the datatypes be converted? At the Classic ASP end or .NET end? Can
SOAP toolkit provide the conversion, can any toolkit provide a conversion?
...
|
by: Zoury |
last post by:
Hi there! :O)
I have a WebService that contains the following struct definition. this
struct is defined right after the WebService class, ie :
//***
namespace mynamespace
{
public class MyWebService : WebService {// code here..}
public struct Record
{
| |
by: yma |
last post by:
Hi,
I tried to use a listbox to display a column in MS Access 2000 nwind.mdb by
using ole DataAdapter, Connection and dataset controls. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." I put ole DataAdapter, Connection and dataset controls and fill
in the properties of the listbox. The only code I have is
OleDbDataAdapter1.Fill(DataSet11, "employees") in page_load sub. How can I...
|
by: Richard |
last post by:
I have a webservice which returns a dataset from an SQL database to winforms
client.
All has been working fine for some time now but since my datasets have
increased to over 1800 records an error is now thrown on the client side
stating the "the root element is missing" when returning tables of this
size. I can test the ASMX file using a web browser and the whole dataset is
displayed in XML there in the browser, but when it is called as...
|
by: Bob Davies |
last post by:
Hi
I have a webservice that retrieves data from a database, this is then
returned to the calling client application built in windows forms within a
dataset, however upon attempting to create tablestyles to format any of the
columns within the datagrid, the exception "Can-not parent objects created
on one thread to objects created on another" or words to that effect.
I'm not too sure if what I said make sense, but i will add details to...
|
by: Siegfried Glaser |
last post by:
Hello everybody!
I recently wrote a VB.Net webservice that retrieves some survey data from an
oracle server and returns it as a strongly typed dataset. For some weeks
everything worked fine but all of a sudden my customer claimed that my
application ceased working after he had added some new survey data to the
oracle database.
I asked him to test the webservice with his browser and we found out that
some of the data was replaced by...
|
by: Edward Diener |
last post by:
After spending more than a day reducing a complicated compiler bug to a
simple case I reported it to the MSDN Product Feedback Center as a bug
just now. However this bug is completely stymying my development of a
VC++ component. Does Microsoft still offer any free bug reporting cases
for VS2005, as they did two for VS2003 so that I can talk with a
technical representative directly to try to find a workaround for the
compiler bug ?
While...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |