Cloud Dev

By now many people would have realized that SharePoint calculations are quite similar to Excel. To default a list column date to a specific date, you can use this formular below: =DATE(YEAR(Today),MONTH(Today),DAY("28-Dec-2008")) QED

To close a window in ASP.NET 2.0 just inject this script inside a Response.Write(" ") var oMe = window.self; oMe.open('','_self',''); oMe.close(); QED

Microsoft's Language Integrated Query is no doubt one of the most thrilling data access capability I cherish. This is just because of the flexibility you have in writing your queries within your code. The power of LINQ is not limited to the data access as in (LINQ to SQL). LINQ can be used to query the active directory, XML, SharePoint lists etc. Today I will like to discuss how to return @@IDENTITY or SCOPE_IDENTITY() in LINQ. The simple answer is to read the Id value you require immediately after submitting your changes. e.g. DataContext db = new ClassesDataContext(); PATIENT_DETAIL p = new PATIENT_DETAIL(); p.Address1 = txtAddress1.Text; p.Address2 = txtAddress2.Text; p.Address3 = txtAddress3.Text; p.Address4 = txtAddress4.Text; db.PATIENT_DETAILs.InsertOnSubmit(p); db.SubmitChanges(); int myId = p.PASNumber; // This returns the Id generated by the database (where PASNumber represents the Primary key to be returned.) QED