crud | C# Online Compiler

crud by Nabeel

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script type="text/javascript" src="//code.jquery.com/jquery-1.11.3.min.js"></script>
    <script type="text/javascript" src="Scripts/jquery.showLoading.js"></script>
    <link href="css/showLoading.css" rel="stylesheet" />
    <script type="text/javascript">
        $(document).ready(function () {
            $("#btnInsert").click(function () {
                var data = {
                    details: {
                        RollNo: $("#txtRollNo").val(),
                        FirstName: $("#txtFirstName").val(),
                        LastName: $("#txtLastName").val(),
                        MobileNo: $("#txtMobileNo").val()
                    }
                };
                $('body').showLoading();
                setTimeout(function () {
                    
                    $.ajax({
                        url: "Default.aspx/insertStudent",
                        data: JSON.stringify(data),
                        datatype: "json",
                        type: "POST",
                        contentType: "application/json; charset=utf-8",
                        success: function (result) {
                            $('body').hideLoading();
                            alert(result.d);
                        }
                    });
                }, 3000);

               
                return false;
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <center>
            <table>
                <tr>
                    <th>
                        Roll no:
                    </th>
                    <td>
                        <asp:TextBox ID="txtRollNo" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        FirstName:
                    </th>
                    <td>
                        <asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        Last Name:
                    </th>
                    <td>
                        <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        Mobile No:
                    </th>
                    <td>
                        <asp:TextBox ID="txtMobileNo" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th colspan="2">
                        <asp:Button text="Insert" ID="btnInsert" runat="server" OnClick="btnInsert_Click" />
                        <asp:Button text="Update" ID="btnUpdate" runat="server" />
                        <asp:Button text="Delete" ID="btnDelete" runat="server" />
                    </th>
                </tr>
            </table>
        </center>
        </div>
    </form>
</body>
</html>

							
							
							
							
							
							
							
							
							
							
							
							
							
							using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
    

    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {

    }

    [WebMethod]
    public static string insertStudent(StudentDetails details) 
    {
        SqlConnection con;
        SqlCommand cmd;
        string fn, ln, mb;
        fn = details.FirstName;
        ln = details.LastName;
        mb = details.MobileNo;
        con=new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Nabeel\Documents\test.mdf;Integrated Security=True;Connect Timeout=30");
        cmd = new SqlCommand("insert into StudentDetail values('"+fn+"','"+ln+"','"+mb+"')",con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        return "Record entered successfuly";
    }

    [WebMethod]
    public static string updateStudent(StudentDetails details) 
    {

        SqlConnection con;
        SqlCommand cmd;
        con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Nabeel\Documents\test.mdf;Integrated Security=True;Connect Timeout=30");
        cmd = new SqlCommand("update StudentDetail set fname=@fname, lname=@lname,mobileno=@mobileno where id=@id", con);
        cmd.Parameters.AddWithValue("@fname", details.FirstName);
        cmd.Parameters.AddWithValue("@lname", details.LastName);
        cmd.Parameters.AddWithValue("@mobileno", details.MobileNo);
        cmd.Parameters.AddWithValue("@id", details.RollNo);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        return "Record updated successfuly";

    }
    [WebMethod]
    public static string deleteRecord(string rollno) 
    {
        SqlConnection con;
        SqlCommand cmd;
        con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Nabeel\Documents\test.mdf;Integrated Security=True;Connect Timeout=30");
        cmd = new SqlCommand("delete from  StudentDetail where id=@id", con);
        
        cmd.Parameters.AddWithValue("@id", rollno);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        return "Record updated successfuly";
    }
}

public class StudentDetails 
{
    public int RollNo { get; set; }
    public string FirstName { get; set; }
    public string  LastName { get; set; }
    public string MobileNo { get; set; }
}

​x
 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
​
<!DOCTYPE html>
​
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script type="text/javascript" src="//code.jquery.com/jquery-1.11.3.min.js"></script>
    <script type="text/javascript" src="Scripts/jquery.showLoading.js"></script>
    <link href="css/showLoading.css" rel="stylesheet" />
    <script type="text/javascript">
        $(document).ready(function () {
            $("#btnInsert").click(function () {
                var data = {
                    details: {
                        RollNo: $("#txtRollNo").val(),
                        FirstName: $("#txtFirstName").val(),
                        LastName: $("#txtLastName").val(),
                        MobileNo: $("#txtMobileNo").val()
                    }
                };
                $('body').showLoading();
                setTimeout(function () {
                    
                    $.ajax({
                        url: "Default.aspx/insertStudent",
                        data: JSON.stringify(data),
                        datatype: "json",
                        type: "POST",
                        contentType: "application/json; charset=utf-8",
                        success: function (result) {
                            $('body').hideLoading();
                            alert(result.d);
                        }
                    });
                }, 3000);
​
               
                return false;
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <center>
            <table>
                <tr>
                    <th>
                        Roll no:
                    </th>
                    <td>
                        <asp:TextBox ID="txtRollNo" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        FirstName:
                    </th>
                    <td>
                        <asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        Last Name:
                    </th>
                    <td>
                        <asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th>
                        Mobile No:
                    </th>
                    <td>
                        <asp:TextBox ID="txtMobileNo" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <th colspan="2">
                        <asp:Button text="Insert" ID="btnInsert" runat="server" OnClick="btnInsert_Click" />
                        <asp:Button text="Update" ID="btnUpdate" runat="server" />
                        <asp:Button text="Delete" ID="btnDelete" runat="server" />
                    </th>
                </tr>
            </table>
        </center>
        </div>
    </form>
</body>
</html>
​
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
    
​
    protected void Page_Load(object sender, EventArgs e)
    {
​
    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {
​
    }
​
    [WebMethod]
    public static string insertStudent(StudentDetails details) 
    {
        SqlConnection con;
        SqlCommand cmd;
        string fn, ln, mb;
        fn = details.FirstName;
        ln = details.LastName;
        mb = details.MobileNo;
        con=new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Nabeel\Documents\test.mdf;Integrated Security=True;Connect Timeout=30");
        cmd = new SqlCommand("insert into StudentDetail values('"+fn+"','"+ln+"','"+mb+"')",con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        return "Record entered successfuly";
    }
​
    [WebMethod]
    public static string updateStudent(StudentDetails details) 
    {
​
        SqlConnection con;
        SqlCommand cmd;
        con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Nabeel\Documents\test.mdf;Integrated Security=True;Connect Timeout=30");
        cmd = new SqlCommand("update StudentDetail set fname=@fname, lname=@lname,mobileno=@mobileno where id=@id", con);
        cmd.Parameters.AddWithValue("@fname", details.FirstName);
        cmd.Parameters.AddWithValue("@lname", details.LastName);
        cmd.Parameters.AddWithValue("@mobileno", details.MobileNo);
        cmd.Parameters.AddWithValue("@id", details.RollNo);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        return "Record updated successfuly";
​
    }
    [WebMethod]
    public static string deleteRecord(string rollno) 
    {
        SqlConnection con;
        SqlCommand cmd;
        con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Nabeel\Documents\test.mdf;Integrated Security=True;Connect Timeout=30");
        cmd = new SqlCommand("delete from  StudentDetail where id=@id", con);
        
        cmd.Parameters.AddWithValue("@id", rollno);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        return "Record updated successfuly";
    }
}
​
public class StudentDetails 
{
    public int RollNo { get; set; }
    public string FirstName { get; set; }
    public string  LastName { get; set; }
    public string MobileNo { get; set; }
}
​
​
​
​
​
​
​
​
​
​
​
​
​

John Smith
Jim Johnson
Sue Rabon

Last Run:	1:10:48 pm
Compile:	0.124s
Execute:	0s
Memory:	8kb
CPU:	0s

View IL Code