Connecting From VS.net

Hey all! I am new in this form and also new with the SQL serve. I have installed that free express edition of SQL server 2005 and when i am trying to connect to server from my C#.net application i am not able to do it and the error i am getting is the user is not SQL thrusted user. I am able to connect directly thru SQL server using this userid and password but not thru C#.net application.

I have read online that so many people are having that problem. so is it the problem of swl server Express edition or do i have to make some setting to connect to the application.

Please please please please someone guide me . I am stuck here in the beginning only. I would really appreciate it.

the code that i wrote is here:----

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{



protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

}

}
protected void Submit_Click(object sender, EventArgs e)

{

String querry;

SqlDataReader dbread;

try

{

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["Conn1"]);

SqlCommand comm = new SqlCommand();

conn.Open();

querry = " Select password from login where userId='" + TxtUser.Text + "'";

comm.CommandText = querry;

comm.Connection = conn;

dbread = comm.ExecuteReader();

dbread = null;

if (dbread.HasRows)

{

while (dbread.Read())

{

if (dbread["password"].ToString() == Txtpwd.Text)

{

Response.Redirect("home.aspx");

}

}

Response.Write("Your Password Doesn't Match");

}

else

{

Response.Write("Your User Name Is Wrong");

}

conn.Close();

}

catch (Exception ex)

{

Response.Write(" This is an Error - " + ex.Message );

Response.End();

}



Thanks,
Komal