|
Hi, All
iam stuck on that how i reterive the particular record from data table object
Actullay i passed query result into dataset and create data table onject and fill the table with sql data adopter but now i have to extract particular record form data table object
PLease help me iam stuck on this .
|
|
|
|
|
The Rows property is a collection of all rows in the DataTable. You can use it to access any of the rows by index.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
thnks for response
kindly write few lines of code that how i do that actully i wants to extract particular record from data table object and loop through the each row .
thanks for response
Rameez
|
|
|
|
|
Its just a simple for next loop, during which you look for the record you want.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Free hand, but you get the point:
For each oRow as DataRow in dsSales.Tables(0).Rows
If convert.toint32(oRow("CustomerID")) = 1234 then
'Do work here......
End if
Next
Cheers
|
|
|
|
|
You could use a DataView to filter your table and return the results.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Hello,
How do i include the ADODB component to vb6? I've searched the available components though I can't find Microsoft ActiveX Data Objects 2.5 Library or 2.6 for that matter. Is there anyway around this? Many thanks for the help
Aim small, miss small
|
|
|
|
|
tatchung wrote: How do i include the ADODB component to vb6? I've searched the available components though I can't find Microsoft ActiveX Data Objects 2.5 Library or 2.6 for that matter. Is there anyway around this? Many thanks for the help
You need to install MS Data Access Components.
|
|
|
|
|
How to Create utility page in VB.Net?Please help me out of this issue.
|
|
|
|
|
The reason someone gave you a 1 is that your question makes no sense. It's ridiculous. What the hell is a utility page, and why are you asking a top level question that implies you have absolutely no idea what you're doing ? How are we to know how to answer it, in a way that you understand, if you can't even explain what you mean ?
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
5 rating for that answer 
|
|
|
|
|
A would suggest a 6 
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein
I look at Microsoft, and turn to my poster on the wall saying: "Bang head here in case of stress".
|
|
|
|
|
I kept on asking myself what do you mean when you say "utility page". But atleast someone tought you a lesson, next time you will think befoer you post here.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Im communicating with a PLC which works on MODBUS RTU protocol. Need to continuously monitor the registers in it using serial communication. Iv used RS232 Class which i found from Codeproject. Im using a timer object to continuously send read/write command on the port. Iv Set Timeout period as 1000ms and Timer's Interval time as also 1000ms. After a few cycles communication fails and it prompts NULL Exception Argument.Can you Plz guide with it.
Jalpa
|
|
|
|
|
There are also some articles about MODBUS here at CP [^].
See also these pages [^], [^].
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
First of all thanx for replying. Iv tried all those links but none of them worked. Since in coding in VB.NET it does not provide me with any readymade class so iv included a class called as CRs232 which I found through the NET. I think the NULL EXCEPTION ARGUMENT that im getting is due to the incorrect CommTimeOuts that iv set. So if you could help me with a method for finding out the correct Time-Outs.
|
|
|
|
|
jalpam wrote: Since in coding in VB.NET it does not provide me with any readymade class
Are you sure [^]?
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Ya sure. That may be because im using Microsoft Visual Studio.NET 2003. The code that the link has provided would be supporting some other version of Microsoft Visual Studio.NET
|
|
|
|
|
Possibly you just need this [^].
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[Image resize DLL]
|
|
|
|
|
Thanx for the link......
I tried changing the CommTimeOuts and it worked. Now wat im trying to do is that every 500ms i need to dump the registers which i hav read through communication into a DataGrid. When i disable the grid and jus read the registers in a listbox its works but the moment i try to read it in a Grid it fails.
|
|
|
|
|
|
Hi,
I am working on application,which requires fetching data from an Excel sheet,for a particular row.
Please suggest me hw I can do it.
Thanks in advance.
G Singh
|
|
|
|
|
What have you done so far?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
|
hi everyone,
I have one problem while using this split function in vb.net.
actually my requirement is i have a valuepath of my treeview control.
and i have to split it in a reverse direction.
Ex.
M002/67/03/26/21.....
i want this to be split in reverse like i have to get the date of 21 next 26 next 03 like that
hope u all understand my need..
waiting for ur replies...
thanks
Prasad.M
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
