try like this
ASPX
<form id="form1" runat="server">
<asp:GridView ID="gridView" runat="server" AutoGenerateColumns="true">
</asp:GridView>
<h2>Count</h2>: <asp:Label ID="lblCount" runat="server"></asp:Label>
</form>
Stored Procedure
create procedure spGetDetails
as begin
select count(*) from SomeTable
select Column1,Column2, ... ColumnN from SomeTable2
end
Code Behind
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string connectionString = "Your Connection string";
SqlConnection con = new SqlConnection (connectionString);
SqlCommand cmd = new SqlCommand("spGetDetails", con) { CommandType = CommandType.StoredProcedure};
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dtCount = ds.Tables[0];
DataTable dtGridData = ds.Tables[1];
if (dtCount.Rows.Count == 1)
lblCount.Text = dtCount.Rows[0][0].ToString();
gridView.DataSource = dtGridData;
gridView.DataBind();
}
}