error conecting to the DB

arturo · January 29th, 2005, 06:59 AM

Hello,
My problem is that I have a C# code conecting to SQLSERVER working perfectly, but when I try to conect it with an ASPX page, it doesn,t connect.

the code for the ASPX page is this:

<%@ Page Language="C#" Debug="true" Src="adooverview1.cs"%>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="HowTo.Samples.ADONET" %>

<script language="C#" runat="server">

protected void Page_Load(Object Src, EventArgs E)
{
  StringWriter writer = new StringWriter();
  Console.SetOut(writer);
  adooverview1 myadooverview1 = new adooverview1();
  myadooverview1.Run();
  output.InnerHtml = writer.ToString();
}

</script>

<html>
<body style="background-color:f6e4c6">
  <tr><td><h4><xmp id="output" runat="server"/></h4></td></tr>
</body>
</html>

Thanks

ART

bmains · January 31st, 2005, 10:39 AM

What does this do: adooverview1?

Brian

arturo · February 13th, 2005, 10:40 AM

This is the C# code of adooverview1.cs:
It connects to the database but when I try it wit ASPX it doesn't work.

namespace ejemplo
{

using System;
using System.Data.SqlClient;

public class adooverview1
{
  public static void Main()
  {
    adooverview1 myadooverview1 = new adooverview1();
    myadooverview1.Run();
  }

  public void Run()
  {

    SqlConnection mySqlConnection = new SqlConnection("server=(local)\\NetSDK;Trusted_Conn ection=yes;database=hotel");

    try
    {
      mySqlConnection.Open();
      Console.WriteLine("Opened Connection to {0}", mySqlConnection.ConnectionString);

      // Close the connection explicitly
      mySqlConnection.Close();
      Console.WriteLine("Closed Connection. It is important to close connections explicitly.");
    }
    catch
    {
      Console.WriteLine("Couldn't Open Connection to {0}", mySqlConnection.ConnectionString);
    }
  }
}

}

ART

Imar · February 13th, 2005, 10:44 AM

You're writing to the Console, which is not available in ASP.NET

Remove the lines that use Console. and then debug your application Move line by line through the code to see where it breaks....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The new cobweb summer by Lambchop (From the album: Is a woman) What's This?