select count(*) from 你的表 where 你的条件

------解决方案--------------------
用IBatis。写个XML就可以了。

------解决方案--------------------
select count(*) from 你的表 where 你的条件

------解决方案--------------------
C# code

SqlConnection conn = new SqlConnection("data source=.;uid=sa;pwd=;database=test");
string mysql="select count(*) from test"; 
SqlDataAdapter myDapter=new SqlDataAdapter(mysql,conn); 
DataSet ds=new DataSet(); 
myDapter.Fill(ds); 
DataTable dt = ds.Tables[0]; 
if(dt.Rows.Count >=1) 
{ 
    this.label1.Text = "一共有" + dt.Rows[0][0].ToString() + "条数据";
    MessageBox.Show("登录成功");
} 
else 
{ 
    MessageBox.Show("登录失败");
}

------解决方案--------------------
private void Page_Load(object sender, System.EventArgs e)
	{
		string strCnn="data source=(local);Initial Catalog=bookstore;UserId=**;Pwd=**;Connection Timeout=30";
		SqlConnection sqlCnn=new SqlConnection(strCnn);
		sqlCnn.Open();
               SqlCommand sqlCmd=sqlCnn.CreateCommand();
               sqlCmd.CommandType=CommandType.Text;
		SqlDataReader sqlReader;
		sqlCmd.CommandText="Select * from T_Publishers where Pub_Addr like @addr";
		sqlCmd.Parameters.Add("@Addr",SqlDbType.VarChar,50);
		sqlCmd.Parameters["@Addr"].Value="西安%";
	        sqlReader=sqlCmd.ExecuteReader();
		DataGrid1.DataSource=sqlReader;
		DataGrid1.DataBind();
		sqlReader.Close();