Comments by MemberCva

MemberCva 23-Mar-12 3:17am View

Thanks MaulikDusara,

This is my code i have used here total is the no of scripts to be inserted.

RadProgressContext progress = RadProgressContext.Current;
progress.Speed = "N/A";

for (int i = 0; i < total; i++)
{
progress.PrimaryTotal = 1;
progress.PrimaryValue = total;
progress.PrimaryPercent = 100;

progress.SecondaryTotal = total;
progress.SecondaryValue = i;
progress.SecondaryPercent = i;

progress.CurrentOperationText = Filename + " Step " + i.ToString();

if (!Response.IsClientConnected)
{
//Cancel button was clicked or the browser was closed, so stop processing
break;
}

progress.TimeEstimated = (total - i) * 100;
//Stall the current thread for 0.1 seconds
System.Threading.Thread.Sleep(100);
}

The scripts are inserted to db in another loop as u mentioned as datarows .
what else i have to do pls correct my codeing,

thanks in advance.
Siva

MemberCva 23-Mar-12 3:10am View

Thanks Clifford Nelson ,

How can i implement this in asp.net.

MemberCva 8-Oct-11 7:57am View

thanks for your reply...........
the examples in demo as given static.........
i have to achive it dynamically......
warm regards.....
Cva

MemberCva 28-Sep-11 0:37am View

thanks yar....
while executing my query igot he result incorrect syntax near '('.....
my query is
select MAX ( substring (ID,2(2+1),len(ID)-1) ) from Table1

2+1 here 2 mentions the no of alphabets am using in that column, AB is my alphabet in that column.....

thanks in advance.....

with warm regards....
Cva.....

MemberCva 28-Sep-11 0:32am View

thanks sachin....

i got the result by ur query but my need is to get the result dynamically.....

thanks in advance.....
with warm regards...
Cva....

MemberCva 21-Sep-11 7:32am View

thnks for your solution.................

MemberCva 20-Sep-11 7:25am View

thanks yar,
but in my need there is no need of aggregate or group by..
i just got the result set to bind rows to columns........

thanks in advance,
with regards...
siva

MemberCva 20-Sep-11 7:22am View

thanks for all ........
i got the final result to instead of using while i use if condition for the fetch status... it works......

with regards....
siva

MemberCva 17-Sep-11 7:01am View

thanks adit.........

MemberCva 17-Sep-11 6:12am View

thanks,
this is my SP for the need i mention above , the table name to be get dynamically

create procedure SP_M
(
@proc nvarchar(50),
@vc nvarchar(255)
)
as
begin

declare @TABLENAME varchar(50)
declare @TABLENAM_IDENTITY nvarchar(50)
declare @prtable nvarchar(50)
declare @sectable nvarchar(50)

DECLARE @curs CURSOR
SET @curs = CURSOR FOR
SELECT TBL_R_ID,TBL_IDENTITY
FROM PR_TBL_IDENTITY WHERE PR_R_ID=@proc

OPEN @curs
FETCH NEXT
from @curs into @TABLENAME,@TABLENAM_IDENTITY

WHILE @@FETCH_STATUS = 0
BEGIN

PRINT @TABLENAME ---- t1 and t2, t1 has some set of datas, t2 has some set of datas
PRINT @TABLENAM_IDENTITY --- t1 is primary, t2 is secondary

IF @TABLENAM_IDENTITY='PRIMARY'
begin

set @prtable= 't'+@TABLENAME+'_V' --table 1

exec('select I_ID from'+ @prtable+'where VAL='+@vc)

end
----- i dont know what to do here to achieve my need @prtable for secondary

IF @TABLENAM_IDENTITY='secondary'
BEGIN
set @sectable='JITS_'+@TABLENAME+'_VALUE' -- table 2

exec('select C_N,C_V from'+@sectable+' where I_L_ID
in(select I_ID from'+ @prtable )

END

FETCH NEXT
FROM @curs INTO @TABLENAME,@TABLENAM_IDENTITY
END
CLOSE @curs
DEALLOCATE @curs
end

pls guide me
thnks in advance....

MemberCva 17-Sep-11 3:17am View

thnks Mehdi,
the table name parameter @tablename1 given here is for the first fetch using cursor
my need is for the second time of fetch it should select the another table declared parameter @tablename2 during this process i need the executed result of the first fetch from that table, the first executed result should be the sub query for the second execution of the cursor fetch at the second time......

thanks in advance...........

MemberCva 17-Sep-11 3:03am View

here is the sample senario,
am using cursor, for the first fetch it exec a select operation from one table i have set that as secondary.
then for the next fetch it exec a select operation from another table during this execution, how i hav to get the values of the first executed fetch to this execution.....

am using cursor here, if cursor not needed for this then how i can do this.....

thanks n advance.....

Comments by MemberCva (Top 12 by date)