怎么实现购物车序列化
发布网友
发布时间：2022-04-11 19:25
共3个回答
热心网友
时间：2022-04-11 20:54
给你思路, 需要自己改改...图片是该代码基本样式.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Xml;
namespace BaiZhi
{
public partial class Form1 : ComponentFactory.Krypton.Toolkit.KryptonForm
{
public Form1()
{
InitializeComponent();
}
//添加数据到XML文件中
private void btnAddXml_Click(object sender, EventArgs e)
{
//初始化XML文档操作类
XmlDocument myDoc = new XmlDocument();
//如果test.xml文件不存在, 则创建.
if (!File.Exists(@"C:\test.xml"))
{
//声明XML
XmlDeclaration xmldec = myDoc.CreateXmlDeclaration("1.0", "gb2312", null);
myDoc.AppendChild(xmldec);
//创建元素
XmlElement xmlelem = myDoc.CreateElement("Info");
myDoc.AppendChild(xmlelem);
//保存
myDoc.Save(@"C:\test.xml");
}
//加载XML文件
myDoc.Load(@"C:\test.xml");
//创建一个元素
XmlElement xmle = myDoc.CreateElement("UserInfo");
//添加自定义属性
xmle.SetAttribute("UserName", "" + txtNameXml.Text + "");
xmle.SetAttribute("UserAmount", "" + txtAmountXml.Text + "");
xmle.SetAttribute("UserPhone", "" + txtPhoneXml.Text + "");
xmle.SetAttribute("UserAddress", "" + txtAddressXml.Text + "");
//将节属性到文档中
XmlElement AllExlement = myDoc.DocumentElement;
AllExlement.AppendChild(xmle);
//保存
myDoc.Save(@"C:\test.xml");
}
//添加XML文件里的数据到SQL
private void btnAddSql_Click(object sender, EventArgs e)
{
//初始化XML文档操作类
XmlDocument myDoc = new XmlDocument();
//加载文件
myDoc.Load(@"C:\test.xml");
//搜索起始元素
XmlNode xmlnode = myDoc.SelectSingleNode("Info");
//定义数组获取所有子节点
XmlNodeList xmllist = xmlnode.ChildNodes;
//遍历属性值，并调用getcom方法将数据插入sqltable表中
foreach (XmlNode xmlno in xmllist)
{
XmlElement ex = (XmlElement)xmlno;
getcom("insert into sqltable('username','useramount','userphone','useraddress') "
+ "values ('" + ex.GetAttribute("UserName") + "', '"
+ ex.GetAttribute("UserAmount") + "', '"
+ ex.GetAttribute("UserPhone") + "', '"
+ ex.GetAttribute("UserAddress") + "')");
}
}
//读取SQL中数据显示到DGridViewXml控件中
private void btnReadSql_Click(object sender, EventArgs e)
{
DataSet myds = getds("select * from sqltable", "sqltable");
if (myds.Tables.Count > 0)
DGridViewXml.DataSource = myds.Tables[0];
}
//连接SQL字符串
string sqlcon = "Data Source=localhost;Database=Test;Integrated Security=SSPI";
//执行SQL命令
public void getcom(string sqlstr)
{
//建立SQL连接
SqlConnection myCon = new SqlConnection(sqlcon);
myCon.Open();
//执行SQL语句
SqlCommand sqlcom = new SqlCommand(sqlstr, myCon);
sqlcom.ExecuteNonQuery();
sqlcom.Dispose();
myCon.Close();
myCon.Dispose();
}
//读取SQL数据
public DataSet getds(string sqlstr, string sqltable)
{
SqlConnection myCon = new SqlConnection(sqlcon);
SqlDataAdapter sqlda = new SqlDataAdapter(sqlstr, myCon);
DataSet myds = new DataSet();
sqlda.Fill(myds, sqltable);
return myds;
}
}
}
热心网友
时间：2022-04-11 22:12
