473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Combo Box

manster
I have a combo box that I want to refresh the data of after the save button is clicked. I know that in web developer you can just say datasource.databind but I do not see that in vb.net. Please can someone help me out.
Apr 16 '10 #1
12 2104
tlhintoq
3,525 Expert 2GB
I'm pretty sure a combobox has a datasource property.

http://msdn.microsoft.com/en-us/library/x8160f6f.aspx
Apr 17 '10 #2
Yes, a combo box has a datasource but my question is to refresh that datasource after I saved something to the database. I saw that when I do: mycombobox.refresh() that it repeats the data in the combobox.
Apr 17 '10 #3
tlhintoq
3,525 Expert 2GB
This is getting a little out of my area but...
What if you set the datasource to null - forcing a clear - then set the datasource back to the database - forcing it to obtain the most current values?
Apr 17 '10 #4
Yes, I'm gonna try that tommorrow. Will post here to say if it works. Thanks anyway.
Apr 18 '10 #5
to clear the combobox type this following code

"comboboxname.items.clear();"

try this following for refresing the datas in the combobox,
"databind.refresh();"
Apr 19 '10 #6
Frinavale
9,735 Expert Mod 8TB
There is no DataBind method for the combobox.
You should just be able to set the datasource to nothing and it should refresh. You may need to call the Update or the Refresh method for the combobox to force it to redraw on the page (as empty).
Apr 27 '10 #7
OK, I promised to post here when I came right and I did not exactly come right but I saw how the first combo box was done. The person read through a dataset in a loop and did: combobox1.items.add("datacolumn"). I did want to change it to a datasource but still has to learn how they work but I think to set the datasource to nothing and give it again sounds good. in vb.net's comboboxes or any databound controls you cannot use databind. I am busy doing other combo boxes with datasources and will come tell of my successes. Thanks for your posts here and I hope I will be able to help any of you soon.
Apr 29 '10 #8
Frinavale
9,735 Expert Mod 8TB
If you used the Add method to add the items to the ComboBox then you have to use the Remove method to remove them. Setting the datasource to nothing will not work in this case.
Apr 29 '10 #9
Yes, you are right and now I am investigating both options to see which will be the best. The additem or the datasource. Thanks for the interest.
Apr 29 '10 #10
Try ComboBox1.Update()
I dont know If it works.
May 8 '10 #11
@Frinavale
ya you're correct, we cant do databind.refresh().
May 13 '10 #12
mfaisalwarraich
194 100+
Hi,

if you are adding items into the combobox using the database i recommend you the following code:
Expand|Select|Wrap|Line Numbers
  1. With comboBox1
  2.   .DataSource = Me.YourDataSetName.YourTableName
  3.   .DisplayMember = Me.YourDataSetName.YourTableName.Columns(1).ColumnName
  4.   .ValueMember = Me.YourDataSetName.YourTableName.Columns(0).ColumnName
  5.  
  6.  
  7. End With
  8.  
This will add items into your combobox. After that you can set the datasource to nothing and then select datasource again. Here is the code:
Expand|Select|Wrap|Line Numbers
  1.                 comboBox1.DataSource = null
  2.                 comboBox1.Items.Clear()
  3.                 comboBox1.DataSource = Me.YourDataSetName.YourTableName
  4.  
i think this may help you.
May 14 '10 #13

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: vgrssrtrs | last post by:
<html> <head> <script language="JavaScript"> <!-- /* *** Multiple dynamic combo boxes *** by Mirko Elviro, 9 Mar 2005 *** ***Please do not remove this comment
4
by: Heather | last post by:
Hi I am desparately looking for advice in relation to storing the results after selecting items from two combo boxes on a Referral form. The first combo box 'ctl Type' displays a full list of...
6
by: Support4John | last post by:
a2k (9.0.6926) SP-3 Jet 4.0 SP-7 I have a form with combo box field that allows the user to select from the combo box or type in the field value that may or maynot be in the combo box field. ...
2
by: Jeff Mason | last post by:
I'm observing some strange behavior when I use a bound combo box in conjunction with the combo's anchor property. I define a form which contains just a textbox and a combo box. The text box is...
3
by: hmiller | last post by:
Hey everyone, I am having a hell of a time trying to set this menu system up. Here's what I'm trying to do. Combo Box One; is populated by names under properties "row source" "Phase 1"...
9
by: Edwinah63 | last post by:
Hi everyone, Please let there be someone out there who can help. I have two BOUND combo boxes on a continuous form, the second being dependent on the first. I have no problem getting the...
2
by: kiranmn75 | last post by:
I want to dynamically populate a combo box through javascript. Data is coming from a array. Sometimes data list may contain items in excess of 2000. Explorer takes more than 5 seconds to...
6
by: Dave | last post by:
I want to put the information that the user selects in my combo boxes into a subform that lies on the same form as the combo boxes. Thanks for your help already, Dave
2
by: biganthony via AccessMonster.com | last post by:
Hi, I decided to install Office 2003 Service Pack 3 on my home computer to test (in full knowledge that there may be some issues with it). After installation, I have noticed that with a small...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.