All pastes #268117 Raw Edit

Nagappan

public text v1 · immutable
·published 2006-12-05 10:14 UTC
rendered paste body
		public void ColumnOrder ()

		{

			string xml = "<?xml version=\"1.0\" standalone=\"yes\"?>" +

				"<NewDataSet>" +

				"  <Table>" +

				"    <Name>Miguel</Name>" +

				"    <FirstName>de Icaza</FirstName>" +

				"    <Income>4000</Income>" +

				"  </Table>" +

				"  <Table>" +

				"    <Name>25</Name>" +

				"    <FirstName>250</FirstName>" +

				"    <Address>Belgium</Address>" +

				"    <Income>5000</Income>" +

				"</Table>" +

				"</NewDataSet>";



			DataSet ds = new DataSet ();

			ds.ReadXml (new StringReader (xml));

			AssertEquals ("#1", 1, ds.Tables.Count);

			AssertEquals ("#2", "Table", ds.Tables [0].TableName);

			AssertEquals ("#3", 4, ds.Tables [0].Columns.Count);

			AssertEquals ("#4a", "Name", ds.Tables [0].Columns [0].ColumnName);

			AssertEquals ("#4b", 0, ds.Tables [0].Columns [0].Ordinal);

			AssertEquals ("#5a", "FirstName", ds.Tables [0].Columns [1].ColumnName);

			AssertEquals ("#5b", 1, ds.Tables [0].Columns [1].Ordinal);

#if NET_2_0

			AssertEquals ("#6a", "Address", ds.Tables [0].Columns [2].ColumnName);

			AssertEquals ("#6b", 2, ds.Tables [0].Columns [2].Ordinal);

			AssertEquals ("#7a", "Income", ds.Tables [0].Columns [3].ColumnName);

			AssertEquals ("#7b", 3, ds.Tables [0].Columns [3].Ordinal);

#else

			AssertEquals ("#6a", "Income", ds.Tables [0].Columns [2].ColumnName);

			AssertEquals ("#6b", 2, ds.Tables [0].Columns [2].Ordinal);

			AssertEquals ("#7a", "Address", ds.Tables [0].Columns [3].ColumnName);

			AssertEquals ("#7b", 3, ds.Tables [0].Columns [3].Ordinal);

#endif

		}



		[Test] // bug #80048

		public void XmlSpace ()

		{

			string xml = "<?xml version=\"1.0\" standalone=\"yes\"?>" +

				"<NewDataSet>" +

				"  <Table>" +

				"    <Name>Miguel</Name>" +

				"    <FirstName xml:space=\"preserve\"> de Icaza</FirstName>" +

				"    <Income>4000</Income>" +

				"  </Table>" +

				"  <Table>" +

				"    <Name>Chris</Name>" +

				"    <FirstName xml:space=\"preserve\">Toshok </FirstName>" +

				"    <Income>3000</Income>" +

				"  </Table>" +

				"</NewDataSet>";



			DataSet ds = new DataSet ();

			ds.ReadXml (new StringReader (xml));

#if NET_2_0

			AssertEquals ("#1", 1, ds.Tables.Count);

			AssertEquals ("#2", "Table", ds.Tables [0].TableName);

			AssertEquals ("#3", 3, ds.Tables [0].Columns.Count);

			AssertEquals ("#4a", "Name", ds.Tables [0].Columns [0].ColumnName);

			AssertEquals ("#4b", 0, ds.Tables [0].Columns [0].Ordinal);

			AssertEquals ("#5a", "FirstName", ds.Tables [0].Columns [1].ColumnName);

			AssertEquals ("#5b", 1, ds.Tables [0].Columns [1].Ordinal);

			AssertEquals ("#6a", "Income", ds.Tables [0].Columns [2].ColumnName);

			AssertEquals ("#6b", 2, ds.Tables [0].Columns [2].Ordinal);

#else

			AssertEquals ("#1", 2, ds.Tables.Count);

			AssertEquals ("#2", "Table", ds.Tables [0].TableName);

			AssertEquals ("#3", 3, ds.Tables [0].Columns.Count);

			AssertEquals ("#4a", "Name", ds.Tables [0].Columns [0].ColumnName);

			AssertEquals ("#4b", 0, ds.Tables [0].Columns [0].Ordinal);

			AssertEquals ("#5a", "Table_Id", ds.Tables [0].Columns [1].ColumnName);

			AssertEquals ("#5b", 1, ds.Tables [0].Columns [1].Ordinal);

			AssertEquals ("#6a", "Income", ds.Tables [0].Columns [2].ColumnName);

			AssertEquals ("#6b", 2, ds.Tables [0].Columns [2].Ordinal);

			AssertEquals ("#7", "FirstName", ds.Tables [1].TableName);

			AssertEquals ("#8", 3, ds.Tables [1].Columns.Count);

			AssertEquals ("#9a", "space", ds.Tables [1].Columns [0].ColumnName);

			AssertEquals ("#9b", 0, ds.Tables [1].Columns [0].Ordinal);

			AssertEquals ("#10a", "FirstName_Text", ds.Tables [1].Columns [1].ColumnName);

			AssertEquals ("#10b", 1, ds.Tables [1].Columns [1].Ordinal);

			AssertEquals ("#11a", "Table_Id", ds.Tables [1].Columns [2].ColumnName);

			AssertEquals ("#11b", 2, ds.Tables [1].Columns [2].Ordinal);

#endif

		}