Tuesday 17 January 2012

add,edit,delete,search,data clear form in C# with Database

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

<!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>Add New PO</title>
    <style type="text/css">
        .style1
        {
            font-family: Garamond;
            font-size: xx-large;
        }
        .style2
        {
            text-align: center;
        }
        </style>
</head>
<body>
    <p class="style2">
        <span class="style1" lang="en-us">&nbsp;Add, View, Edit P.O </span></p>
    <form id="form1" runat="server">
    <div class="style2">
   
        <div class="style2">
   
        <br />
        <asp:Label ID="Label1" runat="server" Text="P.O No"></asp:Label>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <asp:Label ID="Label2" runat="server" Text="Style Ref No"></asp:Label>
        <asp:TextBox ID="TextBox2" runat="server" Width="425px"></asp:TextBox>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <asp:Label ID="Label3" runat="server" Text="Destination"></asp:Label>
            <asp:DropDownList ID="DropDownList3" runat="server"
                DataSourceID="SqlDataSource1" DataTextField="Destination"
                DataValueField="Destination" Height="16px" Width="130px">
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                ConnectionString="<%$ ConnectionStrings:ShippingConnectionString %>"
                SelectCommand="SELECT * FROM [Destination_Table]"></asp:SqlDataSource>
        </div>
        <br />
        <br />
        <asp:TextBox ID="TextBox9" runat="server"></asp:TextBox>
        <br />
        <br />
        <span lang="en-us">&nbsp;&nbsp; </span>
        <asp:Label ID="Label4" runat="server" Text="Price"></asp:Label>
        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>
        <asp:Label ID="Label5" runat="server" Text="Season"></asp:Label>
        <asp:DropDownList ID="DropDownList2" runat="server"
            DataSourceID="SqlDataSource2" DataTextField="Season" DataValueField="Season"
            Height="19px" Width="130px">
        </asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConnectionString="<%$ ConnectionStrings:ShippingConnectionString %>"
            SelectCommand="SELECT [Season] FROM [Season_Table]"></asp:SqlDataSource>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>
        <asp:Label ID="Label6" runat="server" Text="Order QTY"></asp:Label>
        <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <asp:Label ID="Label7" runat="server" Text="Ship Date"></asp:Label>
        <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
        <br />
        <br />
        <br />
        <br />
        <br />
        <asp:Label ID="Label8" runat="server" Text="P.O Month"></asp:Label>
        <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <asp:Label ID="Label9" runat="server" Text="Ship Mode"></asp:Label>
        <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>
        <asp:Label ID="Label10" runat="server" Text="P.O Value"></asp:Label>
        <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button
            ID="Button3" runat="server" onclick="Button3_Click" Text="Search"
            Width="100px" />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button
            ID="Button4" runat="server" onclick="Button4_Click" Text="Edit" Width="100px" />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>
        <asp:Button ID="Button2" runat="server" Height="26px" onclick="Button2_Click"
            Text="Clear" Width="100px" />
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="Button5"
            runat="server" Text="Delete" Width="100px" onclick="Button5_Click" />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>
        <asp:Button ID="Button1" runat="server" Height="26px" onclick="Button1_Click"
            Text="Submit" Width="101px" />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
   
    </div>
 
    </form>
</body>
</html>
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)