Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Joining two external tables programatically

Home
Forums
.NET

Joining two external tables programatically

Chris Johnson

5yAsked Apr 30, 2021, 8:27 AM510.NET

Hi all.
I have an IBM iSeries here at work. What I want to do is join say the customers table and the orders table programatically in an ASPX page and view the results in a Gridview?

This may be an SQL question or maybe use Linq? I really don't know.
Can someone shed some light on this for me please?

1 Reply

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

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Sachin Singh5y ago
Accepted answer
you can use Ado.Net where your command will be a Sql Join like shown below
string cs = ConfigurationManager.ConnectionStrings["cs"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
    connection.Open();
  string sql= @"select * from Customers c join Orders o on c.Id=O.CustomerId";
    SqlCommand cmd = new SqlCommand(Sql, con);
    using (SqlDataReader rdr = cmd.ExecuteReader())
    {
        GridView1.DataSource = rdr;
        GridView1.DataBind();
    }
}
Or you can use Linq as
var query= (from c in _context.Customers
                Join O in _context.Orders
                on c.Id equals O.CustomerId).ToList();
GridView1.DataSource= query;
GridView1.DataBind();