Board index » Web Programming » databind and getting values

Web Programming368
when i bind a data from a select query to a grid view :

[code]

Dim myCommand As New Data.SqlClient.SqlCommand(sqlSelect, myConnection)

Dim myDataSet As New Data.DataSet



Dim myAdapter As New Data.SqlClient.SqlDataAdapter(myCommand)

myAdapter.Fill(myDataSet)

productsGridView.DataSource = myDataSet

productsGridView.PageIndex = pageNum

productsGridView.DataBind()

[/code]

and there are columns that i dont display

in my gridview so i cant access there values

but is there still a wasy to access the values that were extracted with the

Data.DataSet object

from RowDataBound method for example?

thnaks in advance

Peleg


-

"pelegk1" <pelegk1@discussions.microsoft.com>wrote in message



msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridviewrow.dataitem(vs.80).aspx">msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridviewrow.dataitem(vs.80).aspx





--

Mark Rae

ASP.NET MVP

www.markrae.net">www.markrae.net



-