Store datatable value in excel sheet and that excel sheet should be save on perticular drive

See more:

C#

Store datatable data on excel sheet and this excel sheet save on particular drive of my PC like on D:

i have to do following code but the excel sheet save on Download folder of my PC.

How i would to save it on D: ?

What I have tried:

protected void btndatatabletoexcel_Click(object sender, EventArgs e)
{
objtestBO.Id = 1;
objtestBO.Name = txtnm.Text;
objtestBO.City = txtcity.ToString();
int result = objtestBL.Insert_test(objtestBO);
if (result > 0)
{
u.MsgThenRedirectTo(objtestBO.Name + " Added Successfully!!", "datatabletoexcel");
DataTable dt = new DataTable();
dt = objtestBL.Selecttest();
UploadDataTableToExcel(dt);
}
}

protected void UploadDataTableToExcel(DataTable dtRecords)
{
string XlsPath = Server.MapPath(@"~/Add_data/test.xls");
string attachment = string.Empty;
if (XlsPath.IndexOf("\\") != -1)
{
string[] strFileName = XlsPath.Split(new char[] { '\\' });
attachment = "attachment; filename=" + strFileName[strFileName.Length - 1];
}
else
attachment = "attachment; filename=" + XlsPath;
try
{
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = string.Empty;

foreach (DataColumn datacol in dtRecords.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");

foreach (DataRow dr in dtRecords.Rows)
{
tab = "";
for (int j = 0; j < dtRecords.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}

Response.Write("\n");
}
Response.End();
}
catch (Exception ex)
{
//Response.Write(ex.Message);
}
}