Datagrid > DataList problem - Any clues?

Brock · Jul 8, 2008

Thanks in advance... (you can see a screenshot of what my form looks
like currently at http://www.juggernautical.com/DataGrid.jpg - the
Datalist is super-imposed in 'design view' but the DataGrid is the
actual running of the page) I've almost got this working (?) but need
a little help. I have an .aspx page that has a DataGrid listing
employees with a "Select" button that is to be used to populate the
DataList to the right of the DataGrid with additional employee
information. I'm basing this off the model found at
http://www.aspnet101.com/aspnet101/aspnet/codesample.aspx?code=choose
.. this is a very good example of what I'm trying to do. I can populate
the DataGrid with no problem, but the "Select" button will not
populate the DataList. BTW, I'm using framework 1.1 and Code behind
(all listed below), in addition I'm using Broker DLL's to get my data.
Any clues?

<%@ Page Language="vb" AutoEventWireup="false"
Codebehind="MainDepartment.aspx.vb"
Inherits="Forsyth.HR_ReportingTool.UI.MainDepartment" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>MainDepartment</title>
<META http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta content="False" name="vs_snapToGrid">
<meta content="False" name="vs_showGrid">
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5"
name="vs_targetSchema">
</HEAD>
<BODY background="file:///C:\Inetpub\wwwroot\HR_ReportingTool
\vignette.gif">
<div style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE:
medium; BORDER-LEFT-COLOR: white; LEFT: 50px; FLOAT: none; BORDER-
BOTTOM-COLOR: white; MARGIN-LEFT: 20px; OVERFLOW: auto; WIDTH: 734px;
CLIP: rect(auto auto auto auto); COLOR: black; BORDER-TOP-STYLE:
inset; BORDER-TOP-COLOR: white; TEXT-INDENT: 5%; FONT-FAMILY: 'Times
New Roman'; BORDER-RIGHT-STYLE: inset; BORDER-LEFT-STYLE: inset;
POSITION: absolute; TOP: 50px; HEIGHT: 599px; BACKGROUND-COLOR: white;
TEXT-ALIGN: left; BORDER-RIGHT-COLOR: white; BORDER-BOTTOM-STYLE:
inset"
align="left">
<DIV style="POSITION: absolute">
<FORM id="Form1" method="post" runat="server">
<asp:datagrid id="dgEmployees" runat="server" Font-Size="X-Small"
BorderColor="Silver" AllowSorting="True"
HorizontalAlign="Center" BorderStyle="Solid" Height="136px"
Width="640px">
<SelectedItemStyle Font-Underline="True" Font-Bold="True"></
SelectedItemStyle>
<AlternatingItemStyle BackColor="#C0FFC0"></
AlternatingItemStyle>
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton id="Select" Text="Details"
CommandName="ShowDetails" runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid></FORM>
</DIV>
</div>
<div style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE:
medium; BORDER-LEFT-COLOR: white; LEFT: 869px; FLOAT: none; BORDER-
BOTTOM-COLOR: white; MARGIN-LEFT: 20px; OVERFLOW: auto; WIDTH: 277px;
CLIP: rect(auto auto auto auto); COLOR: black; BORDER-TOP-STYLE:
inset; BORDER-TOP-COLOR: white; TEXT-INDENT: 5%; FONT-FAMILY: 'Times
New Roman'; BORDER-RIGHT-STYLE: inset; BORDER-LEFT-STYLE: inset;
POSITION: absolute; TOP: 50px; HEIGHT: 598px; BACKGROUND-COLOR:
#c0ffc0; TEXT-ALIGN: left; BORDER-RIGHT-COLOR: white; BORDER-BOTTOM-
STYLE: inset"
align="left"><asp:datalist id="dlDetails" runat="server" Font-
Size="X-Small" BorderColor="Silver" Height="350px"
Width="309px" RepeatLayout="Flow">
<ItemTemplate>
Emp #: 
<%# Container.DataItem("Key") %>
 
First Name: 
<%# Container.DataItem("FirstName") %>
 
MI: 
<%# Container.DataItem("MI") %>
 
Last name: 
<%# Container.DataItem("LastName") %>
 
Nick Name: 
<%# Container.DataItem("NickName") %>
 
Use Nick Name Only: 
<%# Container.DataItem("UseNickNameOnly") %>
 
DOB: 
<%# Container.DataItem("DOBString") %>
 
Start Date String: 
<%# Container.DataItem("StartDateString") %>
 
Longevity Date: 
<%# Container.DataItem("LongevityDate") %>
 
Gender: 
<%# Container.DataItem("Gender") %>
 
Race: 
<%# Container.DataItem("Race") %>
 
Status: 
<%# Container.DataItem("Status") %>
 
Email Address: 
<%# Container.DataItem("EmailAddress") %>
 
Login Name: 
<%# Container.DataItem("LoginName") %>
 
Home Phone: 
<%# Container.DataItem("HomePhoneFormatted") %>
 
Payroll Employee ID: 
<%# Container.DataItem("PayrollEmployeeID") %>
 
Retiree: 
<%# Container.DataItem("Retiree") %>
 
Retirement Number: 
<%# Container.DataItem("RetirementNumber") %>
 
Service Date String: 
<%# Container.DataItem("ServiceDateString") %>
 
Suffix: 
<%# Container.DataItem("Sfx") %>
 
Advance Leave: 
<%# Container.DataItem("AdvanceLeave") %>
 
Benefits: 
<%# Container.DataItem("Benefits") %>
 
Cobra: 
<%# Container.DataItem("Cobra") %>
 
Evaluation Due: 
<%# Container.DataItem("EvaluationDueString") %>
 
Law Sep: 
<%# Container.DataItem("LawSep") %>
 
LOA: 
<%# Container.DataItem("LOA") %>
 
Added By: 
<%# Container.DataItem("AddedBy") %>
 
Added By Name: 
<%# Container.DataItem("AddedByName") %>
 
Added Date: 
<%# Container.DataItem("AddedDateString") %>
 
Ad Username: 
<%# Container.DataItem("AdUsername") %>
 
Updated By: 
<%# Container.DataItem("UpdatedBy") %>
 
Updated By Name: 
<%# Container.DataItem("UpdatedByName") %>
 
Updated Date String: 
<%# Container.DataItem("UpdatedDateString") %>
 
</ItemTemplate>
</asp:datalist></div>
</BODY>
</HTML>

Code-Behind:

Public Class MainDepartment
Inherits System.Web.UI.Page

Private m_department As String
Private m_title As String

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
'lblWelcome.Text = "Hello " & Global.UserSecurity.Fname.Trim &
" " & Global.UserSecurity.Lname
Dim act As Action
Dim pos As Position
Dim empname As String
Dim lvi As ListItem
Dim Employee As Employee
Dim empcount As Integer
act = (New
ActionBroker).GetActionCurrent(Global.UserSecurity.EmpId, Today,
Global.UserName, Global.UserPassword, Global.appDataSource)
pos = (New PositionBroker).GetPosition(act.PositionID,
Global.UserName, Global.UserPassword, Global.appDataSource)
m_department = pos.Department.Name
Dim emps As Employees = (New
EmployeeBroker).GetCurrentEmployeesByDepartment(m_department,
Global.UserName, Global.UserPassword, Global.appDataSource)
Dim dt As New DataTable
Dim count As Integer = 0
For Each emp As Employee In emps
SetListViewItem(emp, dt, count)
count = count + 1
Next
dgEmployees.DataSource = dt
dgEmployees.DataBind()
End Sub

Private Sub ShowDetails(ByVal sender As Object, ByVal e As
DataGridCommandEventArgs)
?????????
?????????
End Sub

Private Sub SetListViewItem(ByVal dr As Employee, ByVal dt As
DataTable, ByVal count As Integer)
If count = 0 Then
dt.Columns.Add("Emp #")
dt.Columns.Add("Last Name")
dt.Columns.Add("First Name")
dt.Columns.Add("Title")
End If
Dim EmpPos As Action = (New
ActionBroker).GetActionCurrent(dr.Key, Today, Global.UserName,
Global.UserPassword, Global.appDataSource)
Dim employee As DataRow = dt.NewRow
employee("Emp #") = dr.Key
employee("Last Name") = dr.LastName

employee("First Name") = dr.FirstName
employee("Title") = EmpPos.WorkAgainstInfo.Title
dt.Rows.Add(employee)
End Sub 'SetListViewItem

Private Function FindEmp(ByVal EmployeeID As Integer) As String
Dim emp As Employee
Dim retval As String
Try
If EmployeeID > 0 Then
emp = (New EmployeeBroker).GetEmployee(EmployeeID,
Global.UserName, Global.UserPassword, Global.appDataSource)
retval = String.Empty
If Not IsNothing(emp) Then
retval = emp.FirstName & " " & emp.MI & " " &
emp.LastName
Else
retval = "Vacant"
End If
Else
retval = ""
End If
Catch ex As Exception
Global.HandleException(ex)
retval = String.Empty
End Try
Return retval
End Function

End Class

Teemu Keiski · Jul 9, 2008

Hi,

the code in Page_Load should be wrapped inside If Not Page.IsPostBack check
so that it's not databound on every request. Second is that I cannot see
ShowDetails method being wired to handle anything anywhere, and as you have
specified this in the grid:

<asp:LinkButton id="Select" Text="Details"
CommandName="ShowDetails" runat="server" />

I assume you want to populate DataList when this Button is clicked. Either
wire the ShowDetails method to Command event of datagrid
(OnCommand="ShowDetails)" when it is called when Button is clicked (and you
can check the CommandName if it macthes the expected one) or write
declaratively a click event handler of the Button directly.

Datagrid/Datalist, same page, 2nd is details	1	Jul 3, 2008
Need help , Having problem with Drag n Drop...	1	Dec 21, 2022
How to position the tooltip comment on these buttons?	9	Nov 4, 2023
Help with my responsive home page	2	Dec 14, 2022
Help with code	0	Jun 12, 2022
Help with Visual Lightbox: Scripts	2	May 3, 2023
I need help making a zooming function	11	Dec 14, 2021
I need help fixing my website	2	Oct 15, 2023

Datagrid > DataList problem - Any clues?

Brock

Teemu Keiski

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads