• 0

Help required on VB.Net


Question

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

  • 0

May be u have to check for the domain values of the branch codes <--> to branch names....

use nullable values to know whether the row contains values or not???

Hope, Might help you to go forward :)

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.