解决错误“在表达式中转换未定义的函数"； [英] solve error "undefined function convert in expression"

问题描述

开发人员，
我有一个使用数据集在datagridview中加载的csv文件.
问题是:
我想在datagridview中加载csv文件之前更改数据集中不在datagridview中的日期格式

Hi developers,
I have a csv file that is loaded in datagridview by using dataset.
The problem is:
I want to change dates format in dataset not in datagridview before loading a csv file in datagridview

public static DataSet GetDataset(string filename)
       {

               string Connectionstring = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Text;",
                   Path.GetDirectoryName(filename));
               string cmdString = string.Format("SELECT *FROM {0}", Path.GetFileName(filename));
               string cmdstring = string.Format(@" select convert(varchar, getdate(), 103)  From {0}", Path.GetFileName(filename));


               DataSet dataset = new DataSet();
               using (OleDbConnection olconn = new OleDbConnection(Connectionstring))
               {
                   olconn.Open();
                   OleDbDataAdapter adapter = new OleDbDataAdapter();
                   adapter.SelectCommand = new OleDbCommand(cmdString, olconn);
                   adapter.SelectCommand = new OleDbCommand(cmdstring, olconn);
                   adapter.Fill(dataset, "Test");
                   olconn.Close();
               }
               return dataset;
           }

但是当我写这样的代码时

but when I write a code like this

string cmdstring = string.Format(@" select convert(varchar, getdate(), 103)  From {0}, Path.GetFileName(filename));

错误是
未定义的函数在表达式中转换

一个主要问题是dateformat在多列中发生了变化
没有单个或多个日期被分成多行和多列
所以我不知道要更改更多的列.
我想通过使用此sql查询来更改数据集中所有列的行日期.
请解决我的问题并更正此代码

Error is
undefined function convert in Expression

A main problem is that dateformat change in multiple columns
not single or more dates are split into multiple rows and columns
so I do not know how more columns are changed.
I want to change all of the columns rows dates in dataset, by using this sql query.
please solve my problem and Correct this code

推荐答案

不，我不会解决您的问题，我也不会为您编写任何代码.
看来您正在使用"MS Access"数据库.那将放弃使用
SQL内的convert函数. AFAIK这是仅在T-SQL中可用的功能
MS-SQL Server的版本，在这里不起作用.

干杯

曼弗雷德(Manfred)

No I''ll not solve your problem and neither will I write any code for you.
It seems you''re using maybe an "MS Access" DB. That will forfeit the use of
the convert function inside your SQL. AFAIK this is a function only availabe in T-SQL
of MS-SQL Server and won''t work here.

Cheers

Manfred

这篇关于解决错误“在表达式中转换未定义的函数"；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！