System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection("连接字符串"); System.Data.SqlClient.SqlCommand cm = new System.Data.SqlClient.SqlCommand();
cm.Connection = cnn; cm.CommandText = "select top 10 * from table1"; System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cm); DataTable dt = new DataTable(); da.Fill(dt);
System.Data.SqlClient.SqlCommand cm = new System.Data.SqlClient.SqlCommand();
cm.Connection = cnn;
cm.CommandText = "select top 10 * from table1";
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cm); DataTable dt = new DataTable();
da.Fill(dt);
if(dt.Rows.Count>0)
{
}
else
{}
然后判断返回的数值
{
if(ds.Table[0].Row.Count>0)
{
有数据
}
else
{
无数据
}
}