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

Posted by Anu_dgr8 under Regular Expressions on 6/21/2010 | Views : 4756 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	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

0	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

Latest Posts