Re: how to use windows service in another project? - C# Discussion Boards

Re: Please check this code

29-Jun-09 3:11

same error
no change Frown | :(

even i used try catch block.

himanshu256129-Jun-09 3:15

himanshu2561

29-Jun-09 3:15

Hi Have you log your error in log file or somewhere else...
Read error from there and post it.
Also, Do not use window service for this task.

himanshu

himanshu256129-Jun-09 2:47

himanshu2561

29-Jun-09 2:47

Hi if you want to achieve this type of functionality than i suggest you to consider webservice.Using window service you will not achieve this. Moreover,there is no point to keep busy your server by making window service.

himanshu

Narendra Reddy Vajrala29-Jun-09 2:53

29-Jun-09 2:53

ya
actually but i have to do in windows services only.
Frown | :(

J4amieC29-Jun-09 3:00

29-Jun-09 3:00

Narendra Reddy Vajrala wrote:
actually but i have to do in windows services only

why? Says who?

Narendra Reddy Vajrala29-Jun-09 3:05

29-Jun-09 3:05

i cant break my PL orders Frown | :(

himanshu256129-Jun-09 3:09

himanshu2561

29-Jun-09 3:09

who make him PL Confused | :confused:

.
Use web service..

himanshu

J4amieC29-Jun-09 4:21

29-Jun-09 4:21

What is a "PL" and what specifically are their/it's "orders"?

Vikram A Punathambekar29-Jun-09 5:35

Vikram A Punathambekar

29-Jun-09 5:35

Project Lead, sounds like a cretin who's just been promoted into management by virtue of warming the seat for X years and is out to show his minions who's boss.

Cheers,
Vikram.

Recent activities:
TV series: Friends, season 9
Books: Freakonomics, by Steven Levitt and Stephen J Dubner.

Carpe Diem.

J4amieC29-Jun-09 5:46

29-Jun-09 5:46

Ah ok, I guess we have PM's (Project Managers) but they don't get involved with how the thing is written, or Technical Lead's which do. Hence my confusion.

Anyway, he might have a valid reason for wanting to send all database communication through a windows service (ie, single point of caching) but he's obviously not been specific enough on how to communicate with this service for his more junior team members.

can you please check this code?

Vikram A Punathambekar29-Jun-09 3:07

Vikram A Punathambekar

29-Jun-09 3:07

You are confusing web services and Windows services. I suggest you buy a book.

Cheers,
Vikram.

Recent activities:
TV series: Friends, season 9
Books: Freakonomics, by Steven Levitt and Stephen J Dubner.

Carpe Diem.

Narendra Reddy Vajrala29-Jun-09 3:14

Re: can you please check this code?

29-Jun-09 3:14

my code is like this in windows services class

<br />
protected override void OnStart(string[] args)<br />
{<br />
insertValues(3, "Naresh Kumar", "3658213641", "Begumpet, Hyderabad");<br />
}<br />
<br />
public void insertValues(int custId, string custName, string custPhone, string custAdd)<br />
{<br />
string insertCommand = "Insert into CUSTOMER values ( " + custId + ",'" + custName + "','" + custPhone + "','" + custAdd + "')";<br />
con.Open();<br />
cmd = new SqlCommand(insertCommand, con);<br />
cmd.ExecuteNonQuery();<br />
con.Close();<br />
}<br />

when am trying run this service from computer Mangement
is it displaying below alert
"The service on local machine started and stopped. some services stopped automatically if they have no work to do for example the performance logs and alerts service."

please help me out

J4amieC29-Jun-09 4:20

creating excel workbooks from a given template in a particular folder

29-Jun-09 4:20

The reason it stopped automatically is because there is no further work for the service to do once the line insertValue(...) has run.

In general, windows services' OnStart method starts a thread/timer which continues to process until interupted by a Pause or Stop command.

Whatever a "PL" is, he is an idiot, or you have misunderstood his request.

Krishna Aditya29-Jun-09 1:07

Krishna Aditya

29-Jun-09 1:07

Hi,

I have a template in location " c:\excel_temp\template1.xls". This template is a user defined template.

I have to use this template in a browsed location. ( if user selects "d:\temp\" folder, then I have to import the template in " c:\excel_temp" to "d:\temp" folder).

I am trying this with C#. i have done somepart of it

                        string tempPath =   @"D:\Documents and Settings\eob\Desktop\Testing";

                        //System.IO.Directory.CreateDirectory(@tempPath + launchName);

                        //check path exists
                        if (!System.IO.Directory.Exists(@tempPath + launchName))
                        {
                              System.IO.Directory.CreateDirectory(@tempPath + launchName);
                        }

                        System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(@tempPath + launchName);
                        int directoryCount = dir.GetFiles().Length;

                        if (directoryCount != 0)
                        {
                              FileInfo[] fileNames = dir.GetFiles(@tempPath + launchName);
                        }

                        Excel.Application excelFile = new Excel.ApplicationClass();

Now with the excelFile created above, I have to access the template and create an excel file same as the template in the above folder.

I am stuck at this point, pls guide me

Thanks
Ramm

Re: creating excel workbooks from a given template in a particular folder [modified]

padmanabhan N29-Jun-09 1:31

padmanabhan N

29-Jun-09 1:31

Krishna Aditya wrote:
I have a template in location " c:\excel_temp\template1.xls". This template is a user defined template.

I have to use this template in a browsed location. ( if user selects "d:\temp\" folder, then I have to import the template in " c:\excel_temp" to "d:\temp" folder).

for this you can use:
string source = "c:\excel_temp\template1.xls";
string Destination = "d:\temp\Temp.xls";
if (File.Exists(Destination))
{
File.Copy(source, Destination, true);
}

//refer : Word automation (Part 1)[^]

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

modified on Monday, June 29, 2009 7:37 AM

Datagridview Column Header ReadOnly

rhtbhegade28-Jun-09 21:43

rhtbhegade

28-Jun-09 21:43

Hello Experts
I want to make my columnheader Readonly of my datagrid...

stancrm28-Jun-09 21:52

stancrm

28-Jun-09 21:52

what do you want with columnheader readonly ?
do you mean "not clickable and not sortable" ?

rhtbhegade29-Jun-09 1:48

rhtbhegade

29-Jun-09 1:48

Yes i want that it should not be clicked,because when i click header, my control goes in cell click event and executes the code in it and error arises.

stancrm29-Jun-09 2:20

stancrm

29-Jun-09 2:20

private void dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
  // RowIndex = -1 > ColumnHeader clicked
  if(e.RowIndex < 0)
    return;

  // Otherwise, run your code here...
}

rhtbhegade29-Jun-09 2:56

rhtbhegade

29-Jun-09 2:56

Thanks......

padmanabhan N28-Jun-09 22:09

padmanabhan N

28-Jun-09 22:09

rhtbhegade wrote:
columnheader Readonly of my datagrid

what do you mean by readonly... Plz make your question clear so that our experts could give correct suggestions...

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

KIDYA29-Jun-09 1:40

KIDYA

29-Jun-09 1:40

I have also same problem,i want to avoid click on header.then whats procedure?