且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在数组中存储来自多列数据库的值并绑定到listview

更新时间:2022-01-22 02:55:37

只需选择您想要的字段:

Just select the fields you want:
SELECT [event], [date] FROM myTable

而不是

instead of

SELECT * FROM myTable

您应该始终避免使用通配符字段说明符 - 它们会增加带宽,并且如果数据库被更改,可能会更改或崩溃您的应用程序。



P.S.我只在列名周围使用''[''和'']'',因为date是SQL中的保留字,可以在用作列名时停止查询。***避免使用也是保留字的列名!

You should avoid using wildcard field specifiers at all times - they increase bandwidth and can change or crash your application if the database is altered.

P.S. I only used the ''['' and '']'' around the column names because "date" is a reserved word in SQL and can stop your queries working when used as a column name. It''s best to avoid using column names which are also reserved words!