protected void lbSubmit_Click(object sender, EventArgs e) { SendSms sms = new SendSms(); SqlCommand cmd = new SqlCommand(); string mno = ""; foreach (GridViewRow gvrow in gv.Rows) { HiddenField theHiddenField = gvrow.FindControl("HiddenFieldId") as HiddenField; String qid = theHiddenField.Value; var checkbox = gvrow.FindControl("CheckBox1") as CheckBox; if (checkbox.Checked) { //string Name = gv.Rows[gvrow.RowIndex].Cells[3].Text; string MobileNo = gv.Rows[gvrow.RowIndex].Cells[4].Text; mno += "91" + MobileNo; string msg = txtmsg.Text; //qrys = "insert into SmsMaster(Name,MobileNo,Message)values('" + Name + "','" + MobileNo + "','" + txtmsg.Text + "')"; //cmd.Connection = cn; //cmd.CommandText = qrys; //cn.Open(); //cmd.ExecuteNonQuery(); //cn.Close(); sms.sendotp(msg, mno); BindData(); } } Clear(); }