C#

swetha_insoft wrote:

Textbox is having 3 lines
how to get lines count?

WindowsService1.Service1 winService = new WindowsService1.Service1();<br />
            winService.insertValues(txtcustId.Text, txtcustName.Text, txtcustPhone.Text, txtcustAddress.Text);

<br />
Error 2 The type 'System.ServiceProcess.ServiceBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. C:\Inetpub\wwwroot\WindowsFormsApplication1\WindowsFormsApplication1\Form1.cs 451 13 WindowsFormsApplication1<br />

<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 />

Narendra Reddy Vajrala wrote:

"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.

Narendra Reddy Vajrala wrote:

actually but i have to do in windows services only

<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 />

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