Working with Excel - C# Discussion Boards

First Prev Next

Re: passwords

V.14-Jun-07 4:16

14-Jun-07 4:16

thanks, but wanted to it programmatically... Smile | :)

.
We can't tell the user to this... Poke tongue | ;-P

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Re: passwords

V.14-Jun-07 4:16

14-Jun-07 4:16

thanks, but wanted to do it programmatically... Smile | :)

.
We can't tell the user to this... Poke tongue | ;-P

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Re: passwords

Dave Kreskowiak14-Jun-07 7:12

Dave Kreskowiak

14-Jun-07 7:12

V. wrote:
Is it possible to get the logged on users pa

Nope.

V. wrote:
restart a windows service under the windows logon accou

You have to supply the username AND PASSWORD in order to do this. The only way to get the users password is to ask for it and have them type it in. Then you can restart the service.

But, in the case of Windows XP, you can have multiple users logged in on the machine at any time. How is your service going to handle this situation? You really can't stop the service and change the account every time someone logs in.

If you have a process that needs to run under the users account, create your application as a normal console or Windows Forms .EXE and put a shortcut to it in the Startup folder. The app runs under the users security context when the user logs in.

A guide to posting questions on CodeProject[^]

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

Re: passwords

V.14-Jun-07 20:28

14-Jun-07 20:28

Thanks for the reply.

Dave Kreskowiak wrote:
If you have a process that needs to run under the users account, create your application as a normal console or Windows Forms .EXE and put a shortcut to it in the Startup folder. The app runs under the users security context when the user logs in.

Unfortunately it's not that easy, there is more to it then that.

we're searching in an entirely different direction now... Smile | :)

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

add button to form next maximise minimize buttons

hamid_m14-Jun-07 3:11

hamid_m

14-Jun-07 3:11

how can i add new button next to maximize or minimize buttons (on border of form)

Re: add button to form next maximise minimize buttons

Tarakeshwar Reddy14-Jun-07 3:35

Tarakeshwar Reddy

14-Jun-07 3:35

Take at a look at these articles
Minimize to Tray button[^]
Add Transparent Menus and XP Titlebar Buttons to your application[^]

Problem while Writing to Remote Location in a .netThread

VishalSharmaDev14-Jun-07 3:02

VishalSharmaDev

14-Jun-07 3:02

hi
i am having problem when i am trying to write something on remote location using .net thread.
e.g. i have a central location letsay MachineName|MachineIP/SharedDrive.
and i am creating a thread on click of a button which i need to write some information on that location.

i have also added a node <identity impersonate="true" username="Domain\User" password="*******"> in web.config of my application.

and i have also given credential in <machine.config>--<processmodel enable="true" username="SameInWeb.Config" password="SameInWeb.Config">

but it is giving the following exception:
The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.

below is my method which i am calling on a separate thread.
private void WriteSomeThingToRemoteLocation ()

{
FileStream fileStream = null;
BinaryFormatter binaryFormatter = null;
System.Object systemObject = null;
System.Object obj = new object();
lock ( obj )
{
string _contractLocaterKey = Guid.NewGuid().ToString().Replace( "-", "" );

string fullPath = @"\\MyMachineIP\SharedDrive" + "\\" + _contractLocaterKey + ".dat";
try
{
fileStream = new FileStream( fullPath, FileMode.CreateNew, FileAccess.Write );
binaryFormatter = new BinaryFormatter();

systemObject = new object();
systemObject = "Hello this is testing1";
binaryFormatter.Serialize( fileStream, systemObject );

systemObject = new object();
systemObject = "Hello this is testing2";
binaryFormatter.Serialize( fileStream, systemObject );
}
// catch(Exception ex)
// {
// avoided for getting noticed what happened;
// }
finally
{
if ( fileStream != null )
{
fileStream.Close();
fileStream = null;
}
binaryFormatter = null;
systemObject = null;
}
}
}

please help in this matter as i am stucking in the problem from more than 3 days.

this thing is happening OK :
1. if i call this method directly on another method.
2. if i call this method in a console application .
3. if i call this method on a thread in a console application.

any help would be highly appreciated.

thanks

vishal sharma

Thanks & Regards

Vishal Sharma
vishalsharma556@yahoo.co.in

Working with Excel

A M SOMAN14-Jun-07 2:47

A M SOMAN

14-Jun-07 2:47

I have a VB 6 code with me. The code is playing with excel. It generates worksheets and adds templates to them, sets cell values, etc. I want to rewrite the entire code into C#.Net. For that I have used Microsoft Excel 11.0 COM reference. (This is same in VB6). The problem is that I cannot find code in C#.Net equivalent to VB6 counterpart. Examples are given below:
oBook.Worksheets("General")
or this
oSheet.Rows(2).Copy oSheet.Rows(i)
There are many examples like this.
Either I don't know how to write this in .Net or there is no equivalent.

Does anybody know, where I can learn how to use Excel in .Net 2003 in good amount of depth so that I can convert any code in VB6 to .Net 2003?

Regards
Anil

Re: Working with Excel

JoeSharp14-Jun-07 2:55

JoeSharp

14-Jun-07 2:55

hi anil

look at this example

http://www.codeproject.com/office/package.asp

regards

Re: Working with Excel

A M SOMAN14-Jun-07 3:10

A M SOMAN

14-Jun-07 3:10

Joe,

Thanks! That was a nice article. That solved my Worksheet("abc") problem.

Regards,
Anil

Databinding in FormView

souravmoy sau14-Jun-07 2:30

souravmoy sau

14-Jun-07 2:30

In any web application in C# how we can view/edit/delete some data in the FormView control without using any databaseobject control like sqldatasource,objectdatasource .We want to connect the FormView control with sql databse by writing code in codebehind(like using DataSet).
Waiting for reply......

priyabrata

Re: Databinding in FormView

Deepayan Nandi23-Oct-09 10:36

Deepayan Nandi

23-Oct-09 10:36

hey

i am also looking for the same solution that u r stuck wid ....
i want to hard code form behind in my code behind without using databaseobjects ....
i 'vl inform if i find a solution ... kindly share if u find d way to do it ...

thanx

deepayan

Copy a directory somewhere

Russell^'14-Jun-07 1:46

Russell^'

14-Jun-07 1:46

Simple question. Smile | :)

Is there a command to copy a directory in a different path without doing this manually on files and sub-directory contained there?
I've not found any copy command on System::IO::Directory ... it's strange! Confused | :confused:

Thank you

Russell

Re: Copy a directory somewhere

Manas Bhardwaj14-Jun-07 1:48

Manas Bhardwaj

14-Jun-07 1:48

If you wanna move the directory, use Directory.Move
Rose | [Rose]

Re: Copy a directory somewhere

Russell^'14-Jun-07 1:52

Russell^'

14-Jun-07 1:52

No, .... sorry...I want to copy it Cry | :((

Russell

Re: Copy a directory somewhere

Giorgi Dalakishvili14-Jun-07 1:55

Giorgi Dalakishvili

14-Jun-07 1:55

Do you want to copy subfolders too?

my articles

Re: Copy a directory somewhere

Russell^'14-Jun-07 2:04

Russell^'

14-Jun-07 2:04

yes...like MS-DOS command xcopy does.
Of course, I can use directly that command, ... but I'm trying to understand if there is an implemented function that does this copy that I still not know.
Thank you

Russell

Re: Copy a directory somewhere

Giorgi Dalakishvili14-Jun-07 2:12

Giorgi Dalakishvili

14-Jun-07 2:12

As fas as I know there is not such built-in function but if you search codeproject for xcopy you will find what you need.

my articles

Re: Copy a directory somewhere

Manas Bhardwaj14-Jun-07 1:59

Manas Bhardwaj

14-Jun-07 1:59

To my knowledge, I feel you will need to iterate and copy each file. D'Oh! | :doh:

Re: Copy a directory somewhere

Shy Agam14-Jun-07 2:13

Shy Agam

14-Jun-07 2:13

You have to write you own recursive procedure...

Regards,
Shy.

Re: Copy a directory somewhere

Martin#14-Jun-07 2:25

Martin#

14-Jun-07 2:25

Hello,

I think you are looking fot this[^]

All the best,

Martin

Re: Copy a directory somewhere

David Knechtges14-Jun-07 2:34

David Knechtges

14-Jun-07 2:34

Another idea for you is to do a simple hack - use the Process class and start a process using the xcopy command like you mentioned in some of your other posts.

I actually have done this in a build app I wrote.

I've also used the process class for doing FTP and LPR (using the built-in Windows commands, since there are no easy classes in the framework for this).

David

convert cyrillic from console app to Unicode C#

drweb8614-Jun-07 1:16

drweb86

14-Jun-07 1:16

Hi
I have already wrote about my problem. I have a string that comes from console app

after it i convert it with this procedure

static private string EncodeMessageForConsoleOutput(string Message)
{
//gag
if (MemoLog == null)
return Message;

if (EncodingFrom.CodePage == EncodingTo.CodePage)
return Message;

Decoder decoder = Encoding.UTF8.GetDecoder();
byte[] bytes = Encoding.UTF8.GetBytes(Message);
char[] chars = new char[bytes.Length * 5];//*2

int bytesUsed, charsUsed;
bool completed;

decoder.Convert(bytes, 0, bytes.Length,
chars, 0, chars.Length, true,
out bytesUsed, out charsUsed, out completed);

string ResultString = new string(chars, 0, charsUsed);

return ResultString;
}

but it does not work

Could you help me
what's the problem with this code?

How to compare two Times [modified]

VenkataRamana.Gali14-Jun-07 1:08

VenkataRamana.Gali

14-Jun-07 1:08

Hello all,

how to compare two times using DateTime object. I need to compare hours & minutes only based on this i am showing some message.

plz help me

regards
GV Ramana

Re: How to compare two Times

Mali Perica14-Jun-07 1:30

Mali Perica

14-Jun-07 1:30

For hours and minutes only, without dates and seconds:

DateTime first;
DateTime second;

if (first.Hour > second.Hour)
{
    //first is later
}
else
    if (first.Hour == second.Hour)
        if (first.Minute > second.Minute)
        {
            //first is later
        }
        else
            if (first.Minute == second.Minute)
            {
                //they are the same
            }
            else
            {
                //second is later
            }
    else
    {
        //second is later
    }

Last Visit: 31-Dec-99 18:00 Last Update: 12-May-24 6:21

Refresh

ᐊ Prev 1...9149 9150 9151 915291539154 9155 9156 9157 9158 Next ᐅ

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