The error displayed on my .aspx page is shown below. Please I am trying to develop a Login page. But constantly I am receiving this error.

 No data exists for the row/column.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: No data exists for the row/column.

Source Error:

Line 48: //Verify the returned row for case-sensitivity
Line 49:
Line 50: if (txtPass.Text == reader["Pass"].ToString())
Line 51: {
Line 52: FormsAuthentication.RedirectFromLoginPage(txtUser. Text, false);


Source File: c:\Application development website\links\login.aspx Line: 50

Stack Trace:

[InvalidOperationException: No data exists for the row/column.]
   System.Data.OleDb.OleDbDataReader.DoValueCheck(Int 32 ordinal) +48
   System.Data.OleDb.OleDbDataReader.GetValue(Int32 ordinal) +9
   System.Data.OleDb.OleDbDataReader.get_Item(String name) +24
   ASP.login_aspx.login_click(Object sender, EventArgs e) in c:\Application development website\links\login.aspx:50
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
   System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +97
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919


THIS IS MY CODE:

public void login_click(object sender, EventArgs e)
       {

           OleDbConnection conn1 = new OleDbConnection();
           string myconn;
           myconn = "Provider=Microsoft.Jet.OLEDB.4.0;";
        myconn += "Data Source= " + Server.MapPath ("accessMyWebsite.mdb");
          conn1.ConnectionString = myconn;


          string auth;
          auth = "SELECT User, Pass FROM Customer WHERE Name='";
          auth += txtUser.Text + "' AND Pass='";
          auth += txtPass.Text + "'";

    //Define ADO.NET objects

                      OleDbCommand dbCommand1 = new OleDbCommand();
                      dbCommand1.CommandText = auth;
                      dbCommand1.Connection = conn1;
                      conn1.Open();
                      dbCommand1.ExecuteNonQuery();
                      conn1.Close();



           try

           {

               conn1.Open();
               OleDbDataReader reader = dbCommand1.ExecuteReader();
               reader.Read();


               //Verify the returned row for case-sensitivity

               if (txtPass.Text == reader["Pass"].ToString())
               {
                   FormsAuthentication.RedirectFromLoginPage(txtUser. Text, false);
               }
               else
               {
                   loginfailed.Text = "Reader Invalid Login";
               }
               reader.Close();
           }


           finally
           {
               conn1.Close();
           }
       }

This actualy is my authentication page for my website with backend Access database

Anyone how to solve the problem???

Hi there,

You need to make sure that your query returns a record, before you try to access it. You can do this by checking the return value of the Read method. Try this: Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Praise You by Fatboy Slim (From the album: You've Come a Long Way, Baby) What's This?

Thanks Imar is working. If you need the code tell me.