Tuesday, August 13, 2013

Find Data Types of View Columns

EXEC SP_HELP my_view;

Retrieving a DateTime value from a DataRow (C#)

You can use as follows:

DateTime? myDateField = (row["datefield"] == DBNull.Value) ? null : (DateTime?) DateTime.Parse(row["datefield"].ToString());

Friday, April 26, 2013

Create InfoPath 2010 documents in SharePoint 2010 with SPD Workflow

  • Using InfoPath 2010 designer, design and test your form
  • Publish form to form library or as a content type, in my case created content type first and mapped InfoPath columns to my custom content type columns
  • Click on add document and save the document as template.xml or name of your choice
  • Download and save the document (template.xml) to your hard drive
  • Go to View all site content -> Form Templates -> Library tab (Ribbon) -> Open with Explorer
  • Copy the template.xml file here
  • Go back to your Form library and change the template to something like "//formtemplates/template.xml" without quotes
  • Now design your workflow and create a list item
Thats all!!

Tuesday, August 7, 2012

Word 2010 64 bit crash whenever open a doc or docx

go to User Accounts-> Change User Account Control Settings -->Set the notch to lowest->Restart System->Start MS Word-> Goto COM Add-ins -> Remove "Send to Bluetooth"--> Re-set the UAC->Restart System

Source: http://answers.microsoft.com/en-us/office/forum/office_2010-word/word-2010-64-bit-crash-whenever-open-a-doc-or-docx/23ceac25-1e51-4faf-ad64-f20a3a8828bd