Screenshot Preview

Janus GridEX - Support

by Janus Systems - Product Type: Component / ActiveX OCX

Support Forum

Janus GridEX kiran [Selangor, Malaysia] 29-Oct-2014 09:57:56

Hi,

I am trying to add a record into a row after i add the first record when I am trying to add a next record the previous record automatically cleared.

Where i am doing wrong.

please advise.

Thank you.
Kiran.
Reply


how to select new record in gridex janus for add i fateme.soleimani67 [Iraq] 07-Oct-2014 22:32:50

hi every one
i want when i click icon save in navigator that i new record that updat as case select record and add database but not all record select and show one of record is null beacasue not column select. please help me one of column add with value 0 beacasue not column select. and for add record whiout 0 value i was in run one click after edit a record but i dont click i want in code a click after edit that record to be select how this write .
my code:
try
{

((DataRowView)fatemeBindingSource.Current).Row["code"] = codemax;
int g, b;
g = Convert.ToInt32(gridEX1.CurrentRow.Cells["code_b"].Value);
b = Convert.ToInt32(gridEX1.CurrentRow.Cells["name"].Value);
((DataRowView)fatemeBindingSource.Current).Row["code_b"] = g;
((DataRowView)fatemeBindingSource.Current).Row["name"] = b;
fatemeBindingSource.EndEdit();
fatemeTableAdapter.Update(this.baziDataSet.fateme);

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
:confused:

best regards
Reply


Janus GridEX fateme.soleimani67 [Iraq] 05-Oct-2014 09:53:05

hi every one
i have a bindingnavigator in form and a gridex in form and i set addnew item with value null and i will in bindingnavigatorn in method click a record add to grid but when table is null
not add a record to grid and other record to add a grid but i have one click in colum code .please help mee
my source code:
fatemeBindingSource.AddNew();
int code = Convert.ToInt32(this.fatemeTableAdapter.maxcode());
((DataRowView)fatemeBindingSource.Current).Row["code"] = code + 1;
i dont english as well.please help me
best a regards.
Reply

RE: Janus GridEX fateme.soleimani67 [Iraq] 05-Oct-2014 10:09:59

that value methoad max code=
SELECT ISNULL(MAX(code),0) AS ID
FROM fateme
that in dataset table
can not show record added in grid and how record added in grid i have in selected record
pleeeeeeeeeeese help meeeeeeeeeeee
Reply


Janus GridEX lee.b [FL, USA] 11-Sep-2014 17:01:01

How do I change background color of GridEx scroll bar?
I'm using .SelectionStyle = jgexEntireRow and would like to change color of scrollbar from Blue to Black.
Can't seem to find a property for that.
Reply


Janus GridEX anilkumar1593 [India] 16-Jul-2014 13:05:42

I have two Janus grids with empty rows.

I have added 1 new row in grid 1
Pasted the newly added row into grid 2
After that if I check below properties on grid 2
- gridEX.DataSource getting total rows count as 1
- gridEX.GetDataRows() getting total rows as 1

Than after added new row into grid 2. In this case ideally gridEX.DataSource and gridEX.GetDataRows() should return2 rows, but gridEX.GetDataRows() returning 1 and gridEX.DataSource returning 2 rows.

After adding second row into grid 2 I am trying to select the newly added row by using below code
gridEX.SelectedItems.Add(1);

Here I am getting exception as

Value cannot be null.
Janus.Windows.GridEX.v3
at Janus.Windows.GridEX.GridEX.s(Int32 )
at Janus.Windows.GridEX.GridEXSelectedItemCollection.Add(Int32 position)


It might be because of gridEX not having the newly added row in it Roottable

I am getting this exception only if I paste the row on empty grid and trying to add new record.

What could be the problem and how I can fix this issue.
Reply


Janus GridEX pmbadusha [India] 07-Apr-2014 04:15:43

Hi Team,

Janus Grid will support for UniCode (Multi Langualge)..
If support kindly give some examples for how to use in VB6.0.
Our janus gridex version is 2000b
Reply


Janus GridEX seshukumar.rsr [India] 04-Mar-2014 10:48:24

Hi Support Forum,
I have a client who is using Janus Grid ex 2000a on Windows 2000 server. Now my client wants to move the entire application to Windows 2008 R2 32 Bit environment.
Now we are facing the problem, to deploy the Janus GridEx 2000a or b on to the new windows 2008 server, it is giving dispatcher error and even the Setup not working properly.

My Question is Will JanusGrdEx200a Or Janus GridEx200b is compatible with Windows 2008 R2 32 Bit or Not.
Please provide me the solution if it is compatible on the above said servers.


Thanks & Regards,
Seshu Kumar
Reply


Janus GridEX kmahaney [KY, USA] 01-Mar-2014 12:39:40

I have a normal bound grid with a event for Loading Row. I have setup a normal table adapter that will retrieve 1 records for the table. Why does it go into the Loading Row 2 times.

Also if I wanted to retrieve 10 records from the table then Why does it go into the Loading Row 11 times?? I would like to know if this is a setting in Janus Winforms to not go into the Loading Row an extra time for retrieval of the table.
Reply


Janus GridEX irina170489 [Russia] 26-Jan-2014 16:33:30

I have Janus Gridex2000. Can I make filters like in excel (from droplist)? Can I make any kinds of filters?
Reply


Janus GridEX irina170489 [Russia] 26-Jan-2014 16:33:20

I have Janus Gridex2000. Can I make filters like in excel (from droplist)? Can I make any kinds of filters?
Reply


Janus GridEX ahonen 17-Jan-2014 10:37:41

Hi,
my english is poor, sorry
I am using Janus grid v3.5.
In one column(datamember is complex object) i want to set custom edit with editcontrol which is user control with few text boxes and combo boxes , and when try to edit cell , can't see whole edit control, just small piece(cell size) not all control.
What I can do?

Thanks
Reply


access to row index hamed javanmard 03-Dec-2013 08:26:58

hi
sorry!
I Can't speek english well.
I need the selected rows in a grid show the to list box
Reply


Janus GridEX rkram437 [NJ, USA] 21-Oct-2013 20:40:24

Hi -
I am using Janus Gridex 2000 for a VB6 application. I am able to select multiple rows of a grid but when i click on delete button to delete multiple rows, only one record is getting deleted. Could you please help me how to get the row index for each of the selected rows and delete.

Thanks
Rk
Reply


Janus GridEX Cell Formatting PJ 16-Oct-2013 22:03:50

Is there a way to either make a single row read-only or disabled or make 1 cell in a row read-only for the Janus GridEx for ASP.NET?
Reply


Janus GridEX tiwari.kushagra [UAE] 30-Sep-2013 10:56:00

Hello,
I am using Janus grid control and I have a column in my data grid which contains date in long date format. That is eg: "14:00 14/03/2013". This had been done for project requirement. Now I have to apply filter to this column and in the drop down for this column the text come as "00:00 12/02/2013", "00:00 14/03/2013" etc. Where as I want date to come as a short date. Is there any way where I can remove the time information from the text displayed in the filter combobox and just display the date, where as in the back ground I do comparison using the original value. Also let me know if there is a way to bind date picker with the filter combobox

Regards,
Kushagra
Reply

RE: Janus GridEX morourke [County Dublin, Ireland] 30-Sep-2013 11:35:05

In the Gridex designer for the column set the formatString property to d
Morke
Reply

RE: RE: Janus GridEX morourke [County Dublin, Ireland] 30-Sep-2013 11:42:46

Hi
Sorry, in the old 2000b version I think you should go into the designer, select the colum, select the dormat tab and select 'short date'
Morke
Reply

RE: RE: RE: Janus GridEX tiwari.kushagra [UAE] 01-Oct-2013 09:49:01

Hi Morke,

Is there an event where I can subscribe to opening of the dropdown in the FilterRow? I want to get all items in the dropdown and modify them a little before showing it to user.

Kushagra
Reply

Janus GridEX morourke [County Dublin, Ireland] 01-Oct-2013 10:22:06

Hi,
I am not sure exactly what you are trying to do. However most of the methods are available within code. For instance... (from the xxx.janusys.com/controls/ site )
Private Sub Form_Load()
Dim col As JSColumn
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT [Date Ordered] FROM TblJobs"
Adodc1.Refresh
With GridEX1
.AutomaticSort = True
.RecordNavigator = True
Set .ADORecordset = Adodc1.Recordset
With .Columns("Date Ordered")
.Width = 4000
.Format = "dd-mmm-yy HH:mm"
.SortType = jgexSortTypeDateTime
End With
Set col = .Columns.Add("Date Month", jgexText, Key:="DateMonth")
col.FetchData = True
col.Visible = False
.Groups.Add col.Index, jgexSortAscending
.RefreshGroups allcollapsed:=True
End With

End Sub
Yours
Morke
Reply


Janus GridEX - Sorting lost after grouping ponraj.muthusamy [MO, USA] 06-Sep-2013 06:45:08

While loading the values to the grid, I have sorted based on Filesize desc. When I try to group with some other column like file extension..once I dragged the column to group, grouping done perfectly. But the filesize sorting was lost.

I want to maintain the sorting based on filesize after grouping.

Kindly let me know if there any way to achieve this.

Thanks,
Ponraj.M
Reply

RE: Janus GridEX - Sorting lost after grou... kiran [Selangor, Malaysia] 06-Sep-2013 06:49:32

Hi,

Hold the fields, sort settings then rebind the grid layout.
Grid.HoldFields
Grid.HoldSortSettings = True
Grid.Rebind
Reply


Janus GridEX r.graber [TX, USA] 22-Aug-2013 22:07:37

I currently having an issue grouping a column in the Janus grid because of case sensitivity with the data in the grid. For example, I am grouping a column has value of 'CAT01' in one row and the other 'cat01' in another row. When I group this column, I am getting an unhanded exception from Janus:

************** Exception Text **************
System.ArgumentException: Item has already been added. Key in dictionary: 'CAT01' Key being added: 'CAT01'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Janus.Data.JanusRowCollection.a(JanusRow )
at Janus.Data.JanusRowCollection.f(DataHolderRow )
at Janus.Data.JanusRowCollection.a(DataHolderRow )
at Janus.Data.JanusRowCollection.f(DataHolderRow )
at Janus.Data.JanusRowCollection.a(DataHolderRow )
at Janus.Data.JanusTableRow.RetrieveChildRows()
at Janus.Data.JanusRow.LoadChildRows()
at Janus.Data.JanusRow.RefreshChildRows()

Is there a hot fix out for this issue in Janus Version 4?
Reply

RE: Janus GridEX morourke [County Dublin, Ireland] 23-Aug-2013 10:00:35

Hi,
You do not provide very much detail, however can you not either:
1) ensure that all your data is either CAT01 or cat01 ( have your application convert the data to upper or lower case as part of the validation) and then set the 'data member' and 'key' in the grid to match, or
2) case the data to upper or lower case as it is being read in from the database

Yours
Morke
Reply

RE: RE: Janus GridEX r.graber [TX, USA] 23-Aug-2013 14:07:39

Thanks for your reply.

I am using using this grid a a report viewer, so I can't change the data to upper/lower. I need to have the user see the exact string from the database.
Reply

RE: RE: RE: Janus GridEX morourke [County Dublin, Ireland] 23-Aug-2013 16:08:46

Is there an actual difference between what CAT01 and cat01 represents?
Reply

RE: RE: RE: RE: Janus GridEX r.graber [TX, USA] 23-Aug-2013 16:36:31

For this reporting purpose, yes.
Reply

Grid. morourke [County Dublin, Ireland] 24-Aug-2013 08:10:16

I'm stumped. Perhaps if you try the Janus Gridex forum?
Morke
Reply


Janus GridEX Add child table in runtime Nuno 03-Jul-2013 12:23:58

Hi,
I need to add a child table in runtime and i need help.
Can you tell me what i have to do?
I can't add the child table in design mode.

Tanks
Reply

RE: Janus GridEX Add child table in runtime mohamed mahrose [Egypt] 27-Aug-2013 11:52:08

hi,

do you find the solution of this problem?

thanks in advance,
Reply


Janus GridEX sree [India] 28-May-2013 12:13:42

I am using janus grid version 1.1.1009.0 and .net framework 1.1. Dataset is binded to the grid. there are 4 date field column(type-system.datetime, format string :dd-mmm-yyyy,Edittype - calendar drop down) in the grid which displays date in the format dd-MMM-yyyy. MMM alpha month is displaying the month as per the browser language(polish, arabic, english, french months) choosed when the page loads. After saving anything in the grid then it always shows the date in the format dd-MMM-yyyy with MMM as english months. The problem is it has to be consistent. It should be english months through out even when the page loads first time and when ever save or refresh is done. , how to restrict the grid from displaying the months in different languages ?
Reply


Janus GridEX huy.hoang2225 [Viet Nam] 15-Apr-2013 08:18:28

Hi All, I have problem about Janus GridEX, but i do not know how to solve it.
I have Janus GridEX. When right click on cell, it show ContextMenuStrip. I want to change language text on ContextMenuStrip. but I do not know how do i do?
Reply


Janus GridEX zully [Ireland] 12-Apr-2013 15:42:27

I am working with a Janus-GridEx component. I need to permit to the user to edit a cell no-bound. But, at the moment, when the user writes the information in the cell, when the user leaves the cells, the information entered disappears.
Please, How can I keep the information written for the user?

Thank you!
Reply


Janus GridEX- move up - move down nadia.malohian [QC, Canada] 01-Apr-2013 03:15:55

Hi

I want to create a move up and move down button in a Janus Gridex, I will be grateful if anyone can help me with a sample of code.


Urgent- Urgent - Urgent - Urgent -Urgent -Urgent
Reply

RE: Janus GridEX- move up - move down morourke [County Dublin, Ireland] 01-Apr-2013 11:36:20

Hi,
You do not give much info as to whether the grid is bound or not, or the rule by which the gridrows should be exchanged, However, I had a similar problem a few years ago. I'm sorry I no longer have the code which was written in VB6. However, my answer was to create an array to match the columns. I then copied the data from Gridrow A into that array, then the data from Gridrow B into Gridrow A. Finally, copied the data from the array into Gridrow B.

Alternatively, can you use your code to sort the data on a particular value and then use the grid sort option under say the click event of a button to resort the grid.

ColPosition = 1 'GridDupes.Col
Set Col = GridDupes.Columns.ItemByPosition(ColPosition)
GridDupes.SortKeys.Clear
GridDupes.SortKeys.Add Col.Index, jgexSortAscending
ColIndex = Col.Index

morke
Reply

RE: RE: Janus GridEX- move up - move ... nadia.malohian [QC, Canada] 03-Apr-2013 20:28:16

thanks :)
Reply


Janus GridEX amish.jariwala [India] 05-Jan-2013 08:02:56

Does Janus GridEx support Alaska xbass++ language?
Please reply.
Reply


Janus GridEX r.graber [TX, USA] 04-Dec-2012 15:01:29

When I run my application and go to the section that I implemented Janus GridEX I get 2 popups saying I am using a Trail Version. One is an unauthorized copy of Janus GridEX control and the other is of Janus UIPanelManager. I have implemented Janus elsewhere and do not receive these. The Janus references I added to this project are from the same source as the references added in the other one. I have confirmed I have the full version of Janus on my machine and have tried building the solution in multiple places. Are there any further ways to troubleshoot this?
Reply


Janus GridEX and winodws 7 freezes mfiggins [Australia] 26-Nov-2012 08:53:00

We have an old VB6 application using the Janus GridEx 2000 controls.

We have recently been testing our application on Windows 7 64 bit environment and found the application freezing when resizing grids.

It seems when the grid allows row resizing this causes the issue. So we have had to disable the row sizing on grids, which is not really best solution.
are you aware of any issues with windows 7 and grids causing VB6application freezes?
Reply


GridEX crashes when choosing a condition operator hamz1182 [Mauritius] 13-Sep-2012 13:06:01

I have a GridEX on a Windows form which is bound to a typed datatable. The datatable is auto refreshed every minute with a timer. The grid crashes when i proceed as follows :
1) Launch the windows form containing the grid.
2) When the grid is filled with data, i apply a filter on one of the columns. I.e. I write something in the filter area of a column. The rows are filtered correctly.
3) Then I click on the Filter condition button (the one which opens a little form with options like Begin with, Ends with, etc...).
4) I leave that little form open till the auto-refresh kicks in.
5) As soon as the refresh is complete, I click on one of the options on the little form (Ex. Ends with). This action causes the grid to crash.

I only get a message like "Object reference not set...". This message originates from inside the GridEx, not my code. So i can't debug it.

If i don't clear the rows in my datatable before the refresh, the problem does not occur.

Any solutions?

Is there a way to close that little form (conditions operator form with options like Begin with, Ends with, etc...) using VB.NET code ??

If i'm able to close that form, then no one would be able to click on it's options during the auto refresh and grid won't crash.
Reply


Janus GridEX Piyush.Mishra 03-Sep-2012 15:31:18

I have set the SelectionMode property of Janus Grid to MultipleSelection.
I want to select two set of rows with 5 record each.

I have selected the first 5 rows using shift+ arrow key.But now if i have to select the next 5 rows , i have to use control key and either use mouse click on space bar one by one on ech row.I can't select the new 5 rows in one go.

Is there any way we can select the next 5 row in one go rather than clicking it one by one.
Reply

RE: Janus GridEX morourke [County Dublin, Ireland] 04-Sep-2012 09:55:55

Hi,
Post this up on the Janus forum site and I'm sure you will get a quick response.
Mick
Reply


Janus GridEX pauljmcewan [FL, USA] 06-Aug-2012 20:47:51

I was developing with the trial version of the Janus ASP.NET GridEx, but now I purchased it. However, it's still telling me that I don't have a licensed copy when I develop and deploy. How do I fix this? I installed the purchased copy over the existing trial version. It didn't say anything about uninstalling the trial, so I'm not sure if it upgraded it or what happened
Reply


Janus GridEX stevens [BC, Canada] 15-Jun-2012 23:28:45

When I set the AllowEdit in the Janus GridEx, a editable row at the top appears. How can I color the background of the current cell being inputted to Green?

I looked at Janus.Windows.GridEX.FocusCellDisplayMode but could not figure it out.
Reply


Janus GridEX raampalraana [Maharashtra, India] 19-May-2012 11:08:33

hi
i m using janus GridEX but i am facing below problem this need every body
1 WrapCell/Wrap Row
2 auto drop down list
3 bgcolor & fgcolor of selected cell is not availble in card
3 caption color is not available to change
Reply


Janus GridEX thomas.george 19-Apr-2012 12:36:47

When i am installing, i am getting an error code of 2869
Reply


Janus GridEX / Win 7 ODBC issue md [FL, USA] 13-Mar-2012 14:36:10

I have a recurring issue with GridEx throwing an ODBC login error on Windows 7. Any ideas from anyone? And "Run as Administrator" has no effect on this error..
Reply


Janus GridEX2000 Group By Box Esteban Escobar[Argentina] 24-Jan-2012 15:54:19

Hi, my name is Esteban i'm from Argentina.
I'm Testing the trial version of Janus GridX 2000 in Microsoft Visual Foxpro 9 and I need to know if is possible using the "Group By Box", group the rows for more than only four groups?

Thanks and regards
Reply


Janus GridEX - Default Group Column kiran [Selangor, Malaysia] 12-Jan-2012 08:59:58

Hi,

How to set the default group column and icon in the first column ?

I go through your janus advanced sample program but unable to find.

Best Regards,
Kiran.
Reply


Janus GridEX chandra [Australia] 15-Dec-2011 02:39:25

I am using Grdiex Designer.
I need to show 2 lines for total rows.
could you please help me.

Cheers
Chandra
Reply


Janus GridEX ropy_9000 [AE, USA] 07-Dec-2011 08:46:31

Hi

I want to use the total row in GridEx object, but I dont know how to use it. How should I put some values in it?! Please help...

Thanks...
Reply


Janus GridEX khalidelmeknesi [The Netherlands] 27-Oct-2011 14:18:15

Why my asp.net 1.1 c# webpage is reloading after select another row in my gridview. This is a problem because when I check or uncheck a checkbox on another row in the gridview it will not be saved.
Reply


Janus GridEX thomas.bittner [Switzerland] 22-Aug-2011 13:11:03

hello

when change the state of simple checkBox within the grid, the
EditingCell is not always fired. You can change the state only
once (then it will be fired). If you want to change the state back
you have to (un)check another box, first. From my point-of-view, the
EditingCell should always be fired, after the cell was edited ...

Thanks and kind regard,
Thomas.
Reply


Janus GridEX-Roottable is nothing in run time belleza_reina62 [AE, USA] 08-Aug-2011 12:41:58

hi
In runtime Gridex don't show roottable and columnes,in desing mod Grid show roottable and collumnes but in run time dont show eny collumn,Why?
thnx a lot
Reply

RE: Janus GridEX-Roottable is nothing in r... nc_1426 [UAE] 02-Oct-2011 13:22:28

I think you have the problem with the databinding .You must always bind a binig surce to your grid

like follows :

Dim ds As New DataSet
Dim DV As New DataView
Dim BS As New BindingSource

DV.Table = ds.tables(0)
BS.DataSource = DV
GridEX1.DataSource = BS
Let me know if you did it right at you still have this problem :)
Reply


Janus GridEX kalla.ad [India] 23-Jun-2011 05:24:44

how to select a row using rowIndex ?
Reply

RE: Janus GridEX magadzire.gary [South Africa] 28-Oct-2011 12:10:42

I'm using VB.Net 2010 and would like to find out how do I get the value on row 1 on a Gridex
Reply

RE: RE: Janus GridEX magadzire.gary [South Africa] 28-Oct-2011 12:16:10

To add more clarity, it's a 1 column no heading grid, if taht may assist you
Reply


Janus GridEX kalla.ad [India] 22-Jun-2011 06:47:34

hi,

I have a GridEX control and Web Service. The web service return an xml and bind to GridEX control on each 3 seconds.
For binding fresh data i need to clean my rows and rebind again so that i always lost my selection.

Is there any thing like update panel so that i can update the rows only and no need to re-bind again and again.
Reply


Janus GridEX isaac.contreras [Mexico] 02-Jun-2011 22:57:09

How do I merge rows ns columns? any sample?
Reply


Janus GridEX NW 25-May-2011 04:41:11

I would like to control the cell enable/disable in formattingrow event?
but i found out that there is no enabled property in cell.
Please advice me how can i get this.

Thanks in advance.
Reply

RE: Janus GridEX nc_1426 [UAE] 02-Oct-2011 13:26:39

You can do it in Editing Cell Methos like this :

Private Sub GridEX1_EditingCell(ByVal sender As Object, ByVal e As Janus.Windows.GridEX.EditingCellEventArgs) Handles GridEX1.EditingCell

If e.Column.Key = "Column_Name1" Or e.Column.Key = "Column_Name2" Then
e.Cancel = True

End If


End sub
Reply


Janus GridEX vb6 cells not appearing on Windows 7 jamie.glass [New Zealand] 06-May-2011 05:08:49

Hi, We have a legacy VB6 app that is using the Janus GrixEx 2000b. This grid after the upgrade of another software product does not show the cells of the Grid.
I can see the appropraite number of rows in the grid, but where the cells should be is completely blank.
Reinstaling the support files for our application works on Windows XP (so far) but not on Windows 7.

Any suggestions??

Thanks.
Reply

Janus GridEX vb6 cells not appearing o... samirshetkar [India] 28-Sep-2011 11:12:07

Hi, We have a legacy VB6 app that is using the Janus GrixEx 2000b. This grid after the upgrade of another software product does not show the cells of the Grid.
I can see the appropraite number of rows in the grid, but where the cells should be is completely blank.
Reinstaling the support files for our application works on Windows XP (so far) but not on Windows 7.

Any suggestions??


Thanks

Samir
Reply

RE: Janus GridEX vb6 cells not appearing o... md [FL, USA] 13-Mar-2012 14:33:28

Change the compatibility of the app to be run under XP-SP2 should give you back all your missing screen stuff..
Reply

RE: RE: Janus GridEX vb6 cells not ap... R.Alphey [Victoria, Australia] 19-Mar-2014 05:40:30

My app works fine running under source code from VB6, but the compiled code doesn't display anything in the GridEX grid.
(Windows 7, 32 bits). I've tried compatibility mode, (W2K, XP-SP2, XP-SP3, NT even), and no luck.

I'm at a loss here, do I just remove GridEX and replace it with something else, at least unti lI convert the app to .NET?

R.
Reply


Janus GridEX sadjad.abbasnia 01-Mar-2011 13:10:23

hi,
how to format value or text of a cell while typing???
Reply


Janus GridEX hosseinfani [United Kingdom] 20-Feb-2011 08:14:48

How can I fetch the FilterConditon of RootTable in ApplyingFilter event?
I can have it in FiterApplied, but it is too late.

Any prompt comments are highly appreciated.
Reply

RE: Janus GridEX roohi.iaum [Iraq] 17-Sep-2012 16:19:53

hello
i have janus grid that has filter on it
i want to save filter condition because of grid load again it has own filter condtion
how to save and load filter condition
thanks anywary
best regards mojtaba roohi
Reply


Janus GridEX sz_kk_26 [CA, USA] 13-Dec-2010 06:11:47

Hi
How can i inactive validation of GridEx?
i want to check validation by myself code...
for example when i want to submit my GridEX , i have a alert : Columns 'ID' does not allow nulls. but i dont need to this alert by janus!
Thanks.
Reply

RE: Janus GridEX sz_kk_26 [CA, USA] 13-Dec-2010 07:24:59

i foundOut
EventErrorHandling==false
Reply


Janus GridEX sz_kk_26 [CA, USA] 13-Dec-2010 05:58:07

Hi
i have a GridEX in my form
How can i empty my GridEX after submit?!
Thanks....
Reply


Janus GridEX - selection text mode aharshish [Israel] 02-Dec-2010 08:19:45

RE: Janus GridEX aharshish [Israel] 02-Dec-2010 08:18:18
My Janus Grid is lock for Edit. I would like to keep the edit mode Locked But have teh selection mode enable' meaning the user cannot edit the text' but have the option to copy/paste to clipboard the selected text
is that possible?
thanks
Adi
Reply

RE: Janus GridEX - selection text mode support@componentsource.com 02-Dec-2010 14:24:00

Hi Adi,

Thank you for visiting using this Janus Grid forum here at ComponentSource.

I run your Janus GridEX query with one of the authors of the grid and they sent the below information:

===
No, unfortunately it is not possible to copy the text of the cell if the edit mode is disabled
===

I hope it helps

Regards,

Enrique Perez
ComponentSource Support
Reply


Scroll into view salick [Israel] 19-Nov-2010 13:12:55

How can I scroll a selected item into the view so if the selected item is changed to a row which isn't in the current view it will be scroll there?

I'm calling the movenext() function
Reply

RE: Scroll into view support@componentsource.com 02-Dec-2010 14:24:49

Hi there,

Thank you for visiting using this Janus Grid forum here at ComponentSource.

I run your Janus GridEX query with one of the authors of the grid and they sent the below information:

===
Use the EnsureVisible method when you want a particular cell or row, which might be hidden, to be visible.
===

I hope it helps

Regards,

Enrique Perez
ComponentSource Support
Reply


Janus GridEX racarlet [AL, USA] 27-Oct-2010 19:45:16

I'm using Janus GridEX Version=2.0.1202.0 for WinForms and can't get the 1st column of a column set to freeze. I've set FrozenColumn to 1, but it has no effect. On a regular Column it works fine, just not when it is a ColumnSet.

Thanks in advance for your help.
Reply

RE: Janus GridEX support@componentsource.com 28-Oct-2010 13:09:38

Hello there,

Thank you for visiting using this Janus Grid forum here at ComponentSource.

I run your Janus GridEX for .NET question query with one of the authors of the grid and they sent the below information:

===
The FrozenColumn property has no effect in Hierarchical Grids or when columnsets are defined….
===

I hope it helps

Regards,

Enrique Perez
ComponentSource Support
Reply

RE: RE: Janus GridEX racarlet [AL, USA] 28-Oct-2010 14:13:16

Is there any way to freeze the first column in a ColumnSet?
Reply


Janus GridEX liem.nguyen [DC, USA] 08-Oct-2010 16:03:46

I tried to apply the GridEXFilterCondition programatically to the Janus GridEX, but the UI of the grid does not reflect the change in the Filter Row. Do I have to call any specific method to force it re-paint with new Filter values.

Thanks

Liem Nguyen
Reply

RE: Janus GridEX support@componentsource.com 12-Oct-2010 16:46:11

Hello there,

Thank you for submitting your question on this Janus GridEX Forum here at ComponentSource.

I run your question with one of the authors of Janus GridEX and they sent the below information for you:

===
A filter created in code won't appear in the filter row. If you want to see the filter in the filter row, move to the filter row, edit the cells using SetValue and call UpdateData to apply the filter. i.e.

//Move to filter row
gridEX1.Row = GridEX.filterRowPosition;
//set values in filter row cells
gridEX1.SetValue(1, "filter");
//...

//End edit in filter row
gridEX1.UpdateData();
===

I hope it helps.

Just let us know if we can be of any further assistance

Regards,

Enrique Perez
ComponentSource Support
Reply


Janus GridEX magnus.welander [Sweden] 27-Aug-2010 15:05:11

Hi!

We're using Janus GridEx 2000 with a legacy application. Now some users who are using Windows 7 are having problems with grids being disabled. I figure this is because Gridex2000 lacks Windows 7 support. Can you confirm if this is so? Is there possibly a patch that will help our Windows 7 users?

Best regards,
Magnus
Reply

RE: Janus GridEX support@componentsource.com 31-Aug-2010 15:21:07

Hello there,

I run your query with one of the authors of the Janus GridEx 2000 and they sent this information regarding the problem you mentioned:

===

We haven’t heard of a problem like the one you describe. The only problem we have seen (that could be related to the one you have) with the GridEX control working under vista or windows 7 is that some changes related to security in ADO may affect your application when working under these OS. For instance, prior to vista it wasn’t required to set the parameter "Persist Security Info=True" to a connection string and applications running under previous versions of windows were working correctly without such setting but now an error is thrown under vista if such parameter isn’t set. In addition to this, you may try running your application using windows 7 compatibility mode

===

I hope it helps.

Regards,

Enrique Perez
ComponentSource Support
Reply


Janus GridEX License mli [USA] 10-Aug-2010 19:00:47

Hi,

Our company purchased the Janus controls a few years ago and now the license key is lost, is there any way we can retrieve the license key?

thanks

Michael
Reply

RE: Janus GridEX License support@componentsource.com 13-Aug-2010 15:00:14

Hi Michael,

We will be happy to help with this.

Please, send us an email to support@componentsource.com with any details you might have at hand of your Janus GridEx purchase and we will try to find it for you. Also, please, note that if you bought the product through ComponentSource or Janusys Online Store, you should have a copy of the software and serial number on your account.

Look forward to hearing from you.

Regards,

Enrique Perez
ComponentSource Support
Reply


Janus GridEX paulh [South Africa] 25-May-2010 09:40:35

Hi All

I have a grid that when it loads, the grids focus is always at the bottom of the grid i.e. the vertical scrollbar is at the bottom.
The grid is sorted by date descending and the sort is correct but it is not setting focus to the top of the grid as it does with all my other grids, and the user therefore has to scroll to the top.
Is there a setting, or programmatically, to always set focus to the top (what has been selected as the sort order)

Regards
Reply


Janus GridEX bburnett [United Kingdom] 22-Mar-2010 15:50:36

I've started to have a very strange problem with VB6 and Gridex20.

The problem is that the grid behaves as it always has (the app has been around for 10 years) when running in the development environment or when the .exe is running on the development machine.

if I take the .exe to another machine then only two columns are displayed and any attempt to interact with the incorectly populated grid causes the application to crash.

If anyone can shed any light on this it would be greately appreciated.
Reply


Janus GridEX gordon.mallinson [United Kingdom] 15-Feb-2010 15:02:24

I am looking to recreate the merge cell functionaity that was present in the MS Flex Gri for VB6. Any one got an exmple of how you do this? I is listed in te features buI just cannot see how.

Regards

Gordon
Reply


Janus GridEX psiharath [France] 29-Jan-2010 17:03:01

I am owner of Janus GridEX V3.5 and I am looking for Export of GridEX to Excel capabilities - Where can I find VB source for this ?
Reply


Janus GridEX shadi_davoodnia [Italy] 26-Jan-2010 14:42:57

hi.i have a question about gridex version 2.
i have a select column in my gridex which is unbound to database.i made this with setasselector.
i want when i check this row with selector a particular cell gets enable and when i deselect it it gets disable.but just this cell not whole of column.
would you please help me.
Reply


Janus GridEX krravisha [India] 25-Jan-2010 12:11:53

I have used Janus.Windows.GridEX in my User interface.
I am trying to bind some data with the GriudEx object.but it is not reflecting soon after it is binded.Is there some refresh API specific to this?
I tried refreshing the gridEx object but invain.
Reply


Janus GridEX psiharath [France] 21-Jan-2010 20:09:32

I am feeding column headers in a classic Winforms DataGridView and a GridEX from Janus : I am loosing my Pascal camel case notation in GridEX header, while there is no problem with DataGridView header, for example :
DataGridView header = PsLang_IdLang where GridEX header = Ps Lang Id Lang.
More over, I am loosing the underscore (_) symbol and spacing is introduced between each "word".
What is the reason and how can it be solved ?
Reply


Janus multiColumnCombobox shadi_davoodnia [Italy] 12-Dec-2009 12:16:45

how can i fill multicolumncombobox with vb.net code.i set datasource and displaymember and valuemember but my combo does not fill
Reply

RE: Janus multiColumnCombobox carlosccastilloc [Dominican Republic] 07-Apr-2010 15:57:44

Hi

Din you learn how to add items to a dropdown hardcode?

Im trying to add static items to a multicolum dropdown.

have you any idea of how can i do that?
Reply


Janus GridEX artazanestor [Argentina] 23-Nov-2009 16:56:34

Tengo janus gridex2000 y vb6 y quisiera saber como usar gridex cuando paso con teclas de flecha de una fila a otra e ir tomando los datos de las filas para guardarlos en en text box del form
el evento selectionchange se que se dispara cuando uso las teclas de flecha en el grid ex mas no se como usarlo para tomar datos
Reply


Janus GridEX emiemiv [Macedonia] 21-Oct-2009 14:06:51

I'm having problem with navigating with arrow keys in Grid. I've used Janus.GridEX for some time, and never have encountered such problem. The problem is when using arrow keys the selection of rows jumps on the first or second row, and after that I can only move only between this two rows.
Any help appreciated.
Reply

RE: Janus GridEX emiemiv [Macedonia] 21-Oct-2009 15:26:58

Problem was with something completely different. There's no problem with navigating with arrows through Janus GridEx. Sorry for the post.
Reply


Janus GridEX - Setting KeyDown Jordi Reig 12-Oct-2009 19:42:04

Hello,

I would like to set the key down "." to key down "," (for decimals values), but I don't know how do I it.
I edited the keydown gridEx event but I don't know how I set the new key value.

Thanks.
Reply


Janus GridEX FormatString Jordi Reig 12-Oct-2009 10:57:44

Hello,

I'm trying to format a Janus GridEX for .NET column to a number with 2 decimals, and I don't know how to do this.
I think it is a FormatString property, but I don't know what value to put there.

Any ideas?

Thanks.
Reply


Janus GridEX FormatString Jordi Reig 12-Oct-2009 10:57:31

Hello,

I'm trying to format a Janus GridEX for .NET column to a number with 2 decimals, and I don't know how to do this.
I think it is a FormatString property, but I don't know what value to put there.

Any ideas?

Thanks.
Reply


Janus GridEX uma.ganapathy [India] 08-Sep-2009 11:16:45

I am using Janus Web control 1.5 version. Recently we have implemented SSL in our site as per application audit and we found few errors in Janus GridEx page. The one is "Object Expected" in the below line var GridEX = new GridEX('GridEX', GridEX_client, GridEX_client_tables, GridEX_client_selected_items, GridEX_client_rows_css, GridEX_client_hidden_values, GridEX_client_events, 0);

We tried to reinstall JanusSetupGridEXWebLicensed.msi Software and JanusWebSuitePatch.msi. Still we are facing same issue.

Please help me to solve this issue.

Regards
Uma
Reply


Janus GridEX uma.ganapathy [India] 07-Sep-2009 11:47:03

We are using Janys GridEX web licensed in Dot net application. Previously GridEx is working fine. Now we have implemented SSL (https) in site. GridEx is showing problem like unable to double click and shrinking problem.

Please help me to solve this issue asap. This leads to stop Janus Grid EX in our application.

Regards
Uma
Reply


Janus GridEX goodguy_hyd [India] 02-Sep-2009 10:39:46

How to validate the new data row in gridex while adding the new record to the gridex
Reply


Janus GridEX sally.de 24-Aug-2009 07:44:29

Hi all,
i'm new with januse development.
there is a problem when
i type space in a cell of the new row
or type sth and then remove that in a cell of the new row
at the top of the grid and then leave the grid component the row is added but
i want to check that some special column not to be null when the record added .
when i try to check this statment in the adding record event of the grid,
the focus of my form locked on the grid component and the user can't navigate to any other component.
when o trace the stack i notice that after the adding record event was invoked the enter event gonna invoke !!!
i have no idea why this occure.
any idea is greatly appritiated.
bests.
soheila D.
Reply

RE: Janus GridEX sally.de [Kuwait] 26-Aug-2009 08:21:35

Hi all,
I found the solution of my question.
if you check the status of the cell in the grid's "cell edited" evevt
and if it is null set the "datachanged" property to false.
it works. :D
:)
Soheila D.
Reply


Janus GridEX informatica [Belgium] 17-Aug-2009 16:24:28

Hi; I am trying to support drag drop of rows in a janus grid; and automatic scrolling of my grid when the dragging moves over the bottom or top ( columnheaders ) of the grid.
I found following.
The bottompart was easy :
private void ListDataGrid_DragOver(object sender, DragEventArgs e)
{
e.Effect = DragDropEffects.Move;
Cronos.UI.Win.Controls.CronosDataGrid grid = this.ListDataGrid;

if (e.Y >= PointToScreen(new Point(grid.Location.X + grid.Width, grid.Location.Y + grid.Height)).Y - 10){
grid.FirstRow += 1;

}

Because we are allowing for Filters above the columnheaders, the position (x,y) of these columnheaders is not as easily retrieved.
Is there any way to calculated the x y screen coordinates of the columnheaders or of the grid.GetRow(0), so that I Could write :

headersY = .....;
if (e.Y < headersY)
grid.FirstRow -= 1;


ps : we are using Janus Win Forms 3.0

Thanks for any help
Reply

RE: Janus GridEX informatica [Belgium] 18-Aug-2009 09:31:51

nevermind, I was using the wrong pointtoscreen method,
works using Grid.PointToScreen
Reply


Janus GridEX dredd79 [USA] 31-Jul-2009 15:13:47

Hello,

Using VB.net in Visiual Studio 2005, Janus GridEX vs2, .Net Framework 1.1, and connected to an SQL server database with one root table. For some reason when I run my program the data won't display on my GridEX but will show the number of records in the RecordNavigator. Also when I run the SQL statments in query Analyser, the data table will display with the exact number of records as in the gird with no errors. My SQL data table is unbound. Can anyone help me as to why my data won't display in my GridEx?

Thanks
Reply


Sort in FieldChooser for Janus GridEX dorothyww [China] 01-Jul-2009 04:36:21

I am using Janus Grid for .NET.
One problem I get is the FieldChooser does not have sorting feature.
Is there any way I can get this feature out ?
Thanks a lot.
Reply

RE: Sort in FieldChooser for Janus GridEX dorothyww [China] 20-Jul-2009 11:11:04

Any updates on this?
Thanks,
Reply

RE: Sort in FieldChooser for Janus GridEX johan.huysmans [Belgium] 04-Jul-2013 08:57:25

We are using this Janus GridEx component a lot and are also strugling with the missing functionality of sorting the fields in the fieldchooser in a customised way and receive lots of complaints from our customers about this. Is there a solution ore do we need to take other components ?

Kind regards

JOHHUY
Reply

RE: RE: Sort in FieldChooser for Janus GridEX support@componentsource.com 08-Jul-2013 17:29:07

Hello there,

Thank you for submitting your question on the Janus GridEx forums here at ComponentSource

I run your query with one of the authors of the product and they sent the below information for you:
====
If you use a form with a FieldChooserControl instead of of the ShowFieldChooser method you can choose between 3 ways of sorting the header with the HeaderOrder property. you can show the fields in Alphabetical, Positional or index order.
====

I hope it helps.

Regards

Enrique Perez
ComponentSource Support
Reply


Janus GridEX kittu07_babu [India] 26-Jun-2009 10:09:31

i am using Janus GridEX control in vb.net but i have a problem in this gridex it was
consider two coloums ,first coloumn all rows will be filled from front end and not editable and second coloumns all coloumns are editable then
in second coloumn second row is written as " no" then i want to diasable next two rows of both coloumns (0r) i want to diasable the next two rows of second coloumn not to edit
plz send the code for the above functionality
Reply

RE: Janus GridEX aharshish [Israel] 02-Dec-2010 08:18:18

My Janus Grid is lock for Edit. I would like to keep the edit mode Locked But have teh selection mode enable' meaning the user cannot edit the text' but have the option to copy/paste to clipboard the selected text
is that possible?
thanks
Adi
Reply


Janus GridEX Udin 28-May-2009 05:26:48

We have an error that is getting this error intermittently on ASP.NET 2.0 web applications when loading Janus GridEx on our web page, our application running under Win2003 server.

"Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)"

is there any say to solve this problem ?
Reply


Janus GridEX max 07-May-2009 20:46:10

I would like to have a column which allows the user to select one row only. I have added a column of type checkbox. How can I modify the grid so that the user can select only one row at a time (IE as soon as they select a second row, the first row should become unselected). I am using an unbound grid.
Reply


Janus GridEX s.neumann [Germany] 31-Mar-2009 09:58:09

I have some questions concerning GridEX2000b.

- I use GridEX.FullyLoaded for determining if I have to call the LoadEntireRecordset method.
On which factors it depends whether grid loads all data immediately or only piece by piece on demand.
e.g. much records, or a slow connection to the database ...

- what is the best way binding data on the grid. actually I user the following:

.CursorLocation = jgexUseClient
.DatabaseName = Replace(CONNECTION_ODBC, "ODBC;", "")
.LockType = jgexLockOptimistic
.RecordsetType = jgexRSADOKeyset
.RecordSource = DBEngine(0)(0).QueryDefs("defaultQuery").SQL


Thanks for each help !
Reply


Janus GridEX hs.mishra [India] 23-Jan-2009 07:11:25

How can we make Hierarchial Grid in multilevel

i need a report having 5 level like
Region-->Branch--->Cpa-->FA-->Client Wise
any one can help me how can i implement.

all levels have their seperate fields as well as columns

thx
Hari
Reply


Janus GridEX l.ingold [Switzerland] 14-Jan-2009 16:03:44

In MSAccess 2003, I use a Janus Grid 2000. I use the GridEx1_ColumnHeaderClick event, because after the user changes the sort order, I want to jump always to the first real row of the grid (not grouping rows, but the first data row). For this, I use the Row property. I doesn't work, if I do that within the Event procedure. However, if I wait a little, say 50 ms (with the help of a timer), then it works perfectly. This lets me think that at the time of ColumnHeaderClick event procedure, the sorting hat not completed yet. I am very unhappy using a timer, because how can I know which is the correct time? Would 50 ms be enough for a grid record source with 100'000 records, for example? Isn't it possible to get some callback at the correct point of time, that is when the sorting has completed (instead when the user presses the column header)? Or what else could be done to have a good solution?
Reply


Janus GridEX nhi.nguyen [USA] 21-Nov-2008 16:29:20

I am having a problem with grouping on a particular column on my grid. All columns group fine, but when I drag a particular column to group, the application crashes and says the entry has already been added to the dictionary. The field is a string.
Reply


Janus GridEX Rebecca [Singapore] 17-Sep-2008 10:34:47

Hi,

The FindAll in Janus grid highlights all the rows found. Is there any way to get the rowid of all the rows that are found. This is because I need to get all the found rows and put them in an other grid. any idea would be much appreciated.

Thanks,
Rebecca
Reply


Janus GridEX Rebekah 16-Sep-2008 10:18:30

Hi,

Can you help me with the find functionality of Janus Grid?

Dim column1 As GridEXColumn
column1 = grdex1.RootTable.Columns("abc")

if (grdex1.Find(column1, ConditionOperator.Contains, SearchText_Value, -1, -1)) then
grdex1.EnsureVisible()


But the above statement " if (grdex1.Find(column1, ConditionOperator.Contains, SearchText_Value, -1, -1)) " always returns false though the value is found in "abc" column.

Thanks.
Rebekah
Reply

RE: Janus GridEX rebekah [Singapore] 17-Sep-2008 05:50:49

the error was due to the column being numeric and i was looking at contains which relates to string
the issue resolved with the following
If (Me.grdex1.Find(grdex1.RootTable.Columns("abc"), Janus.Windows.GridEX.ConditionOperator.Equal, CInt(SearchText_Value), -1, 1)) Then
Reply


Janus GridEX cheRayaneh [Tanzania, United Republic Of] 17-Aug-2008 19:30:23

Hi
I want set a colun of geidex to muticolunDropDowndown but i cant any way.Please help me for it Best Reguard
Reply


Janus GridEX info [United Kingdom] 11-Jul-2008 11:38:15

We are testing the Janus GridEX 2000 to have jpg images with in the grid with descriptions, but there is not information within the help file about supported image formats.

Does anyone know the supported image file formats?

Many thanks

Barry
Reply


Janus GridEX murali.iyer [India] 15-Jun-2008 15:31:28

We need to implement Automated Testing for one of the products that implements the Janus Grid Tree.

The automation tools like QTP, Silk or Rational normally identifies the objects and tree branches each as independent objects that help automation.
However the Janus tree Grid considers the entire tree as one object and hence overall does not support automated testing (other then using screen co-ordinates)?

Can anyone throw some light on this?

Regards

Murali Iyer
Reply


Janus GridEX bab_1363 [USA] 09-Jun-2008 07:53:43

We are considering Janus' Grid. we want to create our own editor component and to place it in each editable cell when needed,
we did not see how this is possible.
thank you.
Reply


Janus GridEX awerber [USA] 24-Apr-2008 18:42:25

I'm using the Janus Gridex for Visual basic 6. I want to set the background color of some of the rows in a grid (based on the value in one column) to gray. The properties of the grid are set to use alternating colors.

It seems to me that I need to create a JSStyle object, add it to the grid's collection of style objects, then use that style object fo rthe row. But I tried somehting like that, and it did not work.
Reply

RE: Janus GridEX awerber [USA] 21-May-2008 20:14:25

I just want to see what a reply looks like in case I ever get one.
Reply

RE: Janus GridEX Peter Ferguson [United Kingdom] 20-Nov-2008 00:28:53

I know this may be a little late but then if it does not help yourself then I hope it may help someone else...

In order to change the colour of a row then the FormattingRow method should be called in order to intercept the formatting of each displayed row. Note the use of displayed row as this is only for the rows that are visible to the user and not all rows in the datagrid as this is a way of only formatting the rows that matter.

The following code is a sample of the code that should be used to format the row depending on the value of a particular cell:

Private Sub GridEX2_FormattingRow(ByVal sender As System.Object, ByVal e As Janus.Windows.GridEX.RowLoadEventArgs) Handles GridEX2.FormattingRow
Dim rowCol As New Janus.Windows.GridEX.GridEXFormatStyle

rowCol.BackColor = Color.Gray
rowCol.ForeColor = Color.DarkGray
If e.Row.Cells("abc").Value = "testValue" Then
e.Row.RowStyle = rowCol
End If
End Sub

In order to change the formatting of a single cell then just change the following:
e.Row.RowStyle = rowCol
to:
e.Row.Cells("abc").FormatStyle = rowCol

Hope this helps someone and if so then please let me know.

Regards,
Peter
Reply

RE: RE: Janus GridEX morourke [Ireland] 30-May-2010 08:52:30

Thanks for that. Trying to add a format condition was soing my head in...
Morke
Reply

RE: RE: Janus GridEX martyn [United Kingdom] 09-Jul-2010 10:48:08

Peter,

Thanks for that - exactly what I needed.
Judging by the lack of answers on this forum, there's not a lot of help out there - so very pleased to find your post.

Martyn Matthews
Reply

RE: RE: Janus GridEX morourke [County Dublin, Ireland] 02-Feb-2011 10:05:39

Hi,
Thanks for the tip. Have been using Janus for years, but always find it a drag to find solutions.
Mick O'Rourke
Reply


Janus GridEX karenchambi [Brazil] 18-Mar-2008 13:18:50

Hi,
I have problems when I try to delete from a GridEx. The record is deleted from database, but after the operation, I got a message "Collection was of a fixed size".
How can I resolve this?
Thanks a lot

Karen
Reply


Janus GridEX sadman [Mauritius] 06-Feb-2008 07:40:35

Hi,
One of the fields that I retrieve from an Oracle database is a concatenated string field delimited by a carriage return+ new line ASCII (CHR (10) || CHR (13)).
Exp:'first' || CHR (10) || CHR (13) || 'second'.......
The corresponding column in the gridEx replaces the two ASCII characters with two squares and then continues the suppose to be a second line in the first line as well.
The maxLine of the column is 2.
Isn't there a way to simulate a crlf in the gridEx column?
Thanks.
Reply


Janus GridEX awerber [USA] 30-Jan-2008 19:37:12

I'm using the GridEX for VB6, and I'm trying to load a drop down column dynamically from the values in another grid. For Example, let's say I have the strings "123" and "456" in column X of Grid1. After updating grid1, I want to load a drop down column in Grid2 with the values "123" and "456" as the display values and use numeric values in column A of Grid1 as the index values for the drop down in Grid1. When the user goes back and adds a new row to Grid1, the drop down in Grid2 will be updated with the new values. Deleting from Grid1 will delete a value from the drop down.

I thought I had all this working properly. For some unknown reason, I'm having a problem now. After entering 2 rows in Grid1 and changing focus to Grid1, one of the values in the drop down is being selected by default. using my example above, after entering the first two rows in Grid1 and clicking on Grid2, the value "456" shows up. While this might not appear to be a terrible problem, there are some updates to columns that are not being made after the the grid is updated.
Reply


Janus GridEX - SQL Server 2005 ExpresCompatability adam [Australia] 29-Jan-2008 03:45:03

We have developed an application in .net with the gridex control. ON the developer machine we are linked to an SQL 2000 dataabse and it works fine. However, when we set up and connect to a sql 2005 Expres database any time we click on a grid the application hangs and we get a not responding message for a while. It eventually works until you click on the grid again. Are there any know issues with connecting to sql2005 express?
Reply


Janus GridEX gndoro [South Africa] 21-Jan-2008 10:44:35

How can i associate particular rows to particular icons in an imagelist at runtime? Currently i have the following lines

Private Sub GridEX1_FormattingRow(ByVal sender As Object, ByVal e As Janus.Windows.GridEX.RowLoadEventArgs) Handles GridEX1.FormattingRow
e.Row.Cells("Icon").ImageKey = file 'file is a changing value which is unique to a row, an image with the same key would have already been added to the imagelist
End Sub

When i run the application however, the system is replacing icons for all the previous rows with the icon of the last row, how can i make the grid hold all the previous icons correctly?
Reply


Janus GridEX bozkurt.dogan [Turkey] 11-Dec-2007 14:58:32

The Janus GridEX 2000b is being used in our product, named OMagic, which is an application written in Visual Basic 6. We are located in Turkey and sell OMagic to call centers here in Turkey. One of our customers now operates in Russia. To my customer in Russia I gave a compiled version of OMagic, though the Cyrillic characters do not display right in the grid. They are replaced with junk characters.

A few more facts which may be of interest:

The cyrillic characters are stored correctly in a MS SQL Server 2000 database. The collation of the database is SQL_Latin1_General_CP1251_CI_AS. When I read a table cell, using ADO, and display the value of that cell in a message box, the cyrillic characters are displayed correctly.

The operating system of my computer is Windows XP Professional. When I change Settings > Control Panel > Regional and Language Options > the Advanced tab > Language for non-Unicode programs from Turkish to Russian, open my Visual Basic project, delete the janus grid from a form, re-drop it on the form (and of course re-enter all the properties), and re-compile the Visual Basic project, the grid displays the Cyrillic characters correctly.

There seems to be something in the .lyt file that causes the problem. After I change the regional options from Turkish to Russian, just for the heck of it, I saved the layout of the problematic grid before I deleted it from the form. Then dropped the new grid on the form. The new grid displays the characters correctly, but when I load the problematic layout, the problem comes back. Since the lyt file is binary I could not open and analyze it to see what the differences were. Another thing is that, I made sure that both layouts and the form on which they reside are absolutely the same as seen from within the Visual Basic IDE, yet the frm files are different…
Reply

RE: Janus GridEX Laurella.Asselman [The Netherlands] 21-Dec-2010 12:03:42

Hi,
I have the same problem. I am trying to update the headers in the Grid according the chosen language.
Headers come from a SQL 2005 DB and are in different languages like English, German, Russian, Bulgarian etc
Thanks
Laurella
Reply


Janus GridEX cebourassa [USA] 10-Dec-2007 08:21:53

Hi,

When a broken rule occurs in the Janus Datagrid it shows a yellow diamond icon with a red exclamation mark. Is there any way to change the icon to a red dot so it can be consistent with the red dots that show on the main form when there is a broken rule?

Cliff B
Reply


Janus GridEX louismoisan [Canada] 13-Nov-2007 18:24:34

Hi all,

I have one gridEx with ADO datamode and i want to show or print one column with long text on many line.
I use gridEx for vb6.

Can i do this ?

Thanks !
Reply


Janus GridEX thanosmanesis [Greece] 27-Oct-2007 21:38:44

Hi all,

I'm using two GridEx and two DataTables (I'm not usiing dataset).
One GridEx is binded with the first datatable (called Companies) and has fields: "ID", "Title".
The other GridEx is binded with the second datatable (called Orders) and has fields: "ID", "CompanyID", "Product".
How can i create during run-time a dropdown combo on column CompanyID of the second GridEx having valuemember=ID and datamember=Title from the first GridEx?

I have done it using GridEx Designer but i can't do it using only code during run-time.
Please, if someone has done it, send me the code.

Thanks,
Thanos
Reply


GridEX Delayed Binding Ragin Tiger [USA] 06-Jul-2007 20:47:36

We are retrieving ~100000 records into a gridEx. Wondering how we could have the grid retrieve and display only say the top 100 rows on load and then do runtime binding as the user scrolls down the grid rows, eventually showing all the records.
Sample code would be helpful. Thanks in advance.
Reply


Multi Cell Selection in GridEX ebrahimi_amir_hossein [Italy] 29-Jun-2007 12:41:38

hi everybody.
I need to make the janus grid select cells exactly like the exel,for example I need to be able to select multiple cells. my problem is after I select the first cell,holding down the cntrl button, and selecting the next cell, the row in which each cell is in becomes highlighted, but I want only the two cells to be highlighted. How can I prevent the entire row to be selected in this case?
I would be greatful if anybody could help me.
Reply

RE: Multi Cell Selection in GridEX brigardin_a [Ukraine] 27-May-2008 15:52:15

Hi

I have the same problem. Have you found any solution?

Thanks in advance
Reply

RE: RE: Multi Cell Selection in GridEX ladan_d_4157 [Azerbaijan] 25-Jul-2010 08:26:27

Copy One Cell To Multi Cell Selection in GridEX
Reply


Janus GridEX gsng12 [India] 20-Jun-2007 07:14:28

hi all

can any one helpme how can i add columns in janus grid
Reply

RE: Janus GridEX gsng12 [India] 20-Jun-2007 07:25:30

checking
Reply


Janus winform controls - 64bit support eyalre [Israel] 12-Jun-2007 11:51:24

Hi all,

we have the suite (winform) and we need to build 64bit release.
Is there version supporting 64bit?

Thanks,
Eyal
Reply


Janus GridEX stardancer76 [China] 16-Apr-2007 06:30:17

Hi Everyone, thanks in advance for taking your effort and time to look at my issue. Here we go:

I got GridEx with two tables. One rootTable and a child table. The row in rootTable can be expanded to show the child table's record.
After the childtable row has been edited, i will repopulate the whole grid. I want to find the current row in rootTable to set the expanded property = true. Somehow, the method Grid.Find() returns false. If it is used in a single table it is working. In this case, how can i get the current row in root table and set the property expanded = true correctly.

Help me!
Reply


Janus GridEX - Pasting from Excel AKnox [USA] 05-Apr-2007 22:21:20

I was wondering if it was possible to copy a table from MS Excel and paste it in the same format.
Reply


Janus GridEX rajeshgade2002 [India] 05-Apr-2007 10:57:10

Hi,

I am using Janus GridEx in my vb6 project. I need to color the rows of the grid to red based on a criteria. When i click on a button the the grid should be back to normal without color.
I need the code for this. Can anyone tell where to find a tutorial on Janus Grid.
Reply


Janus GridEX Mahdi(iran) 19-Jan-2007 19:18:19

Hi everybody.
please help me.
How can i find and highlight my record in a Sorted Grid after updating?
Reply


Janus GridEX snow_bird_8261 [India] 19-Jan-2007 19:17:50

Hi everybody.
please help me.
How can i find and highlight my record in a Sorted Grid after updating?
Reply


Janus GridEX format weeks andreasdahllof [Sweden] 20-Dec-2006 16:20:24

I'm using GridEx with vb6 and I'm trying to format a column according to :
GridEx.Columns(ColumnName). Format = "yyyy-ww"

I use a system where the default system first day of the week is monday, and sometimes I get the wrong week shown in the column. It seems that the GridEx default start day of the week is sunday. Can I use the systems default day instead? As I do in the function Format in vb by sending vbUseSystemDayOfWeek as firstdayofweek:
Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

I hope this problem has a simple solution, I tried to download the help files online, but I can't find the information I need.

Thanks!
Reply


Janus GridEX format weeks andreasdahllof [Sweden] 20-Dec-2006 16:19:59

I'm using GridEx with vb6 and I'm trying to format a column according to :
GridEx.Columns(ColumnName). Format = "yyyy-ww"

I use a system where the default system first day of the week is monday, and sometimes I get the wrong week shown in the column. It seems that the GridEx default start day of the week is sunday. Can I use the systems default day instead? As I do in the function Format in vb by sending vbUseSystemDayOfWeek as firstdayofweek:
Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

I hope this problem has a simple solution, I tried to download the help files online, but I can't find the information I need.

Thanks!
Reply


Janus gridex Grouping msadeghebrahimi [Japan] 16-Dec-2006 09:39:07

Hi everybody, I'm using janus grid trial for the first time so I've come up with many issues:
1. When I add a new record which doesn't meet validation rules the grid starts to raise many exceptions and removes the values and sometimes even terminates the application, why does this happen and generally how can I handle the validation exceptions my slef?
2.When I group the table (containing around 20000 records) and update the values in the criterion column and change all of them to a different value and the ungroup them, another exception is raised, I know the reason but I don't know how to fix it
Eg. I group my table by name so there will a group called "jack" and then I change all of the members of this group's name from jack to "John" and then ungroup it, the grid wants to remove the group header "jack" but infact there is no group called "jack" any more so it raised the exception saying there's no such object.
What can I do?
thanx very much in advance
Reply


Janus GridEX "plz urgent help!!!" alyushadevil101 [USA] 30-Nov-2006 17:22:51

hi i have download a "Janus Gridex 2000" before and use it it is so good!!
but i format my PC and forget to make a copy and i don't i have mediaKIT could i download it again if i give u my Lisence number and my company name and key ??
plz urgent help!!!
Reply


Janus GridEX alyushadevil101 [USA] 30-Nov-2006 16:53:40

hey ALL
i wnat to know if i can get Janus Gridex 2000 for vb 6.0
by downloading it withoit payment as a program but i wnat to buy a lisence from the website ??
could i do it? or i need to download the lisence and the program both togther!!
plz help....101
Reply


jgexEditCalendarDropDown problem handyandyh [Australia] 09-Nov-2006 23:13:47

Hi there,

After accessing a cell that uses jgexEditCalendarDropDown as the edit mode, I am unable to click on a command button straight away. Eg user updates a row/column and then clicks on a "save" control button on the form...

The grid loses focus and the command button gains focus, but the click method of the command button doesnt fire for some reason.

Only seems to happen after using the EditCalendarDropDown edit mode on a cell. I've tried switching the edit to another mode after an update, but once that type of edit mode has been used it doesnt seem to work.

Any help or a work around would be appreciated.
Reply


Janus GridEX ted.steadman [USA] 31-Oct-2006 16:43:31

GridEX20.ocx in Access2003 under XP SP 2

I have 6 Janus Grids within 4 Acess 2000 forms. I have placed GridEX20.ocx in C:/winnt/system32
I have registered the Active x in Aceess2003 using the tools menu. There is a reference to JanusGrid in the VBA code.

There are intermittent errors in the application showing error 438 - "Method or property not supported" Works on some user machines and not others.
The app was developed on Windows 2000 SP4 but distributed to a mix of w2k and XP SP2 users. Erros weem to occur most often on XP SP2 machines.

Any help will be greatly appreciated

Thanks, Ted
Reply


Janus GridEX svb [Germany] 18-Oct-2006 09:28:46

is it possible with actual version of gridex activex 2000b to print data to a virtual printer or in database. The question is, how to manage it, to send a result (display) as e-mail - not to print it directly to a printer. Thank you in advance
Reply


Janus GridEX bwagner [USA] 12-Oct-2006 21:01:07

I'm using the Janus GridEx2000b in VB 6 with SP6 on WindowsXP. All is well. I'm operating in Unbound Datamode. I'm allowing the user to add records to the gid: AllowEdit-True, AllowAddNew-Trye, AllowDelete=True, AllowRowSizing=False, AutomaticSort=False. I have the NewRowPos = 0 (top) and things work great. But, what I'd really like to do is allow the user to rapidly add records to the grid. My code picks up the records and works them in it's own way, without direct database access. Again, it all works great.

What I'd really like to do, when the user is done entering the data in the NewRecord row, and hits enter to commit it, the new record is appended to the end of the grid in a newly applocated row. Fine. But, I'd like to tak some of the details they entered, and put them back in the NewRecord row. So far, so goo - I've accomplished this - but I need *NEED* to force the user into EDIT of one of the cells in the NewRecord row. Is there some way to send the grid control a vbKeyF2, or some way of asking the Grid to activate the editor in a cell, programatically, whithout needing the user to enter a key?

Please help - I desperately need this one. Once I have this licked, we can go production with the Janus GridEx200b - which has been a wonderful control to work with, so far.

TIA for any help you or anyone can provide.
Reply


Janus GridEX lise [Norway] 25-Aug-2006 11:46:42

Error message: control array element 'index' doesn't exist

I’m using Janus Grid control in my VB 6.0 Form. I have a gridindex ranging from index =0 to index=3. When I load my form the 1’st time it works fine, but when I load my form again without exit my application I get the error message: control array element 'index' doesn't exist.
But the strange thing is that it sometimes works fine to load the form several times without exit the application, but sometimes I get the error message. If it woks fine I can do it over and over again and I will still work fine, but if I then exit VB 6.0 and execute my application and then tries to load my form several times it would not work.
What should I do? Somebody know this problem?
Reply


Janus GridEX - ASP.NET smmmax [United Kingdom] 13-Jul-2006 11:34:19

<Stephen.Maxwell@sportscotland.org.uk>

Has anbody used the Validation - GridEXFormatCondition
I dont know if i added it correctly and how does it validate your entry and stop invalid entries.

With grdDataEntry
.DataSource = CreateDataSource()
.RetrieveStructure()
.DataBind()

.AllowEdit = Janus.Web.GridEX.InheritableBoolean.True
.RootTable.AllowEdit = Janus.Web.GridEX.InheritableBoolean.True

Dim oCondFormat As Janus.Web.GridEX.GridEXFormatCondition
oCondFormat = New Janus.Web.GridEX.GridEXFormatCondition(.RootTable.Columns("Test1"), GridEX.ConditionOperator.Between, 0, 100)
.RootTable.FormatConditions.Add(oCondFormat)

End With
Reply


Janus GridEX rhprod1 [Greece] 26-Jun-2006 09:05:30

hi all.i have janus gridex 2000 control on VB 6.i want to have 2 different colors in one grid.
for example the first row i want to be white and the second blue by default.what i must do?
(sorry for any mistakes in language i don't know very good english.)tnks a lot!
Reply


Janus GridEX topcat 16-Jun-2006 08:05:14

Wonderful GridEx (in Windows Form) but I can't work out how to refresh the row source of a combo in the grid after a new entry has been added (programatically) to the list in a database. Combo is based on a DataTable and have managed to update that OK but not the list available to users when it is dropped down. It updates that only if the form is closed and reopened. Does anyone have an inkling of how to do it??
Reply


Janus GridEX Iliffe [Germany] 08-May-2006 18:23:13

Hallo, wird hier auch deutsch gesprochen?
Reply


Janus GridEX KM 12-Apr-2006 14:27:28

We are trying to access the webpages on a remote server using Checkpoint. It loads the page however it does not load the gridex in the page. any ideas?
Reply


Janus GridEX moq_ham [Palestinian Territory, Occupied] 07-Nov-2005 21:18:53

I Have Grid with 5 coloms

in some coloms how to make the cell write only numbers like (55 , 55.5) and don't accept letters or number in Error form like (55.5.3)

Thanks
Reply


Janus GridEX find Column header data rachelmchaney [USA] 25-Oct-2005 22:25:35

I'm having problem Identifying the column in VBscript code I get the row information fine.
Example
dim Objgrid as gridex
set gridex as guiobject(name of object)

objgrid.row = irow
rv = objgrid.getvalue(icol)

This pass back the value of the row not the column header.
Can you help me get the column headers.

Thank you
Racheal
Reply


Rowcount nidhi_kabra76 [Germany] 24-Oct-2005 16:13:30

Hello All,

I've a problem with Rowcount.I'm using 2 Janus Grids on the same form,but only one is visible at a time.The first Grid works perfectly fine. The problem is when i click a button to make the second Grid visible ,the rowcount is 2 and colcount is 2. If rowcount is 0, then i want to fill the grid but because its 2 it doesnt get into that loop and the data is not displayed in the grid.

Ive seen that at design time, Janus grid has 2 rows and 2 columns. But the rowcount should be 0, till the time the recordset property is set. Why is the rowcount 2 in my case am not understanding that? If i set a breakpoint it works well and if i click the button again it works well.It just doesnt work the first time. If someone has any idea what could be the reason,pl do write in. Its urgent. Thanks in advance.

Nidhi.
Reply


Janus GridEX fileds values disappear abidse [Pakistan] 07-Sep-2005 12:13:29

im using Janus Gridex 2000 and problem is that i made new invoice no in master details form i select query GridEX1.RecordSource = "select *from SalesDetails where SalesDetails.InvNo = " & tbino.Text detrail table contain these fields invno,itemid,quantity,discount,amount but in grid i show to other fields itemname and salesprice from sales table all these enteriese righty show in row. Now problem when i move to next line these two rows values disappear ( itemname and salesprice) all others working right ever thing updates i got help from advanced example but that is also showing same behavior plz help me
Reply


Janus GridEX monica.dunne [Australia] 20-Jun-2005 06:44:17

HI

We use the Janus Grid in a database and we are having a problem with data 'disappearing'. Our database Audit Log records it has been entered but it does not get displayed in the Grid properly. I suspect it has someting to do with when the data is re-ordered into an order other than the default order and then additional data is entered and stored in table other than the one the Janus Gris is displaying data from. This is part of the error message recorded in the error log - ErrorNumber='5' ErrorDescription='Invalid procedure call or argument '
Module='frmOptions '
Procedure='Sub JanusDatabase_RowColChange

Our programmer is on holidays at the moment and I am trying to get to the bottom of what is a major headache for us. Can anyone shed any light on what may be the cause of our problems?
Reply


Janus GridEX azahra [USA] 16-Jun-2005 15:50:01

While testing a project that has a Janu Grid I found that a message box pops up saying “Destroy” with an “OK” button. It seems to only happen when an editable grid has errors and you try to remove its focus. When “OK” is clicked nothing happens. If you click on the grid again it pops up again.
After some searching I found that the word destroy is located in some Janus XML files on my C drove. I wasn’t able to find the line of code that pops up the message box, maybe its part of the dll for the control?

Please let me know how to stop this as it is not something we want a user to see.
Thanks
Reply


Janus GridEX ieshulman [USA] 13-Mar-2005 19:08:34

I wuld like to have a grid in WinForms where if a user clicks on a row or if focus is set to a specific row, certain buttons on a form (edit/delete) are enabled. Then when a user clicks on a button, I'd get a handle on row identifier.

Which event should I use to enable/disable buttons and how can I get a handle on row identifiers when buttons are clicked
Reply

RE: Janus GridEX paul [USA] 24-Mar-2005 15:50:31

1. To enable/disable buttons, use the GridEX.SelectionChanged event. It will fire each time the selection in the grid changes. By default, the grid should allow a single selection, which will be the entire row of the grid. If you change that to allow multiple selections, you will need to get the GridEx.SelectedItems collection and navigate it to determine which item to test to set the button properties.

For a single selection, however, the following VB.NET code would work:

Dim sel as GridExSelectedItemCollection = MyGrid.SelectedItems
If sel.Count Then
Button1.Enabled = CBool(sel(0).GetRow().Cells("ColumnToCheck").Value)
End If

2. Use the GridEx.GetRow() method to get a handle to the current grid row.
Reply


Janus GridEX plagunas [Mexico] 13-Feb-2005 22:38:43

Hello , Im trying a GridEX Trial, but i have a little mistake.

I have a gridEx in table view, i have 15 Rows and 7 Columns, i only want to select a rate of this columns.
It's possible it?
Reply


Janus GridEX nileshs [USA] 11-Feb-2005 19:44:48

I want to know if there is a way to merge columns using Janus Grid? If yes, than how?
Reply


Janus GridEX zacosta [Australia] 13-Jan-2005 01:40:59

Pls, I need help on how to display chinese characters using Janus Grid.

I have setup a Chinese Windows XP OS as well as have a Chinese keyboard.

I have an MS Access XP database as the backend storage and it is also setup to store chinese characters.

I need help on how to set Janus grid.

In my sample program i have set the following:

GridEx1.Font.Name = "MingLiU"

Is there anything else that i need to set? Could you please provide me with a sample code. Thanx.

-Regards
Zaldy
Reply


Janus GridEX Omar [Peru] 15-Sep-2004 17:11:02

Pls i need help, I have Janus net Registered i work with visual studio .net, when i use the grid in my pc, this work ok, when i copy the program in another pc appear the message "Janus Grid not registered". In Visual Studio .net i only need copy bin subdirectory in another pc , and the program work... what happend with the janus?... thanks in advance

Omar Garcia N.
Projects Manager
Reply

RE: Janus GridEX 22-Nov-2004 16:54:04

Excellent product
Reply

RE: Janus GridEX 22-Nov-2004 16:54:28

Excellent product
Reply


Janus GridEX teschimpf [USA] 30-Mar-2004 18:31:09

i am using a product wintotal and at times we are getting the following error and wanted to know if you knew anything about it. if so i will try and provide more details.

Janus Gridex Control 2.0

"Disk or network Error"
Reply


Janus GridEX LD [USA] 04-Mar-2004 21:06:59

I am considering the ActiveX version of GridEx for use in an Access 2002 ADP project that I am working on.

I have downloaded the trial version and I am attempting to set up a very basic form for the purpose of testing the grid.

I am encountering an error when attempting to set a recordset to the grid.

This is the code:

Private Sub Command1_Click()
Dim gr As GridEX
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim mySql As String

mySql = "Select * from Contacts"

With rs
.CursorLocation = adUseClient

.Open mySql, CurrentProject.Connection, adOpenForwardOnly, adLockOptimistic

End With

Set gr.ADORecordset = rs

End Sub


This is the error:

Runtime Error #'91'

Object variable or With block variable not set.

Please let me know if there is a compatability issue or I am doing something wrong.
Reply

RE: Janus GridEX staffan [Sweden] 24-May-2005 17:47:53

You have to use Me

Dim jsgx As GridEX

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim mySql As String

mySql = "SELECT * FROM QryTreeListShowEjKlaraArbetsplats "

With rs
.CursorLocation = adUseClient

.Open mySql, CurrentProject.Connection, adOpenForwardOnly, adLockOptimistic

End With
'Doesn't work
Set jsgx.ADORecordset = rs
' Thjis work
Set Me.jsgx.ADORecordset = rs
Reply


Janus GridEX nileshs[usa] 20-Feb-2004 01:20:50

I just got the new Janus Grid ActiveX OCX version. We got the site license for the company. I am facing a problem while redistributation. My application gives following error.

Error 747 No design-time license information found. Pls contact vendor to obtain it

Can somebody please help...
Reply

RE: Janus GridEX jcastanedo [Panama] 20-Feb-2004 12:25:06

If you are loading the control dynamically at runtime, the license manager requires a string based on the license of the control.
To get the license string of GridEX or any other licensed control you need to do the following:

1) Create a new VB project.
2) In a procedure call the Add method in the Licenses collection without specifying the License string and print the result in the immediate window (The result of the method will be the license string you need to use for the control). i.e.

Private Sub Command1_Click()
Debug.Print Licenses.Add("GridEX20.GridEX")
End Sub
'it prints
astringwiththelicense

if the computer in which you ran this procedure has a design time license for the control the license string will be computed by VB and you will print a string like "astringwiththelicense"

Now, to add the license string in a project and be able to run it in any machine whether it has a design time license or not of the control just add the string you previously in the licensed machine with the Add method.

Licenses.Add "GridEX20.GridEX", "astringwiththelicense"
Reply


Janus GridEX gaeltacht [USA] 16-Feb-2004 01:03:48

I am using GridEX and Button Bar in a project. The problem I am having is that when I try to create the distributable file I get a message that the dependency file is out of date for the components. If I ignore the message and compile the app it will not work. Does anyone know where I can get the newer dep files for GridEX and ButtonBar.
At present I am developing on a Win XP Pro box.
Reply

RE: Janus GridEX jcastanedo [Panama] 16-Feb-2004 15:05:06

Hi,

Open the .DEP files with Notepad.exe and change its version to reflect the one that you are actually using...
Reply


Janus GridEX c.klimm [Germany] 28-Jan-2004 15:27:19

Hi, I just started with Gridex in an Access XP and SQL Server environment a few days ago and i am convinced this is the right tool for my purposes. But i got now some trouble with several Gridex events and hope there is anybody out there who can tell me how to fix this. The Access samples delivered with Gridex do not show many programming details .
So my problem: Events like gridex_beforecoledit or gridex_aftercolupdate and several others result in a compiler error - I do not post the message because I get it in German and do not know the english counterpart - It seems like the parameters are defined wrong whereas the event gridex_rowformat (rowbuffer as object) works fine with parametertype Object instead of JSRowdata like shown in the provided Sample. So what could be wrong ?

Thanks in advance
Reply

RE: Janus GridEX jcastanedo [Panama] 28-Jan-2004 16:23:53

Yes, Access do not accept typed parameters in event handlers. You must change the event procedure to use Object instead of JS_XXX type in all events you want to handle.

Also, please read the readme.htm file for important information about using the control in Access.
Reply


Janus GridEX qdnguyen2 [USA] 15-Jan-2004 01:11:32

Hi there,

I'm pretty new to Janus GridEx and I have some questions before buying the Janus Grid component.

1. Can this Janus Grid hosts ( display ) linklable control beside combobox/textbox...etc. If it can not then can we format a column in the grid ( any column) to have a blue color with underline text ( trying to mimic the linklable control ) ( and I also assum that we can align the column header and column text as left/center/right as we want ) ?

2. I heard that Janus GridEx can display some kind of parent-child relationship as well. This is what I heard. Hear is the senario:

A) I have a database query, say OrderQuery = Select * from Orders
B) and I also have another query called: OrderDetailQuery = Select * from OrderDetail Where OrderID= 2 ( where OrderID's value is from the column of the OrderQuery)

So Let say, I first load the Janus Grid to display the result from the Orders table ( execute the OrderQuery ) and OrderID is the first column.
Then, lets say, when user double-click (or click) on the cell in OrderID column and we CAN get the OrderID's value and within the double-click ( or click) event, we can execute the 2nd query ( OrderDetailQuery pass in the OrderID) and display a FLOATING GRID over the first grid with the result from the
OrderDetailQuery ?

I really need to know if the senarios above could be done using Janus GridEx.

Thanks in advance

QN
Reply


Janus GridEX marcello [Italy] 12-Jan-2004 10:43:55

I need to write a column of passwords with masked symbol.
Now I made :

Set col = jsgxMain.Columns.Add("Password", jgexText, jgexEditTextBox, "Password")
col.DataField = "Password"

If exist a "PasswordChar"?

Thanks.
Reply

RE: Janus GridEX wqw [Bulgaria] 14-Jan-2004 01:58:21

there's no specific property to mask a passwords column (!!!)

the best approach for this task would be to use a column with EditType = jgexEditCustom and to handle the InitCustomEdit, ShowCustomEdit and EndCustomEdit events.

a regular VB.TextBox control with a preset PasswordChar will do the job. (probably with border = none)

HTH,
</wqw>
Reply


Janus GridEX tremblay.ginette [Canada] 31-Dec-2003 18:39:39

Hi I use the grid for a printing report, when the grid is preview on screen, everythings is ok, my numbers are appears with all digits, but when they are print on the report, they don't ok. the columns width seam to change and numbres are cuts.
I try the option Fit on page, and i have the same probleme.

If somebody a idee, i will feel better. Because the result it's unacceptable, and i will find a other solution (or a other grid!!!).

Thank you
Reply

RE: Janus GridEX jcastanedo 31-Dec-2003 18:43:24

Hi,

Try using True Type Fonts in the Grid in order to have a closer result to what is seen in the screen.
Reply


Janus GridEX geoffb [United Kingdom] 17-Nov-2003 16:01:26

I cannot seem to find a way of deleting lines from the Grid in unbound mode.
I am bound to a variant array - have tried copying to a second (less the selected line) and copy back and rebind.

The example code does not seem to fire the deleteunbound events anyway!

Geoff
Reply


Janus GridEX - New computer jose.orozco [Sweden] 14-Aug-2003 14:41:46

I have the following problem with Janus Grid (Janus GridEX 2000).
I bought this grid for more then two year. I have now a new computer and I want to use this grid in my new computer (only).
Reply

Janus GridEX - Visual C++ Frederiek.Lefebvre [Belgium] 03-Nov-2003 16:49:39

Considering the amount of users asking for VC++ samples, wouldn't it be a good thing supplying some?

Me too, I'm having problems using the control in Visual C++; Especially the Buttonbar Control, that is...
I've overridden the C_Buttonbar class, and I use event reflection to capture the "OnItemClick" Event. This (generated) function has only one parameter: an LPDISPATCH. However, according to the help-file, there should be 2 (there's also an int supplying the id of the item).
The function gets called, no problem, but when I try to use that parameter ("attach-dispatching" it to an C_JSGroupItem), my application crashes at a non-defined point somewhere after the onclick-handler has exited, and I only have "OLEAUT32! 779dbac8()" in the call stack.
The strange thing is, that the LPDISPATCH is actually the right one: a call to GetKey() returns the right value!! But it must have to do something with that, because when I don't call AttachDispatch() on the Item-parameter, the application doesn't crash.

Can anyone help me with this problem please?
Reply


Janus GridEX cmendez [Mexico] 13-Jun-2003 17:27:53

how I can set the behavior of a DropDown gridex containing two columns, and where the first could be a field like '01, 02, 03.. etc' (item code) and the second column could be "Part 1, Part 2, Part 3.. etc" (item description). what I want to do is to type de item code, like a shortcut, and manage the properties BoundColumnIndex and ReplaceColumnIndex set to write to the database just the item description. this is a improvement in the input data process that i want to implent, I know is possible due to I have done this before but I don't know exactly how, I remember that I was able to write the item code and in the moment that I changed the current cell the item description appears in the mentioned cell and finally recorded in the database...

Could somebody help me please... I really needs this

Regards to everybody!
Reply


value property glenhong [United Kingdom] 02-Apr-2003 13:22:13

Im using the trial version of Grid Ex. I have successfully loaded up the GridEx and its perfect in every way. The only problem that I have is trying to get values from the rows selected using the 'object.value(colIndex)' syntax.

I get a 'The setting you entered isnt valid for this property' error (2101).

Is this because Im using the trial version??

Appreciate any help?

Thanks
Reply

RE: value property afa [South Africa] 19-Sep-2003 13:16:09

Hi,

Try using it like this :

Column Value = Gridname.Value(Gridname.Columns("ColumnName").Index)

Best wishes

Andy Fensham
Reply


Janus GridEX fernando.garcia [Spain] 14-Feb-2003 13:03:24

Hello, im using Janus for my aplications and i no have many ideas to do someting, actualiy i use msflexgrid control and i have more information in net, ¿where i can find samples and more thing for janus?

Thanks a lot
Reply


Janus GridEX JKeenan [USA] 28-Jan-2003 21:34:09

Love this Grid. However, I'm having a problem with using it in a dynamic ActiveX control. When I go to add the license of my control (which uses Janus Grid) into the Licenses collection, it will not return a license string. And it won't let me add it to the Controls collection. It works fine on my machine, but when I deploy it, it doesn't. HELP!!!
Reply


Janus GridEX julio.c.jaen [Panama] 24-Jan-2003 19:24:40

I have some question regardin this grid.

First, I don't see in the list, but this not support Sybase System drivers??
Also looks like is not compatible with Windows XP. Why?.

Can I made data entry in this Grid to add or update any database?? Or is just to retrieve and display data.
Reply


Janus GridEX harry [Indonesia] 25-Dec-2002 09:29:33

We really intererest with Janus Product.
Reply


RowCount c.torres [Dominican Republic] 06-Nov-2002 21:53:03

Hello,

Why is my Janus GridEX 2000 returning 110 items always when i read the RowCount or ItemCount
property??

How can i know the exact recordcount value without hitting my database with a SELECT MAX??
(i'm using an ADO connection, but the recordset object is not available when i try to read it)

Thanks a lot for any help.

Camilo
c.torres@microc.com
Reply

RE: RowCount c.torres [Dominican Republic] 07-Nov-2002 12:28:47

Hello,
I did it using the ADORecordset.RecordCount property.

Thanks a lot anyway.

Camilo
Reply

RE: RowCount fsd [Czech Republic] 07-Apr-2003 10:42:41

You should call LoadEntireRecordset method before trying to get row count.
Reply


Janus GridEX albi [Canada] 16-Oct-2002 19:03:56

It's possible to make a fixed column in GridEx? How is when I use the RowHeaders property=True, but I'd like to have the table key field values there. So all the time when I scrolling to the right this fixed column be the first column, to see the "row identification number" ... This work in case of MsFlexGrid.

Thanks in advance
Albert
Reply

RE: Janus GridEX bwagner [USA] 12-Oct-2006 20:46:37

Use the FrozenColumns property of the grid control object. This will allow you to do exactly what you want.
Reply


Janus GridEX sporter [Canada] 15-Oct-2002 16:10:50

Hi all,

I'm getting some really funky behavior from the grid and I&#8217;m wondering if anyone could point me in the proper direction.
I&#8217;m binding the grid to a recordset that I&#8217;m creating via code (eLockType = adLockBatchOptimistic and eCursorType = adOpenStatic). Everything seems to bind correctly, but as I move from row to row I get some bizarre behavior from the underlying recordset. If I scroll the grid and then select a cell outside of the original viewing area, the recordset doesn&#8217;t position itself on the newly selected row. If I don&#8217;t scroll the grid (move via the arrow keys), everything works fine. I&#8217;m using the recordset&#8217;s AbsolutePosition property to check it&#8217;s current position and when I scroll the grid and click on a row, the absolute position always responds that I&#8217;m currently at the row that is just above the viewable area of the grid. I&#8217;ve McGyvered something together for now, but I&#8217;d really like this problem solved.

Ta.
Steve Porter
Reply

RE: Janus GridEX mh_p2006 [Turkey] 09-Feb-2011 04:53:20

How to get selected rows from a gridex?
Reply


Janus GridEX rsm [United Kingdom] 06-Sep-2002 09:21:37

Dates and GridEX

Heres a brief description of the time data entry issue we have regarding the GridEX control.

If a date is entered into a date field in GridEX in the format of aa/bb/cc or similar, GridEX seems to be defaulting to mm/dd/yy format unless the date entered is unambiguous (day of month is over 12). Therefore dates for the beginning of the month are interpreted as mm/dd/yy when the date entered is in the format dd/mm/yy.

The date format on the server does not seem to make a difference to this issue, so how do we alter GridEX to only interpret dates as dd/mm/yy?

We run it web based!

Robert
Reply


Janus GridEX rsm [United Kingdom] 06-Sep-2002 09:18:52

We have the gridex system installed as a web based application, however we are unable to get the gridex when opening a page to populate. We have to have the users click an update button on the page before the gridex will populate.

The page uses the code below to load the gridex and set the recordset etc. The gridex only populates when the button that calls the update is clicked on 90% of machines.

Does anyone know why or how to solve this problem, or how to do the same as the update button on loading so as to populate the gridex.

thanks

Robert

SUB Window_OnLoad
Dim sSQL
<%
Response.write("sSQL = ""SELECT * from Auctions order by AucID DESC;""")
%>
LoadLayout
ADC.SQL = sSQL
ADC.Refresh
Set GridEX1.ADORecordset = ADC.Recordset
END SUB

SUB LoadLayout
<%
Response.Write("URLuse = ""allsopDatabase/layouts/auctions.lyt""")
%>
GridEX1.LoadLayoutFromURL URLuse, False

END SUB

SUB updateADO
GridEX1.Update
ADC.SubmitChanges
ADC.Refresh
Set GridEX1.ADORecordset = ADC.Recordset
LoadLayout()
END SUB
Reply


Janus GridEX rsm [United Kingdom] 06-Sep-2002 09:14:28

We have the gridex system installed as a web based application, however we are unable to get the gridex when opening a page to populate. We have to have the users click an update button on the page before the gridex will populate.

The page uses the following codes

SUB Window_OnLoad
Dim sSQL
<%
Response.write("sSQL = ""SELECT * from Auctions order by AucID DESC;""")
%>
LoadLayout
ADC.SQL = sSQL
ADC.Refresh
Set GridEX1.ADORecordset = ADC.Recordset

END SUB
Reply


Janus GridEX wagova [Dominican Republic] 31-Jul-2002 20:30:02

Estoy probando la version DEMO del GridEX, conectandome por medio a ADO. Al usar dos tablas como origen de datos me presenta un error al momento de añadir nuevos datos. Consulte a una persona de soporte de JANUSYS y me hablaron de la propiedad "Unique Table", la usé y el problema persiste.

Como puedo usar el GridEX usando varias tablas como origen de datos ? ? ? ?

Anexo los codigos que uso:

StrSql = "SELECT com.Estatus as Exc," & _
"com.codigo_Intermediario as Intermediario," & _
"com.Codigo_Empresa as Empresa, Emp.Nombre, " & _
"emp.Dia_Facturacion,com.Comision, com.fecha_ingreso " & _
"FROM EMPRESAS_COMISIONES as com " & _
"LEFT JOIN EMPRESAS as Emp " & _
"ON com.codigo_empresa = emp.codigo_empresa " & _
"where com.Codigo_Intermediario = " & fQuo(txtIntermediario.Text)

GridComision.RecordSource = StrSql
GridComision.HoldFields
GridComision.Rebind
Dim RS As New ADOR.Recordset
Set RS = GridComision.ADORecordset
RS.Properties("Unique Table") = "EMPRESAS_COMISIONES"
GridComision.Refresh


NO PUEDO INSERTAR, PUES AL HACERLO EL CONTROL GridEX TRATA DE INSERTAR EN AMBAS TABLAS QUE USO.
Reply


Janus GridEX paparesta.s [Italy] 31-Jul-2002 08:32:37

Mi piacerebbe acquistare Janus Grid .NET e non dovermi affidare ad un altro produttore di componenti, quantomeno mi piacerebbe provare la beta o una pre release, a quando dei tempi certi di rilascio. Avrei una certa urgenza di poter vedere del materiale. Saluti
Reply


Janus GridEX metric [Croatia] 24-Jul-2002 19:28:11

I tested .NET beta version and I have to say that it works fine and technical support was exelent. I olready designed two complex application for .NET with .NET Gridex. When is time for lunch relace?
Reply


Janus GridEX bryce0 [Israel] 23-Jul-2002 09:07:11

Hi
One of the fields that I retrieve from an Oracle database is a concatenated string field delimited by a carriage return+ new line ASCII (CHR (10) || CHR (13)).
Exp:'first' || CHR (10) || CHR (13) || 'second'.......
The corresponding column in the gridEx replaces the two ASCII characters with two squares and then continues the suppose to be a second line in the first line as well.
Isn't there a way to simulate a crlf in the gridEx column?
Reply


Janus GridEX paparesta.s [Italy] 22-Jun-2002 10:59:29

.NET version? April ???? :-(
Regards
Reply

RE: Janus GridEX support@componentsource.com 25-Jun-2002 16:49:13

Janus GridEX .NET will be here very soon. I do not have an exact date, but it should be very soon.

Jason Williamson
ComponentSource
Technical Support
Reply

RE: Janus GridEX layne_h [USA] 05-Jul-2002 21:35:57

Jose Castanedo of Janus Systems replied to me this June that 7/15 was a target date contigent (of course) on quality testing.

A public beta is available. I think the grid will meet the high expectations.
Reply


Janus GridEX fsd [Czech Republic] 05-Jun-2002 09:12:09

Hello, we are using Janus GridEx (great one component) and need to add one unbound column whe we are in bound mode. Is that possible? We connect an ADO recordset to the GridEx in bound mode and then add a new column (edittype=checkbox). That is possible and easy to do. But when the checkbox in the added column is checked at any row all other rows are make unchecked in that column. Only one row can have that checkbox checked at the moment. How to prevent it? We need that for making the rows checked for further operations.
Any suggestions are welcome.
Reply

RE: Janus GridEX support@componentsource.com 05-Jun-2002 18:49:02

Hello,

I contacted the author of GridEX 2000 about your question. They tell me the GridEX control can not maintain values in columns that are not bound to a field in the recordset. To have an unbound column you must use the FetchData event to pass the value of each cell when it is loaded by the control.

Best regards,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX in MS Visual C++ 6.0 jet [Russia] 03-Jun-2002 17:17:35

Hailz!
Could someone help me.... trying to call the Rebind method but failed in all ways
I know i'm doing something wrong but dunno what :(( If you please please show
Compiler said that there must be an argument : (VARIANT*)...
My brain is near the critical :) Somebody help!!!
Reply


Janus GridEX KO 02-Jun-2002 17:37:47

How to display / edit text in multi-language within a same Janus GridEX.
In my case, I need to display english, chinese & japanese at the same time.
Please help!!
Reply

RE: Janus GridEX support@componentsource.com 04-Jun-2002 13:58:33

Hello,

Thank you for your post. Janus GridEX 2000 is unable to displaytext from different character sets in one instance of the control. It just isn't possible to do.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply

RE: Janus GridEX cwko [Hong Kong] 04-Jun-2002 18:29:12

Any suggection which can support multi-language.
Reply


Janus GridEX cmesyngi [USA] 23-May-2002 17:29:27

Does anybody know how to use the FetchData event in VC++ to update a calculated column that is not bound to any field of the database table?
The problem I'm facing is on the last parameter (Value) of the function call for the event:
OnFetchDataGridex(long RowIndex, short ColIndex, const VARIANT FAR& RowBookmark, LPDISPATCH Value)
The Type is LPDISPATCH but if you look in the documentation, it should be a JSRetVariant.
The problem is that the wrapper classes generated by VC do not contain the JSRetVariant class.
Are there any workarounds for this problem?
Thanks,
Claudio
Reply

RE: Janus GridEX support@componentsource.com 23-May-2002 20:13:39

Hello Claudio,

I believe Janus Systems only offers examples and tech support for GridEX in Visual Basic. So, unfortunately, I don't believe they will be able to answer your question. If anyone else has used GridEX 2000 in VC++, can you shed some light on what this customer is experiencing?

Best regards,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX npvw [South Africa] 15-May-2002 07:00:09

After a the refetch method has been issued the grid looses all its valuelists and dropdown combo and gridimages assignments. The columns with valuelists and dropdowncombo's default to the index or value of the associated valuelist/dropdowncombo. The columns with gridimages disappear.
Reason for using refetch:
After setting grid.ColumnAutoResize = true, the columns all fit in the visible area of the grid. Issuing grid.ColumnAutoResize = false does not restore the columns to their previous state, however when issuing the refetch command the columns does resize to their previous state BUT all valuelist/dropdowncombo/gridimages are lost.

Work Around for getting the columns to resize to widest entry
dim jscol as GridEX20.JSColumn
for each jscol in grid
jscol.AutoSize
next

Is this a known issue? Should refetch be used in this fasion?

PS
the grid is excellent and we all love it (even convinced management to buy a site lisence)

Thanks
Nicolaas van Wyk
South Africa
Reply

RE: Janus GridEX support@componentsource.com 17-May-2002 16:11:54

Hello Nicolaas,

I contacted Janus about your questions. Here is their response:

When using Refetch method, the control will create a new column
structure by default. To keep the column layout you are using in a
Refetch method use the HoldFields method before calling Refetch. E.g.

GridEX1.HoldFields
GridEX1.Refetch

As for the ColumnAutoResize property, Yes, once you set this
property, the control won't maintain the previous, you can either set
the width of each column after setting ColumnAutoResize to False or, as
you are doing it now call the AutoSize method in each column.

Please let me know if you have any further questions about this at all.

Best regards,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX npvw [South Africa] 15-May-2002 06:56:21

After a the refetch method has been issued the grid looses all its valuelists and dropdown combo and gridimages assignments. The columns with valuelists and dropdowncombo's default to the index or value of the associated valuelist/dropdowncombo. The columns with gridimages disappear
Reason for using refetch:
After setting grid.ColumnAutoResize = true, the columns all fit in the visible area of the grid. Issuing grid.ColumnAutoResize = false does not restore the columns to their previous state, however when issuing the refetch command the columns does resize to their previous state BUT all valuelist/dropdowncombo/gridimages are lost

Work Around for getting the columns to resize to widest entry
dim jscol as GridEX20.JSColumn

Is this a known issue?
Reply


Janus GridEX Printing andy.fox [United Kingdom] 14-May-2002 10:44:48

Hi

I am have a grid in which the cell format styles have background pictures. These pictures are displayed fine on screen and in print preview, but do not appear on the printer (either a mono printer or a colour printer)

Do you have any ideas.
Regards, Andy
Reply


Janus GridEX david [Canada] 04-Apr-2002 20:43:23

how do you get the PrintPreview to work from VC++?

IDispatch * disp = gridPreview.GetIDispatch(FALSE);
grid->PrintPreview(&disp, &sel);

gives a exception that object does not support this operation?

please, thanks!
Reply

RE: Janus GridEX support@componentsource.com 05-Apr-2002 19:36:58

Hi David,

I contacted Janus Systems with this question, and they, too, are unsure how to get PrintPreview to work in VC++. Their response is as follows:

Unfortunately, we don't have samples in VC++, nor we provide
tech support for VC++, we have tried to use the Preview Control under
VC++ but we haven't been able to find a solution for this.

Please let me know if you have any questions about this. Also, if anyone out there has successfully implemented this, please post how you did it :)

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX cwc2000 [USA] 01-Apr-2002 10:40:01

Does Janus GridEX support Oracle database where records are stored in UNICODE?
Reply

RE: Janus GridEX support@componentsource.com 02-Apr-2002 18:08:14

Hello,

The GridEX control supports Oracle databases. but the control does
not have Unicode support. Please let me know if you have any further questions about this.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX & foxpro david [Canada] 20-Mar-2002 15:54:21

Hi all we use this grid with foxpro...

but when foxpro loads it's data (if it is one character and field length 50) loads 49 spaces after the data!?

is there a event i can handle like on_load_data to trim those spaces off?

because it causes lots of problems with valuelist and strikeout rows etc...

before i bought janus grid i got lots of questions answered by support@janus.com but after i bought the product they have not answered anything. anyone have any contact with them lately? do you have to be a non-registered user for them to support you?

thanks.
Reply

RE: Janus GridEX & foxpro support@componentsource.com 02-Apr-2002 18:05:39

Hello David,

I contacted Janus Support and they replied with the following:

when foxpro loads it's data (if it is one character and field length
50) loads 49 spaces after the data!?

is there a event i can handle like on_load_data to trim those spaces
off?

because it causes lots of problems with valuelist and strikeout rows
etc...

To trim spaces of FoxPro databases you must use the control in
unbound mode passing the trimmed data in the UnboundReadData event to
the control. Unfortunately, there is no way to trim the data in a bound
GridEX control.

before i bought janus grid i got lots of questions answered by
support@janus.com but after i bought the product they have not answered
anything. anyone have any contact with them lately? do you have to be a
non-registered user for them to support you?


We provide technical support for both registered and trial
users. I believe that we haven't got your mails because you may be using
a wrong email address. Please submit your question to
support@janusys.com. Also please send a second email for replying to
your questions in case there were a problem with your email.

Please have a look at their reply, and let me know if you have any further questions.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply


Cut & Paste Andreas Cziferszky [Austria] 15-Mar-2002 01:28:43

I found out that the GridEX support cut&paste with the shortcutx ctrl-shift-x. ctrl-shift-c and ctrl-shift-v. why doesn't it support the normal shortcuts without <shift> and is there a workaround so it will react when pressing the windows standard shortcuts without <shift>?
Thanks in advance
Andreas
Reply

RE: Cut & Paste support@componentsource.com 26-Mar-2002 15:38:24

Hello Andreas,

I spoke with Janus Support, and they tell me the following:

GridEX control does support Ctrl+C and Ctrl+X shortcuts but these shortcuts are supported only when the Edit window is visible. If the active cell is not in edit mode the control won’t handle these shortcuts. To enter into edit mode, press F2 or any key to start editing.

Please let me know if you need any further help with this.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX kris [Belgium] 12-Mar-2002 12:50:19

Does anyone know when there will be a .NET version?

Thanks in advance
Reply

RE: Janus GridEX support@componentsource.com 18-Mar-2002 20:19:23

Hello Kris,

I am not sure of the availability date for GridEX .NET, but I do know Janus is working on it. The .NET version should be available soon.

Cheers,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX - Visual C++ dwatkins [United Kingdom] 05-Mar-2002 19:18:49

If anyone has a code snippet in VC++ for launching the PrintPreview, I would be very grateful.

Many thanks in advance.

Danny Watkins
dwatkins@cernica.com
Reply


Janus GridEX Joost.derore [Belgium] 19-Feb-2002 09:10:24

I have the following problem after using the Janus Grid (Janus GridEX V1.5e) for more then tree year. I have a new computer and the OS is now 2000 in stead of my previous NT.
When I want to reinstall the component the following error-message appears :
'you cannot install this VB5 installation without the latest service pack....'
I use VB 6 and this problem did not occur on my previous computer. The programm where I used the component did not change for a couple of years, so I hope it is not necessary to redistribute a new version of this component to all users.

Thanks in advance for the help.
Reply


Janus GridEX Rafi Utudjian [United Kingdom] 12-Feb-2002 13:16:09

I have a few problems with the GridEx Control and was hoping for some help.

1) When using the GridEx control as a dropdown on a secondary monitor the view when droped is displayed on the primary monitor. Are there any fixes available for this?

2) I would like to know how much decrease in preformace should there be between the GridEx Control being Bound against being Unbound using the same database connection.
Reply

RE: Janus GridEX support@componentsource.com 14-Feb-2002 14:25:01

Hello Rafi,

I checked with Janus Support, and they told me the following:

1) When using the GridEx control as a dropdown on a secondary monitor the view when dropped is displayed on the primary monitor. Are there any fixes available for this?

We have seen this behavior in the control but we have also seen this while using other combos in even those used by Microsoft in their apps, so according to our findings this seems a limitation in the way the OS handles windows when used with dual monitors...

2) I would like to know how much decrease in performance should there be between the GridEx Control being Bound against being Unbound using the same database connection.

GridEX has a better performance while used in ADO DataMode than in Unbound mode.

Please have a look at their answers above. If you have any further questions about this, let me know.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply

RE: Janus GridEX rafiutudjian [United Kingdom] 15-Feb-2002 05:30:10

Since Windows98SE Microsoft has had full support for displaying all types of windows on multiple monitors. I don't think the reason for the dropdown reverting back to the primary monitor is entirely due to the OS. This problem is likely to be caused by the GridEx itself wanting the dropdown GridEx to always be visible. This causes a problem when on the secondary monitor as it does not realise that the dropdown is still visible, therefore pushing it back onto the primary monitor. If so is there any chance of a fix in the near future?
The problem may also stem from windows not returning the correct desktop size, but I haven’t looked into this.
Reply


Janus GridEX sandra.gadsby [United Kingdom] 12-Feb-2002 09:57:38

I want the Return key to navigate through columns instead of going to the next row. Is this possible and if so how?.
Reply

RE: Janus GridEX rafiutudjian [United Kingdom] 23-Feb-2002 10:50:32

GridEx doesn't seem to have this functionality. This might do the trick but has a slight fliker as the selected cell changes.

------------------------------
Private bEnterPressed As Boolean
------------------------------
Private Sub Form_Load()
bEnterPressed = False
End Sub
------------------------------
Private Sub GridEX1_KeyDown(KeyCode As Integer, Shift As Integer)
bEnterPressed = IIf(KeyCode = 13, True, False)
End Sub
------------------------------
Private Sub GridEX1_RowColChange(ByVal LastRow As Long, ByVal LastCol As Integer)
If bEnterPressed Then
bEnterPressed = False
With GridEX1
If LastCol < .Columns.Count Then
.Col = LastCol + 1
.Row = LastRow
Else
.Col = 1
End If
End With
End If
End Sub
------------------------------
Reply


CPU performance takenori [Japan] 03-Feb-2002 18:35:53

When using grouping or sorting at runtime,
is there any difference between Celeron and Pentium3 ?
Reply

RE: CPU performance support@componentsource.com 08-Feb-2002 22:05:45

Hi Takenori,

The hardware that makes up the client computer will always affect the performance of your application. Because of this, I would think that depending on the size of the grouping or sorting routine you run, you will see performance differences between a Pentium 3 or Celeron. If you have any questions about this, please let me know.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX ampon [Thailand] 28-Jan-2002 09:25:42

I use delphi 4.0 (Client Server) now.
Can I use this component by using Import ActiveX Control ?
Anyone know ,please help to answer.
Thanks.
Reply

RE: Janus GridEX support@componentsource.com 30-Jan-2002 20:43:50

Hello,

Thank you for posting your question in our forum. I believe you can probably import the GridEX control into Delphi 4. However, I doubt you would be able to get support for GridEX's use in that environment. Please let me know if you have any further questions about this at all.

Sincerely,

Jason Williamson
ComponentSource
Technical Support
Reply


Janus GridEX takenori [Japan] 20-Jan-2002 17:00:05

I'm enjoing the great performance!
I'm very glad to meet like this product.

There's one thing I want to know.
Can GridEX display in Japanese at design time?
Of course this is not a problem only for GridEX.

For example 'Localization' part.
People in none western area like me would be a professor of this hieroglyphs.

Does anyone know the answer?
Reply

RE: Janus GridEX support@componentsource.com 23-Jan-2002 20:01:09

Hello Takenori,

I asked Janus Support about this, and they say it is possible to display characters in Japanese in GridEx. However, you need to chose a font capable of displaying those characters. This font property should be changed using the VB property window and not in the GridEX designer. Please let me know if you need anything else.

Sincerely,

Jason Williamson
ComponentSource Support
Reply

RE: RE: Janus GridEX rprasad [USA] 09-Jan-2008 19:47:53

How can I display the Japanese data in the GridEX2000 control?
Reply


Janus GridEX António [Portugal] 18-Jan-2002 11:36:27

I have a few questions regarding this grid:
1) About licensing: If we buy one developer license, does it mean that only one machine can have the component installed? Is there a way to, even temporarily, to move or copy the component to another machine without violating licensing rules?

2) Displaying images: On our databases we usually do not keep the product picture on the products table, but only its path on a text field (say, "C:\Images\xxx.jpg"). Is there a way to have the grid display the images of all grid listed products on a given column of the grid so that the user can see some kind of thumbnail right away? We could use this kind of functionality.

3) Is it possible to integrate this grid with Data Environment Objects (such as a command object). I don't seem to find properties such as DataSource or DataMember. If it is not currently possible, I think you should give it a thought.

Thanks in advance for your help.

Kindest Regards

António Pinho
Reply


Janus GridEX alb [Denmark] 15-Jan-2002 12:38:28

I have been searching for a good DB grid component, and it seems that GridEX 2000 is the best around.

But I am really missing one thing, that all othjer grids I have tried have been able to :

I have developed my own component to retrieve ADO recordsets from calling a stored procedure, and I use to do the following :

set RS = myconponent.callStoredProcedure(param1, param2)

GridEX1.datasource = RS

But I can't seem to find this type of function i GridEX ...

Can this really be true that you cant throw your own created recordset into the grid without having to make connectionstrings and so on


Otherwise it looks great :o)
Reply

RE: Janus GridEX support@componentsource.com 16-Jan-2002 21:32:55

Hi,

I checked with Janus Systems regarding this, and they gave me the following information to pass on to you:

When you already have a recordset, you could use the ADORecordset property of the control in order to bind the control to it. i.e.

set RS = myconponent.callStoredProcedure(param1, param2)
Set GridEX1.ADORecordset = rs

‘don’t call Rebind after setting the ADORecordset to avoid the
creation of another recordset based on GridEX settings
Note: the recordset you assign to the ADORecordset property must support bookmarks.

If you have any further questions about this at all, please let me know.

Sincerely,

Jason Williamson
ComponentSource Support
Reply


Janus GridEX t.goossens [Belgium] 07-Jan-2002 16:36:43

Hi,

I'm using theGridEx which is a very powerful and satisfying tool. But I have the folowing problem.
When I use this code some strange things happen.
When a record is not 'Payed' (paid) and the 'DateDue' has expanded, the row should get formatted as a 'Overdue'-formatstyle. (Red background...& other stuff...)

But when I scroll the grid, sometimes the field 'Payed' changes randomly into 'True' or 'False' and the formatstyle also changes randomly, ignoring the query.

What's wrong?
-----------------------------------------------------------------------------------------------------------------
Private Sub grdSalesHead_FetchData(ByVal RowIndex As Long, ByVal ColIndex As Integer, ByVal RowBookmark As Variant, ByVal Value As GridEX20.JSRetVariant)
Dim rsRowData As Recordset
Dim rsJSRowData As JSRowData

Set rsRowData = grdSalesHead.ADORecordset
rsRowData.Bookmark = RowBookmark

' On Error Resume Next
If CDate(rsRowData![DateDue]) < CDate(Date) And rsRowData![Payed] = False Then
Set rsJSRowData = grdSalesHead.GetRowData(RowBookmark)
rsJSRowData.RowStyle = "OverDue"
Else
Set rsJSRowData = grdSalesHead.GetRowData(RowBookmark)
rsJSRowData.RowStyle = "Default"
End If
Value = rsRowData![Payed]

End Sub
------------------------------------------------------------------------------------------------------------------

Kind regards,
Tim
Reply

RE: Janus GridEX support@componentsource.com 14-Jan-2002 19:05:47

Hi Tim,

I contacted Janus about your question, and they gave me the following information to give to you:

You are setting the value correctly in the FetchData event. However, this event should not be used to set a formatstyle to the row. I you want to apply a FormatStyle to a row use the RowFormat event. In this event you get the row being formatted as parameter and you can use that row to get values of it and to apply the FormatStyle depending on the value.

Take a look at their suggestions above. If you have any further questions, please let me know.

Sincerely,

Jason Williamson
ComponentSource Support
Reply


Janus GridEX - GPF Thomas Linde 23-Dec-2001 17:27:20

We still have problems with the GPF when ending a application with the END statement. Everything we've tried including what you suggest in the readme file dosn't work, the GPF appears anyway.

Is this a Bug in Gridex or VB? We're running VB 6.0 SP5 on WinXP and W2k.

Any more suggestions?

//Thomas
Reply

RE: Janus GridEX - GPF support@componentsource.com 27-Dec-2001 17:21:55

Hi Thomas,

I asked Janus Systems about this error, and they told me the following:

This is not really a bug in the control, You should never use the
End statement since there are a lot of risks involved in using End in VB
programs: your databases might not be correctly closed, your objects are
not correctly terminated, etc. You should always terminate a program by
unloading all the forms. For more information about this you could read:

http://www.vb2themax.com/Item.asp?PageID=TipBank&ID=273

The link above explains an alternative to the End Statement, and why End
shouldn't be used. Have a look at this information. If you have any other
questions arise, please let me know.

Jason Williamson
ComponentSource Support
support@componentsource.com
Reply

RE: Janus GridEX - GPF Marc Greiner [Switzerland] 11-Jan-2002 08:12:07

Saying that a VB 'End' Statement does not release all system memory properly is pure superstition: The VB 'End' statement does function properly.
There are cases where there is no other option than to use thenVB 'End' statement. It is of course not a normal case.
The GPF that you mentionned is definitively a bug from the Janus Grid and should be corrected. The mentioned link explaining why not use the VB 'End' statement should not protect Janus from correcting this bug.
Reply

RE: Janus GridEX - GPF support@componentsource.com 14-Jan-2002 19:09:06

Hi Marc,

I contacted Janus regarding your post, and they provided me with the following information:

When the End Statement is called from the Unload or QueryUnload events of a form, the controls in such form are not properly terminated (The Terminate event is not fired for those controls). I don’t know the reason why this happens, but in the case of GridEX control, the control needs this event to restore the subclassed windows in it properly.

If you are calling the End statement in the Unload event of a Form with a GridEX control, try setting the Cancel parameter to True before calling the End Statement. This is described in the Readme.htm file installed with the control and will fix the GPF problem you have.


Please let me know if you require any further information about this.

Sincerely,

Jason Williamson
ComponentSource Support
Reply


Janus GridEX Antonio [Portugal] 21-Dec-2001 17:42:57

I've been using the trial version of Janus GridEX and I find it really good. I'm thinking of buying it due to all its functionality.
There's one thing I would like to helped on: I would like to know how can I access the group header caption and value from code as well as the group footer's totals. I examined NWind sample and I saw on the orders grid something like "Order Date ..-..-.... (x orders) (y unpaid)". On the other hand, how can I show totals on the group header (with or without conditions) so that I don't need to expand the group. This would be very helpful for my customers.

Another question is: is ther a way to expand or collapse only one group by code?

Thanks for your help and Merry Christmas.
Reply

RE: Janus GridEX support@componentsource.com 28-Dec-2001 19:07:41

Hello Antonio,

I contacted Janus Systems and asked them your question. They have replied with some code that should show you how to do this:

To add a total in the group header row you should change the GroupCaption property in the RowFormat event when the row is being loaded. For instance, if you want to show the sum of values in column 5 do:

Private Sub GridEX1_RowFormat(RowBuffer As GridEX20.JSRowData)

If RowBuffer.RowType = jgexRowTypeGroupHeader Then
RowBuffer.GroupCaption = RowBuffer.GroupCaption & “ (“ & RowBuffer.GetSubTotal(5, jgexSum) & “)”

End If

End Sub


Please let me know if you have any further questions about this at all.

Best regards,

Jason Williamson
ComponentSource Support
support@componentsource.com
Reply


Problem with FmtConditions nick.hobbs [United Kingdom] 19-Dec-2001 17:54:12

Hello

I am using your Janus GridEx control and have a problem with the conditional formatting feature with the FmtConditions collection. Please see the code below which adds 3 JSFmtCondition items to the FmtConditions collection, and the result appears to only apply the first condition that matches, and not apply all the format styles if all conditions match for a record.

It should apply a bold font to all rows where the 7th and 8th columns have a True value, and also apply a pale yellow background to all rows where the 2nd column matches "Received".

If I apply just one of the conditions then that condition works well, but all together, and only the first matching condition is applied and appears to ignore any other conditions. My conditional formatting is complimentary of each other so need it to apply bold and a yellow background if all the conditions are met.

Please can you help?

Best regards,

Nick Hobbs
Pierbridge

Dim fmtCon As JSFmtCondition

' Embolden the unassigned items
Set fmtCon = GridEX1.FmtConditions.Add(7, jgexEqual, True)
fmtCon.FormatStyle.FontBold = True

' Embolden the unread items
Set fmtCon = GridEX1.FmtConditions.Add(8, jgexEqual, True)
fmtCon.FormatStyle.FontBold = True


' Colour the Received items
Set fmtCon = GridEX1.FmtConditions.Add(2, jgexEqual, "Received")
fmtCon.FormatStyle.BackColor = vbInfoBackground
Reply

RE: Problem with FmtConditions [Janus Systems Support] 21-Dec-2001 15:53:37

Such behavior is by design. FmtConditions are not merged in a row. Only the first condition, is applied to a row.
Reply

RE: Problem with FmtConditions timtom_uk [United Kingdom] 10-May-2002 12:55:46

Hi Nick,

I had the same problem as you when using the format conditions. I found that you can roll your own solution by using the RowFormat event. You can reference the current row by using the rowbuffer object that is passed to the event by the control. I'll not go into too much details as you can see how to use it in the example below. If you are unclear, try searching for RowFormat in the GridEx help file.

Hope this helps my friend :o)

Tim Neale



Private Sub grdTasks_RowFormat(RowBuffer As Object)

Dim bCompleted As Boolean
Dim dDate As Date
Dim dTime As Date
Dim dLate As Date
Dim sError As String
Dim lDiff As Long

m_GridId = RowBuffer.Value(1)
bCompleted = RowBuffer.Value(3)
dDate = RowBuffer.Value(4)
dTime = RowBuffer.Value(5)

lDiff = DateDiff("n", m_Date, (dDate + dTime))

If bCompleted <> 0 Then
RowBuffer.RowStyle = "Done"
Else
Select Case lDiff
Case Is < 1
RowBuffer.IconIndex(2) = 6
Case 1 To 238
Dim t As Integer
t = Int((lDiff - 1) / 60) + 2
RowBuffer.IconIndex(2) = t
Case Else
If dDate = Date Then
RowBuffer.IconIndex(2) = 1
Else
RowBuffer.IconIndex(2) = 0
End If
End Select
End If

End Sub
Reply


Janus GridEX bruynr [The Netherlands] 19-Dec-2001 07:08:03

Does the grid support datashaping (hierarchical data) using ADO?
I can't find anything in the helpfile ...

Roel
Reply

RE: Janus GridEX [Janus Systems Support] 21-Dec-2001 15:55:53

Hierarchical recordsets cannot de displayed in the same grid. You would need to use two grids for that.
Reply


Janus GridEX Sean [Canada] 18-Dec-2001 20:08:45

I too have purchased this Grid and have sent an email to Janus with no response as to .net
Does anyone know if they are developping for .net
Reply

RE: Janus GridEX Sean [Canada] 19-Dec-2001 23:39:51

I may have been sending my request to the wrong address...

For those of you wondering, I contacted the company about their .net strategies coming. They responded almost immediately!.

For those interested, their response was...

"We are working on the .NET version and a public beta is planned to be released in February. we are targeting April for the final release. Janus DataEdit Controls (A set of controls including multicolumn combo, masked edit and dropdown calendar) will be free with GridEX for NET"

Great Product. Great Support.
Reply


Janus GridEX VincentOhare [United Kingdom] 12-Dec-2001 10:25:56

I am just beginning a .Net development program and am on the lookout for suitable components.

Does anyone know if there is a .Net beta version of the Janus Grid available?
Reply

RE: Janus GridEX Sean [Canada] 18-Dec-2001 20:11:37

Vincent,
I too am waiting to hear of a .net beta version. Just bought this grid and hope that I do not have to switch to something else.
I will let you know if I find anything.
Please let me know if you do also.

Regards,
Sean
Reply


Janus GridEX2000 prodomus2 [Romania] 02-Dec-2001 10:11:38

Dear Sirs,

I cannot use DAO. I also have installed v1.6, who works perfect.
What's wrong?

Thanks in advance.
Reply


Janus GridEX t.goossens [Belgium] 19-Nov-2001 11:03:16

I seem to have problems with the find function. I use the grid with an ado connection on a SQL server. The property automaticSort is set to TRUE. When I use the 'find' function in code and the column is ASC-sorted I encountered no problems, but when I use the same code when the column is DESC-sorted the function 'find' returns a true on finding the item but does not position to the right row.

If you need more information on the settings of the grid I can send you the layout file.

Thx in advance...
TIM
Reply


Janus GridEX t.goossens [Belgium] 12-Nov-2001 17:19:31

The Find-property returns a boolean, but doesn't point to a record afterwards,
so how am I able to locate a record in a table of three zillion records?

Help me please, or is this a major minus?
Reply

RE: Janus GridEX jeccles [United Kingdom] 13-Nov-2001 15:34:38

The documentation states for the Find method that it:

Sets the current row in a GridEX control to the one that matches the specified criteria.

You should then be able to use the EnsureVisible method to have the grid move to that row.

I've used this in a couple of projects and it works fine. EnsureVisible should move to the selected row by default (no parameters), but you can always specify gridex1.row if you like.
Reply


Janus GridEX martin.hossfeld [Germany] 23-Sep-2001 11:50:59

The grid looks great. I am only missing one feature: Column merging, i.e if a column in consecutive rows has the same value, I want it only displayed once. Is this supported by janusgrid or am I missing something?
Reply


Janus GridEX in Unbound Mode kwhitten [USA] 10-Sep-2001 22:58:46

Has anyone had any problems with using the grid in unbound mode, and not getting the group value to show when using groups? For some reason, no matter what I do, the group caption always shows "(none)". It works fine in other unbound projects, including the sample, but not in my project. I have checked my code with that of the samples, and it seems to be exactly the same.
Reply


Janus GridEX with C++ lhj [Denmark] 10-Sep-2001 10:12:21

Anyone out there using Janus GridEX 2000 together with C++ ?

Does anyone have some good programming tips for using GridEX 2000a with Visual C++ ?

In the help file accompanying the product all samples are written in VB. When using C++, all the passing of arguments needs to be done using helper classes wrapping all the VARIANT stuff. But all these conversions make things quite tedious at times.

To begin with I fell for the grid's data bound abilities, but I actually needed to work only with temporary data, so that pressing the Cancel button would just leave all 'real' data untouched. Then I had to turn to the unbound-mode. Here, I have troubles in keeping the 'logical' data the same as the displayed data (in the grid's cells). Do you have any good programming hints (like 'use this and that function in this case...') ??

Thanks,
Lars Jacobsen.
Reply

RE: Janus GridEX with C trr [Germany] 22-Dec-2001 17:54:36

i'm looking for good C++ samples too! i like to use the janus button bar in the frameWindows of an MDI Application. if u find some, please let me know!

Regards
Reply


Janus GridEX answer [Greece] 07-Sep-2001 11:52:48

Hi,

Is there some one who use Gridex with Fujitsu PowerCobol or any other than Visual Basic environment ?

Thank you
Dimitris Kostoulas
Reply


Janus GridEX HELP donovan.l.foster [USA] 22-Aug-2001 21:52:36

This is an excellent grid in data bound mode.
I cannot get this grid to work in UnBound Mode in an ASP Application. I converted your example for VB into ASP/VBScript.
I have set the "DataMode" in the controls properties but it does not seem to see it when trying to set the "GridEX1.ItemCount = mRowCount". I keep getting an error that states: "Cannot set item property in bound mode".
I am setting the "DataMode" in the controls declaration in HTML i.e. DataMode="99".
I am very impressed with this product, but this issue has consumed my time for the past 24 hours with no results.
Can you help? How can I fix this. The control I am using is only demo version. Will this go away in the Registered Version?
Reply


Janus GridEX paul [USA] 14-Aug-2001 21:32:27

We have been running the Janus GridEx 2000 control for some time very successfully. We are testing our product on Windows XP (Whistler Beta Build 2462) and cannot get the control to register. All other controls register fine. The error we get is C:\test\gridex20.ocx (3.4) 8/14/01 9:29:59am dispatcher initialization error 13. Anyone have any luck with XP?
Reply

RE: Janus GridEX [Janus Systems Support] 15-Aug-2001 14:47:38

Such problem is fixed in the 2000b patch that is available for download at our web site.
(The list of other bugs fixed in such patch is in the readme file inside the zip).
Reply


Janus GridEX Urgent help needed please rsm [United Kingdom] 11-Aug-2001 08:17:51

I have inherited a gridEX project and have hit a couple of problems I wondered if anyone could help me with.
It is an asp project running from iis4 using an sql 6.5 database.

1: How do you distribute the gridEX activex component to clients accessing the web site so they can view the gridex.
2: I have loaded the development software onto a test client and have got the following error.

Error on script in page
Line:33
Char:5
Error The specified handler has denied access
Code:0
url http://192.168.10.18/allsopdatabase/auction.asp

line 33 is a loadlayoutfromurl call.

I have checked that the client machine has a correct version of MDAC running and it has version 2.1.3711.11(GA) on.
If anyone has any ideas please let me know.

Robert
Reply

RE: Janus GridEX Urgent help needed please [Janus Systems Support] 14-Aug-2001 20:58:06

1) Check at the "Deploying Info.txt" file for important information about using the GridEX control embedded in web pages.
Such file can be found under the directory: "C:\Program Files\Janus Systems Components\Janus GridEX 2000\OCXs Files\Cabs"

2) A Description to the error you have can be found in the MS Knowledge Base Article ID: Q243245 "PRB: RDS Handler Error Messages Due to Security Settings"
Reply


Janus GridEX tony [United Kingdom] 07-Aug-2001 19:43:31

I'm looking for a grid component and the reviews of Janus GridEX do seem impressive

The component I seek needs to work on a web page (IE5) and be able to grab and update data stored in an Access 2000 database located on a remote server over an http connectio. Is this possible using your grid, if so, do you have any examples of code / asp script demonstrating this scenario.

Best regards etc. etc
Reply

RE: Janus GridEX [Janus Systems Support] 14-Aug-2001 21:05:39

Check at the readme.htm file installed with the control for important information about using the GridEX 2000 with Visual Interdev.

For a demo showing the GridEX control working in the scenario you describe, please go to:
http://janusys.com/janus/ADCSample/jsadcGridEX2000.htm
Reply


Janus GridEX R.Alphey [Australia] 17-Jul-2001 07:16:52

If I have a relatively large grid (say 80 - 100) items and I scroll up and down it a few times I get "Out of Memory" errors. I haven't seen this mentioned in the bug fixes...

I'm currently using 1.6b, about to upgrade to 1.6d.

Is this bug fixed in GridEX 2000? Or, is there a workaround for it??
Reply

RE: Janus GridEX [Janus Systems Support] 18-Jul-2001 00:34:53

We've never seen this problem before in the GridEX control and I believe that something in the code you are using in one of GridEX events could be the cause of this memory problems.

If possible, please send me the form in which you are having such problems. Please fell free to send the form to support@janusys.com
Reply


Janus GridEX fmontana [France] 27-Jun-2001 12:33:31

I would also like info on making a master details form,
Reply


Janus GridEX test [Malaysia] 14-Jun-2001 04:53:10

How do I make a master-details form with Janus System Grid? Where can get the information?

I saw the Northwind Advanced Sample, is that available to download for the source code?

Thank you very much.
Reply

RE: Janus GridEX takenori [Japan] 20-Jan-2002 16:43:04

ComponentOne TrueDataControl is the answer.
This control can take any recordset as it's datasource,
and have a master-detail relationship with each other.
This performs great!
But TrueDataControl doesn't perform good as a datasource of Janus GridEX.

Janus GRIDEX is the best choice for manipulating a recordset.
Component One TrueDataControl is the best choice for making a master-detail relationship with Janus GridEX.
Reply


Evaluation version freezes my application when I t ike 01-Jun-2001 15:36:14

I am very impressed with the variety and strength of features provided with your grid ...however, after initially including this grid in my project and running it in debug mode with no problems at all, all subsequent attempts to re-open the project have resulted in VB freezing when your evaluation reminder comes up at startup.

Why is this? (It's the 3rd time I've started a new project and the same sequence of events has occured).

P/s do you have any plans to support SQLServer 7/2000 in the near future as this is a strong determinant in our decision to go ahead - in fact the only (in the absence of the current problem)

Thanks.
Reply

RE: Evaluation version freezes my application w... [Janus Systems Support] 11-Jun-2001 15:51:45

Are you using any other third party control in your project? If so, which one?
You could use GridEX 2000 with SQL Server 7/2000 in ADO DataMode.
Reply


Janus GridEX prashant [India] 29-May-2001 19:14:24

This does not work at all

GridEX.Movelast.....

I want to move the grid to the last row whenever a form is loaded. I have entered the above in my code But it does not do that. It does some times but fails again. Something is wrong with it i feel. The record selection pointer is definetely on the last row but the vertical scroll bar is on different positions each time the grid is refreshed, i.e not taking to the last record!

How can this be solved or is it a bug....
Reply

RE: Janus GridEX [Janus Systems Support] 11-Jun-2001 15:54:45

Such behavior is no longer present in GridEX 2000b
Reply

RE: Janus GridEX sigmund [Norway] 16-May-2002 17:18:29

Some comment...
Reply


Multiple-step Error zubairusman [United Kingdom] 23-May-2001 10:45:02

I have this message that appears 'Multiple-step operation generated errors. Check each status value.'
Anyone have any ideas why this appears and how to resolve it.
Reply

RE: Multiple-step Error [Janus Systems Support] 26-May-2001 00:49:11

The error is raised by ADO not by the GridEX control. It is usually fired when there is a type mismatch in one of the fields, or a required field is empty. There could be other reasons why this error is raised, and you could check the following Microsoft Knowledge Base articles:

Q207684, Q247202, Q228935, Q253882

The error description is not being explicit enough. To get a more explicit description, shift temporarily to use Server side cursors or check the ADO documentation for more information about this error.
Reply


RE: Janus GridEX jlyon [Manchester, United Kingdom] 21-May-2001 09:59:17

Hi

I have added a combo dropdown column to my grid and it all appears to work fine apart from one major problem. When I select an item from the dropdown list it does not change the data in the underlying cell. I have set the edit property to true and I am able to change other cells where I do not have a combo box.

What am I doing wrong as the example project works fine. I'm using VB6 and Access 95 connecting to my database with an ADO connection string.

Thanks

Jonathan Lyon
Reply

RE: Janus GridEX [Janus Systems Support] 21-May-2001 20:15:13

In order to be able to select an entry in a dropdown grid, the BoundColumnIndex and ReplaceColumnIndex properties must be set in the GridEX control that is acting as the dropdown list. Please check that these properties are set in your control.
Reply


RE: Janus GridEX Joost.derore [Belgium] 25-Apr-2001 10:47:24

How to use the property databasename or what other property exists to open a database that is password-protected using the DAO 3.6 ?

Thanks,
Joost
Reply

RE: Janus GridEX [Janus Systems Support] 26-Apr-2001 21:00:39

Set the Connect property in the following way:

GridEX1.Connect = "MS Access;pwd=<password>"

This applies to Password protected databases, if you want to open a database with User Security you need to open the database and recordset at runtime and assign that recordset to the Recordset property of the control.
Reply


RE: Loss of Focus In Unbound Mode.... Syd [UK] 11-Apr-2001 10:07:45

In Unbound mode, the loss of focus from a grid doesn't throw the UnboundReadData. This means that if a user opens the form, clicks a check-box on the grid, then hits a "save" button WITHOUT moving rows in the grid, the change to the value of the check box will not be registered, even though the value will have changed visually in the grid. I wouldn't go so far as to say that this is a "bug" but it is an unexpected piece of behavior.... I can work-around, no doubt, by doing some manual shilly-shally in my "save" routine, but maybe there is a better answer???
Reply

RE: Loss of Focus In Unbound Mode.... [Janus Systems Support] 11-Apr-2001 16:59:52

The UnboundReadData event is not fired when the control loses the focus, (this is by Design).

If you have changed some of the data in your array/collection used in the UnboundReadData event you should call the RefreshRowIndex method to force GridEX Control to fire the UnboundReadData event and refresh the contents of a row.
Reply

RE: Loss of Focus In Unbound Mode.... Syd [UK] 12-Apr-2001 08:28:10

Just out of interest, WHY is this by-design? I would have figured that, from the point-of-view of the user, clicking on another control is more indicative of "I'm happy and I want to commit this now" than moving to another row??? I'm sure there is a good reason - just interested in what it is. Thanks for your help. Syd
Reply

RE: Loss of Focus In Unbound Mode.... [Janus Systems Support] 16-Apr-2001 14:41:15

If we commit the changes when the control loses the focus, you won't have a chance to have a cancel button. when the user tries to click the cancel button, the changes would be committed and it wouldn't be any way to revert those changes.

If we don't commit the changes when the control loses the focus you just need to call the Update method and you are still able to cancel the changes in the current row.
Reply


DblClick Event syd_egan [Berkshire, United Kingdom] 04-Apr-2001 10:45:49

Has anyone got around the v. annoying way the DblClick event picks up a double-click on the column header. I want to use the DblClick to bring up an “Edit” dialog when a user double-clicks on a row, which works fine, but it ALSO brings up the dialog when the user double-clicks on the column header.

I am using the following to get the index of the clicked row:

lngIndex = jgridCustomer.RowIndex(jgridCustomer.Row)

Is there a better way??? Can I somehow detect if the click was on a column header and ignore it???

TIA
Reply

RE: DblClick Event [Janus Systems Support] 05-Apr-2001 21:35:29

To know where the user is clicking you need to use the HitTest method.

The HitTest method uses a coordinate as parameters and you don't get the X,Y coordinate where the user is clicking in the DblClick event so you will need to store this coordinate in a previous MouseDown event. i.e.

'In the Declarations section
Option Explicit

Dim mLastX As Long
Dim mLastY As Long

Private Sub GridEX1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

'save the last coordinate the user clicked on
mLastX = X
mLastY = Y

End Sub

Private Sub GridEX1_DblClick()

If GridEX1.HitTest(mLastX, mLastY) = jgexHTCell Then
'Now you are sure the user is clicking on a row and you can proceed to show the record form here...
End If

End Sub
Reply

RE: DblClick Event syd_egan [Berkshire, United Kingdom] 06-Apr-2001 10:48:24

Cool - I knew there had to be a way!

BTW These discussion forums are v. cool ;)
Reply


Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Screenshot Gallery

Click for full screen preview

Screenshot of Janus GridEX - ActiveX - 2000b Screenshot of Janus GridEX - ActiveX - 2000b Screenshot of Janus GridEX - ActiveX - 2000b Screenshot of Janus GridEX - ActiveX - 2000b
Award Award