Comments by Andy Morris (Top 21 by date)

I'll give the above a try. I am getting another strange error though. I get Data Base Error when viewing the report.

I am new to Asp.net, how do I do that?

I changed it to zEdits, but still doesn't work. I built a DropDownList outside of the ListView and it worked fine. It seems the issue is with the:
Dim ddlWorkArea As DropDownList = ListView1.Items(i).FindControl("WorkAreaDDL"

it like it doesn't see it, here is the asp.net part


<asp:ListView ID="ListView1" runat="server" DataKeyNames="ID, WorkArea, SubWorkArea"
DataSourceID="AuditChecklistAnswerData" InsertItemPosition="LastItem" >
<edititemtemplate>
<tr style="background-color:#008A8C;color: #FFFFFF;">
<td style="width: 55px" rowspan="2">
<asp:Button ID="UpdateButton" runat="server" CommandName="Update"
Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Cancel" />
</td>
<td>
<asp:TextBox ID="WorkAreaTextBox" runat="server" Text='<%# Bind("WorkArea") %>'
width="100px" Enabled="True" BackColor="White" visible ="false" Font-Bold="true" />
<asp:DropDownList ID="WorkAreaDDL" runat="server" BackColor="#FFFFCC" AppendDataBoundItems="true"
DataSourceID="WorkAreaDDLSelect" width="200px" DataValueField="WorkArea" >



~~ rest of the listview ~~

I added the following in VB code and it now works:

Private Sub ddlLastName_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlLastName.DataBound
Me.ddlLastName.Items.Insert(0, New ListItem("All", "%"))
End Sub

Private Sub ddlFirstName_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlFirstName.DataBound
Me.ddlFirstName.Items.Insert(0, New ListItem("All", "%"))
End Sub

The problem with this is now I need to add the "ALL" to the list. If fixed the issues of the doubling of the data but I need to reset it so every thing will show when "All" is selected.

<asp:ListItem Text="All" Value="%">

I tried the Eval also but I get the following error:
Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30691: 'Nullable' is a type in 'System' and cannot be used as an expression.

Source Error:


Line 310: <asp:TextBox ID="DateQualifiedTextBox" runat="server"
Line 311: Text='<%# Bind("DateQualified") %>' />
Line 312: <asp:CalendarExtender ID="DateQualifiedTextBox_CalendarExtender" runat="server"
Line 313: Enabled="True" TargetControlID="DateQualifiedTextBox" SelectedDate='<%# IF(not IsDBNull(Eval("DateQualified")), Eval("DateQualified") %>' >
Line 314:

Source File: C:\Users\Andy\Desktop\PKL_QMWh\PKL_QMW\PersonnelMain.aspx Line: 312

I tried the Eval also but I get the following error:
Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30691: 'Nullable' is a type in 'System' and cannot be used as an expression.

Source Error:


Line 310: <asp:TextBox ID="DateQualifiedTextBox" runat="server"
Line 311: Text='<%# Bind("DateQualified") %>' />
Line 312: <asp:CalendarExtender ID="DateQualifiedTextBox_CalendarExtender" runat="server"
Line 313: Enabled="True" TargetControlID="DateQualifiedTextBox" SelectedDate='<%# IF(not IsDBNull(Eval("DateQualified")), Eval("DateQualified") %>' >
Line 314:

Source File: C:\Users\Andy\Desktop\PKL_QMWh\PKL_QMW\PersonnelMain.aspx Line: 312

Here is a copy of my current code:
<asp:DropDownList ID="DropDownList3" runat="server"
DataSourceID="SqlDataSource1" DataTextField="Reviewer1Title"
DataValueField="Reviewer1Title" Height="25px" style="margin-left: 0px"
Width="162px">

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:PKLConnectionString %>" SelectCommand="SELECT tblEvaluationListing.Reviewer1Title
FROM tblEvaluationListing
GROUP BY tblEvaluationListing.Reviewer1Title
HAVING ((Not (tblEvaluationListing.Reviewer1Title) Is Null));">

Thanks, this worked. Just in case someone else needs an example:
strSQL = "INSERT INTO tblEvaluationQuestions ([EvaluationID] " & _
" ,[PID] " & _
" ,[Checklist] " & _
" ,[Item] " & _
" ,[Objective]) " & _
"SELECT " & _
" '" & txtAssessmentID & "' as EvaluationID" & _
" ,'" & txtPID.Text & "' as PID" & _
" , Checklist " & _
" , Item " & _
" , Objective FROM tblEvaluation" & _
" WHERE checklist = '" & ddChecklist.Text & "' and ProgramGroup = '" & CType(Session.Item("SessionProgramGroup"), String) & "'"

I tried several different ways of doing this and still cannot get it to work.

Thanks for the info. It worked like a charm.

Is that on the page load event? or under Asp?

I'm new to the web development aspect and trying to figure it all out.

I see my error, I initialized the SQLcmd and ObjCommand both as New SQLCommand. I appreciate your help.

Thanks for the help. One other question I am also using the "objCommand" on the Insert SQl statement, should I change that as well to the "SQLCommand"?

I'm quite new to VB.Net (crossing over from MS Access). Can you provide me a good reference or sample?