I have a code using AJAX, and I want to validate if the username and exist. If the the username and password exist it will ask a question if the user want to proceed. If he clicks YES it will be inserted.
And if the username and password is not existing, it will be in inserted too!
<script type = "text/javascript">
function Save() {
$.ajax({
type: "POST",
url: "test.aspx/GetData",
data: '{name: "' + $("#<%=txtUserName.ClientID%>")[0].value + '", name2: "' + $("#<%=txtPassword.ClientID%>")[0].value + '"}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function (response) {
alert(response.d);
}
});
}
function OnSuccess(response) {
}
</script>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>
<input id="btnSave" type="button" value="Save"
onclick = "Save()" />
C# Code
[System.Web.Services.WebMethod]
public static bool GetData(string name, string name2)
{
test insert = new test();
MySqlConnection conn = Functions.GetConnection();
string sql = "SELECT CustomerID, RefDocNo FROM tblsomain WHERE CustomerID=@CustomerID AND RefDocNo=@RefDocNo";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@CustomerID", name);
cmd.Parameters.AddWithValue("@RefDocNo", name2);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
return true;
}
else
{
return false;
}
}
Thank you