asp.net core docker Part 1 How to retrieve data from different databases in asp net

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...

Several of our youtube channel subscribers faced this question in a dot net written test.
We have 2 databases
1. USADB - Contains Employees table that stores only US Employees
2. UKDB - Contains Employees table that stores only UK Employees

Implement an asp.net web page that retrieves data from the Employees table both from USADB and UKDB databases.

Add a webform to the project. Drag and drop a GridView control on the webform. Copy and paste the following code in the code-behind file.
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace Demo
{ public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string USADBCS = ConfigurationManager.ConnectionStrings["USADB"].ConnectionString; string UKDBCS = ConfigurationManager.ConnectionStrings["UKDB"].ConnectionString; SqlConnection con = new SqlConnection(USADBCS); SqlDataAdapter da = new SqlDataAdapter("select * from Employees", con); DataSet ds1 = new DataSet(); da.Fill(ds1); con = new SqlConnection(UKDBCS); da.SelectCommand.Connection = con; DataSet ds2 = new DataSet(); da.Fill(ds2); ds1.Merge(ds2); Gridview1.DataSource = ds1; Gridview1.DataBind(); } }
}

asp.net core docker Part 1 How to retrieve data from different databases in asp net
348 Likes	348 Dislikes
101,317 views views	524K followers
Education	Upload TimePublished on 3 May 2014

Related keywords

wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,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,questions to ask a girl,servers for minecraft,asp.net core dependency injection,ado.net tutorial,services angular,ajax ontario,questions to ask at the end of an interview,asp.net mvc tutorial,freshers fair,.net framework 4.6.1,asp.net cos'è,.net framework 4.6.2,csharp assembly,tutorialspoint python,freshers party,freshers week glasgow 2019,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,questions to ask people,asp.net zero,csharp foreach,server memes,sql date format,services online,chase,freshers meaning,serverless architecture,server resume,freshers flu,wcf c#,server books,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,ajax deadpool,server jobs,cvs,website,mvc tutorial,costco hours,freshers,wcf service application,.net 3.5,tutorialspoint spring,serverless,wcf soap,questions to fall in love,.net framework 4.5.2,wcf cat,cool math games,wcf test client,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,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,serverminer,questions for kids,ajax cleaner,ado.net visual studio 2019,questions to ask interviewer,webassign,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,questions to ask your girlfriend,http://ado.net,asp.net core mvc,ajax soccer,server hosting,wcfi,freshersworld aptitude,ajax dish soap,capital one,questions about me,server rack,tutorialspoint html,csharp interface,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,tutorialspoint python 3,questions to ask siri,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,tutorialspoint spring boot,.net framework 4.7.2,mvc map,csharp online compiler,asp.net download,sql between,ado.net c# pdf,services tag dell,wcf 2019 nba,questions to ask a guy,csharp switch,ado.net ventajas y desventajas,csharpstar,wcf tutorial,tutorialspoint,freshersnow,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,.net que es,freshersvoice,questions to ask,freshers jobs,services windows,asp.net core 3.0,sql injection,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,services google play apk,sqlyog,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,.net framework 4.7,.net core 3,webcam,.net framework 4.8,.net framework 4.5,mvc hours,.net framework 4.6,webmd symptom,csharp array,.net framework 4.0,questions for couples,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,.net framework 3.5 sp1,asp.net core,server pro,server status ffxiv,cheap flights,webcrims,asp.net core hosting,services sas,freshers week oxford 2019,tutorialspoint java,tutorialspoint java compiler,questions game,webmd,.net framework,csharp to json,college football,ado.net dataset,csharp dictionary,questions to ask your friends,cnn,website builder,tutorialspoint sql,asp.net web api,server side rendering,freshers interview questions,freshers day,weber grills,sql server 2017,freshers resume template,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,questions to get to know someone,freshers week,webster bank,.net framework 3.5,freshersworld govt jobs,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,questions to ask your crush,csharp random,freshers resume,century 21,.net framework 3.5 windows 10,services consultores,services consulting,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,questions to ask your bf,chase online,.net core,wcf api,costco,server jobs near me,webex,.net framework 2.0,sql meaning,sql tutorial,freshers resume sample,questions to ask alexa,sql commands,questions and answers,ado.net entity framework,.net framework 4,ajax tavern,tutorialsteacher,ajax javascript,fresherslive,services desk,questions to ask on a first date,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,.netflix,asp.net core middleware,wcf web service,mvc webadvisor,web store,mvcc,freshers jobs near me,webmail,mvci,mvctc,