62,046
社区成员
发帖
与我相关
我的任务
分享求教：怎么写这个函数
一个表中，怎样知道张三有几条记录，李四有几条记录，王五有几条记录？
写一个函数，能够返回一个数字，比如：3（代表张三有3条记录）
写一个函数，能够返回一个数字，比如：3（代表张三有3条记录）
...全文
请发表友善的回复…
发表回复
SharpRose 2004-01-20
- 打赏
- 举报
是的，要好好看看，谢谢~！
ern 2004-01-20
- 打赏
- 举报
呵呵，简单的sql而已啦。楼主稍微看看数据库吧
DimVar 2004-01-20
- 打赏
- 举报
e.g,
public int GetNumber(string name)
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand myCommand = new SqlCommand("SELECT COUNT(*) AS CountOfRecords FROM yourTable WHERE Name = '" + name + "'",myConnection);
myCommand.CommandType = CommandType.Text;
myConnection.Open();
int i = (int) myCommand.ExecuteScalar();
myConnection.Close();
return i;
}
public int GetNumber(string name)
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand myCommand = new SqlCommand("SELECT COUNT(*) AS CountOfRecords FROM yourTable WHERE Name = '" + name + "'",myConnection);
myCommand.CommandType = CommandType.Text;
myConnection.Open();
int i = (int) myCommand.ExecuteScalar();
myConnection.Close();
return i;
}
DimVar 2004-01-20
- 打赏
- 举报
strSQL = "SELECT COUNT(*) AS CountOfRecords FROM yourTable WHERE NAME = '张三'"
