[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Web Form : Require table / gridview / details view / repeater view assistance...

Posted on 2006-05-16
Medium Priority
Last Modified: 2010-04-23

I have a web form which inserts data into an SQL Server 2005 database using a stored procedure. This seems to be working fine, but i now need to add another function to it.

I have some fields which need to be filled in...
Work product | Issue From | Issue To | Verification Method | Checked By

My problem is that there might be one work product, or there might be 50.
I have investigated using datasets, datatables, grid views and detailsviews to try and achieve what I'm after and just cant seem to get any of them to function as i need.

I need the user to fill out these 5 fields and click add (as seen in a detailsview, having delete and edit would be a bonus too), the contents then get stored in a dataset or something, then once the rest of the form is complete the whole dataset will get passed into the stored procedure and dealt with by the server.

Basically I'm stumped on how to achieve this... somehow i need to bind a empty dataset to the control which will allow me to insert/edit and delete once it has contents... all happening without touching my database.

Please can someone assist me with this task, I'm hoping it's a lot simpler than I'm making it.

Question by:craigewens
  • 4
  • 2

Author Comment

ID: 16691503
I'd really appreciate some assistance with this issue sooner rather than later so i have raised the number of points to 500 for someone who can help me generate a working solution.

Expert Comment

ID: 16692096
Hi craigewens,
as far as my opinion

I think u should go for the datagrid as the datagrid provides the better way to manage the data on page also it provide the functionality like edit and update the data, delete the data.

also u can program the footer of datagrid so that can add new record to the dataset

and then u can replicate the changes in the dataset to the database with the updated, deleted and new records


Author Comment

ID: 16697391
Thank you for responding SandeepRR,

When you suggest a datagrid, do you actually mean GridView? I don't have a datagrid in my VS toolbox, but from what you've said the GridView control sounds similar...

Would you be able to offer some code samples of how to achieve what you have suggested?

Thank you.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 16697948
Yes i mean the Gridview only but i am used with the datagrid of VS 2003,

so lets move to solution,

I think u dont have to write much code in VS 2005 for these functionality;

most of the functionality can be added by the mouse click only, like EDIT UPDATE AND DELETE

if u want some help to set the gridview for this functionality, i will tell u the steps for that,

i have implemented this 3 functionality in gridview in less than 5 mins.


Author Comment

ID: 16698434
From what i can find out; a GridView only has the built in functions for EDIT, SELECT and DELETE.
The things I'm having trouble with are how i do the INSERT function and also how i successully link these functions to a datasource generated programmatically (not a connection to a database).
I know it sounds like i don't know anything, but I've been struggling with this for ages and can't believe how badly I've messed it up!

Some more assistance would be gratefully received.

Author Comment

ID: 16700752
I've found this example which seems to do what i require.

Accepted Solution

GranMod earned 0 total points
ID: 16968262
PAQed with points refunded (500)

Community Support Moderator

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month18 days, 21 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question