English 中文(简体)
数据错误 “可用数量 使用XmlRead()
原标题:Dataset error "Table doesn t have a primary key." when using XmlRead()

我犯了错误,“表态t有初级钥匙”。 因此,我是如何确定主要钥匙的,当我叫“阅读Xml()”时,我是否没有这样做?

MemoryStream msXml = new MemoryStream(byteArray);
DataSet dsXml = new DataSet();
dsXml.ReadXml(msXml);
string s = "123456789";
DataRow foundRow = dsXml.Tables["Accounts"].Rows.Find(s);

<><> >>>>

http://www.w3schools.com/xml/cd_catalog.xml”rel=“nofollow noreferer”>example 。 我如何为每个裁谈会确定主要的关键?

增 编

最佳回答

感谢大家的帮助,我设法避免了。 如果我帮助别人的话,下面的例子对我工作。

DataSet dsXml = new DataSet();
dsXml.ReadXml(msXml);
DataTable tbl;
tbl = dsXml.Tables["Accounts"];
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["Id"] };

问题回答

你们正在把XML数据读到你的数据集中,但不是Schema,而Schema是确定一支PK的。

当你使用需要Pk但并未界定的“Fk”方法时,就会出现错误。

两者在装满数据或节省/装载xml和chem后都用人工确定。





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签