The issue is that, I have developed an ASP.NET website which is fully functionally. The company wants a sharepoint as well and want to include the asp.net website in the sharepoint. The sharepoint department asked to make use of sandbox solution. I feel that the site should be hosted on some other server. Could a link (something like iframe) will enable one to browse the site in a particular sharepoint page itself? What is your take on this?

I want to upload an website created in asp.net on sharepoint. Is it possible to upload the site created in asp.net directly on the sharepoint server( or a link from a virtual server is to be provided) . I have been suggested to upload the existing as a sanbox solution. But I want to avoid the overhead to created a sandbox solution.

I want to upload an website created in asp.net on sharepoint. Is it possible to upload the site created in asp.net directly on the sharepoint server( or a link from a virtual server is to be provided) . I have been suggested to upload the existing as a sanbox solution. But I want to avoid the overhead to created a sandbox solution.

I have created a SP and using Oracle 11g. I have declared a variable in a procedure as:

v_juriscode billingcycle.juriscode%TYPE;

(an existing type) . . . I have a condition as

IF n_count > 1
THEN
v_juriscode := 'LODESTAR';
ELSE
IF n_count = 1
THEN
SELECT pm.dejuriscode
INTO v_juriscode
FROM pwrline.lsmdphysicalmeter pm
WHERE pm.decommdevid = V_COMMDEVID;
END IF;
END IF;
UPDATE DEBADGERPROGLOG SET JURISCODE=v_juriscode
WHERE UIDBADGERPROGLOG = V_UID;

When the condition c_count = 0 is encountered I have not set the value for juriscode (ie i hv not mentioned that condition). I have noticed that when no value is set to the v_juriscode variable the table row is not updated, I wanted to know why this happens. Thanks in advance.

Lionel Noronha

I have been asked to do so.

I wanted to create a trigger on a table. Whenever an update statement gets executed on the table, the trigger will be fired and a column “UPDATED_DT” of the table will be updated with the current date. i have used the following but it has compilation errors cause with after update i cannot use the new keyword as it is technically incorrect. If works fine when i use BEFORE UPDATE. Could you guide me with this? CREATE OR REPLACE TRIGGER TRG_AU AFTER UPDATE ON X_TABLE FOR EACH ROW BEGIN :NEW.UPDATED_DT := SYSDATE; --error with the new keyboard any other approach END TRG_AU Can someone advice a solution?

when i store the results in the collection while i run the loop. can i save the results into the cursor.

Hi, I am using a SSRS report and the report is generated by executing a stored procedure. The procedure gets 4 input values a,b,c,d where values c and d is a string containing multiple values. I am executing a complex SQL statement. For this i am using nested loop: A as INPUT B as INPUT C as INPUT (String input seperated by ,) D as input (String input seperated by ,) Cursor Cur as OUTPUT Loop for c Loop for d . . execute the above SQL Statement(select query) . . END loop END Loop problem: Now the results of the SQL statement has to be saved temporarily somewhere I am not allowed to use permanent/temporary tables as they require definition at schema level and modificaton of schema is not allowed. I need to save the value in the cursor at each runs, but in that case the previous results get overwritten. So i wanted to know collection objects and wanted to know if that too requires definition at schema level.

Whenever we create either permanent table or temporary tables it requires modification of the database schema. Is the same applicable for Collection objects? ie when we create collection objects does it modify the database schema/metatdata?

Sorry I didnt mention earlier.. I am writing the stored procedure in oracle. I wanted to know if I can use a array and the store the results in the reference cursor which can be pulled by SSRS. but i dont know how to pass the values form array to reference

Just to let you know.I am using this procedure in a package. Where should I write the temp table declaration?

Hi, I am using a SSRS report and the report is generated by executing a stored procedure. The procedure gets 4 input values a,b,c,d where values c and d is a string containing multiple values. I am executing a Complex SQL statement for all values of c and d. For this reason i am using nested loop:

A as INPUT
B as INPUT
C as INPUT
D as input
Cursor Cur as OUTPUT

Loop for c
	Loop for d
		execute the SQL Statement(select 
	END loop
END Loop

problem:
Now the results of the SQL statement has to be saved temporarily somewhere I am not allowed use permanent tables and I m struglling using temporary tables.
If i save the value in the cursor each time the loop runs the previous results get overwritten.

I figured out another way... i wanted to store a particular value from a database column into a session variable.. Anyways thanks..

HI i have successfully created a connection string and the rest of the commands are as follows Dim cmd As New SqlCommand(sql, SQLConn) cmd.Connection.Open() Repeater1.DataSource = cmd.ExecuteReader() Repeater1.DataBind() cmd.Connection.Close() The above code works fine.. My doubt is that how to i get to store all rows of a column returned by a Repeater in a session variable.... Can do tht using a SQldatareader as: Session("SessionName")=readerobj("uid")

I m using SQldatasource control to get the database table.. so would require a code accordingly

I wanna enable paging repeater control. hOw do i do tht..?

Still awaiting some favorable replies.... i wanna some rough technical ideas on how to achieve this. Each member can have his own blog in a portal.

i have already checked that . its a source code for creating a blog. i wanna know if i can create a blog for each user in my site. As in when a user registers in the portal. A blog should be created in his account automatically. ie a personalized blog for each member.

I want to create a portal in asp.net as a part of my BE engineering project. I am in the initial stages of documentation. One of the modules creating personalized pages for each member with blog facility, personal details and photo gallery. A blog will be created for each user in the portal and they can post articles and stuff on their blog and other members can view their profile and the blog.... I wanna information on that on which asp.net technology can be used and whether it is possible or not.. I am sure it can be done but just need information on the same. Please let me know.... Thanks

When we compile a C/C++ program we get the object code. Now my doubt is : When the object code is executed after transferring into the main memory what is it : 1. Is it a PROGRAM or 2. IS it a process.... I got really confused today in my vivas today cause of my examiner....