datarow question

[rodchar]

Hey all,

I thought what I was doing was pretty straightforward but apparently not.
All I'm doing is loading a datarow, letting the user modify a field in the
datarow by inputing into a textbox. I then take that textbox and assign the
datarow field that value.

But, as soon as the assignment occurs the datarow becomes nothing. And I
have no idea why.

thanks in advance,
rodchar

[rodchar]

ok, i think i've narrowed it down. I can use the dr.BeginEdit and the row
updates, but when i try to use dr.EndEdit then the dr becomes nothing again.
rodchar

"rodchar" wrote:

Hey all,

I thought what I was doing was pretty straightforward but apparently not.
All I'm doing is loading a datarow, letting the user modify a field in the
datarow by inputing into a textbox. I then take that textbox and assign the
datarow field that value.

But, as soon as the assignment occurs the datarow becomes nothing. And I
have no idea why.

thanks in advance,
rodchar

[rodchar]

Here's some of my syntax:
private sub Save
m_dr.BeginEdit() 'This works
m_dr.Codes = strHold 'This works
m_dr.EndEdit() 'This does not work
End Sub

"rodchar" wrote:

Hey all,

I thought what I was doing was pretty straightforward but apparently not.
All I'm doing is loading a datarow, letting the user modify a field in the
datarow by inputing into a textbox. I then take that textbox and assign the
datarow field that value.

But, as soon as the assignment occurs the datarow becomes nothing. And I
have no idea why.

thanks in advance,
rodchar

[Cor Ligthert]

Rodchar,

Have a look for databinding and currencymanager for that (it is in the
snippet I showed you with the textbox)

http://msdn.microsoft.com/library/de...classtopic.asp

http://msdn.microsoft.com/library/de...ClassTopic.asp

That is a better approach.

I hope this helps?

Cor

"rodchar"

Here's some of my syntax:
private sub Save
m_dr.BeginEdit() 'This works
m_dr.Codes = strHold 'This works
m_dr.EndEdit() 'This does not work
End Sub

"rodchar" wrote:

Hey all,

I thought what I was doing was pretty straightforward but apparently not.
All I'm doing is loading a datarow, letting the user modify a field in
the
datarow by inputing into a textbox. I then take that textbox and assign
the
datarow field that value.

But, as soon as the assignment occurs the datarow becomes nothing. And I
have no idea why.

thanks in advance,
rodchar

[rodchar]

Hey Everyone,

Cor, thanks for the articles. I glanced over them and they might be a little
over my head at this time.

Can you take a look at the following code:

Dim _postBack As Boolean = False
Dim _dt As DataSet1.CustomersDataTable
Dim _dr As DataSet1.CustomersRow
Dim arrText() As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
SqlDataAdapter1.Fill(DataSet11)
_dt = DataSet11.Customers
ListBox1.DataSource = _dt
ListBox1.DisplayMember = "ContactName"
ListBox1.ValueMember = "CustomerID"
_postBack = True
End Sub

Private Sub ListBox1_SelectedValueChanged(ByVal sender As Object, ByVal
e As System.EventArgs) Handles ListBox1.SelectedValueChanged
If _postBack = True Then
_dr = _dt.FindByCustomerID(ListBox1.SelectedValue)
FillArray()
TextBox1.Text = arrText(0)
TextBox2.Text = arrText(1)
End If

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
_dr.ContactName = arrText(0) & " " & arrText(1)
MessageBox.Show("Done.")
End Sub

Private Sub FillArray()
arrText = Split(_dr.ContactName, " ")
End Sub
Can you tell me if this is the way to update the contact name?
To run, using Northwind database.
All you need is 1 listbox, 2 textboxes, and a button.
I used all default names.

I used the SqlDataAdapter wizard to get all Customers.
I also generated a typed dataset and added an instance called Dataset1

Goal: All I want to do is update the contact name. I split the first and
last name into textboxes for update and hit save.
It's not working quite right, do you see anything?

thanks in advance,
rodchar

"Cor Ligthert" wrote:

Rodchar,

Have a look for databinding and currencymanager for that (it is in the
snippet I showed you with the textbox)

http://msdn.microsoft.com/library/de...classtopic.asp

http://msdn.microsoft.com/library/de...ClassTopic.asp

That is a better approach.

I hope this helps?

Cor

"rodchar"

Here's some of my syntax:
private sub Save
m_dr.BeginEdit() 'This works
m_dr.Codes = strHold 'This works
m_dr.EndEdit() 'This does not work
End Sub

"rodchar" wrote:

Hey all,

I thought what I was doing was pretty straightforward but apparently not.
All I'm doing is loading a datarow, letting the user modify a field in
the
datarow by inputing into a textbox. I then take that textbox and assign
the
datarow field that value.

But, as soon as the assignment occurs the datarow becomes nothing. And I
have no idea why.

thanks in advance,
rodchar

[rodchar]

ok, i got help from a different post. Each time I fill the datasource is
where the object gets lost. I'm using flags to resolve it. Thanks for the
reply.

"rodchar" wrote:

Hey Everyone,

Cor, thanks for the articles. I glanced over them and they might be a little
over my head at this time.

Can you take a look at the following code:

Dim _postBack As Boolean = False
Dim _dt As DataSet1.CustomersDataTable
Dim _dr As DataSet1.CustomersRow
Dim arrText() As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
SqlDataAdapter1.Fill(DataSet11)
_dt = DataSet11.Customers
ListBox1.DataSource = _dt
ListBox1.DisplayMember = "ContactName"
ListBox1.ValueMember = "CustomerID"
_postBack = True
End Sub

Private Sub ListBox1_SelectedValueChanged(ByVal sender As Object, ByVal
e As System.EventArgs) Handles ListBox1.SelectedValueChanged
If _postBack = True Then
_dr = _dt.FindByCustomerID(ListBox1.SelectedValue)
FillArray()
TextBox1.Text = arrText(0)
TextBox2.Text = arrText(1)
End If

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
_dr.ContactName = arrText(0) & " " & arrText(1)
MessageBox.Show("Done.")
End Sub

Private Sub FillArray()
arrText = Split(_dr.ContactName, " ")
End Sub
Can you tell me if this is the way to update the contact name?
To run, using Northwind database.
All you need is 1 listbox, 2 textboxes, and a button.
I used all default names.

I used the SqlDataAdapter wizard to get all Customers.
I also generated a typed dataset and added an instance called Dataset1

Goal: All I want to do is update the contact name. I split the first and
last name into textboxes for update and hit save.
It's not working quite right, do you see anything?

thanks in advance,
rodchar

"Cor Ligthert" wrote:

Rodchar,

Have a look for databinding and currencymanager for that (it is in the
snippet I showed you with the textbox)

http://msdn.microsoft.com/library/de...classtopic.asp

http://msdn.microsoft.com/library/de...ClassTopic.asp

That is a better approach.

I hope this helps?

Cor

"rodchar"

Here's some of my syntax:
private sub Save
m_dr.BeginEdit() 'This works
m_dr.Codes = strHold 'This works
m_dr.EndEdit() 'This does not work
End Sub

"rodchar" wrote:

> Hey all,
>
> I thought what I was doing was pretty straightforward but apparently not.
> All I'm doing is loading a datarow, letting the user modify a field in
> the
> datarow by inputing into a textbox. I then take that textbox and assign
> the
> datarow field that value.
>
> But, as soon as the assignment occurs the datarow becomes nothing. And I
> have no idea why.
>
> thanks in advance,
> rodchar