Save datagrid contents into database?

Question

I'm populating my datagrid from an excel file which the user has uploaded. Now i want to save the whole datagrid into my SQL table. How to do this? (asp/vb.net)

Answer 1

because I can't understand very well your question

try to find help from the source and I find there

the idea is to use the datagrid control provided in the toolbox and "Admittedly, the DataSetGrid control is not exactly the type of control you'd use in every application. It turns out to be more useful for those quick applications that developers often need to build on the back end of a Web site to allow for easier customization and maintainance. In such a scenario, you have no scalability concerns that would prevent the caching of large chunks of data into the Session object. You can pack everything into a DataSet object and bind it to the DataSetGrid control. Quick and effective."

Whole article:

http://msdn.microsoft.com/msdnmag/issues/03/08/CuttingEdge/

Good Luck!

Answer 2

I did this for my database in my site

All you need is to save your datagrid values into CSV values (ASCII file that can be opened in Notpad) and in your MySQL Admin, import that file into you database



Enjoy my profile, I am the VBAXLMan

Answer 3

Save your excel file to CSV (Comma Separated Value) first, then import the csv files with MySQL.



http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

Answer 4

you may keep the hyperlinks to the photographs contained in the database quite than the photographs themselves. in case you may desire to ask its probable to puzzling for a beginner undertaking. in line with risk try a equipment like Wordpress and detect a plugin to do what you elect for to do.