سؤال عن امكانيه اداه الsqldatasource

مافي حل ؟ أستاذ كريم

جرب هذا الكود من غير ادوات خارجية

Response.Clear();

        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

        Response.Charset = "";

        Response.ContentType = "application/vnd.xls";

        StringWriter StringWriter = new System.IO.StringWriter();
        HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);

        Response.ContentEncoding = Encoding.Unicode;
        Response.BinaryWrite(Encoding.Unicode.GetPreamble());

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter("SELECT ActivityId, ActivityNameArabic, ActivityNameEnglish FROM NGO_Activitiy where ActivityId=@ActivityId or @ActivityId=-1", con);

        da.SelectCommand.Parameters.AddWithValue("ActivityId",TextBox1.Text.ToString());
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataGrid dg = new DataGrid();
        dg.DataSource = ds;
        dg.DataBind();
        dg.RenderControl(HtmlTextWriter);

        Response.Write(StringWriter.ToString());

        Response.End();