• Asp.Net
  • MVC
  • C#
  • SQL Server
  • JavaScript
  • Learn from Life

Prakash Rathod

~ Passion is not a logic; it's an emotion.

Prakash Rathod

Monthly Archives: February 2010

Upload images in FCKEDITOR in asp.net

27 Saturday Feb 2010

Posted by Prakash in Asp.Net, Uncategorized

≈ Comments Off on Upload images in FCKEDITOR in asp.net

1) Create a folder in root namely ” userfiles ” and inside it create sub folder ” image “. So its like this
userfiles \ image

2) Now edit the following lines in fckeditor\fckconfig.js file

var _FileBrowserLanguage = ‘php’ ; // asp | aspx | cfm | lasso | perl | php | py
var _QuickUploadLanguage = ‘php’ ; // asp | aspx | cfm | lasso | perl | php | py

Change it to following :-

var _FileBrowserLanguage = ‘aspx’ ; // asp | aspx | cfm | lasso | perl | php | py
var _QuickUploadLanguage = ‘aspx’ ; // asp | aspx | cfm | lasso | perl | php | py

3) Now edit the following lines in fckeditor\editor\filemanager\connectors\aspx\config.ascx

// URL path to user files.

UserFilesPath = “/userfiles/”;

Change to :-

UserFilesPath = “~/userfiles/”;

Now you are ready to use fckeditor.
Note :- That is for development on localhost. On remote sever don’t forget to give read/write permission to this userfiles and image folder.

SQL split function

15 Monday Feb 2010

Posted by Prakash in SQL Server, Uncategorized

≈ Comments Off on SQL split function

DECLARE @str as varchar(max)
SET @str = ‘Prakash,Sanket,Jigar,JD’
SELECT value as GiveColumName from dbo.split(@str,’,’)

Split function used to insert to multiple records into tables…. see below procedure

INSERT INTO BoqThermoDrawing
SELECT @BoqNo,@RevisionNo,@RootPath+’\’+value from dbo.Split(@FileNames,’/’)

—————————————————————–
Create function in sql server… split after that u can use above function

USE [DataBaseName]
GO
/****** Object: UserDefinedFunction [dbo].[Split] Script Date: 03/04/2010 11:55:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER function [dbo].[Split](
@String nvarchar (4000),
@Delimiter nvarchar (10)
)
returns @ValueTable table ([ID] int,[Value] nvarchar(4000))
begin
declare @NextString nvarchar(4000)
declare @Pos int
declare @NextPos int
declare @CommaCheck nvarchar(1)

–Initialize
set @NextString = ”
set @CommaCheck = right(@String,1)

–Check for trailing Comma, if not exists, INSERT
–if (@CommaCheck @Delimiter )
set @String = @String + @Delimiter

–Get position of first Comma
set @Pos = charindex(@Delimiter,@String)
set @NextPos = 1

–Loop while there is still a comma in the String of levels
Declare @sr as int
set @sr =0
while (@pos 0)
begin
set @NextString = substring(@String,1,@Pos – 1)
set @sr = @sr + 1
insert into @ValueTable ([id], [Value]) Values (@sr , @NextString)

set @String = substring(@String,@pos +1,len(@String))

set @NextPos = @Pos
set @pos = charindex(@Delimiter,@String)
end

return
end

Open Aspx Page in Popup

15 Monday Feb 2010

Posted by Prakash in Asp.Net

≈ Comments Off on Open Aspx Page in Popup

Add this function in Search Page or View All items page..

function ShowPopUp(Id)
{
$get(”).src=”AssignTool.aspx?ID=”+Id;
$find(”).show();
document.getElementById(“”).innerHTML = “Assign Tool”;
return false;
}

—————– View All Items page ———–

 

——————— view All cs page coding —————

Gridview Row DataBound Event

if (e.Row.RowType == DataControlRowType.DataRow)
{
Button btnAccept = (Button)e.Row.Cells[16].Controls[0];
btnAccept.Attributes.Add(“onclick”, “return ShowPopUpAccept(” + rowView[“AssignToolId”].ToString() + “)”);
}

Recent Posts

  • Create a custom autocomplete control in ASP.NET MVC
  • Nth Highest Salary
  • Generate x509 certificate in pem, cer and pfx and export public key
  • Send an image (stored as base64 string) inline in email
  • Put/Delete http verb not working server

Categories

  • Android
  • Asp.Net
  • BANKING
  • c#.net
  • Crystal Report
  • HTML5 CSS3
  • iPhone
  • JavaScript
  • Life – Spiritual – Reality
  • Lightswitch
  • Links
  • MAC
  • MVC
  • Netoworking
  • Silverlight
  • SQL Interview Questions
  • SQL Server
  • Uncategorized
  • Version Controls
  • Windows Store

Archives

  • August 2019
  • May 2019
  • April 2018
  • October 2017
  • August 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • April 2016
  • January 2016
  • November 2015
  • January 2015
  • December 2014
  • October 2014
  • September 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • July 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • July 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009

© 2021 Prakash Rathod