Re: C# + Excel - C# Discussion Boards

DaveyM6926-May-09 0:46

26-May-09 0:46

I'm getting very suspicious about what you're trying to do.

I would suggest that people here stop helping you until answer the question I asked in my last post to you[^].

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)

Re: Complex Question

J4amieC26-May-09 1:10

J4amieC

26-May-09 1:10

So, just to recap. You're trying to:

a) Copy the currently running exe
b) Hide the console window
c) Block access to a folder

If this isn't something you shouldn't be writing then im the pope.

Re: Complex Question

Tom Deketelaere26-May-09 1:13

Tom Deketelaere

26-May-09 1:13

J4amieC wrote:
then im the pope.

Cool, can I borrow your ferrari please Big Grin | :-D

(I was also looking at his profile to see what exactly he is up to and I does seems like this program isn't on the safe side of things.)

Re: Complex Question

0x3c026-May-09 1:30

0x3c0

26-May-09 1:30

J4amieC wrote:
im the pope.

Stay away from those kids!

Re: Complex Question

Dave Kreskowiak26-May-09 3:49

Dave Kreskowiak

26-May-09 3:49

Rajdeep.NET wrote:
I am trying to create a small utility which can block folders from direct access.

Yeah, with you're skill level, and total lack of knowledge in how Windows works, you're never going to pull this off.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

C# + Excel

Socheat.Net25-May-09 22:52

Socheat.Net

25-May-09 22:52

Dear,
I have one problem, when i connect from my app to excel and when display the result I lost 1 row,

Why?

Please help me

Socheat

Re: C# + Excel

fly90425-May-09 23:02

fly904

25-May-09 23:02

You need to be more specific. How did you connect to the excel? Was it the first row you lost?

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: C# + Excel

Socheat.Net25-May-09 23:10

Socheat.Net

25-May-09 23:10

Dear

I Use like this

string strCnn="";
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;";
strCnn += " Data source=" + openFileDialog1.FileName;
strCnn += ";Extended Properties=Excel 8.0;";
OleDbConnection cn = new OleDbConnection(strCnn);
cn.Open();
string strsql="";
strsql = "SELECT * FROM [sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(strsql, cn);
DataTable dt = new DataTable();
da.Fill(dt);
int i=0;
Application.DoEvents();
for (int k = 0; k < dt.Rows.Count; k++)
{
i++;
dgvSource.Rows.Add(i.ToString(), dt.Rows[k][0].ToString());

}

I got only 9 rows, but in fact in excel has 10 rows

Thanks

Socheat

Re: C# + Excel

fly90425-May-09 23:26

fly904

25-May-09 23:26

Which row is missing? Is it the first one? If it is then you will notice that it is being used as the column titles. Use strCnn += ";Extended Properties=\"Excel 8.0;HDR=No;\""; to stop using the first row as the column headers, the default is HDR=Yes.

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: C# + Excel

Socheat.Net25-May-09 23:30

Socheat.Net

25-May-09 23:30

Dear

I lose the first row.

I have include string connection like you wrote "HDR=No;" already but i got error Cound not find installable ISAM, so how can i do?

Socheat

Re: C# + Excel

fly90425-May-09 23:34

fly904

25-May-09 23:34

Apologies, I used used the incorrect syntax:

string strCnn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=No;\"", openFileDialog1.FileName);

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: C# + Excel

Socheat.Net26-May-09 15:33

Socheat.Net

26-May-09 15:33

Dear,

Thanks, it work well now

Socheat

How to hide the black console window

Rajdeep.NET is BACK25-May-09 22:31

Rajdeep.NET is BACK

25-May-09 22:31

Hi guys,

How can I hide the black window which appears during the execution of a console application? I want to hide it, becasue I have a program which doesn't accept any user input and just goes on performing some specific tasks which takes quite long time.

Thanks,
Cheers,
Rajdeep.NET Wink | ;)

Re: How to hide the black console window

stancrm25-May-09 22:45

stancrm

25-May-09 22:45

How about googling, see the first link in google :

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ea8b0fd5-a660-46f9-9dcb-d525cc22dcbd[^]

Re: How to hide the black console window

Tuwing.Sabado25-May-09 22:54

Tuwing.Sabado

25-May-09 22:54

No need to change your existing code just change your project output type as Windows Application instead of Console Application.

How to change your project output type
1. from your solution explorer right click your console project then choose Property menu.
2. from the application tab change the value of Output type dropdownlist.

Happy coding...

Re: How to hide the black console window

Rajdeep.NET is BACK25-May-09 23:32

Rajdeep.NET is BACK

25-May-09 23:32

Thanks Mark, that worked very well..... thanks for preventing me from implementing DLL calling codes to the project. Big Grin | :-D

Re: How to hide the black console window

Pete O'Hanlon25-May-09 23:06

Pete O'Hanlon

25-May-09 23:06

Rajdeep.NET wrote:
How can I hide the black window which appears during the execution of a console application? I want to hide it, becasue I have a program which doesn't accept any user input and just goes on performing some specific tasks which takes quite long time.

Don't run a console application then. If you have an application that doesn't require user interaction, write it as a service instead.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: How to hide the black console window

Rajdeep.NET is BACK25-May-09 23:34

Rajdeep.NET is BACK

25-May-09 23:34

Alright.... I will remember that.

Thanks,
Rajdeep.NET Big Grin | :-D

Re: How to hide the black console window

EliottA26-May-09 2:48

EliottA

26-May-09 2:48

Red flags all over all your posts.

Check out the CodeProject forum Guidelines[^]

Store neutral date in database

Casper Hansen25-May-09 21:33

Casper Hansen

25-May-09 21:33

Hello all

I am building a website and I want to store the current time in a database, thats not a problem.

But I also want to make the time format changable. For example if I have "May 2 2009" stored in the database and I decide I want to change the format to "5/2/2009", I need to either update the database or use a neutral date format that can be converted to the date format I want.

Any tips on this? I thought about using timestamp, but cant rellay see where it fits in

Thanks

Re: Store neutral date in database

stancrm25-May-09 21:35

stancrm

25-May-09 21:35

Just save the datetime in DateTime format in database, not in string.

Re: Store neutral date in database

Casper Hansen25-May-09 21:41

Casper Hansen

25-May-09 21:41

What do you mean?

Re: Store neutral date in database

Eddy Vluggen25-May-09 21:55

Eddy Vluggen

25-May-09 21:55

He means that a datetime is a number[^], and as such, is neutral. To quote;
SQL Server uses 8 bytes to store the datetime data type. The first 4 bytes make up an integer value that represents the number of days since January 1, 1900. The second 4 bytes are an integer value that represents the number of milliseconds since midnight.

When you send a date to the database, do you convert it to a string that get's included in your (text) command? If so, then you can get errors converting from/to the wrong format. If you send it as a number, then it will be interpreted as a "days past since date 1"-number.

Try casting a date to float/integer, and see what happens Smile | :)

I are troll Smile | :)

[Message Deleted]

vishal moharikar25-May-09 20:59

vishal moharikar

25-May-09 20:59

[Message Deleted]

Re: Message Handling in C#

stancrm25-May-09 21:13

stancrm

25-May-09 21:13

If you want to catch the messages, use this in your form class.

protected override void WndProc(ref Message m)
{
  // Do what you want here...
  base.WndProc(ref m);
}

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