1. Here you can see I am using Count(*) query and I am getting error there is a picture with the code
private void List_Load(object sender, EventArgs e)
{
try
{
if (Sqlcon.State == ConnectionState.Closed)
{
Sqlcon.Open();
}
string query = "Select Count(*) from AddCars ";
SqlDataAdapter sdr = new SqlDataAdapter(query, Sqlcon);
sdr.Fill(dt);
totaltbl.Text = dt.Rows[0][0].ToString();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}