Comments by AZHAR SAYYAD (Top 13 by date)

there is not any issue in this code. i want to send only one time. here in this code because of loop this code hitting the server multiple time. i want to hit only single time and insert the multiple record by passing the multiple record in single method.

thanks this is work fine when i am using with same packagID if the package id is change maens if user has assign another package then the new package id is replace with older one

here in my code i am not able to convert the dt.rows in pdf reader

string value = "P 2016-10-17,P 2016-10-18,P 2016-10-19,P 2016-10-20,P 2016-10-21";
MatchCollection matches = Regex.Matches(value, @"(?<=^|,)(?<prefix>.+?)(?=\s)");
foreach (Match m in matches)
{
Console.WriteLine(m.Value);
}

how to get the index of m.value

Thanks this work for me SELECT c.Name, p.productName FROM Customer c
JOIN (SELECT UserID, MAX(ProductID) as MaxPID FROM Purchases GROUP BY UserID) pu
ON c.UserId = pu.UserID
JOIN Purchases p
ON p.ProductID = pu.MaxPID

the last record is acording to purchase id

actually there is 3 different variable and i want to store this three variable one by one in database i dont want to addition i want insert into this three variable in database