1、现在只能显示头一个图片,我想让这个图片轮流循环显示。2、cj_counts字段默认值是5,当每次keys.Enter选中的那条记录的时候,这个值-1。当值=0的时候图片就不参加图片轮换不显示了。请问应该怎么写呢?100分求大侠帮忙。
        
        
        if (e.KeyCode == Keys.Enter)
        {
                    timer1.Enabled = false;
                    label1.Visible = true;
                    label1.Text = "恭喜您!抽中了:" + cj_names;   
        }        private void timer1_Tick(object sender, EventArgs e)
        {
            string sql_str = "select * from cj_main";
            SqlConnection conn = new SqlConnection(conn_str);
            SqlCommand command = new SqlCommand(sql_str, conn);
            conn.Open();
            SqlDataReader rs = command.ExecuteReader();
            if (rs.Read())
            {
                cj_names = rs["cj_names"].ToString();
                cj_pic_path=rs["cj_pic_path"].ToString();
                this.pictureBox1.Image=Image.FromFile(cj_pic_path);
            }

解决方案 »

  1.   

    没看到cj_counts字段在哪里与现在的有什么联系。
      

  2.   


    <html><head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
    <meta name="ProgId" content="FrontPage.Editor.Document">
    <title>New Page 1</title>
    <base target=_blank>
    </head><body>
    <script language="JavaScript1.2"> 
    <!-- 
    /*设置下面的参数。 设置scrollerwidth和scrollerheight参数,设置成滚动显示的图片中尺寸最大的。*/
    var scrollerwidth=140
    var scrollerheight=40
    var scrollerbgcolor='white'
    //每个图间暂停3秒。
    var pausebetweenimages=3000
    //边界下面的行,如果希望logo都是带连接的,只要加上<a>标签即可。
    var slideimages=new Array()
    slideimages[0]='<a href="http://www.happydrips.com"><img src="tuxiang_ym_6_1.gif" border=0"></a>'
    slideimages[1]='<a href="http://www.happydrips.com"><img src="tuxiang_ym_6_2.gif"></a>'
    slideimages[2]='<a href="http://www.happydrips.com"><img src="tuxiang_ym_6_3.gif"></a>'
    slideimages[3]='<a href="http://www.happydrips.com"><img src="tuxiang_ym_6_4.gif"></a>'
    //尽管填加更多的。
    //////以下不要修改////////////////
    if (slideimages.length>1)
    i=2
    else
    i=0
    function move1(whichlayer){
    tlayer=eval(whichlayer)
    if (tlayer.top>0&&tlayer.top<=5){
    tlayer.top=0
    setTimeout("move1(tlayer)",pausebetweenimages)
    setTimeout("move2(document.main.document.second)",pausebetweenimages)
    return
    }
    if (tlayer.top>=tlayer.document.height*-1){
    tlayer.top-=5
    setTimeout("move1(tlayer)",100)
    }
    else{
    tlayer.top=scrollerheight
    tlayer.document.write(slideimages[i])
    tlayer.document.close()
    if (i==slideimages.length-1)
    i=0
    else
    i++
    }}
    function move2(whichlayer){
    tlayer2=eval(whichlayer)
    if (tlayer2.top>0&&tlayer2.top<=5){
    tlayer2.top=0
    setTimeout("move2(tlayer2)",pausebetweenimages)
    setTimeout("move1(document.main.document.first)",pausebetweenimages)
    return
    }
    if (tlayer2.top>=tlayer2.document.height*-1){
    tlayer2.top-=5
    setTimeout("move2(tlayer2)",100)
    }
    else{
    tlayer2.top=scrollerheight
    tlayer2.document.write(slideimages[i])
    tlayer2.document.close()
    if (i==slideimages.length-1)
    i=0
    else
    i++
    }}
    function move3(whichdiv){
    tdiv=eval(whichdiv)
    if (tdiv.style.pixelTop>0&&tdiv.style.pixelTop<=5){
    tdiv.style.pixelTop=0
    setTimeout("move3(tdiv)",pausebetweenimages)
    setTimeout("move4(second2)",pausebetweenimages)
    return
    }
    if (tdiv.style.pixelTop>=tdiv.offsetHeight*-1){
    tdiv.style.pixelTop-=5
    setTimeout("move3(tdiv)",100)
    }
    else{
    tdiv.style.pixelTop=scrollerheight
    tdiv.innerHTML=slideimages[i]
    if (i==slideimages.length-1)
    i=0
    else
    i++
    }
    }
    function move4(whichdiv){
    tdiv2=eval(whichdiv)
    if (tdiv2.style.pixelTop>0&&tdiv2.style.pixelTop<=5){
    tdiv2.style.pixelTop=0
    setTimeout("move4(tdiv2)",pausebetweenimages)
    setTimeout("move3(first2)",pausebetweenimages)
    return
    }
    if (tdiv2.style.pixelTop>=tdiv2.offsetHeight*-1){
    tdiv2.style.pixelTop-=5
    setTimeout("move4(second2)",100)
    }
    else{
    tdiv2.style.pixelTop=scrollerheight
    tdiv2.innerHTML=slideimages[i]
    if (i==slideimages.length-1)
    i=0
    else
    i++
    }}
    function startscroll(){
    if (document.all){
    move3(first2)
    second2.style.top=scrollerheight
    }
    else if (document.layers){
    move1(document.main.document.first)
    document.main.document.second.top=scrollerheight+5
    document.main.document.second.visibility='show'
    }}
    window.onload=startscroll
    //-->
    </script> <ilayer id="main" width="&amp;{scrollerwidth};" height="&amp;{scrollerheight};" bgcolor="&amp;{scrollerbgcolor};"> <layer id="first" left="0" top="1" width="&amp;{scrollerwidth};"> <script
    language="JavaScript1.2">
    if (document.layers)
    document.write(slideimages[0])
    </script> </layer> <layer id="second" left="0" top="0" width="&amp;{scrollerwidth};" visibility="hide"> <script language="JavaScript1.2">
    if (document.layers)
    document.write(slideimages[1])
    </script> </layer> </ilayer> 
    <p><script language="JavaScript1.2">
    <!-- 
    if (document.all){
    document.writeln('<span id="main2" style="position:relative;width:'+scrollerwidth+';height:'+scrollerheight+';overflow:hiden;background-color:'+scrollerbgcolor+'">')
    document.writeln('<div style="position:absolute;width:'+scrollerwidth+';height:'+scrollerheight+';clip:rect(0 '+scrollerwidth+' '+scrollerheight+' 0);left:100;top:0">')
    document.writeln('<div id="first2" style="position:absolute;width:'+scrollerwidth+';left:100;top:1;">')
    document.write(slideimages[0])
    document.writeln('</div>')
    document.writeln('<div id="second2" style="position:absolute;width:'+scrollerwidth+';left:100;top:0">')
    document.write(slideimages[1])
    document.writeln('</div>')
    document.writeln('</div>')
    document.writeln('</span>')
    }
    //--></script>
    </body></html>
      

  3.   

    cj_counts哪里设置的
    根据实体类或键值对设置值为0
      

  4.   

    cj_counts 是数据库里写的字段属性的默认值是 5 比如说 有2条记录 每条的cj_counts都是5
      

  5.   

    看你用计时器了,那你每过一秒让你的图片的URL就变一回不就OK了,图片就滚动了
      

  6.   

    图片地址是写在数据库里的可是 我不知道 c#里有没有 rs.movenext这种方法啊 .
      

  7.   

    linq to sql skip.take