asked on

Error on gridView code

I am trying to return the results of a table to a webpage
using aspx and aspx.cs c#
front code:

<%@ 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" runat="server" />
    </div>
    </form>
</body>
</html>

Open in new window

back end code:

using System;
using System.Collections.Generic;
using System.Linq;
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";
    protected System.Web.UI.WebControls.GridView;


    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();


    }
}

Open in new window

error:
Compiler Error Message: CS1519: Invalid token ';' in class, struct, or interface member declaration

Source Error:

Line 13: {
Line 14: private const string MDBFILE = "FileUpload2.mdb";
Line 15: protected System.Web.UI.WebControls.GridView;
Line 16:
Line 17:

Easwaran Paramasivam

In your ASPX page set AutoGenerateColumns="true" for the Gridview control. Look at the example at http://www.vkinfotek.com/gridview/gridview-autogeneratecolumns-property.html

Tagom

ASKER

I made the correction suggested, good catch - thank you.
However I still get the same error in the backend file.

ASKER CERTIFIED SOLUTION

Easwaran Paramasivam

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial