如何使用数据库生成纸张 [英] how to generate a paper using database

问题描述

您好我的新问题是如何自动生成一个randome问题，如...我在vb.net 2008中有一个表单，在sqlserver 2005中有数据库....我的问题是我有一个form1，其中使用combobox1 for Modules（（这些是字段）Module_ID，Module_Name），Combobox2用于主题（（这些是字段）Module_ID，Topic_ID，Topic_Name），Combobox3用于类别，其中加载项目如（b1，b2），combobox4用于级别（1 ，2,3）...意味着我想选择模块，主题，类别，级别然后它必须从数据库中读取然后从问题表中选择随机问题哪些字段是（Topic_ID，Question_ID，Question，Image_data，level_ID）及其选项表中的a，b，c等选项，根据使用combobox5（10,20,30,40,50。 ..）和过去所有从vb的下一个形式的工具和数据库中选择数据然后我可以打印该纸...请指导我或prope rly告诉我代码我怎么可能在这...等待回复

Hello my new question is how to generate a randome questions in paper automatically like... i have a one form in vb.net 2008 and database in sqlserver 2005.... my question is that i have a form1 in which using combobox1 for Modules((thease are fields)Module_ID,Module_Name), Combobox2 for topics((these are fields)Module_ID,Topic_ID,Topic_Name),Combobox3 for category in which loading items like(b1,b2) , combobox4 for levels(1,2,3) ... means i want to select module,topic,category,level and then it must read from database then select random question from question table which fields are(Topic_ID,Question_ID,Question,Image_data,level_ID)with its options like a,b,c from Options table which fields are(Question_ID,Option_ID,Description,Answer) read randomly at least 10 questions or more then 10 according to quantity for which using combobox5 (10,20,30,40,50...)and the past it all selected data from tools and database on next form of vb then i can print that paper... please guide me or properly tell me about code how may i work on this ... waiting for reply

推荐答案

http://msdn.microsoft.com/en-us/library/system.random%28v=vs.110%29.aspx [ ^ ]。

使用随机方法获取随机问题列表。上面链接将为您提供有关代码随机方法的帮助。假设您有数组或问题列表所以通过使用随机列表或数组你随机得到10 ..10 ..30问题

例如。



随机randomGenerator = new Random（）;

id =（长）postIds.get（randomGenerator.nextInt（postIds.size（） ））;





让我知道是否有任何问题。

Use random method to get list of random question.above link will give you help regarding to code random method .assume u have array or list of questions so by using random on list or array u get 10 ..10 ..30 question randomly
eg.

Random randomGenerator = new Random();
id = (Long) postIds.get(randomGenerator.nextInt(postIds.size()));


let me know if any prob.

这篇关于如何使用数据库生成纸张的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！