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]

On Oct 8, 7:19*pm, egsdar <[e-mail]:

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?=]

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 <[e-mail]:

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]

On Oct 9, 2:05*am, egsdar <[e-mail]:

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 <[e-mail]:

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:SqlDataSource ID="..." Runat="server"
SelectCommand="SELECT ...."
ConnectionString="<%$ ConnectionStrings:NWConnectionString %>">

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.IDGroup"

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

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 <[e-mail]:

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 <[e-mail]:
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:SqlDataSource ID="..." Runat="server"
SelectCommand="SELECT ...."
ConnectionString="<%$ ConnectionStrings:NWConnectionString %>">

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.IDGroup"

[Alexey Smirnov]

On Oct 10, 9:03*pm, egsdar <[e-mail]:

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 <[e-mail]:

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 <[e-mail]:
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:SqlDataSource ID="..." Runat="server"
SelectCommand="SELECT ...."
ConnectionString="<%$ ConnectionStrings:NWConnectionString %>">

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.IDGroup"

great :-)