CS1009:无法识别的转义序列
本文关键字:转义序列 识别 CS1009 | 更新日期: 2023-09-27 18:20:58
我用以下连接字符串创建了一个站点。
我收到以下错误信息,如有任何帮助,我们将不胜感激。
编译器错误消息:CS1009:无法识别的转义序列Line 21: ad.DataFile = "D:'Hosting'9372580'html'pearl'Pearl.mdb";
我的代码:
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;
public partial class html_Show_Projinfo : System.Web.UI.Page
{
OleDbCommand cmd;
OleDbConnection con = new OleDbConnection();
OleDbDataReader rd;
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
con.ConnectionString = ConfigurationManager.ConnectionStrings["pearl"].ToString();
cmd = new OleDbCommand("Select * from Pearl_Projects where ProjectId=" + id, con);
con.Open();
rd = cmd.ExecuteReader();
string ns;
while (rd.Read())
{
Label2.Text = rd["ProjectName"].ToString();
ns = rd["Shortdes"].ToString();
if (ns.Length > 541)
{
Label1.Text = ns.Substring(0, 541);
}
else
{
Label1.Text = ns.Substring(0, ns.Length);
}
Label3.Text = rd["Description"].ToString();
Label4.Text = rd["location"].ToString();
}
rd.Close();
con.Close();
//con.Open();
//cmd = new OleDbCommand("Select ProjectId from Pearl_ProjectDetails where DetailId=" + id, con);
//int j = Convert.ToInt32(cmd.ExecuteScalar());
//con.Close();
//con.Open();
//cmd = new OleDbCommand("Select ProjectName from Pearl_Projects where ProjectId=" + j, con);
//Label1.Text = cmd.ExecuteScalar().ToString();
//con.Close();
if (Label4.Text == "")
{
Label4.Visible = false;
Label5.Visible = false;
}
else
{
Label4.Visible = true;
Label5.Visible = true;
}
AccessDataSource ad = new AccessDataSource();
ad.DataFile = "D:'Hosting'9372580'html'pearl'Pearl.mdb";
ad.SelectCommand = "SELECT top 3 ProjectId,ProjectName,Status FROM [Pearl_Projects] where Status=no Order by ProjectId Desc";
DataList1.DataSource = ad;
DataList1.DataBind();
AccessDataSource ad1 = new AccessDataSource();
ad1.DataFile = "D:'Hosting'9372580'html'pearl'Pearl.mdb";
ad1.SelectCommand = "SELECT top 3 ProjectId,ProjectName,Status FROM [Pearl_Projects] where Status=yes Order by ProjectId Desc";
DataList2.DataSource = ad1;
DataList2.DataBind();
}
}
在类似以下的行中转义那些'
ad.DataFile = "D:'Hosting'9372580'html'pearl'Pearl.mdb";
你可以像一样手动逃离它们
ad.DataFile = "D:''Hosting''9372580''html''pearl''Pearl.mdb";
或者你可以把它做成一个文字字符串
ad.DataFile = @"D:'Hosting'9372580'html'pearl'Pearl.mdb";
字符'''
开始了所谓的"转义序列",它本质上是使用2个字符来表示1个(特殊)字符。
例如,'n
是换行符,'0
是null,''
是'
您需要使用"''''",因为"''"是转义序列
http://msdn.microsoft.com/en-us/library/44ezxxy3(v=vs.80).aspx