Re: Taborder in toolbar? - C# Discussion Boards

Henry Minute3-Jul-09 3:46

Henry Minute

3-Jul-09 3:46

netogg wrote:
these do not have a TabIndex to reorder.

That's a shame!

I hope someone else can help you.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

DaveyM693-Jul-09 5:23

Re: Taborder in toolbar? [modified]

3-Jul-09 5:23

It seems the answer is to extend the ToolStripControlHost class as suggested here[^].

I've just tried it with your 'steps to reproduce' above and it worked fine. Code I used below.

using System.Windows.Forms; namespace WindowsFormsApplication1 { public class ToolStripUserControl1 : ToolStripControlHost { public ToolStripUserControl1() : base(new UserControl1()) { } public UserControl1 UserControl1Control { get { return Control as UserControl1; } } } }

toolStrip1.Items.Add(new ToolStripUserControl1());

Hmm... It was adding it at the end so it appeared to work. Using Insert instead of Add to place it inbetween the buttons produces the same result as before Confused | :confused:

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

netogg3-Jul-09 6:05

3-Jul-09 6:05

Hi Dave,

Thank you for your solution, I already came across the link your posted and tried several times.
I might be doing something terribly wrong...

When I try to "tab" trough the buttons its still messed up. When the focus is inside the UserControl then "tab" goes to the first button instead of to the next. And "shifttab" goes to the last button instead of the previous.

Would you mind posting your full solution please?

Thanks in advance.

@Dave at your comments suggesting insert: been there, tried that... sigh

modified on Friday, July 3, 2009 12:11 PM

DaveyM693-Jul-09 6:23

3-Jul-09 6:23

This is annoying me so I'll have a further look at home tonight (UK) and see if I can work a solution.

netogg3-Jul-09 6:40

3-Jul-09 6:40

Wow, thanks.

So far I've tried to add everything in the designercode, but nothing changes. Also am I looking into SelctNextControl en SelectPreviousControl, but I'd rather have the whole userControl self contained.

Anyway, Good luck!

DaveyM693-Jul-09 9:11

3-Jul-09 9:11

No solution I'm afraid, but I have narrowed down the exact situation under which it occurs which could help to diagnose the cause and find a solution

Problem: It only happens when a UserControl is being hosted and that UserControl has a control(s) that can accept focus.
OK: If you use an empty UserControl or one that only has non focusable controls, it behaves as expected.
OK: If you host a TextBox (or any other edit control) directly, it also behaves as expected.

netogg3-Jul-09 12:10

3-Jul-09 12:10

Thank you very much for your effort!

Anybody else on this issue? It shouldn't be that hard...you'd think. Confused | :confused:

DaveyM693-Jul-09 20:02

3-Jul-09 20:02

I'd file it as a bug report on Microsoft Connect.

netogg4-Jul-09 0:35

4-Jul-09 0:35

Hmmm, the process of bugreporting seems excruciating, frustrating and the average results too meager.
I'd be more interested in a workaround or fix.

If anyone else thinks this is worthy of reporting to Microsoft, I won't stop you and be thankful for it.

Kind regards to all you nice people.

DaveyM694-Jul-09 11:50

4-Jul-09 11:50

Reported here[^]

DaveyM696-Jul-09 23:14

6-Jul-09 23:14

Have you got anywhere with this?

Microsoft have been able to reproduce it which is a good first step, but doesn't mean they have a fix or workaround for it of course!

netogg7-Jul-09 8:07

7-Jul-09 8:07

They better ought to be able to reproduce it... I've been battling this for quite a while now. Smile | :)

Thank you for reporting this, I must admit Microsofts reponse so far has pleasantly surprised me.
Still no luck in getting around this issue though.

Does anyone else know a solution for putting a complex compound control in a toolbar?

netogg7-Jul-09 9:16

Re: Taborder in toolbar? CanSelect?

7-Jul-09 9:16

I have been trying this with a "compound"control on this same form as the toolbar is.

The compound control is a Panel with a Texbox inside (child control) on the very Form.
In the Form's Constructor i do;

toolStrip1.Items.Insert(2,new ToolStripControlHost(panel1));

With the same results. I think this narrows the bug to:

When using a ToolStripControlHost to host any ContainerControl with any focusable controls in a ToolStrip, tabbing between controls on the ToolStrip does not cycle through all controls.

You might wanna link Microsoft to here. Thanks again.

netogg7-Jul-09 9:57

7-Jul-09 9:57

Continuing from the previous code... In my example i had 4 ToolStripButtons and panel1 inserted at position2 in a Toolbar.

Put a break on the added code in the Constructor and debug. Step once withF11.
In the watch Window add 'toolStrip1'. Follow the tree to:

toolStrip1.Items.base.Non-Public members.System.Windows.Forms.ToolStripItemCollection]. owner.Items.Non-Puclic members.base._innerList

Each of the Items in the List represent the Properties of a Control on the ToolStrip. And each of these (toolStripButtons) have their CanSelect property to true. Except for the inserted Control (ToolStripHostControl) at position 2 == Item[2], the third item in the List, which has CanSelect false.

This might be an explanation for the problem.

Now how does the CanSelect property get there? And how do I set its value? Better yet, how to solve this???

mssql version problem

leone3-Jul-09 1:51

leone

3-Jul-09 1:51

hi.i have a confusing problem. i used mssql 2005 developer version for a pc.
it worked well with all functions. but when i installed it for my own pc with same cd's, it worked as if it was express edition. There is no import, export, full-text-search functions and even there is no sql manager studio. i installed it manually. what can i do?

Manas Bhardwaj3-Jul-09 2:07

Manas Bhardwaj

3-Jul-09 2:07

And what does it has to do with C#? WTF | :WTF:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

leone3-Jul-09 5:58

leone

3-Jul-09 5:58

i am sorry. i know here is not appropriate place of the board but many of experienced friends look here and i cannot get answer from database board.

K03063-Jul-09 2:21

K0306

3-Jul-09 2:21

May be you didn't installed all the features, try this link

Installation guide for MSSQL 2005[^]

leone3-Jul-09 6:08

leone

3-Jul-09 6:08

i read it but couldn t fix my problem. İ checked all of those
# SQL Server Database Engine
# Analysis Services
# Reporting Services
# Notification Services
# Integration Services
# Management Tools
# Documentation and Samples

Reading excel file in blocks

Luc Pattyn3-Jul-09 6:20

Luc Pattyn

3-Jul-09 6:20

Sorry for stating the obvious, but when you install more than one database on a machine, they would have different names, and your connection strings need modified including the name.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

sankar i3-Jul-09 1:28

sankar i

3-Jul-09 1:28

Hi,

I would like to know is there any way where we can read excel file in blocks("x" rows at a time) so that the entire file is not loaded into memory.

Replies would be appreciated.

padmanabhan N3-Jul-09 1:44

padmanabhan N

3-Jul-09 1:44

sankar i wrote:
any way where we can read excel file in blocks("x" rows at a time)

means you want to read for example A1 to A20, something like this

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

moon_stick3-Jul-09 3:25

moon_stick

3-Jul-09 3:25

I assume you're talking about loading the data from an excel spreadsheet into a datatable (for example). I wrote the following snippet that will extract the top 10 lines from an excel file using a database connection:

static void Main(string[] args)
        {
            string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;;Data Source=C:\temp\XlsJetTest.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";";
            OleDbConnection conn = new OleDbConnection(connStr);
            OleDbCommand comm = new OleDbCommand("select top 10 * from [Sheet1$]", conn);
            conn.Open();

            OleDbDataAdapter da = new OleDbDataAdapter(comm.CommandText, conn);
            DataTable dt = new DataTable();
            da.Fill(dt);

            Console.WriteLine("RowCount:\t{0}", dt.Rows.Count);
            Console.ReadLine();
        }

A little bit of SQL manipulation should allow you to be able to 'page' through chunks of the spreadsheet (you might have to write a couple of functions to do something clever).

It definitely isn't definatley

EliottA3-Jul-09 3:36

EliottA

3-Jul-09 3:36

I think he want's to read the first ten lines without opening up the excel file in memory as a whole (which is done above).

If that is the case, then no, it cannot be done that way.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]