ASP.NET

Private Sub BindData()
        'hfSearchText has the search string returned from the grid
        If hfSearchText.Value <> "" Then
            EntityDataSource1.Select += " where " & hfSearchText.Value
        End If
        Dim dv As DataView = DirectCast(EntityDataSource1.[Select](New DataSourceSelectArguments()), DataView)
        'hfSort has the sort string returned from the grid
        If hfSort.Value <> "" Then
            dv.Sort = hfSort.Value
        End If

        MySearch.DataSource = dv

        Try
            MySearch.DataBind()
        Catch ex As Exception
            'If databinding threw execept bc current
            'page index is > than available page index
            MySearch.PageIndex = 0
            MySearch.DataBind()
        Finally
            'Select the first row returned
            If MySearch.Rows.Count > 0 Then
                MySearch.SelectedIndex = 0
            End If
        End Try

    End Sub

foreach (DataListItem dli in DataList1.Items)        
{
        CheckBox Chk = (CheckBox)dli.FindControl("CheckBox1");
        if (Chk.Checked)
        {
             SqlConnection SqlCnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
                // SqlDataReader dr;
                SqlCommand SqlCmd = new SqlCommand();
                SqlCmd.Connection = SqlCnn;
                SqlCnn.Open();
                SqlCmd.CommandText = "insert into test(test1) values('"+ck.Text+"')";
                SqlCmd.ExecuteNonQuery();
                SqlCnn.Close();
            break;
        }
        else
        {
            str13 = "you need to check";
        }
}
LblErr.Visible = true;
LblErr.Text = str13;