hi
in my .aspx page i have put a label to show the total amount of my ads in the table. But how i can code it in server side to make this label show the count statment , i need a little help please with my code below
protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection adsviewsqlcon = new SqlConnection(sc))
{
adsviewsqlcon.Open();
SqlDataAdapter dashowadsone = new SqlDataAdapter("select count (AdsID) FROM ads", sc);
//DataSet countriesads = new DataSet();
Sumofadslbl.Text = dashowadsone.ToString();
}
}
Go to the complete details ...