473,323 Members | 1,551 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,323 software developers and data experts.

datagridview

Hi,

I am a newbie on vb.net and need a sample to help me how to access data using datagridview.In our database, we have about 300 tables. The objective of the project is to design an application for users - who can pull up a table and enter data, import excel data into the table etc.,

I would like to create one generic form - user selects a table in the list from UI and using datagridview control, i need to display all the rows on the screen.The user should have edit ability to the data.Appreciate your help - thanks
Sep 8 '07 #1
3 895
JosAH
11,448 Expert 8TB
You should've asked your question in the .NET Forum section, not in the .NET
Articles section. I'll move your question for you.

kind regards,

Jos
Sep 9 '07 #2
kenobewan
4,871 Expert 4TB
Suggest you search the site and other resources on the use of datagridviews. It is your responsibilty as the solution architect to come up with a design.
Sep 9 '07 #3
Hi adithiaz,

The Design would be something like this:

1.The user needs to login first.

(WEBFORM 1)
====================================
Enter UserID:<TextBox>
Enter Password:<TextBox(display asterisk)>
====================================

(WEBFORM 2)
2. if the Login is successful. You may show the details for the user.
3. You may have several actions and maybe you can represent that in buttons.

==============================================
USER FILE SYSTEM
==============================================
Current User :<Label>
Date?: <Label>
===============================================
[Ins] [Del] [Import] [Refresh Grid]
Search: <TextBox> [Go]
===============================================

'this is your datagrid
===============================================
Field1| Field2 | Field3| Field4
===============================================
[x] 1 Info 1 .... <-- to edit a record you may change into a hyperlink or linkbutton
[x] 2 Info 2 .... to redirect to the next edit/view page (WEBFORM 3)
[ ] 3 Info 3 ....
[ ] 4 Info 4 ....
[x] 5 Info 5 ....
--------------------------------------------------------------------------------------------------
=================================================

4.The datagrid design can be something like this.. you will notice that in your datagrid
(Field 1) there is a checkbox.. This will help user to select records for deletion.



(WEBFORM 3)
USER FILE SYSTEM
Current User :<Label>
Date?: <Label>
===============================================
[Save] [Cancel
===============================================
Field 1: <TextBox>
Field 2: <TextBox>
Field 3: <TextBox>
Field 4: <TextBox>
===============================================

5. The Save button will insert or update the current record
6. The Cancel button will go back to the previous page and ignore any updates



Best Regards,
Ruel






Hi,

I am a newbie on vb.net and need a sample to help me how to access data using datagridview.In our database, we have about 300 tables. The objective of the project is to design an application for users - who can pull up a table and enter data, import excel data into the table etc.,

I would like to create one generic form - user selects a table in the list from UI and using datagridview control, i need to display all the rows on the screen.The user should have edit ability to the data.Appreciate your help - thanks
Sep 10 '07 #4

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

Similar topics

0
by: DraguVaso | last post by:
Hi, I'm using the DataGridView in VB.NET 2.0. The DataSource is a Generic List of a custom class0: lstMyPersonnes = New List(Of clsPersonne). When I add a new clsPersonne to lstMyPersonnes,...
6
by: dbuchanan | last post by:
Hello, Is this a bug? Is there some kind of work around? I want to add default values for a few columns in my datagridview I found the "DefaultValuesNeeded" event for the datagridview I...
10
by: Henok Girma | last post by:
Hello Gurus, I want to save the state of an unbound DataGridView on my Windows Form application to an XML file so i can later load it back.. Basically, on my form I have a DataGridView, it's got...
3
by: Rich | last post by:
Hello, I am populating a datagridview from a datatable and filtering the number of rows with a dataview object. Is there a way to retrieve the rows displayed by the datagridview into a separate...
2
by: bob | last post by:
Can anyone tell me the best way to update a dataset while it is being edited/viewed in the DataGridView control? Is this something that should be inserted into one of the grid's events? or should...
7
by: Mitchell S. Honnert | last post by:
Is there an equivalent of the DataGrid's DataGridTableStyle for the DataGridView? If not, is there an easy way to duplicate the DataGridTableStyle's functionality for the DataGridView? Here's...
7
by: =?Utf-8?B?TG9zdEluTUQ=?= | last post by:
Hi All :) I'm converting VB6 using True DBGrid Pro 8.0 to VB2005 using DataGridView. True DBGrid has a MultipleLines property that controls whether individual records span multiple lines. Is...
0
by: jeastman - Hotmail | last post by:
Hello world Excuse, not to be written English and it helps me with a translator. I am new programming in C#. I made a control inheriting the DataGridView to be able to add controls done by...
3
by: Andrus | last post by:
I have DataGridView in virtual mode containing 3500 rows. In code below, assigning to RowCount value to 3500 takes 8 seconds. CPU usage goes high at this time. Stepping by F11 into user code shows...
0
by: priyamtheone | last post by:
I'm trying to make a datagridview column to act like a datetimepicker column (C#.Net 2005). These are the behaviours that the dgv should have: 1) Initially all the cells of the dtp column should be...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.