如何根据月份和开始日期显示结束日期 [英] how to display End Date based on months and Start Date

问题描述

try
{
  con.Open();
  SqlCommand cmd = new SqlCommand();
  SqlDataAdapter da = new SqlDataAdapter(cmd);
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.CommandText = "SP_PaymentTracker";
  cmd.Parameters.AddWithValue("@Name", txtName.Text);
  cmd.Parameters.AddWithValue("@InvestmentType", txtInvestmentType.Text);
  cmd.Parameters.AddWithValue("@Amount", txtAmount.Text);
  cmd.Parameters.AddWithValue("@MonthlyPay", txtMonthlyPay.Text);
  cmd.Parameters.AddWithValue("@NumberOfMonths", txtNoOfMonths.Text);
  cmd.Parameters.AddWithValue("@StartDate", txtStartDate.Text);

  cmd.Parameters.AddWithValue("@EndDate", txtEndDate.Text);
  cmd.Parameters.AddWithValue("@Phone", txtMobile.Text);
  cmd.Parameters.AddWithValue("@Address", txtAddress.Text);
  cmd.Connection = con;

  cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
  throw ex;
}
finally
{
  con.Close();
  con.Dispose();
  txtName.Text = txtInvestmentType.Text = txtAmount.Text = txtMonthlyPay.Text =
  txtNoOfMonths.Text = txtStartDate.Text = txtEndDate.Text = txtMobile.Text = txtAddress.Text = string.Empty;
}

这是我的代码



所以请提供我的结束日期默认值月数和开始日期

this is my code

so please provide me the End Date Default based on Number Of Months and Start Date

推荐答案

convert txtStartDate to datetime, then follow the below code
txtStartDate.AddMonths(txtNoOfMonths)

这篇关于如何根据月份和开始日期显示结束日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！