列名称中的空格 [英] Spaces in column name
问题描述
当触发此事件时,出现以下异常
错误:
''System.Data.SyntaxErrorException''
缺少后的操作数''''''''运营商。
所以大概它不喜欢列中的空格
名称,有没有办法暂时重命名列
这个程序,还是我必须重命名数据库中的列
,重新生成数据集并重新绑定网格?
\ \\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
Me.OrdersDataGrid.DataSource = DataView1
DataView1 .RowFilter ="订单日期= strThisWeeksOrders"
///
提前致谢
问候史蒂夫
When this event is triggered the following exception
error occurs:
''System.Data.SyntaxErrorException''
Missing operand after ''of'' operator.
So presumably it doesn''t like the spaces in the column
name, is there any way of temporarily renaming the column
for this procedure, or will I have to rename the column
in the database, regenerate datasets and rebind the grid ?
\\\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter = "Date of Order = strThisWeeksOrders"
///
Thanks in advance
Regards Steve
推荐答案
" Steven Smith" <一个******* @ discussions.microsoft.com> schrieb
"Steven Smith" <an*******@discussions.microsoft.com> schrieb
当触发此事件时,会发生以下异常
错误:
''System.Data.SyntaxErrorException''
''''运算符后缺少操作数。
所以大概它不喜欢列中的空格
名称,有没有办法暂时重命名这个程序的栏目,或者我是否需要重命名数据库中的列
,重新生成数据集并重新绑定网格?
\\\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
你应该启用Option Strict。
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter ="订单日期= strThisWeeksOrders"
/ //
提前致谢
关心Steve
When this event is triggered the following exception
error occurs:
''System.Data.SyntaxErrorException''
Missing operand after ''of'' operator.
So presumably it doesn''t like the spaces in the column
name, is there any way of temporarily renaming the column
for this procedure, or will I have to rename the column
in the database, regenerate datasets and rebind the grid ?
\\\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
You should enable Option Strict.
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter = "Date of Order = strThisWeeksOrders"
///
Thanks in advance
Regards Steve
未经测试:
DataView1 .RowFilter =" [订购日期] =" &安培; strThisWeeksOrders
你为什么声明订单日期?双倍?
-
Armin
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html
嗨史蒂文,
订单的日期必须是一个数据表达式,这个我无法找到.b / b <
是不是只有一个日期列,而不是
" MyOrderDate = strWeekorders"还不够吗?
Cor
Hi Steven,
That date of Order has to be an datacolumn expression this one I could not
find.
Is there not a just a date column in order and is than
"MyOrderDate = strWeekorders" than not sufficient?
Cor
当触发此事件时,会发生以下异常
错误:
'' System.Data.SyntaxErrorException''
'''''''''''''''''''''''''''
任何临时重命名列的方法
这个程序,还是我必须重命名数据库中的列
,重新生成数据集并重新绑定网格?
\\ \
Dim strThisWeeksOrders As String = Today.ToOADate - 7
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter ="订单日期= strThisWeeksOrders"
///
提前致谢
关心Steve
When this event is triggered the following exception
error occurs:
''System.Data.SyntaxErrorException''
Missing operand after ''of'' operator.
So presumably it doesn''t like the spaces in the column
name, is there any way of temporarily renaming the column
for this procedure, or will I have to rename the column
in the database, regenerate datasets and rebind the grid ?
\\\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter = "Date of Order = strThisWeeksOrders"
///
Thanks in advance
Regards Steve
否否否我看过Armins回答
No No No I saw Armins answer
" MyOrderDate = strWeekorders"还不够吗?
" MyOrderDate =" &安培; strWeekorders还不够吗?
抱歉看起来不太好
Cor
订单日期必须是数据表达式一个我无法找到。
是不是只有一个日期列,而不是
MyOrderDate = strWeekorders还不够吗?
"MyOrderDate = strWeekorders" than not sufficient? "MyOrderDate = " & strWeekorders than not sufficient?
Sorry did not look well
Cor
That date of Order has to be an datacolumn expression this one I could not
find.
Is there not a just a date column in order and is than
"MyOrderDate = strWeekorders" than not sufficient?
Cor
当触发此事件时,会发生以下异常
错误:
''System.Data。 SyntaxErrorException''
在'''''''''''''''''''''''''''''
为此过程重命名列
,或者我是否必须重命名数据库中的列
,重新生成数据集并重新绑定网格?
\\\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter ="订单日期= strThisWeeksOrders"
///
提前致谢
关心Steve
When this event is triggered the following exception
error occurs:
''System.Data.SyntaxErrorException''
Missing operand after ''of'' operator.
So presumably it doesn''t like the spaces in the column
name, is there any way of temporarily renaming the column
for this procedure, or will I have to rename the column
in the database, regenerate datasets and rebind the grid ?
\\\
Dim strThisWeeksOrders As String = Today.ToOADate - 7
Me.OrdersDataGrid.DataSource = DataView1
DataView1.RowFilter = "Date of Order = strThisWeeksOrders"
///
Thanks in advance
Regards Steve
这篇关于列名称中的空格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!