Is it able to transfer the values from one lsit view to another???

[Vbbeginner07]

HI,
1) I have a list view with column id.and another list view with column name
can i get the name on other listview,if i click the id on the listview???
and
2)
if one value say gross salary of particular employee is not saved in databse and the calculation is in another form,if i have to get the gross salary of the particular employee by clicking the id in listv view1,(above mentioned),can i get that,IF THESE CONTROLS IN ANOTHER FORN WHER NO CALCULATION IS NOT DONE???

please clarify???
THANKS IN ADVANCE...........

[QVeen72]

Hi,

It is definately possible if ListViews have same "Key" ..

Regards
Veena

[Vbbeginner07]

Hi,

It is definately possible if ListViews have same "Key" ..

Regards
Veena

code:(vb)
If ListView1.SelectedItem.Checked = True Then
rs.Open "Select all date From saldetail Where id= '" & ListView1.SelectedItem & "'", conn, adOpenStatic, adLockOptimistic
ListView2.ListItems.Clear
ListView2.Refresh
ListView2.ListItems.Add = rs!Date
ListView2.Refresh
rs.Close
Set rs = Nothing

one listview with id and other with dates...
Check this out....
i need for one id i need to get their working dates as....say
102 01/02/08
01/04/08
01/06/08
but the above code is not working????pleaSE CHECK THRU

[QVeen72]

Hi,

By looking into the Code, you are using ListView as some ListBox (Only one Column) , Its better you have 2 columns..
For Second ListView, You have to Add SubItems of ID, This can be used as Key. In first ListView also use the Same ID as Key..
So when you populate second list, It should Contain 2 Columns, ID and Date.
So when you search, you can loop throug for the matching IS's
What Code, are you using for populating the First ListView..?


Regards
Veena

[debasisdas]

1.Populate the first list view by selecting from database.
2.on selection of the id in the 1st control. pass the id to SQL and retrive the related records.
3.polulate the 2nd listview from the resultset.

[Vbbeginner07]

Hi,
By looking into the Code, you are using ListView as some ListBox (Only one Column) , Its better you have 2 columns..
For Second ListView, You have to Add SubItems of ID, This can be used as Key. In first ListView also use the Same ID as Key..
So when you populate second list, It should Contain 2 Columns, ID and Date.
So when you search, you can loop throug for the matching IS's
What Code, are you using for populating the First ListView..?
Regards
Veena

SELECT THE RECORDS CORRESPONDING TO THE ID,WE HAVE SELECTED????

[Vbbeginner07]

1.Populate the first list view by selecting from database.
2.on selection of the id in the 1st control. pass the id to SQL and retrive the related records.
3.polulate the 2nd listview from the resultset.

rite now im getting only one date corresponding to it..

[debasisdas]

rite now im getting only one date corresponding to it..

do you have multiple values in the table for the specified id ?

[QVeen72]

Hi,

Loop through the Recordset and add values to ListView2,
Check your code, you are adding only first Record..

Regards
Veena

[Vbbeginner07]

do you have multiple values in the table for the specified id ?

same id repeated??? yes

[debasisdas]

Please find a related discussion here.

[Vbbeginner07]

Hi,
Loop through the Recordset and add values to ListView2,
Check your code, you are adding only first Record..
Regards
Veena

If ListView1.SelectedItem.Checked = True Then
rs.Open "Select all date From saldetail Where id= '" & ListView1.SelectedItem & "'", conn, adOpenStatic, adLockOptimistic
ListView2.ListItems.Clear
ListView2.Refresh
ListView2.ListItems.Add = rs!Date
'ListView2.Refresh
'rs.MoveNext
ListView2.Refresh
rs.Close
Set rs = Nothing

my code is valid or not?

[QVeen72]

Hi,

Change it this way..

If ListView1.SelectedItem.Checked = True Then
    rs.Open "Select all date From saldetail Where id=  '" & ListView1.SelectedItem & "'", conn, adOpenStatic, adLockOptimistic
    ListView2.ListItems.Clear
If Not RS.EOF Then
    Do While Not rs.EOF
        ListView2.ListItems.Add = rs!Date
        RS.MoveNext
    Loop
End If
rs.Close
Set rs = Nothing
 

Regards
Veena