public void ProcessRequest(HttpContext context)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
Web oWeb = new Web();
//cProductosContrato oProductosContrato = new cProductosContrato(ref oConn);
//oProductosContrato.NumContrato = oWeb.GetData("pCodContrato");
//DataTable dtProdCont = oProductosContrato.GetByExcel();
cRoyaltyContrato oRoyaltyContrato = new cRoyaltyContrato(ref oConn);
oRoyaltyContrato.NumContrato = oWeb.GetData("pCodContrato");
DataTable dtProdCont = oRoyaltyContrato.GetByExcel();
oConn.Close();
System.Web.HttpResponse oResponse = System.Web.HttpContext.Current.Response;
oResponse.Clear();
oResponse.AddHeader("content-disposition", "attachment;filename=FileName.csv");
oResponse.Charset = "";
oResponse.Cache.SetCacheability(HttpCacheability.NoCache);
oResponse.ContentType = "application/vnd.ms-excel";
oResponse.Output.Write(ToCSV(dtProdCont));
oResponse.Flush();
oResponse.End();
}
}
protected void rdRoyaltyBDI_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cRoyaltyContrato RoyaltyContrato = new cRoyaltyContrato(ref oConn);
RoyaltyContrato.NumContrato = num_contrato.Value;
rdRoyaltyBDI.DataSource = RoyaltyContrato.GetByExcel();
}
oConn.Close();
}
