473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Database programming in VB.NET

hi friends...
i am new to VB.NET. and C#... i was trying to read some data from the
database using code,
and display that in 2 textboxes.i was able to get only the first row.
i used ExecuteReader() function of SqlCommand class and read()
function to read data..
i have put a button on the form to advance the records..
in that click method i have called the read() function...
but it's not moving to the next record...even after clicking the
button...
please help me anyone...
thanks and regards...
sandeep...

Oct 14 '06 #1
3 1141

"sandy" <sa*******@gmail.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
hi friends...
i am new to VB.NET. and C#... i was trying to read some data from the
database using code,
and display that in 2 textboxes.i was able to get only the first row.
i used ExecuteReader() function of SqlCommand class and read()
function to read data..
i have put a button on the form to advance the records..
in that click method i have called the read() function...
but it's not moving to the next record...even after clicking the
button...
please help me anyone...
thanks and regards...
sandeep...
Try this article, with VB example code:

http://msdn2.microsoft.com/en-us/lib...qlcommand.aspx
Oct 14 '06 #2

Thanks a lot pvdg42...

but i was getting the data when used read() inside a while loop.
Problem is in displaying the data in textboxes..the first record is
fetched.
and is shown, but it is not moving forward..
please help...
thanks & regards
sandeep...

Oct 14 '06 #3
Sandy,

I have given an answer in the vb.net language newsgroup about this. (This
because you are multiposting with Google, otherwise I would have let you
search yourself to this).

Cor

"sandy" <sa*******@gmail.comschreef in bericht
news:11**********************@i3g2000cwc.googlegro ups.com...
>
Thanks a lot pvdg42...

but i was getting the data when used read() inside a while loop.
Problem is in displaying the data in textboxes..the first record is
fetched.
and is shown, but it is not moving forward..
please help...
thanks & regards
sandeep...

Oct 14 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: A Cate | last post by:
I am new to PHP. I am trying to develop a web site on a development machine that needs to access data in a mysql database. I have mysql running on my development machine with a copy of the...
0
by: John Davis | last post by:
I always heard the term "data/database driven programming" model in ASP database, SQL programming, and web programming circles. But I don't quite sure what does it mean? Does it mean the web...
2
by: hplloyd | last post by:
I am fairly new to VB.NET programming but have built many database applications in Access SQL Server etc. I need to find a good book or other reference material that will help me take my OO...
6
by: Randy Yates | last post by:
Hi Folks, I'm looking for something that is completely independent of the MSVC++ Dev Studio environment, something that will compile and run under win32 using the mingw distribution. A class...
3
by: Alan | last post by:
I am coming from other programming tools field, and new to VB .NET. Just wondering what is the common approaching in database programming in VB .NET? 1) Are you guru always using the data aware...
3
by: jaYPee | last post by:
i am searching a lot of resources in the net that discusses about database programming. i'm still searching on it and would like to received any links that discusses about database programming in...
1
by: Dave | last post by:
Hi, I work on a small team that currently uses an access 97 database for managing peoples time. The database front end is heavily implemented in VBA and is secured with user level security,...
8
by: Maxi | last post by:
Hello, i'm sorry my bad english :( I have CR9 Webservice, how to change databadse name and User_name into Webservice method? (not Viewer Control) Tks!! -- --------------------------
2
by: webcm123 | last post by:
People say that structural programming isn't good for database connection. I code fast-running structural oriented CMS and I don't know what I should do. I use mysql connection using mysql_*. I...
4
by: triton96 | last post by:
I want to get in to programming but would like your input on a couple of things: I would like to write some basic applications that would for example create a payroll check or create a billing for...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.