craigewens
asked on
Web Form : Require table / gridview / details view / repeater view assistance...
Hi,
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.
Thanks!
Craig.
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.
Thanks!
Craig.
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
SandeepRR
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
SandeepRR
ASKER
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.
Craig.
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.
Craig.
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.
SandeepRR
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.
SandeepRR
ASKER
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.
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.
ASKER
I've found this example which seems to do what i require.
http://fredrik.nsquared2.com/viewpost.aspx?PostID=155
http://fredrik.nsquared2.com/viewpost.aspx?PostID=155
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks