Saturday, 18 March 2017

Insert Data on Server using Web Methods in Asp.Net


Database
Create a Table in Database

create table insert_user
(
id int primary key identity(1,1),
Name varchar(20),
contact_number varchar(20),
email varchar(20),
username varchar(10),
password varchar(10),
gender varchar(10),
country varchar(10)
)

Create Stored Procedure to insert data in table

create proc insert_sp_user
@Name varchar(20),
@contact_number varchar(20),
@email varchar(20),
@username varchar(10),
@password varchar(10),
@gender varchar(10),
@country varchar(10),
@success int out
as
begin
insert into insert_user(Name,contact_number,email,username,password,gender,country) values(@Name, @contact_number, @email, @username, @password,@gender,@country)
end




Web.Config
<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <appSettings>
    <add key="constr" value="Database=******; Initial catalog=*****; user id=*****; password=*****;"/>
    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />
  </appSettings>
  <system.web>
    <compilation debug="true" targetFramework="4.5.1"/>
    <httpRuntime targetFramework="4.5.1"/>
  </system.web>
  <system.codedom>
    <compilers>
      <compiler language="c#;cs;csharp" extension=".cs"
        type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        warningLevel="4" compilerOptions="/langversion:6 /nowarn:1659;1699;1701"/>
      <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb"
        type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        warningLevel="4" compilerOptions="/langversion:14 /nowarn:41008 /define:_MYTYPE=\&quot;Web\&quot; /optionInfer+"/>
    </compilers>
  </system.codedom>
</configuration>


BusinessLayer

Add a class with the name BusinessLayer.

 public class BusinessLayer
    {
        string constring = ConfigurationManager.AppSettings["constr"].ToString();
        public int Add_user(string name,Int64 contact,string email,string username, string password,string gender, string country)
        {
            using (SqlConnection con = new SqlConnection(constring))
            using (SqlCommand cmd = new SqlCommand("insert_sp_user", con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter outputvalue = new SqlParameter("@success", SqlDbType.Int);
                outputvalue.Direction = ParameterDirection.Output;
                cmd.Parameters.AddWithValue("@Name", name);
                cmd.Parameters.AddWithValue("@contact_number", contact);
                cmd.Parameters.AddWithValue("@email", email);
                cmd.Parameters.AddWithValue("@username", username);
                cmd.Parameters.AddWithValue("@password", password);
                cmd.Parameters.AddWithValue("@gender", gender);
                cmd.Parameters.AddWithValue("@country", country);
                cmd.Parameters.Add(outputvalue);
                con.Open();
                cmd.ExecuteNonQuery();
                int result = 1;
                if (outputvalue.Value != DBNull.Value)
                    result = Convert.ToInt32(outputvalue.Value);
                return result;
            }
        }
    }

User.aspx



Add a web frm with the name User
Insert Jquery reference on the form.


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/jquery-1.10.2.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $("#<%=btn_submit.ClientID%>").click(function () {
                debugger;
                var name = $("#<%=txt_name.ClientID%>").val();
                var contact = $("#<%=txt_contact.ClientID%>").val();
                var email = $("#<%=txt_email.ClientID%>").val();
                var username = $("#<%=txt_username.ClientID%>").val();
                var password = $("#<%=txt_password.ClientID%>").val();
                var gender = "";
                if ($("#<%=rdbmale.ClientID%>").is(":checked"))
                    gender = "Male";
                else
                    gender = "Female";

                var country = $("#<%=ddl_country.ClientID%> option:selected").text();
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "User.aspx/user_insertion",
                    data: '{"name":"' + name + '","contact":"' + contact + '","email":"' + email + '","username":"' + username + '","password":"' + password + '","gender":"' + gender + '","country":"' + country + '"}',
                    dataType: "json",
                    success: function (data) {
                        debugger;
                        alert("Insert Successfully");
                    }
                });
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <table>
            <tr>
                <td>

               
    <asp:Label ID="lbl_name" Text="Name" runat="server">
    </asp:Label>
                    </td>
                <td>
        <asp:TextBox ID="txt_name" runat="server"></asp:TextBox>
        <asp:RequiredFieldValidator ID="rfv_name" runat="server" ControlToValidate="txt_name" ErrorMessage="Enter Name Please"></asp:RequiredFieldValidator>
                     </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lbl_contact" runat="server" Text="Contact Number"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txt_contact" runat="server" TextMode="Number"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="rfv_contact" runat="server" ControlToValidate="txt_contact" ErrorMessage="Enter Contact Number"></asp:RequiredFieldValidator>
                </td>
            </tr>
          <tr>
                <td>

               
    <asp:Label ID="lbl_email" Text="Email Address" runat="server">
    </asp:Label>
                    </td>
                <td>
        <asp:TextBox ID="txt_email" runat="server" TextMode="Email"></asp:TextBox>
        <asp:RequiredFieldValidator ID="rfv_email" runat="server" ControlToValidate="txt_email" ErrorMessage="Enter Email Address Please"></asp:RequiredFieldValidator>
                     </td>
            </tr>
         <tr>
                <td>

               
    <asp:Label ID="lbl_username" Text="User Name" runat="server">
    </asp:Label>
                    </td>
                <td>
        <asp:TextBox ID="txt_username" runat="server"></asp:TextBox>
        <asp:RequiredFieldValidator ID="rfv_username" runat="server" ControlToValidate="txt_username" ErrorMessage="Enter UserName Please"></asp:RequiredFieldValidator>
                     </td>
            </tr>
          <tr>
                <td>

               
    <asp:Label ID="lbl_password" Text="Password" runat="server">
    </asp:Label>
                    </td>
                <td>
        <asp:TextBox ID="txt_password" runat="server" TextMode="Password"></asp:TextBox>
        <asp:RequiredFieldValidator ID="rfv_password" runat="server" ControlToValidate="txt_password" ErrorMessage="Enter password Please"></asp:RequiredFieldValidator>
                     </td>
            </tr>
         <tr>
                <td>
                    <asp:Label ID="lbl_gender" runat="server" Text="Gender"></asp:Label>
                </td>
                <td>
                    <asp:RadioButton ID="rdbmale" runat="server" Text="Male" GroupName="Gender" Checked="true" />
                    <asp:RadioButton ID="rdb_female" runat="server" Text="Female" GroupName="Gender" />
                </td>
            </tr>
          <tr>
                <td>
                    <asp:Label ID="lbl_state" runat="server" Text="State"></asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddl_country" runat="server">
                        <asp:ListItem>India</asp:ListItem>
                        <asp:ListItem>USA</asp:ListItem>
                        <asp:ListItem>Newzeland</asp:ListItem>
                        <asp:ListItem>UK</asp:ListItem>
                        <asp:ListItem>Sri Lanka</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
          <tr>
                <td></td>
                <td>
                    <asp:Button ID="btn_submit" runat="server" Text="Submit"/>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>


User.aspx.cs

Add namespace for the web [WebMethod] using System.Web.Services;


 [WebMethod]
        public static string user_insertion(string name, Int64 contact,string email,string username, string password, string gender,string country)
        {
            BusinessLayer objbusiness = new BusinessLayer();
            string status = "true";
            int result = objbusiness.Add_user(name, contact, email, username, password, gender, country);
            if(result==0)
            {
                status = "false";
            }
            return status;
        }







No comments:

Post a Comment

Insert, Delete, Update Using Entity Framework and LINQ in ASP.NET 1> Create Database First 2> Create Table 3> Add ADO...