Create a telephone directory
-
I want to represent telephone directory in this way. Certainly, anybody may have more phones and each of them must be visible. It is all dispose in more columns, that economically use working surface. Table: TelDirectory (ID,Name,Tel) PK(ID) - primary key How to show data like this: Name1.....Name4 ------.....------ Tel11......Tel41 Tel12 Name2 ------ Tel21 Tel22 Tel23 Name3 ------ Tel31 ... Thanks for any help.
-
I want to represent telephone directory in this way. Certainly, anybody may have more phones and each of them must be visible. It is all dispose in more columns, that economically use working surface. Table: TelDirectory (ID,Name,Tel) PK(ID) - primary key How to show data like this: Name1.....Name4 ------.....------ Tel11......Tel41 Tel12 Name2 ------ Tel21 Tel22 Tel23 Name3 ------ Tel31 ... Thanks for any help.
where are you showing it ? If in a web app, a repeater is your best option.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
where are you showing it ? If in a web app, a repeater is your best option.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
I want to represent telephone directory in this way. Certainly, anybody may have more phones and each of them must be visible. It is all dispose in more columns, that economically use working surface. Table: TelDirectory (ID,Name,Tel) PK(ID) - primary key How to show data like this: Name1.....Name4 ------.....------ Tel11......Tel41 Tel12 Name2 ------ Tel21 Tel22 Tel23 Name3 ------ Tel31 ... Thanks for any help.
First of all, the ID cannot be a Primary Key as it will not be unique, since anybody can have more than 1 phones. You can get the list sorted on ID/name of the customer. Once it is sorted it will be esily printed.
Manoj Never Gives up
-
Then it's up to you to render the results any way you like. No built in control will give the layout you're wanting, however.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
I want to represent telephone directory in this way. Certainly, anybody may have more phones and each of them must be visible. It is all dispose in more columns, that economically use working surface. Table: TelDirectory (ID,Name,Tel) PK(ID) - primary key How to show data like this: Name1.....Name4 ------.....------ Tel11......Tel41 Tel12 Name2 ------ Tel21 Tel22 Tel23 Name3 ------ Tel31 ... Thanks for any help.
You posted this exact same question a few days ago. What have you tried since then? Even writing some long, slow, even poor code, to get the job done will give you a starting point. Then post snippets of that code, and the people here will help optimise it.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
-
First of all, the ID cannot be a Primary Key as it will not be unique, since anybody can have more than 1 phones. You can get the list sorted on ID/name of the customer. Once it is sorted it will be esily printed.
Manoj Never Gives up
Manoj Kumar Rai wrote:
First of all, the ID cannot be a Primary Key as it will not be unique, since anybody can have more than 1 phones.
How does that make ID not unique 1 Colin Mackay 0123 456 7890 2 Colin Mackay 0321 654 0987 Looks fine to me - What did you think was wrong with it?
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." My website
-
Manoj Kumar Rai wrote:
First of all, the ID cannot be a Primary Key as it will not be unique, since anybody can have more than 1 phones.
How does that make ID not unique 1 Colin Mackay 0123 456 7890 2 Colin Mackay 0321 654 0987 Looks fine to me - What did you think was wrong with it?
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." My website
Ahhh, Ok. Its record ID and not the ID of the person where I thought wrongly. But in either case for the problem we had to print this Unique key do not have any role to play. We have to sort the list on the basis of the Name and get the values printed.
Manoj Never Gives up
-
I want to represent telephone directory in this way. Certainly, anybody may have more phones and each of them must be visible. It is all dispose in more columns, that economically use working surface. Table: TelDirectory (ID,Name,Tel) PK(ID) - primary key How to show data like this: Name1.....Name4 ------.....------ Tel11......Tel41 Tel12 Name2 ------ Tel21 Tel22 Tel23 Name3 ------ Tel31 ... Thanks for any help.
It isn't difficult as a table, but I dont know how to displey data on win form in this way. If I get names and phones into dataset, how show them? How can I provide repetition structure unequal form, that contain name and suitable phones, where all phones are visible? It seems datagridview isn't proper control to realize that. How else can I do it?