ASP.NET

<br />
  Create FUNCTION [dbo].[fn_split] (<br />
    @SourceString sql_variant,<br />
    @Delimiter nvarchar(10) = N','<br />
)<br />
RETURNS @Values TABLE( Position smallint IDENTITY, cValue varchar( 8000 ) , ncValue nvarchar( 4000 ) )<br />
AS<br />
BEGIN<br />
    DECLARE @NormalString    varchar( 8000 ) , @NationalString    nvarchar( 4000 ) ,<br />
            @NormalDelimiter varchar( 10 )   , @NationalDelimiter nvarchar( 10 )   ,<br />
            @IsNationalChar  bit             , @Position          int              ,<br />
            @NormalValue     varchar( 8000 ) , @NationalValue     nvarchar( 4000 )<br />
    SET @Delimiter      = COALESCE( @Delimiter, N',' )<br />
    SET @IsNationalChar = CASE<br />
                            WHEN SQL_VARIANT_PROPERTY( @SourceString , 'BaseType' ) IN ( 'char' , 'varchar' )<br />
                            THEN 0<br />
                            WHEN SQL_VARIANT_PROPERTY( @SourceString , 'BaseType' ) IN ( 'nchar' , 'nvarchar' )<br />
                            THEN 1<br />
                          END<br />
    IF @IsNationalChar IS NULL RETURN<br />
    IF @IsNationalChar = 0<br />
    BEGIN<br />
            SET @NormalDelimiter = @Delimiter<br />
            SET @NormalString    = CAST( @SourceString AS varchar(8000) )<br />
<br />
            IF LEFT( @NormalString , LEN( @NormalDelimiter ) ) = @NormalDelimiter<br />
                    SET @NormalString = SUBSTRING( @NormalString, LEN( @NormalDelimiter ) + 1, 8000 )<br />
            IF RIGHT( @NormalString , LEN( @NormalDelimiter ) ) <> @NormalDelimiter<br />
                    SET @NormalString = @NormalString + @NormalDelimiter<br />
            WHILE( 1 = 1 )<br />
            BEGIN<br />
                    SET @Position     = CHARINDEX( @NormalDelimiter , @NormalString ) - 1<br />
                    IF @Position <= 0 BREAK<br />
                    SET @NormalValue  = LEFT( @NormalString , @Position )<br />
                    SET @NormalString = STUFF( @NormalString , 1 , @Position + LEN( @NormalDelimiter ), '' )<br />
                    INSERT INTO @Values ( cValue ) VALUES( @NormalValue )<br />
            END<br />
    END<br />
    ELSE IF @IsNationalChar = 1<br />
    BEGIN<br />
            SET @NationalDelimiter = @Delimiter<br />
            SET @NationalString    = CAST( @SourceString AS varchar(8000) )<br />
<br />
            IF LEFT( @NationalString , LEN( @NationalDelimiter ) ) = @NationalDelimiter<br />
                    SET @NationalString = SUBSTRING( @NationalString, LEN( @NationalDelimiter ) + 1, 4000 )<br />
            IF RIGHT( @NationalString , LEN( @NationalDelimiter ) ) <> @NationalDelimiter<br />
                    SET @NationalString = @NationalString + @NationalDelimiter<br />
            WHILE( 1 = 1 )<br />
            BEGIN<br />
                    SET @Position     = CHARINDEX( @NationalDelimiter , @NationalString ) - 1<br />
                    IF @Position <= 0 BREAK<br />
                    SET @NationalValue  = LEFT( @NationalString , @Position )<br />
                    SET @NationalString = STUFF( @NationalString , 1 , @Position + LEN( @NationalDelimiter ), '' )<br />
                    INSERT INTO @Values ( ncValue ) VALUES( @NationalValue )<br />
            END<br />
    END<br />
    RETURN<br />
END<br />

<br />
foreach TableCell cell in curRow.Cells<br />
{<br />
  cell.Attributes.Add("id",cell.ClientID);<br />
  cell.Attributes.Add("onclick", "javascript:document.formname.submit();");<br />
}<br />

<br />
foreach TableCell cell in curRow.Cells<br />
{<br />
  cell.Attributes.Add("id",cell.ClientID);<br />
  cell.Attributes.Add("onclick", "javascript:getTheCell(this);");<br />
}<br />

<br />
function getTheCell(cell)<br />
{<br />
  alert('You clicked cell ID: '+ cell.ID);<br />
}<br />

<br />
foreach (TableCell cell in e.Row.Cells)<br />
{<br />
cell.Attributes.Add("id",cell.ClientID);<br />
cell.Attributes.Add("onclick", "javascript:getTheCell(this);");<br />
}<br />
<br />

<br />
function getTheCell(cell)<br />
{<br />
alert('You clicked cell ID: '+ cell.id);<br />
}<br />

Mohammad A Gdeisat wrote:

I need to use a tool that is very productive, relatively easier and reliable to build a world-class project, I need it to be able to handle millions of records and thousands of users surfing the website simaltanously.

jagadeeshkumar2106 wrote:

now using save iam saving the file in a client machine

Sonia Gupta wrote:

did u try to open this link ?