[Mono-list] Problem with asp.net OdbcDataAdapter or DataSet.

[beniniva@csr.unibo.it]

This message is in MIME format.

---MOQ10933381115dc15107ceea34833fb4879d3445aa62
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Hi,

I've an asp.net web application that shows, through an odbc connection to a
mysql database, the content of the table chosen from a DropDownList.
The code go well on windows but on linux with mono 1.01 not all the tables are
shown correctly.

I've also tried to run a c# example that makes the same thing and it works
well....so I think that is not a problem of mysql or odbc connection, but
rather it may be a problem of odbcDataAdapter or Data set....

Is it true?
Could anybody help me?

asp.net web application: WebForm1VisuaTabelle.aspx,
WebForm1VisuaTabelle.aspx.cs
c# example: ProvaVisuaTabella.cs

Thanks a lot,

Valentina.

---MOQ10933381115dc15107ceea34833fb4879d3445aa62
Content-Type: application/octet-stream; name="WebForm1VisuaTabelle.aspx"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="WebForm1VisuaTabelle.aspx"

PCVAIFBhZ2UgbGFuZ3VhZ2U9ImMjIiBDb2RlYmVoaW5kPSJXZWJGb3JtMS5hc3B4LmNzIiBBdXRv
RXZlbnRXaXJldXA9ImZhbHNlIiBJbmhlcml0cz0iVmlzdWFUYWJlbGxlLldlYkZvcm0xIiAlPg0K
PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv
L0VOIiA+DQo8IURPQ1RZUEUgSFRNTCBQVUJMSUMgIi0vL1czQy8vRFREIEhUTUwgNC4wIFRyYW5z
aXRpb25hbC8vRU4iID4NCjxIVE1MPg0KCTxIRUFEPg0KCQk8dGl0bGU+VmlzdWFsaXp6YVRhYmVs
bGU8L3RpdGxlPg0KCQk8bWV0YSBuYW1lPSJHRU5FUkFUT1IiIENvbnRlbnQ9Ik1pY3Jvc29mdCBW
aXN1YWwgU3R1ZGlvIC5ORVQgNy4xIj4NCgkJPG1ldGEgbmFtZT0iQ09ERV9MQU5HVUFHRSIgQ29u
dGVudD0iQyMiPg0KCQk8bWV0YSBuYW1lPSJ2c19kZWZhdWx0Q2xpZW50U2NyaXB0IiBjb250ZW50
PSJKYXZhU2NyaXB0Ij4NCgkJPG1ldGEgbmFtZT0idnNfdGFyZ2V0U2NoZW1hIiBjb250ZW50PSJo
dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2ludGVsbGlzZW5zZS9pZTUiPg0KCTwvSEVBRD4N
Cgk8Ym9keSBNU19QT1NJVElPTklORz0iR3JpZExheW91dCIgYmdDb2xvcj0iI2ZmZmZmZiI+DQoJ
CTxmb3JtIGlkPSJGb3JtMSIgbWV0aG9kPSJwb3N0IiBydW5hdD0ic2VydmVyIj4NCgkJCTxhc3A6
QnV0dG9uIGlkPSJCdXR0b25SaWNlcmNhIiBzdHlsZT0iWi1JTkRFWDogMTAwOyBMRUZUOiA0MTZw
eDsgUE9TSVRJT046IGFic29sdXRlOyBUT1A6IDY0cHgiDQoJCQkJcnVuYXQ9InNlcnZlciIgVGV4
dD0iQXZ2aWEgUmljZXJjYSIgQmFja0NvbG9yPSJEYXJrU2VhR3JlZW4iIEZvcmVDb2xvcj0iQmxh
Y2siPjwvYXNwOkJ1dHRvbj4NCgkJCTxhc3A6RGF0YUdyaWQgaWQ9IkRhdGFHcmlkMSIgc3R5bGU9
IlotSU5ERVg6IDEwMTsgTEVGVDogMjRweDsgUE9TSVRJT046IGFic29sdXRlOyBUT1A6IDE2OHB4
Ig0KCQkJCXJ1bmF0PSJzZXJ2ZXIiIEZvcmVDb2xvcj0iVHJhbnNwYXJlbnQiIEJhY2tDb2xvcj0i
I0MwRkZDMCIgQm9yZGVyQ29sb3I9IkJsYWNrIj4NCgkJCQk8SXRlbVN0eWxlIEZvcmVDb2xvcj0i
VHJhbnNwYXJlbnQiIEJvcmRlckNvbG9yPSJUcmFuc3BhcmVudCI+PC9JdGVtU3R5bGU+DQoJCQkJ
PEhlYWRlclN0eWxlIEZvbnQtTmFtZXM9IkFyaWFsIiBGb250LUJvbGQ9IlRydWUiIEZvcmVDb2xv
cj0iR3JlZW4iIEJvcmRlckNvbG9yPSJUcmFuc3BhcmVudCINCgkJCQkJQmFja0NvbG9yPSJIb25l
eWRldyI+PC9IZWFkZXJTdHlsZT4NCgkJCTwvYXNwOkRhdGFHcmlkPg0KCQkJPGFzcDpMYWJlbCBp
ZD0iTGFiZWwxIiBzdHlsZT0iWi1JTkRFWDogMTAyOyBMRUZUOiAxNnB4OyBQT1NJVElPTjogYWJz
b2x1dGU7IFRPUDogNjRweCIgcnVuYXQ9InNlcnZlciINCgkJCQlGb3JlQ29sb3I9IkdyZWVuIiBG
b250LUJvbGQ9IlRydWUiPkluc2VyaXJlIGxhIHRhYmVsbGEgZGEgdmlzdWFsaXp6YXJlOiA8L2Fz
cDpMYWJlbD4NCgkJCTxhc3A6TGFiZWwgaWQ9IkxhYmVsMiIgc3R5bGU9IlotSU5ERVg6IDEwMzsg
TEVGVDogMjRweDsgUE9TSVRJT046IGFic29sdXRlOyBUT1A6IDEzNnB4IiBydW5hdD0ic2VydmVy
Ig0KCQkJCUZvcmVDb2xvcj0iR3JlZW4iIEZvbnQtQm9sZD0iVHJ1ZSIgRm9udC1TaXplPSJNZWRp
dW0iPjwvYXNwOkxhYmVsPg0KCQkJPGFzcDpEcm9wRG93bkxpc3QgaWQ9IkRyb3BEb3duTGlzdDEi
IHN0eWxlPSJaLUlOREVYOiAxMDQ7IExFRlQ6IDI0OHB4OyBQT1NJVElPTjogYWJzb2x1dGU7IFRP
UDogNjRweCINCgkJCQlydW5hdD0ic2VydmVyIiBXaWR0aD0iMTUycHgiPg0KCQkJCTxhc3A6TGlz
dEl0ZW0gVmFsdWU9InNlc3Npb25lIiBTZWxlY3RlZD0iVHJ1ZSI+PC9hc3A6TGlzdEl0ZW0+DQoJ
CQkJPGFzcDpMaXN0SXRlbSBWYWx1ZT0icHJvYmxlbWkiIFNlbGVjdGVkPSJGYWxzZSI+PC9hc3A6
TGlzdEl0ZW0+DQoJCQkJPGFzcDpMaXN0SXRlbSBWYWx1ZT0ib3JkaW5pIiBTZWxlY3RlZD0iRmFs
c2UiPjwvYXNwOkxpc3RJdGVtPg0KCQkJCTxhc3A6TGlzdEl0ZW0gVmFsdWU9InZpYWdnaSIgU2Vs
ZWN0ZWQ9IkZhbHNlIj48L2FzcDpMaXN0SXRlbT4NCgkJCQk8YXNwOkxpc3RJdGVtIFZhbHVlPSJz
ZXF1ZW56ZSIgU2VsZWN0ZWQ9IkZhbHNlIj48L2FzcDpMaXN0SXRlbT4NCgkJCQk8YXNwOkxpc3RJ
dGVtIFZhbHVlPSJ2ZWljb2xpIiBTZWxlY3RlZD0iRmFsc2UiPjwvYXNwOkxpc3RJdGVtPg0KCQkJ
CTxhc3A6TGlzdEl0ZW0gVmFsdWU9ImdydXBwaSIgU2VsZWN0ZWQ9IkZhbHNlIj48L2FzcDpMaXN0
SXRlbT4NCgkJCQk8YXNwOkxpc3RJdGVtIFZhbHVlPSJ1dGVudGkiIFNlbGVjdGVkPSJGYWxzZSI+
PC9hc3A6TGlzdEl0ZW0+DQoJCQk8L2FzcDpEcm9wRG93bkxpc3Q+DQoJCQk8YXNwOkJ1dHRvbiBp
ZD0iQnV0dG9uMSIgc3R5bGU9IlotSU5ERVg6IDEwNjsgTEVGVDogNTQ0cHg7IFBPU0lUSU9OOiBh
YnNvbHV0ZTsgVE9QOiA2NHB4IiBydW5hdD0ic2VydmVyIg0KCQkJCUJhY2tDb2xvcj0iQmVpZ2Ui
IFRleHQ9IkluZGlldHJvIj48L2FzcDpCdXR0b24+DQoJCTwvZm9ybT4NCgk8L2JvZHk+DQo8L0hU
TUw+DQo=

---MOQ10933381115dc15107ceea34833fb4879d3445aa62
Content-Type: text/x-csharp; name="WebForm1VisuaTabelle.aspx.cs"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="WebForm1VisuaTabelle.aspx.cs"

dXNpbmcgU3lzdGVtOw0KdXNpbmcgU3lzdGVtLkNvbGxlY3Rpb25zOw0KdXNpbmcgU3lzdGVtLkNv
bXBvbmVudE1vZGVsOw0KdXNpbmcgU3lzdGVtLkRhdGE7DQp1c2luZyBTeXN0ZW0uRHJhd2luZzsN
CnVzaW5nIFN5c3RlbS5XZWI7DQp1c2luZyBTeXN0ZW0uV2ViLlNlc3Npb25TdGF0ZTsNCnVzaW5n
IFN5c3RlbS5XZWIuVUk7DQp1c2luZyBTeXN0ZW0uV2ViLlVJLldlYkNvbnRyb2xzOw0KdXNpbmcg
U3lzdGVtLldlYi5VSS5IdG1sQ29udHJvbHM7DQp1c2luZyBTeXN0ZW0uRGF0YS5PZGJjOw0KDQpu
YW1lc3BhY2UgVmlzdWFUYWJlbGxlDQp7DQoJLy8vIDxzdW1tYXJ5Pg0KCS8vLyBTdW1tYXJ5IGRl
c2NyaXB0aW9uIGZvciBXZWJGb3JtMS4NCgkvLy8gPC9zdW1tYXJ5Pg0KCXB1YmxpYyBjbGFzcyBX
ZWJGb3JtMSA6IFN5c3RlbS5XZWIuVUkuUGFnZQ0KCXsNCgkJcHJpdmF0ZSB2b2lkIFBhZ2VfTG9h
ZChvYmplY3Qgc2VuZGVyLCBTeXN0ZW0uRXZlbnRBcmdzIGUpDQoJCXsNCgkJCS8vIFB1dCB1c2Vy
IGNvZGUgdG8gaW5pdGlhbGl6ZSB0aGUgcGFnZSBoZXJlDQoJCQlUYWJlbGxhID0gRHJvcERvd25M
aXN0MS5TZWxlY3RlZEl0ZW0uVGV4dDsNCgkJfQ0KDQoJCXByb3RlY3RlZCBTeXN0ZW0uV2ViLlVJ
LldlYkNvbnRyb2xzLkJ1dHRvbiBCdXR0b25SaWNlcmNhOw0KCQlwcm90ZWN0ZWQgU3lzdGVtLldl
Yi5VSS5XZWJDb250cm9scy5EYXRhR3JpZCBEYXRhR3JpZDE7DQoJCXByb3RlY3RlZCBTeXN0ZW0u
V2ViLlVJLldlYkNvbnRyb2xzLkxhYmVsIExhYmVsMTsNCgkJcHJvdGVjdGVkIFN5c3RlbS5XZWIu
VUkuV2ViQ29udHJvbHMuTGFiZWwgTGFiZWwyOw0KCQlwcm90ZWN0ZWQgU3lzdGVtLldlYi5VSS5X
ZWJDb250cm9scy5Ecm9wRG93bkxpc3QgRHJvcERvd25MaXN0MTsNCgkJcHJvdGVjdGVkIFN5c3Rl
bS5XZWIuVUkuV2ViQ29udHJvbHMuQnV0dG9uIEJ1dHRvbjE7DQoNCgkJc3RyaW5nIFRhYmVsbGEg
PSBudWxsOw0KCQkjcmVnaW9uIFdlYiBGb3JtIERlc2lnbmVyIGdlbmVyYXRlZCBjb2RlDQoJCW92
ZXJyaWRlIHByb3RlY3RlZCB2b2lkIE9uSW5pdChFdmVudEFyZ3MgZSkNCgkJew0KCQkJLy8NCgkJ
CS8vIENPREVHRU46IFRoaXMgY2FsbCBpcyByZXF1aXJlZCBieSB0aGUgQVNQLk5FVCBXZWIgRm9y
bSBEZXNpZ25lci4NCgkJCS8vDQoJCQlJbml0aWFsaXplQ29tcG9uZW50KCk7DQoJCQliYXNlLk9u
SW5pdChlKTsNCgkJfQ0KCQkNCgkJLy8vIDxzdW1tYXJ5Pg0KCQkvLy8gUmVxdWlyZWQgbWV0aG9k
IGZvciBEZXNpZ25lciBzdXBwb3J0IC0gZG8gbm90IG1vZGlmeQ0KCQkvLy8gdGhlIGNvbnRlbnRz
IG9mIHRoaXMgbWV0aG9kIHdpdGggdGhlIGNvZGUgZWRpdG9yLg0KCQkvLy8gPC9zdW1tYXJ5Pg0K
CQlwcml2YXRlIHZvaWQgSW5pdGlhbGl6ZUNvbXBvbmVudCgpDQoJCXsgICAgDQoJCQl0aGlzLkJ1
dHRvblJpY2VyY2EuQ2xpY2sgKz0gbmV3IFN5c3RlbS5FdmVudEhhbmRsZXIodGhpcy5CdXR0b25S
aWNlcmNhX0NsaWNrKTsNCgkJCXRoaXMuTG9hZCArPSBuZXcgU3lzdGVtLkV2ZW50SGFuZGxlcih0
aGlzLlBhZ2VfTG9hZCk7DQoNCgkJfQ0KCQkjZW5kcmVnaW9uDQoNCgkJcHJpdmF0ZSB2b2lkIEJ1
dHRvblJpY2VyY2FfQ2xpY2sob2JqZWN0IHNlbmRlciwgU3lzdGVtLkV2ZW50QXJncyBlKQ0KCQl7
DQoJCQlMYWJlbDIuVGV4dCA9ICJUYWJlbGxhICIrIFRhYmVsbGE7DQoJCQkvL09kYmNDb25uZWN0
aW9uIGNvbm4gPSBuZXcgT2RiY0Nvbm5lY3Rpb24oIkRSSVZFUj17TXlTUUwgT0RCQyAzLjUxIERy
aXZlcn07IisiU0VSVkVSPWxvY2FsaG9zdDsiKyJEQVRBQkFTRT10ZG1pbzsiKyJVSUQ9cm9vdDsi
KyJQQVNTV09SRD1yb290cHdkOyIpOw0KCQkJT2RiY0Nvbm5lY3Rpb24gY29ubiA9IG5ldyBPZGJj
Q29ubmVjdGlvbiAoIkRSSVZFUj1NeVNRTDtTRVJWRVI9bG9jYWxob3N0O0RBVEFCQVNFPXRkbWlv
O1VJRD1yb290O1BBU1NXT1JEPXJvb3Rwd2Q7Iik7DQoJCQlPZGJjRGF0YUFkYXB0ZXIgZGFUYWJl
bGxhID0gbmV3IE9kYmNEYXRhQWRhcHRlcigic2VsZWN0ICogZnJvbSAiICtUYWJlbGxhICsgIiIs
IGNvbm4pOw0KCQkJRGF0YVNldCBEcyA9IG5ldyBEYXRhU2V0KCk7DQoJCQljb25uLk9wZW4oKTsN
CgkJCWRhVGFiZWxsYS5GaWxsKERzLCBUYWJlbGxhKTsNCgkJCWNvbm4uQ2xvc2UoKTsNCgkJCURh
dGFHcmlkMS5EYXRhU291cmNlPSBEczsNCgkJCURhdGFHcmlkMS5EYXRhQmluZCgpOw0KCQl9DQoJ
fQ0KfQ0K

---MOQ10933381115dc15107ceea34833fb4879d3445aa62
Content-Type: text/x-csharp; name="ProvaVisuaTabella.cs"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="ProvaVisuaTabella.cs"

dXNpbmcgU3lzdGVtOw0KdXNpbmcgU3lzdGVtLkRhdGEuT2RiYzsNCg0KbmFtZXNwYWNlIFByb3Zh
VmlzdWFUYWJlbGxlDQp7DQoJLy8vIDxzdW1tYXJ5Pg0KCS8vLyBTdW1tYXJ5IGRlc2NyaXB0aW9u
IGZvciBDbGFzczEuDQoJLy8vIDwvc3VtbWFyeT4NCgljbGFzcyBDbGFzczENCgl7DQoJCS8vLyA8
c3VtbWFyeT4NCgkJLy8vIFRoZSBtYWluIGVudHJ5IHBvaW50IGZvciB0aGUgYXBwbGljYXRpb24u
DQoJCS8vLyA8L3N1bW1hcnk+DQoJCVtTVEFUaHJlYWRdDQoJCXN0YXRpYyB2b2lkIE1haW4oc3Ry
aW5nW10gYXJncykNCgkJew0KCQkJQ29uc29sZS5Xcml0ZUxpbmUoIkluc2VyaXNjaSBpbCBub21l
IGRlbGxhIHRhYmVsbGE6ICIpOw0KCQkJc3RyaW5nIG5vbWUgPSBDb25zb2xlLlJlYWRMaW5lKCk7
DQoJCQkvL09kYmNDb25uZWN0aW9uIGNvbm4gPSBuZXcgT2RiY0Nvbm5lY3Rpb24oIkRSSVZFUj17
TXlTUUwgT0RCQyAzLjUxIERyaXZlcn07IisiU0VSVkVSPWxvY2FsaG9zdDsiKyJEQVRBQkFTRT10
ZG1pbzsiKyJVSUQ9cm9vdDsiKyJQQVNTV09SRD1yb290cHdkOyIpOw0KCQkJT2RiY0Nvbm5lY3Rp
b24gY29ubiA9IG5ldyBPZGJjQ29ubmVjdGlvbiAoIkRSSVZFUj1NeVNRTDtTRVJWRVI9bG9jYWxo
b3N0O0RBVEFCQVNFPXRkbWlvO1VJRD1yb290O1BBU1NXT1JEPXJvb3Rwd2QiKTsNCgkJCWNvbm4u
T3BlbigpOw0KCQkJT2RiY0NvbW1hbmQgY29tID0gbmV3IE9kYmNDb21tYW5kKCk7DQoJCQljb20g
PSBjb25uLkNyZWF0ZUNvbW1hbmQoKTsNCgkJCWNvbS5Db21tYW5kVGV4dD0iU2VsZWN0ICogZnJv
bSAiICtub21lKyAiIjsNCgkJCU9kYmNEYXRhUmVhZGVyIGRiUmVhZGVyID1udWxsOw0KCQkJZGJS
ZWFkZXIgPSBjb20uRXhlY3V0ZVJlYWRlcigpOw0KCQkJQ29uc29sZS5Xcml0ZUxpbmUoKTsNCgkJ
CWZvciAoaW50IGk9MDsgaTxkYlJlYWRlci5GaWVsZENvdW50O2krKykNCgkJCXsNCgkJCQlDb25z
b2xlLldyaXRlKCJ7MH0iLGRiUmVhZGVyLkdldE5hbWUoaSkuUGFkTGVmdCgxMCwnICcpKTsNCgkJ
CX0NCgkJCUNvbnNvbGUuV3JpdGVMaW5lKCk7DQoJCQl3aGlsZSAoZGJSZWFkZXIuUmVhZCgpKQ0K
CQkJew0KCQkJCWZvciAoaW50IGo9MDtqPGRiUmVhZGVyLkZpZWxkQ291bnQ7aisrKQ0KCQkJCXsN
CgkJCQkJLy92YWxvcmUgPSAoc3RyaW5nKWRiUmVhZGVyLkdldFZhbHVlKGopOw0KCQkJCQlDb25z
b2xlLldyaXRlKCJ7MH0iLCBkYlJlYWRlci5HZXRWYWx1ZShqKS5Ub1N0cmluZygpLlBhZFJpZ2h0
KDIwLCcgJykpOw0KCQkJCX0NCgkJCQlDb25zb2xlLldyaXRlTGluZSgpOw0KCQkJfQ0KDQoJCQkN
CgkJCWRiUmVhZGVyLkNsb3NlKCk7DQoJCQljb25uLkNsb3NlKCk7DQoJCX0NCgl9DQp9

---MOQ10933381115dc15107ceea34833fb4879d3445aa62--