Prog TSQL

PROJECT

Programming with Transact SQL

Overview

In this project,= you will create four web pages that allow you to work with the authors table in= the Pubs database.

3D"*" The First Page will show you a list of Authors

3D"*" The Second page will allow a user to add a new author

3D"*" The Third page will allow a user to delete an author

3D"*" The Forth page will allow a user to update a author Phone number

Scenario

Consider these factors while doing the projec= t:

<= img width=3D17 height=3D17 src=3D"ProgrammingTSQLProject_files/image001.gif" al= t=3D"*"> Only five of the= columns in the Authors table are required (au_id, au_lname, au_fname, phone, contract)

<= img width=3D17 height=3D17 src=3D"ProgrammingTSQLProject_files/image001.gif" al= t=3D"*"> Start with a sim= ple web page at first and expand on it only after you get the simple one workin= g

<= img width=3D17 height=3D17 src=3D"ProgrammingTSQLProject_files/image001.gif" al= t=3D"*"> This project sho= uld use ASP.NET for the web pages

<= img width=3D17 height=3D17 src=3D"ProgrammingTSQLProject_files/image001.gif" al= t=3D"*"> Validation logic= is NOT required for this project

Outcome

The project should be considered done when the following is comple= te:

3D"*" You have all web pages that run as intended

Examples

using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection conSQL =3D new SqlConnection();

conSQL.ConnectionString =3D "Integrated Security=3DTrue;Data Source=3DLocalHost;Initial Catalog=3DPubs;";

conSQL.Open();

SqlCommand commSQL =3D new SqlCommand();

commSQL.Connection =3D conSQL;

commSQL.CommandText =3D "Select au_lname, au_fname from authors";

SqlDataReader datRead;<= /p>

datRead =3D commSQL.ExecuteReader();

while (datRead.Read() =3D=3D <= /b>true)

        {

        =     Response.Write(datRead.GetString(1) + " " + datRead.GetString(0) + "<br />" ) ;

        }

        datRead.Close();

        conSQL.Close();

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        SqlConnection conSQL =3D new SqlConnection();

        conSQL.ConnectionString =3D "Integrated Security=3DTrue;Data Source=3DLocalHost;Initial Catalog=3DPubs;";

        conSQL.Open();

        SqlCommand commSQL =3D new SqlCommand();

        commSQL.Connection =3D conSQL;

        commSQL.CommandText =3D "Insert In= to DemoTable Values( '" + TextBox1.Text + "' )"= ;

        commSQL.BeginExecuteNonQuery();

    }