adding a new row to the repeater control

[buran]

Dear ASP.NET Programmers,

Here's my problem: I have a page (as usual :), in which I'm going to display invoices in a repeater control. I am binding data to the repeater control (ID: repHospCosts) without any problems. I have also a button on the page, I am going to add a new datarow programmaticall y and display it when pressed. Unfortunately, I cannot refer to the dataset in the event handler of the button (or at least I think so). I get the following error: Object reference not set to an instance of an object. drow = dtable.NewRow

Below is the code:

Dim dtable As DataTable
Dim drow As DataRow

If Not Page.IsPostBack Then

LoadHospCosts()

End If

Sub LoadHospCosts()

strSql = "spGetHospAmoun ts"
myCommand.Comma ndText = strSql
myCommand.Comma ndType = CommandType.Sto redProcedure
myCommand.Param eters.Clear()
myCommand.Param eters.Add("@our FileNo", Session("select edFileNumber"))
myDataAdapter.F ill(myDataSet, "HospCosts" )
repHospCosts.Da taSource = myDataSet
repHospCosts.Da taMember = "HospCosts"
repHospCosts.Da taBind()

End Sub

Private Sub Button2_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles Button2.Click

dtable = myDataSet.Table s("HospCosts" )
drow = dtable.NewRow
drow("SPName") = "Buran"
drow("InvoiceAm ount") = 100
dtable.Rows.Add (drow)
dtable.AcceptCh anges()

Dim subTotal As Double
For Each drow In dtable.Rows
subTotal += drow.Item("Invo iceAmount")
Next
lblSubTotal.Tex t = Format(subTotal , "n")

End Sub

I need any help I can get, thanks in advance...

Buran

[Jc Morin]

Hi Buran,

The problem is simple you bind your DataTable only on the first page load,
when you click the button, this is now a postback and you re-bind the data
on postback.

A solution would be to retrieve again the information from the database on a
postback or some mechanism with session or cache to keep it from postback to
postback.

Hope that help.
--------------------------
Jean-Claude Morin, MCP
Software Developer
2k1Soft/kCentric, Canada
"buran" <[e-mail]> wrote in message
news:ee******** ******@TK2MSFTN GP09.phx.gbl...
Dear ASP.NET Programmers,
Here's my problem: I have a page (as usual :), in which I'm going to display
invoices in a repeater control. I am binding data to the repeater control
(ID: repHospCosts) without any problems. I have also a button on the page, I
am going to add a new datarow programmaticall y and display it when pressed.
Unfortunately, I cannot refer to the dataset in the event handler of the
button (or at least I think so). I get the following error: Object reference
not set to an instance of an object. drow = dtable.NewRow
Below is the code:
Dim dtable As DataTable
Dim drow As DataRow
If Not Page.IsPostBack Then
LoadHospCosts()
End If
Sub LoadHospCosts()
strSql = "spGetHospAmoun ts"
myCommand.Comma ndText = strSql
myCommand.Comma ndType = CommandType.Sto redProcedure
myCommand.Param eters.Clear()
myCommand.Param eters.Add("@our FileNo",
Session("select edFileNumber"))
myDataAdapter.F ill(myDataSet, "HospCosts" )
repHospCosts.Da taSource = myDataSet
repHospCosts.Da taMember = "HospCosts"
repHospCosts.Da taBind()

End Sub
Private Sub Button2_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button2.Click
dtable = myDataSet.Table s("HospCosts" )
drow = dtable.NewRow
drow("SPName") = "Buran"
drow("InvoiceAm ount") = 100
dtable.Rows.Add (drow)
dtable.AcceptCh anges()
Dim subTotal As Double
For Each drow In dtable.Rows
subTotal += drow.Item("Invo iceAmount")
Next
lblSubTotal.Tex t = Format(subTotal , "n")
End Sub
I need any help I can get, thanks in advance...
Buran

[buran]

Thank you :)

"Jc Morin" <mi************ ****@jcmorin.ne t> wrote in message
news:O3******** ******@TK2MSFTN GP14.phx.gbl...

Hi Buran,

The problem is simple you bind your DataTable only on the first page load,
when you click the button, this is now a postback and you re-bind the data
on postback.

A solution would be to retrieve again the information from the database on a postback or some mechanism with session or cache to keep it from postback to postback.

Hope that help.
--------------------------
Jean-Claude Morin, MCP
Software Developer
2k1Soft/kCentric, Canada
"buran" <[e-mail]> wrote in message
news:ee******** ******@TK2MSFTN GP09.phx.gbl...
Dear ASP.NET Programmers,
Here's my problem: I have a page (as usual :), in which I'm going to display invoices in a repeater control. I am binding data to the repeater control
(ID: repHospCosts) without any problems. I have also a button on the page, I am going to add a new datarow programmaticall y and display it when pressed. Unfortunately, I cannot refer to the dataset in the event handler of the
button (or at least I think so). I get the following error: Object reference not set to an instance of an object. drow = dtable.NewRow
Below is the code:
Dim dtable As DataTable
Dim drow As DataRow
If Not Page.IsPostBack Then
LoadHospCosts()
End If
Sub LoadHospCosts()
strSql = "spGetHospAmoun ts"
myCommand.Comma ndText = strSql
myCommand.Comma ndType = CommandType.Sto redProcedure
myCommand.Param eters.Clear()
myCommand.Param eters.Add("@our FileNo",
Session("select edFileNumber"))
myDataAdapter.F ill(myDataSet, "HospCosts" )
repHospCosts.Da taSource = myDataSet
repHospCosts.Da taMember = "HospCosts"
repHospCosts.Da taBind()

End Sub
Private Sub Button2_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button2.Click
dtable = myDataSet.Table s("HospCosts" )
drow = dtable.NewRow
drow("SPName") = "Buran"
drow("InvoiceAm ount") = 100
dtable.Rows.Add (drow)
dtable.AcceptCh anges()
Dim subTotal As Double
For Each drow In dtable.Rows
subTotal += drow.Item("Invo iceAmount")
Next
lblSubTotal.Tex t = Format(subTotal , "n")
End Sub
I need any help I can get, thanks in advance...
Buran