大家帮忙看看怎么改这个错误吧

[WUDIBLUESKY]

cs文件中

string classroom = TextBox1.Text.ToString();//从label中得到数据库中相对应的表，classroom动态变化

string strConn;
SqlDataAdapter objDataAdapter;
strConn = "server=localhost;database=intelliCampus;Integrated Security=true";
SqlConnection myConn = new SqlConnection(strConn);
myConn.Open();
SqlCommand cmd = new SqlCommand("select * from classroom", myConn);
objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("select [isBooked] from [classroom]", myConn);
DataTable dt = new DataTable();
objDataAdapter.Fill(dt);

提示错误：
对象名 'classroom' 无效。
说明: 执行当前 Web 请求期间，出现未经处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 对象名 'classroom' 无效。

源错误:


行 41: objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("select [isBooked] from [classroom]", myConn);
行 42: DataTable dt = new DataTable();
行 43: objDataAdapter.Fill(dt);
行 44: // int[] a = new int[27];
行 45: int[] a = new int[dt.Rows.Count];

大家说说怎么改呀

[孟子E章]

没有classroom这个表
检查你连的库是否正确

[yp136]

表不存在，看看你数据库是不是名字有误

[riyunzhu]

确定数据库中有classroom表吗？有的话检查下连接数据库的代码，没有的话，那就创建classroom表，再运行看看啊。

[xingxingbanyue]

  string classroom = textBox1.Text.ToString();
  string strConn;
  SqlDataAdapter objDataAdapter;
  strConn = "server=localhost;database=intelliCampus;Integrated Security=true";  
  SqlConnection myConn = new SqlConnection(strConn);
  myConn.Open();
  SqlCommand cmd = new SqlCommand("select * from "+classroom, myConn);
  objDataAdapter = new System.Data.SqlClient.SqlDataAdapter("select [isBooked] from "+classroom, myConn);
  DataTable dt = new DataTable();
  objDataAdapter.Fill(dt);

注意：from后面要有空格，试试吧

[xingxingbanyue]

把sql语句改为"select * from "+classroom，from 后面要有空格

[C5662601]

SqlCommand cmd = new SqlCommand("select * from classroom", myConn);
把classroom写到""里了
SqlCommand cmd = new SqlCommand("select * from " + classroom, myConn);

[fuy733]

没有classroom这个表
检查你连的库是否正确

[子夜__]

SqlCommand cmd = new SqlCommand("select * from '"+classroom+"'", myConn);

[格桑花]

SqlCommand cmd = new SqlCommand("select * from ["+classroom+"]", myConn);