Binding CheckBoxList to Database and the returning a SQL statement

Question

I am trying to populate a checkboxlist with the names of clients from a database. From that I would like to generate a sql statement that will include those clients in the update query. So what I am looking to do is for an administrator to come in and see a list of the clients that are in the database and then be able to upload a file and select which one of the clients will be able to see the file. I have the authentication working and have a page that will allow the user to upload files but I am still trying to figure this out. So far I was able to bind the checkboxlist to the database and display the values, but being new to C# I am unable to figure out how to generate this sql statement that would include what clients the admin checked. Here is the code as of right now: private void Page_Load(object sender, System.EventArgs e) { CheckBoxList1.DataSource = MyQueryMethod(); CheckBoxList1.DataValueField = "ClientName"; CheckBoxList1.DataTextField ="ClientName"; CheckBoxList1.DataBind(); } System.Data.DataSet MyQueryMethod() { string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\Inetpub\\wwwr" + "oot\\LandFormFileProject\\LoginClients.mdb"; System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString); string queryString = "SELECT [clients].[clientName] FROM [clients]"; System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand(); dbCommand.CommandText = queryString; dbCommand.Connection = dbConnection; System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter(); dataAdapter.SelectCommand = dbCommand; System.Data.DataSet dataSet = new System.Data.DataSet(); dataAdapter.Fill(dataSet); return dataSet; }