How to get data from multiple datacontext (DBML) in Linq

var ObjPermission = dbOne.Permissions.ToList();

var ObjRoleMapping = (from RD in dbTwo.RoleDetails

join RM in dbTwo.RoleMasters on RD.RoleId equals RM.RoleID

                      where RM.RoleID == AgentId

                      select RD).ToList();

List<P> ObjResult = (from P in ObjPermission

join RML in ObjRoleMapping on P.PermissionID equals RML.PermissionId

              select P).ToList();

Multiple Table's Join In LINQ

List<PM> ObjPermission = (

from P in Permissions

join RD in RoleDetails on P.PermissionID equals RD.PermissionId

join RM in RoleMasters on RD.RoleId equals RM.RoleID

where RM.RoleID == AgentId

select P).ToList();

Trim Empty Space Using JavaScript When doing Validation

function ValidateImage() {

   var fileName = document.getElementById('FUHeaderLogo').value;

   if (trim(fileName) == '') {

   alert("Please browse PNG Image");

   return false;

   }

   else {

   return true;

  }

}

function trim(s) {

    var l = 0; var r = s.length - 1;

    while (l < s.length && s[l] == ' ')

    { l++; }

    while (r > l && s[r] == ' ')

    { r -= 1; }

    return s.substring(l, r + 1);

 }

How to get Printable Contents and Non Printable Contents in Javascript

<script language="javascript" type="text/javascript">

function PopPrint() {

var originalContents = document.body.innerHTML;

var prtContent = document.getElementById('<%=Receipt.ClientID %>');

var printContents = prtContent.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

</script>

How to Get Filenames from Directory

DirectoryInfo di = new DirectoryInfo(@"E:\Empphoto\");

FileInfo[] files = di.GetFiles();

foreach (FileInfo f in files)

{

con.Open();

string Qry = "Insert into TblEmpPhoto(ImgNameWithExt,ImgName,ImgExt) Values (@ImgNameWithExt,@ImgName,@ImgExt);";

SqlCommand cmd = new SqlCommand(Qry, con);

cmd.Parameters.AddWithValue("@ImgNameWithExt", f.Name.ToString().ToUpper());

cmd.Parameters.AddWithValue("@ImgName", f.Name.Split('.')[0].ToString().ToUpper());

cmd.Parameters.AddWithValue("@ImgExt", f.Name.Split('.')[1].ToString().ToUpper());

cmd.ExecuteNonQuery();

con.Close();

}

Get FileName from Filepath

private string GetFileName(string hrefLink)

{

string[] parts = hrefLink.Split('/');

string fileName = "";

if (parts.Length > 0)

fileName = parts[parts.Length - 1];

else

fileName = hrefLink;

return fileName;

}

Linq IsNull for DateTime

var
result = from r in Dsdod.Tables[0].AsEnumerable()where r.IsNull("startdate") != true && r.IsNull("expirydate") != true && r.IsNull("category") != true && CurrentIST >= (r.Field<DateTime>("startdate")) && CurrentIST < (r.Field<DateTime>("expirydate"))select new { Id = r.Field<Int32>("adid"), PromoCode = r.Field<string>("category") };