How to get two variable values loop wise in c#?

Dawood Abbas

11y1.1kVisual Basic .NET

I want to insert two variables foreach loop wise into database.how to do it?

foreach (string item in split)

{

val = item;

foreach (string uid in useid)

{

useval = uid;

}

command = new SqlCommand();

command.CommandText = "Insert_SentSMS";

command.CommandType = CommandType.StoredProcedure;

command.Parameters.AddWithValue("@sentTime", sentTime);

command.Parameters.AddWithValue("@mobileNo", val);

command.Parameters.AddWithValue("@userid", useval);

command.Parameters.AddWithValue("@smsType", "Manual");

command.Parameters.AddWithValue("@smsText", smsText);

command.Parameters.AddWithValue("@registrationId", lblCustomSMSRegId.Text);

command.Connection = connection;

command.ExecuteNonQuery();

}

i tried like above but 'useval ' value getting same not other values..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saroj Kumar Sahu11y ago
Hi,

Please try the with the below code,it may help you

for (int i = 0; i < split.Count; i++)
{
val = split[i];
useval = useid[i];
command = new SqlCommand();
command.CommandText = "Insert_SentSMS";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@sentTime", sentTime);
command.Parameters.AddWithValue("@mobileNo", val);
command.Parameters.AddWithValue("@userid", useval);
command.Parameters.AddWithValue("@smsType", "Manual");
command.Parameters.AddWithValue("@smsText", smsText);
command.Parameters.AddWithValue("@registrationId", lblCustomSMSRegId.Text);
command.Connection = connection;
command.ExecuteNonQuery();
}

OR

foreach (var item in split)
{
val = item;
int index = split.IndexOf(item);
useval = useid.ElementAt(index);
command = new SqlCommand();
command.CommandText = "Insert_SentSMS";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@sentTime", sentTime);
command.Parameters.AddWithValue("@mobileNo", val);
command.Parameters.AddWithValue("@userid", useval);
command.Parameters.AddWithValue("@smsType", "Manual");
command.Parameters.AddWithValue("@smsText", smsText);
command.Parameters.AddWithValue("@registrationId", lblCustomSMSRegId.Text);
command.Connection = connection;
command.ExecuteNonQuery();
}
Dawood Abbas11y ago
i wanna like
foreach (string item in split && string uid in useid)
{
command.Parameters.AddWithValue("@mobileNo", val);
command.Parameters.AddWithValue("@userid", useval);
}
Dawood Abbas11y ago
yes iam sending sms to every user so want to insert userid on the basis mobile no so iam getting both lists so wanna insert both into database loop wise.
Khan Abrar Ahmed11y ago
HI do u have any relation in both list. or you want to sent an message to every user???
Saroj Kumar Sahu11y ago
Hi,
Are the Count of both split and useid same and for first item of split will use the first item of useid and so on ?