try this:-
clsConnection sqlConn = new clsConnection();
SqlCommand sqlComm = new SqlCommand();
DataTable dt = new DataTable();
sqlComm.Connection = sqlConn.connection;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.CommandText = "ElectricityData.Schedules_LoadGrid";
sqlComm.Parameters.Add("@MeterID", SqlDbType.Int).Value = iMeterID2;
sqlComm.Parameters.Add("@ReadingType", SqlDbType.VarChar, 50).Value = cboReadingType2.Text.ToString().Trim();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = sqlComm;
da.Fill(dt);
dgvSchedules.ReadOnly = true;
dgvSchedules.Rows.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvSchedules.Rows.Add();
dgvSchedules.Rows[i].Cells["colMeterNumber"].Value=dt.Rows[i]["MeterNumber"].ToString();
dgvSchedules.Rows[i].Cells["colDescription"].Value=dt.Rows[i]["Description"].ToString();
dgvSchedules.Rows[i].Cells["colType"].Value=dt.Rows[i]["Type"].ToString();
dgvSchedules.Rows[i].Cells["colDateTimeFrom"].Value=dt.Rows[i]["DateTimeFrom"].ToString();
if(Convert.ToBoolean(dt.Rows[i]["Enabled"])==false)
{
dgvSchedules.Rows[i].Cells["colEnabled"].Value=false;
}
else(Convert.ToBoolean(dt.Rows[i]["Enabled"])==true)
{
dgvSchedules.Rows[i].Cells["colEnabled"].Value=true;
}
}
Please don't forget to mark this as your answer if it helps you out.
Thanks