case "userSelection":
                sqlAdapter = CreateMyAdapter("dbName", true, sqlconn, null);
                sqlAdapter.SelectCommand.CommandText += "";
                sqlAdapter.Fill(myDS.tableName);
                sqlAdapter.Dispose();

private SqlDataAdapter CreateMyAdapter(string TableName, bool IncludeUpdates, SqlConnection sqlConn, SqlTransaction sqlTran)
{
    SqlDataAdapter sqlAdapter = null;
    SqlConnection sqlConnArchive = new SqlConnection();

    strSQL = "SELECT " + TableName + ".* FROM " + TableName;
    sqlAdapter = new SqlDataAdapter(strSQL, sqlConn);

    // Right here, I create another sqlConnection that is pointed to
    // another datasource.

    sqlConnArchive = getThisOtherConnection();

    SqlCommand sqlComm;

    if (IncludeUpdates)
    {
        string strInsertSQL = "<insertQuery>";

        sqlComm = new SqlCommand(strInsertSQL, sqlConnArchive);
        sqlComm.Parameters.Add("@TableID", SqlDbType.Int, 0, "TableID");
        // More params here...

        sqlAdapter.InsertCommand = sqlComm;

        // Update

        // Delete

    }
 }
        return sqlAdapter;

var rowsAffected = sqlAdapter.InsertCommand.ExecuteNonQuery();

private SqlDataAdapter myTableAdapter;
private DataTable myDataTable;
private void LoadData_Click(object sender, EventArgs e)
{
    //Your connection string
    var connection = @"data source=(localdb)v11.0;initial catalog=TestDB;integrated security=True;";

    //Your select command
    var command = "SELECT Id, Name FROM Category";

    //Create tableAdapter and then use commandBuilder to generate insert, update, delete commands
    myTableAdapter = new SqlDataAdapter(command, connection);
    var commandBuilder = new SqlCommandBuilder(myTableAdapter);

    //Create the dataTable and the load data to dataTable
    myDataTable = new DataTable();
    myTableAdapter.Fill(myDataTable);

    //Bind data to grid
    this.dataGridView1.DataSource = myDataTable;
}

private void SaveData_Click(object sender, EventArgs e)
{
    this.Validate();
    myTableAdapter.Update(myDataTable);
}