Casting Error!!!!

[Guest]

Hi All,

I am having a problem with the following code:

During the Item Bound event is am getting a 'Cast' error for this line:
if(!((DbDataRecord)e.Item.DataItem).IsDBNull(2))

Any thoughts why this is happening?

Cheers,
Adam

private DataView GetEnrollments()
{

//create db connection
SqlConnection Cn = new
SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);

//open db connection
Cn.Open();

//sql command to retrieve students
SqlCommand cmdGetElligibleStudents = new
SqlCommand("GetElegibleStudents",Cn);
cmdGetElligibleStudents.CommandType = CommandType.StoredProcedure;
cmdGetElligibleStudents.Parameters.Add("@CourseID",
Request.QueryString["CourseID"]);

DataSet dsElligibleStudents = new DataSet();

DataAdapter daElligibleStudents = new
SqlDataAdapter(cmdGetElligibleStudents);
daElligibleStudents.Fill(dsElligibleStudents);

//create DataView out of DataSource
DataView dvEnrollments = new DataView(dsElligibleStudents.Tables[0]);

//close db connection
Cn.Close();

return dvEnrollments;

}

public void dgEnrollments_ItemBound(object sender, DataGridItemEventArgs e)
{

if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem)
{

if(!((DbDataRecord)e.Item.DataItem).IsDBNull(2))
{

((CheckBox)e.Item.FindControl("chkEnrolled")).Checked = true;

}

}

 

[Laurent Bugnion]

Hi,

Hi All,

I am having a problem with the following code:

During the Item Bound event is am getting a 'Cast' error for this line:
if(!((DbDataRecord)e.Item.DataItem).IsDBNull(2))

Any thoughts why this is happening?

Cheers,
Adam

Are you sure that e.Item.DataItem exists and is not null?

HTH,
Laurent

 

[Guest]

find out the exact type by debugging the code.

check out
http://www.velocityreviews.com/forums/t121438-dbdatarecord-cast-error.html

Regards,
Augustin
http://augustinprasanna.blogspot.com

 

[Kevin Jones]

Why are you expecting e.Item.DataItem to be a DbDataRecord, in my
testing I see the DataItem as a DataRowView type,

Kevin