File Download Without Using GridView

Thanks alot for patience and reply Akshay Phadke sir.. finally i downloaded as per your idea of  calling report method inside button and separate query .. thank you so much sir..

i called a page it works fine for recently processed file..and i want output in the format as like this screen shot but i cant get this sort of output.

 

i dont know what the mistake i made pls refer this code and say me where i made blender  <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs"

Inherits="projectemailverifier.WebForm2" EnableSessionState="True"%>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<%----%>

code behind for webform2.aspx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace projectemailverifier
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string sqlconstr = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(sqlconstr);
SqlCommand sqlcom = new SqlCommand("select * from PREVTXFILEUPLOAD where User_Id=@user_id");
using (SqlDataAdapter sqlda = new SqlDataAdapter())
{
sqlcom.CommandType = CommandType.Text;
sqlcom.Parameters.AddWithValue("@user_id", 1);
sqlcom.Connection = sqlcon;
sqlcon.Open();
DataTable dt = new DataTable("dt");
sqlda.SelectCommand = sqlcom;
sqlda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

sqlcon.Close();

}
}


protected void grid_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow && GridView1.EditIndex!=e.Row.RowIndex)
{
// e.Row.Cells[0].Text = Session["namefromsession"].ToString();
// Label lblEmail = (Label)e.Row.FindControl("lblfileid");
//lblEmail.Text = Session["emailfromsession"].ToString();
// Label lblEmail = (Label)e.Row.FindControl("lblfileid");
Session["fileid"] = (e.Row.Cells[0].FindControl("lblfileid") as Label).Text;
}

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
string fileid = GridView1.SelectedRow.Cells[0].Text.ToString();
Session["fileid"] = fileid;
//Response.Redirect("~/EditCandidate.aspx");
}

//protected void fnfileid()
//{
// string constr = ConfigurationManager.ConnectionStrings["Sqlconn"].ConnectionString;
// SqlConnection sqlconn = new SqlConnection(constr);
// SqlCommand sqlcomm = new SqlCommand("Select * from prevtxfileupload where User_Id=@user_id");
// using (SqlDataAdapter sqlda = new SqlDataAdapter())
// {
// sqlcomm.CommandType = CommandType.Text;
// sqlcomm.Parameters.AddWithValue("@user_id", Session["User_Id"]);
// sqlcomm.Connection = sqlconn;
// sqlconn.Open();
// Session["fileid"] = sqlcomm.ExecuteScalar();
// sqlconn.Close();
// }
//}
}
} 

C# code : valid.aspx page's code behind

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
namespace projectemailverifier
{
public partial class valid1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//fnfileid();
string constr = ConfigurationManager.ConnectionStrings["Sqlconn"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT distinct Valid_Ids FROM PREVTXUSERVALIDATEDEMAILIDS where User_Id=@user_id and Valid_Ids<>'Temp' and Id=@fid"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
cmd.Parameters.AddWithValue("@user_id", 1);
cmd.Parameters.AddWithValue("@fid", Session["fileid"]);
using (DataTable dt = new DataTable())
{
sda.Fill(dt);

//Build the Text file data.
string txt = string.Empty;

//foreach (DataColumn column in dt.Columns)
//{
// //Add the Header row for Text file.
// txt += column.ColumnName + "\t\t";
//}

//Add new line.
//txt += "\r\n";

foreach (DataRow row in dt.Rows)
{
foreach (DataColumn column in dt.Columns)
{
//Add the Data rows.
txt += row[column.ColumnName].ToString() + "\t\t";
}

//Add new line.
txt += "\r\n";
}

//Download the Text file.
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=Valid_Export.txt");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(txt);
Response.Flush();
Response.End();
}
}
}
}
}
//protected void fnfileid()
//{
// string constr = ConfigurationManager.ConnectionStrings["Sqlconn"].ConnectionString;
// SqlConnection sqlconn = new SqlConnection(constr);
// SqlCommand sqlcomm = new SqlCommand("Select max(Id) from prevtxfileupload where User_Id=@user_id");
// using (SqlDataAdapter sqlda =new SqlDataAdapter())
// {
// sqlcomm.CommandType = CommandType.Text;
// sqlcomm.Parameters.AddWithValue("@user_id", Session["User_Id"]);
// sqlcomm.Connection = sqlconn;
// sqlconn.Open();
// Session["fileid"] = sqlcomm.ExecuteScalar();
// sqlconn.Close();
// }
//}
}
} 

link is ok and thanks for reply .. but i want to download using menu not in linkbutton as shown in the link given by you for reference..