<div>
Did the data source actually pull the other 4 columns and is that data still available if it did? Im doing a Dim reader As SqlDataReader = cmd.ExecuteReader based on the value now, it just seems like overkill,,, maybe I should use the ds for the 2 columns.... and stick with the reader on the SelectedIndexChanged. in the long run its probably better to only pull what i need...
</div>


Did the data source actually pull the other 4 columns and is that data still available if it did? Im doing a Dim reader As SqlDataReader = cmd.ExecuteReader based on the value now, it just seems like overkill,,, maybe I should use the ds for the 2 columns.... and stick with the reader on the SelectedIndexChanged. in the long run its probably better to only pull what i need...

<div>
<div class="content wysiwyg-content">
Hi<br />
Im using a sqldatasource control to retrieve 6 columns to fill a dropdown list that only needs 2 of the 6 the Display and Value for the ddl<br />
<br />
This should seem easy,,,, I simply want to access the other 4 columns in my sqldatasource control depending on the SelectedIndexChanged of my ddl.<br />
<br />
Without doing another DB select. <br />
Thanks<br />

</div>
</div>


Hi
Im using a sqldatasource control to retrieve 6 columns to fill a dropdown list that only needs 2 of the 6 the Display and Value for the ddl

This should seem easy,,,, I simply want to access the other 4 columns in my sqldatasource control depending on the SelectedIndexChanged of my ddl.

Without doing another DB select. 
Thanks


dropdownlist sqldatasource and SelectedIndexChanged

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications