conditional in datagrid column

[DC Gringo]

I have a simple datagrid and need to output the value of "0" (zero) if the
value is null.

<asp:BoundColum n DataField="clnP opulationCensus "
SortExpression= "clnPopulationC ensus" HeaderText="Pop ulation (Census)"
DataFormatStrin g=""></asp:BoundColumn >

Would this go in the DataFormatStrin g column? Or somewhere else?

Here's my adapter:

'SqlDataAdapter 1
'
Me.SqlDataAdapt er1.SelectComma nd = Me.SqlSelectCom mand1
Me.SqlDataAdapt er1.TableMappin gs.AddRange(New
System.Data.Com mon.DataTableMa pping() {New
System.Data.Com mon.DataTableMa pping("Table", "sac1SelectSurv ey1", New
System.Data.Com mon.DataColumnM apping() {New
System.Data.Com mon.DataColumnM apping("clnGUID ", "clnGUID"), New
System.Data.Com mon.DataColumnM apping("clnPrio rityCorrectedTC ",
"clnPriorityCor rectedTC"), New
System.Data.Com mon.DataColumnM apping("clnMADo neTC", "clnMADoneT C"), New
System.Data.Com mon.DataColumnM apping("clnMASc hoolTC", "clnMASchoolTC" ), New
System.Data.Com mon.DataColumnM apping("clnMAPo sterTC", "clnMAPosterTC" ), New
System.Data.Com mon.DataColumnM apping("clnMARa dioTC", "clnMARadioTC") , New
System.Data.Com mon.DataColumnM apping("clnMAPe rformingGroupTC ",
"clnMAPerformin gGroupTC"), New
System.Data.Com mon.DataColumnM apping("clnMACo mmunityCenterTC ",
"clnMACommunity CenterTC"), New
System.Data.Com mon.DataColumnM apping("clnMARe ligiousOrganiza tionTC",
"clnMAReligious OrganizationTC" ), New
System.Data.Com mon.DataColumnM apping("clnMAOt herTC", "clnMAOtherTC") , New
System.Data.Com mon.DataColumnM apping("clnMAOt her", "clnMAOther "), New
System.Data.Com mon.DataColumnM apping("clnMAOr ganisation",
"clnMAOrganisat ion")}), New System.Data.Com mon.DataTableMa pping("Table1",
"Table1", New System.Data.Com mon.DataColumnM apping() {New
System.Data.Com mon.DataColumnM apping("clnGUID ", "clnGUID"), New
System.Data.Com mon.DataColumnM apping("clnName ", "clnName")} )})
--
_______________ ___________
Glenn Levine
gl*********@hot mail.com

Cell: [phone]
Home: [phone]

"One never knows, does one?"

[Cor]

Hi DC Gringo,

I cannot see if you did use the designer from VS.net and did drag things to
your form, but when you want to put a datatable from a database in a
datagrid you need minimal the folowing

a connection with your database (SqlConnection)
a dataset
a SqlDataAdapter
a Datagrid

The dataset can be bounded using the datasourse to the datagrid.

To see a lot of examples for that try to use this.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor

[Herfried K. Wagner [MVP]]

* "DC Gringo" <dc******@visio ntechnology.net > scripsit:

I have a simple datagrid and need to output the value of "0" (zero) if the
value is null.

<asp:BoundColum n DataField="clnP opulationCensus "
SortExpression= "clnPopulationC ensus" HeaderText="Pop ulation (Census)"
DataFormatStrin g=""></asp:BoundColumn >

Group for ASP.NET DataGrid:

<news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.aspnet.data gridcontrol>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[DC Gringo]

Cor,

Yes, of course, all of that is in place and my datagrid is showing. I did
use the VS.NET designer as you described. What I'm looking for help on is
how to alter data values based on conditional processing within this
framework.

In particular, if a data value is null, I want to show a zero or a "none"
value.

_____
Glenn

I'm just looking to deal with the output.
"Cor" <no*@non.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi DC Gringo,

I cannot see if you did use the designer from VS.net and did drag things to your form, but when you want to put a datatable from a database in a
datagrid you need minimal the folowing

a connection with your database (SqlConnection)
a dataset
a SqlDataAdapter
a Datagrid

The dataset can be bounded using the datasourse to the datagrid.

To see a lot of examples for that try to use this.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor

[Cor]

Hi DC,

I am not that deep in the datagrid webcontrol that I know if there are easy
posibilities for your last question. But you can ask this also in the

Microsoft.publi c.dotnet.framew ork.aspnet.data gridcontrol newsgroup.

However because you did all with the designer I think you are limited and
for this kind of things you mostly have to go deep in the code.

databinding events can maybe do something for you. But for that you have to
go really deep in handmade code.

An alternative is adding extra colomns to your datasource but that needs
good knowledge from datatables.

However better is if you ask your question as simple as you ask did in your
last message in the newsgroup I did tell you above.

But do not forget to tell that you did make everything using the designer,
otherwise you get scripting answers or very deep hand made answers.

Sorry no solution in this answer.

Cor

Yes, of course, all of that is in place and my datagrid is showing. I did
use the VS.NET designer as you described. What I'm looking for help on is
how to alter data values based on conditional processing within this
framework.

In particular, if a data value is null, I want to show a zero or a "none"
value.

_____
Glenn

I'm just looking to deal with the output.
"Cor" <no*@non.com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi DC Gringo,

I cannot see if you did use the designer from VS.net and did drag things

to

your form, but when you want to put a datatable from a database in a
datagrid you need minimal the folowing

a connection with your database (SqlConnection)
a dataset
a SqlDataAdapter
a Datagrid

The dataset can be bounded using the datasourse to the datagrid.

To see a lot of examples for that try to use this.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor

[Chan]

When I try to change the header text after Databind for a column I am getting the following error:
dgTest.Columns( 0).HeaderText = "TEST#"

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

PS: I am using .Net 2002 with servicepack2