Why these code can not send SMS to multiple once ONLY to one

Hi Nilesh

Sorry, but I reload the project. Please have a look. I wish a lot to resolv this problem. 

I downloaded your project and I see no code in form1.cs file.

 

may be you forgot to post all code?

 

looking at your post it seems you are missing a for loop, your logic to send sms should be inside for loop

Hi,

Please anyone can help to this project. I am struggling(...)

Please see what I do try but nothing happen. I put these codes into textChange event to send the message its doesnt do nothing. Why I putted into textChande event? Because I need to use mobile number each time when appear on the label1. Then into which event can I put these codes. Or there is another way to resolv it???: 

 

Hi!

 

My question doesnt receive any response. May be was not clear.

Let me explain it very clear and simplify this.

 

1. On my form I have: combobox1, textbox1, label1 and button1

2. I have a database with two columns (name, mobile). This database have 3 records:

 

anderson 123

samia 1234

robert 12345

 

3. With the following piece of codes its displaying on combobox1 each item (I mean the name(s))

 

private void button1_Click(object sender, EventArgs e)

{

Control p;

p = ((Button)sender).Parent;

p.SelectNextControl(ActiveControl, true, true, true, true);

int i = 1;

if (combobox1.SelectedIndex < combobox1.Items.Count - 1)

{

combobox1.SelectedIndex = combobox1.SelectedIndex + i;

Application.DoEvents();

i++;

int milliseconds = 2000;

Thread.Sleep(milliseconds);

button1.PerformClick();

 

4. In the combobox's event I wrote this line of code to filter the name and display the mobile number on the label1:

private void combobox1_SelectedIndexChanged(object sender, EventArgs e)

{

string connectionString = @"Data Source=desktop-1khdkss\sqlexpress;Initial Catalog=FlexitDB;Integrated Security=True";

SqlConnection sqlCon = new SqlConnection(connectionString);

sqlCon.Open();

string commandString = "select * from company where name ='" + combobox1.Text + "'";

SqlCommand sqlCmd = new SqlCommand(commandString, sqlCon);

SqlDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

label1.Text = read["mobile"].ToString();

}

}

else

{

MessageBox.Show("The name " + combobox1.Text + " doesnt exist");

}

read.Close();

sqlCon.Close();

 

5. Then these codes send SMS and its works perfectly:

try

{

WebClient client = new WebClient();

string to, msg;

to = label1.Text;

msg = textbox1.Text;

string baseurl = "http://api.clickatell.com/http/sendmsg?user=xxx&password=xxxx&api_id=xxxxx&to='" + to + "'&text='" + msg + "'";

client.OpenRead(baseurl);

MessageBox.Show("Message sent!");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

 

6. Now what's my problem??? When I click on my button1 to send message. Its send ONLY the message of the last record of my database (its doesnt send respectly one by one). Then which kind of loop can I do to force it to send message to one by one of each records I have in my database.

The whole of codes is here that should send message of each record:

private void button1_Click(object sender, EventArgs e)

{

Control p;

p = ((Button)sender).Parent;

p.SelectNextControl(ActiveControl, true, true, true, true);

int i = 1;

if (combobox1.SelectedIndex < combobox1.Items.Count - 1)

{

combobox1.SelectedIndex = combobox1.SelectedIndex + i;

Application.DoEvents();

i++;

int milliseconds = 2000;

Thread.Sleep(milliseconds);

button1.PerformClick();

//Probably here where the loop should be executed

try

{

WebClient client = new WebClient();

string to, msg;

to = label1.Text;

msg = textbox1.Text;

string baseurl = "http://api.clickatell.com/http/sendmsg?user=xxx&password=xxxx&api_id=xxxxx&to='" + to + "'&text='" + msg + "'";

client.OpenRead(baseurl);

MessageBox.Show("Message sent!");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

yes, I do send codes.

Just to remind that the SMS sending process run vey well. But the problem is when I want to send one SMS to multiple mobile its cant just because its send always to the last mobile's receiver. Even in the database its can found more mobile's number.

Please any question I ready to explan more because I need to resolv it. 

 

I don't see any for or while loop in your code. if a piece of code you want to repeat multiple times then it should be called from a loop. Or you may not have posted all code.

 

post your complete project as a zip or rar file for better understanding of code.