JSP-->c#

<%@ page contentType="text/plain; charset=UTF-8"%>
<%@ page language="java"%>
<%@ page import="java.sql.*,ajax.db.DBUtils"%>
<%
    out.clear();                                    //清空当前的输出内容（空格和换行符）    String sql = "select * from album";             //定义查询数据库的SQL语句    StringBuffer picInfo = new StringBuffer("[");   //保存查询结果
    int counter = 0;                                //计数器    Connection conn = null;                 //声明Connection对象
    PreparedStatement pstmt = null;         //声明PreparedStatement对象
    ResultSet rs = null;                    //声明ResultSet对象
    try {
        conn = DBUtils.getConnection();     //获取数据库连接
        pstmt = conn.prepareStatement(sql); //根据sql创建PreparedStatement
        rs = pstmt.executeQuery();          //执行查询，返回结果集        //遍历结果集，生成JSON格式的查询结果
        while (rs.next()) {
            if (counter > 0) {
                picInfo.append(",");
            }
            picInfo.append("{");
            picInfo.append("'id':'");
            picInfo.append(rs.getString("id"));
            picInfo.append("','name':'");
            picInfo.append(rs.getString("name"));
            picInfo.append("','width':'");
            picInfo.append(rs.getString("width"));
            picInfo.append("','height':'");
            picInfo.append(rs.getString("height"));
            picInfo.append("'}");
            counter++;                      //计数器加1
        }
    } catch (SQLException e) {
        System.out.println(e.toString());
    } finally {
        DBUtils.close(rs);                  //关闭结果集
        DBUtils.close(pstmt);               //关闭PreparedStatement
        DBUtils.close(conn);                //关闭连接
    }
    picInfo.append("]");
    out.print(picInfo.toString());          //返回查询结果
%>
上面这个是JSP的，怎么用C#实现上面的功能，帮帮啊老大们

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

    string sql = "select * from album";            //定义查询数据库的SQL语句     StringBuilder picInfo = new StringBuilder("[");  //保存查询结果
    int counter = 0;                                //计数器     SqlConnection conn = null;                //声明Connection对象
    SqlDataReader rs = null;                    //声明ResultSet对象
    try {
        conn = DBUtils.getConnection();    //获取数据库连接
        SqlCommand cmd=new SqlCommand(sql,conn); //根据sql创建PreparedStatement
        rs = cmd.ExecuteReader();          //执行查询，返回结果集         //遍历结果集，生成JSON格式的查询结果
        while (rs.Read*() {
            if (counter > 0) {
                picInfo.append(",");
            }
            picInfo.Append("{");
            picInfo.Append("'id':'");
            picInfo.Append(rs.GetString(0));
            picInfo.Append("','name':'");
            picInfo.Append(rs.GetString(1));
            picInfo.Append("','width':'");
            picInfo.Append(rs.GetString(2));
            picInfo.Append("','height':'");
            picInfo.Append(rs.GetString(3));
            picInfo.Append("'}");
            counter++;                      //计数器加1
        }
    } catch (SqlException e) {
        Response.Write(e.Message);
    } finally {
        DBUtils.close(rs);                  //关闭结果集              //关闭PreparedStatement
        DBUtils.close(conn);                //关闭连接
    }
    picInfo.Append("]");
    Response.Write(picInfo.ToString());          //返回查询结果
加上  using System.Text;
using System.Data.SqlClient;
帮忙看看下面的程序是什么问题？运行到红色字体的地方就不行了。。
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
    <style type="text/css">
/* 页面字体样式 */
body, td, input {
    font-family:Arial;
    font-size:12px;
}/* 表格基本样式 */
table.default {
    border-collapse:collapse;
    width:850px;
}/* 表格单元格样式 */
table.default td {
    border:1px solid black;
    padding:3px;
    height:30px;
}/* 列头样式 */
table.default td.item {
    background:#006699;
    color:#fff;
    text-align:center;
}/* 预览图片Div的样式 */
div.preview {
    float:left;
    width:90px;
    height:70px;
    border:1px solid black;
    text-align:center;
    margin-left:5px;
}/* 预览图片的样式 */
div.preview img {
    margin:5px;
    border:0;
    cursor:pointer;
}/* 完整图片Div的样式 */
#picDiv {
    text-align:center;
}/* 完整图片的样式 */
#picDiv img {
    border:0;
}
</style><script type="text/javascript">
var xmlHttp;                        //用于保存XMLHttpRequest对象的全局变量
var basePath = "";           //图片保存目录//用于创建XMLHttpRequest对象
function createXmlHttp() {
    //根据window.XMLHttpRequest对象是否存在使用不同的创建方式
    if (window.XMLHttpRequest) {
       xmlHttp = new XMLHttpRequest();                  //FireFox、Opera等浏览器支持的创建方式
    } else {
       xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");//IE浏览器支持的创建方式
    }
}//向服务器获取图片信息
function getPicInfo() {
    createXmlHttp();                                //创建XMLHttpRequest对象
    xmlHttp.onreadystatechange = displayPreview;    //设置回调函数
    xmlHttp.open("GET", "Default2.aspx", true);         //发送GET请求
    xmlHttp.send(null);
}//处理服务器返回信息
function displayPreview() {
    if (xmlHttp.readyState == 4) {
        var previewDiv = document.getElementById("previewDiv"); //获取预览图容器对象
        previewDiv.innerHTML = "";                              //清空容器内容

        var pics = eval("(" + xmlHttp.responseText + ")");      //将服务器信息转为JSON数组
        alert("1");这里没有弹出"1"        //遍历整个JSON数组，创建预览图片
        for (var i=0; i<pics.length; i++) {
            var pic = pics[i];
            previewDiv.appendChild(createPreviewPic(pic));      //在容器内追加预览图节点
        }
    }
}//创建预览图片节点
function createPreviewPic(pic) {
    var picNode = document.createElement("div");
    picNode.className = "preview";
    picNode.innerHTML = "<img src='"+ pic.url + "' onclick='loadPic( '"+  pic.url +"' )'>";
    return picNode;
}//加载完整图片
function loadPic(picName) {
    document.getElementById("picDiv").innerHTML = "<img src='"+ picName + "'>";
}
</script>
</head>
<body onload="getPicInfo()">
    <form id="form1" runat="server">
    <div>
        <h1>相册浏览</h1><table class="default">
<tr>
    <td class="item">点击缩略图查看完整图片</td>
</tr>
<tr>
    <td>
    <div id="previewDiv">正在加载缩略图……</div>
    </td>
</tr>
<tr>
    <td>
    <div id="picDiv"></div>
    </td>
</tr>
</table>

    </div>
    </form>
</body>
</html>
Default2.aspx.cs
这里是没有错误的，我运行过了
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.OleDb;
using System.Text;
public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        StringBuilder picInfo = new StringBuilder("[");
        int count = 0;
        string cmdtext = "select * from url where url";
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db.mdb"));
        conn.Open();
        OleDbCommand cmd = new OleDbCommand(cmdtext, conn);
        OleDbDataReader rs = cmd.ExecuteReader();
        while (rs.Read ())
        {
            if (count > 0)
            {
                picInfo.Append(",");
            }
            picInfo.Append("{");
            picInfo.Append("'leixing':'");
            picInfo.Append(rs.GetString (1));
            picInfo.Append("','surl':'");
            picInfo.Append(rs.GetString(2));
            picInfo.Append("','url':'");
            picInfo.Append(rs.GetString(3));
            picInfo.Append("}");
            count++;
        }
        rs.Close();
        conn.Close();
        picInfo.Append("]");
        Response .Write (picInfo .ToString ());


    }
}