Datagrid to input

rajanikrishna · March 16th, 2006, 07:23 AM

Hi,

How can I use datagrid to input my data to table. Like Excel?

thanks in advance

jbenson001 · March 16th, 2006, 11:59 PM

You can exprt a gridview to excel. Check the VS help files.

mattock · March 17th, 2006, 04:48 AM

Hi

Is there anyway of doing it the other way around? I have managed to get a table from my sql database too display in excel, how ever, if i made changes to the excel file, how would i update the sql database FROM excel?

Thanks

jbenson001 · March 17th, 2006, 10:55 AM

That's really a sql questin not an asp 2.0 question. Look into openquery, the import wizard, DTS or SSIS packages depending on what version of SQL you are using