前台代码<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Tutorial.aspx.cs" Inherits="Tutorial" %><!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 id="Head1" runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>后台代码  if (Session["username"].ToString() != "" && Session["password"].ToString() != "")
            {
                int id = Convert.ToInt32(Request.QueryString["id"].ToString());
                string sql = "select fileaddress from TotorialList where id='" + id + "'";
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolOnLineConnectionString"].ConnectionString);
                conn.Open();
                SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
                DataSet ds = new DataSet();
                sda.Fill(ds, "ds");
                string address =ds.Tables[0].Rows[0][0].ToString();                Response.Redirect("~"+@address);
            }
            else
            {
                Response.Redirect("Default.aspx");
            }
这样写是没有问题的,可是不满足需求。 try
        {
            if (Session["username"].ToString() != "" && Session["password"].ToString() != "")
            {
                int id = Convert.ToInt32(Request.QueryString["id"].ToString());
                string sql = "select fileaddress from TotorialList where id='" + id + "'";
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolOnLineConnectionString"].ConnectionString);
                conn.Open();
                SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
                DataSet ds = new DataSet();
                sda.Fill(ds, "ds");
                string address =ds.Tables[0].Rows[0][0].ToString();                Response.Redirect("~"+@address);
            }
            else
            {
                Response.Redirect("Default.aspx");
            }
        }
        catch
        {
            //throw new Exception(ex.Message);
            Response.Redirect("Default.aspx");
        }
    }
这样写的话提示出错,不论string address =ds.Tables[0].Rows[0][0].ToString();
为中文还是英文,错误很怪,提示全是一些乱码。

解决方案 »

  1.   

    try
            {
                if (Session["username"].ToString() != "" && Session["password"].ToString() != "")
                {
                    int id = Convert.ToInt32(Request.QueryString["id"].ToString());
                    string sql = "select fileaddress from TotorialList where id='" + id + "'";
                    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolOnLineConnectionString"].ConnectionString);
                    conn.Open();
                    SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
                    DataSet ds = new DataSet();
                    sda.Fill(ds, "ds");
                    string address =ds.Tables[0].Rows[0][0].ToString();                Response.Redirect("~"+@address,false);
                }
                else
                {
                    Response.Redirect("Default.aspx");
                }
            }
            catch
            {
                //throw new Exception(ex.Message);
                Response.Redirect("Default.aspx");
            }
        }