Gridview with more than 2 tables

[=?Utf-8?B?ZWdzZGFy?=]

Hello. I'd like to know how can use in a Gridview more than two tables and
when I hit the update button should display for the child table a
dropdownlist instead of a textbox?


How can i do this two things? Best regards and thanks in advance for the help.

[Alexey Smirnov]

Re: Gridview with more than 2 tables

On Oct 8, 7:19 pm, egsdar <egs...@discuss ions.microsoft. comwrote:

Hello. I'd like to know how can use in a Gridview more than two tables and
when I hit the update button should display for the child table a
dropdownlist instead of a textbox?
>
How can i do this two things? Best regards and thanks in advance for the help.

Hi. Check the following articles

http://msdn.microsoft.com/en-us/library/ms972948.aspx

http://msdn.microsoft.com/en-us/library/ms178294.aspx

[=?Utf-8?B?ZWdzZGFy?=]

Re: Gridview with more than 2 tables

I'm really thankful. It works, but I'm really sorry but now i have this:

Table A:
ID Resource IDgroup
1 Callcenter 2

Table B:
IDgroup Description
1 Human Resources
2 Networking


And with your help, when I hit edit, it displays the content with the
dropdown list as it should be and I'm able to update it, but after that it
displays back the content of table A. Is there a way that in normal mode i
can display the grid like this:

Gridview:
ID Resource IDgroup
1 Callcenter Networking

Thanks again.


"Alexey Smirnov" wrote:

On Oct 8, 7:19 pm, egsdar <egs...@discuss ions.microsoft. comwrote:

Hello. I'd like to know how can use in a Gridview more than two tables and
when I hit the update button should display for the child table a
dropdownlist instead of a textbox?

How can i do this two things? Best regards and thanks in advance for the help.

>
Hi. Check the following articles
>

http://msdn.microsoft.com/en-us/library/ms972948.aspx

http://msdn.microsoft.com/en-us/library/ms178294.aspx

>

[Alexey Smirnov]

Re: Gridview with more than 2 tables

On Oct 9, 2:05 am, egsdar <egs...@discuss ions.microsoft. comwrote:

I'm really thankful. It works, but I'm really sorry but now i have this:
>
Table A:
ID     Resource    IDgroup
1      Callcenter   2
>
Table B:
IDgroup   Description
1            Human Resources
2            Networking
>
And with your help, when I hit edit, it displays the content with the
dropdown list as it should be and I'm able to update it, but after that it
displays back the content of table A. Is there a way that in normal mode i
can display the grid like this:
>
Gridview:
ID     Resource    IDgroup
1      Callcenter   Networking
>
Thanks again.
>
"Alexey Smirnov" wrote:

On Oct 8, 7:19 pm, egsdar <egs...@discuss ions.microsoft. comwrote:

Hello. I'd like to know how can use in a Gridview more than two tables and
when I hit the update button should display for the child table a
dropdownlist instead of a textbox?

>

How can i do this two things? Best regards and thanks in advance for the help.

>

Hi. Check the following articles

>

http://msdn.microsoft.com/en-us/library/ms972948.aspx

http://msdn.microsoft.com/en-us/library/ms178294.aspx

it's a matter of your request, if you said "IDgroup" it shows "2"
because this is the value from IDgroup field. To show Description
value from another table you need to join that table.

For example, look at the article I sent you. There is a request like

<asp:SqlDataSou rce ID="..." Runat="server"
SelectCommand=" SELECT ...."
ConnectionStrin g="<%$ ConnectionStrin gs:NWConnection String %>">

You would need to change that SelectCommand as

SelectCommand=" SELECT a.ID, a.Resource, a.IDGroup, b.DESCRIPTION
FROM tableA a, TABLEB b
WHERE a.IDGroup=b.IDG roup"

[=?Utf-8?B?ZWdzZGFy?=]

Re: Gridview with more than 2 tables

I'm going throguh a learning process with ASP.net and I'm really thankful
with your support and patience. After all it works.

"Alexey Smirnov" wrote:

On Oct 9, 2:05 am, egsdar <egs...@discuss ions.microsoft. comwrote:

I'm really thankful. It works, but I'm really sorry but now i have this:

Table A:
ID Resource IDgroup
1 Callcenter 2

Table B:
IDgroup Description
1 Human Resources
2 Networking

And with your help, when I hit edit, it displays the content with the
dropdown list as it should be and I'm able to update it, but after that it
displays back the content of table A. Is there a way that in normal mode i
can display the grid like this:

Gridview:
ID Resource IDgroup
1 Callcenter Networking

Thanks again.

"Alexey Smirnov" wrote:

On Oct 8, 7:19 pm, egsdar <egs...@discuss ions.microsoft. comwrote:
Hello. I'd like to know how can use in a Gridview more than two tables and
when I hit the update button should display for the child table a
dropdownlist instead of a textbox?

How can i do this two things? Best regards and thanks in advance for the help.

Hi. Check the following articles

>http://msdn.microsoft.com/en-us/library/ms972948.aspx
>http://msdn.microsoft.com/en-us/library/ms178294.aspx

>
it's a matter of your request, if you said "IDgroup" it shows "2"
because this is the value from IDgroup field. To show Description
value from another table you need to join that table.
>
For example, look at the article I sent you. There is a request like
>
<asp:SqlDataSou rce ID="..." Runat="server"
SelectCommand=" SELECT ...."
ConnectionStrin g="<%$ ConnectionStrin gs:NWConnection String %>">
>
You would need to change that SelectCommand as
>
SelectCommand=" SELECT a.ID, a.Resource, a.IDGroup, b.DESCRIPTION
FROM tableA a, TABLEB b
WHERE a.IDGroup=b.IDG roup"
>
>

[Alexey Smirnov]

Re: Gridview with more than 2 tables

On Oct 10, 9:03 pm, egsdar <egs...@discuss ions.microsoft. comwrote:

I'm going throguh a learning process with ASP.net and I'm really thankful
with your support and patience. After all it works.
>
"Alexey Smirnov" wrote:

On Oct 9, 2:05 am, egsdar <egs...@discuss ions.microsoft. comwrote:

I'm really thankful. It works, but I'm really sorry but now i have this:

>

Table A:
ID     Resource    IDgroup
1      Callcenter   2

>

Table B:
IDgroup   Description
1            Human Resources
2            Networking

>

And with your help, when I hit edit, it displays the content with the
dropdown list as it should be and I'm able to update it, but after that it
displays back the content of table A. Is there a way that in normal mode i
can display the grid like this:

>

Gridview:
ID     Resource    IDgroup
1      Callcenter   Networking

>

Thanks again.

>

"Alexey Smirnov" wrote:
On Oct 8, 7:19 pm, egsdar <egs...@discuss ions.microsoft. comwrote:
Hello. I'd like to know how can use in a Gridview more than two tables and
when I hit the update button should display for the child table a
dropdownlist instead of a textbox?

>

How can i do this two things? Best regards and thanks in advance for the help.

>

Hi. Check the following articles

>

http://msdn.microsoft.com/en-us/library/ms972948.aspx

http://msdn.microsoft.com/en-us/library/ms178294.aspx

>

it's a matter of your request, if you said "IDgroup" it shows "2"
because this is the value from IDgroup field. To show Description
value from another table you need to join that table.

>

For example, look at the article I sent you. There is a request like

>

<asp:SqlDataSou rce ID="..." Runat="server"
SelectCommand=" SELECT ...."
ConnectionStrin g="<%$ ConnectionStrin gs:NWConnection String %>">

>

You would need to change that SelectCommand as

>

SelectCommand=" SELECT a.ID, a.Resource, a.IDGroup, b.DESCRIPTION
FROM tableA a, TABLEB b
WHERE a.IDGroup=b.IDG roup"

great :-)