473,802 Members | 2,228 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Datagrid and recordset..

46 New Member
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 1476
Atli
5,058 Recognized Expert Expert
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
6075
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 mismatch. Can somesone shed some light please. I define rsDepartmentList as Dao.recordset
4
2211
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 form 1. Is there a Id in the datagrid I can use to find out which user was selected or which record was highlighted when double clicked. Something like: John Thomas Employee Id 2637 was selected on Form1 and the recordset on Form2 would use...
1
1062
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! Frank
5
7097
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 filled but it returns an error at the datagrid databinding.
5
1318
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 selected record in the text/combo-boxes. At this point I only get the first record shown even when i select the second record.
1
1473
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 | janitor 1 |Joe | Smith | cashier 2 |Bob | Anderson | cook I want to bind the above datatable to a datagrid so that
4
2306
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 populating the Datagrid from a adodb recordset. Here is my code Dim rssqldb As ADODB.Recordset Set rssqldb = gfGetData(Conn, 10, "exec payroll" & "'12/01/06'")
0
1101
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 adodc1.Recordset.MoveLast Do While adodc1.Recordset.BOF <> True) total = total + adodc1.Recordset.Fields("Hour") adodc.Recordset.MovePrevious Loop text1.Text = total
0
987
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. Overall i have 3datagrids. The program run smoothly at the first 2datagrids. But when reach to the third datagrids, It occurs error "data access error". What is the proint?? Please help me! Thank you.. If datagrid1.Text <> "" Then ...
0
1736
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 some trouble in reading data from "App A".
0
9699
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9559
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10529
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10058
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7596
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6835
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5492
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4268
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2964
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.