Click here to Skip to main content
   

C#

 
Questionwhat is the meaning of this? Syntax error in UPDATE statement. Pinmemberkruczynski12316-Mar-13 19:43 
AnswerRe: what is the meaning of this? Syntax error in UPDATE statement. PinmemberPIEBALDconsult16-Mar-13 20:23 
AnswerRe: what is the meaning of this? Syntax error in UPDATE statement. PinmvpRichard MacCutchan16-Mar-13 23:11 
AnswerRe: what is the meaning of this? Syntax error in UPDATE statement. PinmvpOriginalGriff16-Mar-13 23:54 
GeneralRe: what is the meaning of this? Syntax error in UPDATE statement. PinmemberPIEBALDconsult17-Mar-13 11:45 
AnswerRe: what is the meaning of this? Syntax error in UPDATE statement. PinmvpAbhinav S18-Mar-13 7:37 
QuestionConnection between two forms in a project Pinmembercoolvibhu16-Mar-13 7:18 
AnswerRe: Connection between two forms in a project PinmemberThePhantomUpvoter16-Mar-13 7:36 
AnswerRe: Connection between two forms in a project PinmvpOriginalGriff16-Mar-13 7:40 
QuestionListBox datasource is not updated on first click Pinmemberzulfakar16-Mar-13 4:24 
AnswerRe: ListBox datasource is not updated on first click PinmemberJegan Thiyagesan16-Mar-13 14:31 
GeneralRe: ListBox datasource is not updated on first click Pinmemberzulfakar17-Mar-13 9:24 
GeneralRe: ListBox datasource is not updated on first click [modified] PinmemberJegan Thiyagesan18-Mar-13 4:50 
QuestionExporting Gridview with fixed number of rows on each page PinmemberAlexRusso16-Mar-13 2:18 
Hello everyone,
 
I need to export gridview data in pdf where suppose i have 50 records...so first 10 records should come in 1st page...next 11 to 20 in next page...so on..
 
here is my code:
 
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);

StringReader sr = new StringReader(sw.ToString());
 

Document document = new Document(PageSize.A4, 0, 0, 50, 50);
 
HTMLWorker htmlparser = new HTMLWorker(document);
 
PdfWriter writer = PdfWriter.GetInstance(document, Response.OutputStream);
document.Open();
htmlparser.Parse(sr);
 
iTextSharp.text.Table datatable = new iTextSharp.text.Table(columns, tableRows);
datatable.BorderWidth = 1;
datatable.BorderColor = new Color(0, 0, 255);
datatable.Cellpadding = 3;
datatable.Cellspacing = 3;

 
String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);

 

Cell c2 = new Cell(this.GridView1.Columns[0].HeaderText);
datatable.AddCell(c2);
datatable.AddCell(this.GridView1.Columns[1].HeaderText);
datatable.AddCell(this.GridView1.Columns[2].HeaderText);
datatable.AddCell(this.GridView1.Columns[3].HeaderText);
 
for (int rowCounter = 0; rowCounter < rows; rowCounter++)
{

 
for (int columnCounter = 0; columnCounter < columns; columnCounter++)
{
 
string strValue = GridView1.Rows[rowCounter].Cells[1].Text;
datatable.AddCell(strValue);

}
if (rowCounter > 0)
{
document.Add(datatable);
document.NewPage();
}
 

 
}

document.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment; filename=GridViewwithPagebreak.pdf");
Response.Write(document);
Response.End();
 

anyone have idea...how to do that?? what changes i have to make??
AnswerRe: Exporting Gridview with fixed number of rows on each page PinmvpEddy Vluggen16-Mar-13 13:06 
GeneralRe: Exporting Gridview with fixed number of rows on each page PinmemberAlexRusso18-Mar-13 1:57 
GeneralRe: Exporting Gridview with fixed number of rows on each page PinmvpEddy Vluggen18-Mar-13 2:29 
QuestionFilesystemwatcher causes exception. Pinmemberleone15-Mar-13 7:32 
AnswerRe: Filesystemwatcher causes exception. PinmemberJibesh15-Mar-13 7:53 
GeneralRe: Filesystemwatcher causes exception. Pinmemberleone15-Mar-13 12:03 
GeneralRe: Filesystemwatcher causes exception. PinmemberJibesh15-Mar-13 12:09 
GeneralRe: Filesystemwatcher causes exception. PinmvpDave Kreskowiak15-Mar-13 13:44 
AnswerRe: Filesystemwatcher causes exception. PinmvpEddy Vluggen15-Mar-13 8:47 
QuestionC# file exists on network drive Pinmemberclassy_dog15-Mar-13 3:44 
AnswerRe: C# file exists on network drive Pinmembers_magus15-Mar-13 4:07 
GeneralRe: C# file exists on network drive PinmvpRichard MacCutchan15-Mar-13 8:19 
GeneralRe: C# file exists on network drive PinmvpEddy Vluggen15-Mar-13 8:48 
GeneralRe: C# file exists on network drive PinmvpRichard MacCutchan15-Mar-13 8:56 
GeneralRe: C# file exists on network drive PinmvpEddy Vluggen15-Mar-13 9:07 
AnswerRe: C# file exists on network drive PinmvpRichard MacCutchan15-Mar-13 8:28 
GeneralRe: C# file exists on network drive Pinmemberclassy_dog15-Mar-13 9:28 
QuestionIf existing String Form name, get that by database then open PinmemberJayantha Bandara15-Mar-13 1:37 
AnswerRe: If existing String Form name, get that by database then open PinmvpRichard MacCutchan15-Mar-13 2:02 
AnswerRe: If existing String Form name, get that by database then open PinprotectorPete O'Hanlon15-Mar-13 2:12 
GeneralRe: If existing String Form name, get that by database then open PinmemberV.15-Mar-13 4:44 
GeneralRe: If existing String Form name, get that by database then open PinmemberMycroft Holmes15-Mar-13 14:39 
QuestionResolving dependent projects PinmemberBernhard Hiller15-Mar-13 1:15 
AnswerRe: Resolving dependent projects PinprotectorPete O'Hanlon15-Mar-13 2:38 
Questionsubstring from form1 to form2.... PinmemberGoaty6510914-Mar-13 18:15 
AnswerRe: substring from form1 to form2.... PinmemberJibesh14-Mar-13 18:35 
GeneralRe: substring from form1 to form2.... PinmemberGoaty6510914-Mar-13 19:57 
QuestionBlueTooth Bytes Disappearing PinmemberC-P-User-314-Mar-13 14:03 
QuestionView in Nhibernate Pinmemberhadi_ganji14-Mar-13 7:06 
AnswerRe: View in Nhibernate - Repost PinmvpRichard MacCutchan14-Mar-13 7:24 
QuestionUnable to set registry value Pinmembersjs4u13-Mar-13 22:27 
AnswerRe: Unable to set registry value Pinmemberdusty_dex14-Mar-13 6:07 
QuestionHow to use CreateTextServices in C# Pinmembercpw999cn13-Mar-13 21:32 
AnswerRe: How to use CreateTextServices in C# PinmemberBernhard Hiller13-Mar-13 23:01 
GeneralRe: How to use CreateTextServices in C# Pinmembercpw999cn13-Mar-13 23:40 
QuestionC# Receive from TCP send to COM2 Pinmemberdockwomblejr13-Mar-13 12:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150326.1 | Last Updated 27 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid