Insert record into bound datalist or OleDbDataReader

[Steven K]

Hello,

I am binding data from a stored procedure to a datalist:

Dim spCategoryList As OleDb.OleDbDataReader
Dim cmdCategoryList As New OleDb.OleDbCommand("sp_web_Search", cnnSearch)
cmdCategoryList.CommandType = CommandType.StoredProcedure
spCategoryList = cmdCategoryList.ExecuteReader()
dtlCategoryList.DataSource = spCategoryList
dtlCategoryList.DataBind()
spCategoryList.Close() : spCategoryList = Nothing

Is there any way to insert a new row into the DataList control or the
OleDbDataReader at the beginning and end?

 

[Abhijeet Dev]

you can use DataTable, which can be modified after fetching it from
database.