Re: How to handle null values in DataBinder.Eval()

Thank you for your answer.

But how would I do that?
Because if it is null, is it your intention to replace it with "" in case of
a strng and a 0 in case of a integer?

Then I should put the following code in the code behind like:

....
for each (Column cl in ds.Tables[i].Rows[j].Columns) )
{
if (cl.IsDBnull(cl))
{
if (cl.Type == DataType.Integer)
{
cl.Value = 0;
}
....
}
ds.ApplyUpdates()

something like this?

Or is there another way?
"Scott M." wrote:

> You should test for null using IsDBNull(object) prior to allowing the value
> in question to be used in your repeater.
>
>
> "eddy de boer" <eddydeboer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:0F9749C0-80E4-4C2B-8350-FC0BDEC183D7@xxxxxxxxxxxxxxxx
> > Hello,
> >
> > in my aspx page I have the followong code:
> >
> > <asp:Repeater id="Repeater1" runat="server">
> > <ItemTemplate>
> > ...
> > <%# Server.HtmlDecode((string)DataBinder.Eval(Container.DataItem,"tekst"))
> > %>
> > ...
> > </ItemTemplate>
> > </asp:Repeater>
> >
> > Whereby "tekst" one of the columns is being loaded in the dataset
> > In the code behind page data is loaded as as follows:
> >
> > ...
> > meetmate.DataLayer.Meetings m = new meetmate.DataLayer.Meetings();
> > ds = m.GetMeetingByID(meetingID);
> > dr = ds.Tables[0].Rows[0];
> > DataView dv = new DataView(ds.Tables[0]);
> > this.Repeater1.DataSource = dv;
> > this.Repeater1.DataBind();
> > ...
> >
> > The problem is that column "tekst" can be null.
> > In that case, I'm getting an error on
> > <%# Server.HtmlDecode((string)DataBinder.Eval(Container.DataItem,"tekst"))
> > %>
> > because the (string) cast then goes wrong. If "tekst" is not null, it is
> > ok.
> >
> > Now this is just for "tekst", but also other columns in my table could be
> > null.
> > How can I deal with this is a nice way?
> >
> > Eddy de Boer
> >
> >
>
>
>
.

Relevant Pages

  • Re: le bon criminel aime la vie
    ... et ne plus confondre toutes les actions du criminel dans la même et unique ... intention de nuire. ... Looping ... Prev by Date: ...
    (soc.culture.belgium)
  • Re: [humour] Georgie ! :)
    ... > aucune réserve, car mon intention était de rigoler, pas d'insulter. ... Tout à fait d'accord avec elle. ... Ça vous va fort mal, ... Prev by Date: ...
    (soc.culture.belgium)
  • Re: Setting user password in Active Directory
    ... If you ask this in one of the security newsgroups, ... your intention with this), than I give you a much better change on an ... Cor ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: OleDbDataAdapter.Fill(DataTable)
    ... Did you read what Cristian wrote, it has the same intention as my message. ... Can it be that you made a typo in the name of the datatable or whatever. ... Cor ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Likert Scale Analysis
    ... It was not my intention to open up this discussion all over again ... (interval vs ordinal data). ... Julia ... Prev by Date: ...
    (sci.stat.edu)