Login Page in WCF

rachayita jaiswal

13y7.2k

Hi,i am able to get data in grid view from database in WCF but want to create Login Page using WCF. I have searched on google, i am not getting please tell me how to create?I am new in WCF.

i have create service as -

[OperationContract]

DataSet SelectUserDetails(string userid1, string password1);

public DataSet SelectUserDetails(string userid1, string password1)

{

using (SqlConnection con = new SqlConnection(strConnection))

{

con.Open();

SqlCommand cmd = new SqlCommand("SELECT UserId,Password FROM M_Users", con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

sda.Fill(ds);

cmd.ExecuteNonQuery();

con.Close();

return ds;

}

}

how to call this and userid and password credentials on button click event???
protected void btnsubmit_Click(object sender, EventArgs e)
{

}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
create a new method in your WCF for checking weather is it a valid user or not

[OperationContract]
public bool IsValidUser(string userId, string password)
{
bool result=false;
using (SqlConnection con = new SqlConnection(strConnection))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT UserId,Password FROM M_Users
where UserId=@UserId and Password=@Password", con);
cmd.Parameters.AddWithValue("@UserId",userId);
cmd.Parameters.AddWithValue("@Password",password);
SqlDatareader reader=cmd.ExecuteReader();
if(reader.HasRows)
{
result=true;
}
con.Close();
}
return result;
}

Regards,
Iftikar
Bala Vignesh11y ago
please give me an idea for doing the same concept in html5 instead of using aspx. How to write the button click event in html5??
rachayita jaiswal13y ago
Thanks, I am going to try, if i ll get any issue i ll come back, Bye
Iftikar Hussain13y ago
yes, you can create SP with two parameter and called in your data access layer.

Regards,
Iftikar
rachayita jaiswal13y ago
Thanks, it's working....

On btn_Click event i have mention code like -

string userid = txtid.Text;
string password = txtpwd.Text;
var result = objservice.SelectUserDetails(userid, password);
if (result)
{
Response.Redirect("Default2.aspx");
}
else
{
lblerror.Text = "error!!!";
}

so it is working fine...
Now inplace of select query i want to use stored procedure..so i can create class and call stored procedure???
rachayita jaiswal13y ago
login page is my .aspx page only and button click event it is on that page, wcf service i have created separately.
Iftikar Hussain13y ago
Hi,
I think you need to create your page by .aspx/WPF/silverlight and use WCF service.

Regards,
Iftikar