作新闻显示的页面，第 1 行: '=' 附近有语法错误。
这是我的链接数据库的源代码
<script language= "C# " runat= "server ">
DataSet ds;
DataRow dr;
String newsid;
void Page_load(Object sender, EventArgs e)
{
SqlConnection MyConnection;
String ConnStr, strCon;
newsid = Request.Params[ "id "];
MyConnection = new SqlConnection( "server=localhost;database=news;uid=sa;pwd= ' ' ");
MyConnection.Open();
String strCom = "SELECT biaoti,zhaizi,neirong,img,counter,shijian FROM news where id= " + newsid;
ds = new DataSet();
SqlDataAdapter myCommand = new SqlDataAdapter(strCom,MyConnection);
myCommand.Fill(ds, "news ");
dr = ds.Tables[ "news "].Rows[0];
strCon = "SELECT counter FROM news WHERE id = " + newsid;
SqlCommand myCommand2 = new SqlCommand(strCon,MyConnection);
SqlDataReader reader = myCommand2.ExecuteReader();
reader.Read();
int i = reader.GetInt32(0);
i ++;
reader.Close();
strCon = "UPDATE news SET counter= " + i.ToString() + " WHERE(id= " + newsid+ ") ";
myCommand2.CommandText = strCon;
myCommand2.ExecuteNonQuery();
MyConnection.Close();
}
行 21: ds = new DataSet();
行 22: SqlDataAdapter myCommand = new SqlDataAdapter(strCom,MyConnection);
行 23: myCommand.Fill(ds, "news ");
行 24: dr = ds.Tables[ "news "].Rows[0];
行 25: strCon = "SELECT counter FROM news WHERE id = " + newsid;
[解决办法]
newsid 是数字吗？ 不是得这样
String strCom = "SELECT biaoti,zhaizi,neirong,img,counter,shijian FROM news where id= ' " + newsid + " ' ";
还有你的库名和表名是一样的阿？
数据库连接字符串里是库名，SQL查询语句里是表名，别搞错了
