从日期时间选取器和文本框 C 获取 dd/mm/yyyy 格式的日期，而不是 mm/dd/yyyyy#-解网

问：

我尝试从日期时间选取器和文本框 C# 获取 dd/mm/yyyy 格式的日期，而不是 mm/dd/yyyyy 格式，但我面临“字符串未被识别为有效日期时间”消息错误”

我试过这段代码

if (tb_date.Text == "")
{
    tb_date.Text = dtp_addingDebit.Value.ToString("dd/MM/yyyy");
}
else
{
    tb_date.Text = Convert.ToDateTime(tb_date.Text).ToString("dd/MM/yyyy");
}

我使用带有插入存储过程的 If 条件的结果

AddingDebit_con.AddingNewDebit(int.Parse(combo_customers.SelectedValue.ToString()),tb_date.Text, Convert.ToInt32(tb_amount.Text));

AddingDebit_con是包含以下代码.cs文件

public void InsertCustomer(string customer_fullname, string customer_phone, string customer_address, string customer_date)
{
    DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
    DAL.Open();
    SqlParameter[] param = new SqlParameter[4];
    param[0] = new SqlParameter("@customer_fullname", SqlDbType.NVarChar); param[0].Value = customer_fullname;
    param[1] = new SqlParameter("@customer_phone", SqlDbType.NVarChar); param[1].Value = customer_phone;
    param[2] = new SqlParameter("@customer_address", SqlDbType.NVarChar); param[2].Value = customer_address;
    param[3] = new SqlParameter("@customer_date", SqlDbType.Date); param[3].Value = customer_date;
    DAL.ExcuteCommand("Inserting_Customers", param);
    DAL.Close();
}

AddingNewDebit 是包含以下 Sql-server 代码的存储过程

ALTER proc [dbo].[Inserting_Customers]

@customer_fullname nvarchar(max),
@customer_phone nvarchar(max),
@customer_address nvarchar(max),
@customer_date date
AS
INSERT INTO Customers
           ([customer_fullname]
           ,[customer_phone]
           ,[customer_address]
           ,[customer_date]
           )
     VALUES
           (@customer_fullname,
           @customer_phone, 
           @customer_address ,
           @customer_date
          )

C# SQL-Server 日期时间

// Note "string" type for "customer_date"
public void InsertCustomer(... string customer_date)
{
    ...
    // MS SQL expects "DateTime" - SqlDbType.Date
    param[3] = new SqlParameter("@customer_date", SqlDbType.Date); 
    
    // But it's given "string"
    param[3].Value = customer_date;
    ...
}

我建议更改类型：customer_date

// customer_date is DateTime now
public void InsertCustomer(... DateTime customer_date) 
{
   ...
}

当你想调用该方法时，你应该提供：DateTime

// Note absence of any "ToString()" here
InsertCustomer(..., myDateTimePicker.Value);

从日期时间选取器和文本框 C 获取 dd/mm/yyyy 格式的日期，而不是 mm/dd/yyyyy#

Get date in dd/mm/yyyy format instead of mm/dd/yyyyy from Date time Picker and Textbox C#

评论

评论