我是想编辑新闻的,点编辑后就出现详细编辑,点修改就出现"标准表达式中数据类型不匹配"这个错误了,新手谁帮忙解决一下啊.... protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/database/ekubaodata.mdb"));
con.Open();
string sql = "select * from Link where id='" + Request.QueryString["id"] + "'";
OleDbDataAdapter sda = new OleDbDataAdapter(sql, con);
DataSet ds = new DataSet();
sda.Fill(ds, "Link");
DataRowView drv = ds.Tables["Link"].DefaultView[0];
Linkname.Text = Convert.ToString(drv.Row["LinkName"]);
Linkurl.Text = Convert.ToString(drv.Row["Url"]);
}
}
{
if (!IsPostBack)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/database/ekubaodata.mdb"));
con.Open();
string sql = "select * from Link where id='" + Request.QueryString["id"] + "'";
OleDbDataAdapter sda = new OleDbDataAdapter(sql, con);
DataSet ds = new DataSet();
sda.Fill(ds, "Link");
DataRowView drv = ds.Tables["Link"].DefaultView[0];
Linkname.Text = Convert.ToString(drv.Row["LinkName"]);
Linkurl.Text = Convert.ToString(drv.Row["Url"]);
}
}
string sql = "select * from Link where id=" + Request.QueryString["id"];改成这样就可以了..