- published: 18 Apr 2013
- views: 25077
Create your page here
Monday, 03 October 2016
-
remove the playlistExport Gridview To Pdf In Asp.net Part 58
-
remove the playlistLongest Videos
- remove the playlistExport Gridview To Pdf In Asp.net Part 58
- remove the playlistLongest Videos
back to playlist
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-pdf-in-aspnet-part-58.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss about exporting gridview data to PDF.
Step 1: Create an asp.net web application project.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.
Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp. After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.
Step 4: Add the following "USING" statements, in your code-behind file.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;
Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridViewData();
}
}
// ADO.NET code to retrieve data from database
private void BindGridViewData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int columnsCount = GridView1.HeaderRow.Cells.Count;
// Create the PDF Table specifying the number of columns
PdfPTable pdfTable = new PdfPTable(columnsCount);
// Loop thru each cell in GrdiView header row
foreach(TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells)
{
// Create the Font Object for PDF document
Font font = new Font();
// Set the font color to GridView header row font color
font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor);
// Create the PDF cell, specifying the text and font
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font));
// Set the PDF cell backgroundcolor to GridView header row BackgroundColor color
pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor);
// Add the cell to PDF table
pdfTable.AddCell(pdfCell);
}
// Loop thru each datarow in GrdiView
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
if (gridViewRow.RowType == DataControlRowType.DataRow)
{
// Loop thru each cell in GrdiView data row
foreach (TableCell gridViewCell in gridViewRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.RowStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
}
}
// Create the PDF document specifying page size and margins
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
// Roate page using Rotate() function, if you want in Landscape
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
// Using PageSize.A4_LANDSCAPE may not work as expected
// Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f);
PdfWriter.GetInstance(pdfDocument, Response.OutputStream);
pdfDocument.Open();
pdfDocument.Add(pdfTable);
pdfDocument.Close();
Response.ContentType = "application/pdf";
Response.AppendHeader("content-disposition",
"attachment;filename=Employees.pdf");
Response.Write(pdfDocument);
Response.Flush();
Response.End();
}
At this point, run the application and click on the button. The data gets exported to PDF as expected. If you are using Google chrome as your browser, you may get a browser warning stating - this type of file can harm your computer do you want to keep Employees.pdf anyway? This is a know issue with google chrome. Internet explorer, works fine.
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/generate-pdf-document-from-gridview.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Please watch Part 58, before proceeding with this video.
http://www.youtube.com/watch?v=urw4D2fshhc
Step 1: Create an asp.net web application project. Add a folder with name "PDFDocuments" to the project. We will be using this folder to store the dynamically generated pdf document.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.
Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp/. After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.
Step 4: Add the following "USING" statements, in your code-behind file.
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridViewData();
}
}
private void BindGridViewData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
PdfPTable pdfTable = new PdfPTable(GridView1.HeaderRow.Cells.Count);
foreach (TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
foreach (TableCell gridViewCell in gridViewRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.RowStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
}
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
// Roate page using Rotate() function, if you want in Landscape
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
// Using PageSize.A4_LANDSCAPE may not work as expected
// Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f);
PdfWriter.GetInstance(pdfDocument, new FileStream(Server.MapPath("~/PDFDocuments/Employees.pdf"), FileMode.Create));
pdfDocument.Open();
pdfDocument.Add(pdfTable);
pdfDocument.Close();
}
At this point, run the application and click on the button. The data gets exported to a PDF as expected and is stored in the folder "PDFDocuments". Notice that the PDF document, is generated using "Portrait" orientation.
To generate the PDF document in "Landscape" orientation, uncomment the following line
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
Now, run the application and click on the button. The PDF document should be generated in landscape orientation.
- published: 21 Apr 2013
- views: 12937
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-excel-in-aspnet-part.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss about exporting gridview data to excel.
Step 1: Create an asp.net web application project.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Set the following properties of the button control.
ID="btnExportToExcel"
Text="Export to excel"
OnClick="btnExportToExcel_Click"
Step 3: Copy and paste the following code in webform1.aspx.cs. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void btnExportToExcel_Click(object sender, EventArgs e)
{
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=Employees.xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw = new HtmlTextWriter(stringWriter);
// Set white color as the background color for gridview header row
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
// Set background color of each cell of GridView1 header row
foreach (TableCell tableCell in GridView1.HeaderRow.Cells)
{
tableCell.Style["background-color"] = "#A55129";
}
// Set background color of each cell of each data row of GridView1
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
gridViewRow.BackColor = System.Drawing.Color.White;
foreach (TableCell gridViewRowTableCell in gridViewRow.Cells)
{
gridViewRowTableCell.Style["background-color"] = "#FFF7E7";
}
}
GridView1.RenderControl(htw);
Response.Write(stringWriter.ToString());
Response.End();
}
Step 4: Run the application and click on "Export to excel" button. You will get an error stating - Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server. This is because, we are calling GridView1.RenderControl(htmlTextWriter) method. This causes .net to think that a Server-Control is being rendered outside of a Form. To fix this error, we need to override VerifyRenderingInServerForm() method. Copy and paste the following method in webform1.aspx.cs.
public override void VerifyRenderingInServerForm(Control control)
{
}
At this point, run the application and click on "Export to excel button. The data gets exported to excel as expected. However, when you try to open the file you will get a warning message stating - The file you are trying to open, 'Employee.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
According to MSDN - The warning message is a user-notification function that was added to Excel 2007. The warning message can help prevent unexpected problems that might occur because of possible incompatibility between the actual content of the file and the file name extension.
One way to resolve this error, is to edit the registry. Microsoft knowledge base article related to this error
http://support.microsoft.com/kb/948615
If you want to export the same data to microsoft word, there are only 2 changes that you need to do.
First Change: Change the file extension to ".doc" instead of ".xls"
Response.AppendHeader("content-disposition", "attachment; filename=Employees.doc");
Second Change: Set the content type to word
Response.ContentType = "application/word";
- published: 16 Apr 2013
- views: 27550
44.In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how to export gridview data to PDF using asp.net. In asp.net we don’t have direct feature to export gridview data to PDF for that reason here I am using third party library ITextSharp reference. The dll is available here ITextSharp File 1 : (http://sourceforge.net/projects/itextsharp/) File 2 : (http://sourceforge.net/projects/itextsharp/files/xmlworker/) first download dll from this site after that create one new website in visual studio and add ITextsharp dll reference to newly created website after that design aspx page like this
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
- published: 25 Jan 2016
- views: 220
In this topic we are going to see how to retrieve image using file path stored in database to gridview. : http://aj-learning.com/blog/retrieve-image-using-file-path-stored-database-gridview/
For more visit: http://aj-learning.com/
- published: 29 Mar 2014
- views: 6499
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
http://www.youtube.com/user/kudvenkat/playlists
Different techniques to move data from one webform to another
1. Cross Page Postback: Discussed in Part 55 and Part 56
2. Context.Handler object - Discussed in Part 58
3. Query strings - Will be discussed in this session.
The following concepts will be discussed in the subsequent sessions
4. Cookies
5. Session state
6. Application state
Points to remember about query strings
1. Querystrings are name/value collection pairs
2. Using querystrings, is a very comman way to send data from one webform to another.
3. Query strings are appended to the page URL.
4. ?(Question Mark), indicates the beginning of a query string and it's value.
5. It is possible to use more than one query string. The first query string is specified using the ?(question mark). Subsequent query strings can be appended to the URL using the &(ampersand) symbol.
6. There is a limit on the Query string length. Hence, Query strings cannot be used to send very long data.
7. Query strings are visible to the user, hence should not be used to send sensitive information, unless encrypted.
8. To read the query string value, use Request object's QueryString property.
9. &(ampersand) is used to concatenate query strings, so if you want to send &, as value for the query string there are 2 ways, as shown below
Using Server.UrlEncode() method
Response.Redirect("WebForm2.aspx?UserName=" + Server.UrlEncode(txtName.Text) +
"&UserEmail;=" + Server.UrlEncode(txtEmail.Text));
Or
&(ampersand) is encoded as %26, so use, Replace() function to replace & with %26
Response.Redirect("WebForm2.aspx?UserName=" + txtName.Text.Replace("&", "%26") +
"&UserEmail;=" + txtEmail.Text.Replace("&", "%26"));
- published: 29 Nov 2012
- views: 66546
This video illustrates how to only export records that are selected within the DevExpress ASP.NET Grid View (ASPxGridView). Rows can be selected and unselected using corresponding check boxes. To restrict data export, the ASPxGridViewExporter’s ExportedRowType property is set to 'Selected'.
Steps:
- Add gridview to website
- Binding Products table to gridview
Create a new column with FieldName is Total = UnitsInStock * UnitPrice
- Create sum of quantity, unit price in group
- Add two button
- Add gridviewexporter
Done!
Thank for your watching!
https://lqtutorial.com
- published: 10 Jan 2015
- views: 5571
Export
The term export means shipping the goods and services out of the port of a country. The seller of such goods and services is referred to as an "exporter" and is based in the country of export whereas the overseas based buyer is referred to as an "importer". In international trade, "exports" refers to selling goods and services produced in the home country to other markets.
Export of commercial quantities of goods normally requires involvement of the customs authorities in both the country of export and the country of import. The advent of small trades over the internet such as through Amazon and eBay have largely bypassed the involvement of Customs in many countries because of the low individual values of these trades. Nonetheless, these small exports are still subject to legal restrictions applied by the country of export. An export's counterpart is an import.
History
The theory of international trade and commercial policy is one of the oldest branches of economic thought. Exporting is a major component of international trade, and the macroeconomic risks and benefits of exporting are regularly discussed and disputed by economists and others. Two views concerning international trade present different perspectives. The first recognizes the benefits of international trade. The second concerns itself with the possibility that certain domestic industries (or laborers, or culture) could be harmed by foreign competition.
This page contains text from Wikipedia, the Free Encyclopedia -
https://wn.com/Export
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
Portable Document Format
The Portable Document Format (PDF) is a file format used to present documents in a manner independent of application software, hardware, and operating systems. Each PDF file encapsulates a complete description of a fixed-layout flat document, including the text, fonts, graphics, and other information needed to display it. In 1991, Adobe Systems' co-founder John Warnock outlined a system called "Camelot" that developed into PDF.
Adobe Systems made the PDF specification available free of charge in 1993. PDF was a proprietary format controlled by Adobe, until it was officially released as an open standard on July 1, 2008, and published by the International Organization for Standardization as ISO 32000-1:2008, at which time control of the specification passed to an ISO Committee of volunteer industry experts. In 2008, Adobe published a Public Patent License to ISO 32000-1 granting royalty-free rights for all patents owned by Adobe that are necessary to make, use, sell, and distribute PDF compliant implementations. However, there are still some proprietary technologies defined only by Adobe, such as Adobe XML Forms Architecture and JavaScript for Acrobat, which are referenced by ISO 32000-1 as normative and indispensable for the application of the ISO 32000-1 specification. These proprietary technologies are not standardized and their specification is published only on Adobe’s website. The ISO committee is actively standardizing many of these as part of ISO 32000-2.
This page contains text from Wikipedia, the Free Encyclopedia -
https://wn.com/Portable_Document_Format
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
ASP.NET
ASP.NET is an open-sourceserver-side web application framework designed for web development to produce dynamic web pages. It was developed by Microsoft to allow programmers to build dynamic web sites, web applications and web services.
It was first released in January 2002 with version 1.0 of the .NET Framework, and is the successor to Microsoft's Active Server Pages (ASP) technology. ASP.NET is built on the Common Language Runtime (CLR), allowing programmers to write ASP.NET code using any supported .NET language. The ASP.NET SOAP extension framework allows ASP.NET components to process SOAP messages.
ASP.NET is in the process of being re-implemented as a modern and modular web framework, together with other frameworks like Entity Framework. The new framework will make use of the new open-source .NET Compiler Platform (code-name "Roslyn") and be cross platform. ASP.NET MVC, ASP.NET Web API, and ASP.NET Web Pages (a platform using only Razor pages) will merge into a unified MVC 6. The project is called ASP.NET vNext.
This page contains text from Wikipedia, the Free Encyclopedia -
https://wn.com/ASP.NET
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
Asp
Asp may refer to:
Places
Animals
Plants
Science
Other
- Asp baton, expandable baton by ASP, also used as a generic term
This page contains text from Wikipedia, the Free Encyclopedia -
https://wn.com/Asp
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
.net
The domain name net is a generic top-level domain (gTLD) used in the Domain Name System of the Internet. The name is derived from the word network, indicating it was originally intended for organizations involved in networking technologies, such as Internet service providers and other infrastructure companies. However, restrictions were never enforced and the domain is now a general purpose namespace. It is still popular with network operators, the advertising sector, and is often treated as an alternative to com.
net is one of the original top-level domains (the other six being com, us, edu, gov, mil, and org) despite not being mentioned in RFC 920, having been created in January 1985. As of 2015, it is the fourth most popular top-level domain, after .com, .tk and .de.
Verisign, the operator of net after acquiring Network Solutions, held an operations contract that expired on 30 June 2005. ICANN, the organization responsible for domain management, sought proposals from organizations to operate the domain upon expiration of the contract. Verisign regained the contract bid, and secured its control over the net registry for another six years. On 30 June 2011, the contract with Verisign was automatically renewed for another six years. This is because of a resolution approved by the ICANN board, which states that renewal will be automatic as long as Verisign meets certain ICANN requirements.
This page contains text from Wikipedia, the Free Encyclopedia -
https://wn.com/.net
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
This article is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License, which means that you can copy and modify it as long as the entire work (including additions) remains under this license.
- Loading...
-
20:15Export gridview to pdf in asp.net - Part 58
Export gridview to pdf in asp.net - Part 58Export gridview to pdf in asp.net - Part 58
The HTML and the code used in the demo, can be found at the link below. http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-pdf-in-aspnet-part-58.html Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss about exporting gridview data to PDF. Step 1: Create an asp.net web application project. Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method. Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp. After you download the assembly, add a reference to it, from your web application. a) In Solution Explorer, right click on the "References" folder and select "Add Reference" b) Browse to the folder where you have downloaded the assembly and Click OK. Step 4: Add the following "USING" statements, in your code-behind file. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.IO; using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser; Step 5: Copy and paste the following code. The code is well commented and is self-explanatory. protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGridViewData(); } } // ADO.NET code to retrieve data from database private void BindGridViewData() { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } } protected void Button1_Click(object sender, EventArgs e) { int columnsCount = GridView1.HeaderRow.Cells.Count; // Create the PDF Table specifying the number of columns PdfPTable pdfTable = new PdfPTable(columnsCount); // Loop thru each cell in GrdiView header row foreach(TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells) { // Create the Font Object for PDF document Font font = new Font(); // Set the font color to GridView header row font color font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor); // Create the PDF cell, specifying the text and font PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font)); // Set the PDF cell backgroundcolor to GridView header row BackgroundColor color pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor); // Add the cell to PDF table pdfTable.AddCell(pdfCell); } // Loop thru each datarow in GrdiView foreach (GridViewRow gridViewRow in GridView1.Rows) { if (gridViewRow.RowType == DataControlRowType.DataRow) { // Loop thru each cell in GrdiView data row foreach (TableCell gridViewCell in gridViewRow.Cells) { Font font = new Font(); font.Color = new BaseColor(GridView1.RowStyle.ForeColor); PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font)); pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor); pdfTable.AddCell(pdfCell); } } } // Create the PDF document specifying page size and margins Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f); // Roate page using Rotate() function, if you want in Landscape // pdfDocument.SetPageSize(PageSize.A4.Rotate()); // Using PageSize.A4_LANDSCAPE may not work as expected // Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f); PdfWriter.GetInstance(pdfDocument, Response.OutputStream); pdfDocument.Open(); pdfDocument.Add(pdfTable); pdfDocument.Close(); Response.ContentType = "application/pdf"; Response.AppendHeader("content-disposition", "attachment;filename=Employees.pdf"); Response.Write(pdfDocument); Response.Flush(); Response.End(); } At this point, run the application and click on the button. The data gets exported to PDF as expected. If you are using Google chrome as your browser, you may get a browser warning stating - this type of file can harm your computer do you want to keep Employees.pdf anyway? This is a know issue with google chrome. Internet explorer, works fine. -
20:15Export gridview to pdf in asp net
Export gridview to pdf in asp netExport gridview to pdf in asp net
Export gridview to pdf in asp net -
20:1558 Export gridview to pdf in asp net
58 Export gridview to pdf in asp net58 Export gridview to pdf in asp net
-
8:32Generate pdf document from gridview data and store on web server - Part 59
Generate pdf document from gridview data and store on web server - Part 59Generate pdf document from gridview data and store on web server - Part 59
The HTML and the code used in the demo, can be found at the link below. http://csharp-video-tutorials.blogspot.com/2013/04/generate-pdf-document-from-gridview.html Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Please watch Part 58, before proceeding with this video. http://www.youtube.com/watch?v=urw4D2fshhc Step 1: Create an asp.net web application project. Add a folder with name "PDFDocuments" to the project. We will be using this folder to store the dynamically generated pdf document. Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method. Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp/. After you download the assembly, add a reference to it, from your web application. a) In Solution Explorer, right click on the "References" folder and select "Add Reference" b) Browse to the folder where you have downloaded the assembly and Click OK. Step 4: Add the following "USING" statements, in your code-behind file. using iTextSharp.text; using iTextSharp.text.html.simpleparser; using iTextSharp.text.pdf; Step 5: Copy and paste the following code. The code is well commented and is self-explanatory. protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGridViewData(); } } private void BindGridViewData() { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } } protected void Button1_Click(object sender, EventArgs e) { PdfPTable pdfTable = new PdfPTable(GridView1.HeaderRow.Cells.Count); foreach (TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells) { Font font = new Font(); font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor); PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font)); pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor); pdfTable.AddCell(pdfCell); } foreach (GridViewRow gridViewRow in GridView1.Rows) { foreach (TableCell gridViewCell in gridViewRow.Cells) { Font font = new Font(); font.Color = new BaseColor(GridView1.RowStyle.ForeColor); PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font)); pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor); pdfTable.AddCell(pdfCell); } } Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f); // Roate page using Rotate() function, if you want in Landscape // pdfDocument.SetPageSize(PageSize.A4.Rotate()); // Using PageSize.A4_LANDSCAPE may not work as expected // Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f); PdfWriter.GetInstance(pdfDocument, new FileStream(Server.MapPath("~/PDFDocuments/Employees.pdf"), FileMode.Create)); pdfDocument.Open(); pdfDocument.Add(pdfTable); pdfDocument.Close(); } At this point, run the application and click on the button. The data gets exported to a PDF as expected and is stored in the folder "PDFDocuments". Notice that the PDF document, is generated using "Portrait" orientation. To generate the PDF document in "Landscape" orientation, uncomment the following line // pdfDocument.SetPageSize(PageSize.A4.Rotate()); Now, run the application and click on the button. The PDF document should be generated in landscape orientation. -
17:41Export gridview to excel in asp.net - Part 57
Export gridview to excel in asp.net - Part 57Export gridview to excel in asp.net - Part 57
The HTML and the code used in the demo, can be found at the link below. http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-excel-in-aspnet-part.html Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss about exporting gridview data to excel. Step 1: Create an asp.net web application project. Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Set the following properties of the button control. ID="btnExportToExcel" Text="Export to excel" OnClick="btnExportToExcel_Click" Step 3: Copy and paste the following code in webform1.aspx.cs. The code is well commented and is self-explanatory. protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindData(); } } private void BindData() { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } } protected void btnExportToExcel_Click(object sender, EventArgs e) { // Clear all content output from the buffer stream Response.ClearContent(); // Specify the default file name using "content-disposition" RESPONSE header Response.AppendHeader("content-disposition", "attachment; filename=Employees.xls"); // Set excel as the HTTP MIME type Response.ContentType = "application/excel"; // Create an instance of stringWriter for writing information to a string System.IO.StringWriter stringWriter = new System.IO.StringWriter(); // Create an instance of HtmlTextWriter class for writing markup // characters and text to an ASP.NET server control output stream HtmlTextWriter htw = new HtmlTextWriter(stringWriter); // Set white color as the background color for gridview header row GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF"); // Set background color of each cell of GridView1 header row foreach (TableCell tableCell in GridView1.HeaderRow.Cells) { tableCell.Style["background-color"] = "#A55129"; } // Set background color of each cell of each data row of GridView1 foreach (GridViewRow gridViewRow in GridView1.Rows) { gridViewRow.BackColor = System.Drawing.Color.White; foreach (TableCell gridViewRowTableCell in gridViewRow.Cells) { gridViewRowTableCell.Style["background-color"] = "#FFF7E7"; } } GridView1.RenderControl(htw); Response.Write(stringWriter.ToString()); Response.End(); } Step 4: Run the application and click on "Export to excel" button. You will get an error stating - Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server. This is because, we are calling GridView1.RenderControl(htmlTextWriter) method. This causes .net to think that a Server-Control is being rendered outside of a Form. To fix this error, we need to override VerifyRenderingInServerForm() method. Copy and paste the following method in webform1.aspx.cs. public override void VerifyRenderingInServerForm(Control control) { } At this point, run the application and click on "Export to excel button. The data gets exported to excel as expected. However, when you try to open the file you will get a warning message stating - The file you are trying to open, 'Employee.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? According to MSDN - The warning message is a user-notification function that was added to Excel 2007. The warning message can help prevent unexpected problems that might occur because of possible incompatibility between the actual content of the file and the file name extension. One way to resolve this error, is to edit the registry. Microsoft knowledge base article related to this error http://support.microsoft.com/kb/948615 If you want to export the same data to microsoft word, there are only 2 changes that you need to do. First Change: Change the file extension to ".doc" instead of ".xls" Response.AppendHeader("content-disposition", "attachment; filename=Employees.doc"); Second Change: Set the content type to word Response.ContentType = "application/word"; -
45:5444 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
44.In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how to export gridview data to PDF using asp.net. In asp.net we don’t have direct feature to export gridview data to PDF for that reason here I am using third party library ITextSharp reference. The dll is available here ITextSharp File 1 : (http://sourceforge.net/projects/itextsharp/) File 2 : (http://sourceforge.net/projects/itextsharp/files/xmlworker/) first download dll from this site after that create one new website in visual studio and add ITextsharp dll reference to newly created website after that design aspx page like this 44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net -
25:58Retrieve image using file path stored in database to gridview
Retrieve image using file path stored in database to gridviewRetrieve image using file path stored in database to gridview
In this topic we are going to see how to retrieve image using file path stored in database to gridview. : http://aj-learning.com/blog/retrieve-image-using-file-path-stored-database-gridview/ For more visit: http://aj-learning.com/ -
13:56QueryString in asp.net Part 59
QueryString in asp.net Part 59QueryString in asp.net Part 59
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists Different techniques to move data from one webform to another 1. Cross Page Postback: Discussed in Part 55 and Part 56 2. Context.Handler object - Discussed in Part 58 3. Query strings - Will be discussed in this session. The following concepts will be discussed in the subsequent sessions 4. Cookies 5. Session state 6. Application state Points to remember about query strings 1. Querystrings are name/value collection pairs 2. Using querystrings, is a very comman way to send data from one webform to another. 3. Query strings are appended to the page URL. 4. ?(Question Mark), indicates the beginning of a query string and it's value. 5. It is possible to use more than one query string. The first query string is specified using the ?(question mark). Subsequent query strings can be appended to the URL using the &(ampersand) symbol. 6. There is a limit on the Query string length. Hence, Query strings cannot be used to send very long data. 7. Query strings are visible to the user, hence should not be used to send sensitive information, unless encrypted. 8. To read the query string value, use Request object's QueryString property. 9. &(ampersand) is used to concatenate query strings, so if you want to send &, as value for the query string there are 2 ways, as shown below Using Server.UrlEncode() method Response.Redirect("WebForm2.aspx?UserName=" + Server.UrlEncode(txtName.Text) + "&UserEmail;=" + Server.UrlEncode(txtEmail.Text)); Or &(ampersand) is encoded as %26, so use, Replace() function to replace & with %26 Response.Redirect("WebForm2.aspx?UserName=" + txtName.Text.Replace("&", "%26") + "&UserEmail;=" + txtEmail.Text.Replace("&", "%26")); -
24:54[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
This video illustrates how to only export records that are selected within the DevExpress ASP.NET Grid View (ASPxGridView). Rows can be selected and unselected using corresponding check boxes. To restrict data export, the ASPxGridViewExporter’s ExportedRowType property is set to 'Selected'. Steps: - Add gridview to website - Binding Products table to gridview Create a new column with FieldName is Total = UnitsInStock * UnitPrice - Create sum of quantity, unit price in group - Add two button - Add gridviewexporter Done! Thank for your watching! https://lqtutorial.com -
25:41Exportar un GridView a formatos Excel, Word, PDF en Asp.Net
Exportar un GridView a formatos Excel, Word, PDF en Asp.NetExportar un GridView a formatos Excel, Word, PDF en Asp.Net
-
Export gridview to pdf in asp.net - Part 58
The HTML and the code used in the demo, can be found at the link below. http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-pdf-in-aspnet-part-58.html Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss about exporting gridview data to PDF. Step 1: Create an asp.net web application project. Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method. Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/pr...
published: 18 Apr 2013 -
Export gridview to pdf in asp net
Export gridview to pdf in asp net
published: 21 Apr 2014 -
58 Export gridview to pdf in asp net
published: 05 Dec 2015 -
Generate pdf document from gridview data and store on web server - Part 59
The HTML and the code used in the demo, can be found at the link below. http://csharp-video-tutorials.blogspot.com/2013/04/generate-pdf-document-from-gridview.html Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Please watch Part 58, before proceeding with this video. http://www.youtube.com/watch?v=urw4D2fshhc Step 1: Create an asp.net web application project. Add a folder with name "PDFDocuments" to the project. We will be using this folder to store the dynamically generated pdf document. Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler meth...
published: 21 Apr 2013 -
Export gridview to excel in asp.net - Part 57
The HTML and the code used in the demo, can be found at the link below. http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-excel-in-aspnet-part.html Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss about exporting gridview data to excel. Step 1: Create an asp.net web application project. Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Set the following properties of the button control. ID="btnExportToExcel" Text="Export to excel" OnClick="btnExportToExcel_Click" Step 3: Copy and paste the following code in webform1.aspx.cs. The code is well commented and is...
published: 16 Apr 2013 -
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
44.In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how to export gridview data to PDF using asp.net. In asp.net we don’t have direct feature to export gridview data to PDF for that reason here I am using third party library ITextSharp reference. The dll is available here ITextSharp File 1 : (http://sourceforge.net/projects/itextsharp/) File 2 : (http://sourceforge.net/projects/itextsharp/files/xmlworker/) first download dll from this site after that create one new website in visual studio and add ITextsharp dll reference to newly created website after that design aspx page like this 44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
published: 25 Jan 2016 -
Retrieve image using file path stored in database to gridview
In this topic we are going to see how to retrieve image using file path stored in database to gridview. : http://aj-learning.com/blog/retrieve-image-using-file-path-stored-database-gridview/ For more visit: http://aj-learning.com/
published: 29 Mar 2014 -
QueryString in asp.net Part 59
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners http://www.youtube.com/user/kudvenkat/playlists Different techniques to move data from one webform to another 1. Cross Page Postback: Discussed in Part 55 and Part 56 2. Context.Handler object - Discussed in Part 58 3. Query strings - Will be discussed in this session. The following concepts will be discussed in the subsequent sessions 4. Cookies 5. Session state 6. Application state Points to remember about query strings 1. Querystrings are name/value collection pairs 2. Using querystrings, is a very comman way to send data from one webform to another. 3. Query strings are appended to the page URL. 4. ?(Question Mark), indicates the beginning of a query string and it's value. 5. It is possible to use more than one q...
published: 29 Nov 2012 -
[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
This video illustrates how to only export records that are selected within the DevExpress ASP.NET Grid View (ASPxGridView). Rows can be selected and unselected using corresponding check boxes. To restrict data export, the ASPxGridViewExporter’s ExportedRowType property is set to 'Selected'. Steps: - Add gridview to website - Binding Products table to gridview Create a new column with FieldName is Total = UnitsInStock * UnitPrice - Create sum of quantity, unit price in group - Add two button - Add gridviewexporter Done! Thank for your watching! https://lqtutorial.com
published: 10 Jan 2015 -
Exportar un GridView a formatos Excel, Word, PDF en Asp.Net
published: 04 Aug 2015
Export gridview to pdf in asp.net - Part 58
- Order: Reorder
- Duration: 20:15
- Updated: 18 Apr 2013
- views: 25077
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-pdf-in-aspnet-part...
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-pdf-in-aspnet-part-58.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss about exporting gridview data to PDF.
Step 1: Create an asp.net web application project.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.
Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp. After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.
Step 4: Add the following "USING" statements, in your code-behind file.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;
Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridViewData();
}
}
// ADO.NET code to retrieve data from database
private void BindGridViewData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int columnsCount = GridView1.HeaderRow.Cells.Count;
// Create the PDF Table specifying the number of columns
PdfPTable pdfTable = new PdfPTable(columnsCount);
// Loop thru each cell in GrdiView header row
foreach(TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells)
{
// Create the Font Object for PDF document
Font font = new Font();
// Set the font color to GridView header row font color
font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor);
// Create the PDF cell, specifying the text and font
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font));
// Set the PDF cell backgroundcolor to GridView header row BackgroundColor color
pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor);
// Add the cell to PDF table
pdfTable.AddCell(pdfCell);
}
// Loop thru each datarow in GrdiView
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
if (gridViewRow.RowType == DataControlRowType.DataRow)
{
// Loop thru each cell in GrdiView data row
foreach (TableCell gridViewCell in gridViewRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.RowStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
}
}
// Create the PDF document specifying page size and margins
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
// Roate page using Rotate() function, if you want in Landscape
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
// Using PageSize.A4_LANDSCAPE may not work as expected
// Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f);
PdfWriter.GetInstance(pdfDocument, Response.OutputStream);
pdfDocument.Open();
pdfDocument.Add(pdfTable);
pdfDocument.Close();
Response.ContentType = "application/pdf";
Response.AppendHeader("content-disposition",
"attachment;filename=Employees.pdf");
Response.Write(pdfDocument);
Response.Flush();
Response.End();
}
At this point, run the application and click on the button. The data gets exported to PDF as expected. If you are using Google chrome as your browser, you may get a browser warning stating - this type of file can harm your computer do you want to keep Employees.pdf anyway? This is a know issue with google chrome. Internet explorer, works fine.
wn.com/Export Gridview To Pdf In Asp.Net Part 58
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-pdf-in-aspnet-part-58.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss about exporting gridview data to PDF.
Step 1: Create an asp.net web application project.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.
Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp. After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.
Step 4: Add the following "USING" statements, in your code-behind file.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;
Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridViewData();
}
}
// ADO.NET code to retrieve data from database
private void BindGridViewData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int columnsCount = GridView1.HeaderRow.Cells.Count;
// Create the PDF Table specifying the number of columns
PdfPTable pdfTable = new PdfPTable(columnsCount);
// Loop thru each cell in GrdiView header row
foreach(TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells)
{
// Create the Font Object for PDF document
Font font = new Font();
// Set the font color to GridView header row font color
font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor);
// Create the PDF cell, specifying the text and font
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font));
// Set the PDF cell backgroundcolor to GridView header row BackgroundColor color
pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor);
// Add the cell to PDF table
pdfTable.AddCell(pdfCell);
}
// Loop thru each datarow in GrdiView
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
if (gridViewRow.RowType == DataControlRowType.DataRow)
{
// Loop thru each cell in GrdiView data row
foreach (TableCell gridViewCell in gridViewRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.RowStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
}
}
// Create the PDF document specifying page size and margins
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
// Roate page using Rotate() function, if you want in Landscape
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
// Using PageSize.A4_LANDSCAPE may not work as expected
// Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f);
PdfWriter.GetInstance(pdfDocument, Response.OutputStream);
pdfDocument.Open();
pdfDocument.Add(pdfTable);
pdfDocument.Close();
Response.ContentType = "application/pdf";
Response.AppendHeader("content-disposition",
"attachment;filename=Employees.pdf");
Response.Write(pdfDocument);
Response.Flush();
Response.End();
}
At this point, run the application and click on the button. The data gets exported to PDF as expected. If you are using Google chrome as your browser, you may get a browser warning stating - this type of file can harm your computer do you want to keep Employees.pdf anyway? This is a know issue with google chrome. Internet explorer, works fine.
- published: 18 Apr 2013
- views: 25077
Export gridview to pdf in asp net
- Order: Reorder
- Duration: 20:15
- Updated: 21 Apr 2014
- views: 2275
Export gridview to pdf in asp net
Export gridview to pdf in asp net
wn.com/Export Gridview To Pdf In Asp Net
Export gridview to pdf in asp net
- published: 21 Apr 2014
- views: 2275
58 Export gridview to pdf in asp net
- Order: Reorder
- Duration: 20:15
- Updated: 05 Dec 2015
- views: 23
- published: 05 Dec 2015
- views: 23
Generate pdf document from gridview data and store on web server - Part 59
- Order: Reorder
- Duration: 8:32
- Updated: 21 Apr 2013
- views: 12937
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/generate-pdf-document-from-gridview.h...
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/generate-pdf-document-from-gridview.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Please watch Part 58, before proceeding with this video.
http://www.youtube.com/watch?v=urw4D2fshhc
Step 1: Create an asp.net web application project. Add a folder with name "PDFDocuments" to the project. We will be using this folder to store the dynamically generated pdf document.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.
Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp/. After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.
Step 4: Add the following "USING" statements, in your code-behind file.
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridViewData();
}
}
private void BindGridViewData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
PdfPTable pdfTable = new PdfPTable(GridView1.HeaderRow.Cells.Count);
foreach (TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
foreach (TableCell gridViewCell in gridViewRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.RowStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
}
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
// Roate page using Rotate() function, if you want in Landscape
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
// Using PageSize.A4_LANDSCAPE may not work as expected
// Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f);
PdfWriter.GetInstance(pdfDocument, new FileStream(Server.MapPath("~/PDFDocuments/Employees.pdf"), FileMode.Create));
pdfDocument.Open();
pdfDocument.Add(pdfTable);
pdfDocument.Close();
}
At this point, run the application and click on the button. The data gets exported to a PDF as expected and is stored in the folder "PDFDocuments". Notice that the PDF document, is generated using "Portrait" orientation.
To generate the PDF document in "Landscape" orientation, uncomment the following line
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
Now, run the application and click on the button. The PDF document should be generated in landscape orientation.
wn.com/Generate Pdf Document From Gridview Data And Store On Web Server Part 59
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/generate-pdf-document-from-gridview.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Please watch Part 58, before proceeding with this video.
http://www.youtube.com/watch?v=urw4D2fshhc
Step 1: Create an asp.net web application project. Add a folder with name "PDFDocuments" to the project. We will be using this folder to store the dynamically generated pdf document.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.
Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itextsharp/. After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.
Step 4: Add the following "USING" statements, in your code-behind file.
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridViewData();
}
}
private void BindGridViewData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
PdfPTable pdfTable = new PdfPTable(GridView1.HeaderRow.Cells.Count);
foreach (TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
foreach (TableCell gridViewCell in gridViewRow.Cells)
{
Font font = new Font();
font.Color = new BaseColor(GridView1.RowStyle.ForeColor);
PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font));
pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor);
pdfTable.AddCell(pdfCell);
}
}
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
// Roate page using Rotate() function, if you want in Landscape
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
// Using PageSize.A4_LANDSCAPE may not work as expected
// Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f);
PdfWriter.GetInstance(pdfDocument, new FileStream(Server.MapPath("~/PDFDocuments/Employees.pdf"), FileMode.Create));
pdfDocument.Open();
pdfDocument.Add(pdfTable);
pdfDocument.Close();
}
At this point, run the application and click on the button. The data gets exported to a PDF as expected and is stored in the folder "PDFDocuments". Notice that the PDF document, is generated using "Portrait" orientation.
To generate the PDF document in "Landscape" orientation, uncomment the following line
// pdfDocument.SetPageSize(PageSize.A4.Rotate());
Now, run the application and click on the button. The PDF document should be generated in landscape orientation.
- published: 21 Apr 2013
- views: 12937
Export gridview to excel in asp.net - Part 57
- Order: Reorder
- Duration: 17:41
- Updated: 16 Apr 2013
- views: 27550
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-excel-in-aspnet-pa...
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-excel-in-aspnet-part.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss about exporting gridview data to excel.
Step 1: Create an asp.net web application project.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Set the following properties of the button control.
ID="btnExportToExcel"
Text="Export to excel"
OnClick="btnExportToExcel_Click"
Step 3: Copy and paste the following code in webform1.aspx.cs. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void btnExportToExcel_Click(object sender, EventArgs e)
{
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=Employees.xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw = new HtmlTextWriter(stringWriter);
// Set white color as the background color for gridview header row
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
// Set background color of each cell of GridView1 header row
foreach (TableCell tableCell in GridView1.HeaderRow.Cells)
{
tableCell.Style["background-color"] = "#A55129";
}
// Set background color of each cell of each data row of GridView1
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
gridViewRow.BackColor = System.Drawing.Color.White;
foreach (TableCell gridViewRowTableCell in gridViewRow.Cells)
{
gridViewRowTableCell.Style["background-color"] = "#FFF7E7";
}
}
GridView1.RenderControl(htw);
Response.Write(stringWriter.ToString());
Response.End();
}
Step 4: Run the application and click on "Export to excel" button. You will get an error stating - Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server. This is because, we are calling GridView1.RenderControl(htmlTextWriter) method. This causes .net to think that a Server-Control is being rendered outside of a Form. To fix this error, we need to override VerifyRenderingInServerForm() method. Copy and paste the following method in webform1.aspx.cs.
public override void VerifyRenderingInServerForm(Control control)
{
}
At this point, run the application and click on "Export to excel button. The data gets exported to excel as expected. However, when you try to open the file you will get a warning message stating - The file you are trying to open, 'Employee.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
According to MSDN - The warning message is a user-notification function that was added to Excel 2007. The warning message can help prevent unexpected problems that might occur because of possible incompatibility between the actual content of the file and the file name extension.
One way to resolve this error, is to edit the registry. Microsoft knowledge base article related to this error
http://support.microsoft.com/kb/948615
If you want to export the same data to microsoft word, there are only 2 changes that you need to do.
First Change: Change the file extension to ".doc" instead of ".xls"
Response.AppendHeader("content-disposition", "attachment; filename=Employees.doc");
Second Change: Set the content type to word
Response.ContentType = "application/word";
wn.com/Export Gridview To Excel In Asp.Net Part 57
The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/export-gridview-to-excel-in-aspnet-part.html
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss about exporting gridview data to excel.
Step 1: Create an asp.net web application project.
Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Set the following properties of the button control.
ID="btnExportToExcel"
Text="Export to excel"
OnClick="btnExportToExcel_Click"
Step 3: Copy and paste the following code in webform1.aspx.cs. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
protected void btnExportToExcel_Click(object sender, EventArgs e)
{
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=Employees.xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw = new HtmlTextWriter(stringWriter);
// Set white color as the background color for gridview header row
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
// Set background color of each cell of GridView1 header row
foreach (TableCell tableCell in GridView1.HeaderRow.Cells)
{
tableCell.Style["background-color"] = "#A55129";
}
// Set background color of each cell of each data row of GridView1
foreach (GridViewRow gridViewRow in GridView1.Rows)
{
gridViewRow.BackColor = System.Drawing.Color.White;
foreach (TableCell gridViewRowTableCell in gridViewRow.Cells)
{
gridViewRowTableCell.Style["background-color"] = "#FFF7E7";
}
}
GridView1.RenderControl(htw);
Response.Write(stringWriter.ToString());
Response.End();
}
Step 4: Run the application and click on "Export to excel" button. You will get an error stating - Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server. This is because, we are calling GridView1.RenderControl(htmlTextWriter) method. This causes .net to think that a Server-Control is being rendered outside of a Form. To fix this error, we need to override VerifyRenderingInServerForm() method. Copy and paste the following method in webform1.aspx.cs.
public override void VerifyRenderingInServerForm(Control control)
{
}
At this point, run the application and click on "Export to excel button. The data gets exported to excel as expected. However, when you try to open the file you will get a warning message stating - The file you are trying to open, 'Employee.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
According to MSDN - The warning message is a user-notification function that was added to Excel 2007. The warning message can help prevent unexpected problems that might occur because of possible incompatibility between the actual content of the file and the file name extension.
One way to resolve this error, is to edit the registry. Microsoft knowledge base article related to this error
http://support.microsoft.com/kb/948615
If you want to export the same data to microsoft word, there are only 2 changes that you need to do.
First Change: Change the file extension to ".doc" instead of ".xls"
Response.AppendHeader("content-disposition", "attachment; filename=Employees.doc");
Second Change: Set the content type to word
Response.ContentType = "application/word";
- published: 16 Apr 2013
- views: 27550
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
- Order: Reorder
- Duration: 45:54
- Updated: 25 Jan 2016
- views: 220
44.In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how...
44.In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how to export gridview data to PDF using asp.net. In asp.net we don’t have direct feature to export gridview data to PDF for that reason here I am using third party library ITextSharp reference. The dll is available here ITextSharp File 1 : (http://sourceforge.net/projects/itextsharp/) File 2 : (http://sourceforge.net/projects/itextsharp/files/xmlworker/) first download dll from this site after that create one new website in visual studio and add ITextsharp dll reference to newly created website after that design aspx page like this
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
wn.com/44 How To Export Gridview Data To Pdf Using Asp Net Or Export Gridview Data To Pdf Using Asp Net
44.In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how to export gridview data to PDF using asp.net. In asp.net we don’t have direct feature to export gridview data to PDF for that reason here I am using third party library ITextSharp reference. The dll is available here ITextSharp File 1 : (http://sourceforge.net/projects/itextsharp/) File 2 : (http://sourceforge.net/projects/itextsharp/files/xmlworker/) first download dll from this site after that create one new website in visual studio and add ITextsharp dll reference to newly created website after that design aspx page like this
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
- published: 25 Jan 2016
- views: 220
Retrieve image using file path stored in database to gridview
- Order: Reorder
- Duration: 25:58
- Updated: 29 Mar 2014
- views: 6499
In this topic we are going to see how to retrieve image using file path stored in database to gridview. : http://aj-learning.com/blog/retrieve-image-using-file-...
In this topic we are going to see how to retrieve image using file path stored in database to gridview. : http://aj-learning.com/blog/retrieve-image-using-file-path-stored-database-gridview/
For more visit: http://aj-learning.com/
wn.com/Retrieve Image Using File Path Stored In Database To Gridview
In this topic we are going to see how to retrieve image using file path stored in database to gridview. : http://aj-learning.com/blog/retrieve-image-using-file-path-stored-database-gridview/
For more visit: http://aj-learning.com/
- published: 29 Mar 2014
- views: 6499
QueryString in asp.net Part 59
- Order: Reorder
- Duration: 13:56
- Updated: 29 Nov 2012
- views: 66546
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
http://www.youtube.com/user/kudvenkat/playlists
Different techniques to move data from one ...
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
http://www.youtube.com/user/kudvenkat/playlists
Different techniques to move data from one webform to another
1. Cross Page Postback: Discussed in Part 55 and Part 56
2. Context.Handler object - Discussed in Part 58
3. Query strings - Will be discussed in this session.
The following concepts will be discussed in the subsequent sessions
4. Cookies
5. Session state
6. Application state
Points to remember about query strings
1. Querystrings are name/value collection pairs
2. Using querystrings, is a very comman way to send data from one webform to another.
3. Query strings are appended to the page URL.
4. ?(Question Mark), indicates the beginning of a query string and it's value.
5. It is possible to use more than one query string. The first query string is specified using the ?(question mark). Subsequent query strings can be appended to the URL using the &(ampersand) symbol.
6. There is a limit on the Query string length. Hence, Query strings cannot be used to send very long data.
7. Query strings are visible to the user, hence should not be used to send sensitive information, unless encrypted.
8. To read the query string value, use Request object's QueryString property.
9. &(ampersand) is used to concatenate query strings, so if you want to send &, as value for the query string there are 2 ways, as shown below
Using Server.UrlEncode() method
Response.Redirect("WebForm2.aspx?UserName=" + Server.UrlEncode(txtName.Text) +
"&UserEmail;=" + Server.UrlEncode(txtEmail.Text));
Or
&(ampersand) is encoded as %26, so use, Replace() function to replace & with %26
Response.Redirect("WebForm2.aspx?UserName=" + txtName.Text.Replace("&", "%26") +
"&UserEmail;=" + txtEmail.Text.Replace("&", "%26"));
wn.com/Querystring In Asp.Net Part 59
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
http://www.youtube.com/user/kudvenkat/playlists
Different techniques to move data from one webform to another
1. Cross Page Postback: Discussed in Part 55 and Part 56
2. Context.Handler object - Discussed in Part 58
3. Query strings - Will be discussed in this session.
The following concepts will be discussed in the subsequent sessions
4. Cookies
5. Session state
6. Application state
Points to remember about query strings
1. Querystrings are name/value collection pairs
2. Using querystrings, is a very comman way to send data from one webform to another.
3. Query strings are appended to the page URL.
4. ?(Question Mark), indicates the beginning of a query string and it's value.
5. It is possible to use more than one query string. The first query string is specified using the ?(question mark). Subsequent query strings can be appended to the URL using the &(ampersand) symbol.
6. There is a limit on the Query string length. Hence, Query strings cannot be used to send very long data.
7. Query strings are visible to the user, hence should not be used to send sensitive information, unless encrypted.
8. To read the query string value, use Request object's QueryString property.
9. &(ampersand) is used to concatenate query strings, so if you want to send &, as value for the query string there are 2 ways, as shown below
Using Server.UrlEncode() method
Response.Redirect("WebForm2.aspx?UserName=" + Server.UrlEncode(txtName.Text) +
"&UserEmail;=" + Server.UrlEncode(txtEmail.Text));
Or
&(ampersand) is encoded as %26, so use, Replace() function to replace & with %26
Response.Redirect("WebForm2.aspx?UserName=" + txtName.Text.Replace("&", "%26") +
"&UserEmail;=" + txtEmail.Text.Replace("&", "%26"));
- published: 29 Nov 2012
- views: 66546
[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
- Order: Reorder
- Duration: 24:54
- Updated: 10 Jan 2015
- views: 5571
This video illustrates how to only export records that are selected within the DevExpress ASP.NET Grid View (ASPxGridView). Rows can be selected and unselected ...
This video illustrates how to only export records that are selected within the DevExpress ASP.NET Grid View (ASPxGridView). Rows can be selected and unselected using corresponding check boxes. To restrict data export, the ASPxGridViewExporter’s ExportedRowType property is set to 'Selected'.
Steps:
- Add gridview to website
- Binding Products table to gridview
Create a new column with FieldName is Total = UnitsInStock * UnitPrice
- Create sum of quantity, unit price in group
- Add two button
- Add gridviewexporter
Done!
Thank for your watching!
https://lqtutorial.com
wn.com/Devexpress Asp.Net Devexpress Gridview Export Selected Records To Pdf, Xls...
This video illustrates how to only export records that are selected within the DevExpress ASP.NET Grid View (ASPxGridView). Rows can be selected and unselected using corresponding check boxes. To restrict data export, the ASPxGridViewExporter’s ExportedRowType property is set to 'Selected'.
Steps:
- Add gridview to website
- Binding Products table to gridview
Create a new column with FieldName is Total = UnitsInStock * UnitPrice
- Create sum of quantity, unit price in group
- Add two button
- Add gridviewexporter
Done!
Thank for your watching!
https://lqtutorial.com
- published: 10 Jan 2015
- views: 5571
Exportar un GridView a formatos Excel, Word, PDF en Asp.Net
- Order: Reorder
- Duration: 25:41
- Updated: 04 Aug 2015
- views: 1498
- published: 04 Aug 2015
- views: 1498
-
How to export database data to PDF file in ASP.NET
For Complete Step by Step Tutorial and source code visit : http://dotnetawesome.blogspot.com/2014/02/how-to-export-database-data-to-pdf-file-using-aspnet.html
published: 07 Feb 2014 -
How to upload and download files using asp net and c# Part 139
Link for code samples used in the demo http://csharp-video-tutorials.blogspot.com/2013/08/how-to-upload-and-download-files-using.html Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists In this video, we will discuss 1. Uploading files 2. Displaying the list of files that are already uploaded 3. Downloading files When the files are uploaded, they should be uploaded to a folder on the web server. In our case, we will be uploading to "Data" folder. WebForm1.aspx code: [div style="font-family:Arial"] [asp:FileUpload ID="FileUpload1" runat="server" /] [asp:Button ID="Button1" runat="server" Text="Upload" OnClick="Button1_Click" /] [br /] [br /] [asp:GridView ID="GridView1" runat="server" AutoGene...
published: 11 Aug 2013 -
How to export database data to PDF file in ASP.NET
- Order: Reorder
- Duration: 21:42
- Updated: 07 Feb 2014
- views: 19367
For Complete Step by Step Tutorial and source code visit :
http://dotnetawesome.blogspot.com/2014/02/how-to-export-database-data-to-pdf-file-using-aspnet.html...
For Complete Step by Step Tutorial and source code visit :
http://dotnetawesome.blogspot.com/2014/02/how-to-export-database-data-to-pdf-file-using-aspnet.html
wn.com/How To Export Database Data To Pdf File In Asp.Net
For Complete Step by Step Tutorial and source code visit :
http://dotnetawesome.blogspot.com/2014/02/how-to-export-database-data-to-pdf-file-using-aspnet.html
- published: 07 Feb 2014
- views: 19367
How to upload and download files using asp net and c# Part 139
- Order: Reorder
- Duration: 24:16
- Updated: 11 Aug 2013
- views: 83620
Link for code samples used in the demo
http://csharp-video-tutorials.blogspot.com/2013/08/how-to-upload-and-download-files-using.html
Link for csharp, asp.net,...
Link for code samples used in the demo
http://csharp-video-tutorials.blogspot.com/2013/08/how-to-upload-and-download-files-using.html
Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss
1. Uploading files
2. Displaying the list of files that are already uploaded
3. Downloading files
When the files are uploaded, they should be uploaded to a folder on the web server. In our case, we will be uploading to "Data" folder.
WebForm1.aspx code:
[div style="font-family:Arial"]
[asp:FileUpload ID="FileUpload1" runat="server" /]
[asp:Button ID="Button1" runat="server" Text="Upload"
OnClick="Button1_Click" /]
[br /]
[br /]
[asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
OnRowCommand="GridView1_RowCommand" BackColor="White"
BorderColor="#CC9966" BorderStyle="None"
BorderWidth="1px" CellPadding="4"]
[Columns]
[asp:TemplateField HeaderText="File" ShowHeader="False"]
[ItemTemplate]
[asp:LinkButton ID="LinkButton1" runat="server"
CausesValidation="False"
CommandArgument='[%# Eval("File") %]'
CommandName="Download" Text='[%# Eval("File") %]']
[/asp:LinkButton]
[/ItemTemplate]
[/asp:TemplateField]
[asp:BoundField DataField="Size" HeaderText="Size in Bytes" /]
[asp:BoundField DataField="Type" HeaderText="File Type" /]
[/Columns]
[FooterStyle BackColor="#FFFFCC" ForeColor="#330099" /]
[HeaderStyle BackColor="#990000" Font-Bold="True"
ForeColor="#FFFFCC" /]
[PagerStyle BackColor="#FFFFCC" ForeColor="#330099"
HorizontalAlign="Center" /]
[RowStyle BackColor="White" ForeColor="#330099" /]
[SelectedRowStyle BackColor="#FFCC66" Font-Bold="True"
ForeColor="#663399" /]
[SortedAscendingCellStyle BackColor="#FEFCEB" /]
[SortedAscendingHeaderStyle BackColor="#AF0101" /]
[SortedDescendingCellStyle BackColor="#F6F0C0" /]
[SortedDescendingHeaderStyle BackColor="#7E0000" /]
[/asp:GridView]
[/div]
WebForm1.aspx.cs code:
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName;
FileUpload1.PostedFile
.SaveAs(Server.MapPath("~/Data/") + fileName);
}
DataTable dt = new DataTable();
dt.Columns.Add("File");
dt.Columns.Add("Size");
dt.Columns.Add("Type");
foreach (string strfile in Directory.GetFiles(Server.MapPath("~/Data")))
{
FileInfo fi = new FileInfo(strfile);
dt.Rows.Add(fi.Name, fi.Length.ToString(),
GetFileTypeByExtension(fi.Extension));
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
private string GetFileTypeByExtension(string fileExtension)
{
switch (fileExtension.ToLower())
{
case ".docx":
case ".doc":
return "Microsoft Word Document";
case ".xlsx":
case ".xls":
return "Microsoft Excel Document";
case ".txt":
return "Text Document";
case ".jpg":
case ".png":
return "Image";
default:
return "Unknown";
}
}
protected void GridView1_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "Download")
{
Response.Clear();
Response.ContentType = "application/octect-stream";
Response.AppendHeader("content-disposition", "filename="
+ e.CommandArgument);
Response.TransmitFile(Server.MapPath("~/Data/")
+ e.CommandArgument);
Response.End();
}
}
Please make sure to include the following using declarations in the code behind file.
using System.IO;
using System.Data;
Make sure to replace [ with LESSTHAN and ] with GREATERTHAN symbol.
wn.com/How To Upload And Download Files Using Asp Net And C Part 139
Link for code samples used in the demo
http://csharp-video-tutorials.blogspot.com/2013/08/how-to-upload-and-download-files-using.html
Link for csharp, asp.net, ado.net, dotnet basics, mvc and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
In this video, we will discuss
1. Uploading files
2. Displaying the list of files that are already uploaded
3. Downloading files
When the files are uploaded, they should be uploaded to a folder on the web server. In our case, we will be uploading to "Data" folder.
WebForm1.aspx code:
[div style="font-family:Arial"]
[asp:FileUpload ID="FileUpload1" runat="server" /]
[asp:Button ID="Button1" runat="server" Text="Upload"
OnClick="Button1_Click" /]
[br /]
[br /]
[asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
OnRowCommand="GridView1_RowCommand" BackColor="White"
BorderColor="#CC9966" BorderStyle="None"
BorderWidth="1px" CellPadding="4"]
[Columns]
[asp:TemplateField HeaderText="File" ShowHeader="False"]
[ItemTemplate]
[asp:LinkButton ID="LinkButton1" runat="server"
CausesValidation="False"
CommandArgument='[%# Eval("File") %]'
CommandName="Download" Text='[%# Eval("File") %]']
[/asp:LinkButton]
[/ItemTemplate]
[/asp:TemplateField]
[asp:BoundField DataField="Size" HeaderText="Size in Bytes" /]
[asp:BoundField DataField="Type" HeaderText="File Type" /]
[/Columns]
[FooterStyle BackColor="#FFFFCC" ForeColor="#330099" /]
[HeaderStyle BackColor="#990000" Font-Bold="True"
ForeColor="#FFFFCC" /]
[PagerStyle BackColor="#FFFFCC" ForeColor="#330099"
HorizontalAlign="Center" /]
[RowStyle BackColor="White" ForeColor="#330099" /]
[SelectedRowStyle BackColor="#FFCC66" Font-Bold="True"
ForeColor="#663399" /]
[SortedAscendingCellStyle BackColor="#FEFCEB" /]
[SortedAscendingHeaderStyle BackColor="#AF0101" /]
[SortedDescendingCellStyle BackColor="#F6F0C0" /]
[SortedDescendingHeaderStyle BackColor="#7E0000" /]
[/asp:GridView]
[/div]
WebForm1.aspx.cs code:
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName;
FileUpload1.PostedFile
.SaveAs(Server.MapPath("~/Data/") + fileName);
}
DataTable dt = new DataTable();
dt.Columns.Add("File");
dt.Columns.Add("Size");
dt.Columns.Add("Type");
foreach (string strfile in Directory.GetFiles(Server.MapPath("~/Data")))
{
FileInfo fi = new FileInfo(strfile);
dt.Rows.Add(fi.Name, fi.Length.ToString(),
GetFileTypeByExtension(fi.Extension));
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
private string GetFileTypeByExtension(string fileExtension)
{
switch (fileExtension.ToLower())
{
case ".docx":
case ".doc":
return "Microsoft Word Document";
case ".xlsx":
case ".xls":
return "Microsoft Excel Document";
case ".txt":
return "Text Document";
case ".jpg":
case ".png":
return "Image";
default:
return "Unknown";
}
}
protected void GridView1_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "Download")
{
Response.Clear();
Response.ContentType = "application/octect-stream";
Response.AppendHeader("content-disposition", "filename="
+ e.CommandArgument);
Response.TransmitFile(Server.MapPath("~/Data/")
+ e.CommandArgument);
Response.End();
}
}
Please make sure to include the following using declarations in the code behind file.
using System.IO;
using System.Data;
Make sure to replace [ with LESSTHAN and ] with GREATERTHAN symbol.
- published: 11 Aug 2013
- views: 83620
How to Export Webgrid to PDF in asp.net MVC4 Application
- Order: Reorder
- Duration: 26:17
- Updated: 01 Aug 2014
- views: 6636
back
- Playlist
- Chat
back
- Playlist
- Chat
20:15
Export gridview to pdf in asp.net - Part 58
The HTML and the code used in the demo, can be found at the link below.
http://csharp-vide...
published: 18 Apr 2013
Export gridview to pdf in asp.net - Part 58
Export gridview to pdf in asp.net - Part 58
- Report rights infringement
- published: 18 Apr 2013
- views: 25077
20:15
Export gridview to pdf in asp net
Export gridview to pdf in asp net
published: 21 Apr 2014
Export gridview to pdf in asp net
Export gridview to pdf in asp net
- Report rights infringement
- published: 21 Apr 2014
- views: 2275
20:15
58 Export gridview to pdf in asp net
published: 05 Dec 2015
58 Export gridview to pdf in asp net
58 Export gridview to pdf in asp net
- Report rights infringement
- published: 05 Dec 2015
- views: 23
8:32
Generate pdf document from gridview data and store on web server - Part 59
The HTML and the code used in the demo, can be found at the link below.
http://csharp-vide...
published: 21 Apr 2013
Generate pdf document from gridview data and store on web server - Part 59
Generate pdf document from gridview data and store on web server - Part 59
- Report rights infringement
- published: 21 Apr 2013
- views: 12937
17:41
Export gridview to excel in asp.net - Part 57
The HTML and the code used in the demo, can be found at the link below.
http://csharp-vide...
published: 16 Apr 2013
Export gridview to excel in asp.net - Part 57
Export gridview to excel in asp.net - Part 57
- Report rights infringement
- published: 16 Apr 2013
- views: 27550
45:54
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
44.In my previous articles I explained clearly how to export gridview data to excel or wor...
published: 25 Jan 2016
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
44 How To Export GridView Data To PDF Using Asp Net Or Export GridView Data To PDF Using Asp Net
- Report rights infringement
- published: 25 Jan 2016
- views: 220
25:58
Retrieve image using file path stored in database to gridview
In this topic we are going to see how to retrieve image using file path stored in database...
published: 29 Mar 2014
Retrieve image using file path stored in database to gridview
Retrieve image using file path stored in database to gridview
- Report rights infringement
- published: 29 Mar 2014
- views: 6499
13:56
QueryString in asp.net Part 59
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
http://www.youtube.com...
published: 29 Nov 2012
QueryString in asp.net Part 59
QueryString in asp.net Part 59
- Report rights infringement
- published: 29 Nov 2012
- views: 66546
24:54
[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
This video illustrates how to only export records that are selected within the DevExpress ...
published: 10 Jan 2015
[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
[Devexpress Asp.net] Devexpress gridview export selected records to pdf, xls...
- Report rights infringement
- published: 10 Jan 2015
- views: 5571
25:41
Exportar un GridView a formatos Excel, Word, PDF en Asp.Net
published: 04 Aug 2015
Exportar un GridView a formatos Excel, Word, PDF en Asp.Net
Exportar un GridView a formatos Excel, Word, PDF en Asp.Net
- Report rights infringement
- published: 04 Aug 2015
- views: 1498
back
- Playlist
- Chat
21:42
How to export database data to PDF file in ASP.NET
For Complete Step by Step Tutorial and source code visit :
http://dotnetawesome.blogspot...
published: 07 Feb 2014
How to export database data to PDF file in ASP.NET
How to export database data to PDF file in ASP.NET
- Report rights infringement
- published: 07 Feb 2014
- views: 19367
24:16
How to upload and download files using asp net and c# Part 139
Link for code samples used in the demo
http://csharp-video-tutorials.blogspot.com/2013/08/...
published: 11 Aug 2013
How to upload and download files using asp net and c# Part 139
How to upload and download files using asp net and c# Part 139
- Report rights infringement
- published: 11 Aug 2013
- views: 83620
26:17
How to Export Webgrid to PDF in asp.net MVC4 Application
Step Bt Step : http://dotnetawesome.blogspot.com/2014/08/how-to-export-webgrid-to-pdf-in-m...
published: 01 Aug 2014
How to Export Webgrid to PDF in asp.net MVC4 Application
How to Export Webgrid to PDF in asp.net MVC4 Application
- Report rights infringement
- published: 01 Aug 2014
- views: 6636
How to export database data to PDF file in ASP.NET...
How to upload and download files using asp net and...
How to Export Webgrid to PDF in asp.net MVC4 Appli...
photo: AP / Christophe Ena
Kim Kardashian held up at gunpoint by fake police officers in Paris hotel room
Edit Belfast Telegraph 03 Oct 2016
Kim Kardashian has been held up at gunpoint in a Paris hotel room by masked men dressed as police officers. Her spokeswoman said the reality TV star "is badly shaken but physically unharmed" but offered no other details. Share Go To. Kardashian has been in Paris for fashion week, and attended the Givenchy show on Sunday evening ... The Meadows Music and Arts Festival sent out a tweet saying ... ....
photo: AP / OMN
52 confirmed dead in stampede at Ethiopia religious event
Edit Boston Herald 02 Oct 2016
BISHOFTU, Ethiopia — Dozens of people were crushed to death Sunday in a stampede after police fired tear gas and rubber bullets to disperse an anti-government protest that grew out of a massive religious festival, witnesses said. The Oromia regional government confirmed the death toll at 52. "I almost died in that place today," said one shaken protester who gave his name only as Elias ... The first to fall in had suffocated, he said ... ....
photo: AP / Artyom Korotayev
Russia-Baiting and Risks of Nuclear War
Edit Antiwar 03 Oct 2016
As U.S. and Russian officials trade barbed threats and as diplomacy on Syria is “on the verge” of extinction, it is tempting to view the ongoing propaganda exchange over who shot down Malaysia Airlines Flight 17 in July 2014 as a sideshow ... Adult input is sorely needed. There are advantages to having some hands-on experience, and having watched how propaganda wars can easily escalate to military confrontation. In a Sept ... Goodman wrote....
photo: US DoS
Philippine President Rodrigo Duterte to order review of defense pact with US
Edit Zeenews 03 Oct 2016
Philippine President Rodrigo Duterte said on Sunday that he will order a review of the 2014 Enhanced Defense Cooperation Agreement (EDCA) between his country and the US. Duterte made the remarks at a local festival in Bacolod City in central Philippines, Xinhua reported ... ....
photo: Public Domain
Woman Gives Birth To One Of The Biggest Babies Ever Born (Photos)
Edit Opposing Views 02 Oct 2016
A British mother recounted her story of giving birth to one of the country's largest babies to be born naturally. Charlotte Hawthorn from Wirral, England, gave birth to Rory, who at 12-pounds, 7-ounces, weighed approximately twice as much as most newborns. "I planned a natural delivery not knowing he was going to be twice the size of most newborns," Hawthorn said. "He is gorgeous, we call him our little hunky chunky." ... ....
« back to news headlines
U.K. Factories Boom as Pound’s Brexit Plunge Boosts Exports
Edit Bloomberg 03 Oct 2016
factories had their best month in more than two years in September as the weaker pound sent export orders surging ... Export orders increased the most since January 2014 in September, and Markit said manufacturing probably helped to lift GDP in the three months....
OPEC daily basket price stood at $44.63 a barrel Friday, 30 September 2016 (OPEC - Organization of the Petroleum Exporting Countries)
Edit Public Technologies 03 Oct 2016
OPEC - Organization of the Petroleum Exporting Countries) ... OPEC - Organization of the Petroleum Exporting Countries published this content on 03 October 2016 and is solely responsible for the information contained herein....
Oil Halts Gains as U.S. Adds Rigs While Iran Seeks Export Boost
Edit Bloomberg 03 Oct 2016
drillers added more rigs and Iran signaled it’s seeking to raise exports. Futures fell as much as 0.8 percent in New York, paring the 8 percent advance following the agreement by the Organization of Petroleum Exporting Countries Wednesday to trim production for the first time in eight years ... Iran wants to increase exports to 2.35 million ......
New report finds UK loses out on £141bn due to SME export shortfall
Edit World First 03 Oct 2016
A new report commissioned by World First, an international money transfer and FX expert, has found that the UK is losing out on a potential £141.3bn[ii] – more than the combined UK Government budgets for health and defence in 2015/16 – because of the SME export gap ... Yet despite this renewed focus on new markets and trade, the report found that only 5% of UK SMEs have plans to start exporting in the next five years[iii]....
Tokyo stocks close higher as weaker yen lifts exporters, concerns ease about Deutsche Bank
Edit Xinhua 03 Oct 2016
TOKYO, Oct ... dollar lifted investor sentiment and sent exporter issues higher, while easing concerns about Deutsche Bank's financial predicament added to an upbeat market mood ... dollars) ... ....
New report finds UK loses out on £141bn due to SME export shortfall (World First UK Ltd)
Edit Public Technologies 03 Oct 2016
A new report commissioned by World First, an international money transfer and FX expert, has found that the UK is losing out on a potential £141.3bn[ii] - more than the combined UK Government budgets for health and defence in 2015/16 - because of the SME export gap ... Yet despite this renewed focus on new markets and trade, the report found that only 5% of UK SMEs have plans to start exporting in the next five years[iii]....
Receipt of payment for KRI oil exports (Genel Energy plc)
Edit Public Technologies 03 Oct 2016
(Source. Genel Energy plc). 3 October 2016 ... Receipt of payment for KRI oil exports from Tawke field ... Tawke production in July averaged 117,992 bopd, of which 117,579 bopd were earmarked for export. This was up from June production levels of 114,384 bopd, of which 113,601 bopd were earmarked for export. An amount of $8.41 million remains outstanding from the Kurdistan Regional Government for Tawke June deliveries to the export market ... GENL)....
Exporters Lead U.K. Stocks Higher as Pound Slides on Brexit Date
Edit Bloomberg 03 Oct 2016
British stocks climbed for the third time in four days as a weaker pound boosted revenue prospects for exporters after Prime Minister Theresa May said the country will begin to exit the European Union next year. Companies that get most of their sales outside the U.K ... in London ... LEARN MORE. ....
Three champions crowned in Oklahoma City as the 2016 Slow Pitch Championship Series comes to end (ASA/USA Softball)
Edit Public Technologies 03 Oct 2016
ASP/KV Weld/BHR was crowned the Men's Class A Slow Pitch National Champion following back-to-back wins over T's 13/DeMarini while OTW/Elite forced DCL to an if-game and claimed the title after a 14-11 win. The Women's Open Championship was also decided with an if-necessary game as Derby Girls/ASP/Combat handed Khaos two straight losses, taking the Women's Open Championship with an 8-1 win....
Deputy President Cyril Ramaphosa arrives in Vietnam for a Diplomatic Working Visit from 03-04 October 2016 (The Presidency of the Republic of South Africa)
Edit Public Technologies 03 Oct 2016
By 2015 South African imports from Vietnam amounted to R16.3 billion from R11.5 billion in 2014 while exports are at R2.3 billion in 2015 from R1.9 billion in 2014 thus creating trade deficit for South Africa to the tune of R13 ... Original documenthttp.//www.thepresidency.gov.za/pebble.asp?relid=22793....
Strong kiwi could hit star exports
Edit NZ Herald 03 Oct 2016
The stubborn strength of the New Zealand dollar could be the major hurdle for the agriculture sector in the months ahead, as positive signs for dairying, sheepmeat and wine take shape.Rabobank's agribusiness monthly report for September... ....
- 1
- 2
- 3
- 4
- 5
- Next page »
