handling control array in runtime - C# Discussion Boards

Problem in Importing data from Excel (Urgent)

Abhi15814-Jul-06 1:00

4-Jul-06 1:00

Hi I am using following code to Import data from Excel File in .NET 2005

DataSet myDataSet = new DataSet();

string strConn = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\test.xls;Jet OLEDB:Engine Type=5; Extended Properties=Excel 9.0";

OleDbConnection conn = new OleDbConnection(strConn);

OleDbDataAdapter addapter = new OleDbDataAdapter();

addapter.SelectCommand = new OleDbCommand("Select * From Mercury$", conn);

addapter.Fill(myDataSet);

On Executing it is giving me Following error
"Could not find installable ISAM."

I am using Excel2003 installed on Windows 2000.

Thanks in advance

Abhi

Re: Problem in Importing data from Excel (Urgent)

AB77714-Jul-06 1:14

AB7771

4-Jul-06 1:14

Try this
Extended Property="""Excel 9.0"""".

i guess that works for u.

Regards,

Pramod

Re: Problem in Importing data from Excel (Urgent)

ketankumar4-Jul-06 1:15

ketankumar

4-Jul-06 1:15

You need to check proper registry entry of Msexcl40.dll. Please go through following link and follow the steps given.

http://support.microsoft.com/kb/209805[^]

Regards,
Ketan

rows and columns in the List View

satsumatable4-Jul-06 0:54

satsumatable

4-Jul-06 0:54

Hi,

How can i count the total number of rows and columns in the List View, is there any properties or methods with out using loops.

Re: rows and columns in the List View

SeMartens4-Jul-06 2:24

SeMartens

4-Jul-06 2:24

Hi,

there are some properties that can be used to obtain the number of columns and rows:

Columns:

MyListView.Columns.Count

Rows:
MyListView.Items.Count

Regards
Sebastian

Re: rows and columns in the List View [modified]

satsumatable4-Jul-06 3:07

satsumatable

4-Jul-06 3:07

Ofcourse i want to get the currently selected row and column is it possible if so how to do it?

-- modified at 9:07 Tuesday 4th July, 2006

Re: rows and columns in the List View

BoneSoft5-Jul-06 3:43

BoneSoft

5-Jul-06 3:43

listView.SelectedItem

You do have IntelliSense don't you?

Try code model generation tools at BoneSoft.com.

handling control array in runtime

vatzcar4-Jul-06 0:44

vatzcar

4-Jul-06 0:44

i'm trying to implement control array in my app. the no of control will depend on user's requirement. total number will be gathered from database. therefore i had to make the code within a method.

<br />
private void CreatePictureBoxes()<br />
{<br />
   ....<br />
   ....<br />
   PictureBox[] pcbMem = new PictureBox[intCount];<br />
   Label[] lblMem = new Label[intCount];<br />
   ....<br />
}<br />

since i'm doing the whole code in a method i can't access those controls outside of that method. it's also not possible for me to create them in class level as the total index is unkown to me initially. i don't know how to reasign the length of an array so it's being a problem for me.
so please help me out to creating the controls so that i can use them from anywhere.

Re: handling control array in runtime

Stefan Troschuetz4-Jul-06 0:48

Stefan Troschuetz

4-Jul-06 0:48

vatzcar wrote:
it's also not possible for me to create them in class level as the total index is unkown to me initially

Just declare them at class level and instanciate them inside the method.

PictureBox[] pcbMem;
Label[] lblMem;

private void CreatePictureBoxes()
{
....
....
this.pcbMem = new PictureBox[intCount];
this.lblMem = new Label[intCount];
....
}

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: handling control array in runtime

jjansen4-Jul-06 2:29

jjansen

4-Jul-06 2:29

vatzcar wrote:
i don't know how to reasign the length of an array so it's being a problem for me.

To solve this problem, you could use a generic list.

using System.Collections.Generic;
List<picturebox> pcbMem = new List<picturebox>();

Private void CreatePictureBoxes()
{
...
for (int i = 0; i < intCount; i++)
{
PictureBox myPcb = new PictureBox();
...
pcbMem.Add(myPcb);
}
}

How to Disable AddressBar and Menus???

rachgreen4-Jul-06 0:02

rachgreen

4-Jul-06 0:02

Hi All,
Can somebody help me how to disable the addressbar and the menus, for a web application??? Confused | :confused:

Rach

Re: How to Disable AddressBar and Menus???

psamy4-Jul-06 0:37

psamy

4-Jul-06 0:37

Hi,
use window.open method. assign features property in this method.

example,

window.open(sURL, "HELP", "resizable=yes,titlebar=no,toolbar=no,location=no,status=no,menubar=no");

Re: How to Disable AddressBar and Menus???

Dario Solera4-Jul-06 0:37

Dario Solera

4-Jul-06 0:37

You'll need a piece of JavaScript code, so you should ask in the web development forum.

_____________________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] - Developing ScrewTurn Wiki 1.0b...

Finding " Specified cast is not valid."error in strType = CType(sender, MenuItem).Text

bpoojas3-Jul-06 23:34

bpoojas

3-Jul-06 23:34

Kiindly help and reply soon.

pooja

Re: Finding " Specified cast is not valid."error in strType = CType(sender, MenuItem).Text

J4amieC3-Jul-06 23:41

J4amieC

3-Jul-06 23:41

erm, sender is not of type "MenuItem" - its pretty straight forward as far as error messages go!

Do you by any chance define a class in your project with the name "MenuItem"

Current blacklist
svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour

Restricting the user to Access the hidden form

AB77713-Jul-06 23:20

AB7771

3-Jul-06 23:20

Hi all,

I have created an app which starts and the forms are
kept invisble, but when i press ALT + TAB the Form
is displayed.

I want to avoid this.

Any ideas will be appreciated.

Thanks,
Pramod

Re: Restricting the user to Access the hidden form

SeMartens3-Jul-06 23:25

SeMartens

3-Jul-06 23:25

Hi Pramod,

there must be a form-property called "ShowInTaskbar". Setting this to false should fix your problem.

Hope this helps,
Regards
Sebastian

Re: Restricting the user to Access the hidden form

AB77714-Jul-06 0:15

AB7771

4-Jul-06 0:15

Thanks,

Actually i had set that property but the actual problem was i had called the forms ShowDialog() method,
due to which that was visible.

Thanks for ur time

Pramod

Re: Restricting the user to Access the hidden form

stancrm4-Jul-06 0:19

stancrm

4-Jul-06 0:19

Use Show() not ShowDialog()

DLL hell

singhswat3-Jul-06 23:10

singhswat

3-Jul-06 23:10

hi friends,
Can anybody tell me which framewok do i need for using this namespace i have VS2003 i need to use "using microsoft.PointOfService;"

Cry | :((

Re: DLL hell

Dario Solera4-Jul-06 0:39

Dario Solera

4-Jul-06 0:39

It should be microsoft.pointofservice.dll

_____________________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] - Developing ScrewTurn Wiki 1.0b...

How to have a very/better responsive RichTextBox (no WordWrap) when it is resized ?

girm3-Jul-06 23:08

girm

3-Jul-06 23:08

Hi There (sorry for my english, not my native language),

I'am using a RichTextBox (docked "fill" in a form) , with no word wrapping , my problem is that when it is polpulated with around 50.000 line resizing the parent form takes times.

Considering that :
-scrolling is fast
-I do not want word wrapping

It seems weird to me why there is this overhead when resizing(*).

I am thinking of a solution:
- do not dock the rtf , size it at screen maximum size (and so let the parent form hide the "out of client area" parts).
- handle scroll bars of my own

But before starting the big thing I will *really* apreciate if anyone has already solved this kind of problem or , have a better idea ???

Thanks in advance for any help or views

(*) WordPad for instance it rft based and is damned fast in resizing big documents.

Girm

How to modify stand-by times in the power schemes

sogge3-Jul-06 22:19

sogge

3-Jul-06 22:19

Hi guys,

I am trying to find a way to modify the times in the machines power schemes to define the time when the computer will go into the standby mode.
I have scanned the MSDN (and there especially the WMI providers),
but haven't found anything there.
For my specific problem I would prefer to modify the time span directly, but as a fallback I could live with changing the used power schema.

Any help on how I can do this would be appreciated!

Cheers,
sogge

Re: postback

Guffa3-Jul-06 23:26

Guffa

3-Jul-06 23:26

Use the SelectItem, SelectedIndex or SelectedValue property.

---
b { font-weight: normal; }

form show/hide problem ? [tcp/ip > freezes my form]

cmpeng343-Jul-06 21:44

cmpeng34

3-Jul-06 21:44

hi all,
i have two forms. one is a login form and the other is a main form created if login is successful.
on successful logins, i create the main form and hide the login form.

i do some socket programming on form2. and when i close the main one, show the first form again.

but this time the login screen freezes, and my form doesnt respond. so i terminate that application and rerun it again.

what may cause the login form to freeze when i close the main form ?

help please,
regards,
bye...

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.