Sir i am new to webservices and my scenario is that i want to display records from database against email and password. but when i debug webservices i recieved error. Here is my code

 [WebMethod]
        public bool CheckLogin(string Email, string Password)
        {

            return getEmail(Email, Password);
        }


        public bool getEmail(String Email, String Password)
        {

            SqlConnection NewCon;
            NewCon = Class1.GetConnection();
            NewCon.Open();
            bool check = false;
            string pa;



            SqlCommand CheckCmd = new SqlCommand("SELECT * from RegisterUsers WHERE Email ='" + Email + "' and Password='" + Password + "'", NewCon);
            CheckCmd.CommandType = CommandType.Text;
            CheckCmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;

            SqlDataReader sdr = CheckCmd.ExecuteReader();



            while (sdr.Read())
            {
                pa = sdr.GetString(8); // for Password column

                if (pa == Password)
                {
                    check = true;
                }
                break;
            }

            NewCon.Close();
            return check;
        }

Edited 2 Years Ago by pritaeas: Fixed title.

System.IndexOutOfRangeException: Index was outside the bounds of the array.
at System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName)
at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
at WebSer.WebService1.getEmail(String Email, String Password) in c:\Users\MuhammadAli\Documents\Visual Studio 2012\Projects\WebSer\WebSer\WebService1.asmx.cs:line 162
at WebSer.WebService1.CheckLogin(String Email, String Password) in c:\Users\MuhammadAli\Documents\Visual Studio 2012\Projects\WebSer\WebSer\WebService1.asmx.cs:line 137

Index was outside the bounds of the array

 pa = sdr.GetString(8); // for Password column

Are you sure the index is 8? It starts counting at 0.

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<boolean xmlns="http://tempuri.org/">false</boolean>

when i debug web services it gives me False rather than records against SQL QUERY

My scenario is that i want to get record from database against SQL Query.

SELECT * from RegisterUsers WHERE Email ='" + Email +'"

Actually we are making and android application and Web Application, when a user login via Android application the Query pass via web services and get details from SQL Server Database

This article has been dead for over six months. Start a new discussion instead.