Yes i did, but that didn't work... So i removed all registry entries that pointed to the ocx and registrated the new one. That didn't work too. My last hope was a system restart, did it, and YES it works again!!! Don't know what fixed the problem, but my solutions where: - Recompiling the ocx on the other computer. - Registrating all dll/ocx files again. - Removed all registry entries of the ocx file. - Registrated the ocx again. - Restarted the computer.

I have a really weird problem. I had to make some adjustments to a VB6 application. So i installed Visual Studio 6 (with SP6) on my Windows 7 pc, i downloaded the project though Visual SourceSafe and after changing some filepaths in the projectfiles(had to be done because it had some absolute references in it) and recompiling some ocx file(because of a more logic file-location) i got the project to work on my computer. I made my changes i checked-in the project again. Now a college of mine wanted to see the changes on his computer(with had a already working copy of the source). He got the latest version of the source code and opened the project. He got a error about visual basic not finding the ocx file i recompiled, but after registrating the ocx file he could open the project without a problem. After hitting F5 he got the following error message: "System Error &H80004015 (-2147467243). The class is configured to be executed when a security-ID is different from the caller" << now don't know about the error message, i had to translate it, the original message was: De klasse is geconfigureerd om te worden uitgevoerd als een beveiligings-ID dat verschilt van de beller < witch is not correct dutch :) His Pc is a Windows XP computer and also has Visual Studio 6 (SP6) installed. Can somebody please help me out with this really weird problem.

This also doesn't work... The checkbox mouseenter event gets triggerd, sets the focus to the usercontrol, but no scroll event is triggerd after that.

Well acually, i did not know that;) (kinda new in .NET Forms, the last forms application was Visual C++ 6, MFC) But there is a sophisticated system behind the interaction between the checkboxes in the list, if i want to convert that to a listcontrol it would take me some time, while the listbox i created now works exactly like i want, with the minor problem of scrolling. I also want to know how to properly solve this issue for future usage. Converting would be my last hope;)

This was my first solution and it doesn't work. When i do this my usercontrol will get the focus(the mouseenter event gets fired), but it doesn't fire the scroll event after that. I think this is because the checkboxes override the foces when hovering over it, I think this because the checkbox "lights up" when you hover over it(I use windows 7). So i think you understood my question right, but the solution doesn't work.

Hi, I have made a C# forms application. In there i use a usercontrol that dynamicly puts a list of checkboxes onto the usercontrol. Next to the checkboxes is a scrollbar. If you move the scrollbar the checkboxes will be set onto the selection that is pointed out by the scrollbar. So the Text and Checked state of the checkboxes get updated to the position in the entire list. (in short, i've made my own ListBox with checkboxes) My problem is that i cannot capture the scroll event of the mouse from checkboxes(using the hardware scrollbutton). The scroll event of the usercontrol itself doesn't get triggerd because of the checkboxes are on top of it. And the checkboxes itself do not have a scroll event. How can i solve this? Greetz Willem

After playing around with this problem i notest that the base table doesn't have a primary key, after changing this the query excuted as fast as directly on the server. Also setting some indexes improved the speed. Why this should make a difference is a mystery to me...

Hi, I'm working for the first time with linq on a new project. I've made a few queries now, that are quite simple. They are running very fast, but, for my last query i had to do some more complex things(5 joins) and now the preformance is really really bad. It takes more than a minute to retreive 400 records(and it often gives time-outs). At first i thought it might be that the query was wrong. So i copied the query that was excuted in debug mode and ran it directly on the SQL Server using SQL Management studio. This excuted in less than a second, so the problem is not the query. Then i thought it might be that the objects that are used to join the tables together where very heavy for the application. So i moved my complete query to a stored procedure, and used linq to only excute the stored procedure, witch makes linq kind of obsolete. This gave exactly the same behaviour, the stored procedure's execution time is over a minute and often ends up in a time out, while when i excute the stored procedure directly on the sql server the excution time is less than a second. I've searched google for others with the same problem, but i cannot find anyone with the same problem. Please help me, i see the advantages of linq but with these kind of problems i think i have to switch to something different than linq. Few things, i don't know if it makes a difference: - I'm using .dbml datacontext files - The joins i make in the query are not described in this datacontext. The linq query:

var externeuitvoeringen =
from euv in ((UitvoeringenDataContext)_DataContext).tblExternUitvoerings

    join join\_brs in ((UitvoeringenDataContext)\_DataContext).tblBrandstofs
    on euv.lng\_euv\_brs\_ID equals join\_brs.lng\_brs\_ID
    into brs\_temp
    from brs in brs\_temp.DefaultIfEmpty()

    join join\_adr in ((UitvoeringenDataContext)\_DataContext).tblAandrijvings
    on euv.lng\_euv\_adr\_ID equals join\_adr.lng\_adr\_ID
    into adr\_temp
    from adr in adr\_temp.DefaultIfEmpty()

    join join\_vsn in ((UitvoeringenDataContext)\_DataContext).tblVersnellings
    on euv.lng\_euv\_vsn\_ID equals join\_vsn.lng\_vsn\_ID
    into vsn\_temp
    from vsn in vsn\_temp.DefaultIfEmpty()

    join join\_eku in ((UitvoeringenDataContext)\_DataContext).tblExternKoppelUitvs
    on euv.str\_euv\_ID equals join\_eku.str\_eku\_euv\_ID
    into euk\_temp
    from euk in euk\_temp.DefaultIfEmpty()

    join join\_euh in ((UitvoeringenDataContext)\_DataContext).tblExt

Hi, I already got the solution, thanks to djj55: I converted the Stored Procedure into a Database Function, now i can use it in the query like this:

SELECT
db1.dbo.table1.ID as ID,
db1.dbo.table1.Field1 as Field1,
db2.dbo.table2.Field2 as Field2,
db1.dbo.Calculate(db1.dbo.table1.ID) As Amount

FROM db1.dbo.table1

INNER JOIN db2.dbo.table2
ON db1.dbo.table1.ID = db2.dbo.table2.ID

Could you give me an example how to use a function in my query? I have never used functions in sql server, only views/stored procedures and triggers. Converting my stored procedure to a function would not be the biggest problem, i think.

Hi, I have made a stored procedure witch returns a field that i want to use in a query. There is 1 parameter that I give to the stored procedure witch comes from the normal query. The info about the stored procedure: Name: SP_Calculate Input: ID Output: table with 1 column: Amount and 0 or 1 row. And this is what I want to do in the query:

SELECT
db1.dbo.table1.ID as ID,
db1.dbo.table1.Field1 as Field1,
db2.dbo.table2.Field2 as Field2,
( SELECT Amount FROM db1.dbo.SP_Calculate(db1.dbo.table1.ID) ) As Amount

FROM db1.dbo.table1

INNER JOIN db2.dbo.table2
ON db1.dbo.table1.ID = db2.dbo.table2.ID

Of course this code doesn't work, but i hope it gives you a good view of what I try to do. This query is a example query, the actual query is really long.

Found the solution myself, the setting of selected cell's is only effective after the datasource is bound to the control. This is not done jet when you are in the Form_Load, so you have to wait for it. This is my solution:

private string Selection_ColumnName = null;
private List<object> Selection_CellValues = null;

public void SetSelectedValues(string ColumnName, List<object> CellValues)
{
Selection_ColumnName = ColumnName;
Selection_CellValues = CellValues;
gridData.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(gridData_DataBindingComplete);
}
private void gridData_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
bool CellFound = false;

for (int ColumnIndex = 0; ColumnIndex < gridData.Columns.Count; ColumnIndex++)
{
    if (gridData.Columns\[0\].Name == Selection\_ColumnName)
    {
        gridData.ClearSelection();

        for (int RowIndex = 0; RowIndex < gridData.Rows.Count; RowIndex++)
        {
            foreach (object CellValue in Selection\_CellValues)
            {
                try
                {
                    if (gridData.Rows\[RowIndex\].Cells\[ColumnIndex\].Value.ToString() == CellValue.ToString())
                    {
                        gridData.Rows\[RowIndex\].Cells\[ColumnIndex\].Selected = true;
                        if (!CellFound) gridData.CurrentCell = gridData.SelectedCells\[0\];

                        CellFound = true;
                    }
                }
                catch
                {
                }
            }
        }

        break;
    }
}

gridData.DataBindingComplete -= new DataGridViewBindingCompleteEventHandler(gridData\_DataBindingComplete);

}

Hi, I'm creating a user control that displays a DataGridView control. I want to be able to programmatically select multiple cells/rows. So i made this function:

public bool SetSelectedValues(string ColumnName, List<object> CellValues)
{
bool FoundRows = false;

for (int ColumnIndex = 0; ColumnIndex < gridData.Columns.Count; ColumnIndex++)
{
    if (gridData.Columns\[0\].Name == ColumnName)
    {
        gridData.ClearSelection();

        for (int RowIndex = 0; RowIndex < gridData.Rows.Count; RowIndex++)
        {
            foreach (object CellValue in CellValues)
            {
                if (gridData.Rows\[RowIndex\].Cells\[ColumnIndex\].Value.ToString() == CellValue.ToString())
                {
                    gridData.Rows\[RowIndex\].Cells\[ColumnIndex\].Selected = true;
                    gridData.CurrentCell = gridData.Rows\[RowIndex\].Cells\[ColumnIndex\];

                    FoundRows = true;
                }
            }
        }

        break;
    }
}

return FoundRows;

}

It doesn't work, only the last cell gets selected, because i cannot select multiple cells in the CurrentCell. How can i solve this? Regards, Willem

Thank you for your link, i've seen it before. Maybe it's me, but i cannot read a solution for my problem on this page, although the title of this webpage refers to my problem.

I'm sorry, but the usage of resource files is really not an option for me. The application that i'm programming makes use of a database witch is also used by a remote application where you can dynamically update the captions(like an update server). I could use the resource file as a shadow for the database but that would mean reprogramming the hole application into the usage of resource files. And making a interfase for the shadown resource files and the database itself. This simply is too much work (application source is more than 65 mb).

The captions of my buttons/textboxes ect. are filled from a database, I cannot convert this to the usage of resource files cause of the functionallity of the program. I already tried changing the fonts and the charset property of the fonts but that didn't work as well.

Could you be more specific? Witch resource file?

Okey i thought you where talking about that... I really need an answer for this question...

.NET??? read this: http://support.microsoft.com/kb/193540[^]

Hi, I'm currently working on a VB6 project witch has to be able to display texts in different languages(NL/US/FR/RU ect.). The problem as you all know with this is that the text end up looking like "???". To solve this i can set the regional settings in the control panel to the corresponding language. But this means that the computer has to restart every time you setup a different language. All controls also have a Charset property but if i set those to the right value(for instance 204 for using russian) it doesn't seem to have any effect. After some searching on the net i found out this is caused by the translation of unicode to ansi in the controls of VB6 (i don't know for sure that i'm using unicode). To solve this you can buy libaries that do this translation for you so the VB6 controls can't mess it up. But i have no money;) Another solution would be to use Forms 2.0 controls that are able to handle unicode. But then i cannot redistribute my software. And they also didn't work (still showing ???). After all of this it seems kind of impossible to solve this problem, but i cannot believe there isn't a solution. It does work if i set the regional settings to the right language, can't i do the same thing without using the regional settings? I really need help here. Greetz, Willem