Asp.net - Pulling Data Into A RadioButtonList Including Randomizing ?
Jan 16, 2012
This is in ASP.net iwth VB.I have a quiz project that I've been assigned for work.This quiz project contains two main SQL Databases it pulls the info from. First is a Quiz table, which contains three columns: QuizID (Pri Key), Title, Description. This is where I declare the quizzes, indicated by the QuizID (1, 2, 3....etc)
The second table is the Questions table, containing the following columns: QuestionsID (Pri Key), Title, Answer1, Answer2, Answer3, Answer4, Answer5, CorrectAnswer, QuestionOrder, QuizID....The QuizID in the Quesitons table matches the QuizID in the Quiz table.Thus for QuizID = 1, it consists of all the questions with the matching QuizID in the Questions table. The CorrectAnswer I want to assign a simple value (1, 2, 3...etc).I need a way to take a set of questions (based on the QuizID) put them in some sort of table and randomize them (or rather shuffle them) so that each time this quiz is taken, it pulls all questions randomly, but not repeating any)...I then want the code to pull the question and coorepsonding answers to pick from in a radiobuttonlist. However, It only needs to pull the number of answers. Example, a True/False will only have Answer1 and Answer2. The other Answers will have the NULL value in it.
There needs to then be a way to go through each one of these questions that have been placed in the table (in that random order) using a "next" button. When a question and possible answwers are displayed, I alaready have code to keep the answers in the session to grade it at the end (using correctAnswer and selected answer.I have no specific way to bind the data to the Database. I have used SQLDataSource to make other connections before, but I don't know if this is the best way.
View 1 Replies
ADVERTISEMENT
Jul 6, 2009
I'm trying to pull data from a PDF to run calculations.What would be the best way to approach this?
View 7 Replies
Jun 9, 2010
here's what I'm doing. I'm putting together a program that will allow employees that work under me to all submit shift reports in the same format instead of getting multiple different formatted text files.
I have a list box that they add "actions" they've performed throughout the day. It's populated by a combo box and some text boxes.I've got it all functioning minus one aspect...
[Code]...
Here's my problem... it's only outputting the FIRST set of items. The "Upgraded" accounts all list but the "Downgraded" and "Canceled" are not there.In a perfect world, I wouldn't ever need to worry about "Canceled" or "Downgraded" but... the world isn't perfect so,
View 1 Replies
Feb 24, 2009
I have a table in my SQL DB that contains :- ID- Date From- Date ToI then have a SQL function that pulls out the Start Date (See code below)
View 1 Replies
Jul 21, 2009
database name = DataTable
Pulling data from Access database in .net?
View 3 Replies
Apr 6, 2011
I am trying to pull wind direction, temperature and speed, data from this webpage, I have had not much success with it at all, I think that I have the correct method but get stuck on the HTML coding. the webpage is: [URL] I sort of know how to get to the HTML code, but get lost on how to define the ellements that are required. I have a screen capture of where I get up to.
View 1 Replies
Jul 21, 2009
I was wondering which way would be the easiest in VS2005 to connect to and pull data from a MS SQL database. I have already setup the database connection by choosing the datasource for a DataGridView but I'm not able to retreive any information.
The steps I have taken so far:
1. Make new form
2. Drag and drop DataGridView onto the form
3. Setup the data source and respective username password
Not sure where to go from here....
View 1 Replies
Feb 5, 2010
I am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim SearchPatient As String = txtNPatientID.Text
[Code].....
View 2 Replies
Sep 11, 2009
I just got put on a new project to design an app that will retrieve data from an excel data sheet that holds information from our VoIP server's call log. Conveniently, this call log is stored in a fixed location on the local drive that this app will be running on. After working on this for a bit, I knew right away I'm going to need someone smarter than I am...I got to the point where I can show data but heres the issue : Every time I am retrieving the date it shows it as, "08/27/2009 12:00:00 AM", how do i remove the unrelated time stamp? Here is my code in Visual Basic 2008 Express Edition:
Public Class Form1
Dim cn As System.Data.OleDb.OleDbConnection
Dim cmd As System.Data.OleDb.OleDbDataAdapter
Dim ds As New System.Data.DataSet()
[Code]...
View 3 Replies
Jul 14, 2010
When it is installed on a machine, it will run for all users. But for some users, it is unable to get some data from the database. I have found out that if it is run-as either administrator,or in winxp compatibility mode, it works. But if not, then some users have the problem.The database is in the same C: drive location as the exe, and it doesn't change from user to user.The computer is using windows 7 professional 32-bit.
View 4 Replies
Apr 2, 2010
I am trying to pull sql data into a text file. The code works just fine, until some new data comes in from lazy employees and a couple fields (used for notes/comments) are now left blank. Originally I've never seen them blank so I didn't think anything of it.
col2 = myreader.GetString(1)
It will error if the field is ever null - I even tried using a case when:
case when note is null then '" & empty & "' else note end and set the variable emtpy = '', but vb still thinks that it's null and errors?
View 6 Replies
Jun 3, 2010
I have a PHP Page that displays airport information in a list in the following order
[code...]
Using that delimited method of ";" then a break, how can i put all of those into a combo box. There are a few hundred.
View 1 Replies
Jan 15, 2012
I generate a print preview, the only thing is, if there is enough data to fill like 2-3 pages I don't know how to generate a new page. It only fills the first page and that's it....
Private Doc As New PrintDocument()
Private Sub btnPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnPrint.Click[code].....
most of the code it's just pulling data from database and printing necessary charges to the invoice, but if the invoice is more than 1 page then I don't know what to do because it only generates 1 page.
View 2 Replies
Nov 26, 2010
I am working on a project for a local charity to build a library catalogue of their books/music. I have built the main form and database but I would like to include the data they have already collated in excel (over 1000 records) so that it doenst have to be manually input into the finished program.is there an easy way to do this, I tried a cut and paste from excel into the data table in my project but unless I'm doing something wrong it wont let me paste the data into the table.
View 3 Replies
Apr 15, 2012
I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,TimeoutI want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them.[code]
View 2 Replies
Dec 16, 2010
I am wanting to include data in my vb2008 deployment package.I have tried many different ways, but with no success.Even with the "click Once" method, also using the setup method.
View 5 Replies
Sep 13, 2010
In my app I present to the user an option to customize the name of the file that gets produced. The format string the program reads is something like "yyyyMMdd-%1-%2-%3-%4" which the user can customize to his liking. In this case the format of the date is yyyyMMdd and the %1 is the trip number like 1000P, %2 is the origin code like PTTTT, %3 is the destination code like PHYUD, and %4 is a secondary stop code like YYYY123. I'm having problems taking the actual data and formatting into the custom string. I believe its the date format that I'm getting stuck on.
So far I have
sOut = txtFormatPattern.Text
sOut = sOut.Replace("%1", "1000P")
sOut = sOut.Replace("%2", "PTTTT")
sOut = sOut.Replace("%3", "PHYUD")
sOut = sOut.Replace("%4", "YYYY123")
sOut = myDate.ToString(sOut) 'date is July 01, 2007
The output is "20070701-#1000P-PTTTTP12YUD (YYYY123)"
The problem obviously here is my last conversion. The string contains key characters that denote a part of the date specifically in PHYUD. So my question is how can I give my user the flexibility to format the output as they wish and then convert that properly?
View 2 Replies
May 14, 2010
I'm using the following to populate a listbox from a sql server:[code]Is Available returns true (It's a bit in sql) or false - Is it possible to replace this with something shorter, say a checkbox or tick image?Also, is it possible to only display actual data rather than the whole field including empty characters? I have a few nchar(30) fields, the above seems to include all 30 character spaces.
View 4 Replies
Jun 27, 2012
I'd like to give a homework assignment to a person learning VB.NET. I'd like it to use basic inheritance and a variety of data structures including queues, lists, arrays, or stacks in a windows forms application. I was thinking of a pizza-ordering application. This would allow them to utilize some basic inheritance and practice using .NET UI elements.
View 2 Replies
Aug 30, 2010
What is wrong with this code? It is called in groups of four, and always seems to wind up with only two combinations:
[Code]...
It is returning random strings, but it seems to be returning them in a non-random order?
View 3 Replies
Jul 28, 2009
So I have code that will create a picture grid and then alignes them into a collage from left to right.
View 16 Replies
Jul 4, 2010
I was wondering how I could randomize a number between a given min/max and have it displayed in a label. And after it's been randomized in 2 different labels, I want to add these 2 integers (labels).
View 5 Replies
Nov 28, 2011
Below is my code in randomizing numbers in vb 2010 express edition. Error comes out stating that "AppendText is not declared. It may be inaccessible due to its protection level"..
Private Sub BtnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnAdd.Click
Dim x As Integer
Randomize()
For x = 0 To 8
TextBox1 = AppendText(Str(Int(Rnd() * 10)))
Next
[Code] .....
View 3 Replies
May 21, 2009
I am creating a hangman game for a class prject. I have done everything apart from randomising the word that is loaded in. I have tried a few different types of code but just can't seem to get it. I have tried this:
[Code]...
View 2 Replies
Feb 17, 2011
Basically I have 7 labels on a form that I randomize into numbers between 0 and 49. However some of the numbers repeat, like this 1,4,8,14,14,50,12. [Code]
View 2 Replies
May 11, 2010
Basically I have two textboxes.
Textbox1: "(Hey|Hi|Yo)! My name is (John|Linda|Carl)"
Textbox2: Blank
What I want to do is to press a button and transfer the contents of Textbox1 to Textbox2. However, I want it to randomize the result by randomly selecting between the words in the parentheses. Now of course, the contents of Textbox1 are subject to change at any time, so I can't just add code for "Hey", "Hi" and "Yo". I need some sort of system in place that will generate random results no matter what I put in Textbox1. So I guess I have to search the string for "(", note the location and then search for "|" to isolate the characters in between as one word or phrase. Then search for ")" to determine the end of the randomizing and continuing normally until the next "(".
View 8 Replies
Dec 3, 2011
randomizing picturebox location given four points example:i have 4 picture boxes. these boxes should be place at points (145, 190) (210, 190) (290, 190) (37, 190). this will display the pictureboxes at a horizontal line. i'm adding a functionality that when i press spacebar or click a button, these coordinates will be randomized and be assigned to my four pictureboxes just like in text twist but no animations.
View 7 Replies
May 17, 2011
I am building a VB.NET frontend to access an ACCDB backend built with Access 2007/2010. The backend will be on a share and accessed simultaneously by multiple users (5 max for the time being, maybe a dozen or more eventually?).My question is, what is the best way to pull the data for the fastest possible acquisition, manipulation, and updating? I'm thinking that pulling it in, then severing the connection and running all of my queries against in-memory structures would be best; am I wrong in this line of thinking?
Do the "DataRow" objects (e.g. "TicketsRow") maintain a connection to the database? I started in on building custom classes to store the data in memory which would pull from DataRows and then dispose of them, but wasn't sure if this was the best approach. My Access frontend was horrendously slow, which is part of the reason I migrated to .NET. I'm not convinced the app itself was the problem, but this solution should give me far more granular control over how the data is accessed and stored, besides the fact that VB.NET seems orders of magnitude more powerful than VBA.
View 1 Replies
Jan 4, 2010
I have a piece of code that reads in lines of tabbed text. It is a game of who wants to be a millionaire. What I would like to do is get the game to incorporate random questioning.
The format of the text file is as follows:
Which record company did the Beatles create? (tab)Apple Records (tab)Sony (tab)BMG (tab)LiteFM (tab)Apple Records (tab) Which has the highest mountain? (tab)Mars (tab)Ireland (tab)Iceland (tab)America (tab)Mars(tab) With a set amount of lines. I want the program to choose each question randomly and not to repeat the question. I'm not sure how to incorporate it into the code.
Quote:
[CODE].....................
View 1 Replies
Jun 19, 2010
I have a RadioButtonList wich contain 4 radio buttons A,B,C,D
RBQ.Items.Add("A")
RBQ.Items.Add("B")
RBQ.Items.Add("C")
[code].....
View 2 Replies
