Ad:

VB.NET Discussion Thread
Unsolved
Views: 1776

Nov 3rd, 2009

How to select a value in the database

Expand Post »

Using VB.NET

I am using Combobox, when i select the value in combobox, the date value should display in datetimepicker where date = combobox id

vb6 code

VB.NET Syntax (Toggle Plain Text)
cmd.CommandText = "select distinct Name from T_Person where personid = '" & txtno & "'"
Set rs = cmd.Execute
While Not rs.EOF
   If Not IsNull(rs("Name")) Then
txtName.Text = rs("Name")
       rs.MoveNext
    End If
Wend
cmd.CommandText = "select distinct Name from T_Person where personid = '" & txtno & "'"
Set rs = cmd.Execute
While Not rs.EOF
   If Not IsNull(rs("Name")) Then
txtName.Text = rs("Name")
       rs.MoveNext
    End If
Wend

txtno - combobox, txtname = datetimepicker1

The above code is working in vb6, But am new to vb.net

How to modify my code in vb.net

Need vb.net code help

Similar Threads

VB: Connect to Access database via ODBC datasource name in Visual Basic 4 / 5 / 6
retrieve data to DOM select from database in JavaScript / DHTML / AJAX
Writing to an Access Database in Visual Basic 4 / 5 / 6
submiting info into a database for retrieval! in PHP
mySQL database searching for registration in MySQL

jetjash

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jun 2009

Permalink

Nov 3rd, 2009

Re: How to select a value in the database

vb Syntax (Toggle Plain Text)
            Dim myDA As New OleDbDataAdapter
 
            myCmd.CommandText = "select distinct Name from T_Person where personid = '" & txtno & "'"
            myDA.SelectCommand = myCmd
            myDR = myCmd.ExecuteReader()
            While (myDR.Read())
                    myDR("Name"))
            End While
            Dim myDA As New OleDbDataAdapter
            
            myCmd.CommandText = "select distinct Name from T_Person where personid = '" & txtno & "'"
            myDA.SelectCommand = myCmd
            myDR = myCmd.ExecuteReader()
            While (myDR.Read())
                    myDR("Name"))
            End While

yorro

Reputation Points: 8

Solved Threads: 7

Junior Poster

Offline

119 posts
since Aug 2009

Permalink

Nov 3rd, 2009

Re: How to select a value in the database

I dont understand the need for a loop to assign control values when only a single value can be displayed in the textbox and datepicker at a time. Also Im a bit confused by the naming conventions, a prefix for txt for a datepicker and your saying your looking for a date but the select statement shows your querying a field named "Name".

TomW

Reputation Points: 84

Solved Threads: 48

Posting Whiz

Offline

342 posts
since Sep 2009

Permalink

Nov 3rd, 2009

Same Problem

I have the same problem I am trying to read distinct values from an Access table but i get a syntax error. heres my code . The Code works fine until I put in the distinct key word.

VB.NET Syntax (Toggle Plain Text)

sql = "SELECT DISTINCT Model,Make,Problem,HP FROM Makes"

can anyone point me in the right direction.

thanks
james

Last edited by JAM1011; Nov 3rd, 2009 at 8:21 pm.

JAM1011

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Nov 2009

Permalink

Nov 3rd, 2009

Re: How to select a value in the database

Your SQL syntax is invalid. Typically you use Distinct() on a single column. I'm not sure if this is the exact syntax with Access but this is how it would work in MSSQL:

sql Syntax (Toggle Plain Text)
SELECT Model, Make, Problem, HP
FROM Makers
GROUP BY Model, Make, Problem, HP
ORDER BY Model, Make, Problem, HP --This is an optional ordering line
Select Model, Make, Problem, HP
From Makers
Group By Model, Make, Problem, HP
Order By Model, Make, Problem, HP --This is an optional ordering line

It should be similar for access.

Last edited by sknake; Nov 3rd, 2009 at 9:13 pm.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Need to convert from string to integer

Next Thread in VB.NET Forum Timeline: Loading user input into parralell arrays, Please help!

DaniWeb Message

Cancel Changes

User Name
Password