I am developing a particular application on VB.Net. I got stuck in a particular place. The senior is as under. The application deals with the statements of my clients. I am creating an application to send statements via SMTP in bulk. The application has to shoot almost around 10000 emails.
Currently I am not using the SMTP part instead I am diverting the statements to a notepad. The statements are getting generated as per the required structure. The only problem I am facing is that I have this data coming form a system where the branch are known by branch code. In our earlier application the branch code used to get replaced in the statements by the branch name for example.
Branch code Branch Name
001 India
002 UK
003 USA
004 Germany
And so on..............
The earlier application was on lotus notes and we had a view for the branch code in the application itself.
But in current application I need to fetch the details from an excel file. I have created the connection and the details are getting fetched in a dataset. But while converting the raw data in to a structured statement the branch comes blank. The field is not taking any value.
Question
Devil - The Great
Hello all,
I am developing a particular application on VB.Net. I got stuck in a particular place. The senior is as under. The application deals with the statements of my clients. I am creating an application to send statements via SMTP in bulk. The application has to shoot almost around 10000 emails.
Currently I am not using the SMTP part instead I am diverting the statements to a notepad. The statements are getting generated as per the required structure. The only problem I am facing is that I have this data coming form a system where the branch are known by branch code. In our earlier application the branch code used to get replaced in the statements by the branch name for example.
Branch code Branch Name
001 India
002 UK
003 USA
004 Germany
And so on..............
The earlier application was on lotus notes and we had a view for the branch code in the application itself.
But in current application I need to fetch the details from an excel file. I have created the connection and the details are getting fetched in a dataset. But while converting the raw data in to a structured statement the branch comes blank. The field is not taking any value.
Can any one please help me with this issue?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts