连接access数据库,打算根据ID值(自增)查找具体内容
可是总是提示标准表达式中数据类型不匹配 错误
代码片段如下:
try
{
int xuhao;
string contentd;
xuhao = Convert.ToInt32(this.DropDownList1.Text.ToString());
string commandtext = "select content from blog where ID = '"+xuhao+"'";
OleDbConnection conn = new OleDbConnection();
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
connStr += Server.MapPath(@"data\Data.mdb");
conn.ConnectionString = connStr;
OleDbCommand cmd = new OleDbCommand(commandtext, conn);
conn.Open();
contentd = cmd.ExecuteScalar().ToString();
this.TextBox1.Text = contentd;
conn.Close();
}
catch (Exception ex)
{
Response.Write("数据库连接失败,可能的原因是:<br>" + ex.Message);
}
高手帮我看看,多谢!
可是总是提示标准表达式中数据类型不匹配 错误
代码片段如下:
try
{
int xuhao;
string contentd;
xuhao = Convert.ToInt32(this.DropDownList1.Text.ToString());
string commandtext = "select content from blog where ID = '"+xuhao+"'";
OleDbConnection conn = new OleDbConnection();
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
connStr += Server.MapPath(@"data\Data.mdb");
conn.ConnectionString = connStr;
OleDbCommand cmd = new OleDbCommand(commandtext, conn);
conn.Open();
contentd = cmd.ExecuteScalar().ToString();
this.TextBox1.Text = contentd;
conn.Close();
}
catch (Exception ex)
{
Response.Write("数据库连接失败,可能的原因是:<br>" + ex.Message);
}
高手帮我看看,多谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货