Row Item in DataView - OnRowDatabound event

[Elmo Watson]

I previously had a project working, in which the Gridview was populated by a
DataSet - then, with a DropDownlist in one of the columns, using the
OnrowDataBound event, to populate the DDL with the correct item in the
returned data, I had :
myDDL.SelectedV alue =
IIf(IsDBNull(My DataSet.Rows(e. Row.RowIndex).I tem("Fieldname" )),
vbNullString, MyDataSet.Rows( e.Row.RowIndex) .Item("Fieldnam e"))

In my new application, I'm using a DataView to populate the Gridview, since
there are filters which need to be used, dynamically - - I tried the same
kind of thing, but I'm not sure how it would work with a DataView:

Here's what I have that doesn't work:
..SelectedValue = IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

myDVis saved in cache, and retrieved when needed. However, I get the dreaded
"Object Reference not set to an instance of the object' error when it gets
to that line)
(and yes, this all between an "If e.Row.RowType = DataControlRowT ype.DataRow
Then" block

Any ideas on how to get that to work?

[Alvin Bruney [MVP]]

This is really the old way of doing things. The new way would be to first
convert the gridview column that contains the dropdown to a template column,
add a dropdown control, add an sqldatasource, bind the sqldatasource to the
database to get the column field and then bind the dropdown to
sqldatasource. The benefit is zero code and zero event hookup.

Here's what I have that doesn't work:
.SelectedValue =
IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

I believe there is a bug here. You are using the row index to index into the
dataview items. There's no guarantee that the two will map to the same hence
the null object error. You'd be better served mapping to the respective row
of the dataview object instead of indexing into its item collection.
Something like myDV.Tables.Row s(e.Row.Rowinde x should get you started on the
right path.
--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"Elmo Watson" <sp*****@yahoo. comwrote in message
news:eV******** ******@TK2MSFTN GP03.phx.gbl...

>I previously had a project working, in which the Gridview was populated by
a
DataSet - then, with a DropDownlist in one of the columns, using the
OnrowDataBound event, to populate the DDL with the correct item in the
returned data, I had :
myDDL.SelectedV alue =
IIf(IsDBNull(My DataSet.Rows(e. Row.RowIndex).I tem("Fieldname" )),
vbNullString, MyDataSet.Rows( e.Row.RowIndex) .Item("Fieldnam e"))

In my new application, I'm using a DataView to populate the Gridview,
since
there are filters which need to be used, dynamically - - I tried the same
kind of thing, but I'm not sure how it would work with a DataView:

Here's what I have that doesn't work:
.SelectedValue =
IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

myDVis saved in cache, and retrieved when needed. However, I get the
dreaded
"Object Reference not set to an instance of the object' error when it gets
to that line)
(and yes, this all between an "If e.Row.RowType =
DataControlRowT ype.DataRow
Then" block

Any ideas on how to get that to work?

[Elmo Watson]

I agree with you to a point, but not all situations provide the choice for
that one scenario. As far as I know, the DataSource controls either provide
a DataSet or DataReader.
The problem is, that, at this point, it can't be re-constructed - this is
all object based, and the connection is made using an object, a DataView is
returned, so filters can be applied.
I tried myDV.Table.Rows (e.row.RowIndex )
however I get the same error.

"Alvin Bruney [MVP]" <www.lulu.com/owcwrote in message
news:Os******** ******@TK2MSFTN GP04.phx.gbl...

This is really the old way of doing things. The new way would be to first
convert the gridview column that contains the dropdown to a template

column,

add a dropdown control, add an sqldatasource, bind the sqldatasource to

the

database to get the column field and then bind the dropdown to
sqldatasource. The benefit is zero code and zero event hookup.

Here's what I have that doesn't work:
.SelectedValue =
IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

I believe there is a bug here. You are using the row index to index into

the

dataview items. There's no guarantee that the two will map to the same

hence

the null object error. You'd be better served mapping to the respective

row

of the dataview object instead of indexing into its item collection.
Something like myDV.Tables.Row s(e.Row.Rowinde x should get you started on

the

right path.
--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"Elmo Watson" <sp*****@yahoo. comwrote in message
news:eV******** ******@TK2MSFTN GP03.phx.gbl...

I previously had a project working, in which the Gridview was populated

by

a
DataSet - then, with a DropDownlist in one of the columns, using the
OnrowDataBound event, to populate the DDL with the correct item in the
returned data, I had :
myDDL.SelectedV alue =
IIf(IsDBNull(My DataSet.Rows(e. Row.RowIndex).I tem("Fieldname" )),
vbNullString, MyDataSet.Rows( e.Row.RowIndex) .Item("Fieldnam e"))

In my new application, I'm using a DataView to populate the Gridview,
since
there are filters which need to be used, dynamically - - I tried the

same

kind of thing, but I'm not sure how it would work with a DataView:

Here's what I have that doesn't work:
.SelectedValue =
IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

myDVis saved in cache, and retrieved when needed. However, I get the
dreaded
"Object Reference not set to an instance of the object' error when it

gets

to that line)
(and yes, this all between an "If e.Row.RowType =
DataControlRowT ype.DataRow
Then" block

Any ideas on how to get that to work?

[Alvin Bruney [MVP]]

Couple things wrong in your code. I provide the correct syntax below -
you'll need to translate into vb. Additionally, the rowindex isn't valid for
the gridview header, it actually is set to -1. That is an invalid index in
the dataview. You'll need to trap for that condition to avoid the header
row. Here's working code.

DataView view = (DataView)Sessi on["view"];

if (view == null)

{

Response.Write( "<script>alert( 'empty')</script>");

}

else

{

if (e.Row.RowIndex -1)

{

object[] items = view.Table.Rows[e.Row.RowIndex].ItemArray;

string str = items[3].ToString();

}

}
--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"Elmo Watson" <sp*****@yahoo. comwrote in message
news:uK******** ******@TK2MSFTN GP02.phx.gbl...

>I agree with you to a point, but not all situations provide the choice for
that one scenario. As far as I know, the DataSource controls either
provide
a DataSet or DataReader.
The problem is, that, at this point, it can't be re-constructed - this is
all object based, and the connection is made using an object, a DataView
is
returned, so filters can be applied.
I tried myDV.Table.Rows (e.row.RowIndex )
however I get the same error.

"Alvin Bruney [MVP]" <www.lulu.com/owcwrote in message
news:Os******** ******@TK2MSFTN GP04.phx.gbl...

>This is really the old way of doing things. The new way would be to first
convert the gridview column that contains the dropdown to a template

column,

>add a dropdown control, add an sqldatasource, bind the sqldatasource to

the

>database to get the column field and then bind the dropdown to
sqldatasourc e. The benefit is zero code and zero event hookup.

Here's what I have that doesn't work:
.SelectedValue =
IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

I believe there is a bug here. You are using the row index to index into

the

>dataview items. There's no guarantee that the two will map to the same

hence

>the null object error. You'd be better served mapping to the respective

row

>of the dataview object instead of indexing into its item collection.
Something like myDV.Tables.Row s(e.Row.Rowinde x should get you started on

the

>right path.
--
______________ __________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"Elmo Watson" <sp*****@yahoo. comwrote in message
news:eV******* *******@TK2MSFT NGP03.phx.gbl.. .

>I previously had a project working, in which the Gridview was populated

by

>a
DataSet - then, with a DropDownlist in one of the columns, using the
OnrowDataBound event, to populate the DDL with the correct item in the
returned data, I had :
myDDL.SelectedV alue =
IIf(IsDBNull(My DataSet.Rows(e. Row.RowIndex).I tem("Fieldname" )),
vbNullString, MyDataSet.Rows( e.Row.RowIndex) .Item("Fieldnam e"))

In my new application, I'm using a DataView to populate the Gridview,
since
there are filters which need to be used, dynamically - - I tried the

same

kind of thing, but I'm not sure how it would work with a DataView:

Here's what I have that doesn't work:
.SelectedValue =
IIf(IsDBNull(my DV.Item(e.Row.R owIndex).Item(" Fieldname")),
vbNullString, myDV.Item(e.Row .RowIndex).Item ("Fieldname" ))

myDVis saved in cache, and retrieved when needed. However, I get the
dreaded
"Object Reference not set to an instance of the object' error when it

gets

to that line)
(and yes, this all between an "If e.Row.RowType =
DataControlRowT ype.DataRow
Then" block

Any ideas on how to get that to work?