SQL操作,说数据类型不匹配,请帮忙!

[hooohooooooo]

出错行显示在Fill的时候.
id 是数据库中的一个自动编号字段.

Int32 se = Convert.ToInt32 (Session["id"]);

//Response.Write(se);
con.Open();
ds = new DataSet();
string sql = "select id ,title,content,ram,overtime,Tpoint from question where id='" + se + "'";
//com = new System.Data.OleDb.OleDbCommand(sql, con);
da = new System.Data.OleDb.OleDbDataAdapter(sql, con);
da.Fill(ds, "question");

Label1.Text = Server .HtmlDecode ( ds.Tables["question"].Rows[0][2].ToString());
Label3.Text = Server.HtmlDecode(ds.Tables["question"].Rows[0][0].ToString());
Label5.Text = Server.HtmlDecode(ds.Tables["question"].Rows[0][1].ToString());
Label7.Text = Server.HtmlDecode(ds.Tables["question"].Rows[0][4].ToString());
Label9.Text = Server.HtmlDecode(ds.Tables["question"].Rows[0][3].ToString());
Session ["point"]=Server.HtmlDecode(ds.Tables["question"].Rows[0][5].ToString ());

da.Dispose();
con.Close();

[winner2050]

这么写ID号有英文的'就被任务是字符了。而ID字段是INT的
string sql = "select id ,title,content,ram,overtime,Tpoint from question where id='" + se + "'";

你应该这样写
string sql = "select id ,title,content,ram,overtime,Tpoint from question where id=" + se;

[wpfonline]

楼上 winner2050
正解 只有字符行的才加‘’

[hooohooooooo]

非常感谢,请问大侠为什么要加[]呢?

[hooohooooooo]

string sql = "select id ,title,content,ram,overtime,Tpoint from question where id=" + se + "";
这样也可以成功的.

[Knight94]

change
string sql = "select id ,title,content,ram,overtime,Tpoint from question where id='" + se + "'";
with
string sql = "select id ,title,content,ram,overtime,Tpoint from question where id=" + se.ToString() + "";

[aspgreener]

楼上正解！

[lcddjyy]

应该把数字转化为字符型的.

[hooohooooooo]

转为string也一样,还是数据类型不匹配.

[vcforeverya]

对,用字符类型

[Knight94]

数据库是什么，报什么错

[hooohooooooo]

数据库:
string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/noi.mdb") + ";User Id=admin;Password=;";
con = new OleDbConnection(strcon);

错误提示:

System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。 在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) 在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) 在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) 在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) 在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) 在 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) 在 questionN.bind() 位置 d:\Visual Studio 2005\NOI\questionN.aspx.cs:行号 56

[Knight94]

用如下这条语句进行查询。
string sql = "select [id] ,[title],[content],[ram],[overtime],[Tpoint] from [question] where [id]=" + se.ToString();