Devexpress gridview导出器不会将数据从网格视图导出为pdf [英] Devexpress gridview exporter doesn't export data from grid view to pdf

问题描述

大家好，

我使用下面这段代码来检索特定月份的数据，我将这个gridview数据导出为pdf格式。但是网格视图正在显示数据，但它没有导出为pdf format.please帮帮我...

或者我必须在sqldatasource中自定义查询，以便我将sqldatasource绑定到gridview来检索数据....

请帮助我...





代码是：

Hi all,
Im using this below code to retrieve the data of particular month and I am exporting this gridview data into pdf format.But grid view is displaying data but it is not exporting to pdf format.please help me...
Or I have to custom query to in sqldatasource so that I will bind sqldatasource to gridview to retrieve the data....
Please help me...


Code is:

protected void FillBookingDataset()
     {
         DateTime firstDate = new DateTime(Calendar1.VisibleDate.Year,
      Calendar1.VisibleDate.Month, 1);
         DateTime lastDate = GetFirstDayOfNextMonth();
         dsBooking = GetCurrentMonthData(firstDate, lastDate);
     }

     protected DateTime GetFirstDayOfNextMonth()
     {
         int monthNumber, yearNumber;
         if (Calendar1.VisibleDate.Month == 12)
         {
             monthNumber = 1;
             yearNumber = Calendar1.VisibleDate.Year + 1;
         }
         else
         {
             monthNumber = Calendar1.VisibleDate.Month + 1;
             yearNumber = Calendar1.VisibleDate.Year;
         }
         DateTime lastDate = new DateTime(yearNumber, monthNumber, 1);
         return lastDate;
     }
     public override void VerifyRenderingInServerForm(Control control)
     {
         /* Verifies that the control is rendered */
     }


     protected DataSet GetCurrentMonthData(DateTime firstDate,
          DateTime lastDate)
     {
         DataSet dsMonth = new DataSet();
         ConnectionStringSettings cs;
         cs = ConfigurationManager.ConnectionStrings["BuckshawHomesConnectionString"];
         String connString = cs.ConnectionString;
         SqlConnection dbConnection = new SqlConnection(connString);
         dbConnection.Open();

         String query;
         query = "SELECT HouseID,BookingID,PersonTitle,fName,sName,Address1,Address2,Address3,City,Postcode,Country,Mobile,SpecialRequirements, CheckinDate,CheckoutDate,Price,AmountPaid,ReviewRequested,timeoutDate,IsPending,County FROM tblBooking " +
             " WHERE CheckinDate >= @firstDate AND CheckinDate < @lastDate";
         SqlCommand dbCommand = new SqlCommand(query, dbConnection);
         dbCommand.Parameters.Add(new SqlParameter("@firstDate",
             firstDate));
         dbCommand.Parameters.Add(new SqlParameter("@lastDate", lastDate));

         SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(dbCommand);
         sqlDataAdapter.Fill(dsMonth);

         //ASPxGridView1.DataSourceID = "SqlDataSourceMonth";
         ASPxGridView1.DataSource = dsMonth;
         ASPxGridView1.DataBind();
         dbConnection.Close();
         //try
         //{
         //    sqlDataAdapter.Fill(dsMonth);
         //}
         //catch { }
         return dsMonth;

     }

推荐答案

这篇关于Devexpress gridview导出器不会将数据从网格视图导出为pdf的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！