afranka
01-09-2004, 06:53 PM
Hi,
Please can anyone suggest why the following isn't working..?
Just get a blank screen.
Apologies if it is really bad coding!!!
Thanks!
<%@ Page Language="C#" AutoEventWireup="False"
EnableSessionState="False" EnableViewState="False" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<script runat="server">
void Pageload()
{
string myConnString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=test;" +
"DATABASE=change;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";
DataSet ds = new DataSet();
OdbcConnection myConnection = new OdbcConnection(myConnString);
OdbcDataAdapter da = new OdbcDataAdapter("SELECT username FROM users", myConnection);
da.Fill(ds, "users");
dgNameList.DataSource = new DataView(ds.Tables["users"]);
dgNameList.DataBind();
}
</script>
<html>
<head>
</head>
<body>
<asp:datagrid id="dgNameList" runat="server" />
</body>
</html>
Please can anyone suggest why the following isn't working..?
Just get a blank screen.
Apologies if it is really bad coding!!!
Thanks!
<%@ Page Language="C#" AutoEventWireup="False"
EnableSessionState="False" EnableViewState="False" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<script runat="server">
void Pageload()
{
string myConnString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=test;" +
"DATABASE=change;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";
DataSet ds = new DataSet();
OdbcConnection myConnection = new OdbcConnection(myConnString);
OdbcDataAdapter da = new OdbcDataAdapter("SELECT username FROM users", myConnection);
da.Fill(ds, "users");
dgNameList.DataSource = new DataView(ds.Tables["users"]);
dgNameList.DataBind();
}
</script>
<html>
<head>
</head>
<body>
<asp:datagrid id="dgNameList" runat="server" />
</body>
</html>