AWP

7b. Aim :- Displaying phone number, author name using author name.

        // using System.Data.SqlClient;
        protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conString = new SqlConnection("Data
Source=DESKTOP-V2K2VGF;Initial Catalog=college;Integrated Security=True");
conString.Open();
SqlCommand cmdQuery = new SqlCommand("Select * from student1",conString);
SqlDataAdapter sda = new SqlDataAdapter(cmdQuery); DataSet
dsData = new DataSet();
sda.Fill(dsData);
DropDownList1.DataSource = dsData;
DropDownList1.DataTextField = "name";
DropDownList1.DataValueField = "Phone";
DropDownList1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = "You have Selected " + DropDownList1.SelectedValue;
}

6b. Aim :- Displaying record from Database.

        //using System.Data.SqlClient;
        
        protected void Page_Load(object sender, EventArgs e)
{
    
}

protected void Button1_Click1(object sender, EventArgs e)
{
    SqlConnection conn = new SqlConnection("Data Source=HITESH\\SQLEXPRESS01;Initial Catalog=pract;Integrated Security=True");
    conn.Open();
    SqlCommand cmd = new SqlCommand("select name,local from info",conn);
    SqlDataReader rd = cmd.ExecuteReader();

    while(rd.Read())
    {
        Label1.Text += rd["name"] + " " + rd["local"]+"<br>";
    }
}

6a. Aim :- Multiline Textbox for Query Processing.

        //using System.Data.SqlClient;
        protected void Page_Load(object sender, EventArgs e)
{
    
}

protected void Button1_Click(object sender, EventArgs e)
{
    SqlConnection conn = new SqlConnection("Data Source=HITESH\\SQLEXPRESS01;Initial Catalog=pract;Integrated Security=True");
    conn.Open();
    SqlCommand cmd = new SqlCommand(TextBox1.Text, conn);
    SqlDataReader rd = cmd.ExecuteReader();
    ListBox1.Items.Clear();

    while (rd.Read())
    {
        for(int i = 0; i < rd.FieldCount; i++)
        {
            ListBox1.Items.Add(rd[i].ToString());
        }
    }
}

8a. Aim :- Create a web application to demonstrate use of GridView.

        using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication4
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=DESKTOP-V2K2VGF;Initial Catalog=college;Integrated Security=True");
            conn.Open();

            SqlCommand cmd = new SqlCommand("UPDATE student1 SET name = @name, city = @city, phone = @phone WHERE id = @id", conn);
            cmd.Parameters.AddWithValue("@id", TextBox1.Text);
            cmd.Parameters.AddWithValue("@name", TextBox2.Text);
            cmd.Parameters.AddWithValue("@city", TextBox3.Text);
            cmd.Parameters.AddWithValue("@phone", TextBox4.Text);
            cmd.ExecuteNonQuery();

            conn.Close();
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=DESKTOP-V2K2VGF;Initial Catalog=college;Integrated Security=True");
            conn.Open();

            SqlCommand cmd = new SqlCommand("INSERT INTO student1 VALUES(@id, @name, @city, @phone)", conn);
            cmd.Parameters.AddWithValue("@id", TextBox1.Text);
            cmd.Parameters.AddWithValue("@name", TextBox2.Text);
            cmd.Parameters.AddWithValue("@city", TextBox3.Text);
            cmd.Parameters.AddWithValue("@phone", TextBox4.Text);
            cmd.ExecuteNonQuery();

            Label1.Text = "Entry successful.";
            conn.Close();
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            TextBox1.Text = "";
            TextBox2.Text = "";
            TextBox3.Text = "";
            TextBox4.Text = "";
        }

        protected void Button4_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=DESKTOP-V2K2VGF;Initial Catalog=college;Integrated Security=True");
            conn.Open();

            SqlCommand cmd = new SqlCommand("DELETE FROM student1 WHERE id = @id", conn);
            cmd.Parameters.AddWithValue("@id", TextBox1.Text);
            cmd.ExecuteNonQuery();

            Label1.Text = "Deletion successful.";
            conn.Close();
        }

        protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {
        }

        protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
        {
            TextBox1.Text = GridView1.SelectedRow.Cells[1].Text;
            TextBox2.Text = GridView1.SelectedRow.Cells[2].Text;
            TextBox3.Text = GridView1.SelectedRow.Cells[3].Text;
            TextBox4.Text = GridView1.SelectedRow.Cells[4].Text;
        }
    }
}

9a. Aim :- Create a web application to demonstrate use of various Ajax controls.

//aspx code
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace awppratice
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Label1.Text = System.DateTime.Now.ToString();
        }
    }
}


//design code
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace awppratice
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Label1.Text = System.DateTime.Now.ToString();
        }
    }
}

10a. Aim :- Create a web application to demonstrate JS Bootstrap Button.

        <!-- <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="boot.aspx.cs"
Inherits="bootstrap.boot" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript"
src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js">
</script>
<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/twitterbootstrap/3.0.3/css/bootstrap.min.css"
media="screen" />
<script type="text/javascript"
src="https://cdnjs.cloudflare.com/ajax/libs/twitterbootstrap/3.0.3/js/bootstrap.min.js">
</script>
</head>
<body>
<button type="button" class="btn btn-info btn-lg" data-toggle="modal" data-target="#myModal">Open
Modal</button>
<div id="myModal" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Hi this is my first modal</h4>
</div>
<div class="modal-body">
<p>Bootstrap is the Best...!</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</body>
</html> -->

Prime number

        using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            bool flag=true;
            Console.WriteLine("Enter number till you want to check : ");
            int n = int.Parse(Console.ReadLine());
            for(int i = 2; i <= n; i++)
            {
                for(int j = 2; j <= n; j++)
                {
                    if (i!=j && i%j==0)
                    {
                        flag = false;
                        break;
                    }
                }
                if (flag)
                {
                    Console.WriteLine("Prime number is : "+i);
                }
                flag = true;
            }
            Console.ReadLine();
        }
    }
}

Boxing and Unboxing

        using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Enter nuumber : ");
            int num = int.Parse(Console.ReadLine());
            Console.WriteLine("*********Boxing**********");
            object o = num;
            Console.WriteLine("object o = "+o);
            Console.WriteLine("********UnBoxing***********");
            int m = (int)o;
            Console.WriteLine("integer = "+m);
            Console.ReadKey();
        }
    }
}

fibonacci

        using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            int f0 = 0, f1 = 1, fib = 0;
            Console.WriteLine("Enter number of Element you want to display : ");
            int n = int.Parse(Console.ReadLine());
            Console.WriteLine("*********fib*******");
            Console.WriteLine(f0);
            Console.WriteLine(f1);
            for(int i=0; i < n - 2; i++)
            {
                fib = f0 + f1;
                Console.WriteLine(fib);
                f0 = f1;
                f1 = fib;
            }
            Console.ReadKey();
        }
    }
}

1b. Floyds Triangle

        using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            int n = 1;
            Console.WriteLine("Enter number of Rows : ");
            int r = int.Parse(Console.ReadLine());
            for(int i = 0; i < r; i++)
            {
                for(int j=0;j<i+1;j++)
                {
                    Console.Write(n + "\t");
                    n += 1;
                }
                Console.WriteLine("");
            }
            Console.ReadKey();
        }
    }
}

Arithmetic

        using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        int a, b;
        public Program()
        {
            Console.WriteLine("Enter two number : ");
            a = Convert.ToInt32(Console.ReadLine());
            b = Convert.ToInt32(Console.ReadLine());
        }
        int Add()
        {
            return a + b;
        }
        int Sub()
        {
            return a - b;
        }
        int Mul()
        {
            return a * b;
        }
        int Div()
        {
            return a / b;
        }
        static void Main(string[] args)
        {
            Console.WriteLine("*****Arithmetic********");
            Program p = new Program();
            Console.WriteLine("Addition = " + p.Add());
            Console.WriteLine("Sub = " + p.Sub());
            Console.WriteLine("Mul = " + p.Mul());
            Console.WriteLine("Div = " + p.Div());
            console.ReadKey();
        }
    }
}

delegate

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp1
{
    class Program
    {
        public delegate int Mathoperation(int a, int b);
        public static int Add(int a, int b)
        {
            return a + b;
        }
        public static int Sub(int a, int b)
        {
            return a - b;
        }
        static void Main(string[] args)
        {
            Mathoperation Addition = new Mathoperation(Add);
            Mathoperation Subs = new Mathoperation(Sub);

            Console.WriteLine("Enter two number : ");
            int a = int.Parse(Console.ReadLine());
            int b = int.Parse(Console.ReadLine());

            Console.WriteLine("Add = " + Addition(a, b));
            Console.WriteLine("Sub = " + Subs(a, b));
            Console.ReadKey();
        }
    }
}

interface

        using System;

namespace InterfaceExample
{
    // Define an interface with two methods: Add and Subtract
    public interface IMathOperations
    {
        int Add(int a, int b);
        int Subtract(int a, int b);
    }

    // Implement the IMathOperations interface in a class
    public class Calculator : IMathOperations
    {
        // Implement Add method
        public int Add(int a, int b)
        {
            return a + b;
        }

        // Implement Subtract method
        public int Subtract(int a, int b)
        {
            return a - b;
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            // Create an instance of the Calculator class
            IMathOperations calculator = new Calculator();

            // Input values
            Console.Write("Enter the first number: ");
            int num1 = Convert.ToInt32(Console.ReadLine());

            Console.Write("Enter the second number: ");
            int num2 = Convert.ToInt32(Console.ReadLine());

            // Perform operations using the interface methods
            int sum = calculator.Add(num1, num2);
            int difference = calculator.Subtract(num1, num2);

            // Output results
            Console.WriteLine($"Addition: {num1} + {num2} = {sum}");
            Console.WriteLine($"Subtraction: {num1} - {num2} = {difference}");

            Console.ReadKey(); // Pause to view results before closing
        }
    }
}

5a. Session

        //first WebForm1.aspx
        using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace awppratice
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Session["name"] = TextBox1.Text;
            Session["city"] = TextBox2.Text;
            Response.Redirect("WebForm2.aspx");
        }
    }
}

//second WebForm2.aspx
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace awppratice
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            TextBox1.Text = Session["name"].ToString();
            TextBox2.Text = Session["city"].ToString();
        }
    }
}

Adrotator

        //xml file
        
        
<Advertisements>
	<Ad>
		<ImageUrl>https://res.klook.com/image/upload/c_fill,w_750,h_563/q_80/w_80,x_15,y_15,g_south_west,l_Klook_water_br_trans_yhcmh3/activities/tsah7c9evnal289z5fig.jpg</ImageUrl>
		<AlternateText>google</AlternateText>
		<NavigateUrl>https://google.com</NavigateUrl>
		<Impressions>20</Impressions>
		<Keyword>google</Keyword>
	</Ad>
	<Ad>
		//Add more adds
	</Ad>
</Advertisements>

cookies

        //Page 1
        protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookies2 = new HttpCookie("visit");
cookies2.Value = "1";
Response.Cookies.Add(cookies2);
Label1.Text = cookies2.Value;
}

//Page 2
protected void Page_Load(object sender, EventArgs e)
{
int co_val = Convert.ToInt32(Request.Cookies["visit"].Value) + 1;
HttpCookie cookies2 = new HttpCookie("visit");
cookies2.Value = co_val.ToString();
Response.Cookies.Add(cookies2);
Label1.Text = co_val.ToString();
}

//Page 3
protected void Page_Load(object sender, EventArgs e)
{
int co_val = Convert.ToInt32(Request.Cookies["visit"].Value) + 1;
HttpCookie cookies1 = new HttpCookie("visit");
cookies1.Value = co_val.ToString();
Response.Cookies.Add(cookies1);
Label1.Text = co_val.ToString();
Response.Cookies["visit"].Expires = DateTime.Now.AddSeconds(5);
}

//Page 4
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["visit"] == null)
{
Label1.Text = "No Cookies Found";
}
}

setting of 3a

        <appSettings>
	<add key="ValidationSettings:UnobtrusiveValidationMode" value="None"/>
</appSettings>

Calendar

            <form id="form1" runat="server">
        <div>
        </div>
        <asp:Calendar ID="Calendar1" runat="server" OnDayRender="Calendar1_DayRender" OnSelectionChanged="Calendar1_SelectionChanged"></asp:Calendar>
        <br />
        Your selected date : <asp:Label ID="Label1" runat="server"></asp:Label>
        <br />
        Today's Date :
        <asp:Label ID="Label2" runat="server"></asp:Label>
        <br />
        Ganpati Vacation Start :
        <asp:Label ID="Label3" runat="server"></asp:Label>
        <br />
        Days Remaining for Ganpati Vacation :
        <asp:Label ID="Label4" runat="server"></asp:Label>
        <br />
        Days remaining for new year :
        <asp:Label ID="Label5" runat="server"></asp:Label>
        <br />
        <br />
        <asp:Button ID="btnResult" runat="server" Height="26px" OnClick="btnResult_Click" Text="Result" />
 
        <asp:Button ID="btnReset" runat="server" OnClick="btnReset_Click" Text="Reset" />
    </form>   
    
    //aspx
    protected void Page_Load(object sender, EventArgs e)
{

}

protected void btnResult_Click(object sender, EventArgs e)
{
    Calendar1.Caption = "SAMBARE";
    Calendar1.FirstDayOfWeek = FirstDayOfWeek.Sunday;
    Calendar1.NextPrevFormat = NextPrevFormat.ShortMonth;
    Calendar1.TitleFormat = TitleFormat.Month;

    Label2.Text = "Todays Date" + Calendar1.TodaysDate.ToShortDateString();
    Label3.Text = "Ganpati Vacation Start: 9-07-2024";
    TimeSpan d = new DateTime(2024, 9, 07) - DateTime.Now;
    Label4.Text = "Days Remaining For Ganpati Vacation:" + d.Days.ToString();
    TimeSpan d1 = new DateTime(2024, 12, 31) - DateTime.Now;
    Label5.Text = "Days Remaining for New Year:" + d1.Days.ToString();
    if (Calendar1.SelectedDate.ToShortDateString() == "9-07-2024")
        Label3.Text = "<b>Ganpati Festival Start </b>";
    if(Calendar1.SelectedDate.ToShortDateString() == "9-17-2024")
        Label3.Text = "<b>Ganpati Festival End </b>";
}

protected void btnReset_Click(object sender, EventArgs e)
{
    Label1.Text = "";
    Label2.Text = "";
    Label3.Text = "";
    Label4.Text = "";
    Label5.Text = "";
    Calendar1.SelectedDates.Clear();
}

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
    Label1.Text = "Your Selected Date:" + Calendar1.SelectedDate.Date.ToString();
}

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
    if(e.Day.Date.Day == 5 && e.Day.Date.Month == 9)
    {
        e.Cell.BackColor = System.Drawing.Color.Yellow;
        Label lbl = new Label();
        lbl.Text = "<br>Teachers Day!";
        e.Cell.Controls.Add(lbl);
        Image g1 = new Image();
        g1.ImageUrl = "td.jpg";
        g1.Height = 20;
        g1.Width = 20;
        e.Cell.Controls.Add(g1);
    }
    if(e.Day.Date.Day == 13 && e.Day.Date.Month == 9)
    {
        Calendar1.SelectedDate = new DateTime(2024, 9, 7
            
            );
        Calendar1.SelectedDates.SelectRange(Calendar1.SelectedDate, Calendar1.SelectedDate.AddDays(10));
        Label lbl1 = new Label();
        lbl1.Text = "<br>Ganpati!";
        e.Cell.Controls.Add(lbl1);
    }
}

Download PDF 1-5 and 9-10