获取网站服务器数据库,利用XmlHttp获取服务器数据库数据以表格的方式返回客户的代码示例...

以下示例，不使用任何的无刷新组件，直接通过XmlHttp完成！

一、JS文件代码

// JScript 文件

二、ASHX文件代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.IO;

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.Security; //加密

using System.Text;

using System.Data.SqlClient;

using System.Web.SessionState;

public class GetSuggestion : IHttpHandler,IRequiresSessionState

{

public void ProcessRequest (HttpContext context)

{

context.Response.ContentType = "text/plain";

//context.Response.Write("Hello World");

DataTable dt = GetSqlDataTable();

string response = string.Empty;

for (int i = 0; i < dt.Rows.Count; i++)

{

response += dt.Rows[i][0].ToString() + "," + dt.Rows[i][1].ToString() + "," + dt.Rows[i][2].ToString() + "," + dt.Rows[i][3].ToString() + ";";

}

if (response.EndsWith(";"))

{

response = response.Substring(0, response.Length - 1);

}

context.Response.Write(response);

context.Response.End();

}

private DataTable GetSqlDataTable()

{

DataClass.SqlDataClas MyClass = new DataClass.SqlDataClas();

SqlConnection conn = new SqlConnection(MyClass.GetMyDataBaseConStr());

string query = "select 字段１,字段２,字段３,字段４ from 表名 where YouID=@MyID order by ID desc";

SqlCommand cmd = new SqlCommand(query, conn);

cmd.Parameters.Add(new SqlParameter("@MyID", SqlDbType.VarChar, 8000));

cmd.Parameters["@MyID"].Value = HttpContext.Current.Session["变量名称"].ToString().Trim();

SqlDataAdapter adapter = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

try

{

conn.Open();

adapter.Fill(dt);

return dt;

}

catch

{

throw;

}

finally

{

cmd.Dispose();

conn.Close();

}

}

public bool IsReusable {

get

{

return false;

}

}

}

三、ASPX或HTML页面

里面仅需要一个按钮和一个div即可！

“”