更改数据集中的日期格式 [英] change date format in dataset

问题描述

开发人员，

我有一个使用数据集在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 cmdstring1 = string.Format(@" select convert(varchar, getdate(), 103  From {0}") ,(YourFieldPath.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(cmdstring1, olconn);
                adapter.Fill(dataset, "Test");
                olconn.Close();               
            }
          return dataset;
        }

但是当我写这样的代码时

but when I write a code like this

select convert(varchar, getdate(), 103 From{0})

引发错误:参数无效"

一个主要问题是dateformat在多列中发生了变化
没有单个或多个日期被分成多行和多列
所以我不知道要更改更多的列.

我想通过使用此sql查询来更改数据集中的所有列行日期.

an error is raised: "Invalid argument"

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.

推荐答案

Hi 维舒，

您在以下变量中缺少右括号:
string cmdstring1

请使用以下行代替您的行.

Hi Vishu,

You are missing right parentheses in following variable:
string cmdstring1

Please use following line instead of your.

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

如有任何疑问，请让我知道.

请提供"投票":thumbsup:如果有帮助，请提供"接受答案":rose:如果这是正确的答案.
谢谢，
Imdadhusen

Please do let me know, if you have any doubt.

Please provide "Vote":thumbsup: if this would be helpful, and make "Accept Answer":rose: if this would be correct answer.
Thanks,
Imdadhusen

这篇关于更改数据集中的日期格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！