asked on
trying to iron out the last few errors
I am working on a website that returns data to a csv file...I know that the errors are in the lack of declaration of the the variables - however not sure how to declare them.
aspx :: pretty sure there are no errors here
namespace 'StringBuilder' coun not be found
fsudata does not exist
Additionally I am not sure how to create the button to call the btnCSV_Click class
aspx :: pretty sure there are no errors here
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" AutoGenerateColumns="true" runat="server" />
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Data;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page
{
private const string MDBFILE = "FileUpload2.mdb";
private string GetConnectionString()
{
return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(MDBFILE) + ";";
}
protected void Page_Load(object sender, EventArgs e)
{
string SQL = "SELECT * FROM FSUdata ";
// Create Connection object
OleDbConnection dbConn = new OleDbConnection(GetConnectionString());
// Create Command Object
OleDbCommand dbComm = new OleDbCommand(SQL, dbConn);
// Open Connection
dbConn.Open();
// Execute command and receive DataReader
OleDbDataReader dbRead = dbComm.ExecuteReader();
GridView1.DataSource = dbRead;
GridView1.DataBind();
dbConn.Close();
}
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}
/// <summary>
/// This event is used to export gridview data to CSV document
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCSV_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "File.csv"));
Response.ContentType = "application/text";
GridView1.AllowPaging = false;
GridView1.DataBind();
StringBuilder strbldr = new StringBuilder();
for (int i = 0; i < FSUdata.Columns.Count; i++)
{
//separting header columns text with comma operator
strbldr.Append(gvdetails.Columns[i].HeaderText + ',');
}
//appending new line for gridview header row
strbldr.Append("\n");
for (int j = 0; j < FSUdata.Rows.Count; j++)
{
for (int k = 0; k < FSUdata.Columns.Count; k++)
{
//separating gridview columns with comma
strbldr.Append(FSUdata.Rows[j].Cells[k].Text + ',');
}
//appending new line for gridview rows
strbldr.Append("\n");
}
Response.Write(strbldr.ToString());
Response.End();
}
}
namespace 'StringBuilder' coun not be found
fsudata does not exist
Additionally I am not sure how to create the button to call the btnCSV_Click class
.NET ProgrammingASP.NET
Last Comment
Tagom