something on class

OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\db\\mydb.mdb");
   string strSql="select * from problem where pub='true' order by type desc";
   OleDbCommand cmd=new OleDbCommand(strSql,conn);
   conn.Open();
   OleDbDataReader dr=cmd.ExecuteReader();
   int i=1;
   while(dr.Read())
   {
       Label mylabel=new Label();
    TableRow Row=new TableRow();
    TableCell Cell=new TableCell();
    string mystr="",typeStr="";
    if(dr["type"].ToString()=="s")
     typeStr="(单选)";
    else
                    typeStr="(多选)";
    mystr+=i.ToString()+dr["title"]+typeStr+"<br><br>";
                mystr+="A、 "+dr["ans1"]+"   B、 "+dr["ans2"]+"    C、"+dr["ans3"]+"    D、"+dr["ans4"];
    mystr+="<br><br>答题";
    mylabel.Text=mystr;
    Cell.Controls.Add(mylabel);
    if(dr["type"].ToString()=="s")
    {
     RadioButtonList radio=new RadioButtonList();
     radio.RepeatDirection=RepeatDirection.Horizontal;
     radio.Items.Add("A");
     radio.Items.Add("B");
     radio.Items.Add("C");
     radio.Items.Add("D");
     Cell.Controls.Add(radio);

    }
    else
    {
     CheckBoxList check=new CheckBoxList();
     check.RepeatDirection=RepeatDirection.Horizontal;
     check.ID="mycontrol"+i.ToString();
     check.Items.Add("A");
     check.Items.Add("B");
     check.Items.Add("C");
     check.Items.Add("D");
     Cell.Controls.Add(check);
    }
    Label mylabel2=new Label();
    if(dr.Read())
    {
     mylabel2.Text="<br><br>";
    }
    else
    {
     mylabel2.Text="<br><br>********************************************************************";

    }
    Cell.Controls.Add(mylabel2);
    Row.Cells.Add(Cell);
    Table4.Rows.Add(Row);
    i=i+1;
   }
   conn.Close();

posted @ 2005-11-02 19:46  Tory  阅读(177)  评论(0编辑  收藏  举报