C# Discussion Boards - CodeProject

DaveyM693-Jul-09 20:02

DaveyM69

3-Jul-09 20:02

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

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)

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

DaveyM69

4-Jul-09 11:50

Reported here[^]

DaveyM696-Jul-09 23:14

DaveyM69

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![^]