System.Data.SqlClient.SqlException：列名无效(System.Data.SqlClient.SqlException: Invalid column name)

 尝试做一个记录集，我只想要一列数据，但是这段代码给了我一个错误..我是一个ASP.NET新手，有人可以帮忙吗？： 
 
 
 
 System.Data.SqlClient.SqlException：无效的列名称'CustomerName'。 
 
 
 using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
 {
  con.Open();
  using (IDataReader dr = DB.GetRS("select CustomerName from Customer where CustomerID=" + Customer.CustomerID, con))
   {
       string CustomerName = "CustomerName";                    
   }
 }

 String EncCustomerName = Encrypt(CustomerName.Replace(".", "").Replace("-", ""),"1");
 
 问题2：如何将数据库内容绑定到CustomerName字符串？ 它似乎只返回“CustomerName”作为CustomerName字符串的值..我希望它返回CustomerName字符串的数据库数据..帮助？ 
 
 建议使用ExecuteScalar，所以我修改了对此的请求 
 
   using (var con = new SqlConnection(DB.GetDBConn()))
   using (var cmdContrib = new SqlCommand("SELECT CustomerName FROM Customer WHERE   CustomerID=" + ThisCustomer.CustomerID, con))

   {

        con.Open();
        string CustomerName = cmdContrib.ExecuteScalar();
   } 
 
 我收到此错误：“string CustomerName = cmdCust.ExecuteScalar（）;” 
 
 CS0266：无法将类型'object'隐式转换为'string'。 存在显式转换（您是否错过了演员？） 

Trying to do a recordset, I just want one column of data, but this code is giving me an error.. I'm an ASP.NET newb, can anyone help?:
 
 
 
System.Data.SqlClient.SqlException: Invalid column name 'CustomerName'.
 
 
 using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
 {
  con.Open();
  using (IDataReader dr = DB.GetRS("select CustomerName from Customer where CustomerID=" + Customer.CustomerID, con))
   {
       string CustomerName = "CustomerName";                    
   }
 }

 String EncCustomerName = Encrypt(CustomerName.Replace(".", "").Replace("-", ""),"1");
 
Question #2: How do I bind the database content to the CustomerName string? It seems like its only returning "CustomerName" as the value for CustomerName string.. I would like it to return the database data for CustomerName string.. Help?
 
Suggested to use a ExecuteScalar, so i modified the request to this 
 
   using (var con = new SqlConnection(DB.GetDBConn()))
   using (var cmdContrib = new SqlCommand("SELECT CustomerName FROM Customer WHERE   CustomerID=" + ThisCustomer.CustomerID, con))

   {

        con.Open();
        string CustomerName = cmdContrib.ExecuteScalar();
   } 
 
And i Get this error: "string CustomerName = cmdCust.ExecuteScalar();"
 
CS0266: Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

原文：https://stackoverflow.com/questions/7291505