如何在ASP.NET 3.5 C#中使用Crystal Report在ASP.NET中打印单个记录

亲爱的朋友，

我的网页上有GRIDVIEW，并在数据库中正常显示数据.

我在其中有一个使用选择按钮= TRUE的命令字段.

Dear Friends,

I have a GRIDVIEW on my webpage and displayed data in it from database its working fine.

I have a Command Field in it with Select Button = TRUE.

<Columns>

<asp:CommandField ShowSelectButton="True"/>

  </Columns>

代码页
=========

code Page
=========

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("ClearanceNumber");
        dt.Columns.Add("CodeTrainId");
        dt.Columns.Add("DateLastChange");
        dt.Columns.Add("DateValidFrom");
        dt.Columns.Add("DateValidTo");
        dt.Columns.Add("ReservationNo");
        dt.Columns.Add("TrainType");
        dt.Columns.Add("CityCode");
        dt.Columns.Add("Days");

        DataRow dataRow;
        dataRow = dt.NewRow();

        for (int i = 0; i < dataRow.Table.Columns.Count; i++)
        {
            dataRow[i] = GridView1.SelectedRow.Cells[i + 1].Text;
            GridView1.Rows[0].Cells[0].BackColor = System.Drawing.Color.Blue;
        }

        dt.Rows.Add(dataRow);
        Session["dataTable"] = dt;

        Response.Redirect("Selected.aspx");
}

假设，如果我在Gridview中单击此选择"按钮，它将重定向到另一个页面.并且仅显示选定记录"，并且当单击打印"按钮时，它正在打印所有gridview记录.所以我不想这样.



我的要求是::


当我单击Gridview中的选择"按钮时，该特定行必须插入到Sqlserver 2005数据库中的另一个表中.为此，我创建了一个新表来插入此行.

我将使用此新表来打印特定记录的Crystal报表.


请帮帮我，

Suppose, If i click this Select button in Gridview, it Redirects to another page. and Displays only Selected Record and when Print button clicks it is printing all the gridview Records. SO I DONT WANT THIS.



MY REQUIREMENT IS : :


When i Click the Select Button in Gridview, that particular row must INSERT into Another Table in Sqlserver 2005 Database. for this i have Created a New table to Insert this Row.

This New Table I Will Use for Crystal Reports for Printing that Particular Record.


Please help me,

Thanks in ADVANCE.