Hi,
I have to add details to a datagrid. but each time the submit clicked, the the page refreshes and the previous entered detail to the datagrid is lost. there is no database to save the datagrid. how do i save the details without database or just refresh the grid without postback the page?

Thanks.

annsary

Hii annsary!!
 You can use cache object to save data,and add it new reqd items and then bind it to data grids :)

Hope this will help you.

Cheers :)

vinod

Add your info into a data table, then rebind on postback.

Hi Vinod,
Thanks for your suggestion. used session to save the datatable. is cache better or session or cookie better?

jbenson001,
there is no database to insert. the program is to list user entered info and extract info for each row from a read access database.

thanks.

regards,
annsary

I said data table, not database

Hi jbenson001,
oops sorry. tried that method. but the data table becomes empty when postback. :(

did you put the code in an if statment?:
If NOT IsPagePostBack Then
 ..Fill data table

End IF

Hi,
the datagrid will be empty when the page is first loaded. only after the user enters the data and click the add button, the data is added to the datagrid.
the datatable becomes empty at postback. the datatable is showing as 'Nothing'. all data entries before post back is lost. so how to fill?

By using the following code, I am able to add. prefer not to use session/cache/cookie as consume server resource and have to do more maitenance:
        If Not IsPostBack Then
            Bindgrd()
        Else

            If Session(SesDs) Is Nothing Then

            Else
                dsTag = CType(Session(SesDs), DataSet)
                dt = ds.Tables(sTbl)
            End If
        End If

Private Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.PreRender
        Session(SesDs) = ds
    End Sub


Private Sub bAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim tRow As DataRow
        Dim itmArr() As Object = {tText1.Text, tText2.Text, tText3.Text}
        tRow = dt.NewRow()
        tRow.ItemArray = itmArr
        dt.Rows.Add(tRow)
        ds.Tables.Add(dt)
        Bindgrd()
    End Sub


Private Sub Bindgrd()

        gdataGrid.DataSource = ds
        gdataGrid.DataBind()
        gdataGrid.Visible = True
    End Sub

Once the click of the button click, you do not put your data set into the session variable. Add:
Session(SesDs) = ds BEFORE the call to Bindgrd().

Not sure why you have Session(SesDs) = ds in prerender event. Seems like that will overwrite ds. And where is ds declared?

Hi,
added Session(SesDs) = ds in the PreRender as this function will be called before page is rendered.
ds is declared in the Page's class section.

Public Class clUserData

    Inherits System.Web.UI.Page
    Dim ds As DataSet
    Dim dt As DataTable

annsary