Do not use on any
shared computer
August 30, 2008 03:31am pdt
 
[x]
Attachment Details

Get Row number from access database using VB.Net 2005

Tags: row, number, get, access
Hi, I am using VB.net 2005 for the first time. I am connecting to a access database using oledb and running a sql quere to return only ever returns one record and this needs to be updated. this all works fine. its when i try to update the record i need to know the row number to update it and this is where i am stuck i cant seem to find any info on getting the current row number back.
Here is my code

Imports System.Data.OleDb
Imports System.data
Public Class FrmEditDetails
    Dim cmd As OleDbCommand
    Dim RsDetails As OleDbDataReader
    Dim SqlString As String
    Dim TempStr As String
    Dim da As New OleDb.OleDbDataAdapter(SqlString, RsSick)
    Dim ds As New DataSet()
    Dim dt As New DataTable("Details")
    Dim drCurrent As DataRow
    'Dim myCommandBuilder = New OleDb.OleDbCommandBuilder(da)
    Dim Row As Integer


    Private Sub FrmEditDetails_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
     
        RsSick.Open()

        SqlString = "SELECT * FROM Details WHERE "
        SqlString = SqlString & "Name2 = '" & ItemNo
        SqlString = SqlString & "';"

        cmd = New OleDbCommand(SqlString, RsSick)
        RsDetails = cmd.ExecuteReader

        Do While RsDetails.Read
            Text4.Text = RsDetails!Name2
            Text3.Text = RsDetails!TelNo
            Text1.Text = RsDetails!MobNo
            Text5.Text = RsDetails!Address
            Combo1.Text = RsDetails!Station
            Combo2.Text = RsDetails!Rank
            Text2.Text = RsDetails!Info

888888 Need to be able to assign rownumber to row variable here 888888888888

        Loop
        RsSick.Close()

    End Sub

    ----------------------------------------------------------------------------------------
    Private Sub CmdUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdUpdate.Click
        da.Update(ds, "Details")

****** need what row number to modify here ***********

        ds.Tables("Details").Rows(Row).Item(1) = Text2.Text


Thank You

    End Sub
End Class
Start your free trial to view this solution
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

Question Stats
Zone: Programming
Question Asked By: mcguirestick
Solution Provided By: gangwisch
Participating Experts: 2
Solution Grade: B
Views: 149
Translate:
Loading Advertisement...
 
[+][-]Accepted Solution by gangwisch

Rank: Guru

Accepted Solution by gangwisch:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by mcguirestick
Author Comment by mcguirestick:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Assisted Solution by JunnickYso
Assisted Solution by JunnickYso:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34