[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Combo Box on VB form locks up application

Posted on 2013-01-28
7
Medium Priority
?
1,085 Views
Last Modified: 2013-01-29
Here's the issue summary:

Developing in Visual Studio 2012 Pro using a VB.net form
SQL Server 2005 Enterprise backend.

I have a combobox (ddlContractorName) that is databound to a Contractor table.  Its display member returns a string (Fullname), and the selected value returns a  datetime associated with the Fullname for the record.  This sits in a VB form inside a tab container.  Once I click on the combobox it locks up my form.  I can’t exit out, I can’t select any other controls via mouse or keyboard.  I have to stop the program debugger to close it.  This only happens if I populate the Selected Value portion of the combobox.  If I set selected value to none, the form works perfectly.  Only problem is that I need the value for calculations and logic.

I thought this might be caused from the datetime datatype not playing nicely, but it does the same thing when I use a string value for the selected value.

What the heck is causing this?

Here’s the relevant form source code:

*********************************************************************

Public Class frmHome

    Private Sub FrmHome_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        'TODO: This line of code loads data into the 'Contractor_TrackingDataSet1.SignInOut' table. You can move, or remove it, as needed.
        Me.SignInOutTableAdapter.Fill(Me.Contractor_TrackingDataSet.SignInOut)
        lblHalt.Visible = False
        lblSignInComplete.Visible = False
        lblSignOutComplete.Visible = False
        btnOKClear.Visible = False


        'TODO: This line of code loads data into the 'Contractor_TrackingDataSet.SignInOut' table. You can move, or remove it, as needed.
        Me.SignInOutTableAdapter.Fill(Me.Contractor_TrackingDataSet.SignInOut)
        'TODO: This line of code loads data into the 'Contractor_TrackingDataSet.Company' table. You can move, or remove it, as needed.
        Me.CompanyTableAdapter.Fill(Me.Contractor_TrackingDataSet.Company)
        'TODO: This line of code loads data into the 'Contractor_TrackingDataSet.Person' table. You can move, or remove it, as needed.
        Me.PersonTableAdapter.Fill(Me.Contractor_TrackingDataSet.Person)
        'TODO: This line of code loads data into the 'Contractor_TrackingDataSet.Person' table. You can move, or remove it, as needed.

    End Sub

    Private Sub ddlContractorName_SelectedIndexChanged(sender As Object, e As EventArgs)

    End Sub

End Class
*********************************************************************


Thanks!
0
Comment
Question by:jribble
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 38828414
Hi ....for what you say this is a databound combobox..with display memer and Value Memeber...
what is your your Value Member ? what is your code to get the SelectedValue?
0
 

Author Comment

by:jribble
ID: 38828624
I’m trying to do it through the GUI as opposed to coding it.  Please see attached screenshot.    The sql for the data source is just a “Select * From ContractorTracking.dbo.Person
VB-screenshot.docx
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 38828678
This is not the proper way....that is why the form freezes...you need as value the safety_training date after each selection ? if so try this
Dim ddlContractorDrv as DataRowView=Ctype(ddlContractorName.SelectedItem,DatarowView)
Dim SelDate as Date=ddlContractorDrv.Item("Safety_Training_Date")
..
..
..

Open in new window

put this code in the Selected index event and set the SelDate where ever you want
Delete the selected value in the databind Mode.Also set the value member the "person_id"
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 18

Accepted Solution

by:
John (Yiannis) Toutountzoglou earned 2000 total points
ID: 38828845
DataSource=>PersonBindingSOurce
DisplayMember=>Fullname
ValueMember=>Person_id
SelectedValue=> None
This the Code
 Private Sub ddlContractorName_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlContractorName.SelectedIndexChanged
        Try
            If ddlContractorName.SelectedIndex <> -1 Then

                Dim ddlContractorDrv As DataRowView = CType(Me.ddlContractorName.SelectedItem, DataRowView)
        Dim selDate As Date = CType(ddlContractorDrv.Item("Safety_Training_Date"),Date)
                Me.TextBox1.Text = selDate
            End If
        Catch ex As Exception

        End Try
    End Sub

Open in new window

Hope It Helps!!
0
 
LVL 28

Expert Comment

by:Ark
ID: 38829441
Safety_Training_Date should be NOT a "Selected Value" but "Value member" instead
Then, from code, you can access following combo properties:
combo.SelectedIndex - (almost) unbounded integer representing combo item index (though it's equal bindingsource.position)
combo.SelectedValue - equals Safety_Training_Date of selected item
combo.SelectedItem - DataRowView equals bindingsource.Current, you can access to table columns through it, like MsgBox(combo.SelectedItem("Column_Name_Here")) or MsgBox(combo.SelectedItem(Column_Index_Here))
'Note - If option strict set ON then cast SelectedItem first:
MsgBox(CType(combo.SelectedItem,DataRowView)("Column_Name_Here"))
0
 

Author Closing Comment

by:jribble
ID: 38831617
Worked great!  I really appreciate that you posted the actual code.
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 38831731
Glad to help you
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question