问题描述
我在Visual Studio 2010中多次生成DataSets
时使用了ODBC驱动程序,但是这次都出错了. DB中的表具有一组定义为numeric(7,2)
的列.我尝试通过自动生成的Insert
方法插入数据,如下所示:
I''ve used the ODBC driver when generating DataSets
in Visual Studio 2010 multiple times, but this time it all went wrong. The table in the DB has a set of columns defined as numeric(7,2)
. I try to insert data through the autogenerated Insert
method like this:
int x = tableAdapterMyDataTable.Insert(
(decimal)data.X,
(decimal)data.Y,
(decimal)data.Z);
在运行时,我收到一条错误消息:
In run-time I get an error saying:
ERROR [22P02] ERROR: invalid input syntax for type numeric: "-1,6"; Error while executing the query
显然,小数点分隔符是,"(逗号)是一个问题.由于TableAdapter中没有CultureInfo
,因此我很难更改它.一个无用的解决方法是更改Windows中的小数点符号.可以,但是不能使用.
设置应用程序的区域性也不起作用:
Clearly it is a problem with the decimal separator being '','' (comma). Since there are no CultureInfo
in the TableAdapter, I have trouble changing it. A useless workaround is to change the decimal symbol in Windows. That works, but can''t be used.
Setting the culture of the application doesn''t work either:
Application.CurrentCulture = System.Globalization.CultureInfo.GetCultureInfoByIetfLanguageTag("en-US");
有什么建议吗?
ODBC驱动程序8.04
PostgreSQL 8.4
Any suggestions?
ODBC Driver 8.04
PostgreSQL 8.4
推荐答案
someDataSetTableAdapters.amunds_dataTableAdapter taData =
new someDataSetTableAdapters.amunds_dataTableAdapter();
someDataSet sds = new someDataSet();
someDataSet.amunds_dataDataTable adt = sds.amunds_data;
taData.Fill1(adt); // SELECT * FROM amunds_data LIMIT 1
int x = taWeatherData.Insert(
(decimal)data.X,
(decimal)data.Y,
(decimal)data.Z);
伙计,我已经用谷歌搜索了!希望将来对某人有帮助.
Man, I''ve googled this one! Hope it will help somebody sometime in the future.
这篇关于更改Postgresql ODBC驱动程序上的区域性的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!