473,406 Members | 2,378 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Datagrid and recordset..

46
Hi all,

I am now using vb6 to store and get the data according to the process, machine line and machine. Let say, Line A02, process texture, machines are m1, m2 and m3. The user might store the data many times for each machine(down time, in hour). So now, I want to seperate each machine data with each machine total hour. What should I do? I am using datagrid and adodc to get the data from the MySQLserver.

Can I use many adodc for 1 datagrid?
Can I use 1recordset to sort data in many times?
I mean: filter out the m1 data, then add the total hour and place in a text box,
then, filter out the m2 data, add the hour and place in another text box,
and same as m3.

But I had tried, the recordset got debug.

Can anyone teach me about recordset? How to use it?

Please give me your hand. I need you.

Thank you.
May 28 '07 #1
1 1452
Atli
5,058 Expert 4TB
This sounds more like a VB problem than a MySQL problem so I'm moving it to the Visual Basic Forum.

I've also edited the title. Please refrain from using the word 'Help' in the title!

MODERATOR
May 28 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: JingleBEV | last post by:
Hi all, I don't seem to get this going, possibly lacking the knowledge of dao recordset. I try to fill this Datagrid with the DAO.recordset, but it keeps giving me the error 13 - datatype...
4
by: Pacific Design Studios | last post by:
I have a DataGrid on Form1 that displays a small amount of information about employees. On Form2 I want to have all the data displaying in text boxes about the employee selected in the datagrid on...
1
by: Francis Bisson | last post by:
I trie to set the datasource of a datagrid with a recordset. On VB6 I can make that with : SET DATAGRID.DATASOURCE = RECORDSET This is possible to make the same on VB.NET??? Thank You! ...
5
by: Allen | last post by:
Is there a way to bind a datagrid in VB.Net to an ADODB Recordset object? I have tried: rs.Open ("SELECT Name FROM tblStaff",connection) dgTest.SetDataBindings(rs,"") The recordset is...
5
by: Niels | last post by:
Hi There, I have a form with a datagrid, and some text/combo-boxes and a button. When I select a record in the datagrid an press the button I want to see the valeus of the cells from tehe...
1
by: John Doe | last post by:
Now i know how to manually add a combobox to a datagrid, but how would i handle the recordset below? ID | FirstName | LastName | Job -------------------------------- 1 |Joe | Smith |...
4
by: juya | last post by:
Hi all, I have been struggling with datagrid for more than a week. I pretty new to datagrid, have never used it before. All I am trying to do is Edit the TDBGrid in Visual basic. I am...
0
by: berry | last post by:
Hi guys.. How to write the code 'if the datagrid is empty'? i using VisibleRows as shown as below. Hope any of you can look for it If Datagrid1.VisibleRows > 0 Then ...
0
by: berry | last post by:
Hi... I very need yours help. I having a very weird problem. I want to consider the datagrid is empty or not, then if not empty, i want to total up the value. I using datagrid.text <> "" in my code....
0
by: sumitdipsite2005 | last post by:
I am trying to use VB6 as a middleware between two 3rd party applications. "App. A" ----> VB6 ------> "App B" i am having no trouble sending data from VB to the "App B". But i am having...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.