ASP.net: Data field used in gridview is not showing as column but turns into title in another field

Question

ASP.net: Data field used in gridview is not showing as column but turns into title in another field

Kurt Jensen 20

Hi.

I have a SQL datasource that returns 5 columns and a gridview to show them, but one of the columns does not show as a column in the gridview but turns into title (showing when holding the mouse over) in one of the other columns.

It keeps doing it no matter how the gridview is configured (Auto-generate fields or not).

If the SQL statement from the datasource is executed else where, all 5 columns is showing fine

What can cause this behaviour?

QiYou-MSFT 4,326 Reputation points Microsoft External Staff

2023-03-07T08:02:25.0733333+00:00

Hi @Kurt Jensen

Can you share your code? Based on your description, I can't reproduce the problem.

Best Regards

Qi You
Kurt Jensen 20 Reputation points

2023-03-07T08:10:32.6466667+00:00
Hi.

The SQL Datasource Select statement looks like this and it is an IBM database:

SELECT CMNPSU.KSROLL AS ROLE, CMNPSU.KSFNID AS FUNCTION, CMNFNG.JFTX40 AS TEXT, T2.JDTX40 AS GB_TEXT, CASE KSALO WHEN '000010000' THEN 'READ ONLY' WHEN '111111111' THEN 'FULL ACCESS' WHEN '000000000' THEN 'NO ACCESS' " ELSE 'SPECIAL DEFINED' END AS ACCESS FROM CMNPSU INNER JOIN CMNFNG ON (CMNPSU.KSFNID = CMNFNG.JFFNID) LEFT JOIN (SELECT JDFNID, JDTX40 FROM CMNFNL WHERE (JDLANC = 'GB')) T2 ON (CMNPSU.KSFNID = T2.JDFNID) WHERE (CMNPSU.KSFNID = CMNFNG.JFFNID) AND (CMNPSU.KSDIVI = 'TheDivi') AND (CMNPSU.KSROLL = 'RoleName') ORDER BY FUNCTION

The rest is quite simple where the gridview's datasorurce is set to the SQL Datasource.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="DatSrcRoleFunctions" EnableModelValidation="True"> <Columns> <asp:BoundField DataField="ROLE" HeaderText="ROLE" SortExpression="ROLE" /> <asp:BoundField DataField="FUNCTION" HeaderText="FUNCTION" SortExpression="FUNCTION" /> <asp:BoundField DataField="TEXT" HeaderText="TEXT" SortExpression="TEXT" /> <asp:BoundField DataField="GB_TEXT" HeaderText="GB_TEXT" SortExpression="GB_TEXT" /> <asp:BoundField DataField="ACCESS" HeaderText="ACCESS" SortExpression="ACCESS" /> </Columns> </asp:GridView>

But as you can see in the snip below (showing the source in the browser), the column called ACCESS turns into the title of the column called GB_TEXT even though it should have been a normal column

Kurt Jensen 20

I don't know what happened to this question, but the image showing some of the source from the browser is lost and I cannot edit that comment to put it back in (page fails if I try), so I will try with text instead:

<table cellspacing="0" rules="all" border="1" id="GridView1" style="border-collapse:collapse;">
		<tr>
			<th scope="col">ROLE</th><th scope="col">FUNCTION</th><th scope="col">TEXT</th><th title="ACCESS" scope="col">GB_TEXT</th>
		</tr><tr>
			<td>SADAGL    </td><td>MMS030    </td><td>Vare. Koble navne/sprog                 </td><td title="FULL ACCESS">Item. Enter Names/Language              </td>
		</tr><tr>

Edit: I can see the picture again in the previous comment, but anyway: The text here shows a little more

Viorel 122.6K Reputation points

2023-03-07T20:01:11.38+00:00

Does it work differently if you use another name for "ACCESS" column, header, etc.?

QiYou-MSFT 4,326 Microsoft External Staff

Hi @Kurt Jensen

In fact, I tested it myself with an example based on your description.

Code:

<asp:GridView ID="GridView3" runat="server" DataSourceID="SqlDataSource3" AutoGenerateColumns="false" EnableModelValidation="True" >
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name"
SortExpression="Name" />
<asp:BoundField DataField="Text" HeaderText="Text"
SortExpression="Text" />
<asp:BoundField DataField="Result" HeaderText="Result"
SortExpression="Result" />
<asp:BoundField DataField="ACCESS" HeaderText="ACCESS"
SortExpression="ACCESS" />
</Columns>
</asp:GridView>

"SELECT Test1 AS Name,Test2 AS Text,Test3 AS Result,CASE Test4 WHEN '00001' THEN 'A' WHEN '00002' THEN 'B' ELSE 'C'END AS ACCESS FROM dbo.TestGridViewTest"

Test1

Test2

I think there is other code in your project that is interfering with the result. You can recreate the project and test it with just that. If there is still a problem, you can share more code to locate the problem.

Best Regards

Qi You

Kurt Jensen 20 Reputation points

2023-03-16T12:04:10.6233333+00:00

Hi @QiYou-MSFT

It sometimes helps that someone else takes a look at it to open ones eyes :-)

You are right, there was some code elsewhere in the project that I forgot all about. That code was manipulating the gridview.

Thank you very much for taking time to help and test it :-)

Best Regards

Kurt Jensen

Accepted answer

0 additional answers

Your answer

QiYou-MSFT 4,326 Reputation points Microsoft External Staff

2023-03-07T08:02:25.0733333+00:00

Hi @Kurt Jensen

Can you share your code? Based on your description, I can't reproduce the problem.

Best Regards

Qi You
Kurt Jensen 20 Reputation points

2023-03-07T08:10:32.6466667+00:00

Hi.

The SQL Datasource Select statement looks like this and it is an IBM database:

SELECT CMNPSU.KSROLL AS ROLE, CMNPSU.KSFNID AS FUNCTION, CMNFNG.JFTX40 AS TEXT, T2.JDTX40 AS GB_TEXT, CASE KSALO WHEN '000010000' THEN 'READ ONLY' WHEN '111111111' THEN 'FULL ACCESS' WHEN '000000000' THEN 'NO ACCESS' " ELSE 'SPECIAL DEFINED' END AS ACCESS FROM CMNPSU INNER JOIN CMNFNG ON (CMNPSU.KSFNID = CMNFNG.JFFNID) LEFT JOIN (SELECT JDFNID, JDTX40 FROM CMNFNL WHERE (JDLANC = 'GB')) T2 ON (CMNPSU.KSFNID = T2.JDFNID) WHERE (CMNPSU.KSFNID = CMNFNG.JFFNID) AND (CMNPSU.KSDIVI = 'TheDivi') AND (CMNPSU.KSROLL = 'RoleName') ORDER BY FUNCTION

The rest is quite simple where the gridview's datasorurce is set to the SQL Datasource.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="DatSrcRoleFunctions" EnableModelValidation="True"> <Columns> <asp:BoundField DataField="ROLE" HeaderText="ROLE" SortExpression="ROLE" /> <asp:BoundField DataField="FUNCTION" HeaderText="FUNCTION" SortExpression="FUNCTION" /> <asp:BoundField DataField="TEXT" HeaderText="TEXT" SortExpression="TEXT" /> <asp:BoundField DataField="GB_TEXT" HeaderText="GB_TEXT" SortExpression="GB_TEXT" /> <asp:BoundField DataField="ACCESS" HeaderText="ACCESS" SortExpression="ACCESS" /> </Columns> </asp:GridView>

But as you can see in the snip below (showing the source in the browser), the column called ACCESS turns into the title of the column called GB_TEXT even though it should have been a normal column
Kurt Jensen 20 Reputation points

2023-03-07T09:08:44.7366667+00:00

I don't know what happened to this question, but the image showing some of the source from the browser is lost and I cannot edit that comment to put it back in (page fails if I try), so I will try with text instead:

<table cellspacing="0" rules="all" border="1" id="GridView1" style="border-collapse:collapse;"> <tr> <th scope="col">ROLE</th><th scope="col">FUNCTION</th><th scope="col">TEXT</th><th title="ACCESS" scope="col">GB_TEXT</th> </tr><tr> <td>SADAGL </td><td>MMS030 </td><td>Vare. Koble navne/sprog </td><td title="FULL ACCESS">Item. Enter Names/Language </td> </tr><tr>

Edit: I can see the picture again in the previous comment, but anyway: The text here shows a little more
Viorel 122.6K Reputation points

2023-03-07T20:01:11.38+00:00

Does it work differently if you use another name for "ACCESS" column, header, etc.?
QiYou-MSFT 4,326 Reputation points Microsoft External Staff

2023-03-08T06:48:43.99+00:00

Hi @Kurt Jensen

In fact, I tested it myself with an example based on your description.

Code:

<asp:GridView ID="GridView3" runat="server" DataSourceID="SqlDataSource3" AutoGenerateColumns="false" EnableModelValidation="True" > <Columns> <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" /> <asp:BoundField DataField="Text" HeaderText="Text" SortExpression="Text" /> <asp:BoundField DataField="Result" HeaderText="Result" SortExpression="Result" /> <asp:BoundField DataField="ACCESS" HeaderText="ACCESS" SortExpression="ACCESS" /> </Columns> </asp:GridView>

"SELECT Test1 AS Name,Test2 AS Text,Test3 AS Result,CASE Test4 WHEN '00001' THEN 'A' WHEN '00002' THEN 'B' ELSE 'C'END AS ACCESS FROM dbo.TestGridViewTest"

I think there is other code in your project that is interfering with the result. You can recreate the project and test it with just that. If there is still a problem, you can share more code to locate the problem.

Best Regards

Qi You
Kurt Jensen 20 Reputation points

2023-03-16T12:04:10.6233333+00:00

Hi @QiYou-MSFT

It sometimes helps that someone else takes a look at it to open ones eyes :-)

You are right, there was some code elsewhere in the project that I forgot all about. That code was manipulating the gridview.

Thank you very much for taking time to help and test it :-)

Best Regards

Kurt Jensen

Answer 1

Jose Zero 576

In addition to @QiYou-MSFT , have you any code at Gridview.DataBound or GridviewRowDataBound events?
Sometimes we use these events to make some final changes before page render...

Share via

ASP.net: Data field used in gridview is not showing as column but turns into title in another field

0 additional answers

Your answer