ASP.NET

indian143 wrote:

this webpage contains content that will not be delivered using a secure https connection

indian143 wrote:

"Unable to automatically step into the server. Connecting to the server machine 'tserver.perfectcompliance.com' failed. Invalid access to memory location." - This error at the time of debugging, when my application calls the web service method, I am getting this error.

The only way to Find out is to attach it on an SQL Instance,First try to attach it in an SQL 2005 instance, if its a SQL 2008 then it will give you an error that has something like 

"bla bla bla does not belong to ...Family ...."

and if you are able to attach it then it means its 2005 

The SQL Express is good for your requirement, i dont think you need to do some conversion, as long as you have SQL Express instance installed on your machine you can just attach your files

You dont need visual Studio , you need to Install the SQL instance. That will have SQL Management studio to attach your Files 

if you could do this then its not a 2008 mdf files, you can still confirm by "Right click on your Database and go to properties and select the "Options" and check the Version from there. 

How do you know that you cant connect , if you cant see the error ? 

You wrote :
Now i have deployed my website on IIS also and when i browse my page i can see it on the browser but ....... I am not able to connect to the database tables as when i enter the login and password it comes to the same login page again without showing any error. Now, I cannot identify whether its due to the following reason:-

How do you know that you cant connect , if you cant see the error ? 

You wrote :
Now i have deployed my website on IIS also and when i browse my page i can see it on the browser but ....... I am not able to connect to the database tables as when i enter the login and password it comes to the same login page again without showing any error. Now, I cannot identify whether its due to the following reason:-

How do you know that you cant connect , if you cant see the error ? 

You wrote :
2> I have to make some changes in the connectivity[in web.config or some other location]

what is your Question Regarding this ?

write a single test page with complete diagnostic.

write a single test page with complete diagnostic.

protected void btnLogin_Click(object sender, EventArgs e)<br />
    {<br />
        if (Session["Admin"] != null)<br />
        {<br />
            if (txtPassword.Text.ToUpper.Equals(Session["Admin"]))<br />
                Response.Redirect("Homepage.aspx");<br />
        }<br />
        String except = null;<br />
        <big>DataValidation dv = new DataValidation();</big>        String pass = txtPassword.Text;<br />
<br />
        String password = null;<br />
        <br />
        password = dv.loginIn(txtUserName.Text);<br />
        <br />
        if (password==null)<br />
        {<br />
            //Session["Exception"] = except;<br />
            Session["SourceFile"] = Formname;<br />
            Response.Redirect("Error.aspx");<br />
            txtUserName.Text = "Exception";<br />
        }<br />
<br />
        else if (password.Equals(pass))<br />
        {<br />
            //txtUserName.Text = "Success";<br />
            Session["User"] = txtUserName.Text;<br />
            if (Session["User"].ToString().ToUpper().Equals("ADMIN"))<br />
                Session["Admin"] = "ADMIN";<br />
            Response.Redirect("Homepage.aspx");<br />
<br />
        }<br />
        <br />
        else <br />
        {<br />
            lblCheck.Text="Invalid UserName or Password";<br />
            //Response.Redirect("LogIn.aspx");<br />
        }<br />
<br />
<br />
<br />
    }

public String loginIn(String userName)<br />
    {<br />
        String queryBuilder;<br />
        <br />
        {<br />
            DataBaseConnection ds = new DataBaseConnection();<br />
<br />
            queryBuilder = "SELECT Password FROM User_Master WHERE UserName = @uname";<br />
<br />
            String pass = ds.loginDataBase(userName, queryBuilder);<br />
<br />
            return pass;<br />
        }<br />
<br />
    }

SqlConnection getConnection()<br />
    {<br />
        SqlConnection cn = null;                <br />
        {<br />
            cn = new SqlConnection();            <br />
            cn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();<br />
            return cn;                     <br />
        }<br />
    }<br />
<br />
<br />
<br />
    public String loginDataBase(String userName, String queryBuilder)<br />
    {<br />
        SqlConnection sqlcon = null;<br />
        try<br />
        {<br />
            sqlcon = new SqlConnection();<br />
            sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();<br />
            sqlcon.Open();<br />
<br />
            SqlCommand cmd = new SqlCommand();<br />
<br />
            cmd.CommandText = queryBuilder;<br />
            cmd.CommandType = CommandType.Text;<br />
            cmd.Connection = sqlcon;<br />
<br />
            cmd.Parameters.AddWithValue("@uname", userName);            <br />
           <br />
            SqlDataReader dr = cmd.ExecuteReader();<br />
            if (dr.HasRows == true)<br />
            {<br />
                dr.Read();<br />
                return dr[0].ToString();<br />
            }<br />
            else<br />
                return null;<br />
           <br />
        }<br />
<br />
        catch (Exception ex)<br />
        {<br />
            //except = ex.ToString();<br />
            return null;<br />
        }<br />
        finally<br />
        {<br />
            sqlcon.Close();<br />
        }<br />
    }

catch (Exception ex)
           {
              // except = ex.ToString();
               throw;
           }