MAster Detail

  • Thread starter Mohammed Abdel-Razzak
  • Start date
M

Mohammed Abdel-Razzak

Dear sirs
I`m making a software application using C# and MS-SQL
server
I`ve two tables named SECTORS(Sect_Id, Sect_Name) and
CUSTOMERS(Cust_Id, Cust_Name) they have many
to many relationship, and I`ve broken this relationship
with a table named CUST_SECTOR (Cust_Id, Sect_Id)
In my application I want to view the SECTORS names in a
combo box and I want to view the CUSTOMERS in each SECTOR
in a data grid
I`ve used oleDbDataAdapter for each table and filled a
dataset with them

thanks
Mohammed
 
M

Mohammed Abdel-Razzak

Sir the problem is How can I do that??
where in the data grid it views the Cust_Id and the
Sect_Id
and I want to view the Cust_Id and the Cust_Name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft web browser 7
tree view 1
CREATE VIEW 4
How to bind DataGrid to SQL query ? 4
SqlCommand 3
Row index 2
COUNTIFS with No Criteria 1
Write data into table with VB code 4

Top