ASP.NET Mini Form With SQL Server 2000

Hi, i  have created a mini form to test out easy steps and my sql
connection but something is wrong with my connection i think...

I am running windows XP Pro SP 2.  i have Microsoft VisStudio .NET 2003
fully installed and now im installing SQL Server 2000 Developrs
Edition.  I just cimpleted the installaion and picked some settings:



Local Computer Installation, Create new Instance since this is the
first time i use it, Server and Client Tools, and chose a Local rather
the Domain option aferwards.  (i have used this version before but had
to format the comp so now reinstalling everything).



My problem is this, i basically started the server and it on online.  i
went to the "enterprise manager" and in the "Microsoft SQL Servers
-> SQWL Server Group -> (Local)(Windows NT)-> Databases, i
created a new database called tables and added a single table just to
begin testing to see if at least its functional.  i was able to do this
so far.



Now i started my .NET, and wrote a tiny program to see if the
connection to the SQL database would open, but it didnt.  It always
failed.  i am programming an ASP.NET WebApplication.  I cant open the
connection to my database.  i dont know why.  (The tiny piece of code i
wrote is at the bottom in case you know c#).  There is a note also
under the code for the ones who will read through its simlicity



any help or walk through would be appreciated.  thank u...



Sam















CODE:



using System;



using System.Collections;



using System.ComponentModel;



using System.Data;



using System.Drawing;



using System.Web;



using System.Web.SessionState;



using System.Web.UI;



using System.Web.UI.WebControls;



using System.Web.UI.HtmlControls;



using System.Data.SqlClient;



using System.Configuration;



namespace WebTest1



{



/// <summary>



/// Summary description for WebForm1.



/// </summary>



public class WebForm1 : System.Web.UI.Page



{



string connection = ConfigurationSettings.AppSettings["ConnectionString"];











protected System.Web.UI.WebControls.TextBox TextBox1;



protected System.Web.UI.WebControls.Label Label1;



protected System.Web.UI.WebControls.TextBox TextBox2;



protected System.Web.UI.WebControls.Label Label2;



protected System.Web.UI.WebControls.TextBox TextBox3;



protected System.Web.UI.WebControls.Button Button1;



protected System.Web.UI.WebControls.Label Label5;



protected System.Web.UI.WebControls.Label outputBox;



protected System.Web.UI.WebControls.Label Label3;





private void Page_Load(object sender, System.EventArgs e)



{



// Put user code to initialize the page here



}



#region Web Form Designer generated code



override protected void OnInit(EventArgs e)



{



//



// CODEGEN: This call is required by the ASP.NET Web Form Designer.



//



InitializeComponent();



base.OnInit(e);



}





/// <summary>



/// Required method for Designer support - do not modify



/// the contents of this method with the code editor.



/// </summary>



private void InitializeComponent()



{



this.Button1.Click += new System.EventHandler(this.Button1_Click);



this.Load += new System.EventHandler(this.Page_Load);



}



#endregion



private void Button1_Click(object sender, System.EventArgs e)



{



outputBox.Text = "Button has been clicked";



SqlConnection conn = new SqlConnection(connection);





outputBox.Text += "----------------Creating sql Connection";







try



{



conn.Open();



outputBox.Text += "---------------opening the Connection";



}



catch(Exception p)



{



outputBox.Text += "--------------failed to open Connection";



Console.WriteLine(p.ToString());



}



outputBox.Text += "-------------Success Connection and Login to Server!";







}



}



}











NOTE: i always get this output :



Button has been clicked----------------Creating sql
Connection--------------failed to open Connection-------------Success
Connection and Login to Server!



it skips the try block's print line which means it didnt work......







string connection =
ConfigurationSettings.AppSettings["ConnectionString"]; this one i
updated in my Web.config and included application setting line that
loox like this



<add key="ConnectionString" value="Data Source=127.0.0.1; Initial Catalog=login; User Id=sa; password=pass" />