So I create a datatable like so:
Code:Dim objDT As System.Data.DataTable = New System.Data.DataTable("psearch") objDT.Columns.Add("ID", GetType(Integer)) objDT.Columns("ID").AutoIncrement = True objDT.Columns("ID").AutoIncrementSeed = 1 objDT.Columns.Add("Item", GetType(String)) objDT.Columns.Add("Criteria", GetType(String)) objDT.Columns.Add("sys_name", GetType(String)) objDT.Columns.Add("condition", GetType(String)) Session("psearch") = objDT
And then I add some things in like so:
Code:Dim objdt As System.Data.DataTable Dim objdr As System.Data.DataRow objdt = Session("psearch") objdr = objdt.NewRow objdr("Item") = trim(actual) objdr("Criteria") = Request(name) objdr("sys_name") = name objdr("condition") = condition objdt.Rows.Add(objdr) Session("psearch") = objdt
Now how can I read thru it after I am done with it? I wanna loop thru each row to add values to a database.




Reply With Quote