making of .csv file at run time
-
hello friends, i already posted my query but still need some more assistance to clear my doubt, am having a text box to get email address and a combo box to select its category for e.g category might be as IT Dept, Mech Dept and so, at the first form am inserting these to in to a table. in another form i have only the combo box which has loaded with the category data. when i select any category i need all the emails belongs to this category should come with a .csv file.. am stuck in " how to seperate emailid's as per the category and how to bundle it and make a .csv file at run time ... ?Confused
self confidence+hard work=SUCCESS
-
hello friends, i already posted my query but still need some more assistance to clear my doubt, am having a text box to get email address and a combo box to select its category for e.g category might be as IT Dept, Mech Dept and so, at the first form am inserting these to in to a table. in another form i have only the combo box which has loaded with the category data. when i select any category i need all the emails belongs to this category should come with a .csv file.. am stuck in " how to seperate emailid's as per the category and how to bundle it and make a .csv file at run time ... ?Confused
self confidence+hard work=SUCCESS
Hi Lee, I think you have to pass category Id in the DB and get all the emailid regarding that category.Like you have selected category "IT Dept" and its id is 2(CategoryId) then pass it to DB and collect result in DataTable
select email from tablename where categoryid = 2
Now you have all the email id in the DataTable. I hope you can now export this data to the .csv file :) Hope this will help you.
Regards :)
-
hello friends, i already posted my query but still need some more assistance to clear my doubt, am having a text box to get email address and a combo box to select its category for e.g category might be as IT Dept, Mech Dept and so, at the first form am inserting these to in to a table. in another form i have only the combo box which has loaded with the category data. when i select any category i need all the emails belongs to this category should come with a .csv file.. am stuck in " how to seperate emailid's as per the category and how to bundle it and make a .csv file at run time ... ?Confused
self confidence+hard work=SUCCESS