My code as follows
private void Preseaintake()
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Presea_Intakerpts '" + dtfromdate.Text.Trim() + "', '" + dttodate.Text.Trim() + "'";
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
string filename = "E:\\Preseaintake\\10032014_PreseaIntakedetails.xls";
System.IO.StreamWriter file = new System.IO.StreamWriter(filename);
file.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK);
return;
}
}
i have written a store procecdure, that store procedure value has been binded using datatable.
Now i wan to bind the datatable records into excel.
for that how can i do using c#.
Please help me.
regards,
Narasiman P.