Advance Web Programming | TYIT | MU |Practical 6 B: Display Records using Database(SQL Server).

Описание: Advance Web Programming | TYIT | MU |Practical 6 B: Display Records using Database(SQL Server).

Full video:-
Short Video:-   • Advance Web Programming | TYIT | MU |Pract...  

✅ Practical 6 (B) Create a web application to display records by using database.

✅ Steps to Implement in ASP.NET
🔶 Step 1: Create Database and Table in SQL Server
CREATE DATABASE CollegeDB;
GO
USE CollegeDB;
GO

CREATE TABLE Students(
StudentID INT IDENTITY(1,1) PRIMARY KEY,
Name NVARCHAR(100),
Age INT,
Class NVARCHAR(50)
);

-- Insert sample records
INSERT INTO Students (Name, Age, Class) VALUES
('Ajay Bansode', 20, 'TYIT'),
('Riya Sharma', 19, 'SYIT'),
('Vikram Patil', 21, 'TYIT'),
('Neha Joshi', 20, 'FYIT');

🔶 Step 2: Create Web Application
Open Visual Studio → File → New → Project → Select ASP.NET Web Application (.NET Framework).
Choose Web Forms template.

🔶 Step 3: Add Connection String in web.config
<connectionStrings>
<add name="DBConn"
connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=CollegeDB;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

🔶 Step 4. Create a Page Display.aspx
Add Grid View to display data

🔶 Step 5: Code-Behind (Display.aspx.cs)

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}

private void BindGrid()
{
string connStr = ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString;
using (SqlConnection con = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand("SELECT StudentID, Name, Age, Class FROM Students", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

gvStudents.DataSource = dt;
gvStudents.DataBind();
}
}
}
🔶 Step 6:Run the Application
Press F5 → Open Display.aspx.
You’ll see all student records displayed in a GridView. 🎉

✨ Final Output
A simple web page that shows all student records from SQL Server inside a GridView.
👉 No edit, no delete, no search — only read/display operation.

Git Hub Link Repository
https://github.com/BansodeTechSolutio...

Advance Web Programming Practical Playlist
   • Advance Web Programming Practical TyIt Mum...  

#Subscribe the Channel Link :- #bansodetechsolution #ajupgrading
https://www.youtube.com/c/AjUpgrading...

If you have any Queries or Doubts DM me on #instagram:- #bansode_ajay_2102
https://www.instagram.com/bansode_aja...
@AjUpgradingBANSODETECHSOLUTION

LinkedIn Profile
  / aj-upgrading-bansode-tech-solution-0a99657a  

Link for slides, code samples, and text version of the video #blogger
https://bansodetechsolution.blogspot.com