In your VBA example you are using data stored on an excel spreadsheet, for the C# where will this data be stored?
If it is still in an Excel spreadsheet why try to use to C# at all. While C# is a more powerful programming language, VBA has been developed specifically for use with MS Office and personally I believe you are better off leaving the code in VBA.
Michael
zimmer9
ASKER
I don't have a choice. My company is dropping support for MS Access so my apps have to be rewritten in C#.
The syntax for the DFirst function is:
DFirst ( expression, domain, [criteria] )
expression is the field from which you want the first value.
domain is the set of records. This can be a table or a query name.
criteria is optional. It is the WHERE clause to apply to the domain.
In other words, it is a SELECT TOP(1) clause in SQL.
In .NET, you will replace this with SqlCommand.
This is just an example of how you should go with this:
SqlConnection conn = new SqlConnection("ConnectionString");
conn.Open();
for (int intBranch = 1; intBranch < 1000; intBranch++)
{
SqlCommand cmd = new SqlCommand("SELECT TOP(1) [CPS Account Number] FROM
tblFlLNExp WHERE [CPS Account Number] LIKE '%" + intBranch.ToString() + "%'", conn);
}
conn.Close();
Please let me know if anything.
Regards,
Igor
zimmer9
ASKER
How would you make the comparison so that the intBranch value are 3 positions in length with leading zeroes? (for ex: 001, 002 ... 099, ...999)
Because the values in Left([CPS Account Number],3) = 001, 002, 003
I tried the following but it doesn't translate to the first value being 001
sql = "SELECT TOP(1) [CPS Account Number] FROM tblFlLNExp WHERE [CPS Account Number] LIKE '%" + intBranch.ToString("000") + "%'";
zimmer9
ASKER
Would I need to cast it to int and keep the zeros to create a copy of it and then cast it to int, then have 2 versions of it, one as int and one as string?
zimmer9
ASKER
intBranch num = 001; // 3 digit number
string sNum = num.ToString("000");
How would I incorporate the above into my loop if this is what needs to be done?
If it is still in an Excel spreadsheet why try to use to C# at all. While C# is a more powerful programming language, VBA has been developed specifically for use with MS Office and personally I believe you are better off leaving the code in VBA.
Michael