Tagom
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:
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:
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>
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();
}
}
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.
Line 16:
Line 17:
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
ASKER
I made the correction suggested, good catch - thank you.
However I still get the same error in the backend file.
However I still get the same error in the backend file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.