Showing posts with label using datatable and dataset object for search records. Show all posts
Showing posts with label using datatable and dataset object for search records. Show all posts

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 No comments:
Labels:
Subscribe to: Posts (Atom)