I have a query that is displaying all records from the table:
Say:
select * from table1
Now, how my dataset has all 10 rows from the table. I want to display each row records one by one on button Next Button Click.
E.g. is display 1st question and 4 options, then on click of Next button show 2nd question and so on....
How to code for this requirement.
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.
How do I make A, B and D navy blue?
Region
Stuff
Stuff
tried this just for one of the cells but it's not working what am I missing?
[Code]....
I have a Sql Data Source that queries my class database. What I'm trying to do to save myself some landscape is to check a checkbox if any of the pre-requisite fields are not empty. I have this laying inside a gridview. My code doesn't error out but it doesnt' do anything either.
[Code]....
My query is like this:
[Code]....
So in a nutshell, if there is any value in PR1 - PR7, I want to check my checkbox in the gridview.
I have a requirement where i have to read data from a CSV file which is stored in my disk and put all the data in the CSV into a .Net DataTable.
View 10 Repliesi 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 have 7 different category pages and although the Cart Page shows selected items From the 1 category , when i select other category page it only shows the selections of first page and not the others.
How can i make the DataTable Draw values from all the pages and display them on the Cart? code in first category
[Code]....
i m trying to put the same in each category but it doesn'twork
I had a problem in binding the checkbox list. Here I explain I had a database with 3 columns.
ex:
address     name   number
bangalore    seker    987585
mangalore   shankar  658741
bangalore    kanna    589725
Now I have select the bangalore in address,so i may get seker and kanna.
And now i have display in my page as like this to checkbox.
seker                  Â
987585 Â Â Â Â Â Â Â Â same kanna sholud be displayed.
that is, the seker should be in label and the number should be in checkbox.
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 have a datatable to bind the gridview in my page. now i need to have a export button in near gridview, if we click the button then the gridview values (datatable) to excel.
View 3 RepliesI have gridviwe having 2 columns:
1) DocNumber 2)Title
query select docnumber,title from tbl_docs.
BindwithGridviwe(sql);
Now the issue is that that every document doesn't has document number. I want to make invisible the docuNumber column of the grid viwe if all values in the docNumber retrieved are null.for example:
docnumber tite
null Document 1
null Document 2
null doucment 3
null document 4
if returned result match above where all docnumber are null then make the gridviwe docnumber column ivisible eslemake the greidviwe column visible.
Snap shot of asp code
<Columns>
<asp:BoundField DataField="DeptarmentID" HeaderText="DeptarmentID" ReadOnly="true" />
<asp:BoundField DataField="DepartmentCode" HeaderText="DepartmentCode" />
<asp:BoundField DataField="DepartmentName" HeaderText="DepartmentName" />
<asp:BoundField DataField="Active" HeaderText="Active" />
</Columns>
snap shot of page behind
protected void GridViewDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridViewDept.Rows[GridViewDept.EditIndex];
string code = ((TextBox)(row.Cells[2].Controls[0])).Text;
string name = ((TextBox)(row.Cells[3].Controls[0])).Text;
bool active =((TextBox)(row.Cells[4].Controls[0])).Text=="True"?true:false;
//bool active = ((CheckBox)(row.Cells[4].Controls[0])).Checked;
int id = System.Convert.ToInt32(row.Cells[1].Controls[0]);
}
I get error on the last line stating out of index error, how do get the value which is not set editable in the gridview
i have a column named POINT.. it is the point in every question... therefore i want to get the total of this column..
View 3 Repliesprotected void Button1_Click(object sender, EventArgs e)
View 3 RepliesI need to validate and read edited values from a gridview. Here is the scenario,I have a gridview which has two columns Iteam name and Item Rate. Number of rows are dynamic depending on the user. I get the Text boxes filled with DB data.
I need to do this,
1) Validate if the user has entered numeric using front end validation
2) Read the edited values by user for each row and insert into the database in server side
Below is the gridview Source I have
[Code]....
I am unable to read gridview contents
Please try to guide me how to achieve this one. my application need to do reading the PDF document and want to store the values in Database.Actually what happens is my customers sends me the OCR scanned copied in the form of PDF file. i need to read those scanned pdf files and store the customer information into my table.
View 1 RepliesHow to allow null value on my program?
for below statement, "WARNING_TYPE" IS NULL..
but when I run, it promp me error..what are the correct statement should i write. tq all
l_Connection.ConnectionString = constr
l_Command.Connection = l_Connection
l_Command.CommandType = CommandType.Text
l_Command.CommandText = " SELECT UNP.EMPLOYEE_ID, UNP.UNPAID_DAYS, ABST.ABSENT_DAYS, WARN.WARNING_TYPE " +
[code].....
I need to force SSL when going to the final checkout page (for example from default.aspx to checkout.aspx).
I need to pass variables to this check out page and tried to use server.transfer(https://www.mydomain.com/checkout.aspx). I then use previous page .Fincontrol to read text box and label name to this check out page. If I only do the server.transfer("~/checkout.aspx") then my I can read all vakues of my controls from the passing default.aspx page.
But when I force https:// then I cannot read the control values from default.aspx page.
Please give me some tips on how to get control values to the https:// destination page or if you have another tips on how to do it the right way, please let me know.
This was working fine and then I was tinkering around and I can't figure out what I did to break it. When I stepthrough the debugger, the for each stmt cannot read values from the radiobutton list or the textbox, it only show "" for each. I double checked the id names between the code behind and the markup.
[Code]....
[Code]....
I am using vs2008, Sqlserver2008.
my table: PostGL having data like thi
AutoIdx TxDate Id AccountLink Description Debit Credit
3 2010-01-22 JL 2 bcb 0 35.09
5 2010-01-28 JL 2 g 3.51 0
select AutoIdx,TxDate,Id,AccountLink,Description,Debit,Credit,(Debit-Credit) as Actual from PostGL where Id='JL' and AccountLink=2
AutoIdx TxDate Id AccountLink Description Debit Credit Actual
3 2010-01-22 JL 2 bcb 0 35.09 -35.09
5 2010-01-28 JL 2 g 3.51 0 3.51
I am trying in view like this
declare @cnt int
declare @i int
set @budget=20
set @cnt= (select COUNT(*) from PostGL where AccountLink=2 )
set @i=1
WHILE (@i<=@cnt )
BEGIN
set @tdebit=??
END
I am taking count the no of rows having AccountLink=2
I need to read all debit,credit and add all debit into totaldebit,all credit into totalcredit independently from table.
then i need to show the totaldiff as Actual.
i need ....totaldiff=totaldebit-totalcredit
i have a gridview, and i want to be able to click on a product, which then redirects me to another page showing me the details of that product.
View 2 RepliesHow can i read multiple textbox values inside gridview? as well as getting the specified row id?
View 3 RepliesI get a dataset from the OleDbDataAdapter for a query.I need to modify some the contents in the datatable.The first column is a date field which repeats. I want to delete the duplicates so that it looks like a group by column.I tried the following
1) Trying to modify the dataset looping through it. I get an error that dataset is read only
2) Cloned the dataset and tried to modify that rows. I get an error Column 'Entered_Date' is read only
I have a GridView which is linked to the database via SqlDataSource.
What I would like to do is to make each row of a designated column clickable. Once the user has clicked on a row, the application should postback to another page to allow the user to read all the details of that row.
The effect should be as we can see in this post: if you go to "mypost", you have a list of posts and then when you click on one of them you are able to see the details of that.
I read lots of posts that are using, however, other methods such as datalist + dataset controls etc.
I'm how do I read the posted data. e.g. startRow in the aspx code behind page. Here is the ajax
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default2.aspx/GetPageLinks",
data: "{isbn: '" + startRow + "'}",
dataType: "json",
success: function(msg) {
DisplayReviews(msg.d);
}