在线急求解答!!关于 SliderShowExtender 链接数据库!
月下槿 2012-06-11 10:27:01 webservice.asmx.cs里的内容:
[WebMethod]
public AjaxControlToolkit.Slide[] GetPhoto()
{
string name = "";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=(local);Initial Catalog=MyBlog;User ID=sa;Password=920201";
conn.Open();
string sql = "select * from Images";
//创建数据库连接
SqlCommand command = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = command;
DataSet dss = new DataSet();
da.Fill(dss,"Images");
if (dss.Tables["Images"].Rows.Count > 0)
{
name = dss.Tables["Images"].Rows[0][2].ToString();
}
string sql2 = "select * from Images where [IMG_Name]=" + name;
DataSet ds = new DataSet();
//获取数据库结果,填充到DataSet中
da.Fill(ds, "Images");
//创建Slide数据对象对象,用语存储将要播放的相片。
AjaxControlToolkit.Slide[] ajaxPhoto = new Slide[ds.Tables["Images"].Rows.Count];
int j = 0;
foreach (DataRowView v in ds.Tables["Images"].DefaultView)
{
//读取数据库中数据,并存储到Slide数组中。
ajaxPhoto.SetValue(new AjaxControlToolkit.Slide(v[3].ToString(), v[1].ToString(), v[2].ToString()), j);
j = j + 1;
}
return ajaxPhoto;
}
.aspx页面的代码:
<asp:Image ID="Image2" runat="server" />
<asp:Button ID="btnPrevious" runat="server" Text="btnPrevious" />
<asp:Button ID="btnPlay" runat="server" Text="btnPlay" />
<asp:Button ID="btnNext" runat="server" Text="btnNext" />
<cc1:SlideShowExtender ID="SlideShowExtender1" runat="server"
TargetControlID="Image2"
SlideShowServicePath="PhotoService.asmx" SlideShowServiceMethod="GetPhoto" AutoPlay="true"
NextButtonID="btnNext"
PlayButtonID="btnPlay"
PreviousButtonID="btnPrevious"
PlayButtonText="play"
StopButtonText="stop"
Loop="true" >
</cc1:SlideShowExtender>
/////////////////////////////////////////////////////////////////////////////////////////////////////////
结果是在浏览器里图片显示不出来 怎么回事啊??