Click here to Skip to main content
12,295,791 members (45,152 online)
   

ASP.NET

 
GeneralRe: asp.net 4 with sql server 2008 Pin
lillain2199-Oct-12 21:47
memberlillain2199-Oct-12 21:47 
Questiongridview rowupdating in ascx file Pin
jhyn7-Oct-12 20:13
memberjhyn7-Oct-12 20:13 
AnswerRe: gridview rowupdating in ascx file Pin
Sarvesh Kushwaha8-Oct-12 5:23
memberSarvesh Kushwaha8-Oct-12 5:23 
Question'System.Web.HttpUnhandledException' Error Pin
rattlesnake3167-Oct-12 17:55
memberrattlesnake3167-Oct-12 17:55 
AnswerRe: 'System.Web.HttpUnhandledException' Error Pin
Eddy Vluggen8-Oct-12 0:50
memberEddy Vluggen8-Oct-12 0:50 
AnswerRe: 'System.Web.HttpUnhandledException' Error Pin
Joshua Omundson9-Oct-12 6:50
memberJoshua Omundson9-Oct-12 6:50 
QuestionIntegrate SharpWebMail in existing project Pin
Soni19856-Oct-12 8:44
memberSoni19856-Oct-12 8:44 
QuestionThe 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Pin
Ali Al Omairi(Abu AlHassan)6-Oct-12 5:38
memberAli Al Omairi(Abu AlHassan)6-Oct-12 5:38 
AnswerRe: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Pin
ProgramFOX6-Oct-12 7:00
memberProgramFOX6-Oct-12 7:00 
GeneralAccess Database Engine 2010 Redistributable is not intended Pin
David Mujica8-Oct-12 2:56
memberDavid Mujica8-Oct-12 2:56 
GeneralRe: Access Database Engine 2010 Redistributable is not intended Pin
n.podbielski9-Oct-12 0:28
membern.podbielski9-Oct-12 0:28 
AnswerRe: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Pin
Murugan_vdm14-Oct-12 3:22
memberMurugan_vdm14-Oct-12 3:22 
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 
Questionweird problems: nothing is happening!! Pin
jrahma5-Oct-12 6:50
memberjrahma5-Oct-12 6:50 
AnswerRe: weird problems: nothing is happening!! Pin
jkirkerx5-Oct-12 8:43
memberjkirkerx5-Oct-12 8:43 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma5-Oct-12 9:36
memberjrahma5-Oct-12 9:36 
AnswerRe: weird problems: nothing is happening!! Pin
VijayChauhan1237-Oct-12 20:15
memberVijayChauhan1237-Oct-12 20:15 
AnswerRe: weird problems: nothing is happening!! Pin
Sunil from Pune8-Oct-12 5:27
memberSunil from Pune8-Oct-12 5:27 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma8-Oct-12 6:52
memberjrahma8-Oct-12 6:52 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma8-Oct-12 7:09
memberjrahma8-Oct-12 7:09 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma8-Oct-12 7:10
memberjrahma8-Oct-12 7:10 
GeneralRe: weird problems: nothing is happening!! Pin
Sunil from Pune8-Oct-12 21:06
memberSunil from Pune8-Oct-12 21:06 
QuestionHow to Develop asp.net application to control Time and authenticationfingerprint Device such as get user ID Pin
osama_hagrass5-Oct-12 3:54
memberosama_hagrass5-Oct-12 3:54 
AnswerDevice Pin
David Mujica5-Oct-12 6:20
memberDavid Mujica5-Oct-12 6:20 
GeneralRe: Device Pin
osama_hagrass5-Oct-12 7:25
memberosama_hagrass5-Oct-12 7:25 
GeneralRe: Device Pin
VijayChauhan1237-Oct-12 20:19
memberVijayChauhan1237-Oct-12 20:19 
Questionhow to Run an URL inside a WCF webservice, the URL return a mp3/zip file Pin
findprasad5-Oct-12 3:50
memberfindprasad5-Oct-12 3:50 
Questionworking with menu control in asp.net 2.0 Pin
rimjhim_45-Oct-12 2:21
memberrimjhim_45-Oct-12 2:21 
AnswerRe: working with menu control in asp.net 2.0 Pin
Sandeep Mewara5-Oct-12 2:28
mvpSandeep Mewara5-Oct-12 2:28 
AnswerRe: working with menu control in asp.net 2.0 Pin
VijayChauhan1237-Oct-12 20:21
memberVijayChauhan1237-Oct-12 20:21 
QuestionMVC Pin
JabbarJahambana4-Oct-12 22:52
memberJabbarJahambana4-Oct-12 22:52 
AnswerRe: MVC Pin
Sandeep Mewara5-Oct-12 2:47
mvpSandeep Mewara5-Oct-12 2:47 
QuestionRecording Screen Work Pin
Pawan Mehra4-Oct-12 22:46
memberPawan Mehra4-Oct-12 22:46 
AnswerRe: Recording Screen Work Pin
Sandeep Mewara5-Oct-12 2:30
mvpSandeep Mewara5-Oct-12 2:30 
AnswerCamtasia Studio Pin
David Mujica5-Oct-12 3:15
memberDavid Mujica5-Oct-12 3:15 
GeneralSetUp Projects Pin
Praveen Reddy(ganni)4-Oct-12 21:04
memberPraveen Reddy(ganni)4-Oct-12 21:04 
AnswerRe: SetUp Projects Pin
Sandeep Mewara5-Oct-12 2:32
mvpSandeep Mewara5-Oct-12 2:32 
QuestionSQL Cache Dependency in ASP.NET Pin
hiredotnet4-Oct-12 20:54
memberhiredotnet4-Oct-12 20:54 
AnswerRe: SQL Cache Dependency in ASP.NET Pin
Sandeep Mewara5-Oct-12 2:38
mvpSandeep Mewara5-Oct-12 2:38 
GeneralRe: SQL Cache Dependency in ASP.NET Pin
Richard MacCutchan5-Oct-12 2:48
mvpRichard MacCutchan5-Oct-12 2:48 
GeneralRe: SQL Cache Dependency in ASP.NET Pin
Sandeep Mewara5-Oct-12 2:51
mvpSandeep Mewara5-Oct-12 2:51 
QuestionMicrosoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application Pin
Nitin K4-Oct-12 20:35
memberNitin K4-Oct-12 20:35 
AnswerRe: Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application Pin
Sandeep Mewara4-Oct-12 20:49
mvpSandeep Mewara4-Oct-12 20:49 
AnswerRe: Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application Pin
VijayChauhan1237-Oct-12 20:42
memberVijayChauhan1237-Oct-12 20:42 
QuestionDate & Time in ASP.net Pin
bsshowriraju00014-Oct-12 3:27
memberbsshowriraju00014-Oct-12 3:27 
AnswerRe: Date & Time in ASP.net Pin
Wes Aday4-Oct-12 5:30
memberWes Aday4-Oct-12 5:30 
AnswerRe: Date & Time in ASP.net Pin
jkirkerx4-Oct-12 10:06
memberjkirkerx4-Oct-12 10:06 
AnswerRe: Date & Time in ASP.net Pin
Aysha Patel4-Oct-12 21:09
memberAysha Patel4-Oct-12 21:09 

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.160525.2 | Last Updated 26 May 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid