Save DataSet as XML files XML and .NET is fully integrated, a lot of .NET's server control has one or more capabilities of creating XML files, and the DataSet class contains several ways to create XML files, here In the article, we will create an example of the connection between DataSet and XML, and this example is to read the data from the database to the DataSet object, and then output from the DataSet object to the XML file to the disk, of course We can also create a Schema file related to it for an XML file.
Save DataSet as the ASP.NET page file (.aspx) in the XML file, simple or even ridiculous, essentially, it does not contain a critical code, we need to do a prompt Information - "Complete", and the code that actually reflects the function is in the back code file of Code-Behind, below is the ASP.NET web page (.aspx): <% @ page language = "VB" src = "DataseTtoxml .aspx.vb "inherits =" DataSetToxml "%>
DataSetToxml </ title> <meta name = "GENERATOR" content = "Microsoft Visual Studio.NET 7.0"> <meta name = "CODE_LANGUAGE" content = "Visual Basic 7.0"> <meta name = vs_defaultClientScript content = "JavaScript"> <meta name = vs_targetSchema content = "http : //schemas.microsoft.com/intellisense/ie5 "> </ head> <body ms_positioning =" gridLayout "> <form id =" form1 "method =" post "runat =" server "> </ form> <h3 > DONE! </ H3> </ body> </ html> In fact, code-behind is not very complicated, most of its code is very familiar, such as using the DataAdapter object to populate DataSet objects In order to make XML do not change very much, we put the SQL SQL SQL of the data from NorthWind data, add TOP 10, the real-effect code is only two lines, one line is used to output the DataSet to XML Document, another line creates its schema file, in the article I mark it in red, in this example, we use two methods of the DataSet class: WriteXML and WriteXmlschema, while server.mappath is used to put two files Write the root in the web application Directory, the file will be two are called "Customers.xml" and "Custmers.xsd", the following code: Imports SystemImports System.DataImports System.Data.SqlClientImports System.ConfigurationPublic Class DataSetToXML: Inherits System.Web.UI.Page</p>
<p>Private Sub Page_Load (ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim objConn As SqlConnection Dim strSql As StringstrSql = "SELECT TOP 10 * FROM Customers" objConn = New SqlConnection (ConfigurationSettings.AppSettings ( "ConnectionString "))</p>
<p>DIM SDACUS NEW SQLDATAADAPTER (STRSQL, OBJCONN) DIM DSTCUST AS New DataSet ()</p>
<p>sdaCust.Fill (dstCust, "Customers") 'Save data to xml file and schema file dstCust.WriteXML (Server.MapPath ( "Customers.xml"), XmlWriteMode.IgnoreSchema) dstCust.WriteXMLSchema (Server.MapPath ( "Customers.xsd ")) End Sub</p>
<p>End class, I apologize to this, but in fact, I really should feel sorry that it should be Microsoft .NET, which allows us to convert data from the data table to XML files. So simple, I hope you can believe this! Description: You can download the full code of this following links: http://www.dotnetjohn.com/downloads.aspx?dlid=34</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-22895.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="22895" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.043</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = '4_2F8Xp6arKMetPI27e1_2F_2F_2FFUqXkv9vSqfc4siHBSA3zFG_2BNwipZjxrZc3xILB4OnFEK3JfYVAcunS_2FjKMQPCYog_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
