Re: Problem in Importing data from Excel (Urgent) - C# Discussion Boards

App.config

SysJey4-Jul-06 1:23

SysJey

4-Jul-06 1:23

How to add Application.config file for windows application project and how to access data from the file

Jey

Re: App.config

mav.northwind4-Jul-06 2:21

mav.northwind

4-Jul-06 2:21

Just select Add/New item (or something semantically equivalent - I don't have an english VS at hand) in your project and select Application configuration file. You'll get a file named "App.config" which is renamed to <YourExecutableName>.exe.config and copied to your output directory.

To access entries in the file you should take a look at the System.Configuration namespace.

Regards,
mav

--
Black holes are the places where god divided by 0...

ListView with transparant BackColor

boxed4-Jul-06 1:18

boxed

4-Jul-06 1:18

I'm trying to display my desktop icon's in a listview with a transparant background. I want the icons to be perfectly visible and the white background color to blend in with the graphics below the form.

So actually setting ListView.BackColor to transparant would do the trick. But ListView.BackColor doesn't support transparancy.

Is there an other 'listview' component that does support transparancy, or any other way to achieve a transparant background below the icons?

Cheers, Richard

Re: ListView with transparant BackColor

mav.northwind4-Jul-06 2:29

mav.northwind

4-Jul-06 2:29

You'll have to set a certain color as the BackColor of your ListView (I usually take magenta or cyan for this purpose) and then set the TransparencyKey of the Form containing your ListView to the same color.

Regards,
mav

--
Black holes are the places where god divided by 0...

Re: ListView with transparant BackColor

boxed4-Jul-06 2:56

boxed

4-Jul-06 2:56

Okay great, that worked. But now it's like there's no background at all.
Is there a way to make it semi transparant?

I tried to make a custom color with a alpha value of say 20, but then the listview complains again about not supporting transparant colors...

Re: ListView with transparant BackColor

mav.northwind4-Jul-06 4:13

mav.northwind

4-Jul-06 4:13

To achieve semi-transparency, you'll have to dig deeper into layered windows. But beware, that's not a trivial task and only has very limited support within .NET. YOu'll have to use lots of p/invoke calls to get layered windows working right.

Regards,
mav

--
Black holes are the places where god divided by 0...

Problem in Importing data from Excel (Urgent)

Abhi15814-Jul-06 1:00

Abhi1581

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()

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