Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading…
Transcript

Technical Lead:- Yogesh Sir

ADO.NET

CRUD OPERATIONS

  • We used ADO.NET to take data from PostgreSQL.

  • ADO.NET provides a bridge between the front end controls and the back end database.

  • We installed NpgSql package.

  • We used NpgSqlConnection to connect to PostgreSql.

  • Syntax:

using (NpgsqlConnection con = new

NpgsqlConnection(connection string));

Example:

Using ADO.NET

Jquery & AJAX

  • We had implemented Validations using Jquery.

  • With Jquery we called update,delete functions.

  • AJAX is a development technique used to create interactive web applications.

  • With AJAX, web applications can retrieve data from the server asynchronously, without reloading the page.

Jquery & AJAX

AJAX calling:

Jquery Validations

PostgreSQL Functions

PostgreSQL

  • A PostgreSQL function is a set of SQL that are stored on the database server and can be invoked using the SQL.

  • We had created functions in PostgreSQL for retrieving, deleting,updating and inserting the data.

  • These functions are created using Ref Cursor, so it can handle large data easily.

  • These functions are invoked in the model class of the project.

Example:

create or replace function insertdata(

ref1 refcursor,

con integer,

n_id integer = 0,

n_name varchar = null,

n_city varchar = null

)

returns refcursor AS

$func$

begin

if con = 1 then

insert into mytbl(Nid,Nname,Ncity)

values(n_id,n_name,n_city);

open ref1 for

select * from table_name order by Nid desc limit 1;

return ref1;

end if;

Insert function

Function

  • This way, we have created different functions for each operations.

Output:

MasterPage Layout

  • The Master page is a feature that enables us to define common structure and interface markup elements for the website layout.

  • We had made Universities page as a Master page in our project.

MasterPage Layout

Example:

  • University is the master page.
  • University will redirect to the college page.
  • College page will redirect to Branches page according to college selected.
  • Branches page have to button links: student and faculty.
  • Students page is displayed according to branches selected.
  • Faculties page is displayed according to branches selected.

THANK YOU

Learn more about creating dynamic, engaging presentations with Prezi