问一个简单问题，如何得到count的结果？

myCommand.CommandText   =   "SELECT   COUNT(*)   FROM   tMessages   WHERE   NameID='"   +UserID+   "'";  
  怎样得到COUNT(*)的值？ 问题点数：10、回复次数：5Top

1 楼netproxy（guoli）回复于 2004-08-19 06:25:41 得分 0

我也想知道Top

2 楼scwsm（雨目鸟）回复于 2004-08-19 07:25:26 得分 5

myCommand.CommandText   =   "SELECT   COUNT(*)   as   sum   FROM   tMessages   WHERE   NameID='"   +UserID+   "'";  
  给列加个名称Top

3 楼scwsm（雨目鸟）回复于 2004-08-19 07:30:13 得分 3

 
  public   void   ReadMyData(string   myConnString)    
  {  
        string   mySelectQuery   =   "SELECT   Count(*)   as   ddd   FROM   Orders";  
        SqlConnection   myConnection   =   new   SqlConnection(myConnString);  
        SqlCommand   myCommand   =   new   SqlCommand(mySelectQuery,myConnection);  
        myConnection.Open();  
        SqlDataReader   myReader   =   myCommand.ExecuteReader();  
        try    
        {  
            while   (myReader.Read())    
            {  
                Console.WriteLine(myReader.GetInt32(0)   +   ",   "   +   myReader.GetString(1));  
            }  
          }  
          finally    
          {  
          //   always   call   Close   when   done   reading.  
          myReader.Close();  
          //   always   call   Close   when   done   reading.  
          myConnection.Close();  
          }  
    }  
   
  Top

4 楼venket（创业先锋）回复于 2004-08-19 08:15:09 得分 0

你用recordcount    
  不就一下在全出咯！！！！！Top

5 楼colinliu（流浪人）回复于 2004-08-19 08:21:26 得分 2

myCommand.CommandText   =   "SELECT   COUNT(*)   as   sum   FROM   tMessages   WHERE   NameID='"   +UserID+   "'";  
   
   
  用as   給它取個別名。。。。Top

相关问题

• myreader
• nameid
• mycommand
• myconnection
• commandtext
• userid
• select count
• close
• reading
• from tmessages where

• 帖主：xz1234
• scwsm
• scwsm
• colinliu

• SQL Server类图书