C# Discussion Boards - CodeProject

Re: Converting a string to a DateTime object (globalization question)

Andrei Ungureanu4-Jul-06 4:37

4-Jul-06 4:37

Hi,
Try something like:

DateTime myDateTime = new DateTime(year,month,day);
The year,month and day can be substracted from the string if you know their exact position, using Substring and IndexOf. It helped me a lot sometimes. Hope it helps you. Big Grin | :-D

Do your best to be the best

Re: Converting a string to a DateTime object (globalization question)

Vikram A Punathambekar4-Jul-06 5:06

Vikram A Punathambekar

4-Jul-06 5:06

I was hoping there's a cleaner solution, but hey, your suggestion works. Big Grin | :-D

Thanks a ton! Smile | :)

š

Cheers,
Vikram.

"I am not Jesus and will never be. The fact is I was a piece of cr*p till I found Him." - Paul Selormey.

Re: Converting a string to a DateTime object (globalization question)

J4amieC4-Jul-06 5:02

J4amieC

4-Jul-06 5:02

Using .NET 1.1 and the following code:

string theDate = "11/03/2005";<br />
DateTime dt = Convert.ToDateTime(theDate, new System.Globalization.CultureInfo("en-US"));<br />
MessageBox.Show(dt.ToLongDateString());

Shows Nov 3 2005.

If I remove the culture info, and allow my local machine (UK) to decide, it gives March 11th. So basically that is exactly the desired behaviour!

What did you mean by:

Vikram A Punathambekar wrote:
but that didn't work

It appears to work perfectly!

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

Re: Converting a string to a DateTime object (globalization question)

Vikram A Punathambekar4-Jul-06 23:31

Vikram A Punathambekar

4-Jul-06 23:31

J4amieC wrote:
It appears to work perfectly!

I use the European format on my machine too, but it didn't work. Unsure | :~

However, since then, I replaced the code with the DateTime(year, month, date) suggestion above and it works perfectly.

Thanks anyway! Smile | :)

š

Cheers,
Vikram.

"I am not Jesus and will never be. The fact is I was a piece of cr*p till I found Him." - Paul Selormey.

Re: Converting a string to a DateTime object (globalization question)

lmoelleb4-Jul-06 23:32

lmoelleb

4-Jul-06 23:32

The magic word here is "appears", as you actually made a quite classic I18N error here. Don't worry, you are not the first one - and it won't fail on that many systems. What you really want to do is this:

new System.Globalization.CultureInfo("en-US", false);

Specifying "false" makes sure that you get the default en-US settings ignoring any changes done in the regional settings. Notice that if you do not run en-US regional settings you will always get the default - the potential problem is only for accounts configured with en-US settings and a changed date format.

Re: Converting a string to a DateTime object (globalization question)

Judah Gabriel Himango4-Jul-06 5:56

Judah Gabriel Himango

4-Jul-06 5:56

.NET 2 has DateTime.TryParse, which has an overload which takes an IFormatProvider (where you could pass in some arbitrary culture). Unfortunately, I don't think TryParse is available on .NET 1.1 IIRC.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Goof around music jam with my brothers (with video)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Problem with Open Dialog box

ranandbe4-Jul-06 3:02

ranandbe

4-Jul-06 3:02

Hi Folks,
i have a problem with common dialog', I need to open a file when i click the item from listbox. now i got open dialog with specified path but it dont open the file. can you plz give idea to solve this.

my code is here.,
the following code in selected index changed event for thet listbox.
OpenDialog.FileName="Filepath";
OpenDialog.OpenFile();
OpenDialog.ShowDialog();

ranandbe

Re: Problem with Open Dialog box [modified]

stancrm4-Jul-06 3:13

stancrm

4-Jul-06 3:13

??? I don't understand your code and what do you want to do with that, but normally I use it like this:

OpenFileDialog openFileDialog = new OpenFileDialog();
DialogResult dialogResult = openFileDialog.ShowDialog();
if(dialogResult == DialogResult.OK && openFileDialog.FileName != "")
{
    // use something with this filename (openFileDialog.FileName)
    // For example :
    // FileStream fileStream = new FileStream(openFileDialog.FileName, FileMode.Open);
    // ...
    // fileStream.Close();
}

OpenFileDialog openFileDialog = new OpenFileDialog();
if(openFileDialog.ShowDialog() == DialogResult.OK)
{
	System.IO.FileStream filestream = openFileDialog.OpenFile();
	// ... use something with filestream
	filestream.Close();
}

Before ShowDialog() you can only set the property like Path, Filter, etc...
Then you must call ShowDialog() to show the dialog. If the user select a file and click OK, then
you get a return value DialogResult.OK. Then you can get the filename by calling openFileDialog.FileName.

C# and Excel pivottable caches

boakley4-Jul-06 2:22

boakley

4-Jul-06 2:22

I am generating an Excel workbook from within a C# console app and wish to duplicate a worksheet which includes a pivottable. This however does not create a new pivotcache, so when the original worksheet is updated, the second is as well.

Does anyone know how I can separate the caches after they have been created? It is easy to link the new pivottable's pivotcache to a third pivotcache, but creating a new pivotcache without actually setting up a new pivottable seems impossible.

Thanks.

barcode

Mohammed Elkholy4-Jul-06 2:15

Mohammed Elkholy

4-Jul-06 2:15

how can i read data about product from barcode and stoe it in data base

i hope an example becuase i am not profisional

then you for help

MD_NADA

Re: barcode

Josh Smith4-Jul-06 4:18

Josh Smith

4-Jul-06 4:18

Search CodeProject on the keyword "barcode" and you'll find articles that show how to work with barcodes.

:josh:
My WPF Blog[^]

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.

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