عکسها تو پوشه Pic و این پوشه هم تو Root سایت
اسم عکسها همراه پسوند تو دیتابیس
<script type="text/javascript">
var ReadVar = '<%= ArrayeImage %>';
var imgs = new Array();
imgs = ReadVar.split(':');
var num = 1;
$(document).ready(function () {
setInterval(Slider, 3000);
});
function Slider() {
$('#imageSlide').fadeOut("slow", function () { $(this).attr('src', 'Pic/' + imgs[num++ % imgs.length]).fadeIn("slow"); });
}
</script>
کد HTML:
<div>
<img id="imageSlide" alt="" src="Pic/01.jpg" />
</div>
public string ArrayeImage;
SqlConnection con = new SqlConnection(@"Data Source=amir-pc;Initial Catalog=JQuery;Integrated Security=true");
protected void Page_Load(object sender, EventArgs e)
{
ArrayeImage = string.Empty;
SqlDataReader dr = null;
if (con.State == ConnectionState.Closed)
con.Open();
try
{
dr = (new SqlCommand("select * from Pic", con)).ExecuteReader();
while (dr.Read())
{
ArrayeImage += dr["PicUrl"].ToString() + ":";
}
}
finally
{
if (dr != null)
dr.Close();
con.Close();
}
if (!string.IsNullOrEmpty(ArrayeImage))
ArrayeImage = ArrayeImage.Substring(0, ArrayeImage.Length - 1);
}