Click here to Skip to main content
12,944,475 members (51,617 online)
   

ASP.NET

 
QuestionRandomize Data of Groupboxes Pin
ASPnoob5-Oct-12 23:38
memberASPnoob5-Oct-12 23:38 
AnswerRe: Randomize Data of Groupboxes Pin
VijayChauhan1237-Oct-12 20:10
memberVijayChauhan1237-Oct-12 20:10 
Hi Dear,
I have worked on this type of project...
The following is the stored procedure you can use for randomly getting the questions as well as the random options (answers) from the database.
This stored procedure covers almost your 80% of the work, only the thing is you have to bind it to the gridview . If you have any doubts in this you can comment.


//////////////////////////////////////////////////////////////////////////////////////
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER
Procedure [dbo].[GetRandomOptionsold]
(@class varchar(max),
@Subject varchar(max),
@ExamType varchar(max),
@School varchar(max)
)
 
as
 
Begin
 
Create
Table #Options(ID int identity(1,1),Fields nvarchar(10))
 
Insert
into #Options
 
Select
COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME='Questions' And COLUMN_NAME like 'O%' Order By NEWID()
 
--Select * from #Options
 
Declare
@RandomCols nvarchar(100)
 
Set
@RandomCols=''
 
Select
@RandomCols=@RandomCols+Fields+' ,' from #Options
 
--Select @RandomCols
 
Set
@RandomCols=(Select REPLACE(Substring(@RandomCols,0,CHARINDEX(' ,',@RandomCols)+2),' ,',' as O1,')
 
+
SUBSTRING(@RandomCols,CHARINDEX(' ,',@RandomCols)+2,LEN(@RandomCols)))
 
--Select @RandomCols
 
Set
@RandomCols=(Select REPLACE(Substring(@RandomCols,0,CHARINDEX(' ,',@RandomCols)+2),' ,',' as O2,')
 
+
SUBSTRING(@RandomCols,CHARINDEX(' ,',@RandomCols)+2,LEN(@RandomCols)))
 
--Select @RandomCols
 
Set
@RandomCols=(Select REPLACE(Substring(@RandomCols,0,CHARINDEX(' ,',@RandomCols)+2),' ,',' as O3,')
 
+
SUBSTRING(@RandomCols,CHARINDEX(' ,',@RandomCols)+2,LEN(@RandomCols)))
 
--Select @RandomCols
 
Set
@RandomCols=(Select REPLACE(Substring(@RandomCols,0,CHARINDEX(' ,',@RandomCols)+2),' ,',' as O4,')
 
+
SUBSTRING(@RandomCols,CHARINDEX(' ,',@RandomCols)+2,LEN(@RandomCols)))
 
--Set @RandomCols=SUBSTRING(@RandomCols,0,len(@RandomCols))
 
--Select @RandomCols
 
Declare
@strQry nvarchar(MAX)
 
Set
@strQry=''
 
Set
@strQry='Select qno,que,'+@RandomCols+'ans from Questions where Class='''+@Class+''' and Subject='''+@Subject+''' and ExamType='''+@ExamType+''' and School='''+@School+''''
 
exec
(@strQry)
 
End
 

//////////////////////////////////////////////////////////////////////
AnswerRe: Randomize Data of Groupboxes Pin
VijayChauhan1237-Oct-12 20:46
memberVijayChauhan1237-Oct-12 20:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 23 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid