Datagrid column question.

[JenHu]

I have a datagrid (dgFundStatus) which displays a [Transmit_Date]
column.
When the Transmit_Date is null, how can I show "Not transmit yet"
instead of null?

Thanks.
Sub BindData()
Dim strSql As New SqlCommand
Dim dtrDataGrid As SqlDataReader
Dim dataAdapter As New SqlDataAdapter
Dim dataSet As New DataSet
Dim FilePath As String
If Not conEZDb.State = ConnectionState .Open Then
conEZDb.Open()
End If
Try
If Not IsPostBack Then
strSql.CommandT ext = "SELECT
Batch_Num,DD_Fi le_Name,Transmi t_Date FROM Epay_Batch_Tabl e "
strSql.Connecti on = conEZDb
strSql.CommandT ype = CommandType.Tex t
dataAdapter.Sel ectCommand = strSql
dataAdapter.Fil l(dataSet, "Funding")
Dim FundingInfo As DataTable = dataSet.Tables( "Funding")
Dim dvFundingInfo As New DataView(dataSe t.Tables("Fundi ng"))
Session("Fundin gSession") = dvFundingInfo
dvFundingInfo.S ort = strViewString
dgFundStatus.Da taSource = dvFundingInfo
dgFundStatus.Da taBind()
conEZDb.Close()
Catch err As Exception
End Try
End Sub
The transmit_date column in datagrid:
<asp:BoundColum n DataField="Tran smit_Date" HeaderText="Tra nsmit
Date" DataFormatStrin g="{0:MM/dd/yyyy}"></asp:BoundColumn >

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[Keef]

Hi Jen,

I suppose you could do a validation on the [Transmit_Date] column to check
whether the value is null, then assign the appropriate result to a
dynamically created column to replace the bound column "Transmit_Date" .

Not too sure if its the most effective way, but I hope it helps.
Best Regards

"JenHu" <je**********@h otmail-dot-com.no-spam.invalid> wrote in message
news:41******** **@Usenet.com.. .

I have a datagrid (dgFundStatus) which displays a [Transmit_Date]
column.
When the Transmit_Date is null, how can I show "Not transmit yet"
instead of null?

Thanks.
Sub BindData()
Dim strSql As New SqlCommand
Dim dtrDataGrid As SqlDataReader
Dim dataAdapter As New SqlDataAdapter
Dim dataSet As New DataSet
Dim FilePath As String
If Not conEZDb.State = ConnectionState .Open Then
conEZDb.Open()
End If
Try
If Not IsPostBack Then
strSql.CommandT ext = "SELECT
Batch_Num,DD_Fi le_Name,Transmi t_Date FROM Epay_Batch_Tabl e "
strSql.Connecti on = conEZDb
strSql.CommandT ype = CommandType.Tex t
dataAdapter.Sel ectCommand = strSql
dataAdapter.Fil l(dataSet, "Funding")
Dim FundingInfo As DataTable = dataSet.Tables( "Funding")
Dim dvFundingInfo As New DataView(dataSe t.Tables("Fundi ng"))
Session("Fundin gSession") = dvFundingInfo
dvFundingInfo.S ort = strViewString
dgFundStatus.Da taSource = dvFundingInfo
dgFundStatus.Da taBind()
conEZDb.Close()
Catch err As Exception
End Try
End Sub
The transmit_date column in datagrid:
<asp:BoundColum n DataField="Tran smit_Date" HeaderText="Tra nsmit
Date" DataFormatStrin g="{0:MM/dd/yyyy}"></asp:BoundColumn >

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[David Jessee]

Turn the Column into a TemplateColumn.
Then in the aspx file, change the resultant label's binding to:

Text='<%# IIF(Databinder. Eval(.......)=S tring.Empty,"No Cata
Here",Databinde r.Eval(...)) %>'

There's an easier way to do this, depending on your binding....but this will
work.
"JenHu" <je**********@h otmail-dot-com.no-spam.invalid> wrote in message
news:41******** **@Usenet.com.. .

I have a datagrid (dgFundStatus) which displays a [Transmit_Date]
column.
When the Transmit_Date is null, how can I show "Not transmit yet"
instead of null?

Thanks.
Sub BindData()
Dim strSql As New SqlCommand
Dim dtrDataGrid As SqlDataReader
Dim dataAdapter As New SqlDataAdapter
Dim dataSet As New DataSet
Dim FilePath As String
If Not conEZDb.State = ConnectionState .Open Then
conEZDb.Open()
End If
Try
If Not IsPostBack Then
strSql.CommandT ext = "SELECT
Batch_Num,DD_Fi le_Name,Transmi t_Date FROM Epay_Batch_Tabl e "
strSql.Connecti on = conEZDb
strSql.CommandT ype = CommandType.Tex t
dataAdapter.Sel ectCommand = strSql
dataAdapter.Fil l(dataSet, "Funding")
Dim FundingInfo As DataTable = dataSet.Tables( "Funding")
Dim dvFundingInfo As New DataView(dataSe t.Tables("Fundi ng"))
Session("Fundin gSession") = dvFundingInfo
dvFundingInfo.S ort = strViewString
dgFundStatus.Da taSource = dvFundingInfo
dgFundStatus.Da taBind()
conEZDb.Close()
Catch err As Exception
End Try
End Sub
The transmit_date column in datagrid:
<asp:BoundColum n DataField="Tran smit_Date" HeaderText="Tra nsmit
Date" DataFormatStrin g="{0:MM/dd/yyyy}"></asp:BoundColumn >

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[JenHu]

> David Jesseewrote:
Turn the Column into a TemplateColumn.

Then in the aspx file, change the resultant label's binding to:

Text='<%# IIF(Databinder. Eval(.......)=S tring.Empty,"No Cata
Here",Databinde r.Eval(...)) %>'

Thank you David. I am trying to use your suggestion in my code and
didn't get it work so far. PLEASE HELP!

here is my new code:
<asp:datagrid id="dgFundStatu s" AutoGenerateCol umns="False"
Runat="server">
<Columns>
<asp:BoundColum n DataField="Batc h_Num" HeaderText="Bat ch
#"></asp:BoundColumn >
<asp:BoundColum n DataField="DD_F ile_Name" HeaderText="Fil e
Name"></asp:BoundColumn >
<asp:BoundColum n DataField="File _Status_Descrip tion"
HeaderText="Fil e Status"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Tra nsmit Date">
<ItemTemplate >
<asp:label ID="lblTransDat e" Runat="server"
Text='<%#IIF(Da taBinder.Eval(C ontainer,"DataI tem.Transmit_Da te")=String.Emp ty,"No
file
Transmit",Datab inder.Eval(Cont ainer,"DataItem .Transmit_Date" ))%>'></asp:label>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:datagrid>

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*