DOTNET POINT: Insert,update,delete and display using jquery,json,webservice and linq in asp.net

Design Code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        #popupBoxClose
        {
            font-size: 10px;
            line-height: 15px;
            right: 5px;
            top: 5px;
            position: absolute;
            color: #6fa5e2;
            font-weight: 500;
        }
        #popup_box
        {
            display: none; /* Hide the DIV */
            position: fixed;
            _position: absolute; /* hack for internet explorer 6 */
            height: 300px;
            width: 600px;
            background: #FFFFFF;
            left: 300px;
            top: 150px;
            z-index: 100; /* Layering ( on-top of others), if you have lots of layers: I just maximized, you can change it yourself */
            margin-left: 15px; /* additional features, can be omitted */
            border: 2px solid #999999;
            padding: 15px;
            font-size: 15px;
            -moz-box-shadow: 0 0 5px #ff0000;
            -webkit-box-shadow: 0 0 5px #ff0000;
        }
    </style>

<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>

Webservice Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService {
    DataClassesDataContext o = new DataClassesDataContext();
    public WebService ()
    {


    }

    [WebMethod]
    public string HelloWorld()
    {
        return "Hello World";
    }
    [WebMethod]
    public List<DEPT> insert(int a, string b)
    {
        DEPT p = new DEPT();
        p.DID = a;
        p.DNAME = b;
        o.DEPTs.InsertOnSubmit(p);
        o.SubmitChanges();
        List<DEPT> q=new List<DEPT>();
        var m = (from x in o.DEPTs select x).ToList();
        for (int i = 0; i < m.Count; i++)
            q.Add(new DEPT{DID=m[i].DID,DNAME=m[i].DNAME});
        return o.DEPTs.ToList();
    }
    [WebMethod]
    public List<DEPT> z(int a, string b)
    {
        var n = (from y in o.DEPTs where y.DID == a select y).First();
        n.DNAME = b;
        o.SubmitChanges();
        return o.DEPTs.ToList();
    }
    [WebMethod]
    public List<DEPT> d(int a)
    {
        var n = (from y in o.DEPTs where y.DID == a select y).First();
        o.DEPTs.DeleteOnSubmit(n);
        o.SubmitChanges();
        return o.DEPTs.ToList();
    }
    [WebMethod]
    public List<DEPT> y(int a)
    {
        var m = (from x in o.DEPTs where x.DID == a select x);
        return m.ToList();
    }
    [WebMethod]
    public List<DEPT> v()
    {
        return o.DEPTs.ToList();
    }
}

DOTNET POINT

Thursday 7 June 2012

Insert,update,delete and display using jquery,json,webservice and linq in asp.net

No comments:

Post a Comment