0

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 by pritaeas: Fixed title.

2
Contributors
6
Replies
20
Views
3 Years
Discussion Span
Last Post by aliashiq
0

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

0

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.

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>

0

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

0

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 topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.