前台代码<%@ 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();
为中文还是英文,错误很怪,提示全是一些乱码。
<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();
为中文还是英文,错误很怪,提示全是一些乱码。
{
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");
}
}