hitung masa kerja/umur menggunakan asp.net c#

#region masabekerja

int lama;
DateTime d = Convert.ToDateTime(txtTanggalStart.Text);

string s = d.ToString(“dd/MM/yyyy”);

// Convert date time in string (s) to DateTime (Todate) data type

DateTime Todate = DateTime.Parse(s, CultureInfo.CreateSpecificCulture(“en-AU”));

// Convert entered date string (TextBox1.Text) to DateTime (givenDate) Data Type

DateTime givenDate = DateTime.Parse(queryPrem.Kary_TglMskKrja.ToString());

// Count total days

double days = Todate.Subtract(givenDate).Days;

// Convert days to year and display into Label.Text

lama = Convert.ToInt32(Math.Floor(days / 365.24219));

#endregion

stored procedure SQL to Linq using asp.net c#

1. Klik database .edmxnya

2. Klik View->pilih Other Windows->klik Entiti Data Model Browser

 

 

 

 

3. Pada model browsernya add store procedure yang akan digunakan

4.Pada function importnya klik kanan add function,Isikan Function Name,pilih stored procedure,pilih none,pilih create New complex type.Lalu ok