Working with multiple table

Jude Guillaume

Hi everyone

Thank you for taking the time to read this post, I am new to asp.net and I find myself in a very difficult situation where I have to display data from two tables.

I am using Visual studio 2017 and Sql server 2017. I am using ado.net database first approach.

I need to display information from Customer/Address table.

Customer table

CustID PK not null

Name

Address Table

AddressID PK Not null

CustID FK Not null

I need to create a view for entering the information in the customer and Address database after one click.

To picture thing out my view should list be like this

Name

Address

and I also need to show customer details in the same format.

Thanks for your help.. Just remember I am new to asp.net

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jude Guillaume8y ago
I am using the database first approach and since I am new does any one have a tutorial on using ado.net to post data from a single view to multiple table.
Thanks everyone for their time in trying to help.

Regards
+1
Sankara Krishnan Venugopal8y ago
Find the below details that helps you,

Create view:

Create view vw_customer
select c.name, a.address from customer c join address a on c.cus_id = a .cus_id

insert record through view:
insert into vw_customer select Krishnaa, TN

Get records:
Select * from vw_customer

Thanks.
+1
Faisal Pathan8y ago
You should go with join query.
select  *
from Customer
inner join Address on Customer.CustID = Address.CustID;
+1