using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class _163photoTest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
description.Text  = GetDescription();
AjaxPro.Utility.RegisterTypeForAjax(typeof(_163photoTest));
}
//取数据库里的描述
    protected string GetDescription()
{
try
{
string strComm = "select  photo_description from tab_photo where photo_id=1";
SqlConnection myConn = new SqlConnection("user id=sa;password=123;Database =test;data source=z;");
myConn.Open();
SqlCommand myComm = new SqlCommand(strComm, myConn);
SqlDataReader myReader = myComm.ExecuteReader();
myReader.Read();
return myReader.GetString(0);
}
catch
{
return "";
}
}
[AjaxPro.AjaxMethod]
//将description保存进数据库 www.knowsky.com
    public bool UpdateDesc(string description)
{
try
{
string strComm = "update tab_photo set photo_description='" + description + "' where photo_id=1";
SqlConnection myConn = new SqlConnection("user id=sa;password=123;Database =test;data source=z;");
myConn.Open();
SqlCommand myComm = new SqlCommand(strComm, myConn);
myComm.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
}
}