C#

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

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

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

rhtbhegade wrote:

columnheader Readonly of my datagrid