ASP.net

 File >> new >> project >>web>> asp.net web application 


table access

  • id: AutoNumber (as an AutoNumber field for primary key)
  • issu_name: Text
  • book_id: Text
  • book_name: Text
  • writer_name: Text
  • issu_date: Date/Time
  • retuen_date: Date/Time
  • book_type: Text
  • phone_num: Text


create insert.aspx

between asp: content

    <table class="nav-justified">

    <tr>

        <td style="width: 327px">id</td>

        <td style="width: 290px">

            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

        </td>

        <td>

            &nbsp;</td>

    </tr>

    <tr>

        <td style="width: 327px">name</td>

        <td style="width: 290px">

            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

        </td>

        <td>

            <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2" ErrorMessage="isuuer name" ForeColor="#CC0000"></asp:RequiredFieldValidator>

        </td>

    </tr>

    <tr>

        <td style="width: 327px">book name</td>

        <td style="width: 290px">

            <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

        </td>

        <td>

            <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3" ErrorMessage="book name" ForeColor="#CC0000"></asp:RequiredFieldValidator>

        </td>

    </tr>

    <tr>

        <td style="width: 327px">book id</td>

        <td style="width: 290px">

            <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>

        </td>

        <td>

            <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox4" ErrorMessage="book id" ForeColor="#CC0000"></asp:RequiredFieldValidator>

        </td>

    </tr>

    <tr>

        <td style="width: 327px">writer name</td>

        <td style="width: 290px">

            <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>

        </td>

        <td>

            <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox5" ErrorMessage="writer name" ForeColor="#CC0000"></asp:RequiredFieldValidator>

        </td>

    </tr>

    <tr>

        <td style="width: 327px">issuse date</td>

        <td style="width: 290px">

            <asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>

        </td>

        <td>&nbsp;</td>

    </tr>

    <tr>

        <td style="width: 327px">retern date</td>

        <td style="width: 290px">

            <asp:Calendar ID="Calendar2" runat="server" SelectedDate="2023-10-07"></asp:Calendar>

        </td>

        <td>&nbsp;</td>

    </tr>

    <tr>

        <td style="width: 327px">book type</td>

        <td style="width: 290px">

            <asp:ListBox ID="ListBox1" runat="server">

                <asp:ListItem>story</asp:ListItem>

                <asp:ListItem>horrar</asp:ListItem>

                <asp:ListItem>comady</asp:ListItem>

                <asp:ListItem>motivaction</asp:ListItem>

                <asp:ListItem>history</asp:ListItem>

            </asp:ListBox>

        </td>

        <td>&nbsp;</td>

    </tr>

    <tr>

        <td style="width: 327px">phone num</td>

        <td style="width: 290px">

            <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>

        </td>

        <td>

            <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox6" ErrorMessage="enter phone number" ForeColor="#CC0000"></asp:RequiredFieldValidator>

            <asp:RegularExpressionValidator ID="RegularExpressionValidator6" runat="server" ControlToValidate="TextBox6" ErrorMessage="please enter proper phone number" ForeColor="Red" ValidationExpression="\d{10}"></asp:RegularExpressionValidator>

        </td>

    </tr>

    <tr>

        <td colspan="3">

            <asp:Button ID="Button1" runat="server" Text="Insert" onclick="Button1_Click" />

            <asp:Button ID="Button2" runat="server" Text="Update" onclick="Button2_Click" />

            

        </td>

    </tr>

</table>


    

    <asp:Button ID="Button3" runat="server" Text="Delete" OnClick="Button3_Click" CausesValidation="false" />

<asp:Button ID="Button4" runat="server" Text="Display" OnClick="Button4_Click" CausesValidation="false" />


    

   <asp:Label ID="MessageLabel" runat="server" Text=""></asp:Label>


//in insert.aspx.cs


using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;


using System.Data.OleDb;

using System.Data;


namespace WebApplication1

{

    public partial class insert : System.Web.UI.Page

    {

        OleDbConnection conn = new OleDbConnection();

        OleDbCommand cmd = new OleDbCommand();

        OleDbDataAdapter da = new OleDbDataAdapter();

        OleDbDataReader dr;


           protected void Page_Load(object sender, EventArgs e)

    {

        conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\archi\\OneDrive\\Documents\\practice.mdb";

        conn.Open();

    //     MessageBox.Show(conn.State.ToString());

    }


    protected void Button1_Click(object sender, EventArgs e)

    {

        // MessageBox.Show(Calendar1.SelectedDate + "" + ListBox1.SelectedValue);

        string query = "insert into book_db (issu_name, book_id,book_name, writer_name, issu_date, retuen_date, book_type, phone_num) values (@p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9)";


        cmd = new OleDbCommand(query, conn);

        //cmd.Parameters.AddWithValue("@p1", TextBox1.Text);

        cmd.Parameters.AddWithValue("@p2", TextBox2.Text);

        cmd.Parameters.AddWithValue("@p3", TextBox4.Text);

        cmd.Parameters.AddWithValue("@p4", TextBox3.Text);

        cmd.Parameters.AddWithValue("@p5", TextBox5.Text);

        cmd.Parameters.AddWithValue("@p6", Calendar1.SelectedDate);

        cmd.Parameters.AddWithValue("@p7", Calendar2.SelectedDate);

        cmd.Parameters.AddWithValue("@p8", ListBox1.SelectedValue);

        cmd.Parameters.AddWithValue("@p9", TextBox6.Text);

        cmd.ExecuteNonQuery();

        MessageLabel.Text = "Data is inserted...";   

    }


  protected void Button2_Click(object sender, EventArgs e)

    {

        try

        {

            string query = "update book_db set issu_name=@p2,book_id=@p3,book_name=@p4,writer_name=@p5,issu_date=@p6,retuen_date=@p7,book_type=@p8,phone_num=@p9 where id=@p1";

            cmd = new OleDbCommand(query, conn);

            cmd.Parameters.AddWithValue("@p1", TextBox1.Text);

            cmd.Parameters.AddWithValue("@p2", TextBox2.Text);

            cmd.Parameters.AddWithValue("@p3", TextBox4.Text);

            cmd.Parameters.AddWithValue("@p4", TextBox3.Text);

            cmd.Parameters.AddWithValue("@p5", TextBox5.Text);

            cmd.Parameters.AddWithValue("@p6", Calendar1.SelectedDate);

            cmd.Parameters.AddWithValue("@p7", Calendar2.SelectedDate);

            cmd.Parameters.AddWithValue("@p8", ListBox1.SelectedValue);

            cmd.Parameters.AddWithValue("@p9", TextBox6.Text);

            int rowsUpdated = cmd.ExecuteNonQuery();

                

            if (rowsUpdated > 0)

            {

                MessageLabel.Text = "Data is updated...";

            }

            else

            {

                MessageLabel.Text = "No data was updated. Check the ID value.";

            }

        }

        catch (Exception ex)

        {

            MessageLabel.Text = "An error occurred: " + ex.Message;

        }

    }


    protected void Button3_Click(object sender, EventArgs e)

    {

        Response.Redirect("delete.aspx");

    }

    protected void Button4_Click(object sender, EventArgs e)

    {

        Response.Redirect("display.aspx");

    }

}

}



//delete.aspx 


<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

        <div>

            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

            <br />

            <br />

            <asp:Button ID="Button1" runat="server" Text="delete" onclick="Button1_Click" />

               <asp:Label ID="MessageLabel" runat="server" Text=""></asp:Label>

        </div>

    </form>

</body>

</html>


// delete.aspx.cs


using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.OleDb;


namespace WebApplication1

{

    public partial class delete : System.Web.UI.Page

    {

        OleDbConnection conn = new OleDbConnection();

        OleDbCommand cmd = new OleDbCommand();


        protected void Page_Load(object sender, EventArgs e)

        {

            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\archi\\OneDrive\\Documents\\practice.mdb";

            conn.Open();


        }


        protected void Button1_Click(object sender, EventArgs e)

        {

            cmd = new OleDbCommand("delete from book_db where id=@p1", conn);

            cmd.Parameters.AddWithValue("@p1", TextBox1.Text);

            cmd.ExecuteNonQuery();

            // Use Response.Write to display a message on the web page

            MessageLabel.Text = "Data is Deleted...";

        }

    }

}


//display.aspx



<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

        <div>

            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 

                AutoGenerateColumns="False" BackColor="LightGoldenrodYellow" BorderColor="Tan" 

                BorderWidth="1px" CellPadding="2" DataKeyNames="id" 

                DataSourceID="SqlDataSource1" ForeColor="Black" GridLines="None">

                <AlternatingRowStyle BackColor="PaleGoldenrod" />

                <Columns>

                    <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 

                        ReadOnly="True" SortExpression="id" />

                    <asp:BoundField DataField="issu_name" HeaderText="issu_name" 

                        SortExpression="issu_name" />

                    <asp:BoundField DataField="book_id" HeaderText="book_id" 

                        SortExpression="book_id" />

                    <asp:BoundField DataField="book_name" HeaderText="book_name" 

                        SortExpression="book_name" />

                    <asp:BoundField DataField="writer_name" HeaderText="writer_name" 

                        SortExpression="writer_name" />

                    <asp:BoundField DataField="issu_date" HeaderText="issu_date" 

                        SortExpression="issu_date" />

                    <asp:BoundField DataField="retuen_date" HeaderText="retuen_date" 

                        SortExpression="retuen_date" />

                    <asp:BoundField DataField="book_type" HeaderText="book_type" 

                        SortExpression="book_type" />

                    <asp:BoundField DataField="phone_num" HeaderText="phone_num" 

                        SortExpression="phone_num" />

                </Columns>

                <FooterStyle BackColor="Tan" />

                <HeaderStyle BackColor="Tan" Font-Bold="True" />

                <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />

                <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />

                <SortedAscendingCellStyle BackColor="#FAFAE7" />

                <SortedAscendingHeaderStyle BackColor="#DAC09E" />

                <SortedDescendingCellStyle BackColor="#E1DB9C" />

                <SortedDescendingHeaderStyle BackColor="#C2A47B" />

            </asp:GridView>

            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

                ConnectionString="<%$ ConnectionStrings:practiceConnectionString %>" 

                ProviderName="<%$ ConnectionStrings:practiceConnectionString.ProviderName %>" 

                SelectCommand="SELECT DISTINCT * FROM [book_db]"></asp:SqlDataSource>

        </div>

        <br />

        <br />

        <br />

    </form>

</body>

</html>




//display.aspx.cs


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.OleDb;


namespace WebApplication1

{

    public partial class display : System.Web.UI.Page

    {

        OleDbConnection conn = new OleDbConnection();

        OleDbCommand cmd = new OleDbCommand();


        protected void Page_Load(object sender, EventArgs e)

        {

            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\archi\\OneDrive\\Documents\\practice.mdb";

            conn.Open();


            OleDbDataAdapter da = new OleDbDataAdapter();

            DataTable ds = new DataTable();

            da = new OleDbDataAdapter("select * from book_db", conn);

            da.Fill(ds);

            

        }

 

    }

}






Comments

Post a Comment