For online exam

Question

GoodAfternoon Sir,                                      I have a query regarding a online exam project. could you please suggest me     if i have a 50 question and 4 option for each of the questions. then how will i show only 5 question and     there respective option on one panel. after that when i click on next button I'll go on for further 5 question    so please suggest me a right way

ajaz ansari · Answer

Sir i want to generate a dynamic panel for show the first 5 questions from the database
when user click on next button we get a new dynamic panel where it shows other 5 questions
i could not get the concept for dynamic panels
how to do plz suggest me

ajaz ansari · Answer

sir i know how to generate dynamic panel.
but my question is how to get first five data from database into panel .
after that when i click on next button this panel will update with other 5 question of database

Upendra Pratap Shahi · Answer

use paging for this .  code behind-   void BindRepeaterPage(int pageno) { DataTable dt = new DataTable(); PostThread post = new PostThread(); int _TotalRowCount = 0; int parTotalCount; //int startRowNumber = ((pageno - 1) * pageSize) + 1; //int lastRowNumber = startRowNumber + (pageSize - 1); //dt = post.ReturnPageWiseArticle(Convert.ToString(startRowNumber),Convert.ToString(lastRowNumber),out parTotalCount); dt = post.ReturnPageWiseArticle(pageno, pageSize,"", out parTotalCount); _TotalRowCount = Convert.ToInt32(parTotalCount); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i { dt.Rows[i]["coTags"] = dt.Rows[i]["coTags"].ToString().Replace('#', ','); } rptArtticle.DataSource = dt; rptArtticle.DataBind(); generatePager(_TotalRowCount, pageSize, pageno); } } else { rptArtticle.DataSource = null; rptArtticle.DataBind(); } }   public void generatePager(int totalRowCount, int pageSize, int currentPage) { int totalLinkInPage = 10; int totalPageCount = (int)Math.Ceiling((decimal)totalRowCount / pageSize); int startPageLink = Math.Max(currentPage - (int)Math.Floor((decimal)totalLinkInPage / 2), 1); int lastPageLink = Math.Min(startPageLink + totalLinkInPage - 1, totalPageCount); if ((startPageLink + totalLinkInPage - 1) > totalPageCount) { lastPageLink = Math.Min(currentPage + (int)Math.Floor((decimal)totalLinkInPage / 2), totalPageCount); startPageLink = Math.Max(lastPageLink - totalLinkInPage + 1, 1); } List pageLinkContainer = new List (); if (startPageLink != 1) pageLinkContainer.Add(new ListItem("First", "1", currentPage != 1)); //for prev button if (currentPage > 1) pageLinkContainer.Add(new ListItem("Prev", (currentPage - 1).ToString(), currentPage != 1)); //end for (int i = startPageLink; i { pageLinkContainer.Add(new ListItem(i.ToString(), i.ToString(), currentPage != i)); } //for next button if (currentPage pageLinkContainer.Add(new ListItem("Next", (currentPage + 1).ToString(), currentPage != totalPageCount)); //end if (lastPageLink != totalPageCount) pageLinkContainer.Add(new ListItem("Last", totalPageCount.ToString(), currentPage != totalPageCount)); dlPager.DataSource = pageLinkContainer; dlPager.DataBind(); } protected void dlPager_ItemCommand(object source, DataListCommandEventArgs e) { try { if (e.CommandName == "PageNo") { if (txtSearchPost.Text == "") { BindRepeaterPage(Convert.ToInt32(e.CommandArgument)); } else { SearchWikiData(Convert.ToInt32(e.CommandArgument)); } } }//end try catch (Exception ex) { //your code } }  ASPX page-   OnItemCommand="dlPager_ItemCommand"> ' runat="server" ID="lnkPageNo" Text=' ' CommandArgument=' ' CommandName="PageNo">     SP-     create SP for paging and send page number, page size and get count in output parameter      also see below link-   http://www.dotnetbull.com/2013/05/populate-custom-pagination-for-databind.html

Sreekanth Reddy · Answer

Dynamic panel creation:   Panel Panel1= new Panel(); Panel1.Controls.Add();
more brief:(adding textbox in dynamic panel). Panel p = new Panel(); TextBox t=new TextBox(); p.Controls.Add(t); Form.Controls.Add(p);
If still doubts feel free to ask.   ---------------------------------------------------------------------------------------------------- If it help you, please accept. Thank you.

ajaz ansari · Answer

Sir i want to generate a dynamic panel for first 5 questions when user click on next button we get a new dynamic panel where it shows other 5 questions i could not get the concept for dynamic panels how to do plz suggest me and thanks for reply...

Sreekanth Reddy · Answer

By using paging concept: First call retrieves 5 questions, -->In the next call we will pass the last column id number, such that it retrieves next 5 questions.  Example: DECLARE @PageNumber AS INT , @RowspPage AS INT
SET @PageNumber = 2
SET @RowspPage = 5 SELECT * FROM (
SELECT ROW_NUMBER () OVER ( ORDER BY ID_EXAMPLE ) AS NUMBER ,
ID_EXAMPLE , NM_EXAMPLE , DT_CREATE FROM TB_EXAMPLE
) AS TBL
WHERE NUMBER BETWEEN (( @PageNumber - 1 ) * @RowspPage + 1 ) AND ( @PageNumber * @RowspPage )
ORDER BY ID_EXAMPLE  Call this function in Next button click.   For more on paging concept: http://social.technet.microsoft.com/wiki/contents/articles/23811.paging-a-query-with-sql-server.aspx     ------------------------------------------------------------------------------------------------- Please accept the answer if its useful to you. Thank you.

Sreekanth Reddy · Answer

-->use paging concept in sql server for getting 5 Questions for each call.