DataSource Controls :: Making A Quiz System in .net Using C# vs 2008
Dec 20, 2010
i am making a quiz system in asp.net using C# vs 2008.having one equestion per page,with previous and back button.each question have four options with only one correct answer.The options are in a radio button list.I have a database which has two columns as QuestionID,CorrectAnswer.
For viewing previous answer the user can click on previous button,so that he can see his previous marked answer and if feel he had marked the wrong option then he can mark the other one.
Some Problems:-when clicking the previous button the option which was marked in radio button list got unchecked!!So,the user is unable to know which he/she had marked before.I want that the option remains checked so that the user knows what he/she had marked previously.After completing the quiz how can the answers selected by the user be compared with the CorrectAnswer stored in database and can be displayed in the result page having four columns as QuestionID,CorrectAnswer,UserAnswer,Right/Wrong in a grid view. Though i am able to display the QuestionID and the CorrectAnswer in a grid view in the result page.
i am making a quiz system in asp.net using C# vs 2008.having one equestion per page,with previous and back button.each question have four options with only one correct answer.The options are in a radio button list.I have a database which has two columns as QuestionID,CorrectAnswer.
For viewing previous answer the user can click on previous button,so that he can see his previous marked answer and if feel he had marked the wrong option then he can mark the other one.
Some Problems:-
when clicking the previous button the option which was marked in radio button list got unchecked!!So,the user is unable to know which he had marked before.After completing the quiz how can the answers selected by the user be compared with the CorrectAnswer stored in database and can be displayed in the result page having four columns as QuestionID,CorrectAnswer,UserAnswer,Right/Wrong in a grid view.Though i am able to display the QuestionID and the CorrectAnswer in a grid view in the result page.
I want the same solution like Making A Cool Login System With PHP, MySQL & jQuery But in ASP.Net 3.5, SQL Server 2008 and jquery.
I want this solution for my ASp.Net(C#) site in which I'm using ASP.Net's default membership module and now I want to put its loginview and registaration system in a jquery modal windows and validate the user in the system and create the new user in the sytem by entering user credentials in the loginviews and registaration fields inside the modal windows and then by clicking on the button palced in the modal windows as well.
I am attempting to use SqlBulkCopy to import data from an XML document. I receive the following error when executing WriteToServer: Invalid cast from 'System.String' to 'System.Guid'
HDSK_AUTO HDSK_ID HDSK_CASEDESC 1 TC1 pc spoil 2 TC2 problem Action table: ACT_AUTO ACT_HDSK_ID ACT_DATE ACT_TIMEIN ACT_TIMEOUT ACT_ACTIONS ACT_STATUS [code]...
How do I go about doing this in SQL? I need to return 3 columns: ID, the stuff combined into a single field, and the latest status of each ID. (by latest I mean the most recent entered record's ACT_STATUS. this could be based on the ACT_AUTO I think, which is the auto-increment number)
I have a database table column consisting of text URLs [URL] In my LINQ-to-SQL-driven gridview, I want to make this a clickable link programmatically, with differing link text (e.g. "Link text"). I'm getting close but am missing some key concept. Here's the core of the .vb codebehind:
Dim dctx As New ResourceMod.ResourceModDALDataContext Dim eleResObj = From eleRes In dctx.Resources Where eleRes.Type = "url" Select siteurl = eleRes.Website GridView1.DataSource = eleResObj GridView1.DataBind()
This displays the raw URL in the gridview (i.e. non-clickable). I've experimented with adding an explicit hyperlink column a la [URL](setting AutoGenerateColumns false etc.), but haven't yet figured out how to assign the asp:hyperlink Text and NavigateUrl fields with the anonymous-type object eleResObj. Using a field construct such as Text='<%# Eval("siteurl") %>' isn't working, presumably a scope issue. Is a LinqDataSource needed in this case, and if so, how would that affect the original LINQ query?
Protected Sub grdData_DataBound(ByVal sender As Object, ByVal e As EventArgs) Handles grdData.DataBound grdData.Rows(0).Style.Add(HtmlTextWriterStyle.FontWeight, "Bold") End Sub
This code makes the first row bold , but I want to make the row of every gridview new entry bold.
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
I want to do paging the API Membership without using the datacontrols, but I get this error "Unable to cast object of type '<TakeIterator>d__3a`1[System.Char]' to type 'System.Collections.IList'." when I do this,
in my web project i got an error that i couldnt find any solution. the error says: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. when i work in local there were no problem i put files to our server and i changed the database also. when i work in server in web application in Default.aspx i can connect db and get values without any problem using my DataLibrary
BUT the problem in my web service i also use my DataLibrary in webservice but when i try to run a method in web service it gives me the error which is : System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
When i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
Well I have recently been working with profiles and its been going well. When I load my website within Visual Studio it created an MDB within app_data called aspnetdb.mdb and from then on it uses this database to store data that my users have chosen or entered. When I upload the website it fails because it can't find or create the database above. (even if I upload the mdb that was created on my local machine) I have tried to resolve this issue by changing my web.config file as below
I also made an SQL database on the server called totallyu_profiles and set up a user for it. I can connect to that database by using ODBC on my local machine. I can't however upload my current database created by Visual studio to the totallyu_profiles database so it is empty, I was wondering if it will fill the tables itself when the connection string is okay. One other thing to note is that my site errors very quickly with the above connection string and if I don't include the string and use the default then it takes ages. Can I somehow just point the connection string to my database within App_Data?
I am trying to write a table output from SQL database to a gridview/ Data List through an Object Data Source. I am a new starter and your help will be useful.
public List<Staff> GetStaff() cmd.CommandType = SqlConnection con = new SqlConnection(connectionstring);SqlCommand cmd = new [code]...
I need to implement simple quiz in asp.net that displays question, its options and user can answer these questions by checking options and submit the result.
I think ListView is the best control to implement in a way that each Item is question and I need to display Option of the question using check box list.
In ItemTemplate, how can I specify such condition that give me the list of options to select for the user for the particular question in the same row. Just like this:
1. Question Text goes here: (Options to select for the user)checkbox1 goes here; checkbox2 goes here
2. Question Text goes here: (Options to select for the user)checkbox1 goes here; checkbox2 goes here and so on
I am using System.Linq.Dynamic to create the following query at runtime:
[Code]....
I can then successfully display vMediaQ in a GridView.But I need to be able to access the individual fields (column headers and data) in vMediaQ, which is of type System.Linq.IQueryable.
I'm doing a bulk insert to a sql server and when I do so, the SQL server connection string I have is logged in as admin, but when I press the "submit" button I'm getting this error. The file that I'm trying to open is in a folder with admin read/write access and as I said the SQL connection string is for the admin account. Anyone have any idea what causes this?