filmov
tv
Part 1 How to retrieve data from different databases in asp net
Показать описание
If you are a foodie like me, I am sure you will enjoy the recipes on my friend's YouTube channel. If you find them useful, please subscribe and share to support her. She's really good at what she does.
Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
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
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();
}
}
}
Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
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
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();
}
}
}
0:08:33
Teach Your Dog to Retrieve part 1 - the HOLD - the BASICS to FETCH or BRING - Dog Training Video
0:09:26
Retrieve Data from Database with PHP (Part 1)
0:00:53
How To Get A FREE SHAKE PART 1
0:00:59
She was dying to get his number 😫 part 2 @willononewheel
0:06:52
Part 1 - Basic HTTP GET/response interaction ( HTTP lab (Wireshark)) | Computer Networking
0:21:06
Trained Retrieve Step 7 - Fetch Part 1
0:00:51
Part 1 of “get unready with me” @dojacat Met Gala edition 😂👏🏻👀 #getreadywithme
0:55:15
How To Get Rich Starting From $0 Part 1
0:01:00
how to get space bloop part 1
0:00:27
Part 1: When you get different scores, different mothers react
0:04:51
Did Woman Get the Boot over Blindness? | Part 1
0:00:16
When people pleasers get kidnapped part 1
0:00:44
WHEN THE SUBSCRIBER SHOWS YOU HOW TO GET MORE CREEPS PART 1
0:06:54
How to Get the Most Out of Studying: Part 1 of 5, 'Beliefs That Make You Fail... Or Succeed&apo...
0:05:05
Did Karen Get Conned? | Part 1
0:00:52
#pov every year you get a mark that ages you... PART 1 #shorts
0:18:01
'People Get Ready' Curtis Mayfield Soul & Motown style! (Part 1 of 2 - Rhythm study gu...
0:44:01
How To Get Rich Starting From $0 Part 2
0:28:31
How To Get To The End, Part 1 | Jesse Duplantis
0:01:15
Part 1 - Raquel demands to get proposed to first
0:00:42
How to Get Into Medical Billing and Coding | Part 1 #career #medicalbilling
0:00:58
How to get rid of brain fog, every single day (Part 1)
0:00:27
If Disney princesses didn't get their happy endings... (part 1)
0:11:57
HOW TO GET 6 PACK ABS SERIES PART 1 | FLOOR
Комментарии