I am trying to do this with many issues of data binding doubling the amount and not setting selectedValue on dropdownlist. I have read some posts and they help but I am missing a crucial piece. My problem is that my dropdownlist is doubling the amount of records for the dropdownlist. Instead of "YES;NO;SELECT A VALUE", I am getting "YES;NO;SELECT A VALUE;YES;NO;YES;NO". My database is correct with the UPDATE part but the rebind after update is failing horribly.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
If Session("ACTIVETAB").ToString() = Session("SUBCONTRACTSATABNO").ToString() Then
Public Function loadlookups(ByVal id As String, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) As DataTable
Select Case id
dt = GetLookupTable("SubcontractsA", "Sub 1 Cert Received")
Dim ddlCertReceived As DropDownList = _
ddlCertReceived.DataSource = dt
ddlCertReceived.DataTextField = "lup_text"
View Complete Post