[Mono-list] Databind to SQLServer

Jones, Larry LJones@Lithonia.com
Thu, 15 May 2003 20:26:56 -0700

I still have problems databinding to SQLServer.  Since I last posted this
problem I upgraded to RedHat 9.0 and Mono 0.24.  Still doesn't work.  Exact
same program works fine On MS .Net but not on mono.  Heres the code:

<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="C#" %>

<script runat="server">
public void Page_Load()
	SqlDataReader reader;
       string connectionString = "Server=SERVER;Database=pubs;User
       SqlConnection dbcon;
       dbcon = new SqlConnection(connectionString);
       SqlCommand dbcmd = dbcon.CreateCommand();
       string sql = 
           "SELECT au_fname, au_lname " +
           "FROM Authors";
       dbcmd.CommandText = sql;
       reader = dbcmd.ExecuteReader();

	 dgAuthors.DataSource = reader;


		<H2>Testing Sql</H2>
		<form runat="server">
			<asp:DataList ID="dgAuthors" runat="Server">
DataBinder.Eval(Container.DataItem, "au_lname") %>

Any suggestions as to what is wrong would be appreciated.

Larry Jones
Hydrel/Lithonia Lighting