下面的代码怎么出现这个问题啊??大家帮忙再看看好吗?
Dim m_Conn As SqlConnection
Dim m_Comm As SqlDataAdapter
Dim m_DataTable As New DataTable
m_Conn = New SqlConnection(ConfigurationSettings.AppSettings("SQLConnString"))
m_Comm = New SqlDataAdapter("select count(*) from [admin] where AdminName='" & AdminName.Text & "' and AdminPwd='" & AdminPwd.Text & "'", m_Conn)
m_Comm.Fill(m_DataTable)
Response.Write(m_DataTable.Rows(0)("AdminType").ToString())
错误信息:
列“AdminType”不属于表 。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
SqlCommand Cmd = new SqlCommand("select a,b,c from d where e ='e'",Conn);
SqlDataReader Rad = Cmd.ExecuteReader();
MessageBox.Show(Rad["a"].ToString());