Comments by Member 7781963

Member 7781963 5-Apr-13 4:23am View

Thanks for the answer. Can you please show me the DB Design? I am unable to understand your answer. Thanks.

Member 7781963 2-Jan-13 0:53am View

How to do that? Kindly show me the code.

Member 7781963 30-Dec-12 18:29pm View

i have added a new solution that i am trying now...is that a better solution than the earlier one...and yes i need the row numbers.

Member 7781963 30-Dec-12 18:26pm View

Deleted

<pre lang="SQL">ALTER PROCEDURE [GetHomePageObjectPageWise]
@PageIndex INT = 1
,@PageSize INT = 10
,@PageCount INT OUTPUT
,@whereStoryID VARCHAR(2000)
,@whereAlbumID VARCHAR(2000)
,@wherePictureID VARCHAR(2000)
AS
BEGIN
SET NOCOUNT ON;

WITH Results1 AS
(
SELECT
StoryID,
AlbumID,
StoryTitle,
[AlbumName] = NULL,
[AlbumCover] =
(
SELECT URL
FROM AlbumPictures
WHERE (AlbumID = dbo.Stories.AlbumID) AND (AlbumCover = 'True')
),
Votes,
[PictureId] = NULL,
[tableName] = 'stories',
[Sort] = NEWID()
FROM Stories
WHERE
StoryID IN
(
SELECT StringVal
FROM funcListToTableInt(@whereStoryID)
)
)
, Results2 AS
(
SELECT
[StoryID] = NULL ,
AlbumID,
[StoryTitle] NULL,
AlbumName,
[AlbumCover] =
(
SELECT URL
FROM AlbumPictures AS AlbumPictures_3 --<<<do you="" need="" this="" alias?
="" where="" (albumid="Albums.AlbumID)" and="" (albumcover="True" )
="" ),
="" votes,
="" [pictureid]="NULL,
" [tablename]="albums" ,
="" [sort]="NEWID()
" from="" albums=""
="" albumid="" in="" (
="" select="" stringval="" funclisttotableint(@wherealbumid)
="" )="" ,="" result3="" as="" [storyid]="NULL," [albumid]="NULL,
" [storytitle]="NULL,
" [albumname]="NULL,
" url,
="" pictureid,
="" albumpictures="" --as="" albumpictures_1="" <<<do="" pictureid="" funclisttotableint(@wherepictureid)
="" result4="" *="" results1="" union="" all
="" results2="" results3
="" results="" as
="" [rownumber]="ROW_NUMBER()" over="" (order="" by="" desc),
="" x.*="" results4="" x
="" results
="" rownumber="" between(@pageindex="" -1)="" @pagesize="" +="" 1="" and(((@pageindex="" 1)="" @pagesize)="" -="" 1;
="" declare="" @recordcount="" int="@@RowCount;"

="" set="" @pagecount="CEILING(CAST(@RecordCount" decimal(10,="" 2))="" cast(@pagesize="" 2)));

end<="" pre="">

Member 7781963 30-Dec-12 18:19pm View

you mean remove #Results1,#Results2 and #Results3 ?

Member 7781963 30-Dec-12 18:13pm View

Is there any way i can skip the procedure and do the same thing in dynamic sql?

Member 7781963 14-Dec-12 9:04am View

actually the main reason i am trying to do it in a web method is to avoid post back..any way i can do it in a button click in the code behind without the post back?

Member 7781963 14-Dec-12 8:50am View

Actually when i execute the same code on a button click in the page code behind, it works.

Member 7781963 14-Dec-12 8:42am View

Is there something wrong?

Member 7781963 10-Dec-12 5:14am View

Any link to the converter?

Member 7781963 7-Dec-12 6:09am View

<%@ Page Title="" Language="VB" MasterPageFile="~/Memories/Memories.master" AutoEventWireup="false"
CodeFile="CreateAlbums.aspx.vb" Inherits="Memories_CreateAlbums" %>

Member 7781963 7-Dec-12 6:09am View

Nope. I just selected the master page while creating the content page.

Member 7781963 7-Dec-12 6:01am View

I tried your solution , but i get the Content Page Name(action="Album.aspx") in the action attribute with your solution.

Member 7781963 7-Dec-12 5:45am View

where do i use this script?? Master Page or Content Page??

Member 7781963 7-Dec-12 5:26am View

What is FormName here?

Member 7781963 2-Dec-12 1:28am View

I have tried to hard code it this way data: '{sellReqID:2}' , but still does not work in IE.

Member 7781963 23-Nov-12 6:54am View

we need to write the helper subs in the ordinary, non-lambda form, and then pass them as delegates to ExecuteWithinTransaction

private sub Lambda1 (con as SqlConnection, tran as SqlTransaction)
InsertA("Al", con, tran)
end sub

private sub Lambda2 (con as SqlConnection, tran as SqlTransaction)
InsertB("Bert", con, tran)
end sub

private sub Lambda3 (con as SqlConnection, tran as SqlTransaction)
InsertA("Albert", con, tran)
InsertB("Einstein", con, tran)
end sub

And then

ExecuteWithinTransaction (AddressOf Lambda1)
ExecuteWithinTransaction (AddressOf Lambda2)
ExecuteWithinTransaction (AddressOf Lambda3)

Member 7781963 23-Nov-12 5:36am View

Thanks a lot for your time and effort. + 5. Accepted Answer.

Member 7781963 23-Nov-12 5:24am View

Where do i use the delegate? I mean where does the delegate go?

Member 7781963 23-Nov-12 5:08am View

Tried the new pattern , but no luck.

Member 7781963 23-Nov-12 5:05am View

i am using VS2010 and .NET 3.5 ...but still does not work.

Member 7781963 23-Nov-12 4:43am View

Do i need to import anything?? I get this error "Visual Basic 9.0 does not support this kind of lambda expression" here " ExecuteWithinTransaction(Sub(con, trans) InsertA("Al", con, trans))" when i hover over the Sub

Member 7781963 23-Nov-12 4:40am View

Do i need to import anything?? I get this error "Visual Basic 9.0 does not support this kind of lambda expression" here " ExecuteWithinTransaction(Sub(con, trans) InsertA("Al", con, trans))" for the Sub

Member 7781963 23-Nov-12 4:29am View

Thanks a lot for the detailed explanation. Ummm...the "Sub Main()" and "Sub ExecuteWithinTransaction" should be in the calling(aspx.vb) page , right?
So all i need to do is add two parameters (connection and transaction) to my functions??

Member 7781963 23-Nov-12 2:56am View

Where is the SQL injection??

Member 7781963 23-Nov-12 2:55am View

1. I am calling both the functions : Here i want that if both the functions execute properly then commit.

2. I am calling only one function i.e function 1 or function 2 : Here i want the transaction to be applied to that particular function only.

You see the functions are in business logic layer and i call the functons from different places, so i need the flexibility to pass the transaction parameter depending upon how many functions i want to execute in a single connection.

Member 7781963 6-Oct-12 11:21am View

Any other option similar to netTiers?? I want to automatically generate the Admin Panel as netTiers does like creating the pages with all the relationships.

Member 7781963 1-Oct-12 16:34pm View

I am going through this article http://www.singingeels.com/Articles/Dynamically_Created_Controls_in_ASPNET.aspx

Is it worth it??

Member 7781963 1-Oct-12 16:26pm View

+5

Member 7781963 1-Oct-12 15:36pm View

Thanks a lot for the articles. I always thought that loops take a lot of time and therefore degrade the applications performance. Anyway, how do i place controls dynamically on the page. How do i keep a list of all the controls added to the page, because i will have to fetch the values from the controls added when the user clicks on Save Button. Kindly point me in the right direction.

Member 7781963 1-Oct-12 15:35pm View

Thanks a lot for the articles. I always thought that loops take a lot of time and therefore degrade the applications performance. Anyway, how do i place controls dynamically on the page. How do i keep a list of all the controls added to the page, because i will have to fetch the values from the controls added when the user clicks on Save Button. Kindly point me in the right direction.

Member 7781963 11-May-12 16:34pm View

thanks for the quick reply..can i invoke RSync via System.Diagnostic.Process?

Member 7781963 26-Apr-11 17:56pm View

ya i saw it..but where do i use this code??

Member 7781963 26-Apr-11 17:39pm View

how can i use the Google Contacts Data API??

Member 7781963 26-Apr-11 17:39pm View

i am very new to asp.net...can u help me some more??where should i put these code??or can u provide me a sample tutorial???

Comments by Member 7781963 (Top 35 by date)