如何从webservices登录 [英] How to login from webservices

问题描述

我的场景是我希望从RegisterUsers WHERE Email ='+ Email +'获取来自SQL Query SELECT *的数据库记录。

实际上我们正在制作和Android应用程序和Web应用程序，当用户通过Android应用程序登录时，Query通过Web服务传递并从SQL Server数据库获取详细信息。

这里是我的代码，但它给了我错误，请帮助我，我浪费了2天在网络服务上搜索过多。

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.
here is my code but it gives me error, and help me please i have wasted 2 days and searched too much on web services.

private bool Profile(string Email, string password)
{
    SqlConnection NewCon;
    NewCon = Class1.GetConnection();
    string cmdString = ("SELECT * FROM RegisterUsers WHERE Email = @Email AND Password = @pw");

    SqlCommand cmd = new SqlCommand(cmdString, NewCon);

    cmd.Parameters.Add("uname", SqlDbType.VarChar).Value = Email;
    cmd.Parameters.Add("pw", SqlDbType.VarChar).Value = password;

    DataSet loginCredentials = new DataSet();
    SqlDataAdapter dataAdapter;
    if (NewCon.State.Equals(ConnectionState.Closed))
    {
        NewCon.Open();

        dataAdapter = new SqlDataAdapter(cmd);
        dataAdapter.Fill(loginCredentials);

        NewCon.Close();

        if (loginCredentials != null)
        {
            if (loginCredentials.Tables[0].Rows.Count > 0)
            {
                return true;
            }
        }
    }
    return false;
}

推荐答案

cmd.Parameters.Add("uname", SqlDbType.VarChar).Value = Email;
           cmd.Parameters.Add("pw", SqlDbType.VarChar).Value = password;

试试这个

try this

cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = Email;
           cmd.Parameters.Add("@pw", SqlDbType.VarChar).Value = password;

这篇关于如何从webservices登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！