How to calculated due date betwen two date in ASP.NET Web Form

Question

Hi Guys,,, I'm try to calculated due date betwen two date but I'm can't solve this trouble. I'm found the refrence code in VB and then I'm try to translate that code to C#. Anny help could be appriciate.

this isi code to calculated due date betwen two date in VB.NET

'find maturities based on installments to ??? 
DueDate.Text = DateAdd(DateInterval.Month, Val(InstallmentsTo.Text), DateValue(RentDate.Text))

and then I'm try translate that code in C#. But this code not working

//find maturities based on installments to ???private void SearchDueDate(){System.DateTime PaymentDate;System.DateTime RentDate;int InstallmentsTo;InstallmentsTo = Convert.ToInt32(txtcicilan_ke.Text);RentDate = Convert.ToDateTime(txttgl_pinjaman.Text);PaymentDate = Convert.ToDateTime(txttanggal_pembayaran.Text);DueDate.Text = Convert.ToDateTime(PaymentDate - RentDate), InstallmentsTo.ToString("yyyy/MM/dd");}

Pranam Bhat · Answer

' Combine your Month and Year ' Dim monthAndYear = String.Format("{0} {1}", month.Text, yrtxt.Text) ' Parse it into a DateTime object ' Dim targetedTime = DateTime.ParseExact(monthAndYear,"MMM yyyy", Nothing) ' Using the selectd time, get the 15th day of the next month ' Dim dueDate = New DateTime(targetedTime.Year, targetedTime.Month, 15).AddMonths(1).ToString("dd-MMM-yyyy") Demo : https://dotnetfiddle.net/M6AjL8 https://www.c-sharpcorner.com/UploadFile/0c1bb2/duration-calculator-between-two-dates-using-Asp-Net-C-Sharp/

Tri Setia · Answer

Problem Solved private void ShowDueDate() { using (SqlConnection con = new SqlConnection(koneksi)) { using (SqlCommand cmd = new SqlCommand()) { con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = "Select tbl_pinjaman.tanggal_jatuh_tempo from tbl_pinjaman,tbl_pembayaran where tbl_pinjaman.id_pinjaman = tbl_pembayaran.id_pinjaman and tbl_pinjaman.id_pinjaman ='" + txtid_pinjaman.Text.Trim()+ "'" ; using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { txtDue_date.Text = rdr[ "tanggal_jatuh_tempo" ].ToString(); } } } } }

Tri Setia · Answer

@Pranam Bhat thanks for the anwers sir but I want the code using C# not in VB, because I want translate that code from VB.NET to C#.