Hi,
I would like to have a dynamic gridview (number of columns will change depending on project) and I would like to be able to change the value in a gridview cell and that the database tables will be updated when the grid view cell is updated. An edit button is too cumbersom for the operator.
Anybody know if this is possible, and if so, do you have a piece of sample for me? Preferrably C# aspx with MySql but anything that can get me further is appreciated.
3 2333
When are you planning on updating your DB with the new information entered in the cell? What action will trigger the DB update?
Nathan
Well, I don't know exactly how this can be done, but I was thinking of updating the tables for each time a cell is changed. But in cases where the tables run large that can become a bit sluggish, so a good/better alternative can be to first do all changes needed, across columns and rows and then push an update database button.
The thing is that there are going to be quite a few rows that need update each time and it is too cumbersome to push the edit button for each update.
The operator should be able to tab it's way through the table, update the numbers where needed and then push the update button when all cell changes are completed.
I don't even know if this is possible, but it would be at least twice as fast as having a whole column of edit buttons. If I cannot get this to work, the alternative is probably to parce xl files, which is not a good solution in my mind.
Are you planning on updating the entire DB table with any changes made in the gridview? If you are going to update the database with all of the information in your dataset this task may be easier than you think. See the following link for more information.
Nathan
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: NateDawg |
last post by:
I'm reposting this. I'm kinda in a bind untill i get this figured out, so if
anyone has some input it would sure help me out.
Ok, I’ve noticed a few gridview problems floating around the forum. Everyone
wants to do a java confirmation box when a user clicks the delete button.
Fair enough, basic user design rules state that you should always confirm a
delete action. There is also a consensus that the best way to do this is a
template...
|
by: GregG |
last post by:
Greetings,
I have been working with the new GridView control, and while figuring
out most of it's idiosyncrasies on my own, have stumbled upon a
problem I cannot seem to resolve.
We have table displayed in a GV control.
It allows for editing and selecting, etc.
Some of the fields are 60 characters long, but only the first 20 or so
are relevant, and all of them have to fit on one line within the row -
|
by: Patrik |
last post by:
hello,
based on a client login I call a GridView that presents the appropriate
questionnaire for that person. I added three columns (template fields)
to the gridview that are radiobuttons. The client has to choose one
radiobutton per row (either YES, NO, or PERHAPS). Yes would have a
value of 1, No 2, perhaps 3.
1) I need to restrict the choice to one of the three radiobuttons ?
2) Need to insert the client's choice for every row in...
|
by: Frank |
last post by:
Hello All,
I am working with VS.NET 2005 and I have an editable GridView whose HTML
markup is shown below.
In short, when the user clicks on the Edit button, one of the textboxes is
replaced with a DropDownList that displays account numbers in a list. If the
user selects an account from the DropDownList that already exists in the
list, I wish to hide the 'Update' button or column, along with displaying a
warning message. I try to do...
|
by: Frank |
last post by:
Hello All,
I am working with VS.NET 2005 and I have an editable GridView whose HTML
markup is shown below.
In short, when the user clicks on the Edit button, one of the textboxes is
replaced with a DropDownList that displays account numbers in a list. If the
user selects an account from the DropDownList that already exists in the
list, I wish to hide the 'Update' button or column, along with displaying a
warning message. I try to do...
| |
by: =?Utf-8?B?c3Jpbml2YXM=?= |
last post by:
Hi All,
Can anybody please help me, how to access all rows in a grid view if the
paging is enabled?
If gridview contains 100 rows and pagecount=10, then in the gridview.rows
collection, i'm getting only those 10 rows which are displayed on the screen.
But i want to access all the 100 rows in the code.
Thanks in advance
|
by: servernet1997 |
last post by:
I have a gridview with 4 columns. Two of the columns are read-only and
two are editable. The two editable columns are listboxes leveraging an
ObjectDataSource. The first listbox is populated from a table of
static information, the second listbox is more problematic.
If the contents of the first listbox contains one specific value, I
want to populate the second listbox with the results of QueryA when
the row is edited. If the contents of...
|
by: Steve Kershaw |
last post by:
Hi,
I have a gridview with an UpdateQuery() that's fired when the user
edits/updates a row. The problem lies in the fact that every cell in
the edited row shows up as editable even though one cell actually gets
changed in the database.
Is there a way to make a cell appear non-editable?
Thanks
|
by: agamoto |
last post by:
hello guys,
i don't know if this is the right tread to post but i have the following problem:
i've built a dynamic gridview in run time because the gried values (columns, headers, etc) are conditioned with values that come from the database. I used TemplateField's to do that. i don't have a active connection to the database. i store my information to a dataset and bind it to the gridview
another thing is that all rows in m gridview are...
|
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,...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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,...
|
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...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |