如何从 JavaScript 代码调用 StorageProcedure

本文关键字：调用 StorageProcedure 代码 JavaScript | 更新日期: 2023-09-27 18:35:10

>我有电子邮件字段和标签

<asp:TableRow runat="server">
                <asp:TableCell runat="server">
                    <asp:TextBox runat="server" ID="txtUserEmail" onfocusout="emailVerification()" CssClass="forTextbox ui-corner-all" PlaceHolder="Enter your email"></asp:TextBox>
                </asp:TableCell>
                <asp:TableCell runat="server">
                    <asp:ScriptManager runat="server" ID="smForEmail"></asp:ScriptManager>
                    <asp:UpdatePanel runat="server" ID="upLblEmail">
                        <ContentTemplate>
                            <asp:Label runat="server" ID="lblEmail"></asp:Label>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </asp:TableCell>
            </asp:TableRow>

以及其他一些领域。

我希望当用户移动到下一个字段时onfocusout="emailVerification()"调用方法。在这种方法中，我想检查电子邮件是否存在于数据库中。为此，我编写了存储过程。

USE [CDistributors]
GO
/****** Object:  StoredProcedure [dbo].[sp_InsertUser]    Script Date: 2/17/2016 2:50:05 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[sp_InsertUser]
(@Email varchar(50) = null,
@ReturnValue int = null)
As
Begin
SET NOCOUNT ON;
IF EXISTS (SELECT UserId from Users where Email = @Email)
Begin
    return 0; -- Email already registered
End 
Else
Begin
    return 1; -- Email is not registered yet
End
End

JavaScript 函数是

// code for email verification
$(function () {
    function emailVerification() {
         // What code to call stored procedure that return integer
    }
});

请帮忙。

如何从 JavaScript 代码调用 StorageProcedure

你可以为数据库调用方法制作 Web 服务，也可以在页面上将其设为 webmethod

如果您使用的是 .Net Framwork 4 或更高版本，则可以指定 ClientIDMode="Static"，以使控件在客户端上具有与您指定的相同的 ID

<asp:TextBox runat="server" ID="txtUserEmail"  ClientIDMode="Static" onfocusout="emailVerification()" CssClass="forTextbox ui-corner-all" PlaceHolder="Enter your email"></asp:TextBox>

这里 WebMethod 调用示例

// code for email verification
$(function () {
    function emailVerification() {
        // What code to call stored procedure that return integer
        var email = $('#txtUserEmail').val();
        jQuery.ajax({
            url: 'yourPage.aspx/VerifyEmail',
            type: "POST",
            data: "{'email' :' " + email + "'}",
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            beforeSend: function () {
                alert("Maybe you need some stuff before! ");
            },
            success: function (data) { alert(data.d); },
            failure: function (msg) { alert("Something go wrong! "); }
        });
    }
});

代码隐藏文件

[System.Web.Services.WebMethod]
public static int VerifyEmail(string email)
{
    //Your verification code 
    return 1;
}
相关文章：