Move record in VB.net

Question

2.00/5 (1 vote)

See more:

Hi all visitors.
I have problem with moving record to next record.
i have 4 buttons( first,previous,next,last).
i used sql bindingsource.when the form loaded, i dont display any data to text box.
and than i want to move the record to next record. but when i click Next Button, it alerts a message "Object not set............).

How can i solve that problem?

(Note: if i fill data to text box at form loaded and move Next, it is ok. but i dont want to fill data at form loaded)

Best Regards,

Posted 20-Jun-11 15:44pm

soeun tony

Add a Solution

Comments

Sergey Alexandrovich Kryukov 20-Jun-11 21:46pm

Not clear. What do you mean by "record". What events do you handle. Show your code and full exception dump, indicate code lines where it happens, post it. Use "Improve question".
--SA

soeun tony 20-Jun-11 22:22pm

Thanks for your replied
normally, after we created datasource.it will created one dataset.at that time, when my text box link to field of the table in dataset at form loaded Event, it will display: myTableAdapter.Fill(Me.myDataset.myTable) code automatically.When i open my form, i will see any value on my text box and i also can move next, move last, move first....But for my purpose, i don't want to use myTableAdapter.Fill(Me.myDataset.myTable) at form loaded Event.so if i dont use it, when i open my form. it also don't display any value on text box too.
My purpose is: I don't want to use myTableAdapter.Fill(Me.myDataset.myTable) at form loaded Event but i can move next, move last,move first.......
Best Regards,

Christian Graus 20-Jun-11 23:36pm

It sounds like you're writing code to iterate over a data source, one record at a time. Edit your post to give us the full error message, and the line of code that gives the error. Some info on what you see when you debug the code would also be helpful. No-one can answer this

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Savalia Manoj M · Answer 1 · 2011-06-20T18:38:00

Solution 2

Try this link...

http://www.codeproject.com/KB/grid/BindSourceBindingNavCS.aspx

Posted 20-Jun-11 18:38pm

Savalia Manoj M

jaysing123 · Answer 2 · 2012-10-10T18:56:00

Solve Problem
by :-Jaysing Chavda

VB

connetionString = "Data Source=SOFT05-PC;Initial Catalog=Demo;User ID=sa;Password=sa123"
        da = New SqlDataAdapter("Select * From Test", connetionString)
        Dim ds As New DataSet
        da.Fill(ds)
        bm = Me.BindingContext(ds, "Demo")
        dr = ds.Tables(0).Rows(ds.Tables(0).Rows.Count - 1)
        TextBox1.Text = dr(0)
        TextBox2.Text = dr(1)
        TextBox3.Text = dr(2)
        TextBox4.Text = dr(3)
        TextBox5.Text = dr(4)

jaysing123 · Answer 3 · 2012-10-10T18:56:00

Solve Problem
by :-Jaysing Chavda

VB

connetionString = "Data Source=SOFT05-PC;Initial Catalog=Demo;User ID=sa;Password=sa123"
        da = New SqlDataAdapter("Select * From Test", connetionString)
        Dim ds As New DataSet
        da.Fill(ds)
        bm = Me.BindingContext(ds, "Demo")
        dr = ds.Tables(0).Rows(ds.Tables(0).Rows.Count - 1)
        TextBox1.Text = dr(0)
        TextBox2.Text = dr(1)
        TextBox3.Text = dr(2)
        TextBox4.Text = dr(3)
        TextBox5.Text = dr(4)

ElectronicShocker · Answer 4 · 2011-06-20T18:07:00

Solution 1

If you Google it, you might find some answers.

Posted 20-Jun-11 18:07pm

ElectronicShocker

Move record in VB.net

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0