Sharepoint Caluclation column

1.Display date format like "dd-MMM-yyyy"

=TEXT(StartDate,"dd-mmm-yyyy")

Namespaces for .Net Fucntionality

1. Going to use upload functionality the use the namespace

using System.IO;

if (!System.IO.File.Exists(fileToUpload))
                throw new FileNotFoundException("File not found.", fileToUpload);

Otherwise it throws error
----------------------------------------------------------------------------------------------------------------

ASP.Net Validation Controls

1. Validation for Non-Numeric and Decimal Values

It will restrict alphabets characters. It will allow only Numbers or
decimal values.

style="text-align:right" Width="53px" BackColor="#82CAFA"
BorderStyle="Dotted" BorderWidth="1px">
                                                   
runat="server" ErrorMessage="Only Number allowed"
ControlToValidate="Target"  ValidationExpression="^\d*[0-9](|.\d*[0-9]|,
\d*[0-9])?$" ValidationGroup="METVAL">
----------------------------------------------------------------------------------------------------------------

How to Import the Excel Data into the MS SQL Database table

Create a Dummy table name is Dummy_Tyring and create column name as per Excel Sheet.
The existing table name is Properties

steps:
1.Just copy all data from Excel File and paste into the Dummy_Tyring table

2.Execute the below update Query
update [Properties]
set [Properties].Tiring = Dummy_Tyring.Tiring
FROM [Properties]
INNER JOIN Dummy_Tyring ON [Properties].PropertyPIN = Dummy_Tyring.PIN

3.Now all the dummy data information has moved to Existing Database table.

 

How to check the W2WP Process is running in the Sharepoint

Opend cmd

C:\Windows\System32>issapps.vbs

ASP.Net and C Sharp String Manipulation

1.using foreach loop for split the comma in that string

 foreach (string c in Controls.Text.Split(','))
                    {
                        if (c == Target.ID)
                        {
}
}


2.Get the specific values in that string using substring method


3.Replace the string
toAddress = toAddress.Replace(";", ",");


4.Get the string after comma
string[] words = subject.Split(',');
                string title = words[0];
                string Roomtoretrieve = words[1];
                string MeetingRoom = words[2];

Update same table column using Join

UPDATE t2
SET t2.FinalValue = t3.FinalValue ,t2.Updated='true'--t3.FinalValue
from #tbl_3 t2 INNER JOIN #tbl_3 t3 ON t3.FTValue=t2.FTValue
WHERE t2.Updated='false'