AsyncFileUpload control FOR IMPORTING FROM .XLS FILE INTO SQLDATABASE [Resolved]

Posted by Anu_dgr8 under Regular Expressions on 6/21/2010 | Views : 2561 | Status : [Member] | Replies : 5
i need to create a page in which i need to have a textbox and a button beside it to browse a file..that file should only be .xls file ..i need to import all the records from the .xls file into sqldatabase..can this be done using AsyncFileUpload control??if yes,i wanted the exact code..

THanks in advance:-)

Thanks and Regards,
Hoosha Boosha



Responses

Posted by: Vuyiswamb on: 6/21/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down

Resolved
The Filupload control is used to Upload files to the server not directly to sql as depicted in the following
http://www.dotnetfunda.com/articles/article633-asyncfileupload-control--new-control-in-ajax-control-toolkit-.aspx

and if you want up import the File data from Excel to SQl you need to do as explained in the Following Article
http://www.codeproject.com/KB/database/Excel2Sql.aspx
http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx

Thank you for posting at Dotnefunda

Vuyiswa Maseko




Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Anu_dgr8 on: 6/22/2010 [Member] Starter

Up
0
Down
I wanted to import data from Excel Sheet into SQL DATABASE...CAN'T IT BE DONE USING AsyncFileUpload CONTROL??

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 6/22/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
as i said, the control has nothing to do with sql, what it does it copies the file to the location of your choie and you have to make sure that you write a code to copy that Excel sheet to SQL as it has showed in the links.

Kind Regards

Vuyiswa


Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Anu_dgr8 on: 6/22/2010 [Member] Starter

Up
0
Down
ok Thanks alot

Thanks and Regards,
Hoosha Boosha

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 6/22/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Thank you for posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Anu_dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response