First you should build your area temp string like this:
string area = string.Empty;
foreach (Object item in listBox1.Items)
{
if(area.Length > 0) area += ", ";
area += item.ToString();
}
Then to use the area string to build your query:
query1 = "select customer_id,name,area,mobile_number,package_name,package_type,activation_date,status,monthly_amount,lastpaid_date,lastpaid_amount,nextpay_date,totalamount_paid,totaldue_amount,total_charges from customer where area_code in ("+area+")";