how to create excel dynamically and wirete the dataset values inside the sheet1 and store the excel in a folder

Question

can you please help me...
How to dynamically create excel sheet in asp.net using vb code. After creating the excel i want to write dataset datas into it after that  i need to store the excel sheet in a seperate folder.

Answer 1

refer This Link

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Answer 2

Thanks,
Can you tell me how to use this command with a textbox

regionTableAdapter.Insert(5, "NorthWestern");

can i write textbox1.text, textbox2.text instead of 5 and Northwestern. I tried it but it gave me error( I was explicitly converting the textboxes to int32)

????

Answer 3

Hi Waqas,

Please refer the below links

http://www.c-sharpcorner.com/uploadfile/mimrantaj/connect-to-access-database-in-C-Sharp-and-ado-net/

http://msdn.microsoft.com/en-us/library/aa288452%28v=vs.71%29.aspx

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Thanks