Avatar of Tagom

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
<%@ 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">
    <form id="form1" runat="server">
        <asp:GridView ID="GridView1" AutoGenerateColumns="true" runat="server" />

Open in new window

aspx.cs page::this page contains the errors
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

        // Execute command and receive DataReader
        OleDbDataReader dbRead = dbComm.ExecuteReader();

        GridView1.DataSource = dbRead;


    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.AddHeader("content-disposition", string.Format("attachment; filename={0}", "File.csv"));
        Response.ContentType = "application/text";
       GridView1.AllowPaging = false;
        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
        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

Open in new window

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

Avatar of undefined
Last Comment

8/22/2022 - Mon