private void btnSearchByDate_Click_1(object sender, EventArgs e) { try { DataTable dt = Class_Fees.usp_GetFeesByDate(dateTimePicker1.Value.Date); dataGridView1.DataSource = dt; txtNombreRecu.Text = dt.Rows.Count.ToString(); decimal daily = 0.00M; foreach (DataRow dr in dt.Rows) { daily += Convert.ToDecimal(dr[6]); } txtDaily.Text = daily.ToString(); } catch (Exception ex) { // throw; } }