Hello friends, I am whidbey, new to thescripts and dot net as well.I am working over Online Shopping Cart,web application.I design a page (webform5.aspx) where user search books then select the books to buy from the datagrid.
User can select books using checkboxes in the datagrid.
The selected books are stored in a session variable name session("temp") which is a dataset type.After storing dataset in session (in bold letters),user will redirected to next page "webform6.aspx" . Here is the code....
Then, I retrieve this dataset on the page load event of "webform6.aspx" .Here is the code.....
But, I got an error :
Exception Details: System.Web.Http Exception: The IListSource does not contain any data sources.
But, I got an error :
Exception Details: System.Web.Http Exception: The IListSource does not contain any data sources.
Help me to remove this error and give me some good knowledge on this issue
User can select books using checkboxes in the datagrid.
The selected books are stored in a session variable name session("temp") which is a dataset type.After storing dataset in session (in bold letters),user will redirected to next page "webform6.aspx" . Here is the code....
Code:
sub button2_click(sender as object,e as eventargs)
'con.close()
dim da as sqldataadapter,ds as dataset
dim con as sqlconnection
dim griditem as datagriditem
dim kk as boolean
dim row as integer
con=new sqlconnection("server=WADHWA;user id=sa;pwd=;initial catalog=OnlineShoppingDatabase")
con.open()
da=new SqlDataAdapter()
da.selectcommand=new SqlCommand()
da.selectcommand.connection=con
da.selectcommand.commandtext="insert temp_info values(@BookId,@CatId,@Title,@Author,@Publisher,@Price,@Quantity)"
da.selectcommand.parameters.add(new sqlparameter("@BookId",SqlDbType.Int,0,"BookId"))
da.selectcommand.parameters.add(new sqlparameter("@CatId",SqlDbType.Int,0,"CatId"))
da.selectcommand.parameters.add(new sqlparameter("@Title",SqlDbType.varchar,10,"Title"))
da.selectcommand.parameters.add(new sqlparameter("@Author",SqlDbType.varchar,10,"Author"))
da.selectcommand.parameters.add(new sqlparameter("@Publisher",SqlDbType.varchar,10,"Publisher"))
da.selectcommand.parameters.add(new sqlparameter("@Price",SqlDbType.float,0,"Price"))
da.selectcommand.parameters.add(new sqlparameter("@Quantity",SqlDbType.Int,0,"Quantity"))
for each griditem in datagrid1.items
'chk=griditem.cells(0).findcontrol("checkbox")
'kk=directcast(griditem.Cells(1).Controls(0), CheckBox).checked
da.selectcommand.parameters("@BookId").value=integer.parse(griditem.cells(8).text)
da.selectcommand.parameters("@CatId").value=integer.parse(griditem.cells(9).text)
da.selectcommand.parameters("@Title").value=griditem.cells(2).text
da.selectcommand.parameters("@Author").value=griditem.cells(3).text
da.selectcommand.parameters("@Publisher").value=griditem.cells(4).text
da.selectcommand.parameters("@Price").value=decimal.parse(griditem.cells(5).text.Replace(" ", ""), Globalization.NumberStyles.AllowThousands or Globalization.NumberStyles.AllowCurrencySymbol or Globalization.NumberStyles.AllowDecimalPoint)
da.selectcommand.parameters("@Quantity").value=integer.parse(griditem.cells(6).text)
kk=directcast(griditem.cells(0).findcontrol("checkbox1"),checkbox).checked
if kk then
'response.write("checked")
row =da.selectcommand.executenonquery()
end if
row=0
next
[B]ds=new DataSet
da.fill(ds,"temp_info")
session("temp")=ds[/B]
'ds = nothing
'da=nothing
con.close()
response.redirect("webform6.aspx")
end sub
Then, I retrieve this dataset on the page load event of "webform6.aspx" .Here is the code.....
Code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
'If Not Page.IsPostBack Then
If Session("temp") Is Nothing Then
ds = New DataSet
da = New SqlDataAdapter
con = New SqlConnection("server=WADHWA;user id=sa;pwd=;initial catalog=onlineshoppingdatabase")
con.Open()
da.SelectCommand = New SqlCommand("select * from temp_info", con)
da.Fill(ds, "temp_info")
'DataGrid1.DataSource = ds
'DataGrid1.DataSource = ds.Tables("temp_info")
DataGrid1.DataBind()
End If
If Not Page.IsPostBack Then
'DataGrid1.EnableViewState = False
ds = New DataSet
ds = CType(Session("temp"), DataSet)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End If
End Sub
Exception Details: System.Web.Http Exception: The IListSource does not contain any data sources.
But, I got an error :
Exception Details: System.Web.Http Exception: The IListSource does not contain any data sources.
Help me to remove this error and give me some good knowledge on this issue
Comment