how to retrieve file name to be stored in variable

My code as follows

int count = 0;

string connectionstring = "Server=(local);initial catalog=Test;Trusted_Connection=True";

SqlConnection sqlConnection = new SqlConnection(connectionstring);

SqlCommand cmd = new SqlCommand();

SqlDataReader reader;

DataSet ds = new DataSet();

cmd.CommandText = "select * from Empdetails";

cmd.CommandText += " where shifttype = @par ";

cmd.Parameters.Add("@par", SqlDbType.Int).Value = j;

cmd.CommandType = CommandType.Text;

cmd.Connection = sqlConnection;

sqlConnection.Open();

reader = cmd.ExecuteReader();

if (reader.HasRows)

{

string filePath = @"C:\Users\God\Desktop\DataDump\" + j + "Excel.xls";

System.IO.StreamWriter sw_In = new System.IO.StreamWriter(filePath);

while (reader.Read())

{

if (count == 0)

{

for (int i = 0; i < reader.FieldCount; i++)

{

sw_In.AutoFlush = true;

sw_In.Write(reader.GetName(i) + "\t");

}

sw_In.Write("\n");

count = 1;

}

for (int i = 0; i < reader.FieldCount; i++)

{

sw_In.AutoFlush = true;

sw_In.Write(reader[i].ToString() + "\t");

}

sw_In.Write("\n");

}

reader.Close();

sqlConnection.Close();

when i run the above code two excel file is downloaded in desktop under C Folder as follows

1Excel

2Excel

i want the above Excel file name to retrieved and displayed.

for that how can i do to retireve the excel file name and to be displayed

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ketan borsdiya10y ago
Hi Narasiman,
First you need to add referecne below dll,
Microsoft.Office.Interop.Excel.dll
After that put below code when you have to open excel file
Application excel = new Application();
excel.Visible = true;
Workbook wb = excel.Workbooks.Open(filePath);
0
Bikesh Srivastava10y ago
Hi,
try this..
stringfileName=@"C:\mydir\myfile.ext";
stringpath=@"C:\mydir\";
stringresult;
result=Path.GetFileName(fileName);
Console.WriteLine("GetFileName('{0}')returns'{1}'",
fileName,result);
result=Path.GetFileName(path);
Console.WriteLine("GetFileName('{0}')returns'{1}'",
path,result);
0
Midhun Tp10y ago
Hi,
If you just need the filenames why don't you save it in an array and retrieve it whenever needed?
0