Joining multiple tables in .net

Question

Hi All,

 

I am struggling to get this working in my applicaiton using C# MVC .Net framework 4.5,

 

Any help is greatly appriciated.

 

myProjects projects = db.myProjects.Find(id); 

 

Once the above line is executed, I need to join to 3 other tables for looking up values to get the discription of below attributes. 

 

ProjectStatus

ProgramName

Priority. 

 

Can you please help?

 

Regards,

Anand 

Answer 1

Yes, if you know the format and you use (Try)ParseExact, then it doesn't matter about the culture:

      string s = "20110714";

      string f = "yyyyMMdd";

      DateTime dt;

      bool isValid = DateTime.TryParseExact(s, f, null, 0, out dt);

      if (isValid)

      {

         Console.WriteLine(dt);

      }

Answer 2

hi,

use this:

string @DOB = DateTime.ParseExact(txtDOB.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat).ToString("MM/dd/yyyy");
string @DOJ = DateTime.ParseExact(txtDOJ.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat).ToString("MM/dd/yyyy");

modify this code to you requirement....