Selected index changed combobox

Question

0.00/5 (No votes)

See more:

Two situations:
1) I add a new record and Select ISBN from the combobox. SelectedIndexChanged should fire and populate the BookName from the DataBase. It works and fine.

2) After initial loading of all data in Form, when I navigate from Record 1 to Record 2 etc, SelectedIndexChanged fires and populates BookName from the DataBase. But, this is not desirable.

How to identify and distinguish New Record from the Fetched Record, based on which these actions be controlled?

What I have tried:

VB

Private Sub ISBNComboBox_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ISBNComboBox.SelectedIndexChanged
        Dim lISBN As String
        lISBN = ISBNComboBox.Text
        PopulateBookName() 'When ISBN is changed, Book Title should be updated
    End Sub

Posted 1-Nov-18 4:52am

Me.RKrishna

Updated 1-Nov-18 19:14pm

Leo Chapiro

v2

Add a Solution

Comments

Bryian Tan 1-Nov-18 12:07pm

You might need to wrap the code in the if not postback. Example

If Not Page.IsPostBack Then 
  PopulateBookName()
End

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Answer 1 · 2018-11-01T05:38:00

You need to show us how your PopulateBookName() method was doing. Essentially, you just need to update your SQL query to get the latest record by doing either:

SQL

SELECT TOP 1 * FROM [TABLENAME] ORDER BY id DESC

You can also use the Posted Date to get the latest record. That really depends on you.

Me.RKrishna · Answer 2 · 2018-11-01T19:15:00

Book Name is a dependent field. Based on ISBN number, book name is populated. That is all.

The issue is: When I add NEW Records, based on the ISBN, Book name is to be populated.
But, when I QUERY the existing records from the DataBase, the fetched ISBN should trigger the SelectedIndexChanged procedure and should not populate the Book Name. Otherwise, it marks the record as edited record, and prompts for saving.

Selected index changed combobox

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0