How to save datagrid values in the database.
-
How to save an grid values in database (sql server 2005)at runtime.. Is there any link refer to me.. Thanx in advance..
-
How to save an grid values in database (sql server 2005)at runtime.. Is there any link refer to me.. Thanx in advance..
Hi, maybe this link: http://www.wherecanibuyit.co.uk/ASP/fully_editable_gridview.html[^] or this one: http://www.codeproject.com/KB/custom-controls/PSGridView.aspx[^] Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
How to save an grid values in database (sql server 2005)at runtime.. Is there any link refer to me.. Thanx in advance..
what do you mean exactly?? did you mean you want to update/select/insert/delete data on database from datagrid?? if you mean this,don't worry this is a simple job, just use SqlDataAdapter and set these commands for it: SelectCommand UpdateCommand DeleteCommand InsertCommand see this sample for more details: http://www.c-sharpcorner.com/UploadFile/raj1979/GridViewExample11232008075052AM/GridViewExample.aspx[^]
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
-
what do you mean exactly?? did you mean you want to update/select/insert/delete data on database from datagrid?? if you mean this,don't worry this is a simple job, just use SqlDataAdapter and set these commands for it: SelectCommand UpdateCommand DeleteCommand InsertCommand see this sample for more details: http://www.c-sharpcorner.com/UploadFile/raj1979/GridViewExample11232008075052AM/GridViewExample.aspx[^]
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
No i dont want to edit,update,select command.For example if i am loading an xml file to the project during run time.that particular file details must stored in database automatically... help me. Thanx in advance.
-
No i dont want to edit,update,select command.For example if i am loading an xml file to the project during run time.that particular file details must stored in database automatically... help me. Thanx in advance.
in general you can export your xml data to sqlserver using SSIS(Integration Service) but if you mean that your xml data binded to a grid and you want to insert these data into sqlserver from your grid, i think you can generate a datatable from your grid data, and then insert your datatable into sqlserver table completely.
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php