c#关于查寻数据库的行数
1
private void button1_Click(object sender, EventArgs e)
2
{
3
// 数据库连接
4
SqlConnection con = new SqlConnection("server=.;database=Northwind;uid=sa;pwd=0");
5
con.Open();
6![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
//查询记录数
8
SqlCommand cmd = new SqlCommand("select count(*) from orders", con);
9![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
//反回首行首列
11
int count = Convert.ToInt32(cmd.ExecuteScalar());
12![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
//显示记录数
14
MessageBox.Show("Northwind数据库orders表共有 " + count + " 条记录! ");
15![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
}
17![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
白虎
![](http://www.cnblogs.com/Emoticons/yoyocici/224026138.gif)