1,.net 将字典数据转换成xml 字符串
- Dictionary<string,DateTime> dicUserLocked = new Dictionary<string,DateTime>();
- if (!dicUserLocked.ContainsKey(model.UserName))
- {
- dicUserLocked.Add(model.UserName,System.DateTime.Now);
- }
- // ....
- dicLockedUsers.ToXml<string,System.DateTime>().ToString()
2,传参至存储过程后如何取值
var tmpList =
this.GeneratesqlSpParameter(column_LockedUsers,(dicLockedUsers == null) ? null : dicLockedUsers.ToXml<string,System.DateTime>().ToString());
tmpList.sqlDbType = System.Data.sqlDbType.Xml;
parameters.Add(tmpList);
- declare @X xml
- set @X=convert(xml,N'<Dictionary><Item><Key><string>jones.zhang</string></Key><Value><dateTime>2015-04-16T10:24:36.4149457+08:00</dateTime></Value></Item></Dictionary>')
- SELECT @X
- declare @XmlHandle int
- EXEC sp_xml_preparedocument @XmlHandle OUTPUT,@x;
- select * from OPENXML (@XmlHandle,'/Dictionary/Item',2)
- WITH (
- [A] [varchar](200) 'Key/string',[B] [DateTime] 'Value/dateTime'
- );
- EXEC sp_xml_removedocument @XmlHandle;
截图: