using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using AjaxPro;
public partial
class _Default : System.Web.UI.Page
{
protected string displayCategoryID;
protected void Page_Load(
object sender, EventArgs e)
{
Utility.RegisterTypeForAjax(
typeof(AjaxMethod));
displayCategoryID = "17";
}
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using AjaxPro;
/// <summary>
/// Summary description for AjaxMethod
/// </summary>public class AjaxMethod
{
public AjaxMethod()
{
//
// TODO: Add constructor logic here
//
}
public static string ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
GetDataSet /// <summary>
/// 獲取某個(gè)分類下圖片的id和photo_path信息
/// </summary>
/// <param name="iCategoryID">分類ID號(hào)</param>
/// <returns>圖片信息(id, photo_path)的信息</returns> [AjaxMethod(HttpSessionStateRequirement.ReadWrite)]
public static DataSet GetPhotoList(
int iCategoryID)
{
string sql =
string.Format("SELECT id, photo_path FROM Photo WHERE photo_category_id = {0}", iCategoryID);
return GetDataSet(sql);
}
/// <summary>
/// 獲取圖片信息(標(biāo)題、說明)
/// </summary>
/// <param name="id">圖片id</param>
/// <returns>圖片信息</returns> [AjaxMethod(HttpSessionStateRequirement.ReadWrite)]
public static DataSet GetPhotoInfo(
int id)
{
string sql =
string.Format("SELECT photo_title, photo_description FROM Photo WHERE id = {0}", id);
return GetDataSet(sql);
}
}
if exists (
select * from dbo.sysobjects
where id
= object_id(N
'[dbo].[Photo]')
and OBJECTPROPERTY(id, N
'IsUserTable')
= 1)
drop table [dbo].
[Photo]GOCREATE TABLE [dbo].
[Photo] (
[id] [int] IDENTITY (
1,
1)
NOT NULL ,
[photo_title] [varchar] (
128) COLLATE Chinese_PRC_CI_AS
NULL ,
[photo_description] [text] COLLATE Chinese_PRC_CI_AS
NULL ,
[photo_category_id] [int] NULL ,
[photo_path] [varchar] (
255) COLLATE Chinese_PRC_CI_AS
NULL )
ON [PRIMARY] TEXTIMAGE_ON
[PRIMARY]GO