combobox in a jbgrid cell

Trainee

Date of registration: Aug 14th 2012

Monday, October 29th 2012, 1:24pm

Have a nice week all of us!

i would like to have a combobox in my JBGrid cell with row = 0 and col = 2 .... (0,2)

that fills like that

Set Data = Order.executeQuery("SELECT * FROM katigories WHERE katigories <> '***** ΚΑΜΙΑ *****' GROUP BY katigories ORDER BY katigories")
Do While Data.next()
katigories = Data.getString("katigories")
ComboBox_katigoria.AddItem New ListCellData(katigories, all_katigories, False)
Loop

How can i do something like this?

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

2

Monday, October 29th 2012, 7:09pm

finally i found the solution but it appears when i dblclick on every cell.
BUT I WANT TO HAVE THIS COMBOLIST ONLY IN (ROW,2)...
so to have it when i double click only the "column = 2" not to ALL CELLS

Does anybody know how can i do for example if col = 2 then.......COMBOLIST?

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

3

Monday, October 29th 2012, 9:04pm

Hey there,

try this:

Jabaco Source

JBGrid1.Editable = jbEditOnClick
'   Dim ComboBox1 As javax#swing#JComboBox = New javax#swing#JComboBox
ComboBox1.AddItem("Yes")
ComboBox1.AddItem("No")   
'AFTER!!!!!!  DataMatrix or TextMatrix of JBGrid1 is addressed set your new CellEditor
JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New DEFAULTCellEditor(ComboBox1))

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

4

Tuesday, October 30th 2012, 4:02pm

hi dani!
I tried to do your solution but i have "compile_error" and mark this...
JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New DEFAULTCellEditor(ComboBox1))
Have you got any idea what i am doing wrong?

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

5

Tuesday, October 30th 2012, 4:30pm

Hey there,

I am not sure what to tell you

It works fine for me...

Jabaco Source

'draw a JBGrid1
'draw a ComboBox1

Public Sub Form_Load()
   JBGrid1.Editable = jbEditOnClick
'   JBGrid1.SelectionMode = flexSelectionByRow
'      Dim ComboBox1 As javax#swing#JComboBox = New javax#swing#JComboBox
   ComboBox1.AddItem("Yes")
   ComboBox1.AddItem("No")
   JBGrid1.TextMatrix(0,2) = ""
   'AFTER!!!!!!  DataMatrix or TextMatrix of JBGrid1 is addressed set your new CellEditor
   JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New DEFAULTCellEditor(ComboBox1))
End Sub

Try to do the above and save it as a little project.Unload Jabaco and load it again. Sometimes that works!

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

6

Tuesday, October 30th 2012, 4:37pm

could you please send me the example in zip because i did what exactly you told me but i am still having "COMPILE_ERROR"

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

7

Tuesday, October 30th 2012, 5:03pm

as i see this code occurs the problem on me...
JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New DEFAULTCellEditor(ComboBox1))

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

8

Tuesday, October 30th 2012, 5:53pm

Hey there,

hm, we are back to the framework question!
But I believe you are using the latest one by now right?

You might try not to draw the ComboBox and uncomment the 'Dim...' line.

GridCbo.zip

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

9

Tuesday, October 30th 2012, 6:14pm

Hey there,

Ok, my guess is that this should do it:

Jabaco Source

'draw a JBGrid1

Public Sub Form_Load()
   JBGrid1.Editable = jbEditOnClick
'   JBGrid1.SelectionMode = flexSelectionByRow
   Dim ComboBox1 As javax#swing#JComboBox = New javax#swing#JComboBox
   ComboBox1.AddItem("Yes")
   ComboBox1.AddItem("No")
   JBGrid1.TextMatrix(0,2) = ""
   'AFTER!!!!!!  DataMatrix or TextMatrix of JBGrid1 is addressed set your new CellEditor
   JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox1))
End Sub

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

10

Wednesday, October 31st 2012, 12:01pm

Yes it solved my problem...

JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox1))

thank you very much!

1.----------------------------------------------------------
is there a way to open the combobox without auto selected the first item?

for example if i have...

Public Sub Form_Load()
JBGrid1.Editable = jbEditOnClick
' JBGrid1.SelectionMode = flexSelectionByRow
Dim ComboBox1 As javax#swing#JComboBox = New javax#swing#JComboBox

ComboBox1.AddItem("ΕΣΟΔΑ")
ComboBox1.AddItem("ΕΞΟΔΑ")
JBGrid1.TextMatrix(0,2) = "test"
'AFTER!!!!!! DataMatrix or TextMatrix of JBGrid1 is addressed set your new CellEditor
JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox1))
End Sub

i just want to open the combo without auto selecting ΕΣΟΔΑ as first value and loosing my "test" value

2.----------------------------------------------------------
can i have a function like this...

public sub Combobox1_change()
msgbox combobox1.text
end sub

thanks again!

This post has been edited 1 times, last edit by "fomaxrge" (Oct 31st 2012, 12:11pm)

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

11

Wednesday, October 31st 2012, 2:17pm

Hey there,

I don't know how to display any text on the ComboBox.
ComboBox1.Text = "test" does not seem to work!!

I'll have a look at the framework.

This will preserve the grid content when ComboBox1_Click is fired and
this will also keep ComboBox1.List from having any item preselected:

Jabaco Source

'draw a JBGrid1
'draw a ComboBox1

Public Sub Form_Load()
   JBGrid1.Editable = jbEditOnClick
   JBGrid1.TextMatrix(0,2) = "test"
   'AFTER!!!!!!  DataMatrix or TextMatrix of JBGrid1 is addressed set your new CellEditor
   JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox1))
   ComboBox1.AddItem("Yes")
   ComboBox1.AddItem("No")
End Sub

Public Sub ComboBox1_Click()
   ComboBox1.Parent.setSelectedIndex(-1)
End Sub

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

12

Wednesday, October 31st 2012, 3:02pm

hi dani i tried to add this....
Public Sub ComboBox1_Click()
ComboBox1.Parent.setSelectedIndex(-1)
End Sub

and even thought it keeps the first selected value when i click on the cell i see it empty
how can i see when i click on it...

test
Yes
No

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

13

Wednesday, October 31st 2012, 3:16pm

Hey there,

ComboBox1.Text sets the ComboBox1.ListIndex if the String matches the ListItem.
Since ComboBox1.ListIndex can not be set to 0 or -1 (see Bugreport) we are using ComboBox1.Parent.setSelectedIndex(-1) wich displays an empty ComboBox1.
There is no property of ComboBox that allows us to display text other than ListItems.
I think in VB6 that was possible!

So when you pass the JBGrid CellContent to the ComboBox it would oben with that String and set its ListIndex accordingly.
I don't see how it would make sense to display text on the JBGrid Cell that is not in ComboBox1.List.
Usually ComboBox1.List should be populated with all valid data for that field.

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

14

Wednesday, October 31st 2012, 3:23pm

Dani can you please help me how to do something like this...

Public Sub Form_Load()
ComboBox1.AddItem("first entry")
ComboBox1.AddItem("second entry")
ComboBox1.AddItem("third entry")

End Sub

Public Sub ComboBox1_Change()
MsgBox("your selection is " + ComboBox1.Parent.getItemAt(ComboBox1.ListIndex))
End Sub

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

15

Wednesday, October 31st 2012, 3:59pm

Hey there,

I think you are thinking too complicated here:

	Jabaco Source
1 2 3	Public Sub ComboBox1_Change() MsgBox("your selection is " + ComboBox1) End Sub

The thing is:
when ever you .add to the ComboBox ComboBox1_Change() is invoked!!
I don't know if that is a BUG or intentionally designed like this...
But you have to find some way to work arround that:

	Jabaco Source
1 2	'If you know how many Items are to be loaded If Combobox1.ListCount < 3 then Exit Sub

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

16

Wednesday, October 31st 2012, 4:02pm

	Jabaco Source
1 2 3 4	Public Sub ComboBox1_Change() If Combobox1.ListCount < 3 then Exit Sub MsgBox("your selection is " + ComboBox1) End Sub

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

17

Thursday, November 1st 2012, 3:47pm

Have a good month Dani!
i tried to find a way to print selected value of combobox2 whenever it change but i did not succeed.
i am trying to do something like this...

public sun combobox2_change()
JBGrid1.Editable = jbEditOnClick
JBGrid1.Parent.getColumnModel().getColumn(4).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox3))
Set Data = Order.executeQuery("SELECT * FROM katigories WHERE katigories = combobox2 GROUP BY ipokatigories ORDER BY ipokatigories")
Do While Data.next()
MsgBox JBGrid1.Parent.getColumnModel().getColumn(4).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox3))
ComboBox3.Visible = True
ipokatigories = Data.getString("ipokatigories")
ComboBox3.AddItem(ipokatigories)
Loop
end sub

So the combobox3 data depends on the selected item of combobox2.

Have you got any idea?

Go to the top of the page

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

18

Friday, November 2nd 2012, 3:02pm

Hey there,

Please try to post your code in the Jabaco Code Box for better readability.
Use the <JBC> button in the editor to do so!!

I don't know the rest of your code. But remember I told you...

Quoted

'AFTER!!!!!! DataMatrix or TextMatrix of JBGrid1 is addressed set your new CellEditor

If you don't fill your Grid with data your CellEditor will not work!

What are you trying to do here? Do you really want the MsgBox to pop up every loop?

Quoted

Do While Data.next()
MsgBox JBGrid1.Parent.getColumnModel().getColumn(4).setCellEditor(New javax#swing#DefaultCellEditor(ComboBox3))
...

Are you looking for this

	Jabaco Source
1	MsgBox(JBGrid1.TextMatrix(JBGrid1.Row, 4))

Dani

latest Jabaco.jar:
Jabaco.jar on bitbucket since other links are down !!
Jabaco Framework source:
https://code.google.com/p/jabacoframework/source/list

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

19

Monday, November 5th 2012, 11:02am

Thank you Dani for your precious help i think that i did what i was looking for.
I am testing it now.

Thanks again.

Go to the top of the page

fomaxrge

Trainee

Posts: 88

Date of registration: Aug 14th 2012

20

Wednesday, November 14th 2012, 4:41pm

Hi again i wonder is it possible to handle my combobox with double click instead of click.
I tried but it doesn't work on me.

Also it would perfect if someone knows how can i hide my combobox (before i put it in my JBGrid i do not want to show in on my form) is it possible?

Thank you!

Go to the top of the page