Skip to main content

Posts

SQL SPLIT FUNCTION or String_split sql function alternative Very Information (Solved)

Dear All,  Today i created a form with the checkbox list and store the value in the sql with comma seprated way. It was strange for me that the split_string function is not supported in sql 2014, so i have created split function that will help to split the comma sepearted values   CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))      returns @temptable TABLE (items varchar(8000))      as      begin      declare @idx int      declare @slice varchar(8000)      select @idx = 1          if len(@String)<1 or @String is null  return      while @idx!= 0      begin          set @idx = charindex(@Delimiter,@String)          if @idx!=0              set @slice = left(@String,@idx - 1)          else              set @slice = @String          if(len(@slice)>0)         insert into @temptable(Items) values(@slice)          set @String = right(@String,len(@String) - @idx)          if len(@String) = 0 break      end  return      end select top 10 * from dbo.split('Karachi,
Post a Comment
Read more
Recent posts

Visual webpart for office 365

Hi Everyone, In Today’s Post we are going to see Office 365 how to build and deploy a web part with sharepoint online. Prerequisites: 1. Visual Studio 2. SharePoint Site 3. Visual Studio 2010 Power Tools 4. Office 365 Site Note: Please install Visual Studio 2010 Power Tools before starting Please follow the below Procedure. Step 1 Run Visual Studio as an Administrator Step 2 Create a Project using “Empty SharePoint Project” Template Step 3 Specify the local Share Point site Url(Not o365) Step 4 Select “Deploy as Sandbox solution”option and click on Finish Step 5 Now Add Visual Web part(Sandbox) Template Step 6 Write your code as per the requirement Step 7 Build the Solution and Test the functionality in Local Site. Step 8 Package the solution by clicking on “Package” Option. Right click on solution ->Package Step 9 Now login into o365 Site as an Administrator Step 10 click on the solution Gallery Root site -> Site Actions -> Site
Post a Comment
Read more

SharePoint: A Complete Guide to Getting and Setting Fields using C#

Original article https://social.technet.microsoft.com/wiki/contents/articles/21801.sharepoint-a-complete-guide-to-getting-and-setting-fields-using-c.aspx Introduction This article demonstrates how to set and get the various SPField types for a SharePoint list using C#. The examples demonstrated set and get fields from an item that belongs to a custom list. The custom list contains a number of fields, and all the fields are named based on the type of field they are. For example, there is a Text field, which has been named, textfield. This is depicted in the following picture:   Applies To The examples demonstrated below are tested with and apply to the following versions of SharePoint: SharePoint 2010 SharePoint 2013 Get the List, and the first SPListItem This is the basic code for getting an item. If the list has at least one item, the first item is retrieved, otherwise a new item is created. var web = SPContext.Current.Site.RootWeb; var list = web.Lists.Try
Post a Comment
Read more