Creating Form to Create, Modify and Delete

[millardesigns]

I need some direction. I am currently creating a form in C# in which I need to add, modify and delete some inventory to excel. I am having some trouble trying to grasp my own concept. I need to keep the inventory updated but also export it in another excel sheet that will be linked to additional information. Example: (Step 1) Company Name, Company Code, and list of servers - This information will be pulled from an excel sheet that needs to have the ability to add, modify and delete. (Step 2) The information above will autofill in my form to where additional information will be complete. I need this to also add, modify and delete to an excel sheet. This will help me keep an inventory of company servers and additional required info. Can anyone point me in a direction to examples or books that can help me grasp this concept. If there is an easier way to this,I am open to suggestions. I do not have the ability to download Sql to my pc. Also this form will be put on a sharepoint for multiple persons to enter inventory. Thank you in advance for all your suggestions and help.

[vidhyasagar]

Hi, just read the data intially from the excel sheet and store it some where on your object/string. And finally when the data operations are done, just push all the data to a string, which you want to write in excel(with comma separated values: Eg: Name,Age\nVidhy aSagarReddy,23\ nRaviChandra,23 ; which will be displayed as: Name and Age in the first row; VidhyaSagarRedd y details in the next row and last details in the second row).