Comments by Member 14738666 (Top 9 by date)

public Users GetUserLogin(string UserID, string Password)
{
Users us = new Users();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("spUserLogin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", UserID);
cmd.Parameters.AddWithValue("@Password", Password);
SqlDataAdapter da = new SqlDataAdapter(cmd);
con.Close();
DataSet ds = new DataSet();
da.Fill(ds, "tb_Users");

return us;
}
note; this above code I wrote in svc class after that when I run this code I got above error