asp.net core docker Part 2 Display database table metadata in asp net web application

Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat...

Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspo...

Dot net written test
1. Create an asp.net web page with a dropdownlist and a gridview control.
2. When the page loads the dropdownlist should be populated with all the table names that are in a specific sql server database
3. Upon selecting a table from the dropdownlist, the respective table metadata i.e all the column names and their datatypes must be displayed in the gridview control.

In the Sample database we have 2 tables - Departments and Employees

DropDownList on the WebForm should display both the table names

When a table is selected from the DropDownList, it's metadata should be displayed in the GridView control

Step 1: Use the following SQL script to create database tables.
Create table Departments
(
ID int primary key identity,
Name nvarchar(50),
Location nvarchar(50)
)

Create table Employees
(
ID int primary key identity,
FirstName nvarchar(50),
LastName nvarchar(50),
Gender nvarchar(50),
Salary int,
DepartmentId int foreign key references Departments(Id)
)

Step 2: Stored procedures to retrieve the list of table names and their metadata.
Create Procedure spGetAllTables
as
Begin
Select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE'
End

Create Procedure spGetTableMetaData
@TableName nvarchar(50)
as
Begin
Select COLUMN_NAME, DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @TableName
End

Step 3: Create an asp.net web application. Drag and drop a DropDownList control.

a) Set AutoPostBack="true"
b) Double click on the DropDownList1 control to generate the click event handler.

Step 4: Drag and drop a GridView control and AutoFormat it to select "Colourful" scheme. Add 2 bound columns
a) For the first bound column set DataField="Column_Name" HeaderText="Column Name"
b) For the second bound column set DataField="Data_Type" HeaderText="Data Type"
c) Set AutoGenerateColumns="False"

Step 5: Copy and paste the following code in the code-behind file.
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

namespace DatabaseTables
{ public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownList1.DataTextField = "TABLE_NAME"; DropDownList1.DataValueField = "TABLE_NAME"; DropDownList1.DataSource = GetAllTables(); DropDownList1.DataBind(); DropDownList1.Items.Insert(0, new ListItem("Select Table", "-1")); } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedValue != "-1") { GridView1.DataSource = GetTableMetaData(DropDownList1.SelectedValue); GridView1.DataBind(); } } private DataTable GetAllTables() { string cs = ConfigurationManager.ConnectionStrings["SampleDBCS"].ConnectionString; SqlConnection con = new SqlConnection(cs); SqlDataAdapter da = new SqlDataAdapter("spGetAllTables", con); DataTable dataTable = new DataTable(); da.Fill(dataTable); return dataTable; } private DataTable GetTableMetaData(string tableName) { string cs = ConfigurationManager.ConnectionStrings["SampleDBCS"].ConnectionString; SqlConnection con = new SqlConnection(cs); SqlDataAdapter da = new SqlDataAdapter("spGetTableMetaData", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@TableName", tableName)); DataTable dataTable = new DataTable(); da.Fill(dataTable); return dataTable; } }
}

asp.net core docker Part 2 Display database table metadata in asp net web application
103 Likes	103 Dislikes
35,849 views views	524K followers
Education	Upload TimePublished on 10 May 2014

Related keywords

wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,display inline-block,craigslist nj,wcf one piece,asp.net core 3,ajax players,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,database normalization,services angular,database management system,ajax ontario,asp.net mvc tutorial,display driver,asp.net cos'è,csharp assembly,displayport cable,database types,tutorialspoint python,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,asp.net zero,csharp foreach,server memes,sql date format,services online,database online,chase,serverless architecture,display flex css,server resume,wcf c#,server books,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,database.ensurecreated(),display resolution,ajax deadpool,display flex,server jobs,cvs,website,mvc tutorial,costco hours,display meaning,wcf service application,tutorialspoint spring,serverless,wcf soap,wcf cat,cool math games,wcf test client,displayport,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,mvconnect,cunyfirst,asp.net guida,wcf nba,csharp download,wcfi foundation,csharp online,wcf authentication,tutorials near me,display driver uninstaller,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,serverminer,ajax cleaner,ado.net visual studio 2019,webassign,database diagram online,ado.net vs entity framework,ado.net visual studio 2017,csharp list,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,ajax roster,mvc architecture,http://ado.net,display wallpaper,asp.net core mvc,ajax soccer,server hosting,database schema online,wcfi,ajax dish soap,display price in bangladesh,capital one,server rack,tutorialspoint html,csharp interface,database disk image is malformed,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,database administrator,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,database index,mvc framework,ajax paving,mvc near me,database migration,database schema,tutorialspoint spring boot,database developer,mvc map,csharp online compiler,asp.net download,sql between,ado.net c# pdf,services tag dell,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,csharpstar,wcf tutorial,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,ado.net c#,asp.net core github,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,server error in '/' application,services windows,asp.net core 3.0,sql injection,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,displayport vs hdmi,services google play apk,sqlyog,database first,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,webcam,mvc hours,webmd symptom,csharp array,displayport to hdmi,csharp enum,display picture,ajax call,asp.net core 2. guida completa per lo sviluppatore,asp.net core,server pro,server status ffxiv,database is,cheap flights,webcrims,asp.net core hosting,services sas,database management systems,tutorialspoint java,tutorialspoint java compiler,webmd,csharp to json,college football,ado.net dataset,csharp dictionary,cnn,website builder,tutorialspoint sql,asp.net web api,server side rendering,weber grills,sql server 2017,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,webster bank,webstaurant,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,ajax jersey,csharp operator,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,database design,century 21,services consultores,services consulting,database diagram,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,sql update,asp.net tutorial,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,display device,chase online,display css,wcf api,display advertising,costco,database это,server jobs near me,webex,sql meaning,sql tutorial,sql commands,display block in css,ado.net entity framework,ajax tavern,tutorialsteacher,databases list,ajax javascript,services desk,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,display table,mvcu,asp.net core middleware,wcf web service,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,display test,