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

Srikanth 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...

Srikanth 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.

Srikanth Reddy · Answer

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