I have an ASPX page in which I am trying to bind a datagrid to a dataset
pulled from Microsoft Access DB using code inline method. For some reason,
the compiler is having a problem with 'using'. Any help here would be much
appreciated. Thanks!
Getting the following error:
CS1519: Invalid token 'using' in class, struct, or interface member
declaration
My Code:
<%@ Page Language="C#" %>
<script runat="server">
using System.Data;
using System.Data.ole db;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
private void Form_Load(objec t sender, System.EventArg s e)
{
// create a connection string
string connString = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=C:\Dev\A TTRIBUTES_VH\AT TRIBUTES_VH.mdb ";
OleDbConnection myConnection = new OleDbConnection ();
myConnection.Co nnectionString = connString;// create a data adapter
OleDbDataAdapte r da = new OleDbDataAdapte r("Select * from mytable",
myConnection);
// create a new dataset
DataSet ds = new DataSet();
// fill dataset
da.Fill(ds, "RateCenter s");
// Attach DataSet to DataGrid
DataGrid1.DataS ource = ds.DefaultViewM anager;
DataGrid1.datab ind()
myConnection.cl ose()
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server"> </asp:DataGrid>
</form>
</body>
</html>
