Use DB query result to generate Jquery required lines of code

Hello

I 'm gonna query database for photo records. each record include "photo path" where imagesURL stored in string format

I Choses my favorite Juqery plugin to show images. Plugin needs some lines of code like below.

How could I generate these lines

<script>
  $(function() {
    $('#slideshow').crossSlide({
      sleep: 2,
      fade: 1
    }, [
      { src: 'picture1.jpg' },
      { src: 'picture2.jpg' },
      ......
      .....
      { src: 'picture4.jpg' }
    ])
  });
</script>

Re: Use DB query result to generate Jquery required lines of code

Solution 1:

in code behind :

public string GenerateJS(){

string ret="";

foreach( var str in <your picture collection>){
ret+= "

{ src: '" + str + "' }";

}

return ret;

}

In aspx page

<script>
  $(function() {
    $('#slideshow').crossSlide({
      sleep: 2,
      fade: 1
    }, [
      <% = 
GenerateJS() %>
    ])
  });
</script>

Solution 2:
http://msdn.microsoft.com/en-us/library/system.web.ui.page.registerstartupscript%28VS.71%29.aspx