image button

[Dave Kreskowiak]

Lisana wrote: I can't recall the function in the ImageButton1ClickHandler, what should I do? If you want to call the code in the handler, just move the code to another method outside the handler.

Public Sub ImageButton1ClickHandler(ByVal sender As Object, ByVal e As System.EventArgs)
Dim results As Int32 = CType(CType(sender, Button).Name, Int32)
BindDataSources(results)
End Sub

Public Sub BindDataSources(ByVal entityID As Int32)
' I'm assuming client_entityID is a "global" variable
objConn.Open()
Dim DA As New OleDbDataAdapter
DA.SelectCommand = New OleDbCommand
With DA.SelectCommand
.Connection = objConn
.CommandType = CommandType.Text
.CommandText = "UPDATE Contacts set primary_contact = 0 WHERE client_entity_id = " & client_entityID
.ExecuteNonQuery()
End With
 
Dim DA2 As New OleDbDataAdapter
DA2.SelectCommand = New OleDbCommand
With DA2.SelectCommand
.Connection = objConn
.CommandType = CommandType.Text
.CommandText = "UPDATE Contacts set primary_contact = 1 WHERE entity_id = " & entityID
.ExecuteNonQuery()
End With
 
objConn.Close()
End Sub

Now you can call BindDataSources from anywhere in your code, so long as you provide it an entityID. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[Lisana]

I think you misunderstood my meaning, I want to call the function contactView not the update query. Public Sub ImageButtonClickHandler(ByVal sender As Object, ByVal e As System.EventArgs) results = CType(CType(sender, Button).Name, Int32) contactView() 'give me error end sub it gave me error when I call the contactView() in the ImageButtonClickHandler The main thing I want to do in here is when the blankImageButton Click, then go the database to change the pimary_contact to 1, the other pimary_contact=1 to 0, at the same time, the button image changes as well, in the output, the imagebutton didn't change when I click, but the database is updated. I have to close the window, then reopen again, then it shows the change. Lisa

[Dave Kreskowiak]

Whopps! My mistake. What's the error? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[Lisana]

The main thing I want to do in here is when the blankImageButton Click, then go the database to change the pimary_contact to 1, the other pimary_contact=1 to 0, at the same time, the button image changes as well, in the output, the imagebutton didn't change when I click, but the database is updated. I have to close the window, then reopen again, then it shows the change. Lisa

[Lisana]

expression is not a method. Lisa

[Dave Kreskowiak]

You've got a major design flaw in there. Every time you call contactView, you're created new buttons. But, you're never removing the old ones that you created. What are you trying to do with the buttons? Implement paging? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[Lisana]

How can I remove the old buttons when before contactView() called? those buttons are checked and unchecked buttons, if you have 5 contacts, there is only one pimary contact that would be the checked buttons, if you want to change your pimary contact, then click one unchecked button, the one you just clicked will become the pimary contact(changed to checked button), the old pimary contact changed to unchecked button. like this: -Unchecked X checked 5 lists, when the second record click, then old new - - - X - - X - - - Lisa

[rwestgraham]

TextBox, Button, CheckBox and most (not all but most) NET controls can display images from an ImageList. You will find that your code is simpler, easier to deploy, and easier to manage in general if you just abandon the whole approach of loading images from a file. Put them in an ImageList control instead. Robert

[rwestgraham]

If there is some compelling reason whay you absolutely have to add the buttons at run-time - like the numebr of buttons changes depending on the number of contacts, then load them all one time when the form is initialized. After you create each button, also add it to a local collection. Then when a person clicks on a button, enumerate the local collection, set each button's state to unchecked, then continue to process the click event to perform the query and reset the newly checked contact. This will be much faster than trying to constantly add and remove buttons and their event handlers from the form. You also do not need to keep track of the current state of any given button, because you simply reset them all to unchecked whenever one is clicked. Unless you have a lot of buttons, simply enumerating the list will be about as fast, and much simpler than writing code to keep track of the the button state. Robert

[Lisana]

it's very complicate in this data binding..I have a very hard time to get around all of those. this is my form look like: PC|View|Name|Phone|email PC column: imagebutton View: button --when the user click button, then open a form to view the detail, and the user and change the data, when the form closed, in this form's data has to be updated as well, this is a hard part I haven't found a way to fix the problem..in my app now, I can't get to refresh and load the update data, I have to close this form and open again to get the newest data. Name: textbox phone: combobox, binding all the phone number in db to combobox email: button - when the user click the button, then auto start a outlook to send email. I can't use datagrid because I can't find a way to add those controls to datagrid. so I only can use the dataReader to menually creat those needed in my app. that is very annoying to do that. but I can't find any other way to do it. IF you know a better way to do it, please tell me. I will very appricate it. Lisa

[Dave Kreskowiak]

Wow! Talk about doing it the hard way! :-D The DataGrid is the tool choice for this project, but admittedly, it's not an easy tool to learn to use. Ummmm... Try seeing what you can glean from this[^] little article by Omri. There's even a link in it to show you how to get a ComboBox column into a DataGrid. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[Lisana]

Thanks;) how about a button inside datagrid, and when it click, open another window? This is I always want to do it, but I just can't get around it, it includes some drawing and you need to creat a button by your own...do you have any experience for the button inside datagrid. I know the combobox inside datagrid is much easier to do it than button. I have buttons and combobox at the same time. Lisa