473,811 Members | 1,881 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HELP in saving all information in a datagrid in vb6?

26 New Member
How to save all the information in a datagrid in just one command button, click, and it will automatically save in the table in access(student name,and student subjects will added and save in table ), regardless on how many records were bind in a datagrid.

im using dataenvironment in connecting my database MS Access 2007, hope you help me on this matter (please just a dataenvironment code) cause modules is too complicated for me..

im working with enrollment system and im stuck in this, student's subject's transaction, i want to save all subjects in my datagrid in just a single click of a command button.

kindly help me ASAP...

that's if your not busy and in a good mood...x)

thanks in advance... GOD bless... and more power... to you...

additional question?

for you, what is the simplest programming language now a days? cause i want to try it for sure... and i want to adapt that new trend programming language..


thanks a lot... sir/maam...


"And if you have a system related to vb6 college enrollment system,please kindly email me at spincer31069@ya hoo.com your kindness is much appreciated..." don't worry sir/maam i will promise that i will not copy all you have made for your program i just want to know and analyze some codes that you made... x)

that's all thanks to the answers... note: it is better to give than to....receive.. . i mean it is better to share your precious knowledge than to keep it forever... that's one of my moto in life x)

--------

below i attach my image form to relate my problems...
Attached Images
File Type: jpg sub.jpg (13.2 KB, 4303 views)
Oct 18 '09 #1
3 5190
Crystaltech
6 New Member
'''' hope this will help

Private Sub Command1_Click( )

dim DTL AS NEW ADODB.RECORDSET

If DTL.State = 1 Then DTL.Close

DTL.Open "select FieldName from Table Name", con, adOpenKeyset, adLockPessimist ic

If DTL.RecordCount > 0 Then

Set DataGrid1.DataS ource = DTL

End sub
Oct 21 '09 #2
regan2007
12 New Member
How are you going to connect one desktop visual basic application to another visual basic application in a network?Please help me....
Oct 21 '09 #3
joxun
5 New Member
Pls, One more. I would like to display more than 500 icons into the form. Is there an easy way to do it. I know vb.net does not allow to create an array of variable. Can I create one PictureBox and divice it into several pieces.

Antigua Holidays
bra accessories
Oct 24 '09 #4

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

Similar topics

8
3131
by: pei_world | last post by:
Hi, there; I have a problem with my datagrid control. I declared it in one of my form, set with DataGridTalbeStyle as well, and when I click on button, I would like to retrive Data from Database and bind these data to my datagrid in the form, when I click the button first time, it work fine. but when I click the second button. it report belowing error, I guess it is because it already set up the column name at first time, so cann't do...
2
5423
by: John Rajendran | last post by:
HI there, I need to make the functionality of right clicking on a datagrid cell and try to invoke some menu driven code. It could be a file opening, file saving or my own event driven code. Is this possible, if so can someone help me with some sample code. Thanks john ___ Newsgroups brought to you courtesy of www.dotnetjohn.com
4
2283
by: steroche | last post by:
I would REALLY appreciate help please please please! Im sure it is probably blindingly obvious to most of you but I am totally in the dark here!I am lost - i thought i had finally figured out this dataSet updating lark when i realised that i think i am right back at square 1!!! Here's my scenario - i have a SQLDB and i retrieve all my data from that into a dataset and display this to a datagrid(WebForm). I have got this grid sorted and...
14
1847
by: Brett Sinclair | last post by:
Hello everybody I'm still on the learning curve here...and from what I read, I created inherited datagrid class so I could have icons, combobox...etc in the columns of my datagrid. The grid will be used to populate information coming from a Webservice. (No datasets - No datareaders). So, I do not know see how to use the "datasource".
4
2142
by: Jeff User | last post by:
Hi I tryed to solve this problem over in the framework.asp group, but still am having trouble. Hope someone here can help. using .net 1.1, VS 2003 and C# I have an asp.DataGrid control with a Delete button on the end of each row. I am unable to gain access to the event when the button is clicked. I don't fully understand how the click gets connected to the C# code,
5
4736
by: TheGanjaMan | last post by:
Hi everyone, I'm trying to write up a simple image stamper application that stamps the Exif date information from the jpegs that I've taken from my digital camera and saves the new file with the date stamped on the lower right part of the picture. (I'm not an advanced programmer so my code may not be 100% efficient - sorry, I'm still learning) Everything works fine until the saving part. I've been able to read the file into a...
7
1812
by: Niyazi | last post by:
Hi, I am developing small insurance application using VB.NET and SQL server 2000. My tables in SQL server are: tbl_Customer (stores the custmer information) tbl_CustImage (stores the customer picture and signature) tbl_InsuranceCompanies (stores the Insurance companies information) tbl_InsuranceType (stores the insurance type)
0
1336
by: khaleelrashid | last post by:
I would be very thankful if anyone do this till 30 dec Write a C++ program that contains a structure named “Account” having four data members 1) Account number 2) Account holder name 3) Account type
1
4282
by: psyvanz | last post by:
i have created 2 tables name table1 and table2 with the same fieldnames in subjectnumber(sub-0001), subjectname(english1) but in my table2 i added studentnumber(s-0001) and studentname(paul) im using dataenvironment in connecting my (table1) ms access 2007 database in a datagrid but my problem is how to save and add all information bind(table1) in datagrid into another database table2 in my ms access, i want to connect what is inside my...
0
9728
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
10648
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...
1
10402
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10135
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
7670
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
6890
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
5692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4339
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
3018
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.