/* * structural elements */ .KBPUBV2 { margin: 0px 4px 4px 8px; display:inline-block; FONT-FAMILY: verdana, arial, helvetica, sans-serif; FONT-SIZE: 100%; }
.kbRightCol, .kbRightNav { width:165px; float:right; position:static; padding: 0px 8px 0px 16px; margin: 8px 8px 0px 12px; font-size:100%; }
.kbRightCol A, .kbRightNav A { font-weight: normal; }
.kbRightCol A:visited, .kbRightNav A:visited { color: Purple; }
.KBTT .dec, .KBPUBV2 .dec { list-style-type: decimal; }
.KBTT .alpha, .KBPUBV2 .alpha { list-style-type: lower-alpha; }
.KBTT UL, .KBPUBV2 UL { list-style-type:disc }
.KBTT LI, .KBPUBV2 LI { margin-left: -0.5em; }
.KBTT OL LI, .KBPUBV2 OL LI { line-height: 120%; margin-bottom: 1px; margin-left: -0.2em; }
.KBTT UL LI, .KBPUBV2 UL LI { line-height: 120%; margin-bottom: 1px; margin-left: -0.5em; }
.KBTT UL UL, .KBPUBV2 UL UL { font-size: 100%; list-style-type:square; }
.KBTT UL UL LI, .KBPUBV2 UL UL LI { font-size: 100%; }
.KBTT UL UL UL, .KBPUBV2 UL UL UL { font-size: 100%; list-style-type:circle; }
.KBTT UL UL UL UL, .KBPUBV2 UL UL UL UL { font-size: 100%; list-style-type:square; }
.appliesto {font-weight:bold; width: 99%; border-top: solid 1px #cccccc; padding-top: 1em; margin-top: 2em; }
.appliesto H3 { font-family:Verdana, Helvetica; font-size:110%; }
.appliesto UL { font-weight:normal; margin-top: 0.5em;}
.appliesto UL UL { font-size: 100%; margin-top: 0em; margin-bottom: 0.5em; }
.appliesto UL LI { margin-top: 0em; margin-bottom: 0em; }
.notice { margin-bottom: 0em; margin-top: 1.4em; padding-top: 4px; font-size: inherit; }
.KBTT .indent, .KBPUBV2 .indent { margin-top: 1em; margin-bottom: 1em; margin-left: 2em; }
.copyright {}
.disclaimer { padding:5px 20px 5px 10px; }
.TableData TABLE { margin-top: 1em; margin-bottom: 1em; width: 95%; }
.TableData TH { background-color: #cccccc; text-align: center; padding: 4px; border: white 1px solid; font-size: 100%; }
.TableData TR { }
.TableData TD { background-color: #f4f4fC; padding: 4px; border: white 1px solid; font-size: 100%; }
.TABLE.docinfo { WIDTH: 95%; border: none; }
.TABLE.docinfo TD { BORDER: none; }
.docinfo { margin-top: 12px; }
.docinfo TD.data { font-size: 100%; background-color: #f4f4fC; }
.docinfo TD.label { background-color: #cccccc; font-weight: bold; font-size: 100%; }
.KBPUBV2 IMG.graphic { border-style:none; border-width:0 }
.KBPUBV2 .E { margin-top: 0.5em; margin-bottom: 0.3em; display:block; }
.KBPUBV2 KBD { font-weight: bold; }
/* USERINPUT */ .KBPUBV2 .weboutput { }
.KBPUBV2 .weboutput table object { position: static; }
.KBPUBV2 .URLLink:hover, .KBPUBV2 .kblink:hover, .KBPUBV2 .UNCLink:hover { CURSOR: hand; COLOR: #ff9900 }
.KBPUBV2 .URLLink:link, .KBPUBV2 .kblink:link, .KBPUBV2 .UNCLink:link {COLOR: #0000ff}
.KBPUBV2 .URLLink:visited, .KBPUBV2 .kblink:visited, .KBPUBV2 .UNCLink:visited {COLOR: #800080}
.KBPUBV2 .URLLink:active, .KBPUBV2 .kblink:active, .KBPUBV2 .UNCLink:active {COLOR: red}
.errormsg { margin-top: 12px; margin-bottom: 12px; margin-left: 24px; COLOR: red; display:block; font-weight: normal; }
.message { margin-top: 12px; margin-bottom: 12px; margin-left: 24px; }
PRE { PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; PADDING-TOP: 0.5em; PADDING-BOTTOM: 0.5em; MARGIN-LEFT: 24px; MARGIN-TOP: 1em; MARGIN-BOTTOM: 1em; COLOR: black; BACKGROUND-COLOR: #eeeeee; width: 100%; FONT-FAMILY: "Courier New", courier, monospace; }
PRE.in_text { COLOR: black; FONT-FAMILY: "Courier New", courier, monospace; }
H1 { FONT-WEIGHT: bold; FONT-SIZE: 170%; MARGIN-TOP: 6px; MARGIN-LEFT: 0px; TEXT-DECORATION: none }
H3 { FONT-WEIGHT: bold; FONT-SIZE: 105%; margin-bottom: 12px; MARGIN-LEFT: 0px; TEXT-DECORATION: none;}
H4 { FONT-WEIGHT: bold; FONT-SIZE: 100%; MARGIN-LEFT: 0px; TEXT-DECORATION: none }
H5 { FONT-WEIGHT: bold; FONT-SIZE: 95%; MARGIN-LEFT: 0px; TEXT-DECORATION: none }
H2 { font-variant: small-caps; FONT-WEIGHT: bold; FONT-SIZE: 110%; font-family: Verdana, Helvetica; COLOR: #CC6600; margin: 8px 12px 6px -12px; padding-top: 8px; }
.disclaimer { font-size: 95%; font-weight: 100; }
.NOTICE {padding-left: 12px; padding-right: 24px; }
.SUMMARY {padding-left: 12px; padding-right: 24px; }
.MOREINFORMATION {padding-left: 12px; padding-right: 24px; }
.SYMPTOMS {padding-left: 12px; padding-right: 24px; }
.CAUSE {padding-left: 12px; padding-right: 24px; }
.RESOLUTION {padding-left: 12px; padding-right: 24px; }
.STATUS {padding-left: 12px; padding-right: 24px; }
.WORKAROUND {padding-left: 12px; padding-right: 24px; }
.REFERENCES {padding-left: 12px; padding-right: 24px; }
.CAUSE {padding-left: 12px; padding-right: 24px; }
.WHATTOTRY {padding-left: 12px; padding-right: 24px; }
.ERRORMESSAGE {padding-left: 12px; padding-right: 24px; }
.internal .head { font-weight:bold; text-align: center; background-color: white; color: red; border-top-style: solid }
p.internal { margin-left: 5%; margin-right: 5% }
.internal .tail { background-color: white; color: red; border-bottom-style: solid }
.partner .head { font-weight:bold; text-align: center; background-color: white; color: #FFAA00; border-top-style: solid }
p.partner { margin-left: 5%; margin-right: 5% }
.partner .tail { background-color: white; color: #FFAA00; border-bottom-style: solid }
/*** For KB-Subtypes ***/ .KBSC, .KBQA, .KBTT, .KBSI { display:inline-block; margin: 0px 8px 4px 6px; FONT-FAMILY: verdana, arial, helvetica, sans-serif; }
.KBSI { margin: 0px 0px 4px 0px; }
.SectionImage { width:110px; float:right; position:static; padding-left:8px; margin: 4px 10px 8px 4px; }
.dropCap { font-size: x-large; }
.qaText { padding-top: 9px; }
.blurb { padding: 0px 10px 10px 5px; }
.g_graphic { border-left: solid 1px #999999; padding: 0px 4px 0px 4px; }
.b_graphic { border-right: solid 1px #999999; padding: 0px 4px 0px 4px; }
.kbRightCol { float:none; }
.KBSI H1 { margin-left : 10px }
.KBSI H2 { font-variant: small-caps; FONT-WEIGHT: bold; FONT-SIZE: 110%; font-family: Verdana, Helvetica; COLOR: #CC6600; margin: 10px 2px 6px 0px; padding-top: 4px; }
.kbQA .Summary {padding-left: 12px; padding-right: 24px; margin-top:0px; border-top: solid 1px #999999;}
/************/
第一次翻译文档，如有问题敬请原谅并指教！
This article was previously published under Q306134
问题在Visual Studio .Net集成开发环境中试图添加到这个XML Web Service的引用时，也会看到下面类似的错误信息：
System.Data.DataRelation cannot be serialized because it does not have a default public constructor.
在Visual Studio .Net集成开发环境中试图添加到这个XML Web Service的引用时，也会看到下面类似的错误信息：
Internal Server Error. Unable to request "http://localhost/Webservice1/Service1.asmx?WSDL". The server responded with error code "ProtocolError".
原因DataTable、 DataRow、 DataView以及 DataViewManager 等对象不能被序列化也不能被从一个XML XML Web service返回。要返回，至少必须是一个完整的 DataSet ，因此必须把要返回的数据复制到一个 DataSet中。
解决解决这个问题的方法是：返回一个 DataSet 以替代 DataTable。一个 DataSet 对象中可以包含一个或多个 DataTable对象。
状态本行为正在设计中。
更多信息
操作步骤
说明：以下示例包含VB.NET、C#和J#。
在一个已存在的XML Web Service中添加一个返回DataTable对象的Web Service方法。以下代码创建一个连接到Microsoft SQL Server数据库和Authors表。如果你想使用本代码，请修改并连接到你的安装有SQL Server的计算机上。 'Visual Basic
<WebMethod()> Function GiveMeADataTable() As System.Data.DataTable
Dim conn As New System.Data.SqlClient.SqlConnection("Server=YourServer;Initial Catalog=pubs;Integrated Security=SSPI;")
Dim ds As New System.Data.DataSet()
Dim adapter As New System.Data.SqlClient.SqlDataAdapter()
adapter.SelectCommand = New System.Data.SqlClient.SqlCommand("Select * From Authors", conn)
adapter.Fill(ds, "Authors")
Return ds.Tables("Authors")
End Function
//Visual C#
[WebMethod]
public System.Data.DataTable GiveMeADataTable()
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Server=YourServer;Initial Catalog=pubs;Integrated Security=SSPI;");
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new System.Data.SqlClient.SqlCommand("Select * From Authors", conn);
adapter.Fill(ds, "Authors");
return ds.Tables["Authors"];
}
/**Visual J# */
/** @attribute WebMethod() */
public System.Data.DataTable GiveMeADataTable()
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Server=YourServer;Initial Catalog=pubs;Integrated Security=SSPI;");
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.set_SelectCommand(new System.Data.SqlClient.SqlCommand("Select * From Authors", conn));
adapter.Fill(ds, "Authors");
System.Data.DataTableCollection dtc = ds.get_Tables();
return dtc.get_Item("Authors");
}
编译这个XML Web service.。
浏览你添加了上面的方法的XML Web Service的URL，你将收到错误信息。
修改为如下的代码，使用 DataSet 对象替换 DataTable对象：'Visual Basic
<WebMethod()> Function GiveMeADataSet() As System.Data.DataSet
Dim conn As New System.Data.SqlClient.SqlConnection("Server=YourServer;Initial Catalog=pubs;Integrated Security=SSPI;")
Dim ds As New System.Data.DataSet()
Dim adapter As New System.Data.SqlClient.SqlDataAdapter()
adapter.SelectCommand = New System.Data.SqlClient.SqlCommand("Select * From Authors", conn)
adapter.Fill(ds, "Authors")
Return ds
End Function
//Visual C#
[WebMethod]
public System.Data.DataSet GiveMeADataSet()
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Server=YourServer;Initial Catalog=pubs;Integrated Security=SSPI;");
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new System.Data.SqlClient.SqlCommand("Select * From Authors", conn);
adapter.Fill(ds, "Authors");
return ds;
}
/**Visual J# */
/** @attribute WebMethod() */
public System.Data.DataSet GiveMeADataSet()
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Server=YourServer;Initial Catalog=pubs;Integrated Security=SSPI;");
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.set_SelectCommand(new System.Data.SqlClient.SqlCommand("Select * From Authors", conn));
adapter.Fill(ds, "Authors");
return ds;
}
编译这个XML Web Service。
再浏览这个XML Web Service方法的URL连接，将不会看到上面的错误提示。
本文档信息应用于：
Microsoft Web Services (包括.NET Framework) 1.0
Microsoft Web Services (包括.NET Framework 1.1)
Microsoft Visual Basic .NET (2002)
Microsoft Visual C# .NET (2002)
Microsoft ASP.NET (包括.NET Framework) 1.0
Microsoft Visual J# .NET (2002)
Microsoft Visual J# .NET (2003)
Microsoft Visual C# .NET (2003)
Microsoft Visual Basic .NET (2003)
Microsoft ASP.NET (包括.NET Framework 1.1)
