👉🏻Repeater control V/S GridView which on e is better and why?

The choice between using a Repeater control or a GridView control in ASP.NET depends on the specific requirements of the project and the features needed for the presentation of data. Both controls are used to display data from a data source, but they have some key differences in terms of functionality and flexibility.

A GridView control is a more advanced control that provides many features out of the box, such as sorting, filtering, paging, and editing of data. It is a highly customizable control that allows developers to easily bind data from a variety of data sources, including databases, XML, and custom collections. With GridView, developers can easily customize the appearance of data by using templates for columns, rows, and headers.

On the other hand, a Repeater control is a more basic control that provides a greater degree of flexibility in terms of layout and styling. The Repeater control does not have built-in support for features such as sorting, filtering, or editing of data. Instead, it is designed to display data in a highly customizable way, allowing developers to fully control the HTML markup and layout of the rendered data. With a Repeater control, developers can easily customize the appearance of data by using templates for item layout, header, and footer.

So, if the project requires advanced features such as sorting, filtering, and editing of data, then GridView control would be the better option. However, if the project requires a greater degree of flexibility in terms of layout and styling, or if the data being displayed is relatively simple, then Repeater control would be a better choice.

In conclusion, both controls have their own unique strengths and weaknesses, and the choice between them should be based on the specific requirements of the project.

School Database Query:
————————————-
CREATE DATABASE SchoolManagementSystem;
USE SchoolManagementSystem;

CREATE TABLE Grades (
GradeID INT PRIMARY KEY IDENTITY(1,1),
GradeName VARCHAR(50) NOT NULL
);

CREATE TABLE Subjects (
SubjectID INT PRIMARY KEY IDENTITY(1,1),
SubjectName VARCHAR(50) NOT NULL
);

CREATE TABLE Classes (
ClassID INT PRIMARY KEY IDENTITY(1,1),
ClassName VARCHAR(50) NOT NULL,
GradeID INT NOT NULL,
FOREIGN KEY (GradeID) REFERENCES Grades(GradeID)
);

CREATE TABLE Teachers (
TeacherID INT PRIMARY KEY IDENTITY(1,1),
TeacherName VARCHAR(50) NOT NULL,
Email VARCHAR(100) NOT NULL,
Phone VARCHAR(20) NOT NULL,
Address VARCHAR(100) NOT NULL
);

CREATE TABLE Students (
StudentID INT PRIMARY KEY IDENTITY(1,1),
StudentName VARCHAR(50) NOT NULL,
DateOfBirth DATE NOT NULL,
Gender VARCHAR(10) NOT NULL,
Address VARCHAR(100) NOT NULL,
Phone VARCHAR(20) NOT NULL,
Email VARCHAR(50) NOT NULL,
DateEnrolled DATE NOT NULL
);

CREATE TABLE ClassTeachers (
ClassID INT NOT NULL,
TeacherID INT NOT NULL,
PRIMARY KEY (ClassID, TeacherID),
FOREIGN KEY (ClassID) REFERENCES Classes(ClassID),
FOREIGN KEY (TeacherID) REFERENCES Teachers(TeacherID)
);

CREATE TABLE Enrollments (
EnrollmentID INT PRIMARY KEY IDENTITY(1,1),
StudentID INT NOT NULL,
ClassID INT NOT NULL,
EnrollmentDate DATE NOT NULL,
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (ClassID) REFERENCES Classes(ClassID)
);

CREATE TABLE Assignments (
AssignmentID INT PRIMARY KEY IDENTITY(1,1),
AssignmentName VARCHAR(50) NOT NULL,
SubjectID INT NOT NULL,
ClassID INT NOT NULL,
TeacherID INT NOT NULL,
DueDate DATE NOT NULL,
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID),
FOREIGN KEY (ClassID) REFERENCES Classes(ClassID),
FOREIGN KEY (TeacherID) REFERENCES Teachers(TeacherID)
);

CREATE TABLE GradesSubjects (
GradeID INT NOT NULL,
SubjectID INT NOT NULL,
PRIMARY KEY (GradeID, SubjectID),
FOREIGN KEY (GradeID) REFERENCES Grades(GradeID),
FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID)
);

new video aagya
https://youtu.be/MiuoElqOETQ

🌱SQL Handwritten Notes
Follow @coder_baba #coderbaba #SQL
SQL is the one of the important topic of any technical interview.
Make sure you are well prepared for it.

I am sharing this simple and scrips notes on SQL, hope it helps you understand SQL in simple way.

Do not forget to follow @coder_baba for more such awesome technical notes.

credit : Unknown

LINQ in .NET
👇👇👇💪superb short video ye nahi dekha to kya dekha💪👇👇👇
https://youtube.com/shorts/O8pL-e7eODw?feature=share

Microsoft Giving Free Machine Learning Course: Enroll Now
Name: Foundations of data science for machine learning
Duration: 12 Hours 45 mins
Number of Modules: 14
Difficulty level: Beginner
Offered By: Microsoft
Rating: 4.8/5

Click here to enroll now
Link: https://bit.ly/3Av8SW7

Hi guys 🌞

Don't miss this opportunity!

Bookmark this page and dive into my curated curriculum.

Eager to learn Data Engineering?

Ive crafted a comprehensive, free Data Engineering course just for you!

Free lessons to get you interview-ready and move ahead of 90% of people.

1. Master Python: https://lnkd.in/e5rCbvP8

2. Learn SQL: https://lnkd.in/efMKFkfX

3. Learn MySQL: https://lnkd.in/efk-Mi3c

4. Learn MongoDB: https://lnkd.in/eMKPWtqX

5. Dominate PySpark: https://lnkd.in/exwA2hKz

6. Learn Bash, Airflow & Kafka: https://lnkd.in/eyN6u2yd

7. Learn Git & GitHub: https://lnkd.in/eX_Q8s99
8. Learn How to Structure Project: https://lnkd.in/dWwnYbA3

9. Learn CICD basics: https://lnkd.in/epKGVFY

10. Decode Data Warehousing: https://lnkd.in/eKnVbFAB

11. Leam DBT: : https://lnkd.in/eG9eaEuE

12. Learn Data Lakes: https://lnkd.in/eQ9xxAJT

13. Learn DataBricks: https://lnkd.in/ePZpCv86

14. Learn Azure Databricks: https://lnkd.in/eBij4akJ

15. Leam Snowflake: https://lnkd.in/erETmtFU

16. Learn Apache NiFi: http://bit.ly/43btwy

17. Leam Debezium: http://bit.ly/3K6W5gL

👇
Subscribe my YT channel: https://youtu.be/dVLGhhEUvBc
Join my Telegram @Coder_Baba

Free SQL Course:
https://www.codecademy.com/learn/learn-sql

Become Expert in GitHub
https://www.udemy.com/course/git-expert-4-hours/

🧜‍♂️Free Project with source code:🧜‍♂️
👇👇👇👇👇👇👇👇👇

1-Online Shopping Website
2-Weather Updates
3-Library Project
4-Hospital Project in C
5-Banking Application
6-BusReservation
7-MovieTicket
8-Food Ordering

Follow👉🏻 @Coder_Baba