Re: Problem in adding dll files - Visual Basic Discussion Boards

vbbeg4-Jun-07 7:11

4-Jun-07 7:11

Thank for your patience dave.

I just need clarification on something.. realisticly what im trying to do is clone a record and rewrite columns so that essentially its not a duplicated record after all when its written to a table but I havent been able to work that out. (any advice you can give me will save you reading below and helping me along where im at right now)..

so imagine in my DGV i have surname , firstname , address . if i select a particular record showing these columns and rows respectively i want to additionally go to the table and also get "phone number" etc.

i guess what im asking is based on the DGV selection how can i go to the table and pickout the rest of the fields i need for that same row of data selected in the DGV.

e.g. SELECTED ROW IN DGV(IN BOLD)

[SURNAME]-[FIRSTNAME]-[ADDRESS]
CHAN,...........ALEX,.......mamre drive.............[AT INDEX 0}
Bloggs,.......JOE,.......2 Hollywood st , hollywood..INDEX 1

if i sort this by FIRSTNAME IN DESCENDING. it would be

[SURNAME]-[FIRSTNAME]-[ADDRESS]
Bloggs,.........JOE,.....2 Hollywood st , hollywood... INDEX 0
CHAN,.............ALEX,.....mamre drive .....................INDEX 1

im trying to use the below line
where "i" is the row number coming from DGV select row index.
dim value as string
value = ds.tables("customers").rows(i).item("phone")

* if i use the index from the DGV after i sort it it doesnt return the correct record to match the phone number...

just a reminder.. If i dont sort the DGV at all. I can use the DGV.index and use it here :
dim value as string
value = ds.tables("customers").rows(i).item("phone") it WORKS CORRECTLY. its just after i sort the DGV that I cant get

ds.tables("customers").rows(i).item("phone") to return the correct row from the table..

sorry about this dave .. thanks for your patience.

Robbo

Re: a question about row-index

Dave Kreskowiak4-Jun-07 8:09

Dave Kreskowiak

4-Jun-07 8:09

You do not need the row number at all. Once you have to DataGridViewRow, you have the ENTIRE record that was clicked on. Every field that the grid was bound to in is that row object. So

Dim phone as String = cell.OwningRow.Cells("phone").Value

gives you the Phone column of the row that was clicked on. The example, of course, assumes that the Value property in that column returns a String. You'll have to change it to match whatever you're expecting.

You don't need to go to the table to get the rest of the fields.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: a question about row-index

Dave Kreskowiak4-Jun-07 13:33

Dave Kreskowiak

4-Jun-07 13:33

If you didn't retrieve all the data you wanted in the first fetch, you need to change the first fetch to include the primary key in the table you bound the DGV to. When the use clicks on a row, you grab the PK value from the DataRow object and use that value in a second request to get the columns you need specifying the PK in the WHERE clause of the SQL SELECT.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: a question about row-index

vbbeg4-Jun-07 17:24

vbbeg

4-Jun-07 17:24

Thankyou Dave. I think now where getting somewhere. ill let you know how i go later on . thanks champ.

Problem in adding dll files

Nanda16054-Jun-07 0:59

Nanda1605

4-Jun-07 0:59

Hi

I am trying to add *.dll files as a reference in VB.NET 2005 but am recieveing the message as 'A reference (Path) could not be added please make sure that the file is accessible and that it is a valid assembly or COM components'.

Help me to proceed......

Thanks,
Nanda

Re: Problem in adding dll files

WhiteGirl234-Jun-07 2:07

WhiteGirl23

4-Jun-07 2:07

hi,
if you want to add reference to project:
go in solution explorer and you will find Reference and click right on Reference and choose Add Reference and after that you can choose your reference

hope it helped.

Re: Problem in adding dll files

Nanda16054-Jun-07 2:17

Nanda1605

4-Jun-07 2:17

Hi,
am recieving the error message while adding the reference(i can't able to add that dll), please help in this
Error message:
'A reference (Path) could not be added please make sure that the file is accessible and that it is a valid assembly or COM components'.

Thanks,
Nanda

Re: Problem in adding dll files

Dave Kreskowiak4-Jun-07 4:05

Dave Kreskowiak

4-Jun-07 4:05

You're getting this error message because your trying to add a reference to a .DLL that is not COM-based, just like the message says.

In order to use the functions in that .DLL, you do NOT add a reference to it. You call the functions through P/Invoke. Define the function headers in your code using the Declare statement and setting up the arguments that the function is expecting. For example, to call the Win32 Beep function found in kernel32.dll:

Declare Function Beep Lib "kernel32.dll" (ByVal frequency As Integer, ByVal duration As Integer) As Boolean

Then later in your code:

Dim r As Boolean
' Make a sound at 4000Hz, for 250 millisecond (1/4 second)
r = Beep(4000, 250)

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

help!

daredevil_beware164-Jun-07 0:55

daredevil_beware16

4-Jun-07 0:55

am new 2 vb

1. i want a value to be entered through a text box
2. store it in an array
3. input text length should be exactly ten
4. first four should be charachter next four integers last two charachters
5. how to achieve all this in vb6.0
6. please help me at de earliest

2nd question

1. i got a listbox filled with a table entry.
2. when i click it de corresponding row should be displayed in data grid

3rd question

1. if i enter a value in text box. supposing a name "devx" is given in de textbox i should retrieve all de rows that has de name as devx

tell me how 2 do from scratch coz i really dono much bout vb please help me

my tools are vb6.0 and access
with DAO connection