-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BanupriyaVelmurugan
Message 1 in Discussion
Hi This is such a long query that I am posting.. Please read this with full
passion & give me some better sollution..... My requirement is to get the
SSNs from the user and generate the report based on the SSNs entered. I
created the datagrid inside a loop in aspx page as: <%For intICount = 0 To
UBound(strSSN) - 1%>
<%If strSSN(intICount) <> "" Then%>
<%If strUserInfo(0) <> Nothing Then%>
<tr>
<td align="center" colspan=2>
<%--<asp:DataList ID="dList" Runat="server" RepeatDirection="vertical"
RepeatLayout="Table" GridLines="Horizontal" BorderColor="whitesmoke"
ForeColor="Black" Font-Size="8pt" Font-Name="Arial" BackColor="White"
BorderWidth="1px" EnableViewState="false" OnItemDataBound="OnMainListDataBound">
<ItemTemplate>--%>
<asp:datagrid id="dgrdReport1" runat="server" ForeColor="Black"
AllowSorting="True" Width="100%" AutoGenerateColumns="False" AllowPaging="true"
GridLines="vertical" CellPadding="0" BackColor="white" BorderWidth="0px"
BorderStyle="Solid" BorderColor="#999999" OnItemDataBound="OnMainGridDataBound">
<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="white"
Width="100%"></HeaderStyle>
<ItemStyle CssClass="clsBlacksmallText" Width="100%"></ItemStyle>
<AlternatingItemStyle BackColor="White" CssClass="clsBlacksmallText"
Width="100%"></AlternatingItemStyle>
<PagerStyle Visible="false" HorizontalAlign="Center"
ForeColor="Black" BackColor="#999999"></PagerStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr bgcolor="#33a533">
<td><font class=HeaderText><%=objReport.tit3%></font></td>
<td><font class=HeaderText><%=objReport.tit11%></font></td>
<td><font class=HeaderText><%=objReport.tit10%></font></td>
<td><font class=HeaderText><%=objReport.tit26%></font></td>
<td><font class=HeaderText><%=objReport.Label7%></font></td>
<td><font class=HeaderText><%=objReport.tit27%></font></td>
<td><font class=HeaderText><%=objReport.tit36%></font></td>
<td><font class=HeaderText><%=objReport.tit54%></font></td>
<td><font class=HeaderText><%=objReport.tit38%></font></td>
</tr>
<tr>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"UserID")%></td>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"LastName")%></td>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"FirstName")%></td>
<td class="clsBlacksmallText"><%#
DisplayDOT(DataBinder.Eval(Container.DataItem,"DOTDrugStatus"))%></td>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"Name")%> (<%#
DataBinder.Eval(Container.DataItem,"ProjectCode")%>)</td>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"CompanyName")%></td>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"CertStatus")%></td>
<td class="clsBlacksmallText"><%#
DataBinder.Eval(Container.DataItem,"SponsorName")%></td>
<td class="clsBlacksmallText"><%=objReport.tit39%></td>
</tr>
</table>
</td>
</tr>
<tr Bgcolor="DarkGray">
<td height="25"><font class="HeaderText"> Core
Course(s)</font></td>
</tr>
<tr>
<td>
<asp:DataGrid id="dgrdReport2" runat="server"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" BackColor="White"
CellPadding="2" GridLines="vertical" ForeColor="Black"
AutoGenerateColumns="False" Width="100%">
<HeaderStyle CssClass="clsBlacksmallTextBold"
BackColor="DarkGray"></HeaderStyle>
<ItemStyle CssClass="clsBlacksmallText"></ItemStyle>
<AlternatingItemStyle BackColor="#DCDCDC"
CssClass="clsBlacksmallText"></AlternatingItemStyle>
<PagerStyle Visible="false" HorizontalAlign="Center"
ForeColor="Black" BackColor="#999999"></PagerStyle>
<Columns>
<asp:TemplateColumn>
<HeaderStyle Width="40%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit21%></HeaderTemplate>
<ItemTemplate>
<a
href="javascript:PopCrsLibDesc('<%#DataBinder.Eval(Container.DataItem,"CourseID")%>','<%#DataBinder.Eval(Container.DataItem,"LONG_NAME")%>')"class=black><%#
DataBinder.Eval(Container.DataItem,("LONG_NAME"))%></a>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle Width="20%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit22%></HeaderTemplate>
<ItemTemplate>
<%#DisplayPreTest(DataBinder.Eval(Container.DataItem,("PreTestCompleted")))%>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle Width="20%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit23%></HeaderTemplate>
<ItemTemplate>
<%#
DisplayMasteredDate(DataBinder.Eval(Container.DataItem,("MASTEREDDATE")))%>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle Width="20%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit24%></HeaderTemplate>
<ItemTemplate>
<%#
DisplayStatus(DataBinder.Eval(Container.DataItem,("COURSESTATUS")))%>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td valign="top">
<asp:Label ID="lblNonCoreResult" Runat="server"
BackColor="DarkGray" Height="20" Width="100%"><font
class="HeaderText"> Non-Core Course(s)</font></asp:Label>
<asp:DataGrid id="dgrdReport3" runat="server"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" BackColor="White"
CellPadding="2" GridLines="vertical" ForeColor="Black"
AutoGenerateColumns="False" Width="100%">
<HeaderStyle CssClass="clsBlacksmallTextBold"
BackColor="DarkGray"></HeaderStyle>
<ItemStyle CssClass="clsBlacksmallText"></ItemStyle>
<AlternatingItemStyle BackColor="#DCDCDC"
CssClass="clsBlacksmallText"></AlternatingItemStyle>
<PagerStyle Visible="false" HorizontalAlign="Center"
ForeColor="Black" BackColor="#999999"></PagerStyle>
<Columns>
<asp:TemplateColumn>
<HeaderStyle Width="40%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit21%></HeaderTemplate>
<ItemTemplate>
<a
href="javascript:PopCrsLibDesc('<%#DataBinder.Eval(Container.DataItem,"CourseID")%>,<%#DataBinder.Eval(Container.DataItem,"LONG_NAME")%>')"class=black><%#
DataBinder.Eval(Container.DataItem,("LONG_NAME"))%></a>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle Width="20%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit22%></HeaderTemplate>
<ItemTemplate>
<%#DisplayPreTest(DataBinder.Eval(Container.DataItem,("PreTestCompleted")))%>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle Width="20%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit23%></HeaderTemplate>
<ItemTemplate>
<%#
DisplayMasteredDate(DataBinder.Eval(Container.DataItem,("MASTEREDDATE")))%>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<HeaderStyle Width="20%"></HeaderStyle>
<HeaderTemplate><%=objReport.tit24%></HeaderTemplate>
<ItemTemplate>
<%#
DisplayStatus(DataBinder.Eval(Container.DataItem,("COURSESTATUS")))%>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
</table>
<br>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
<%--</ItemTemplate>
</asp:DataList> --%>
</td>
</tr>
<%else%>
<!--<tr><td align="center" colspan=2>SSN Not Found</td></tr>-->
<%end if%>
<%end if%>
<%next%> and the code behind I used is as: in Page load: If
dsS2WStatus.Tables(0).Rows.Count > 0 Then
dvS2WStatus1 = GetNewDataView()
dList.DataSource = dvS2WStatus1
dList.DataBind()
End If in OnMainGridDataBound() Public Sub OnMainGridDataBound(ByVal sender
As Object, ByVal e As DataGridItemEventArgs)
If e.Item.ItemType = ListItemType.AlternatingItem Or e.Item.ItemType =
ListItemType.Item Then
Dim dvS2WStatus As New DataView
dvS2WStatus = New DataView(dsS2WStatus.Tables(0))
dvS2WStatus.Sort = "UserID"
Dim PrimUserID As String
PrimUserID = DataBinder.Eval(e.Item.DataItem, "UserID")
Dim obCtl As New Control
Dim obCtl1 As New Control
Dim dgrdTemp As New DataGrid
Dim lblTemp As New Label
Dim arrDataRowView() As DataRowView 'To display the
test details
obCtl = e.Item.FindControl("dgrdReport2")
If (Not obCtl Is Nothing) And (TypeOf obCtl Is DataGrid) Then
dgrdTemp = CType(obCtl, DataGrid)
dvS2WStatus.RowFilter = "IsCoreCourse='true'"
arrDataRowView = dvS2WStatus.FindRows(PrimUserID)
dgrdTemp.DataSource = arrDataRowView
dgrdTemp.DataBind()
End If
obCtl = e.Item.FindControl("dgrdReport3")
If (Not obCtl Is Nothing) And (TypeOf obCtl Is DataGrid) Then
dgrdTemp = CType(obCtl, DataGrid)
dvS2WStatus.RowFilter = "IsCoreCourse='false' and
CourseStatus='Current'"
arrDataRowView = dvS2WStatus.FindRows(PrimUserID)
dgrdTemp.DataSource = arrDataRowView
dgrdTemp.DataBind()
If arrDataRowView.Length > 0 Then
dgrdTemp.Visible = True
obCtl1 = e.Item.FindControl("lblNonCoreResult")
If (Not obCtl1 Is Nothing) And (TypeOf obCtl1 Is Label) Then
lblTemp = CType(obCtl1, Label)
lblTemp.Visible = True
End If
Else
dgrdTemp.Visible = False
obCtl1 = e.Item.FindControl("lblNonCoreResult")
If (Not obCtl1 Is Nothing) And (TypeOf obCtl1 Is Label) Then
lblTemp = CType(obCtl1, Label)
lblTemp.Visible = False
End If
End If
End If
End If
End Sub Form this code I am able to display the result of 2nd/ Last SSN
entered by the user. I want to loop the datagrid if the number of SSN entered
is more than 1 and display the report for each and every SSN. Please guide me
to do this..... Thanks & Regards Banu Can U please
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
